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 |