Table Detail Report

OSM_CLIENT_DEFAULTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Outreach Services Client Defaults
Definition: Stores default values for each cleint to determine process flow in Requisition Order Entry and PathLink..
Table Type: REFERENCE





Column Detail - OSM_CLIENT_DEFAULTS


Column Name Type Null? Definition
ADMITTING_PHYS_ID DOUBLE N The person id of the admitting physician.
ALIAS_POOL_CD DOUBLE N This determines the default alias pool for display in Requisition Order Entry.
ALIAS_TYPE_CD DOUBLE N This determines the default alias for display in Requisition Order Entry.
BILL_TYPE_FLAG DOUBLE Y This determines the default BILL TYPE for display in Requisition Order Entry.
BILL_TYPE_IND DOUBLE Y This determines the default BILL TYPE for display in Requisition Order Entry. [0 = Client, 1= Patient]
CLIENT_BILL_ENCNTR_TYPE_CD DOUBLE N This determines the default ENCNTR TYPE for display in Requisition Order Entry.
CLIENT_BILL_FIN_CLASS_CD DOUBLE N This determines the default financial class for display in Requisition Order Entry.
CMRN_OPTION_FLAG DOUBLE N This setting determines how the Community Medical record Number will be assigned for the patient in Osm's Requisition Order Entry.
COLLECTION_PRIORITY_CD DOUBLE N This determines the default collection priority in Requisition Order Entry.
COLLECT_BY_PERSON_ID DOUBLE N This determines the default COLLECTED PERSON ID for display in Requisition Order Entry.
COLLECT_BY_USER_IND DOUBLE Y This determines if default Collected By is displayed in Requisition Order Entry.[0 - not using current sign on user, 1 - use current sign on user]
CURDATE_IND DOUBLE Y This determines if default CURRENT DATE is displayed in Requisition Order Entry.[0 - no, 1 -yes]
CURTIME_IND DOUBLE Y This determines if default CURRENT TIME is displayed in Requisition Order Entry.[0 - no, 1 -yes]
ENCOUNTER_TYPE_FLAG DOUBLE Y This determines the default ENCOUNTER TYPE for display in Requisition Order Entry.
FINANCIAL_CLASS_CD DOUBLE N This determines the default FINANCIAL CLASS for display in Requisition Order Entry. ************This field is not being used***************************
FINANCIAL_CLASS_FLAG DOUBLE Y This determines the default FINANCIAL CLASS requirements in Requisition Order Entry.
FINANCIAL_NUMBER_OPTION_FLAG DOUBLE Y This determines financial number assignment in Requisition Order Entry.
FLEX_REG_FLAG DOUBLE Y This determines the flex registration in Requisition Order Entry.
FLEX_REG_IND DOUBLE Y This determines the default use of FLEX REG for Requisition Order Entry. [0 = NO, 1 = YES] *************This field is not being used******************************
LOCATION_FLAG DOUBLE Y This determines what type of location to show on OSMClientLookup OCX.
MRN_OPTION_FLAG DOUBLE Y This determines how MRN is going to be assigned in Requisition Order Entry.
NEW_MRN_FLAG DOUBLE Y This determines whether to create a new MRN or not in Requisition Order Entry.
NEW_REG_FLAG DOUBLE Y This determines how search returns in Requisition Order Entry.
ORGANIZATION_ID DOUBLE N Organization id is the key to the table, which identifies the client for which these defaults will be used.
PATIENT_ALIAS_FLAG DOUBLE Y This determines the default action for PATIENT ALIAS in Requisition Order Entry.
PATIENT_BILL_ENCNTR_TYPE_CD DOUBLE N This determines the default PATIENT BILL ENCNTR TYPE for display in Requisition Order Entry.
PATIENT_BILL_FIN_CLASS_CD DOUBLE N This determines the patient bill financial class in Requisition Order Entry.
PHONE_TYPE_CD DOUBLE N This determines the default PHONE TYPE for display in Requisition Order Entry for callback phone numbers.
PRI_INS_SUB_HP_FLAG DOUBLE Y This determines if the primary insurance company, subscriber, and health plan fields are required.
PRI_SPONSOR_FLAG DOUBLE Y This determines if sponsor is required for primary insurance.
PROCEDURE_VIEW_FLAG DOUBLE Y This determines the default View of procedures for display in Requisition Order Entry.
PROV_HLTH_NBR_FLAG DOUBLE N Require provincial health number based on bill type.0 - Required for neither 1 - Required for client bill2 - Required for patient bill3 - Required for both4 - Disabled for both5 - Disabled for client bill6 - Disabled for patient bill
REV_CYCLE_CONV_DTL_TXT VARCHAR(2000) Y Contains the action keys used for the reveneue cycle registration conversation.
RPT_PRIORITY_CD DOUBLE N This determines the default REPORT PRIORITY for display in Requisition Order Entry.
SEARCH_START_FLAG DOUBLE Y This determines the default field used for searching in Requisition Order Entry.
SUB_MEMBER_NBR_FLAG DOUBLE N Require subscriber member number based on bill type. 0 Required for neither 1 Required for client bill 2 Required for patient bill 3 Required for both 4 Disabled for both 5 Disabled for client bill 6 Disabled for patient bill
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VETERNARY_IND DOUBLE Y This determines the default used to determine if VETERNARY testing is performed for this client for display in Requisition Order Entry.



