SIGN_LINE_LAYOUT_FIELD_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Signature Line Layout Field Relation
Definition: This table contains the relationships between the layout field used in Layout Builder with the signature line format.
Table Type: REFERENCE





Column Detail - SIGN_LINE_LAYOUT_FIELD_R


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.
FORMAT_ID DOUBLE N This column contains the internal identification code representing the signature line format. This value is used to join to the signature line format information stored on the SIGN_LINE_FORMAT table.
SIGN_LINE_LAYOUT_FIELD_R_ID DOUBLE N Uniquely identifies a relationship between a signature line and a layout field.
STATUS_FLAG DOUBLE Y This column contains a flag value representing the result status for which the signature line format is associated. Currently signature lines can be associated with : 1 - Performed2 - Verified and Corrected
UCMR_LAYOUT_FIELD_ID DOUBLE N Uniquely identifies the related stored layout field for Layout 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.



Relationship Detail - SIGN_LINE_LAYOUT_FIELD_R


Child Column in SIGN_LINE_LAYOUT_FIELD_R(FK) Parent Table Name Parent Column Name
Parents: FORMAT_ID SIGN_LINE_FORMAT FORMAT_ID
UCMR_LAYOUT_FIELD_ID UCMR_LAYOUT_FIELD UCMR_LAYOUT_FIELD_ID


UCMR_CASE_CHARGE_ORDRBL_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager Reference - Case Charge Orderable Relationship
Definition: Stores the relationship between charge orderables and Helix case types. The relationship between the two is many to many.
Table Type: REFERENCE





Column Detail - UCMR_CASE_CHARGE_ORDRBL_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.
UCMR_CASE_CHARGE_ORDRBL_R_ID DOUBLE N Uniquely identifies a relationship between a charge orderable and a helix case type.
UCMR_CASE_TYPE_ID DOUBLE N Uniquely identifies the case type related to this relationship.
UCMR_CHARGE_ORDERABLE_ID DOUBLE N Uniquely identifies the charge orderable associated to this relationship.
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.



Relationship Detail - UCMR_CASE_CHARGE_ORDRBL_R


Child Column in UCMR_CASE_CHARGE_ORDRBL_R(FK) Parent Table Name Parent Column Name
Parents: UCMR_CASE_TYPE_ID UCMR_CASE_TYPE UCMR_CASE_TYPE_ID
UCMR_CHARGE_ORDERABLE_ID UCMR_CHARGE_ORDERABLE UCMR_CHARGE_ORDERABLE_ID


UCMR_CASE_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manger Reference - Case Group
Definition: Contains case group type data.
Table Type: REFERENCE





Column Detail - UCMR_CASE_GROUP


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_GROUP_DESCRIPTION VARCHAR(100) N Contains the description of the case group type.
CASE_GROUP_NAME_CD DOUBLE N Contains the code value of the Case Group Name
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.
LOOKBACK_MINUTES_MAX_NBR DOUBLE N Contains the maximum number of minutes to look back for cases to qualify.
LOOKBACK_MINUTES_MIN_NBR DOUBLE N Contains the minimum number of minutes to look back for cases to qualify.
MAX_DATE_TYPE_FLAG DOUBLE N The preferred date type display of maximum lookback minutes. For example: days, weeks, months, and years.1 - Days2 - Weeks3 - Months4 - Years
MIN_DATE_TYPE_FLAG DOUBLE N The preferred date type display of minimum lookback minutes. For example: days, weeks, months, and years.1 - Days2 - Weeks3 - Months4 - Years
PREV_UCMR_CASE_GROUP_ID DOUBLE N Used to track versions of the case group 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.
PROMPT_REPEAT_ORDERS_IND DOUBLE N Prompt to add repeat orders to the worklist when True. Otherwise automatically add repeat orders.
UCMR_CASE_GROUP_ID DOUBLE N Uniquely identifies a case group.
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.



Relationship Detail - UCMR_CASE_GROUP




Parent Column in UCMR_CASE_GROUP (PK) Child Table Name Child Column Name
Children: UCMR_CASE_GROUP_ID UCMR_CASE_GRP_STEP_R UCMR_CASE_GROUP_ID
UCMR_CASE_TYP_GRP_R UCMR_CASE_GROUP_ID
UCM_CASE_GROUP_PREQUAL UCMR_CASE_GROUP_ID


UCMR_CASE_GRP_STEP_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager Reference - Case Group Step Relation
Definition: Contains the case group step relationship information.
Table Type: REFERENCE





Column Detail - UCMR_CASE_GRP_STEP_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_CASE_GRP_STEP_R_ID DOUBLE N Used to track versions of the case group information. This field will always point back to the initial value created. This may be used to find the correct version when combined with the begin and end effective dates and times.
REPEAT_CAT_CD DOUBLE N Orderable to be repeated.
UCMR_CASE_GROUP_ID DOUBLE N Uniquely identifies the case group related to this record.
UCMR_CASE_GRP_STEP_R_ID DOUBLE N Uniquely identifies a case group step relationship.
UCMR_CASE_STEP_ID DOUBLE N Uniquely identifies the case step related to this record.
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_CASE_GRP_STEP_R


Child Column in UCMR_CASE_GRP_STEP_R(FK) Parent Table Name Parent Column Name
Parents: UCMR_CASE_GROUP_ID UCMR_CASE_GROUP UCMR_CASE_GROUP_ID
UCMR_CASE_STEP_ID UCMR_CASE_STEP UCMR_CASE_STEP_ID


UCMR_CASE_INTEGRATION_R



Column Section Top of Page


Table-level Detail

Description: Unified Case Management Reference Case Integration
Definition: Stores the relationship between an order catalog item and its associated patterns for case integration orderables.
Table Type: REFERENCE





Column Detail - UCMR_CASE_INTEGRATION_R


Column Name Type Null? Definition
CATALOG_CD DOUBLE N An internal code for the case Integration orderable.
CKI_IDENTIFIER VARCHAR(50) N Indicates the CKI Identifier of the pattern selected to be associated with the given case integration orderable. This identifier originates in the SCR Pattern table.
CKI_SOURCE CHAR(12) N This column indicates the CKI Source of the pattern selected to be associated with the given case integration orderable. This identifier originates in the SCR Pattern table.
UCMR_CASE_INTEGRATION_ID DOUBLE N Unique identifier for the orderable to pattern relationship for case integration orderables.
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.