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. |