Table Detail Report

CDI_FORM_FIELD



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Form Field
Definition: A row in this table represents an interactive field on a CPDI interactive form.
Table Type: REFERENCE





Column Detail - CDI_FORM_FIELD


Column Name Type Null? Definition
CDI_FORM_FIELD_ID DOUBLE N The unique primary key of this table. It is an internally generated number.
CDI_FORM_ID DOUBLE N The ID of the form the field appears on. A foreign key to the CDI_FORM table.
FIELD_DESCRIPTION VARCHAR(500) N Description of the form field.
FIELD_HEIGHT DOUBLE N The height of the field.
FIELD_NAME VARCHAR(40) N The name of the field. Used primarily by RDDS to match rows across domains.
FIELD_ROTATION_VALUE DOUBLE N The orientation of the field, in degrees of rotation counterclockwise.
FIELD_TYPE_FLAG DOUBLE N Indicates the type of interactive field. 0 - Signature, 1 - Checkbox, 2 - Text, 3 - Group, 4 - Required Signature
FIELD_WIDTH DOUBLE N The width of the field.
FONT_FAMILY_FLAG DOUBLE N Font family to be used when displaying a text field.0 = sans-serif (e.g. Arial)1 = serif (e.g. Times)2 = monospace (e.g. Courier)256 = sans-serif italic 257 = serif italic 258 = monospace italic 512 = sans-serif bold 513 = serif bold 514 = monospace bold 768 = sans-serif bold italic 769 = serif bold italic 770 = monospace bold italic 2048 = bar code 128 2049 = bar code 3 of 9 extended 3072 = bar code PDF 417 3073 = bar code datamatrix
FONT_SIZE_NBR DOUBLE N Font size to be used when displaying a text field.
FORM_COMPLETION_FLAG DOUBLE N Identifies how completion of this field affects completion of the entire form. 0 - No effect, 1- Declined if not set, 2 - Declined if set.
LAST_PAGE_NBR DOUBLE N The last page number that the field appears on.
LINKED_VALUE_CD DOUBLE N Indicates the code value that will be stored if this field is set. The code set will vary depending on what is selected in linked_variable_cd. OBSOLETE COLUMN
LINKED_VALUE_NBR DOUBLE N Indicates the numeric value that will be stored if this field is set. OBSOLETE COLUMN
LINKED_VALUE_TEXT VARCHAR(150) Y Indicates the text value that will be stored if this field is set. OBSOLETE COLUMN
LINKED_VARIABLE_CD DOUBLE N Identifies the data variable that will be set if this field is set. OBSOLETE COLUMN
PAGE_NBR DOUBLE N The first page number that the field appears on.
PARENT_FORM_FIELD_ID DOUBLE N Indicates that this field is associated to a parent form field.
REQUIRED_IND DOUBLE N Indicates that this field is required.
TEXT_COLOR_NBR DOUBLE N RGB color to be used when displaying a text field.
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.
VALUE_FORMAT_TEXT VARCHAR(150) Y Indicates the format for text fields.
X_COORD DOUBLE N Position x coordinate that the field appears at.
Y_COORD DOUBLE N Position y coordinate that the field appears at.



Relationship Detail - CDI_FORM_FIELD


Child Column in CDI_FORM_FIELD(FK) Parent Table Name Parent Column Name
Parents: CDI_FORM_ID CDI_FORM CDI_FORM_ID
PARENT_FORM_FIELD_ID CDI_FORM_FIELD CDI_FORM_FIELD_ID




Parent Column in CDI_FORM_FIELD (PK) Child Table Name Child Column Name
Children: CDI_FORM_FIELD_ID CDI_FORM_FIELD PARENT_FORM_FIELD_ID
CDI_FORM_FIELD_ACTIVITY CDI_FORM_FIELD_ID
CDI_FORM_FIELD_VAR_RELTN CDI_FORM_FIELD_ID


CDI_FORM_FIELD_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI_FORM_FIELD_ACTIVITY
Definition: This table tracks the status of each field on an instance of a CDI_FORM.
Table Type: ACTIVITY





Column Detail - CDI_FORM_FIELD_ACTIVITY


Column Name Type Null? Definition
CDI_FORM_ACTIVITY_ID DOUBLE N Foreign key to the CDI_FORM_ACTIVITY table.
CDI_FORM_FIELD_ACTIVITY_ID DOUBLE N Unique generated number that identifies a single row on the CDI_FORM_FIELD_ACTIVITY table.
CDI_FORM_FIELD_ID DOUBLE N Foreign key to the CDI_FORM_FIELD table.
FIELD_STATUS_FLAG DOUBLE N Indicates the status of the form field. 0=Complete 1=Pending 2=Declined
FIELD_VALUE_TEXT VARCHAR(150) Y This will support capturing the (first 150 characters of) text values entered by patients on text fields for patient forms. Capturing the text value will allow reports to be written that display the values entered by patients (without displaying the actual document itself).
PAGE_NBR DOUBLE N The page number that the field appears on.
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_FIELD_ACTIVITY


