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 |