EFFILE: EMPLOYEE BENEFIT RECORDS

ElementElement NameTableSQL Name
EFAACUSER IDEFRBTSCORP
EFAADIDENTIFICATION NUMBREFRBTSEMP_ID
EFAAEEMP PLAN TYPEEFRBTSPLAN_TYPE
EFAAFEMP COV START DATEEFRBTSCOVER_BGN_DT
EFAAMEMP PLAN CODEEFRBTSPLAN_CODE
EFAANEMP COVERAGE CODEEFRBTSCOVERAGE
EFAAOEMP JOB CODEEFRBTSJOB
EFCBAEMPR REF IDEFRBTSREF_ID
EFCBBEMPR ACTN AMTEFRBTSACTN_AMT
EFCBCEMPR ACTN GOALEFRBTSACTN_GOAL
EFCBDEMPR ACTN ARREFRBTSACTN_ARREARS
EFCBEEMPR DED NOT TAKENEFRBTSNOT_TAK
EFCBFEMPR AMOUNT PERCENTEFRBTSAMT
EFCBGEMPR GOALEFRBTSGOAL
EFCBHEMPR GOAL PAIDEFRBTSGOAL_PD
EFCBIEMPR ARREARSEFRBTSARREARS
EFCBJEMPR PAY START DATEEFRBTSPAY_BGN_DT
EFCBQEMPR PAY END DATEEFRBTSPAY_END_DT
EFCBWEMPR COV END DATEEFRBTSCOVER_END_DT
EFCCBEMPR CURRENT INDEFRBTSCURRENT_IND
EFCCCEMPR APPROVAL INDEFRBTSAPPROVAL_IND
EFCCDEMPR SHELTER INDICATEFRBTSSHELT_IND
EFCCEEMPR CURRENTEFRBTSAMT_CURR
EFCCFEMPR MTDEFRBTSAMT_MTD
EFCCGEMPR QTDEFRBTSAMT_QTD
EFCCHEMPR FYTDEFRBTSAMT_FYTD
EFCCIEMPR CYTDEFRBTSAMT_YTD
EFCCJEMPR RTDEFRBTSAMT_RTD
EFCCKEMPR PRIOR QTDEFRBTSAMT_PRIOR_QUAR
EFCCLEMPR PRIOR YTDEFRBTSAMT_PRIOR_YR
EFCCMEMPR LAST ACT DATEEFRBTSLAST_ACT_DT
EFCCNEMPR LAST ACT CODEEFRBTSLAST_ACT_CD
EFCCOEMPR PRIOR MOEFRBTSAMT_PRIOR_MO
EFCCPEMPR PRIOR FYREFRBTSAMT_PRIOR_FY

©1999 All Rights Reserved