Table Detail Report

INPUT_FORM_DEFINITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Input Form Definition
Definition: Contains the components of an input form, including input groups and input controls
Table Type: REFERENCE





Column Detail - INPUT_FORM_DEFINITION


Column Name Type Null? Definition
CMPNT_HEIGHT DOUBLE Y The height that this input form component should be displayed
CMPNT_LEFT DOUBLE Y The left value for displaying this input form component. This column is only populated when the user has re-positioned the form, i.e. Autolayout Ind = 0
CMPNT_REPEAT_IND DOUBLE Y An indicator of whether or not this input form component is repeating
CMPNT_TOP DOUBLE Y The top value for displaying this input form component. This column is only populated when the user has re-positioned the form, i.e. Autolayout Ind = 0
CMPNT_WIDTH DOUBLE Y The width for displaying this input form component. This column is only populated when the user has re-positioned the form, i.e. Autolayout Ind = 0
COLUMN_HEADING VARCHAR(100) Y The column heading to be used in the listview for this input form component. Only used for repeating forms
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
FIELD_PROMPT VARCHAR(100) Y The prompt to be used when the component appears on this input form
GROUP_CD DOUBLE N The input group associated with this input form
GROUP_REFERENCE_ID DOUBLE N Defines a unique Row in the GROUP_REFERENCE table. Can be treated like a Foreign Key
GROUP_VERSION_NBR DOUBLE Y A reference (foreign key) to the group_reference table indicating the version number of the group that this input form component belongs to, if applicable
INPUT_FORM_CD DOUBLE N The input form that this component is associated with
INPUT_FORM_DEF_SEQ DOUBLE N The sequence that this input form component should be displayed (and accepted) on the form
INPUT_FORM_REFERENCE_ID DOUBLE N Defines a unique row in the INPUT_FORM_REFERENCE table. Can be treated like a Foreign Key.
INPUT_FORM_VERSION_NBR DOUBLE N The version number of the input form associated with this component
ONLINE_ITEM_DEFINITION_ID DOUBLE N Defines a unique row in the ONLINE_ITEM_DEFINITION Table. Can be treated like a Foreign Key.
ONLINE_ITEM_VERSION_NBR DOUBLE Y A reference (foreign key) to the online_item_definition table indicating the version number of the input control component of this form
PROMPT_LEFT DOUBLE Y The left position of the component on the form.
PROMPT_TOP DOUBLE Y The top position of the component on the form.
REQUIRED_FLAG DOUBLE Y An indicator of whether this component of the input form is required
TASK_ASSAY_CD DOUBLE N A reference (foreign key) to the online_item_definition table indicating the input control component of this form
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_DEFINITION


Child Column in INPUT_FORM_DEFINITION(FK) Parent Table Name Parent Column Name
Parents: INPUT_FORM_CD INPUT_FORM_REFERENCE INPUT_FORM_CD
INPUT_FORM_VERSION_NBR INPUT_FORM_REFERENCE INPUT_FORM_VERSION_NBR
ONLINE_ITEM_VERSION_NBR ONLINE_ITEM_DEFINITION ONLINE_ITEM_VERSION_NBR
TASK_ASSAY_CD ONLINE_ITEM_DEFINITION TASK_ASSAY_CD


INPUT_FORM_REFERENCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Input Form Reference
Definition: Contains the attributes of an input form used by the form builder, including description, repeating indicator, auto layout indicator, etc
Table Type: REFERENCE





Column Detail - INPUT_FORM_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 Y The person who caused the active_status_cd to be set or change.
AUTO_LAYOUT_IND DOUBLE Y An indicator of whether this form should use an automatic layout by the form builder or use the layout that the user has defined, i.e. repositioned the form
CALC_RESULT_IND DOUBLE Y NOT CURRENTLY BEING USED
COLUMN_SORT_IND DOUBLE Y An indicator of whether or not to allow column sorting in the listbox -- for repeating forms only
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
DESCRIPTION VARCHAR(100) Y A description for this input form
DISPLAY VARCHAR(50) Y A textual display for this input form. 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 A textual display for this input form, in key form, 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.
EVENT_CD DOUBLE Y The Event Code associated with this input form
INPUT_FORM_CD DOUBLE N The primary key uniquely identifying an input form (along with version number)
INPUT_FORM_REFERENCE_ID DOUBLE N This column uniquely identifies a row in the table. Can be treated like a PK.
INPUT_FORM_VERSION_NBR DOUBLE N The version number associated with the input form
NOTE_TEMPLATE_CD DOUBLE Y NOT CURRENTLY BEING USED -- The template to be used for comments when this input form is documented
ONE_COLUMN_IND DOUBLE Y An indicator of whether or not this input form should be displayed in one column when being documented
PART_PROCESS_IND DOUBLE Y An indicator of whether or not the version processor is currently running but not yet complete.
REPEAT_IND DOUBLE Y An indicator of whether or not this is a repeating form
SYSTEM_DEFINED_FLAG DOUBLE Y An indicator of the source of definition for this input form, i.e. Form Builder-defined, SurgiNet-defined, DCP-defined
UNPROCESS_IND DOUBLE Y An indicator of whether or not this input form 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.



