Table Detail Report

UCMR_LAYOUT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager Reference Layout
Definition: Contains layouts for the unified report builder.
Table Type: REFERENCE





Column Detail - UCMR_LAYOUT


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.
ACTIVITY_TYPE_CD DOUBLE N Associates this layout with a specific activity type, which will be used to flex the layout properties and filter the selection of a layout.
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.
LAYOUT_NAME_CD DOUBLE N The code value for the layout name.
LAYOUT_RTF_ID DOUBLE N The long blob reference identifier that stores the layout RTF.
PREV_UCMR_LAYOUT_ID DOUBLE N Used to track versions of the layout information. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
REPORT_TYPE_CD DOUBLE N Defines the type of report this layout will define, which will be used to flex logic.
UCMR_LAYOUT_ID DOUBLE N Uniquely identifies a layout for the unified report builder.
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.
XML_FORMATTING_TEXT_ID DOUBLE N Uniquely identifies a row on the long blob table that contains layout formatting information related to this record.



Relationship Detail - UCMR_LAYOUT


Child Column in UCMR_LAYOUT(FK) Parent Table Name Parent Column Name
Parents: LAYOUT_RTF_ID LONG_BLOB_REFERENCE LONG_BLOB_ID
XML_FORMATTING_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in UCMR_LAYOUT (PK) Child Table Name Child Column Name
Children: UCMR_LAYOUT_ID UCMR_LAYOUT_FIELD UCMR_LAYOUT_ID
UCMR_LAYOUT_ORDERABLE_R UCMR_LAYOUT_ID
UCM_REPORT UCMR_LAYOUT_ID


UCMR_LAYOUT_FIELD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager Reference Layout Field
Definition: Stores a layou field for the unified report builder.
Table Type: REFERENCE





Column Detail - UCMR_LAYOUT_FIELD


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.
ALLOW_CAPTION_IND DOUBLE N Indicates whether to allow captions for Image Type fields.
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.
CERNER_DEFINED_CD DOUBLE N Identifies the source Cerner Defined element of a case field.
COLUMN_CNT DOUBLE N Indicates the number of columns to occupy when inserting images.
DEVICE_ALIAS_NAME VARCHAR(40) Y Stores the field name of an external device's result.
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.
FIELD_DESC_TXT VARCHAR(60) Y Non unique description for this field.
FIELD_HEADER_TXT VARCHAR(40) Y Header that displays with field in layout.
FIELD_NAME VARCHAR(40) Y Name for this field that will be unique within the layout.
FIELD_OPTION_FLAG DOUBLE N Indicates whether to require field, suppress field, or allow missing data value. 0 - Allow Missing Data Value 1 - Required Field 2 - Suppress Field
FIELD_TYPE_FLAG DOUBLE N Flag to identify the type of the field. 0 - Case 1 - Edit 2 - Supplemental
MISSING_DATA_VALUE_TXT VARCHAR(40) Y Displays in a field when no data is present from the source.
OE_FIELD_MEANING_ID DOUBLE N Identifies the source Order Entry Field element of a case field.
PREVIEW_DATA_VALUE_TXT VARCHAR(40) Y Displays in a field at build time.
PREV_UCMR_LAYOUT_FIELD_ID DOUBLE N Used to track versions of the field information. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
REFERENCE_TYPE_CD DOUBLE N If this field is a reference field, this will store the type of data that will be displayed in the reference field.
RELATED_FIELD_ID DOUBLE N Associates one layout field to another layout field.
SOURCE_TYPE_CD DOUBLE N Identifies the source of the data the field displays.
TASK_ASSAY_CD DOUBLE N Identifies the source task assay of a case field.
UCMR_LAYOUT_FIELD_ID DOUBLE N Uniquely identifies a stored layout field for unified report builder.
UCMR_LAYOUT_ID DOUBLE N Identifies the parent layout for this field.
UCMR_WORKSHEET_STATEMENT_R_ID DOUBLE N Identifies the source worksheet statement of a case field.
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_LAYOUT_FIELD


Child Column in UCMR_LAYOUT_FIELD(FK) Parent Table Name Parent Column Name
Parents: UCMR_LAYOUT_ID UCMR_LAYOUT UCMR_LAYOUT_ID
PREV_UCMR_LAYOUT_FIELD_ID UCMR_LAYOUT_FIELD UCMR_LAYOUT_FIELD_ID
RELATED_FIELD_ID UCMR_LAYOUT_FIELD UCMR_LAYOUT_FIELD_ID
UCMR_WORKSHEET_STATEMENT_R_ID UCMR_WORKSHEET_STATEMENT_R UCMR_WORKSHEET_STATEMENT_R_ID




Parent Column in UCMR_LAYOUT_FIELD (PK) Child Table Name Child Column Name
Children: UCMR_LAYOUT_FIELD_ID SIGN_LINE_LAYOUT_FIELD_R UCMR_LAYOUT_FIELD_ID
UCMR_DSR_FIELD_COLUMN UCMR_LAYOUT_FIELD_ID
UCMR_LAYOUT_FIELD PREV_UCMR_LAYOUT_FIELD_ID
UCMR_LAYOUT_FIELD RELATED_FIELD_ID
UCMR_LAYOUT_FIELD_TMPLT_R UCMR_LAYOUT_FIELD_ID
UCM_REPORT_FIELD UCMR_LAYOUT_FIELD_ID


