EFFILE: EMPLOYEE BENEFIT RECORDS

ElementElement NameTableSQL Name
EFAACUSER IDEFEBTSCORP
EFAADIDENTIFICATION NUMBREFEBTSEMP_ID
EFAAEEMP PLAN TYPEEFEBTSPLAN_TYPE
EFAAFEMP COV START DATEEFEBTSCOVER_BGN_DT
EFAAMEMP PLAN CODEEFEBTSPLAN_CODE
EFAANEMP COVERAGE CODEEFEBTSCOVERAGE
EFAAOEMP JOB CODEEFEBTSJOB
EFABAEMP REF IDEFEBTSREF_ID
EFABBEMP ACTN AMTEFEBTSACTN_AMT
EFABCEMP ACTN GOALEFEBTSACTN_GOAL
EFABDEMP ACTN ARREFEBTSACTN_ARREARS
EFABEEMP DED NOT TAKENEFEBTSNOT_TAK
EFABFEMP AMOUNT PERCENTEFEBTSAMT
EFABGEMP GOALEFEBTSGOAL
EFABHEMP GOAL PAIDEFEBTSGOAL_PD
EFABIEMP ARREARSEFEBTSARREARS
EFABJEMP PAY START DATEEFEBTSPAY_BGN_DT
EFABQEMP PAY END DATEEFEBTSPAY_END_DT
EFABWEMP COV END DATEEFEBTSCOVER_END_DT
EFACBEMP CURRENT INDEFEBTSCURRENT_IND
EFACCEMP APPROVAL INDEFEBTSAPPROVAL_IND
EFACDEMP SHELTER INDICATOEFEBTSSHELT_IND
EFACEEMP CURRENTEFEBTSAMT_CURR
EFACFEMP MTDEFEBTSAMT_MTD
EFACGEMP QTDEFEBTSAMT_QTD
EFACHEMP FYTDEFEBTSAMT_FYTD
EFACIEMP CYTDEFEBTSAMT_YTD
EFACJEMP RTDEFEBTSAMT_RTD
EFACKEMP PRIOR QTDEFEBTSAMT_PRIOR_QUAR
EFACLEMP PRIOR YTDEFEBTSAMT_PRIOR_YR
EFACMEMP LAST ACT DATEEFEBTSLAST_ACT_DT
EFACNEMP LAST ACT CODEEFEBTSLAST_ACT_CD
EFACOEMP PRIOR MOEFEBTSAMT_PRIOR_MO
EFACPEMP PRIOR FYREFEBTSAMT_PRIOR_FY

©1999 All Rights Reserved