Relationship Detail - INPUT_FORM_REFERENCE




Parent Column in INPUT_FORM_REFERENCE (PK) Child Table Name Child Column Name
Children: INPUT_FORM_CD CONDITIONAL_BEHAVIOR INPUT_FORM_CD
INPUT_FORM_VERSION_NBR CONDITIONAL_BEHAVIOR INPUT_FORM_VERSION_NBR
INPUT_FORM_CD INPUT_FORM_DEFINITION INPUT_FORM_CD
INPUT_FORM_VERSION_NBR INPUT_FORM_DEFINITION INPUT_FORM_VERSION_NBR


ITEM_SR_LOC_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Item/Service Resource/Location Relationship
Definition: Identifies item exceptions for fill location relationships between an OR and an inventory location
Table Type: REFERENCE





Column Detail - ITEM_SR_LOC_R


Column Name Type Null? Definition
IN_TRANSIT_IND DOUBLE Y To store the Intransit status for each Location of corresponding service resource
ITEM_ID DOUBLE N A reference (foreign key) to the item_definition table identifying the item for which an exception exists.
ITEM_SR_LOC_TYPE_CD DOUBLE N Indicates the type of relationship for this item exception, i.e. Surgery Add, Surgery Fill, Surgery Return. These relationships will be queried in Case Pick List Manager when defaulting the list of fill locations that are valid for this item.
LOCATION_CD DOUBLE N The inventory location for which an item exception exists.
SEQUENCE DOUBLE N The sequence in which to look for "Stored At" locations for the specified item. Used to default a fill location in Case Pick List Manager.
SERVICE_RESOURCE_CD DOUBLE N The service resource (CDF Meaning = "SURGOP" -- Surgical Operating Area) for which an item exception is defined.
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 - ITEM_SR_LOC_R


