Table Detail Report
EEM_PROV_TAX_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Provider to taxonomy relationship |
Definition: | Relation from Provider (physician/org/service resource) to provider taxonomy |
Table Type: | REFERENCE |
Column Detail - EEM_PROV_TAX_RELTN
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. |
EEM_PROV_TAX_RELTN_ID | DOUBLE | N | Primary Key |
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. |
LONG_TEXT_ID | DOUBLE | N | Long Text Id used to store comments. |
PARENT_ENTITY_ID | DOUBLE | N | Primary Key of the Id. |
PARENT_ENTITY_NAME | VARCHAR(32) | Y | Parent Table for relation. |
SEQ_NBR | DOUBLE | N | Future Use. |
TAXONOMY_ID | DOUBLE | N | Taxonomy Id (NOMENCLATURE) |
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 - EEM_PROV_TAX_RELTN
Child Column in EEM_PROV_TAX_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
TAXONOMY_ID | PROVIDER_TAXONOMY | TAXONOMY_ID |
Parent Column in EEM_PROV_TAX_RELTN (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | EEM_PROV_TAX_RELTN_ID | EEM_ENTITY_PROV_TAX_RELTN | EEM_PROV_TAX_RELTN_ID |
EEM_PRSNL_LOC_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Personnel Location Relation |
Definition: | Personnel to Facility Association for Provider Networks |
Table Type: | REFERENCE |
Column Detail - EEM_PRSNL_LOC_RELTN
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. |
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. |
LOCATION_CD | DOUBLE | N | Location Code to be related to the PRSNL. |
LONG_TEXT_ID | DOUBLE | N | Long Text Id that holds a comment for this relation row |
NETWORK_ID | DOUBLE | N | Network Id |
NTWK_PRSNL_RELTN_ID | DOUBLE | N | Network Personnel Relation Identifier |
PRSNL_ID | DOUBLE | N | Foreign key back tot he PRSNL table. |
PRSNL_LOC_RELTN_ID | DOUBLE | N | The unique primary key of this 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. |
Relationship Detail - EEM_PRSNL_LOC_RELTN
Child Column in EEM_PRSNL_LOC_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | NETWORK_ID | EEM_NETWORK | NETWORK_ID |
LONG_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID | |
PRSNL_ID | PRSNL | PERSON_ID |
EEM_REVIEW_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Holds the relationship between review groups, health plans, and sponsors |
Definition: | EEM Review Relationship |
Table Type: | ACTIVITY |
Column Detail - EEM_REVIEW_RELTN
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. |
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. |
ORGANIZATION_ID | DOUBLE | N | This is the value of the unique primary identifier of the organization table. It is an internal system assigned number |
PARENT_ENTITY_ID | DOUBLE | N | The value of the primary identifier of the table to which the address row is related (i.e., person_id, organization_id, etc.) |
PARENT_ENTITY_NAME | VARCHAR(30) | Y | The upper case name of the table to which this address row is related (i.e., PERSON, PRSNL, ORGANIZATION, etc.) |
REVIEW_RELTN_ID | DOUBLE | N | Sequence Generated Primary Key for the table. |
SEQ_NBR | DOUBLE | N | Determines the order among the children of a group. |
SPECIALTY_CD | DOUBLE | N | EEM Medical Review Specialties |
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 - EEM_REVIEW_RELTN
Child Column in EEM_REVIEW_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SPECIALTY_CD | CODE_VALUE | CODE_VALUE |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |
EEM_SERVICE_LIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | EEM Service List |
Definition: | EEM Service List |
Table Type: | REFERENCE |
Column Detail - EEM_SERVICE_LIST
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. |
CAUSE_BEG_IDENT | VARCHAR(50) | Y | Nomenclature Source Identifier |
CAUSE_BEG_NOMEN_ID | DOUBLE | N | Nomenclature Identifier. |
CAUSE_END_IDENT | VARCHAR(50) | Y | Nomenclature Source Identifier |
CAUSE_END_NOMEN_ID | DOUBLE | N | Nomenclature Identifier. |
CAUSE_INC_EXC_CD | DOUBLE | N | Include/Exclude Code |
CAUSE_INC_EXC_MEANING | VARCHAR(12) | Y | Include/Exclude Meaning |
CAUSE_VOCAB_CD | DOUBLE | N | Vocabulary 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. |
SEQ_NBR | DOUBLE | N | Determines the order among the children of a group. |
SERVICE_LIST_ID | DOUBLE | N | Service List Identifier |
SERVICE_TYPE_ID | DOUBLE | N | Service Type Identifier |
TYPE_BEG_IDENT | VARCHAR(50) | Y | Nomenclature Source Identifier |
TYPE_BEG_NOMEN_ID | DOUBLE | N | Nomenclature Identifier |
TYPE_END_IDENT | VARCHAR(50) | Y | Nomenclature Source Identifier |
TYPE_END_NOMEN_ID | DOUBLE | N | Nomenclature Identifier. |
TYPE_INC_EXC_CD | DOUBLE | N | Include/Exclude Code |
TYPE_INC_EXC_MEANING | VARCHAR(12) | Y | Include/Exclude Meaning |
TYPE_VOCAB_CD | DOUBLE | N | Vocabulary Code |
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 - EEM_SERVICE_LIST
Child Column in EEM_SERVICE_LIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SERVICE_TYPE_ID | EEM_SERVICE_TYPE | SERVICE_TYPE_ID |
CAUSE_BEG_NOMEN_ID | NOMENCLATURE | NOMENCLATURE_ID | |
CAUSE_END_NOMEN_ID | NOMENCLATURE | NOMENCLATURE_ID | |
TYPE_BEG_NOMEN_ID | NOMENCLATURE | NOMENCLATURE_ID | |
TYPE_END_NOMEN_ID | NOMENCLATURE | NOMENCLATURE_ID |
EEM_SERVICE_TYPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | EEM Service Types |
Definition: | EEM Service Types |
Table Type: | REFERENCE |
Column Detail - EEM_SERVICE_TYPE
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. |
DESCRIPTION | VARCHAR(200) | Y | A long description used for documentation. |
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. |
LONG_TEXT_ID | DOUBLE | N | Primary Key to LONG_TEXT/LONG_TEXT_REFERENCE table |
PARENT_ENTITY_ID | DOUBLE | N | Primary Key of the Parent Row |
PARENT_ENTITY_NAME | VARCHAR(32) | Y | Name of the Parent Entity |
SEQ_NBR | DOUBLE | Y | Determines the order among the children of a group. |
SERVICE_TYPE_CD | DOUBLE | N | Service Type Code |
SERVICE_TYPE_ID | DOUBLE | N | Service Type 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 - EEM_SERVICE_TYPE
Child Column in EEM_SERVICE_TYPE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
Parent Column in EEM_SERVICE_TYPE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SERVICE_TYPE_ID | EEM_SERVICE_LIST | SERVICE_TYPE_ID |