Table Detail Report

EEM_BENEFIT_ALLOC



Column Section Relationship Section Top of Page


Table-level Detail

Description: eem benefit allocation
Definition: eem benefit allocation table
Table Type: ACTIVITY





Column Detail - EEM_BENEFIT_ALLOC


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.
BENEFIT_ALLOC_ID DOUBLE N unique key to eem_benefit_alloc table
EEM_BENEFIT_ID DOUBLE N benefit allocated
ENCNTR_ID DOUBLE N encounter identifier value
ENCNTR_SLICE_ID DOUBLE N Identifies an Encounter as it relates to a time slice.
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.
FINALIZED_DT_TM DATETIME Y finalized date and time
HEALTH_PLAN_ID DOUBLE N This is the value of the unique primary identifier of the health plan table. It is an internal system assigned number.
MADE_BY_ID DOUBLE N made by identifier
MAN_ALLOC_REQ_IND DOUBLE N manual allocation request indicator will be set to 1 if the row needs to be manually allocated.
NCA_IND DOUBLE N Non-Contracted Activity indicator will be set to 1 if no contract is found or if no benefit qualified for the contract.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
STATE_CD DOUBLE N state code value
SVC_CAT_HIST_ID DOUBLE N service category history identifier column
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.



Relationship Detail - EEM_BENEFIT_ALLOC


Child Column in EEM_BENEFIT_ALLOC(FK) Parent Table Name Parent Column Name
Parents: EEM_BENEFIT_ID EEM_BENEFIT EEM_BENEFIT_ID
ENCNTR_SLICE_ID ENCNTR_SLICE ENCNTR_SLICE_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
MADE_BY_ID PRSNL PERSON_ID
SVC_CAT_HIST_ID SERVICE_CATEGORY_HIST SVC_CAT_HIST_ID


EEM_BENEFIT_PLAN



Column Section Relationship Section Top of Page


Table-level Detail

Description: EEM Benefit Plan
Definition: Used to store benefit plan information for health plans (and optional sponsor)
Table Type: REFERENCE





Column Detail - EEM_BENEFIT_PLAN


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.
BENEFIT_PLAN_CD DOUBLE N Benefit Plan Code
BENEFIT_PLAN_ID DOUBLE N Benefit Plan Identifier
CONTRACT_CODE VARCHAR(100) Y Contract Code
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_REFERENCE table
OPTIONAL_CD DOUBLE N Denotes if the benefit plan is basic or optional coverage
PARENT_ENTITY_ID DOUBLE N Primary Key of the Parent Row
PARENT_ENTITY_NAME VARCHAR(30) Y Name of the Parent Entity
SEQ_NBR DOUBLE N Determines the order among the children of a group.
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_BENEFIT_PLAN


Child Column in EEM_BENEFIT_PLAN(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID


EEM_BENEFIT_QUAL



Column Section Relationship Section Top of Page


Table-level Detail

Description: EEM Benefit Qualifier
Definition: EEM Benefit Qualifier
Table Type: REFERENCE





Column Detail - EEM_BENEFIT_QUAL


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.
BEG_IDENT VARCHAR(50) Y Nomenclature Source Identifier
BEG_NOMEN_ID DOUBLE N Nomenclature Identifier
BENEFIT_ID DOUBLE N EEM BenefitIdentifier
BENEFIT_QUAL_ID DOUBLE N Benefit Qualifier Identifier
DATA_TYPE_CD DOUBLE N A unique identifier for the Data Type Code.
DATE_VALUE DATETIME Y Date Value
DOUBLE_VALUE DOUBLE N Double Value
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.
END_IDENT VARCHAR(50) Y Nomenclature Source Identifier
END_NOMEN_ID DOUBLE N Nomenclature Identifier
FROM_UNITS DOUBLE N From Units
FROM_UNITS_CD DOUBLE N Units Of Measure Code
INC_EXC_CD DOUBLE N Include/Exclude Code
INC_EXC_MEANING VARCHAR(12) Y Include/Exclude Meaning
LONG_TEXT_ID DOUBLE N Primary Key to LONG_TEXT_REFERENCE table
PARENT_ENTITY_ID DOUBLE N Primary Key of the Parent Row
PARENT_ENTITY_NAME VARCHAR(30) Y Name of the Parent Entity
QUALIFIER_CD DOUBLE N Benefit Qualifier Code
SEQ_NBR DOUBLE N Determines the order among the children of a group.
STRING_VALUE VARCHAR(255) Y String Value
TO_UNITS DOUBLE N To Units
TO_UNITS_CD DOUBLE N Units Of Measure 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.
VOCABULARY_CD DOUBLE N Nomenclature Vocabulary Code



Relationship Detail - EEM_BENEFIT_QUAL


Child Column in EEM_BENEFIT_QUAL(FK) Parent Table Name Parent Column Name
Parents: BENEFIT_ID EEM_BENEFIT EEM_BENEFIT_ID
LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
BEG_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
END_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID


EEM_BENEFIT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: EEM Benefit Relationship
Definition: EEM Benefit Relationship
Table Type: REFERENCE





Column Detail - EEM_BENEFIT_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_BENEFIT_ID DOUBLE N EEM Benefit Identifier
EEM_BENEFIT_RELTN_ID DOUBLE N EEM Benefit Relationship Identifier
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.
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 N Determines the order among the children of a group.
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_BENEFIT_RELTN


Child Column in EEM_BENEFIT_RELTN(FK) Parent Table Name Parent Column Name
Parents: EEM_BENEFIT_ID EEM_BENEFIT EEM_BENEFIT_ID