Analytics Catalog/Data dictionary/BEN_PRTT_ENRT_RSLT
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

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
Joins (inferred from key columns): BENEFIT_RELATION_ID → BEN_BILL_CHARGE_DETAILS · LEGAL_ENTITY_ID → XLE_ENTITY_PROFILES · PER_IN_LER_ID → BEN_PER_IN_LER

Columns

ColumnKeyIn reportsDescription (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_DATEINCR●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_IDPK?●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
Problems that run through this table
What the extract does not carry · The export ceiling · The extraction pattern