Table Detail Report

CDI_FORM



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Form
Definition: A row in this table represents a CPDI interactive form and contains configuration information about the form.
Table Type: REFERENCE





Column Detail - CDI_FORM


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.
AUTO_PRINT_IND DOUBLE N Indicates that this form should be auto-printed upon completion.
CDI_DOCUMENT_SUBTYPE_ID DOUBLE N Foreign key to cdi_document_subtype table. Optionally identifies a document subtype.
CDI_FORM_ID DOUBLE N The unique primary key of this table. It is an internally generated number.
EVENT_CD DOUBLE N Event code that corresponds to the CPDI document type. Can be multiple code sets; associated code set is stored in column event_code_set.
EVENT_CODE_SET DOUBLE N Specifies the code set for the event_cd field.
FORM_DESCRIPTION VARCHAR(500) Y Patient-friendly description of the form.
FORM_NAME VARCHAR(255) N Displays the name of the CDI Form.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MEDIA_OBJECT_IDENT VARCHAR(64) Y Foreign key to dms_media_identifier, if form is stored in media object management.
PAGE_CNT DOUBLE N Number of pages in this form if this form is static; 0 if unknown or if the form is dynamic.
PROCEDURAL_FORM_IND DOUBLE N Indicates whether the form is a non-registration form. 0 - No, 1 - Yes
SIGNATURE_PAGE_IND DOUBLE N indicates whether or not this document is being used as a signature page.
SOURCE_FORM_IDENT VARCHAR(255) N Unique form identifier in source system.
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 - CDI_FORM


Child Column in CDI_FORM(FK) Parent Table Name Parent Column Name
Parents: CDI_DOCUMENT_SUBTYPE_ID CDI_DOCUMENT_SUBTYPE CDI_DOCUMENT_SUBTYPE_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in CDI_FORM (PK) Child Table Name Child Column Name
Children: CDI_FORM_ID CDI_FORM_ACTIVITY CDI_FORM_ID
CDI_FORM_FACILITY_RELTN CDI_FORM_ID
CDI_FORM_FIELD CDI_FORM_ID
CDI_FORM_RULE CDI_FORM_ID
CDI_PENDING_DOCUMENT CDI_FORM_ID
CDI_TRANS_LOG CDI_FORM_ID


CDI_FORM_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Form Activity
Definition: A row in this table represents the status of a form completion for a given parent entity (person, encounter, order, etc). (Currently, only "refusals" will be logged to this table; a "status" will likely be added in the future and *all* form completions will be logged here.)
Table Type: ACTIVITY





Column Detail - CDI_FORM_ACTIVITY


Column Name Type Null? Definition
ACTIVITY_DEVICE_IDENT VARCHAR(64) Y The unique, alphanumeric identifier for the device used to update or save the form.
ACTIVITY_DT_TM DATETIME N Date that the activity was performed
BLOB_HANDLE VARCHAR(255) Y Handle to the image stored in OTG database.
BLOB_REF_ID DOUBLE N Foreign key to the blob_reference table. Optional.
CDI_DOCUMENT_SUBTYPE_ID DOUBLE N The document subtype identifier. Optional.
CDI_FORM_ACTIVITY_ID DOUBLE N The unique primary key of this table. It is an internally assigned number.
CDI_FORM_ID DOUBLE N The ID of the form the field appears on. A foreign key to the CDI_FORM table.
EVENT_CD DOUBLE N Event code that corresponds to the CPDI document type. Can be multiple code sets; associated code set is stored in column event_code_set.
EVENT_CODE_SET DOUBLE N Specifies the code set for the event code field.
EVENT_ID DOUBLE N Pseudo foreign key to the clinical event table. Optional.
FORM_STATUS_FLAG DOUBLE N The status of the form, eg, completed or postponed. 0 - Postponed, 1 - Complete, 2 - Declined, 3 - In Progress, 4 - Marked Coomplete, 5 - Unmarked Complete, 6 - Queued, 7 - Dequeued, 10 - Presented, 11 - Save in Progress, 12 - Content Management Store Failed, 13 - Millennium Document Creation Failed, 14 - Millennium Document Logging Failed, 15 - Linked Data Update Failed, 16 - ABN Update Failed.
MEDIA_OBJECT_IDENT VARCHAR(64) Y Psuedo FK to DMS_MEDIA_IDENTIFIER.MEDIA_OBJECT_IDENTIFIER column. But column column. But column MEDIA_OBJECT_IDENTIFIER is not a PK so there is no foreign key constraint on this column.
PARENT_ENTITY_ID DOUBLE N The ID of the parent table row associated to the form activity.
PARENT_ENTITY_NAME VARCHAR(30) N The name of the table that this form activity is associated to.
REASON_CD DOUBLE N Identifies the reason that this form was not presented or the reason that it was marked complete.There are two codesets associated with this column. CODE SET:4002611 Identifies the reason that this form was not presented. CODE SET:4602008 Identifies the reason that this form was marked complete". Column FORM_STATUS_FLAG will be set to '0 - Postponed' for CODE SET 4002611 or '4 - Marked Complete' for CODE SET 4602008. REASON_CD will be 0 if FORM_STATUS_FLAG is not 0 or 4.
REASON_TEXT VARCHAR(500) N Further clarifies the reason that this form was not presented, if necessary.
SOURCE_EVENT_ID DOUBLE N A value from the EVENT_ID field in CLINICAL_EVENT. The Clinical Event used to generate the form.
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 - CDI_FORM_ACTIVITY


