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