CKI_ENTITY_RELTN



Column Section Top of Page


Table-level Detail

Description: Relate a CKI to a DB entity
Definition: Provide a generic mechanism for specifying a CKI for some other DB entity.
Table Type: ACTIVITY





Column Detail - CKI_ENTITY_RELTN


Column Name Type Null? Definition
CKI VARCHAR(255) N A unique external identifier for CKI
CKI_ENTITY_RELTN_ID DOUBLE N Entity ID of parent table to which this row is related as a child.
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the CKI_ENTITY_RELTN row is related
PARENT_ENTITY_NAME VARCHAR(30) N The upper case name of the table to which this address row is related (i.e., PERSON, PRSNL, ORGANIZATION, etc.)
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.


DCP_ACTIVITY_LOG



Column Section Top of Page


Table-level Detail

Description: DCP ACTIVITY LOG
Definition: Holds activity log entries to support the Patient Access Panel.
Table Type: ACTIVITY





Column Detail - DCP_ACTIVITY_LOG


Column Name Type Null? Definition
ACTIVITY_DT_TM DATETIME N The date w of the event being logged.
ACTIVITY_LOG_ID DOUBLE N Unique identifier for the log entry.
ACTIVITY_TYPE_CD DOUBLE N The type of event for the entry.
PARENT_ENTITY_DT_TM DATETIME N date time the parent entity was changed
PARENT_ENTITY_ID DOUBLE N The parent entity id of the entry.
PARENT_ENTITY_NAME VARCHAR(100) Y The name of the parent entry referred to by this entry.
PRSNL_ID DOUBLE N The id of the user that logged the entry.
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.


DCP_FORMS_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Forms Activity Record
Definition: Maintains record of all charting transactions performed via PowerForms
Table Type: ACTIVITY





Column Detail - DCP_FORMS_ACTIVITY


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_ACTIVITY_DT_TM DATETIME Y Date & Time form was first charted
DCP_FORMS_ACTIVITY_ID DOUBLE N Unique identifier for assessment
DCP_FORMS_REF_ID DOUBLE N Identifies form definition for activity
DESCRIPTION VARCHAR(255) Y This field is the display that will show up in the FormBrowser.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
FLAGS DOUBLE Y //Completion Status 0 - Unknown 1 - Incomplete 2 - Complete
FORM_DT_TM DATETIME Y Date/Time that assessment was done
FORM_STATUS_CD DOUBLE N Status of the results on the form
FORM_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
LAST_ACTIVITY_DT_TM DATETIME Y Last Date/Time form was modified
LOCK_CREATE_DT_TM DATETIME Y The time this row was locked for use.
LOCK_PRSNL_ID DOUBLE N The personnel who is currently in control of this row.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
TASK_ID DOUBLE N Activity Task Id
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.
VERSION_DT_TM DATETIME Y Date & time of the form definition that was documented. Used to retrieve the correct version of the form that was used to document the results.



Relationship Detail - DCP_FORMS_ACTIVITY


Child Column in DCP_FORMS_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
TASK_ID TASK_ACTIVITY TASK_ID




Parent Column in DCP_FORMS_ACTIVITY (PK) Child Table Name Child Column Name
Children: DCP_FORMS_ACTIVITY_ID CV_CASE FORM_ID
DCP_FORMS_ACTIVITY_COMP DCP_FORMS_ACTIVITY_ID
DCP_FORMS_ACTIVITY_PRSNL DCP_FORMS_ACTIVITY_ID


DCP_FORMS_ACTIVITY_COMP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Components of Forms Activity
Definition: List all of the components for a given activity form
Table Type: ACTIVITY





Column Detail - DCP_FORMS_ACTIVITY_COMP


Column Name Type Null? Definition
COMPONENT_CD DOUBLE N Type of component
DCP_FORMS_ACTIVITY_COMP_ID DOUBLE N Unique, generated key for DCP_FORMS_ACTIVITY_COMP.
DCP_FORMS_ACTIVITY_ID DOUBLE N Activity form component is part of
DESCRIPTION VARCHAR(100) Y textual description
PARENT_ENTITY_ID DOUBLE N Id of parent entity. This corresponds to the component_cd
PARENT_ENTITY_NAME VARCHAR(32) Y Name of parent entity
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 - DCP_FORMS_ACTIVITY_COMP


Child Column in DCP_FORMS_ACTIVITY_COMP(FK) Parent Table Name Parent Column Name
Parents: DCP_FORMS_ACTIVITY_ID DCP_FORMS_ACTIVITY DCP_FORMS_ACTIVITY_ID


DCP_FORMS_ACTIVITY_PRSNL



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP FORMS ACTIVITY PRSNL
Definition: List all prsnl that have contributed to a form
Table Type: ACTIVITY





Column Detail - DCP_FORMS_ACTIVITY_PRSNL


Column Name Type Null? Definition
ACTIVITY_DT_TM DATETIME N Date/Time person contributed.
ACTIVITY_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
DCP_FORMS_ACTIVITY_ID DOUBLE N Activity form that the person contributed to.
DCP_FORMS_ACTIVITY_PRSNL_ID DOUBLE N unique identifier
PROXY_ID DOUBLE N Id of proxy prsnl when necessary
PRSNL_FT VARCHAR(100) Y Free Text name of prsnl.
PRSNL_ID DOUBLE N ID of prsnl
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 - DCP_FORMS_ACTIVITY_PRSNL


Child Column in DCP_FORMS_ACTIVITY_PRSNL(FK) Parent Table Name Parent Column Name
Parents: DCP_FORMS_ACTIVITY_ID DCP_FORMS_ACTIVITY DCP_FORMS_ACTIVITY_ID
PROXY_ID PRSNL PERSON_ID
PRSNL_ID PRSNL PERSON_ID