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 |