Child Column in CDI_FORM_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: BLOB_REF_ID BLOB_REFERENCE BLOB_REF_ID
CDI_DOCUMENT_SUBTYPE_ID CDI_DOCUMENT_SUBTYPE CDI_DOCUMENT_SUBTYPE_ID
CDI_FORM_ID CDI_FORM CDI_FORM_ID




Parent Column in CDI_FORM_ACTIVITY (PK) Child Table Name Child Column Name
Children: CDI_FORM_ACTIVITY_ID CDI_FORM_ACTIVITY_RELTN CDI_FORM_ACTIVITY_ID
CDI_FORM_FIELD_ACTIVITY CDI_FORM_ACTIVITY_ID


CDI_FORM_ACTIVITY_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Form Activity Reltn
Definition: A row in this table represents a relationship between a form activity and another identifier, such as the relationship between a queued ABN form and rows on the EEM_ABN_CHECK table.
Table Type: ACTIVITY





Column Detail - CDI_FORM_ACTIVITY_RELTN


Column Name Type Null? Definition
CDI_FORM_ACTIVITY_ID DOUBLE N Foreign key to the CDI_FORM_ACTIVTY table.
CDI_FORM_ACTIVITY_RELTN_ID DOUBLE N The unique primary key of the CDI_FORM_ACTIVTY_RELTN table.
PARENT_ENTITY_ID DOUBLE N The ID of the parent table row associated to the form activity.
PARENT_ENTITY_NAME VARCHAR(30) N Name of the table associated to the form activity.
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 - CDI_FORM_ACTIVITY_RELTN


Child Column in CDI_FORM_ACTIVITY_RELTN(FK) Parent Table Name Parent Column Name
Parents: CDI_FORM_ACTIVITY_ID CDI_FORM_ACTIVITY CDI_FORM_ACTIVITY_ID


CDI_FORM_CRITERIA



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Form Criteria
Definition: A row in this table represents criteria which is part of a rule for when a CPDI interactive form may be required.
Table Type: REFERENCE





Column Detail - CDI_FORM_CRITERIA


Column Name Type Null? Definition
CDI_FORM_CRITERIA_ID DOUBLE N Unique row identifier for the CDI Form Criteria table. It is internally generated.
CDI_FORM_RULE_ID DOUBLE N Foreign key to the cdi_form_rule table. Identifies the rule the criteria is associated with.
COMPARISON_FLAG DOUBLE N Indicates the type of comparison to perform. 0 - equals, 1 - less than, 2 - greater than, 3 - not equal, 4 - less than or equal, 5 - greater than or equal
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.
VALUE_CD DOUBLE Y The code value to compare against. Code set will vary.
VALUE_DT_TM DATETIME Y Date/time value to compare against.
VALUE_NBR DOUBLE Y Numeric value to compare against.
VALUE_TEXT VARCHAR(30) Y Text value to compare against.
VARIABLE_CD DOUBLE N Identifies the variable (encounter data, etc.) that this criteria is evaluated against.



Relationship Detail - CDI_FORM_CRITERIA


Child Column in CDI_FORM_CRITERIA(FK) Parent Table Name Parent Column Name
Parents: CDI_FORM_RULE_ID CDI_FORM_RULE CDI_FORM_RULE_ID


CDI_FORM_FACILITY_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Form Facility Relationship
Definition: Associates CPDI Forms to Facilities.
Table Type: REFERENCE





Column Detail - CDI_FORM_FACILITY_RELTN


Column Name Type Null? Definition
CDI_FORM_FACILITY_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the CDI_FORM_FACILITY_RELTN table.
CDI_FORM_ID DOUBLE N Foreign Key to the CDI_FORM table. The ID of the form the facility is associated to.
FACILITY_CD DOUBLE N The Code Value of the facility the form is associated to.
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 - CDI_FORM_FACILITY_RELTN


Child Column in CDI_FORM_FACILITY_RELTN(FK) Parent Table Name Parent Column Name
Parents: CDI_FORM_ID CDI_FORM CDI_FORM_ID
FACILITY_CD LOCATION LOCATION_CD