CLINICAL_EVENT_SEC_LBL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Event Security Label
Definition: Storage for security attributes associated to millennium data entities.
Table Type: ACTIVITY





Column Detail - CLINICAL_EVENT_SEC_LBL


Column Name Type Null? Definition
ACTION_PRSNL_ID DOUBLE Y The ID of the personnel who has taken an action (modified, deleted, etc.) this label.
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.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
CLINICAL_EVENT_SEC_LBL_ID DOUBLE N System generated number used to uniquely identify a row on the CLINICAL_EVENT_SEC_LBL table.
CREATED_BY_PRSNL_ID DOUBLE Y The ID of the personnel who associated this label with the data entity.
END_EFFECTIVE_DT_TM DATETIME Y 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.
EVENT_ID DOUBLE Y Identifies a unique event on the CLINICAL_EVENT table.
SENSITIVITY_REASON_CD DOUBLE Y The code value indicating why the tagged data is considered sesitive.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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 - CLINICAL_EVENT_SEC_LBL


Child Column in CLINICAL_EVENT_SEC_LBL(FK) Parent Table Name Parent Column Name
Parents: CREATED_BY_PRSNL_ID PRSNL PERSON_ID


DIAGNOSIS_SEC_LBL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Diagnosis Security Label
Definition: Storage for security attributes associated to millennium data entities.
Table Type: ACTIVITY





Column Detail - DIAGNOSIS_SEC_LBL


Column Name Type Null? Definition
ACTION_PRSNL_ID DOUBLE Y The ID of the personnel who has taken an action (modified, deleted, etc.) this label.
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.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
CREATED_BY_PRSNL_ID DOUBLE Y The ID of the personnel who associated this label with the data entity.
DIAGNOSIS_GROUP_ID DOUBLE Y The ID of the data entity that this security attribute is associated with.
DIAGNOSIS_SEC_LBL_ID DOUBLE N A system generated number to uniquely identify a row on the Diagnosis Security Label Identifier table.
END_EFFECTIVE_DT_TM DATETIME Y 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.
SENSITIVITY_REASON_CD DOUBLE Y The code value indicating why the tagged data is considered sensitive.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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 - DIAGNOSIS_SEC_LBL


Child Column in DIAGNOSIS_SEC_LBL(FK) Parent Table Name Parent Column Name
Parents: DIAGNOSIS_GROUP_ID DIAGNOSIS DIAGNOSIS_ID
CREATED_BY_PRSNL_ID PRSNL PERSON_ID


ORDER_CONFID_LBL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Confidentiality Label
Definition: Stores confidentiality information for each order.
Table Type: ACTIVITY





Column Detail - ORDER_CONFID_LBL


Column Name Type Null? Definition
ACTION_PRSNL_ID DOUBLE Y The ID of the person who took the last action on this confidentiality label.
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.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
CONFID_LBL_CD DOUBLE Y The code value indicating why the tagged data is considered confidential. Values should be taken from the SENSITIVITY_REASON Code Set (4702082) and ORDERS_SENSITIVITY_REASON (4740922). This column will support other code sets in the future.
CREATED_BY_PRSNL_ID DOUBLE Y The ID of the person who created this confidentiality label.
END_EFFECTIVE_DT_TM DATETIME Y 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.
ORDER_CONFID_LBL_ID DOUBLE N Unique generated number that identifies a single row on the ORDER_CONFID_LBL table.
ORDER_ID DOUBLE Y The ID of the order the confidentiality labels are applied to.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 - ORDER_CONFID_LBL


Child Column in ORDER_CONFID_LBL(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
ACTION_PRSNL_ID PRSNL PERSON_ID
CREATED_BY_PRSNL_ID PRSNL PERSON_ID


PREGNANCY_SEC_LBL



Column Section Relationship Section Top of Page


Table-level Detail

Description: PREGANCY SECURITY LABEL
Definition: Storage for security attributes associated to millennium data entities related to Womens Health
Table Type: ACTIVITY





Column Detail - PREGNANCY_SEC_LBL


Column Name Type Null? Definition
ACTION_PRSNL_ID DOUBLE Y The ID of the personnel who has taken an action (modified, deleted, etc) this label.
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.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
CREATED_BY_PRSNL_ID DOUBLE Y The ID of the personnel who associated this label with the data entity.
END_EFFECTIVE_DT_TM DATETIME Y 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.
PREGNANCY_ID DOUBLE Y The ID of the data entity that this security attribute (PREGNANCY INSTANCE) is associated with.
PREGNANCY_SEC_LBL_ID DOUBLE N PRIMARY KEY
SENSITIVITY_REASON_CD DOUBLE Y The code value indicating why the tagged data is considered sensitive.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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 - PREGNANCY_SEC_LBL


Child Column in PREGNANCY_SEC_LBL(FK) Parent Table Name Parent Column Name
Parents: PREGNANCY_ID PREGNANCY_INSTANCE PREGNANCY_INSTANCE_ID
ACTION_PRSNL_ID PRSNL PERSON_ID
CREATED_BY_PRSNL_ID PRSNL PERSON_ID


PROBLEM_SEC_LBL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Problem Security Label
Definition: Storage for security attributes associated to millennium data entities.
Table Type: ACTIVITY





Column Detail - PROBLEM_SEC_LBL


Column Name Type Null? Definition
ACTION_PRSNL_ID DOUBLE Y The ID of the personnel who has taken an action (modified, deleted, etc) this label.
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.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
CREATED_BY_PRSNL_ID DOUBLE Y The ID of the personnel who associated theis label with the data entity.
END_EFFECTIVE_DT_TM DATETIME Y 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.
PROBLEM_ID DOUBLE Y The ID of the data entity that this security attribute is associated with.
PROBLEM_SEC_LBL_ID DOUBLE N A system generated number to uniquely identify a row on the PROBLEM_SEC_LBL table.
SENSITIVITY_REASON_CD DOUBLE Y The code value indicating why the tagged data is considered sensitive.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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 - PROBLEM_SEC_LBL


Child Column in PROBLEM_SEC_LBL(FK) Parent Table Name Parent Column Name
Parents: PROBLEM_ID PROBLEM PROBLEM_INSTANCE_ID
CREATED_BY_PRSNL_ID PRSNL PERSON_ID