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