Table Detail Report

UCMR_WORKSHEET_ORDERABLE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Management Reference Worksheet Orderable Relation
Definition: This table stores relationships between worksheets and orderables.
Table Type: REFERENCE





Column Detail - UCMR_WORKSHEET_ORDERABLE_R


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CATALOG_CD DOUBLE N This field is used to store the internal code for the order catalog item.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
SPECIMEN_TYPE_CD DOUBLE N Identifies which containers created in the workup should be associated with this order.
SPECIMEN_TYPE_FLAG DOUBLE N Indicates what specimen(s) are associated with the orderable: 0- The specific specimen in the specimen_type_cd field, 1 - All workup containers, or 2 - No specimens.
UCMR_WORKSHEET_ID DOUBLE N This field contains a unique identifier for the associated worksheet.
UCMR_WORKSHEET_ORDERABLE_R_ID DOUBLE N Identifies a unique relationship between a worksheet and an orderable.
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.



Relationship Detail - UCMR_WORKSHEET_ORDERABLE_R


Child Column in UCMR_WORKSHEET_ORDERABLE_R(FK) Parent Table Name Parent Column Name
Parents: UCMR_WORKSHEET_ID UCMR_WORKSHEET UCMR_WORKSHEET_ID


UCMR_WORKSHEET_STATEMENT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Management Reference Worksheet Statement Relation
Definition: This table stores statements associated with a worksheet.
Table Type: REFERENCE





Column Detail - UCMR_WORKSHEET_STATEMENT_R


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
DEFAULT_CD DOUBLE N A default for any coded list accepts. The code set of this default is determined by the code_set attribute.
DEFAULT_NBR DOUBLE N If the accept type is numeric, the default number will be stored here. If the type is checkbox, the value of 1 will be stored for True or 0 for false.
DEFAULT_TXT VARCHAR(250) Y A default for free text accept types. Also can store defaults for date accept types (e.g., current date)
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LABEL_TXT VARCHAR(250) Y Text that appears on the protocol worksheet as the label for an accept prompt.
LAYOUT_AREA_NAME VARCHAR(250) Y Identifies the area of the statement as Input (INPUT), Output(OUTPUT) or Process (any other string). Worksheet Statements in Process area will either have LAYOUT or a unique spread name as a parent.
NOTES_ID DOUBLE N Stores formatted rich text associated with a worksheet statement.
ORDER_LEVEL_IND DOUBLE N Indicates that this is an order level worksheet statement.
REQUIRED_IND DOUBLE N Set to True if the user must enter a value in the statement before the worksheet can be completed.
UCMR_STATEMENT_ID DOUBLE N The unique identifier for the associated statement.
UCMR_WORKSHEET_ID DOUBLE N This field contains the unique identifier for the associated worksheet.
UCMR_WORKSHEET_STATEMENT_R_ID DOUBLE N Identifies a unique relationship between a worksheet and a statement.
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.
WORKSHEET_STMT_NAME VARCHAR(40) N Contains the worksheet statement name.
WORKSHEET_STMT_NAME_KEY VARCHAR(40) Y Contains the worksheet statement name in uppercase with spaces removed.
WORKSHEET_STMT_NAME_KEY_A_NLS VARCHAR(160) Y WORKSHEET_STMT_NAME_KEY_A_NLS column
WORKSHEET_STMT_NAME_KEY_NLS VARCHAR(82) Y Stores the corresponding non-English character set value for the worksheet statement name.
XML_FORMATTING_TEXT_ID DOUBLE N This field stores statement formatting information in an xml blob. This information may include font, bold, calculation formula or any other information pertaining the statement within a worksheet.



Relationship Detail - UCMR_WORKSHEET_STATEMENT_R


Child Column in UCMR_WORKSHEET_STATEMENT_R(FK) Parent Table Name Parent Column Name
Parents: NOTES_ID LONG_BLOB_REFERENCE LONG_BLOB_ID
XML_FORMATTING_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
UCMR_WORKSHEET_ID UCMR_WORKSHEET UCMR_WORKSHEET_ID




Parent Column in UCMR_WORKSHEET_STATEMENT_R (PK) Child Table Name Child Column Name
Children: UCMR_WORKSHEET_STATEMENT_R_ID UCMR_LAYOUT_FIELD UCMR_WORKSHEET_STATEMENT_R_ID
UCMR_WS_STMT_ASSAY_R UCMR_WORKSHEET_STATEMENT_R_ID
UCMR_WS_STMT_VALIDATION UCMR_WORKSHEET_STATEMENT_R_ID
UCM_PTL_RESULT UCMR_WORKSHEET_STATEMENT_ID


