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 |