Table Detail Report
BR_CLIENT_PRSNL_RELTN
Column Section | Top of Page |
Table-level Detail
Description: | BEDROCK CLIENT PERSONNEL RELATIONSHIP |
Definition: | user's for each client |
Table Type: | REFERENCE |
Column Detail - BR_CLIENT_PRSNL_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BR_CLIENT_ID | DOUBLE | N | Identifies which bedrock client data belongs to |
BR_PRSNL_ID | DOUBLE | N | identifier of the user from br_prsnl table |
STATUS_IND | DOUBLE | N | Status indicator of the relationship |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
BR_CLIENT_SOL_STEP
Column Section | Top of Page |
Table-level Detail
Description: | BEDROCK CLIENT SOL STEP |
Definition: | sequence of steps within solution |
Table Type: | REFERENCE |
Column Detail - BR_CLIENT_SOL_STEP
Column Name | Type | Null? | Definition |
---|---|---|---|
BR_CLIENT_ID | DOUBLE | N | Identifies which bedrock client data belongs to |
SEQUENCE | DOUBLE | N | Sequence |
SOLUTION_MEAN | VARCHAR(100) | N | Short name for solution |
STEP_MEAN | VARCHAR(100) | N | short name for step |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | date/time on which the record was added to the file |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
BR_CLIENT_STEP_DEP
Column Section | Top of Page |
Table-level Detail
Description: | BEDROCK CLIENT STEP DEP |
Definition: | dependent step information |
Table Type: | REFERENCE |
Column Detail - BR_CLIENT_STEP_DEP
Column Name | Type | Null? | Definition |
---|---|---|---|
BR_CLIENT_ID | DOUBLE | N | Identifies which bedrock client data belongs to |
DEP_STEP_DONE_IND | DOUBLE | N | indicates if dependent step is complete or not (not used yet) |
DEP_STEP_MEAN | VARCHAR(100) | N | short name for dependent step |
STEP_MEAN | VARCHAR(100) | N | short name for step |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | date/time on which the record was added to the file |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
BR_COLL_CLASS
Column Section | Top of Page |
Table-level Detail
Description: | BEDROCK COLLECTION CLASS |
Definition: | Bedrock data for collection classes |
Table Type: | REFERENCE |
Column Detail - BR_COLL_CLASS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVITY_TYPE | VARCHAR(12) | N | Activity type with which this collection class is associated, i.e. GLB |
BR_CLIENT_ID | DOUBLE | N | Client identifier |
CODE_VALUE | DOUBLE | N | Actual code_value of the collection class on code set 231 |
COLLECTION_CLASS | VARCHAR(20) | N | Standard name of the collection class, i.e. Chemistry |
DEFAULT_SELECTED_IND | DOUBLE | Y | indicates that the defaults were selected |
DISPLAY_NAME | VARCHAR(10) | Y | Actual value of the display name on code set 231 |
FACILITY_ID | DOUBLE | N | ID for facility for which this collection class has been created |
PROPOSED_NAME_SUFFIX | VARCHAR(6) | Y | Short name to be concatenated to the facility prefix, i.e. CHEM |
START_VERSION_NBR | DOUBLE | N | Identifies which version of start has been loaded |
STORAGE_TRACKING_IND | DOUBLE | N | Set to 1 to indicate that storage tracking is on, 0 for off |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
BR_COLL_CLASS_INSTR_RELTN
Column Section | Top of Page |
Table-level Detail
Description: | Bedrock Collection Class Instrument Relation |
Definition: | stores the relationship between collection classes and instruments/benches |
Table Type: | REFERENCE |
Column Detail - BR_COLL_CLASS_INSTR_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
COLLECTION_CLASS_CD | DOUBLE | N | stores the collection class for the collection class/instrument relationship |
SERVICE_RESOURCE_CD | DOUBLE | N | stores the instrument for the collection class/instrument relationship |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |