EFFILE: EMPLOYEE BENEFIT RECORDS

ElementElement NameTableSQL Name
EFAACUSER IDEFEHTSCORP
EFAADIDENTIFICATION NUMBREFEHTSEMP_ID
EFAAEEMP PLAN TYPEEFEHTSPLAN_TYPE
EFAAFEMP COV START DATEEFEHTSCOVER_BGN_DT
EFAAMEMP PLAN CODEEFEHTSPLAN_CODE
EFAANEMP COVERAGE CODEEFEHTSCOVERAGE
EFAAOEMP JOB CODEEFEHTSJOB
EFSLAEMPH REF IDEFEHTSREF_ID
EFSLBEMPH ACTN AMTEFEHTSACTN_AMT
EFSLCEMPH ACTN GOALEFEHTSACTN_GOAL
EFSLDEMPH ACTN ARREFEHTSACTN_ARREARS
EFSLEEMPH DED NOT TAKENEFEHTSNOT_TAK
EFSLFEMPH AMOUNT PERCENTEFEHTSAMT
EFSLGEMPH GOALEFEHTSGOAL
EFSLHEMPH GOAL PAIDEFEHTSGOAL_PD
EFSLIEMPH ARREARSEFEHTSARREARS
EFSLJEMPH PAY START DATEEFEHTSPAY_BGN_DT
EFSLQEMPH PAY END DATEEFEHTSPAY_END_DT
EFSLWEMPH COV END DATEEFEHTSCOVER_END_DT
EFSMBEMPH CURRENT INDEFEHTSCURRENT_IND
EFSMCEMPH APPROVAL INDEFEHTSAPPROVAL_IND
EFSMDEMPH SHELTER INDICATEFEHTSSHELT_IND
EFSMEEMPH CURRENTEFEHTSAMT_CURR
EFSMFEMPH MTDEFEHTSAMT_MTD
EFSMGEMPH QTDEFEHTSAMT_QTD
EFSMHEMPH FYTDEFEHTSAMT_FYTD
EFSMIEMPH CYTDEFEHTSAMT_YTD
EFSMJEMPH RTDEFEHTSAMT_RTD
EFSMKEMPH PRIOR QTDEFEHTSAMT_PRIOR_QUAR
EFSMLEMPH PRIOR YTDEFEHTSAMT_PRIOR_YR
EFSMMEMPH LAST ACT DATEEFEHTSLAST_ACT_DT
EFSMNEMPH LAST ACT CODEEFEHTSLAST_ACT_CD
EFSMOEMPH PRIOR MOEFEHTSAMT_PRIOR_MO
EFSMPEMPH PRIOR FYREFEHTSAMT_PRIOR_FY

©1999 All Rights Reserved