BEN_PRTT_ENRT_RSLT

BenefitsUsed in 0 subject areas111 reporting columnsBICC incremental-ready

Benefits (BEN).

Likely primary key: PRTT_ENRT_RSLT_ID (inferred from Oracle naming conventions — verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE

Columns

Column	Key	In reports	Description (inferred)
ADMIN_CATEGORY_CD		●	Admin category code.
ASSIGNMENT_ID		●	Identifier for the assignment.
BENEFIT_RELATION_ID		●	Identifier for the benefit relation.
BNFT_AMT		●	Bnft amount.
BNFT_NNMNTRY_UOM		●	Bnft nnmntry unit of measure.
BNFT_ORDR_NUM		●	Bnft ordr number.
BNFT_TYP_CD		●	Bnft type code.
BUSINESS_GROUP_ID		●	Identifier for the business group.
CIR_BENEFIT_ID		●	Identifier for the cir benefit.
COMP_LVL_CD		●	Comp lvl code.
CONFIG_CHAR_1		●	Config char 1.
CONFIG_CHAR_10		●	Config char 10.
CONFIG_CHAR_6		●	Config char 6.
CONFIG_CHAR_7		●	Config char 7.
CONFIG_CHAR_8		●	Config char 8.
CONFIG_CHAR_9		●	Config char 9.
CONFIG_ID_1		●	Config id 1.
CONFIG_ID_2		●	Config id 2.
CONFIG_ID_3		●	Config id 3.
CONFIG_ID_4		●	Config id 4.
CONFIG_ID_5		●	Config id 5.
CONFIG_NUM_1		●	Config number 1.
CONFIG_NUM_10		●	Config number 10.
CONFIG_NUM_6		●	Config number 6.
CONFIG_NUM_7		●	Config number 7.
CONFIG_NUM_8		●	Config number 8.
CONFIG_NUM_9		●	Config number 9.
CREATED_BY		●	User who created the row.
CREATION_DATE		●	Date and time the row was created.
ELECTION_DATE		●	Election date.
ENDED_CVG_THRU_DT		●	Ended cvg thru date.
ENDED_PER_IN_LER_ID		●	Identifier for the ended per in ler.
ENRT_CVG_STRT_DT		●	Enrt cvg strt date.
ENRT_CVG_THRU_DT		●	Enrt cvg thru date.
ENRT_MTHD_CD		●	Enrt mthd code.
ENRT_OVRIDN_FLAG		●	Indicator (Y/N) for the enrt ovridn.
ENRT_OVRID_RSN_CD		●	Enrt ovrid rsn code.
ENRT_OVRID_THRU_DT		●	Enrt ovrid thru date.
ERLST_DEENRT_DT		●	Erlst deenrt date.
IMPTD_INCM_CALC_CD		●	Imptd incm calc code.
INTERIM_FLAG		●	Indicator (Y/N) for the interim.
JOB_DEFINITION_NAME		●	Name of the job definition.
JOB_DEFINITION_PACKAGE		●	Job definition package.
LAST_UPDATED_BY		●	User who last updated the row.
LAST_UPDATE_DATE	INCR	●	Date and time the row was last updated (the incremental-extract key).
LAST_UPDATE_LOGIN		●	Session login of the user who last updated the row.
LEGAL_ENTITY_ID		●	Identifier of the legal entity.
LER_ID		●	Identifier for the ler.
MISC_PLN_FLAG		●	Indicator (Y/N) for the misc pln.
NO_LNGR_ELIG_FLAG		●	Indicator (Y/N) for the number lngr elig.
OBJECT_VERSION_NUMBER		●	Optimistic-locking version number, incremented on each update.
OIPL_ID		●	Identifier for the oipl.
OIPL_ORDR_NUM		●	Oipl ordr number.
OPT_ID		●	Identifier for the opt.
ORGNL_ENRT_DT		●	Orgnl enrt date.
PEN_ATTRIBUTE1		●	Pen attribute1.
PEN_ATTRIBUTE10		●	Pen attribute10.
PEN_ATTRIBUTE11		●	Pen attribute11.
PEN_ATTRIBUTE12		●	Pen attribute12.
PEN_ATTRIBUTE13		●	Pen attribute13.
PEN_ATTRIBUTE14		●	Pen attribute14.
PEN_ATTRIBUTE15		●	Pen attribute15.
PEN_ATTRIBUTE16		●	Pen attribute16.
PEN_ATTRIBUTE17		●	Pen attribute17.
PEN_ATTRIBUTE18		●	Pen attribute18.
PEN_ATTRIBUTE19		●	Pen attribute19.
PEN_ATTRIBUTE2		●	Pen attribute2.
PEN_ATTRIBUTE20		●	Pen attribute20.
PEN_ATTRIBUTE21		●	Pen attribute21.
PEN_ATTRIBUTE22		●	Pen attribute22.
PEN_ATTRIBUTE23		●	Pen attribute23.
PEN_ATTRIBUTE24		●	Pen attribute24.
PEN_ATTRIBUTE25		●	Pen attribute25.
PEN_ATTRIBUTE26		●	Pen attribute26.
PEN_ATTRIBUTE27		●	Pen attribute27.
PEN_ATTRIBUTE28		●	Pen attribute28.
PEN_ATTRIBUTE29		●	Pen attribute29.
PEN_ATTRIBUTE3		●	Pen attribute3.
PEN_ATTRIBUTE30		●	Pen attribute30.
PEN_ATTRIBUTE4		●	Pen attribute4.
PEN_ATTRIBUTE5		●	Pen attribute5.
PEN_ATTRIBUTE6		●	Pen attribute6.
PEN_ATTRIBUTE7		●	Pen attribute7.
PEN_ATTRIBUTE8		●	Pen attribute8.
PEN_ATTRIBUTE9		●	Pen attribute9.
PEN_ATTRIBUTE_CATEGORY		●	Pen attribute category.
PERSON_ID		●	Identifier for the person.
PER_IN_LER_ID		●	Identifier for the per in ler.
PGM_ID		●	Identifier for the pgm.
PLIP_ORDR_NUM		●	Plip ordr number.
PL_ID		●	Identifier for the pl.
PL_ORDR_NUM		●	Pl ordr number.
PL_TYP_ID		●	Identifier for the pl type.
PROGRAM_APP_NAME		●	Name of the program app.
PROGRAM_NAME		●	Name of the program.
PROGRAM_UPDATE_DATE		●	Program update date.
PRTT_ENRT_RSLT_ID	PK?	●	Identifier for the prtt enrt rslt.
PRTT_ENRT_RSLT_STAT_CD		●	Prtt enrt rslt status code.
PRTT_IS_CVRD_FLAG		●	Indicator (Y/N) for the prtt is cvrd.
PRVS_CVG_STRT_DT		●	Prvs cvg strt date.
PRVS_CVG_THRU_DT		●	Prvs cvg thru date.
PRVS_SSPNDD_FLAG		●	Indicator (Y/N) for the prvs sspndd.
PTIP_ID		●	Identifier for the ptip.
PTIP_ORDR_NUM		●	Ptip ordr number.
REQUEST_ID		●	Identifier of the process that created or last updated the row.
RPLCS_SSPNDD_RSLT_ID		●	Identifier for the rplcs sspndd rslt.
SSPNDD_FLAG		●	Indicator (Y/N) for the sspndd.
SS_CATEGORY_CD		●	Ss category code.
SVNGS_PLN_FLAG		●	Indicator (Y/N) for the svngs pln.
TYPE_ID		●	Identifier for the type.
UOM		●	Unit of measure.

Used by reports

No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.

Subject areas

Need the extract + dbt staging for BEN_PRTT_ENRT_RSLT?

We ship parameterized SQL, BICC config, and dbt models you own.

Talk to us