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