Table Detail Report
CNT_INPUT_KEY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CNT INPUT KEY |
Definition: | INPUT KEY |
Table Type: | REFERENCE |
Column Detail - CNT_INPUT_KEY
Column Name | Type | Null? | Definition |
---|---|---|---|
CNT_INPUT_KEY_ID | DOUBLE | N | Sequence generated ID - PRIMARY KEY |
CNT_INPUT_PVC_NAME | VARCHAR(32) | N | The name portion of the name/value pair that is stored on a row in this table. |
CNT_SECTION_KEY2_ID | DOUBLE | N | Sequence generated ID (Value: 0.0) - FROM CNT_SECTION_KEY2 |
DCP_INPUT_REF_ID | DOUBLE | N | Unique ID of Input Control (FK value from DCP_INPUT_REF) |
INPUT_DESCRIPTION | VARCHAR(200) | N | Textual description of input control |
INPUT_REF_SEQ | DOUBLE | N | Sequence number of input control to control order that it is placed on the section. |
INPUT_TYPE | DOUBLE | Y | Numeric indicator to identify what type of control the input is. |
MODULE_NAME | VARCHAR(100) | N | Name of DLL module that implements control. If the name is blank then the control is implemented in pvFormControls.dll |
SECTION_UID | VARCHAR(100) | N | Unique identifier for Section |
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 - CNT_INPUT_KEY
Child Column in CNT_INPUT_KEY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CNT_SECTION_KEY2_ID | CNT_SECTION_KEY2 | CNT_SECTION_KEY2_ID |
DCP_INPUT_REF_ID | DCP_INPUT_REF | DCP_INPUT_REF_ID |
Parent Column in CNT_INPUT_KEY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CNT_INPUT_KEY_ID | CNT_GRID | CNT_INPUT_KEY_ID |
CNT_INPUT | CNT_INPUT_KEY_ID |
CNT_PF_KEY2
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CNT PF KEY |
Definition: | PF KEY |
Table Type: | REFERENCE |
Column Detail - CNT_PF_KEY2
Column Name | Type | Null? | Definition |
---|---|---|---|
CNT_PF_KEY_ID | DOUBLE | N | Sequence generated ID - PRIMARY KEY |
DCP_FORMS_REF_ID | DOUBLE | N | Every form has a single entry in this table that describes the form such as name and definition - DCP_FORMS_REF |
FORM_DEFINITION | VARCHAR(200) | Y | Textual definition of the form. |
FORM_DESCRIPTION | VARCHAR(200) | Y | Textual description of the form |
FORM_INTERNAL_UID | VARCHAR(100) | N | Unique identifier for domain generated Powerform |
FORM_UID | VARCHAR(100) | N | Unique identifier for Powerform |
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 the Powerform we extracted from source. |
Relationship Detail - CNT_PF_KEY2
Parent Column in CNT_PF_KEY2 (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CNT_PF_KEY_ID | CNT_PF_SECTION_R | CNT_PF_KEY_ID |
CNT_POWERFORM | CNT_PF_KEY_ID |
CNT_PF_SECTION_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CNT PF SECTION R |
Definition: | PF SECTION RELTN |
Table Type: | REFERENCE |
Column Detail - CNT_PF_SECTION_R
Column Name | Type | Null? | Definition |
---|---|---|---|
CNT_PF_KEY_ID | DOUBLE | N | Sequence generated ID (Value: 0.0) - FK from CNT_PF_KEY2 |
CNT_PF_SECTION_R_ID | DOUBLE | N | Sequence generated ID - PRIMARY KEY |
CNT_SECTION_KEY2_ID | DOUBLE | N | Sequence generated ID (Value: 0.0) - FK from CNT_SECTION_KEY2 |
FORM_UID | VARCHAR(100) | N | Unique identifier for PowerForm |
IGNORE_IND | DOUBLE | N | Indicates whether to ignore the relationship in the Bedrock wizard |
SECTION_SEQ | DOUBLE | Y | Sequence of the section within the PowerForm |
SECTION_UID | VARCHAR(100) | N | Unique identifier for Section |
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 - CNT_PF_SECTION_R
Child Column in CNT_PF_SECTION_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CNT_PF_KEY_ID | CNT_PF_KEY2 | CNT_PF_KEY_ID |
CNT_SECTION_KEY2_ID | CNT_SECTION_KEY2 | CNT_SECTION_KEY2_ID |
CNT_POWERFORM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CNT POWERFORM |
Definition: | POWERFORM |
Table Type: | REFERENCE |
Column Detail - CNT_POWERFORM
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. |
CNT_PF_KEY_ID | DOUBLE | N | `Sequence generated ID - FK from CNT_PF_KEY2 |
CNT_POWERFORM_ID | DOUBLE | N | each form has a unique reference id that is used to identify the form. each version of the form is identified by a unique instance id. |
DONE_CHARTING_IND | DOUBLE | N | Done charting indicator |
ENFORCE_REQUIRED_IND | DOUBLE | N | Indicates whether to make the user enter all required fields before they are allowed to save. Without this option users can chart forms missing required fields, tasks associated with the results will be in an "in progress" status. |
FORM_EVENT_CD | DOUBLE | N | event_cd associated with this form to be used for various purposes. currently is not used |
FORM_EVENT_CDUID | VARCHAR(100) | N | Unique identifier FK to CNT_CODE_VALUE_KEY |
FORM_EVENT_SET_NAME | VARCHAR(100) | Y | Specify an Event Set that is associated with this form to enable charting to print results |
FORM_FLAG | DOUBLE | N | 1 - do not allow any charting unless all required fields are filled out.2 - show form in a maximized state0 - not defined |
FORM_HEIGHT | DOUBLE | N | Height the form should be sized |
FORM_UID | VARCHAR(100) | N | Unique identifier for PowerForm |
FORM_WIDTH | DOUBLE | N | Width the form should be sized |
TEXT_RENDITION_EVENT_CD | DOUBLE | N | event code associated with the text rendered from the form. |
TEXT_RENDITION_EVENT_CDUID | VARCHAR(100) | Y | unique identifier value from the CNT_CODE_VALUE_KEY table (code_value_uid) |
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 - CNT_POWERFORM
Child Column in CNT_POWERFORM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CNT_PF_KEY_ID | CNT_PF_KEY2 | CNT_PF_KEY_ID |
CNT_REF_TEXT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CNT REF TEXT |
Definition: | REF TEXT |
Table Type: | REFERENCE |
Column Detail - CNT_REF_TEXT
Column Name | Type | Null? | Definition |
---|---|---|---|
CNT_DTA_KEY_ID | DOUBLE | N | Sequence generated ID (Value: 0.0) - from table CNT_DTA_KEY2 |
CNT_REF_BLOB | LONGBLOB | Y | BLOB field to contain stored reference data |
CNT_REF_TEXT_ID | DOUBLE | N | Sequence generated ID |
CNT_REF_TEXT_UID | VARCHAR(100) | N | Unique identifier for Reference Text |
TASK_ASSAY_UID | VARCHAR(100) | N | Unique identifier for DTA |
TEXT_TYPE_CD | DOUBLE | N | defines what type of text this is, for example patient education, nursing preps, etc. |
TEXT_TYPE_CDUID | VARCHAR(100) | N | Unique identifier FK to CNT_CODE_VALUE_KEY |
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 - CNT_REF_TEXT
Child Column in CNT_REF_TEXT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CNT_DTA_KEY_ID | CNT_DTA_KEY2 | CNT_DTA_KEY_ID |