Table Detail Report

OSM_FORM_GROUPS



Column Section Relationship Section Top of Page


Table-level Detail

Description: OSM FORM GROUPS
Definition: Table used to store specific grouping id's for Forms
Table Type: REFERENCE





Column Detail - OSM_FORM_GROUPS


Column Name Type Null? Definition
GROUP_DESCRIPTION VARCHAR(100) Y Name or description of group
GROUP_ID DOUBLE N Unique Id for grouping for Form
OSM_FORM_ID DOUBLE N Unique Form identifier
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 - OSM_FORM_GROUPS


Child Column in OSM_FORM_GROUPS(FK) Parent Table Name Parent Column Name
Parents: OSM_FORM_ID OSM_FORM OSM_FORM_ID




Parent Column in OSM_FORM_GROUPS (PK) Child Table Name Child Column Name
Children: GROUP_ID OSM_FORM_GROUP_VALUES GROUP_ID
OSM_FORM_ORG_GRP_XREF GROUP_ID


OSM_FORM_GROUP_VALUES



Column Section Relationship Section Top of Page


Table-level Detail

Description: OSM FORM GROUP VALUES
Definition: Table used to store id's of actual information for given forms.
Table Type: REFERENCE





Column Detail - OSM_FORM_GROUP_VALUES


Column Name Type Null? Definition
FORM_FIELD_ID DOUBLE N Unique Id for different types of fields specific to a form
GROUP_ID DOUBLE N Unique Id for a Form Group
PARENT_ENTITY_ID DOUBLE N Unique Id for the actual information for the form that comes from the Parent_Entity_Name table
PARENT_ENTITY_NAME VARCHAR(40) Y Table where Parent_Entity_Name belongs
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 - OSM_FORM_GROUP_VALUES


Child Column in OSM_FORM_GROUP_VALUES(FK) Parent Table Name Parent Column Name
Parents: FORM_FIELD_ID OSM_FORM_FIELDS FORM_FIELD_ID
GROUP_ID OSM_FORM_GROUPS GROUP_ID


OSM_FORM_ORG_GRP_XREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: OSM FORM ORG GRP XREF
Definition: Cross Reference table for the Group and Form Table
Table Type: REFERENCE





Column Detail - OSM_FORM_ORG_GRP_XREF


Column Name Type Null? Definition
GROUP_ID DOUBLE N Unique Group Identifier
LOCATION_CD DOUBLE N Organization Location identifier
ORGANIZATION_ID DOUBLE N Unique Organization Id
OSM_FORM_ID DOUBLE N Unique Form Specific Id
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 - OSM_FORM_ORG_GRP_XREF


Child Column in OSM_FORM_ORG_GRP_XREF(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
OSM_FORM_ID OSM_FORM OSM_FORM_ID
GROUP_ID OSM_FORM_GROUPS GROUP_ID


OSM_FORM_PRINTING



Column Section Relationship Section Top of Page


Table-level Detail

Description: OSM FORM PRINTING
Definition: Contains records of forms that an user can print.
Table Type: REFERENCE





Column Detail - OSM_FORM_PRINTING


Column Name Type Null? Definition
LAST_PRINT_DT_TM DATETIME Y Last date and time form was printed
LAST_PRINT_NUMBER DOUBLE N Last number from requisition bucket to be printed.
LOCATION_CD DOUBLE N Organization Location code_value
NUMBER_COPIES DOUBLE N Number of forms that was last printed.
ORGANIZATION_ID DOUBLE N Organization Id for specific form
OSM_FORM_ID DOUBLE N Unique Id for a form
PRINT_IND DOUBLE N Print Indicator for running operation jobs
THRESHOLD DOUBLE N How low requisition numbers will go before new forms will be printed.
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 - OSM_FORM_PRINTING


Child Column in OSM_FORM_PRINTING(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
OSM_FORM_ID OSM_FORM OSM_FORM_ID


OSM_INSURANCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains OSM insurance information.
Definition: OSM Insurance.
Table Type: ACTIVITY





Column Detail - OSM_INSURANCE


Column Name Type Null? Definition
ADDITIONAL_INFO VARCHAR(30) Y This is the free text field to store the additional information of OSM insurance.
ENCOUNTER_ID DOUBLE N This is the foreign key to the Encounter table.
FINANCIAL_CLASS VARCHAR(30) Y This is string that contains financial class.
GROUP_NAME VARCHAR(30) Y This is the insurance group name.
GROUP_NBR VARCHAR(15) Y This is the insurance group number.
HEALTH_PLAN VARCHAR(30) Y This is the health plan name.
INSURANCE_COMPANY VARCHAR(30) Y This is the insurance company name.
MEMBER_NBR VARCHAR(15) Y This is the insurance membership number.
POLICY_NBR VARCHAR(15) Y This is the Policy Number.
PRIORITY_SEQ DOUBLE N This is the insurance priority sequence, such as primary, and secondary.
SPONSOR_ID DOUBLE N This field contains the identifier of the organization that is sponsoring the health plan.
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 - OSM_INSURANCE


Child Column in OSM_INSURANCE(FK) Parent Table Name Parent Column Name
Parents: SPONSOR_ID ORGANIZATION ORGANIZATION_ID