UCMR_WORKUP_CRITERIA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Management Reference Workup Criteria
Definition: This table stores criteria for the case workup used to determine which workups need to be performed with specimens on a case
Table Type: REFERENCE





Column Detail - UCMR_WORKUP_CRITERIA


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
BODY_SITE_CD DOUBLE N This field indicates a valid body site for this criteria. A '0' value will indicate (Any) body site.
CATALOG_CD DOUBLE N Indicates a valid catalog item for this criteria.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
SERVICE_RESOURCE_CD DOUBLE N The service resource code value which helps determine the qualifying workup.
SPECIMEN_TYPE_CD DOUBLE N Indicates a valid specimen type for this criteria. Will only be a valid specimen type for the selected catalog item. A '0' value will indicate (Any) specimen type.
UCMR_CASE_WORKUP_ID DOUBLE N This field indicates the case workup this workup criteria is part of.
UCMR_WORKUP_CRITERIA_ID DOUBLE N This field contains the unique identifier for the case workup version.
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.



Relationship Detail - UCMR_WORKUP_CRITERIA


Child Column in UCMR_WORKUP_CRITERIA(FK) Parent Table Name Parent Column Name
Parents: UCMR_CASE_WORKUP_ID UCMR_CASE_WORKUP UCMR_CASE_WORKUP_ID


UCMR_WS_STMT_ASSAY_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager Reference - Worksheet Statement Assay Relation
Definition: Stores worksheet statement to assay mappings.
Table Type: REFERENCE





Column Detail - UCMR_WS_STMT_ASSAY_R


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CASE_STEP_CAT_CD DOUBLE N The case type workup where the mapped relationship exists.
CONVERT_TO_TEXT_IND DOUBLE N The system can auto-convert result when loaded if it doesn't fit an assay's defined parameters.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
TASK_ASSAY_CD DOUBLE N The task assay to which the worksheet statement is mapped.
UCMR_CASE_WORKUP_ID DOUBLE N The case type workup where the mapped relationship exists.
UCMR_WORKSHEET_STATEMENT_R_ID DOUBLE N The specific Worksheet Statement Identifier that is mapped
UCMR_WS_STMT_ASSAY_R_ID DOUBLE N Uniquely identifies a relationship between a worksheet statement and an assay.
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.



Relationship Detail - UCMR_WS_STMT_ASSAY_R


Child Column in UCMR_WS_STMT_ASSAY_R(FK) Parent Table Name Parent Column Name
Parents: UCMR_CASE_WORKUP_ID UCMR_CASE_WORKUP UCMR_CASE_WORKUP_ID
UCMR_WORKSHEET_STATEMENT_R_ID UCMR_WORKSHEET_STATEMENT_R UCMR_WORKSHEET_STATEMENT_R_ID


UCMR_WS_STMT_VALIDATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Management Reference - Statement Validation
Definition: Stores relationships between whorksheet statements and validation information. Includes numeric range validation.
Table Type: REFERENCE





Column Detail - UCMR_WS_STMT_VALIDATION


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
UCMR_WORKSHEET_STATEMENT_R_ID DOUBLE N Uniquely identifies the associated worksheet statement to be validated.
UCMR_WS_STMT_VALIDATION_ID DOUBLE N Uniquely identifies a validation entry for a given worksheet statement 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.
VALIDATION_CD DOUBLE N A code value from any code set that is checked at activity time to determine if a valid selection from a code list was made.
VALIDATION_NBR DOUBLE N The number used for comparison with the statement accept value on the activity side to determine if the input is valid.
VALIDATION_TEXT VARCHAR(250) Y Stores textual validation information for a worksheet statement (e.g., ensuring current date entered).
VALIDATION_TYPE_CD DOUBLE N Used to store the internal code for the type of validation (e.g., minimum, maximum, etc.)



Relationship Detail - UCMR_WS_STMT_VALIDATION


Child Column in UCMR_WS_STMT_VALIDATION(FK) Parent Table Name Parent Column Name
Parents: UCMR_WORKSHEET_STATEMENT_R_ID UCMR_WORKSHEET_STATEMENT_R UCMR_WORKSHEET_STATEMENT_R_ID