Appendix 6: Database Items
The following table lists newly created database items that can be used in release 21A onwards.
User Entity | Required Contexts | Array Database Item | Database Item Name |
---|---|---|---|
BEN_ELIG_PER_ELCTBL_CHC_TN_UE |
HR_ASSIGNMENT_ID, BUSINESS_GROUP_ID, EFFECTIVE_DATE |
Yes |
BEN_EPE_INTERIM_FLAG_TN BEN_EPE_LER_CHG_DPNT_CVG_CD_TN BEN_EPE_MNDTRY_FLAG_TN BEN_EPE_MUST_ENRL_ANTHR_PL_ID_NN BEN_EPE_OIPL_ID_NN BEN_EPE_PER_IN_LER_ID_NN BEN_EPE_PGM_ID_NN BEN_EPE_PIL_ELCTBL_CHC_POPL_ID_NN BEN_EPE_PLIP_ID_NN BEN_EPE_PL_ID_NN BEN_EPE_PL_TYP_ID_NN BEN_EPE_PROCG_END_DT_DN BEN_EPE_PRTT_ENRT_RSLT_ID_NN BEN_EPE_PTIP_ID_NN BEN_EPE_ROLL_CRS_FLAG_TN BEN_EPE_SPCL_RT_OIPL_ID_NN BEN_EPE_SPCL_RT_PL_ID_NN BEN_EPE_YR_PERD_ID_NN BEN_EPE_ALWS_DPNT_DSGN_FLAG_TN BEN_EPE_APPROVAL_STATUS_CD_TN BEN_EPE_AUTO_ENRT_FLAG_TN BEN_EPE_BNFT_PRVDR_POOL_ID_NN BEN_EPE_BNF_DSGN_CD_TN BEN_EPE_BUSINESS_GROUP_ID_NN BEN_EPE_CMBN_PLIP_ID_NN BEN_EPE_CMBN_PTIP_ID_NN BEN_EPE_CMBN_PTIP_OPT_ID_NN BEN_EPE_COMP_LVL_CD_TN BEN_EPE_CRNTLY_ENRD_FLAG_TN BEN_EPE_CTFN_RQD_FLAG_TN BEN_EPE_CVRD_FLAG_TN BEN_EPE_DFLT_FLAG_TN BEN_EPE_DPNT_CVG_STRT_DT_CD_TN BEN_EPE_DPNT_CVG_STRT_DT_RL_NN BEN_EPE_DPNT_DSGN_CD_TN BEN_EPE_ELCTBL_FLAG_TN BEN_EPE_ELIG_FLAG_TN BEN_EPE_ELIG_PER_ELCTBL_CHC_ID_NN BEN_EPE_ENRT_CVG_STRT_DT_CD_TN BEN_EPE_ENRT_CVG_STRT_DT_DN BEN_EPE_ENRT_CVG_STRT_DT_RL_NN BEN_EPE_ERLST_DEENRT_DT_DN BEN_EPE_INELIG_RSN_CD_TN BEN_EPE_LER_NAME_TN BEN_EPE_LER_INSTRUCTION_TEXT_TN BEN_EPE_LER_ID_NN BEN_EPE_LER_GLOBAL_FLAG_TN BEN_EPE_LER_DESC_TXT_TN BEN_EPE_LER_QUALG_EVT_FLAG_TN BEN_EPE_LER_SELF_ASSIGNED_EVENT_FLAG_TN BEN_EPE_LER_SHORT_CODE_TN BEN_EPE_LER_SHORT_NAME_TN BEN_EPE_LER_SLCTBL_SLF_SVC_CD_TN BEN_EPE_LER_TYP_CD_TN BEN_EPE_OPT_NAME_TN BEN_EPE_PGM_NAME_TN BEN_EPE_PGM_GLOBAL_FLAG_TN BEN_EPE_PGM_EFFECTIVE_START_DATE_DN BEN_EPE_PGM_EFFECTIVE_END_DATE_DN BEN_EPE_PGM_ALWS_UNRSTRCTD_ENRT_FLAG_TN BEN_EPE_PGM_SHORT_CODE_TN BEN_EPE_PGM_RATE_LEVEL_TN BEN_EPE_PGM_STAT_CD_TN BEN_EPE_PGM_SHORT_NAME_TN BEN_EPE_PL_NAME_TN BEN_EPE_PL_RATE_LEVEL_TN BEN_EPE_PL_ALWS_UNRSTRCTD_ENRT_FLAG_TN BEN_EPE_PL_GLOBAL_FLAG_TN BEN_EPE_PL_EFFECTIVE_START_DATE_DN BEN_EPE_PL_SHORT_NAME_TN BEN_EPE_PL_STAT_CD_TN BEN_EPE_PL_FUNCTION_CODE_TN BEN_EPE_PL_EFFECTIVE_END_DATE_DN BEN_EPE_PL_SHORT_CODE_TN BEN_EPE_PTP_SS_CATEGORY_CD_TN BEN_EPE_PTP_NAME_TN BEN_EPE_PTP_GLOBAL_FLAG_TN BEN_EPE_PTP_CARRIER_PLAN_TYPE_NAME_TN BEN_EPE_PTP_ADMIN_CATEGORY_CD_TN |
BEN_PRTT_LEG_DISCMR_ACTN_TN |
PERSON_ID, PER_IN_LER_ID, BUSINESS_GROUP_ID, EFFECTIVE_DATE |
Yes |
BEN_PLD_ACTION_TIME_DN BEN_PLD_STATUS_TN BEN_PLD_BENEFIT_RELATION_NAME_TN BEN_PLD_LEGAL_DISCLAIMER_DESC_TN BEN_PLD_LER_NAME_TN |
BEN_PER_BNFTS_BAL_F_TN |
EFFECTIVE_DATE, BUSINESS_GROUP_ID, PERSON_ID |
Yes |
BEN_PBB_BNFTS_BAL_NAME_TN BEN_PBB_BUSINESS_GROUP_ID_NN BEN_PBB_VAL_NN BEN_PBB_EFFECTIVE_START_DATE_DN BEN_PBB_PERSON_ID_NN BEN_PBB_PER_BNFTS_BAL_ID_NN BEN_PBB_BNFTS_BAL_ID_NN BEN_PBB_EFFECTIVE_END_DATE_DN |
BEN_PER_LE_HABITS_COV_F |
PERSON_ID, BUSINESS_GROUP_ID, EFFECTIVE_DATE |
No |
BEN_PHB_COORD_MED_CVG_END_DT BEN_PHB_TOBACCO_TYPE_USAGE BEN_PHB_COORD_MED_EXT_ER BEN_PHB_COORD_MED_INSR_CRR_IDENT BEN_PHB_COORD_MED_INSR_CRR_NAM BEN_PHB_COORD_MED_PLN_NO BEN_PHB_COORD_MED_PL_NAME BEN_PHB_COORD_NO_CVG_FLAG BEN_PHB_CVRD_IN_ANTHR_PL BEN_PHB_DISABILITY_STATUS BEN_PHB_DPDNT_ADOPTION_DATE BEN_PHB_DPDNT_VLNTRY_SVCE_FLAG BEN_PHB_EFFECTIVE_END_DATE BEN_PHB_EFFECTIVE_START_DATE BEN_PHB_ON_MILITARY_SERVICE BEN_PHB_RECEIPT_OF_DEATH_CERT_DATE BEN_PHB_REGISTERED_DISABLED_FLAG BEN_PHB_STUDENT_STATUS BEN_PHB_COORD_MED_CVG_STRT_DT |
BEN_PER_BNF_ORG_TN |
PERSON_ID, BUSINESS_GROUP_ID, EFFECTIVE_DATE |
Yes |
BEN_PBO_BNF_ORGANIZATION_NAME_TN BEN_PBO_END_DATE_DN BEN_PBO_START_DATE_DN BEN_PBO_TRUSTEE_ORG_REG_CD_TN BEN_PBO_TRUSTEE_EXECUTOR_NAME_TN BEN_PBO_TRUSTEE_ORG_DESCRIPTION_TN BEN_PBO_TRUSTEE_ORG_NAME_TN BEN_PBO_BNF_TYP_CD_TN BEN_PBO_TRUSTEE_ADDL_DETAILS_TN |
BEN_PER_BENEFIT_GROUP_F_TN |
PERSON_ID, BUSINESS_GROUP_ID, EFFECTIVE_DATE |
Yes | EN_PBG_BENEFIT_GROUP_NAME_TN |
BEN_EXT_HIST_PLD |
PERSON_ID, EFFECTIVE_DATE |
Yes |
BEN_EXT_HIST_PLD_ACTION_TIME_DN BEN_EXT_HIST_PLD_STATUS_TN BEN_EXT_HIST_PLD_BENEFIT_RELATION_ID_NN BEN_EXT_HIST_PLD_PRTT_LEG_DISCMR_ACTN_ID_NN BEN_EXT_HIST_PLD_PL_ID_NN BEN_EXT_HIST_PLD_PGM_ID_NN BEN_EXT_HIST_PLD_PER_IN_LER_ID_NN BEN_EXT_HIST_PLD_PERSON_ID_NN BEN_EXT_HIST_PLD_LER_ID_NN BEN_EXT_HIST_PLD_LEGAL_ENTITY_ID_NN BEN_EXT_HIST_PLD_LEGAL_DISCLAIMER_ID_NN BEN_EXT_HIST_PLD_LAST_UPDATE_LOGIN_TN BEN_EXT_HIST_PLD_LAST_UPDATE_DATE_DN BEN_EXT_HIST_PLD_LAST_UPDATED_BY_TN BEN_EXT_HIST_PLD_CREATION_DATE_DN BEN_EXT_HIST_PLD_CREATED_BY_TN BEN_EXT_HIST_PLD_BRN_BENEFIT_REL_SYSTEM_CD_TN BEN_EXT_HIST_PLD_BRN_STATUS_TN BEN_EXT_HIST_PLD_BENEFIT_RELATION_NAME_TN BEN_EXT_HIST_PLD_LEG_DESCRIPTION_TN BEN_EXT_HIST_PLD_LEGAL_ENTITY_NAME_TN BEN_EXT_HIST_PLD_LER_SHORT_CODE_TN BEN_EXT_HIST_PLD_LER_TYP_CD_TN BEN_EXT_HIST_PLD_LER_GLOBAL_FLAG_TN BEN_EXT_HIST_PLD_LER_SLCTBL_SLF_SVC_CD_TN BEN_EXT_HIST_PLD_LER_SHORT_NAME_TN BEN_EXT_HIST_PLD_LER_LER_NAME_TN BEN_EXT_HIST_PLD_PERSON_NAME_TN BEN_EXT_HIST_PLD_PGM_NAME_TN BEN_EXT_HIST_PLD_PGM_SHORT_NAME_TN BEN_EXT_HIST_PLD_PGM_SHORT_CODE_TN BEN_EXT_HIST_PLD_PIL_LF_EVT_OCRD_DT_DN BEN_EXT_HIST_PLD_PIL_PER_IN_LER_STAT_CD_TN BEN_EXT_HIST_PLD_PL_NAME_TN BEN_EXT_HIST_PLD_PL_SHORT_NAME_TN BEN_EXT_HIST_PLD_PL_SHORT_CODE_TN |
BEN_EXT_HIST_PTNL_LER_FOR_PER |
PERSON_ID, EFFECTIVE_DATE |
Yes |
BEN_EXT_HIST_PTNL_BRN_BENEFIT_RELATION_NAME_TN BEN_EXT_HIST_PTNL_BRN_BENEFIT_REL_SYSTEM_CD_TN BEN_EXT_HIST_PTNL_BRN_EFFECTIVE_END_DATE_DN BEN_EXT_HIST_PTNL_BRN_EFFECTIVE_START_DATE_DN BEN_EXT_HIST_PTNL_BRN_PRIMARY_REL_TN BEN_EXT_HIST_PTNL_BRN_REL_PRMRY_ASG_ID_NN BEN_EXT_HIST_PTNL_BRN_STATUS_TN BEN_EXT_HIST_PTNL_LEGAL_ENTITY_NAME_TN BEN_EXT_HIST_PTNL_LER_LF_EVT_OPER_CD_TN BEN_EXT_HIST_PTNL_LER_TMLNS_PERD_CD_TN BEN_EXT_HIST_PTNL_LER_TMLNS_EVAL_CD_TN BEN_EXT_HIST_PTNL_LER_TMLNS_DYS_NUM_NN BEN_EXT_HIST_PTNL_LER_SLCTBL_SLF_SVC_CD_TN BEN_EXT_HIST_PTNL_LER_SHORT_NAME_TN BEN_EXT_HIST_PTNL_LER_SHORT_CODE_TN BEN_EXT_HIST_PTNL_LER_PTNL_LER_TRTMT_CD_TN BEN_EXT_HIST_PTNL_LER_OVRIDG_LE_FLAG_TN BEN_EXT_HIST_PTNL_LER_OCRD_DT_DET_CD_TN BEN_EXT_HIST_PTNL_LER_NAME_TN BEN_EXT_HIST_PTNL_LER_GLOBAL_FLAG_TN BEN_EXT_HIST_PTNL_PERSON_NAME_TN BEN_EXT_HIST_PTNL_CREATED_BY_TN BEN_EXT_HIST_PTNL_LF_EVT_OCRD_DT_DN BEN_EXT_HIST_PTNL_MNL_DT_DN BEN_EXT_HIST_PTNL_NTFN_DT_DN BEN_EXT_HIST_PTNL_PERSON_ID_NN BEN_EXT_HIST_PTNL_PROCD_DT_DN BEN_EXT_HIST_PTNL_VOIDD_DT_DN BEN_EXT_HIST_PTNL_LER_ID_NN BEN_EXT_HIST_PTNL_PTNL_LER_FOR_PER_ID_NN BEN_EXT_HIST_PTNL_LER_FOR_PER_STAT_CD_TN BEN_EXT_HIST_PTNL_BENEFIT_RELATION_ID_NN BEN_EXT_HIST_PTNL_LEGAL_ENTITY_ID_NN BEN_EXT_HIST_PTNL_LAST_UPDATE_LOGIN_TN BEN_EXT_HIST_PTNL_LAST_UPDATE_DATE_DN BEN_EXT_HIST_PTNL_LAST_UPDATED_BY_TN BEN_EXT_HIST_PTNL_DTCTD_DT_DN BEN_EXT_HIST_PTNL_CREATION_DATE_DN BEN_EXT_HIST_PTNL_UNPROCD_DT_DN BEN_EXT_HIST_PTNL_LER_TYP_CD_TN |
BEN_EXT_HIST_PCP |
PERSON_ID, EFFECTIVE_DATE |
Yes |
BEN_EXT_HIST_PCP_DPNT_FULL_NAME_TN BEN_EXT_HIST_PCP_PRTTPCP_TN BEN_EXT_HIST_PCP_LEGAL_ENTITY_NAME_TN BEN_EXT_HIST_PCP_LER_SHORT_CODE_TN BEN_EXT_HIST_PCP_LER_ID_NN BEN_EXT_HIST_PCP_LER_NAME_TN BEN_EXT_HIST_PCP_LER_GLOBAL_FLAG_TN BEN_EXT_HIST_PCP_LER_SHORT_NAME_TN BEN_EXT_HIST_PCP_LER_TYP_CD_TN BEN_EXT_HIST_PCP_OPT_NAME_TN BEN_EXT_HIST_PCP_OPT_SHORT_NAME_TN BEN_EXT_HIST_PCP_OPT_SHORT_CODE_TN BEN_EXT_HIST_PCP_DPNT_RLNSHP_CD_TN BEN_EXT_HIST_PCP_DPNT_PERSON_ID_NN BEN_EXT_HIST_PCP_ENRT_MTHD_CD_TN BEN_EXT_HIST_PCP_ENRT_CVG_THRU_DT_DN BEN_EXT_HIST_PCP_ENRT_CVG_STRT_DT_DN BEN_EXT_HIST_PCP_ELECTION_DATE_DN BEN_EXT_HIST_PCP_COMP_LVL_CD_TN BEN_EXT_HIST_PCP_PL_TYP_ID_NN BEN_EXT_HIST_PCP_PL_ID_NN BEN_EXT_HIST_PCP_PGM_ID_NN BEN_EXT_HIST_PCP_ORGNL_ENRT_DT_DN BEN_EXT_HIST_PCP_SSPNDD_FLAG_TN BEN_EXT_HIST_PCP_PRTT_ENRT_RSLT_STAT_CD_TN BEN_EXT_HIST_PCP_OPT_ID_NN BEN_EXT_HIST_PCP_LEGAL_ENTITY_ID_NN BEN_EXT_HIST_PCP_PERSON_FULL_NAME_TN BEN_EXT_HIST_PCP_PGM_SHORT_NAME_TN BEN_EXT_HIST_PCP_PGM_NAME_TN BEN_EXT_HIST_PCP_PGM_SHORT_CODE_TN BEN_EXT_HIST_PCP_BENEFIT_RELATION_ID_NN BEN_EXT_HIST_PCP_LF_EVT_OCRD_DT_DN BEN_EXT_HIST_PCP_PER_IN_LER_ID_NN BEN_EXT_HIST_PCP_PER_IN_LER_STAT_CD_TN BEN_EXT_HIST_PCP_PERSON_ID_NN BEN_EXT_HIST_PCP_PL_SHORT_CODE_TN BEN_EXT_HIST_PCP_PL_NAME_TN BEN_EXT_HIST_PCP_PL_SHORT_NAME_TN BEN_EXT_HIST_PCP_PL_TYP_NAME_TN BEN_EXT_HIST_PCP_LAST_UPDATE_LOGIN_TN BEN_EXT_HIST_PCP_LAST_UPDATE_DATE_DN BEN_EXT_HIST_PCP_EXT_IDENT_TN BEN_EXT_HIST_PCP_ELIG_PER_ELCTBL_CHC_ID_NN BEN_EXT_HIST_PCP_ELIG_DPNT_ID_NN BEN_EXT_HIST_PCP_ELIG_CVRD_DPNT_ID_NN BEN_EXT_HIST_PCP_CVRD_FLAG_TN BEN_EXT_HIST_PCP_PRTT_ENRT_RSLT_ID_NN BEN_EXT_HIST_PCP_PRMRY_CARE_PRVDR_ID_NN BEN_EXT_HIST_PCP_PRMRY_CARE_PRVDR_TYP_CD_TN BEN_EXT_HIST_PCP_CREATED_BY_TN BEN_EXT_HIST_PCP_CREATION_DATE_DN BEN_EXT_HIST_PCP_NAME_TN BEN_EXT_HIST_PCP_LAST_UPDATED_BY_TN BEN_EXT_HIST_PCP_CVG_THRU_DT_DN BEN_EXT_HIST_PCP_CVG_STRT_DT_DN |
BEN_EXT_HIST_PBB |
PERSON_ID, EFFECTIVE_DATE |
Yes |
BEN_EXT_HIST_PBB_BNB_BNFTS_BAL_DESC_TN BEN_EXT_HIST_PBB_BNB_BNFTS_BAL_NAME_TN BEN_EXT_HIST_PBB_BNB_BNFTS_BAL_USG_CD_TN BEN_EXT_HIST_PBB_BNB_NNMNTRY_UOM_TN BEN_EXT_HIST_PBB_BRN_BRN_STATUS_TN BEN_EXT_HIST_PBB_BRN_BENEFIT_RELATION_NAME_TN BEN_EXT_HIST_PBB_BRN_BENEFIT_REL_SYSTEM_CD_TN BEN_EXT_HIST_PBB_BRN_BRN_PRIMARY_REL_TN BEN_EXT_HIST_PBB_LEGAL_ENTITY_NAME_TN BEN_EXT_HIST_PBB_PERSON_ID_NN BEN_EXT_HIST_PBB_LEGAL_ENTITY_ID_NN BEN_EXT_HIST_PBB_LAST_UPDATE_LOGIN_TN BEN_EXT_HIST_PBB_LAST_UPDATE_DATE_DN BEN_EXT_HIST_PBB_LAST_UPDATED_BY_TN BEN_EXT_HIST_PBB_CREATION_DATE_DN BEN_EXT_HIST_PBB_CREATED_BY_TN BEN_EXT_HIST_PBB_BNFTS_BAL_ID_NN BEN_EXT_HIST_PBB_VAL_NN BEN_EXT_HIST_PBB_ASSIGNMENT_ID_NN BEN_EXT_HIST_PBB_BENEFIT_RELATION_ID_NN BEN_EXT_HIST_PBB_PER_BNFTS_BAL_ID_NN BEN_EXT_HIST_PBB_UOM_TN BEN_EXT_HIST_PBB_PERSON_NAME_TN |
BEN_EXT_HIST_FLEX_CRDT_LDGR |
PERSON_ID, EFFECTIVE_DATE |
Yes |
BEN_EXT_HIST_FCL_CHILD_POOL_NAME_TN BEN_EXT_HIST_FCL_PRNT_POOL_NAME_TN BEN_EXT_HIST_FCL_POOL_LEGAL_ENTITY_NAME_TN BEN_EXT_HIST_FCL_POOL_LDG_NAME_TN BEN_EXT_HIST_FCL_ACTY_REF_PERD_CD_TN BEN_EXT_HIST_FCL_ANN_CASH_RECD_VAL_NN BEN_EXT_HIST_FCL_ANN_DONATED_TO_PRNT_VAL_NN BEN_EXT_HIST_FCL_ANN_FRFTD_VAL_NN BEN_EXT_HIST_FCL_ANN_PRVDD_VAL_NN BEN_EXT_HIST_FCL_ANN_RECD_FROM_CHLD_VAL_NN BEN_EXT_HIST_FCL_ANN_RLD_UP_VAL_NN BEN_EXT_HIST_FCL_ANN_USED_VAL_NN BEN_EXT_HIST_FCL_CASH_RECD_VAL_NN BEN_EXT_HIST_FCL_CMCD_CASH_RECD_VAL_NN BEN_EXT_HIST_FCL_CMCD_DONATED_TO_PRNT_VAL_NN BEN_EXT_HIST_FCL_CMCD_FRFTD_VAL_NN BEN_EXT_HIST_FCL_CMCD_PRVDD_VAL_NN BEN_EXT_HIST_FCL_CMCD_RECD_FROM_CHLD_VAL_NN BEN_EXT_HIST_FCL_CMCD_REF_PERD_CD_TN BEN_EXT_HIST_FCL_CMCD_RLD_UP_VAL_NN BEN_EXT_HIST_FCL_CMCD_USED_VAL_NN BEN_EXT_HIST_FCL_CREATED_BY_TN BEN_EXT_HIST_FCL_CREATION_DATE_DN BEN_EXT_HIST_FCL_DONATED_TO_PRNT_POOL_VAL_NN BEN_EXT_HIST_FCL_FLEX_CRDT_LDGR_ID_NN BEN_EXT_HIST_FCL_FRFTD_VAL_NN BEN_EXT_HIST_FCL_LAST_UPDATED_BY_TN BEN_EXT_HIST_FCL_LAST_UPDATE_DATE_DN BEN_EXT_HIST_FCL_LAST_UPDATE_LOGIN_TN BEN_EXT_HIST_FCL_LDGR_CLASS_TN BEN_EXT_HIST_FCL_LDGR_END_DT_DN BEN_EXT_HIST_FCL_LDGR_STRT_DT_DN BEN_EXT_HIST_FCL_PRVDD_VAL_NN BEN_EXT_HIST_FCL_RECD_FROM_CHLD_POOL_VAL_NN BEN_EXT_HIST_FCL_RLD_UP_VAL_NN BEN_EXT_HIST_FCL_USED_VAL_NN BEN_EXT_HIST_FCL_LER_SHORT_NAME_TN BEN_EXT_HIST_FCL_LER_ID_NN BEN_EXT_HIST_FCL_LER_GLOBAL_FLAG_TN BEN_EXT_HIST_FCL_LER_TYP_CD_TN BEN_EXT_HIST_FCL_LER_NAME_TN BEN_EXT_HIST_FCL_LER_SHORT_CODE_TN BEN_EXT_HIST_FCL_OPT_SHORT_NAME_TN BEN_EXT_HIST_FCL_OPT_NAME_TN BEN_EXT_HIST_FCL_OPT_SHORT_CODE_TN BEN_EXT_HIST_FCL_PRTT_ENRT_RSLT_ID_NN BEN_EXT_HIST_FCL_ENRT_MTHD_CD_TN BEN_EXT_HIST_FCL_ENRT_CVG_THRU_DT_DN BEN_EXT_HIST_FCL_ENRT_CVG_STRT_DT_DN BEN_EXT_HIST_FCL_ELECTION_DATE_DN BEN_EXT_HIST_FCL_PRTT_ENRT_RSLT_STAT_CD_TN BEN_EXT_HIST_FCL_COMP_LVL_CD_TN BEN_EXT_HIST_FCL_ORGNL_ENRT_DT_DN BEN_EXT_HIST_FCL_PERSON_FULL_NAME_TN BEN_EXT_HIST_FCL_PGM_RATE_LEVEL_TN BEN_EXT_HIST_FCL_PGM_SHORT_NAME_TN BEN_EXT_HIST_FCL_PGM_SHORT_CODE_TN BEN_EXT_HIST_FCL_PGM_NAME_TN BEN_EXT_HIST_FCL_PER_IN_LER_ID_NN BEN_EXT_HIST_FCL_PERSON_ID_NN BEN_EXT_HIST_FCL_BENEFIT_RELATION_ID_NN BEN_EXT_HIST_FCL_LF_EVT_OCRD_DT_DN BEN_EXT_HIST_FCL_PER_IN_LER_STAT_CD_TN BEN_EXT_HIST_FCL_PL_SHORT_CODE_TN BEN_EXT_HIST_FCL_PL_NAME_TN BEN_EXT_HIST_FCL_PL_SHORT_NAME_TN BEN_EXT_HIST_FCL_POOL_LEVEL_TN BEN_EXT_HIST_FCL_POOL_NAME_TN BEN_EXT_HIST_FCL_POOL_LDG_ID_NN BEN_EXT_HIST_FCL_POOL_LEGAL_ENTITY_ID_NN BEN_EXT_HIST_FCL_PROVIDER_OPTION_SHORT_NAME_TN BEN_EXT_HIST_FCL_PROVIDER_OPTION_NAME_TN BEN_EXT_HIST_FCL_PROVIDER_OPTION_SHORT_CODE_TN BEN_EXT_HIST_FCL_PROVIDER_PLAN_SHORT_NAME_TN BEN_EXT_HIST_FCL_PROVIDER_PLAN_NAME_TN BEN_EXT_HIST_FCL_PROVIDER_PLAN_SHORT_CODE_TN BEN_EXT_HIST_FCL_PRV_RATE_STRT_DT_DN BEN_EXT_HIST_FCL_PRV_MLT_CD_TN BEN_EXT_HIST_FCL_PRV_RATE_END_DT_DN BEN_EXT_HIST_FCL_PRV_RCRRG_FLAG_TN BEN_EXT_HIST_FCL_PRV_RATE_NAME_TN |