UCMR_LAYOUT_FIELD_TMPLT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager Reference - Layout Field Template Relation
Definition: Stores layout field relation to word processing templates for Unified Report Builder.
Table Type: REFERENCE





Column Detail - UCMR_LAYOUT_FIELD_TMPLT_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.
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.
PREV_UCMR_LAYOUT_FLD_TMPLT_ID DOUBLE N Used to track versions of the layout field to template relation information. This column will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
TEMPLATE_ID DOUBLE N Uniquely identifies the template of this relationship.
UCMR_LAYOUT_FIELD_ID DOUBLE N Uniquely identifies the layout field for this relationship.
UCMR_LAYOUT_FIELD_TMPLT_R_ID DOUBLE N Uniquely identifies a layout field relationship to a word processing template for Unified Report Builder.
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.
VIEW_SEQ DOUBLE N Specifies the order in which the templates should be displayed.



Relationship Detail - UCMR_LAYOUT_FIELD_TMPLT_R


Child Column in UCMR_LAYOUT_FIELD_TMPLT_R(FK) Parent Table Name Parent Column Name
Parents: UCMR_LAYOUT_FIELD_ID UCMR_LAYOUT_FIELD UCMR_LAYOUT_FIELD_ID
TEMPLATE_ID WP_TEMPLATE TEMPLATE_ID


UCMR_LAYOUT_ORDERABLE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager Reference - Layout Orderable Relationship
Definition: Stores layout orderable relationships for unified report builder.
Table Type: REFERENCE





Column Detail - UCMR_LAYOUT_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 Contains the Orderable of this relationship.
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.
PREV_UCMR_LAYOUT_ORDERABLE_ID DOUBLE N Used to track versions of the layout orderable relation information. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
UCMR_LAYOUT_ID DOUBLE N Uniquely identifies the layout for this relationship.
UCMR_LAYOUT_ORDERABLE_R_ID DOUBLE N Uniquely identifies a relationship between a layout 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_LAYOUT_ORDERABLE_R


Child Column in UCMR_LAYOUT_ORDERABLE_R(FK) Parent Table Name Parent Column Name
Parents: UCMR_LAYOUT_ID UCMR_LAYOUT UCMR_LAYOUT_ID


UCMR_POSITION_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager Reference - Position Map
Definition: Stores the position map settings for a protocol worksheet.
Table Type: REFERENCE





Column Detail - UCMR_POSITION_MAP


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.
ALPHA_COL_HEADER_IND DOUBLE N Indicator whether the column headers are labeled using alpha characters. Otherwise, the column headers are labeled using numbers.
ALPHA_ROW_HEADER_IND DOUBLE N Indicator whether the row headers are labeledusing alpha characters. Otherwise, the row headers are labeledusing numbers.
BACK_FRONT_IND DOUBLE N Indicator whether the map is populated back-to-front (top-to-bottom) or front-to-back (bottom-to-top).
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.
CELLS_PER_BATCH_ITEM_CNT DOUBLE N The number of cells that should be populated in the map for each order or container on the batch.
COL_CNT DOUBLE N The number of columns defined to appear for each map.
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.
FILL_BEFORE_START_IND DOUBLE N Indicator whether the position map must be filled out prior to starting the protocol.
LEFT_RIGHT_IND DOUBLE N Indicator whether the map is populated left-to-right or right-to-left.
LONG_TEXT_NOTES_ID DOUBLE N Stores the identifier to the formatted rich text associated with a position map.
MAP_CNT DOUBLE N The number of maps defined to appear.
POSITION_MAP_DISPLAY_NAME VARCHAR(40) N The position map name that is displayed in applications. This value is editable at anytime after creation.
POSITION_MAP_NAME VARCHAR(40) N The name of this position map. Every position map associated with a worksheet must have a unique name. Cannot be changed after it is created.
ROWS_FIRST_IND DOUBLE N Indicator whether the map is first populated by rows or columns.
ROW_CNT DOUBLE N The number of rows defined to appear for each map.
SEQ_NBR_IND DOUBLE N Indicator whether sequential numbering will be used for identifying each cell in a position map. Otherwise, each cell is identified using coordinates.
UCMR_POSITION_MAP_ID DOUBLE N Stores unique position map settings for a protocol worksheet.
UCMR_WORKSHEET_ID DOUBLE N Uniquely identifies the worksheet associated with this position map.
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.
USE_PATTERN_IND DOUBLE N Indicator whether the position map will be filled out according to a pattern or manually.
ZIG_ZAG_IND DOUBLE N Indicator whether the map is populated in a zig zag pattern.



Relationship Detail - UCMR_POSITION_MAP


Child Column in UCMR_POSITION_MAP(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_NOTES_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
UCMR_WORKSHEET_ID UCMR_WORKSHEET UCMR_WORKSHEET_ID




Parent Column in UCMR_POSITION_MAP (PK) Child Table Name Child Column Name
Children: UCMR_POSITION_MAP_ID UCMR_POSITION_MAP_CELL UCMR_POSITION_MAP_ID
UCM_POSITION_MAP_CELL UCMR_POSITION_MAP_ID