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