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.