Table Detail Report
FORM_ASSOCIATION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Form Association |
Definition: | Contains the association between a input form and an order catalog item or an order task |
Table Type: | REFERENCE |
Column Detail - FORM_ASSOCIATION
Column Name | Type | Null? | Definition |
---|---|---|---|
ASSOCIATION_TYPE_FLAG | DOUBLE | Y | An indicator of the type of association, i.e. Order Catalog, Order Task |
CATALOG_CD | DOUBLE | N | The order catalog entry associated with this input form (when the association_type_flag = 1) |
FORM_ASSOCIATION_ID | DOUBLE | N | The primary key, uniquely identifying a row on this table |
INPUT_FORM_CD | DOUBLE | N | The input form code referred to in this form association |
LOCATION_CD | DOUBLE | N | The location associated with this form association |
ORDER_TYPE_FLAG | DOUBLE | Y | NOT CURRENTLY BEING USED |
REFERENCE_TASK_ID | DOUBLE | N | A reference (foreign key) to the order_task table indicating the order task associated with this form (when association_type_flag=2) |
SEQUENCE_NBR | DOUBLE | N | NOT BEING USED |
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 - FORM_ASSOCIATION
Child Column in FORM_ASSOCIATION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CATALOG_CD | ORDER_CATALOG | CATALOG_CD |
GROUP_DEFINITION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Group Definition |
Definition: | Identifies a component of an input group -- used by the Form Builder. |
Table Type: | REFERENCE |
Column Detail - GROUP_DEFINITION
Column Name | Type | Null? | Definition |
---|---|---|---|
COLUMN_HEADING | VARCHAR(100) | Y | The column heading that will be used in the listview for a repeating group. |
CREATE_APPLCTX | DOUBLE | Y | The application context responsible for inserting this row on the table. |
CREATE_DT_TM | DATETIME | Y | The date and time this row was inserted on the table. |
CREATE_ID | DOUBLE | Y | The person responsible for inserting this row on the table |
CREATE_TASK | DOUBLE | Y | The task responsible for inserting this row on the table |
FIELD_PROMPT | VARCHAR(100) | Y | The prompt to be used when this component appears in this group. |
GROUP_CD | DOUBLE | N | A reference to the code_value table indicating the group being defined |
GROUP_CMPNT_LEFT | DOUBLE | Y | The left position of the component within the group. This column is only filled out if the form has been re-positioned. |
GROUP_CMPNT_TOP | DOUBLE | Y | The top position of the component within the group. This column is only filled out if the form has been re-positioned. |
GROUP_DEF_SEQ | DOUBLE | N | The sequence of this component within the group. |
GROUP_REFERENCE_ID | DOUBLE | N | This is a unique value from the GROUP_REFERENCE table. It will be considered a Foreign Key value. |
GROUP_VERSION_NBR | DOUBLE | N | A reference (foreign key) to the group_reference table identifying the version number of the input form group associated with this group component. |
ONLINE_ITEM_DEFINITION_ID | DOUBLE | N | This is a unique value for a row in the ONLINE_ITEM_DEFINITION_ID table. It will be treated like a Foreign Key value. |
ONLINE_ITEM_VERSION_NBR | DOUBLE | N | A reference (foreign key) to the online_item_definition table indicating the version number of the input control component of this group. |
REPEAT_IND | DOUBLE | Y | An indicator of whether or not this is a repeating group. |
REQUIRED_FLAG | DOUBLE | Y | An indicator of whether or not this input group component is required within the input group |
TASK_ASSAY_CD | DOUBLE | N | A reference (foreign key) to the discrete_task_assay table identifying the input control component of this group. |
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 - GROUP_DEFINITION
Child Column in GROUP_DEFINITION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ONLINE_ITEM_VERSION_NBR | ONLINE_ITEM_DEFINITION | ONLINE_ITEM_VERSION_NBR |
TASK_ASSAY_CD | ONLINE_ITEM_DEFINITION | TASK_ASSAY_CD |
GROUP_REFERENCE
Column Section | Top of Page |
Table-level Detail
Description: | Group Reference |
Definition: | Contains the attributes of an input group, including the description, repeating indicator, etc. |
Table Type: | REFERENCE |
Column Detail - GROUP_REFERENCE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BACKCOLOR | DOUBLE | Y | Color behind the text for the group frame. |
CREATE_APPLCTX | DOUBLE | Y | The application context responsible for inserting this row on the table |
CREATE_DT_TM | DATETIME | Y | The date and time this row was inserted on the table |
CREATE_ID | DOUBLE | N | The person responsible for inserting this row on the table |
CREATE_TASK | DOUBLE | Y | The task responsible for inserting this row on the table |
DESCRIPTION | VARCHAR(100) | Y | A description of the input group |
DISPLAY | VARCHAR(50) | Y | A display of the input group.This column is not populated by mainline Surginet applications and has been deemed OBSOLETE for that solution. It is possible, however, that other applications may use the field. |
DISPLAY_KEY | VARCHAR(50) | Y | The display for this input group, in key format -- used for retrieval purposes.This column is not populated by mainline Surginet applications and has been deemed OBSOLETE for that solution. It is possible, however, that other applications may use the field. |
FACENAME | VARCHAR(50) | Y | Font used for the font of the text of the group frame. |
FONTEFFECTS | DOUBLE | Y | Look of text of the group frame such as italic, bold, underline, and strike through. |
FORECOLOR | DOUBLE | Y | Color of the text for the group frame. |
GROUP_CD | DOUBLE | N | Identifies an input group used by the Form Builder |
GROUP_REFERENCE_ID | DOUBLE | N | Group Reference ID. This column will uniquely identify a row in this table. Can be treated like a PK. |
GROUP_VERSION_NBR | DOUBLE | N | A part of the composite primary key, identifying the version number for the input group. |
PART_PROCESS_IND | DOUBLE | Y | An indicator of whether or not the version processor is currently running but not yet complete. |
POINTSIZE | DOUBLE | Y | Size of the font for the text for the group frame. |
PROMPT_HEIGHT | DOUBLE | Y | Height of the text for the group frame. |
PROMPT_WIDTH | DOUBLE | Y | Width of the text for the group frame. |
REPEAT_IND | DOUBLE | Y | An indicator of whether or not the input group is repeating |
SYSTEM_DEFINED_FLAG | DOUBLE | Y | An indicator of the source of definition for this input group, i.e. Form Builder-defined, SurgiNet-defined, DCP-defined. |
UNPROCESS_IND | DOUBLE | Y | An indicator of whether or not this input group has been processed by the Version Processor. |
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. |
INPUT_FORM_BEHAVIOR
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Input_Form_Behavior |
Definition: | Defines behaviors for input_form_reference forms |
Table Type: | REFERENCE |
Column Detail - INPUT_FORM_BEHAVIOR
Column Name | Type | Null? | Definition |
---|---|---|---|
BEHAVIOR_ID | DOUBLE | N | Unique identifier for this row. PK |
CONDITION_ID | DOUBLE | N | Foreign key from Input_Form_Condition, the condition that triggers this behavior |
EFFECTED_FORM_CD | DOUBLE | N | The input_form_reference form that will be effected by this behavior |
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 - INPUT_FORM_BEHAVIOR
Child Column in INPUT_FORM_BEHAVIOR(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CONDITION_ID | INPUT_FORM_CONDITION | CONDITION_ID |
INPUT_FORM_CONDITION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Input_Form_Condition |
Definition: | Defines conditions for input_form_reference forms; when evaluated these conditions can trigger behaviors from input_form_behavior |
Table Type: | REFERENCE |
Column Detail - INPUT_FORM_CONDITION
Column Name | Type | Null? | Definition |
---|---|---|---|
COMPARISON_PARENT_ENTITY_ID | DOUBLE | N | Compared to the value in the trigger control to determine if behavior(s) should be executed |
COMPARISON_PARENT_ENTITY_NAME | VARCHAR(32) | N | Name of the table from which Comparison_Parent_Entity_ID comes |
COMPARISON_TASK_ASSAY_CD | DOUBLE | N | The field/input control whose value will be evaluated to determine if any behavior(s) should be executed. |
COMPARISON_TEXT | VARCHAR(255) | Y | Compared to the value in the trigger control to determine if behavior(s) should be executed |
CONDITION_ID | DOUBLE | N | Unique identifier for this row. PK |
CONDITION_TYPE_FLAG | DOUBLE | N | Logical operation that will be used to compare the value in the trigger to the comparison control/value/text.0 - Equal To; 1 - Not Equal To; 2 - Any Value; 3 - Less Than; 4 - Greater Than; 5 - Greater Than/Equal To; 6 - Less Than/Equal To |
INPUT_FORM_CD | DOUBLE | N | The code of the parent form from Input_Form_Reference. |
TRIGGER_TASK_ASSAY_CD | DOUBLE | N | The field/input control whose value will be evaluated to determine if any behavior(s) should be executed. |
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 - INPUT_FORM_CONDITION
Parent Column in INPUT_FORM_CONDITION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CONDITION_ID | INPUT_FORM_BEHAVIOR | CONDITION_ID |