Child Column in ITEM_SR_LOC_R(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


ONLINE_ITEM_DEFINITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Online Item Definition
Definition: Contains the attributes of an input control used by the form builder, including description, prompt, result type, validation information, etc.
Table Type: REFERENCE





Column Detail - ONLINE_ITEM_DEFINITION


Column Name Type Null? Definition
ACCEPT_SIZE DOUBLE Y The accept size for the input control
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 Background color of the prompt for the input field.
CATALOG_TYPE_MEANING VARCHAR(12) Y The CDF Meaning of the catalog type that should be used when the result type is "ORC Selection".
COMBINE_ALLOWED_IND DOUBLE Y An indicator of whether or not duplicate controls should be removed when forms are combined.
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_PRSNL_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
DECIMAL_DIGITS DOUBLE Y The number of places past the decimal to accept for numeric result types
DEF_COLUMN_HEADING VARCHAR(100) Y The default column heading to be used in the listview of repeating forms for this input control
DEF_UNIT_MEAS_CD DOUBLE N The default unit of measure to use for this input control, if applicable
DESCRIPTION VARCHAR(100) Y A description for the input control
DISPLAY VARCHAR(100) Y A textual display value for the input controlThis 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(100) Y A textual display value for the input control, 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 CHAR(50) Y Font to use for the text prompt of the input field.
FIELD_PROMPT VARCHAR(500) Y The prompt to use for this input control
FIELD_SIZE_FLAG DOUBLE Y The accept size of this field, i.e. small, medium, large, memo
FONTEFFECTS DOUBLE Y Effects such as italics, bold, underline, and strike through for the prompt for the input field.
FORECOLOR DOUBLE Y Color of the text of the prompt for the input field.
INCREMENT_VALUE DOUBLE Y The increment value to use for the spin control when the result type is numeric
MAX_VALUE DOUBLE Y The maximum value to be accepted for this input control
MIN_VALUE DOUBLE Y The minimum value to be accepted for this input control
MNEMONIC_TYPE_MEANING VARCHAR(12) Y The CDF Meaning of the mnemonic type that should be used when the result type is "ORC Selection".
MULTI_RESULT_ALLOWED_IND DOUBLE Y An indicator of whether or not multiple results may be documented when this control appears on an input form
ONLINE_ITEM_DEFINITION_ID DOUBLE N Online Item Definition ID. This column will uniquely identify a row in the table.
ONLINE_ITEM_VERSION_NBR DOUBLE N The version number associated with this input control
OPTION_BORDER_IND DOUBLE Y An indicator of whether or not a border should appear around option buttons and checkboxes
OVERRIDE_CONTROL_TYPE_FLAG DOUBLE Y An override value for the control type to be used for this input control (a default control type exists for each result type), i.e. Text Box, Combo Box, Option Buttons, etc.
POINTSIZE DOUBLE Y Size of the font of the text prompt for the input field.
PROMPT_HEIGHT DOUBLE Y Height of the text prompt for the input field.
PROMPT_LOCATION_IND DOUBLE Y Indicates where the prompt should appear; 0 = left of the control, 1= top of the control
PROMPT_WIDTH DOUBLE Y Width of the text prompt for the input field.
PROVIDER_PHYS_IND DOUBLE Y An indicator of whether or not only physicians should be displayed when the result type is "Provider"
REPEAT_IND DOUBLE Y An indicator of whether or not this is a repeating input control
REQUIRED_FLAG DOUBLE Y An indicator of whether or not this input control is required
RESTRICTED_IND DOUBLE Y An indicator of whether the user should be restricted to the list of available choices only, or allow free-text entry as well. If the control type is checkboxes or options buttons, and the restricted_ind = 0, then "Other" will be added as an option.
RESULT_FIELD_NAME VARCHAR(30) Y NOT CURRENTLY USED
RESULT_TYPE_CD DOUBLE N The result type associated with this input control, i.e. free text, date and time, inventory, provider, etc.
SIGNATURE_FLAG DOUBLE N Indicates if the segment allows or requires electronic signature (0 = does not allow or require signature, 1 = allows signature, 2 = requires signature)
STATIC_UNIT_IND DOUBLE Y An indicator of whether the unit of measure is read only (value=1) or appears as a modifiable combo box (value=0)
SYSTEM_DEFINED_FLAG DOUBLE Y An indicator of the source of definition for this input control, i.e. Form Builder-defined, SurgiNet-defined, DCP-defined
TASK_ASSAY_CD DOUBLE N A reference (foreign key) to the discrete_task_assay table indicating the discrete task assay for this input control. Also part of the composite primary key
UNIT_MEAS_IND DOUBLE Y An indicator of whether or not unit of measure should be display/accepted for this input control
UNPROCESSED_IND DOUBLE Y An indicator of whether or not this input control 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.
VALIDATION_CODESET DOUBLE Y The codeset to be used when validating this input control
VALIDATION_FIELD VARCHAR(30) Y The field to be used when validating this input control
VALIDATION_SCRIPT VARCHAR(50) Y The script to be used when validating this input control
VALIDATION_TABLE_NAME VARCHAR(30) Y The table to be used when validating this input control



Relationship Detail - ONLINE_ITEM_DEFINITION


Child Column in ONLINE_ITEM_DEFINITION(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD




Parent Column in ONLINE_ITEM_DEFINITION (PK) Child Table Name Child Column Name
Children: ONLINE_ITEM_VERSION_NBR GROUP_DEFINITION ONLINE_ITEM_VERSION_NBR
TASK_ASSAY_CD GROUP_DEFINITION TASK_ASSAY_CD
ONLINE_ITEM_VERSION_NBR INPUT_FORM_DEFINITION ONLINE_ITEM_VERSION_NBR
TASK_ASSAY_CD INPUT_FORM_DEFINITION TASK_ASSAY_CD
ONLINE_ITEM_VERSION_NBR ONLINE_ITEM_INVENTORY_CLASSES ONLINE_ITEM_VERSION_NBR
TASK_ASSAY_CD ONLINE_ITEM_INVENTORY_CLASSES TASK_ASSAY_CD


ONLINE_ITEM_INVENTORY_CLASSES



Column Section Relationship Section Top of Page


Table-level Detail

Description: the Online Item inventory class for the online items for the inventory control
Definition: Contains the Online Item inventory class for the online items for the inventory type controls
Table Type: REFERENCE





Column Detail - ONLINE_ITEM_INVENTORY_CLASSES


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 Y The person who caused the active_status_cd to be set or change.
CREATE_APPLCTX DOUBLE Y The application context number from the record info block.
CREATE_DT_TM DATETIME Y The created date and timeColumn
CREATE_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.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted the row.
ITEM_CLASS_NODE_ID DOUBLE Y The item class nodes of the items that the control needs to display
ONLINE_ITEM_DEFINITION_ID DOUBLE N Foreign Key value from the ONLINE_ITEM_DEFINITION table.
ONLINE_ITEM_VERSION_NBR DOUBLE Y The online item version numberColumn
TASK_ASSAY_CD DOUBLE Y A reference (foreign key) to the discrete_task_assay table indicating the discrete task assay for this input control. Also part of the composite primary 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 - ONLINE_ITEM_INVENTORY_CLASSES


Child Column in ONLINE_ITEM_INVENTORY_CLASSES(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