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 |