ACTIVITY_PRIVILEGE_DEFINITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Activity_Privilege_ Definition
Definition: This table is used to define activities.
Table Type: REFERENCE





Column Detail - ACTIVITY_PRIVILEGE_DEFINITION


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.
ACTIVITY_IDENTIFIER VARCHAR(25) N Identifier for the activity that is getting defined.
ACTIVITY_NAME VARCHAR(255) N Name descriptor for the activity. Identifies the name of the Activity.
ACTIVITY_PRIVILEGE_DEF_ID DOUBLE N Primary key for the activity_privilege_ definition. The unique identifier of a row on this table
ACTIVITY_TYPE_FLAG DOUBLE N Type of the Activity. Indicates the type of activity, such as 1 for UK. This is used to classify the activity. 1 - Activity type is "UK" (Currently there is only one valid value)
PRIVILEGE_CD DOUBLE N Privilege_cd that is be to associated with the Activity
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 - ACTIVITY_PRIVILEGE_DEFINITION




Parent Column in ACTIVITY_PRIVILEGE_DEFINITION (PK) Child Table Name Child Column Name
Children: ACTIVITY_PRIVILEGE_DEF_ID ACTIVITY_PRIVILEGE_RELTN ACTIVITY_PRIVILEGE_DEF_ID
PRIVILEGE_DELETION ACTIVITY_PRIVILEGE_DEF_ID


DOC_SET_ELEMENT_REF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Documentation Set Element Reference
Definition: Defines a discrete input element that is used for entering data within a documentation set section.
Table Type: REFERENCE





Column Detail - DOC_SET_ELEMENT_REF


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.
ALLOW_COMMENT_IND DOUBLE N Determines if comments may be written against the documentation set section.
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.
DOC_SET_ELEMENT_DESCRIPTION VARCHAR(250) Y A description of a documentation set element.
DOC_SET_ELEMENT_ID DOUBLE N Identifies a documentation set element
DOC_SET_ELEMENT_NAME VARCHAR(40) N The name of a documentation set element.
DOC_SET_ELEM_SEQUENCE DOUBLE N Identifies the ordering of this element relative to other elements contained within a section.
DOC_SET_SECTION_REF_ID DOUBLE N Identifies a specific version of a documentation set section related to the SECTION_REF_ID.
ELEMENT_TYPE_CD DOUBLE N Classifies this element by its functionality. Examples include 'NUMERIC' and 'CALCULATION'.
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.
EVENT_CD DOUBLE N Type of Section as defined in the event code model.
PREV_DOC_SET_ELEMENT_ID DOUBLE N Previous doc_set_element_id - used for type 2 versoning
READ_ONLY_IND DOUBLE N Specifies if data related to this element may be saved.
REQUIRED_IND DOUBLE N Indicates if this element is required to be populated to ensure the section it is a part of.
TASK_ASSAY_CD DOUBLE N Defines information that further defines this element.
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 - DOC_SET_ELEMENT_REF