Child Column in CDI_FORM_FIELD_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: CDI_FORM_ACTIVITY_ID CDI_FORM_ACTIVITY CDI_FORM_ACTIVITY_ID
CDI_FORM_FIELD_ID CDI_FORM_FIELD CDI_FORM_FIELD_ID


CDI_FORM_FIELD_VAR_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI_FORM_FIELD_VAR_RELTN
Definition: A row in this table represents a link from a patient eSignature form to a Millennium variable (eg, a registration UDF field or health plan relationship field).
Table Type: REFERENCE





Column Detail - CDI_FORM_FIELD_VAR_RELTN


Column Name Type Null? Definition
CDI_FORM_FIELD_ID DOUBLE N The ID of the form field this variable is linked to. A foreign key to the cdi_form_field table.
CDI_FORM_FIELD_VAR_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the CDI_FORM_FIELD_VAR_RELTN table.
FIELD_STATUS_FLAG DOUBLE N Indicates the status this field must have before the linked variable is updated. 0 - Not set (unchecked or unsigned), 1 - Set (checked or signed), 2- Declined, 3 - Embedded.
LINKED_VALUE_CD DOUBLE N Indicates the data variable that will be set if this field is updated. The code set will vary depending on what is selected in linked_variable_cd.
LINKED_VALUE_NBR DOUBLE N Indicates the numeric value that will be stored if this field updated.
LINKED_VALUE_TEXT VARCHAR(150) Y Indicates the text value that will be stored if this field is updated.
LINKED_VARIABLE_CD DOUBLE N Indicates the code value that will be stored if this field is updated.
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_FIELD_VAR_RELTN


Child Column in CDI_FORM_FIELD_VAR_RELTN(FK) Parent Table Name Parent Column Name
Parents: CDI_FORM_FIELD_ID CDI_FORM_FIELD CDI_FORM_FIELD_ID


CDI_FORM_RULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Form Rule
Definition: A row in this table represents a rule for when a CPDI interactive form may be required.
Table Type: REFERENCE





Column Detail - CDI_FORM_RULE


Column Name Type Null? Definition
CDI_FORM_ID DOUBLE N Foreign key to the cdi_form table. The ID of the form the rule is associated with.
CDI_FORM_RULE_ID DOUBLE N Unique row identifier for the CDI Form Rule.
CRITERIA_CNT DOUBLE N Specifies the number of criteria that make up this rule.
REQUIRED_IND DOUBLE N Specifies if forms matching this rule are required to be completed.
RULE_NAME VARCHAR(40) N The name of the rule. It is primarily used by the RDDS process.
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_RULE


Child Column in CDI_FORM_RULE(FK) Parent Table Name Parent Column Name
Parents: CDI_FORM_ID CDI_FORM CDI_FORM_ID




Parent Column in CDI_FORM_RULE (PK) Child Table Name Child Column Name
Children: CDI_FORM_RULE_ID CDI_FORM_CRITERIA CDI_FORM_RULE_ID


CDI_IMPORT_JOB



Column Section Relationship Section Top of Page


Table-level Detail

Description: CDI Import Job
Definition: This table tracks the status of requests to import one or more Document Imaging documents to the system.
Table Type: ACTIVITY





Column Detail - CDI_IMPORT_JOB


Column Name Type Null? Definition
CDI_IMPORT_JOB_ID DOUBLE N The unique primary key of this table. This value is internally generated by the system.
CDI_IMPORT_TYPE_ID DOUBLE Y The import type associated to the import job.
COMPLETE_DOCUMENT_COUNT DOUBLE Y The total number of documents successfully created.
COMPLETE_DT_TM DATETIME Y When the import job was completed.
CREATE_DT_TM DATETIME Y When the import job was created.
FAILURE_CNT DOUBLE Y Count of how many prior failed attempts there have been to import this job.
FILE_CREATE_DT_TM DATETIME Y The date and time the file to import was created.
FILE_NAME VARCHAR(1000) N The name of the file to import.
JOB_IDENT VARCHAR(50) Y The unique identifier created and returned by the service doing the import.
STATUS_FLAG DOUBLE Y The status of the import. 0 - submitted - The file was submitted to the service doing the import.; 1 - Received - The file was received by the service doing the import.; 2 - document creation failed - The import failed.; 3 - Complete - The import was successful.; 4 - Timed Out - Filing and Bursting has not processed job in time allowed.; 5 - Index Extraction Error - Filing and Bursting encountered an error extracting the documents.; 6 - Purged - File was purged from the input directory.
TOTAL_DOCUMENT_COUNT DOUBLE Y The total number of documents that will be created from the imported file.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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_IMPORT_JOB


Child Column in CDI_IMPORT_JOB(FK) Parent Table Name Parent Column Name
Parents: CDI_IMPORT_TYPE_ID CDI_IMPORT_TYPE CDI_IMPORT_TYPE_ID