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 |