Child Column in DOC_SET_ELEMENT_REF(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
PREV_DOC_SET_ELEMENT_ID DOC_SET_ELEMENT_REF DOC_SET_ELEMENT_ID
DOC_SET_SECTION_REF_ID DOC_SET_SECTION_REF DOC_SET_SECTION_REF_ID




Parent Column in DOC_SET_ELEMENT_REF (PK) Child Table Name Child Column Name
Children: DOC_SET_ELEMENT_ID CNT_DS_SEC_ELEMENT_KEY DS_ELEMENT_REF_ID
DOC_SET_ELEMENT_REF PREV_DOC_SET_ELEMENT_ID
ONC_DOCSET_ELEM_DECORATOR DOC_SET_ELEMENT_ID
ONC_TASK_SENT_RELTN DOC_SET_ELEMENT_ID
ONC_TOKEN_ELEMENT_R DOC_SET_ELEMENT_ID


DOC_SET_REF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Documentation Set Reference
Definition: Defines the container used to store a documentation set.
Table Type: REFERENCE





Column Detail - DOC_SET_REF


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.
ALLOW_COMMENT_IND DOUBLE N Determines if comments may be written against the documentation set.
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.
DOC_SET_DESCRIPTION VARCHAR(250) Y A description of a documentation set.
DOC_SET_NAME VARCHAR(40) N The name of a documentation set.
DOC_SET_NAME_KEY VARCHAR(40) N The name value of DOC_SET_NAME in all CAPS with no spaces.
DOC_SET_REF_ID DOUBLE N Identifies a specific version of a documentation set related to the SET_REF_ID.
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.
EVENT_CD DOUBLE N Type of Doc Set as defined in the event code model.
EVENT_SET_NAME VARCHAR(100) N Name of the Event Set that is associated with the Doc Set.
LAST_MODIFIED_DT_TM DATETIME Y The date and time this doc set was last modified
PREV_DOC_SET_REF_ID DOUBLE N Previous DOC_SET_REF_ID - used for type 2 versioning
SET_REF_ID DOUBLE N Identifies a specific documentation set for all versions of the set hierarchy.
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 - DOC_SET_REF


Child Column in DOC_SET_REF(FK) Parent Table Name Parent Column Name
Parents: PREV_DOC_SET_REF_ID DOC_SET_REF DOC_SET_REF_ID




Parent Column in DOC_SET_REF (PK) Child Table Name Child Column Name
Children: DOC_SET_REF_ID CNT_DS_KEY DOC_SET_REF_ID
DOC_SET_REF PREV_DOC_SET_REF_ID
DOC_SET_SECTION_REF_R DOC_SET_REF_ID
DYNAMIC_LABEL_TEMPLATE DOC_SET_REF_ID
ONC_DOCSETREF_CAT_R DOC_SET_REF_ID
ONC_FORM_ACTIVITY DOC_SET_REF_ID
ONC_NOMEN_DOCSETREF_R DOC_SET_REF_ID
ONC_TOKEN_ELEMENT_R DOC_SET_REF_ID
ONC_WORKSHEET DOC_SET_REF_ID


DOC_SET_SECTION_REF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Documentation Set Section Reference
Definition: Defines documentation set section.
Table Type: REFERENCE





Column Detail - DOC_SET_SECTION_REF


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.
ALLOW_COMMENT_IND DOUBLE N Determines if comments may be written against the documentation set section.
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.
DOC_SET_SECTION_DESCRIPTION VARCHAR(250) Y A description of a documentation set section.
DOC_SET_SECTION_INSTRUCTION VARCHAR(2000) Y This is instructional content used to assist with entering data related to the elements contained within the section.
DOC_SET_SECTION_NAME VARCHAR(40) N The name of the event set
DOC_SET_SECTION_NAME_KEY VARCHAR(40) N The name value of DOC_SET_SECTION_NAME in all CAPS with no spaces.
DOC_SET_SECTION_REF_ID DOUBLE N Identifies a specific version of a documentation set section related to the SECTION_REF_ID
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.
EVENT_CD DOUBLE N Type of doc set section as defined in event code model
EVENT_SET_NAME VARCHAR(100) N The Event Set Name
PREV_DOC_SET_SECTION_REF_ID DOUBLE N Previous DOC_SET_SCTION_REF ID. Used for type 2 versioning
SECTION_REF_ID DOUBLE N Identifies a documentation set section across all versions of the section.
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 - DOC_SET_SECTION_REF


Child Column in DOC_SET_SECTION_REF(FK) Parent Table Name Parent Column Name
Parents: PREV_DOC_SET_SECTION_REF_ID DOC_SET_SECTION_REF DOC_SET_SECTION_REF_ID




Parent Column in DOC_SET_SECTION_REF (PK) Child Table Name Child Column Name
Children: DOC_SET_SECTION_REF_ID CNT_DS_SECTION_KEY DOC_SET_SECTION_REF_ID
DOC_SET_ELEMENT_REF DOC_SET_SECTION_REF_ID
DOC_SET_SECTION_REF PREV_DOC_SET_SECTION_REF_ID
DOC_SET_SECTION_REF_R DOC_SET_SECTION_REF_ID
ONC_TASK_SENT_RELTN DOC_SET_SECTION_ID


DOC_SET_SECTION_REF_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: DOC SET SECTION REF RELATION
Definition: Identifies the relationship between doc_set_ref and doc_section_ref. This table will replace table DOC_SET_SECTION_RELTN with introductin of new code. This table supports type 2 versioning.
Table Type: REFERENCE





Column Detail - DOC_SET_SECTION_REF_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.
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.
DOC_SET_REF_ID DOUBLE N FK from table DOC_SET_REF
DOC_SET_SECTION_REF_ID DOUBLE N FK FROM DOC_SET_SECTION_REF
DOC_SET_SECTION_REF_R_ID DOUBLE N PRIMARY KEY
DOC_SET_SECTION_SEQUENCE DOUBLE N SEQUENCE
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_DOC_SET_SECTION_REF_R_ID DOUBLE N PREVIOUS ID - SUPPORTS TYPE 2 VERSIONING
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 - DOC_SET_SECTION_REF_R


Child Column in DOC_SET_SECTION_REF_R(FK) Parent Table Name Parent Column Name
Parents: DOC_SET_REF_ID DOC_SET_REF DOC_SET_REF_ID
DOC_SET_SECTION_REF_ID DOC_SET_SECTION_REF DOC_SET_SECTION_REF_ID
PREV_DOC_SET_SECTION_REF_R_ID DOC_SET_SECTION_REF_R DOC_SET_SECTION_REF_R_ID




Parent Column in DOC_SET_SECTION_REF_R (PK) Child Table Name Child Column Name
Children: DOC_SET_SECTION_REF_R_ID DOC_SET_SECTION_REF_R PREV_DOC_SET_SECTION_REF_R_ID