Table Detail Report

BR_RLI_CLIENT_ORDERS



Column Section Top of Page


Table-level Detail

Description: BEDROCK RLI CLIENT ORDERS
Definition: Reference Lab order client order bid sheet
Table Type: REFERENCE





Column Detail - BR_RLI_CLIENT_ORDERS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ALIAS VARCHAR(100) N Order catalog alias value for the RLI order
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
CATALOG_CD DOUBLE N The unique identifier for the RLI order catalog item
STATUS_FLAG DOUBLE Y Defines the processing status of the client RLI order
SUPPLIER_FLAG DOUBLE N unique identifier for an RLI supplier
SUPPLIER_MEANING VARCHAR(100) Y String value uniquely identifying the RLI supplier
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_RLI_CONTAINER_RELTN



Column Section Top of Page


Table-level Detail

Description: BEDROCK RLI CONTAINER RELATIONSHIP
Definition: Reference Lab order-container relation
Table Type: REFERENCE





Column Detail - BR_RLI_CONTAINER_RELTN


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
OPERAND VARCHAR(100) Y Value ""OR"" or ""AND"" defines the relationship between multiple containers for an RLI order
RLI_ORDER_ID DOUBLE N Unique identifier for an RLI order catalog item
SUPPLIER_FLAG DOUBLE N Unique identifier for an RLI supplier
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_RLI_ORC_SUMMARY



Column Section Top of Page


Table-level Detail

Description: BEDROCK RLI ORC SUMMARY
Definition: Reference Lab order change log
Table Type: REFERENCE





Column Detail - BR_RLI_ORC_SUMMARY


Column Name Type Null? Definition
ACCN_CLASS VARCHAR(100) Y The alias value for an accession class, used for modification tracking
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
COLL_CLASS VARCHAR(100) Y The alias value for a collection class, used for modification tracking
COLL_METHOD VARCHAR(100) Y The alias value for a collection method, used for modification tracking
CONTAINER1 VARCHAR(100) Y The alias value for a specimen container, used for modification tracking
CONTAINER2 VARCHAR(100) Y The alias value for a specimen container, used for modification tracking
CONTAINER3 VARCHAR(100) Y The alias value for a specimen container, used for modification tracking
CONTAINER4 VARCHAR(100) Y The alias value for a specimen container, used for modification tracking
CONTAINER5 VARCHAR(100) Y The alias value for a specimen container, used for modification tracking
MIN_VOL VARCHAR(100) Y The alias value for a minimum volume, used for modification tracking
RLI_ORDER_ID DOUBLE N Unique identifier for an RLI order catalog item
SEQUENCE DOUBLE N Sequence
SPECIAL_HANDLING VARCHAR(100) Y The alias value for a special handling code, used for modification tracking
SPEC_TYPE VARCHAR(100) Y The alias value for a specimen type, used for modification tracking
SUPPLIER_FLAG DOUBLE N Unique identifier for an RLI supplier
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_RLI_SUPPLIER



Column Section Top of Page


Table-level Detail

Description: BEDROCK RLI SUPPLIER
Definition: reference lab supplier data
Table Type: REFERENCE





Column Detail - BR_RLI_SUPPLIER


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
CONTENT_LOADED_IND DOUBLE Y Defines whether the RLI supplier's autobuild content has been loaded
DEFAULT_SELECTED_IND DOUBLE Y Defines whether the RLI supplier is used for a specified client
START_VERSION_NBR DOUBLE N Identifies which version of start has been loaded
SUPPLIER_FLAG DOUBLE N Unique identifier for an RLI supplier
SUPPLIER_MEANING VARCHAR(100) Y String value uniquely identifying the RLI supplier
SUPPLIER_NAME VARCHAR(100) Y Describes the name of the RLI supplier
SUPPLIER_PREFIX VARCHAR(100) Y A value concatenated to the order mnemonics to identify the orders as being from the RLI supplier
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_SCHED_APPT_TYPE



Column Section Top of Page


Table-level Detail

Description: Bedrock Scheduling Appointment Type
Definition: Stores proposed scheduling appointment types.
Table Type: REFERENCE





Column Detail - BR_SCHED_APPT_TYPE


Column Name Type Null? Definition
APPT_TYPE_DISPLAY VARCHAR(40) N Name of the appointment type
APPT_TYPE_ID DOUBLE N identifier of the appointment type
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
CATALOG_TYPE_CD DOUBLE N Catalog type of the default orders the department type can be scheduled for
DEPT_TYPE_ID DOUBLE N ID of the department type
MATCH_APPT_TYPE_CD DOUBLE N Code value from 14230 if the proposed appointment type is created
ORDERS_BASED_IND DOUBLE Y Indicates if the appointment type will have orders attached to it
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.