Table Detail Report

OSM_INSURANCE_ADDRESS



Column Section Top of Page


Table-level Detail

Description: OSM Insurance Address
Definition: The osm_insurance_address table contains the person, employer and the insurance addresses.
Table Type: ACTIVITY





Column Detail - OSM_INSURANCE_ADDRESS


Column Name Type Null? Definition
ADDITIONAL_INFO VARCHAR(30) Y This is a free text field that contains additional osm insurance address information.
ADDRESS VARCHAR(20) Y This contains the address of the person, address, or insurance.
CITY VARCHAR(15) Y The city field is the text name of the city associated with the address row.
HOME_PHONE VARCHAR(20) Y This is the home phone number.
OSM_INSURANCE_RELTN_ID DOUBLE N This is the primary key of osm_insurance_address table.
STATE VARCHAR(2) Y The state field is the text name of the state or province associated with the address row.
TYPE_FLAG DOUBLE N This is the flag that indicate the address type of person, employer or insurance.
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.
WORK_PHONE VARCHAR(20) Y This is the work phone number.
ZIP VARCHAR(10) Y This field contains the postal code for the street address in the address row.


OSM_INSURANCE_RELTN



Column Section Top of Page


Table-level Detail

Description: osm insurance relation table
Definition: This table contains the relationship between osm_insurance table and osm_insurance_address table.
Table Type: ACTIVITY





Column Detail - OSM_INSURANCE_RELTN


Column Name Type Null? Definition
EMPLOYER_NAME VARCHAR(100) Y This is the employer name of the insured person.
ENCOUNTER_ID DOUBLE N This is the foreign key to the Encounter table.
OSM_INSURANCE_RELTN_ID DOUBLE N This insurance relation id is used to relate the OSM_Insurance table and the OSM_Insurance_address table.
PERSON_ID DOUBLE N This column is no longer used.
PERSON_NAME VARCHAR(100) Y Name of the person involved in this OSM Insurance Relationship.
PRIORITY_SEQ DOUBLE N This is the insurance priority sequence.
RELATION VARCHAR(15) Y This describes the relationship between the insured person and the dependent.
SSN VARCHAR(15) Y This is the social security number.
TYPE_FLAG DOUBLE N This is the insurance type flag.
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.


OSM_ORG_XREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: OSM ORG XREF
Definition: Currently used cross reference organizations with requisition buckets.
Table Type: REFERENCE





Column Detail - OSM_ORG_XREF


Column Name Type Null? Definition
ORGANIZATION_ID DOUBLE N Unique identifier for Organization from organization table.
PARENT_ENTITY_ID DOUBLE N Unique Identifier from table names in Parent_Entity_Name Field.
PARENT_ENTITY_NAME VARCHAR(32) N Table name where Parent_Entity_Id resides.
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_ORG_XREF


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


OSM_PHYS_PROC_XREF



Column Section Top of Page


Table-level Detail

Description: osm physician procedure cross reference table
Definition: This table stores the excluded procedures that each physician can order.
Table Type: REFERENCE





Column Detail - OSM_PHYS_PROC_XREF


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_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, 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.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CATALOG_CD DOUBLE N This is the catalog code.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
INCLUDE_IND DOUBLE Y This is the indicator of whether the procedure is included. 0 is excluded.
PHYSICIAN_ID DOUBLE N This is the physician id.
PHYS_PROC_XREF_ID DOUBLE N This is the primary key of osm_phys_proc_xref table.
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.


PL_CATALOG_SEGMENTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: PL CATALOG SEGMENTS
Definition: Stores procedure catalog segments specific to organization and orderable.
Table Type: REFERENCE





Column Detail - PL_CATALOG_SEGMENTS


Column Name Type Null? Definition
ACTIVE_DATA_IND DOUBLE N Indicator used to determine if the data stored in SEGMENT_DATA_ID is active.
ACTIVE_IND DOUBLE N 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.
ORGANIZATION_ID DOUBLE N Unique identifier from the Organization table.
SEGMENT_DATA_ID DOUBLE N Unique identifier to the LONG_BLOB table used to store segment data.
SEGMENT_ID DOUBLE N Unique identifier for this table.
SEGMENT_LABEL VARCHAR(60) Y Non-HTML representation of segment label.
SEGMENT_LABEL_ID DOUBLE N Unique identifier to LONG_TEXT table used to store HTML representation of segment label.
SEGMENT_TYPE_CD DOUBLE N Segment type associated with a specific segment. Code set 2225.
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 - PL_CATALOG_SEGMENTS


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




Parent Column in PL_CATALOG_SEGMENTS (PK) Child Table Name Child Column Name
Children: SEGMENT_ID PL_SEG_CAT_CD_XREF SEGMENT_ID