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 |