Relationship Detail - OSM_CLIENT_DEFAULTS


Child Column in OSM_CLIENT_DEFAULTS(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
ADMITTING_PHYS_ID PRSNL PERSON_ID
COLLECT_BY_PERSON_ID PRSNL PERSON_ID


OSM_DEFAULTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: OSM DEFAULTS
Definition: Outreach Services Managment Defaults
Table Type: REFERENCE





Column Detail - OSM_DEFAULTS


Column Name Type Null? Definition
AGE_FLAG DOUBLE Y This determines if AGE is required in Requisition Order Entry.
BIRTH_DATE_FLAG DOUBLE Y This determines if BIRTHDATE is required in Requisition Order Entry.
BIRTH_TIME_FLAG DOUBLE Y This determines if BIRTH TIME is required in Requisition Order Entry.
DFLT_HP_ADDR_TYPE_CD DOUBLE N Address type that should be automatically selected for the selected health plan.
DX_FLAG DOUBLE Y This determines if DIAGNOSIS is required in Requisition Order Entry.
EEM_ABN_CHECK_IND DOUBLE Y Determines if EEM ABN checking will be used.
FINANCIAL_ASSIGNMENT_FLAG DOUBLE Y Indicator flag to determine financial assessibility.
FINANCIAL_NUMBER_FLAG DOUBLE Y This determines if FINANCIAL NUMBER is required in Requisition Order Entry.
FIRST_NAME_FLAG DOUBLE Y This determines if FIRST NAME is required in Requisition Order Entry.
LAB_ORG_ID DOUBLE N The default organization of the laboratory. Used for printing laboratory name and address on reports.
LANGUAGE_FLAG DOUBLE Y This determines if LANGUAGE is required in Requisition Order Entry.
MIDDLE_NAME_FLAG DOUBLE Y This determines if MIDDLE NAME is required in Requisition Order Entry.
ORDER_COMMENT_FLAG DOUBLE Y This determines what ORDER COMMENT type(s) are available in Requisition Order Entry.
ORDER_DONOR_PRODUCT_IND DOUBLE Y This determines if ORDERs of DONOR or PRODUCTS is allowed in Requisition Order Entry. [0 - no, 1- yes]
PHONE_FLAG DOUBLE Y This determines if PHONE is required in Requisition Order Entry.
PHYS_ALIAS_TYPE_CD DOUBLE N Physician alias type code from code set 320.
PHYS_FILTERED_ALIAS_IND DOUBLE Y Physician filtered alias indicator. This setting is no longer used.
PHYS_ORG_FILTER_IND DOUBLE Y This determines if PHYSICIANS are filter by client in Requisition Order Entry. AGE required? [0 = no,1 = yes]
RACE_FLAG DOUBLE Y This determines if RACE is required in Requisition Order Entry.
REG_CONTRIBUTOR_SYSTEM_CD DOUBLE N This determines the CONTRIBUTOR SYSTEM for encounter match and tag in Requisition Order Entry.
REQUISITION_IND DOUBLE Y This determines if REQUISITION NUMBER is USED in Requisition Order Entry. [0 - no,1 - yes]
ROE_ADDON_LIMIT_DAYS DOUBLE Y The limited days of which will allow ROE to load orders for addon.
ROE_CANCEL_ORDER VARCHAR(100) Y The default setting for cancel orders in ROE.
ROE_DEMOGRAPHICS VARCHAR(100) Y Requisition Order Entry patient demographics.
ROE_DUAL_ORDER VARCHAR(100) Y This stores Requisition Order Entry ordered procedures for dual entry.
ROE_DUAL_REGISTRATION VARCHAR(100) Y This stores Requisition Order Entry ordered procedures for dual entry registration.
ROE_ENCNTR_SEARCH VARCHAR(100) Y Requisition Order Entry Encounter Alias Search Default.
ROE_MODIFY_ORDER VARCHAR(100) Y This stores modified Requisition Order Entry ordered procedures.
ROE_MODIFY_REGISTRATION VARCHAR(100) Y This stores modified Requisition Order Entry ordered procedures for registration.
SEX_FLAG DOUBLE Y This determines if SEX is required in Requisition Order Entry.
SSN_FLAG DOUBLE Y This determines if SOCIAL SECURITY NUMBER is required in Requisition Order Entry.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VOC_IND DOUBLE N Flag to enable VOC use in OSM Requisition Order Entry. 0 = disabled 1 = enabled



Relationship Detail - OSM_DEFAULTS


Child Column in OSM_DEFAULTS(FK) Parent Table Name Parent Column Name
Parents: LAB_ORG_ID ORGANIZATION ORGANIZATION_ID


OSM_FORM



Column Section Relationship Section Top of Page


Table-level Detail

Description: OSM FORM
Definition: Table used to store forms created by the user, usually requisition forms.
Table Type: REFERENCE





Column Detail - OSM_FORM


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.
DESCRIPTION VARCHAR(100) Y Name or description of Form
MAX_COL DOUBLE Y Maximum Columns allowed for form
MAX_ROW DOUBLE N Maximum Rows allowed for Form
OSM_FORM_ID DOUBLE N Unique Id used for each Form
SORT_DIR_FLAG DOUBLE N Contains the direction of the sort.1 - Ascending2 - Descending0 - No Sort
SORT_FIELD_TYPE_CD DOUBLE N Contains which field type will be used for sorting, 0 for no sort.
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




Parent Column in OSM_FORM (PK) Child Table Name Child Column Name
Children: OSM_FORM_ID OSM_FORM_GROUPS OSM_FORM_ID
OSM_FORM_ORG_GRP_XREF OSM_FORM_ID
OSM_FORM_PRINTING OSM_FORM_ID


OSM_FORM_CLIENT_VALUES



Column Section Relationship Section Top of Page


Table-level Detail

Description: OSM FORM CLIENT VALUES
Definition: Table used to store the Id's of the actual information used on the Form.
Table Type: REFERENCE





Column Detail - OSM_FORM_CLIENT_VALUES


Column Name Type Null? Definition
FORM_FIELD_ID DOUBLE N Unique field id for different types of fields specific to form
LOCATION_CD DOUBLE N Organization Location code_value
ORGANIZATION_ID DOUBLE N Organization Id for specific client value
PARENT_ENTITY_ID DOUBLE N Id of record from the Parent_Entity_Name
PARENT_ENTITY_NAME VARCHAR(40) Y Name of Table where Parent_Entity_Id is found
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_CLIENT_VALUES


Child Column in OSM_FORM_CLIENT_VALUES(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
FORM_FIELD_ID OSM_FORM_FIELDS FORM_FIELD_ID


OSM_FORM_FIELDS



Column Section Relationship Section Top of Page


Table-level Detail

Description: OSM FORM FIELDS
Definition: Table used to store unique fields of different types for a specific Form.
Table Type: REFERENCE





Column Detail - OSM_FORM_FIELDS


Column Name Type Null? Definition
DISP_LEN DOUBLE Y User defined length a given field has to fill
FIELD_COL DOUBLE N Column where field starts
FIELD_ROW DOUBLE N Row where field starts
FORM_FIELD_ID DOUBLE N Unique Id used for different types of fields for a specific forms
OSM_FIELD_TYPE_CD DOUBLE N Type of Field used by the Form
OSM_FORM_ID DOUBLE N Unique Form Id form OSM_FORM table
TEXT VARCHAR(100) Y Form specific text entered by user
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.
VALUE_GROUP_NBR DOUBLE N This field identifies the set of fields on the form to which the field belongs and the position of that set of fields on the form.
VALUE_SEQ_NBR DOUBLE N This field identifies the sequence that values will be filled within a group and the fields with the same sequence that will share a value.



Relationship Detail - OSM_FORM_FIELDS




Parent Column in OSM_FORM_FIELDS (PK) Child Table Name Child Column Name
Children: FORM_FIELD_ID OSM_FORM_CLIENT_VALUES FORM_FIELD_ID
OSM_FORM_GROUP_VALUES FORM_FIELD_ID