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

BEN_PGM_F

BenefitsUsed in 0 subject areas110 reporting columnsBICC incremental-ready

Benefits (BEN).

Likely primary key: PGM_ID, EFFECTIVE_START_DATE (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE

Columns

ColumnKeyIn reportsDescription (inferred)
ACTY_REF_PERD_CD●Acty reference perd code.
ALWS_UNRSTRCTD_ENRT_FLAG●Indicator (Y/N) for the alws unrstrctd enrt.
AUTO_ENRT_MTHD_RL●Auto enrt mthd rl.
BUSINESS_GROUP_ID●Identifier for the business group.
CONFIG_CHAR_1●Config char 1.
COORD_CVG_FOR_ALL_PLS_FLG●Coord cvg for all pls flag.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
DFLT_ELEMENT_TYPE_ID●Identifier for the dflt element type.
DFLT_INPUT_VALUE_ID●Identifier for the dflt input value.
DFLT_PGM_FLAG●Indicator (Y/N) for the dflt pgm.
DFLT_STEP_CD●Dflt step code.
DFLT_STEP_RL●Dflt step rl.
DPNT_CVG_END_DT_CD●Dpnt cvg end date code.
DPNT_CVG_END_DT_RL●Dpnt cvg end date rl.
DPNT_CVG_STRT_DT_CD●Dpnt cvg strt date code.
DPNT_CVG_STRT_DT_RL●Dpnt cvg strt date rl.
DPNT_DSGN_LVL_CD●Dpnt dsgn lvl code.
DPNT_DSGN_NO_CTFN_RQD_FLAG●Indicator (Y/N) for the dpnt dsgn number ctfn rqd.
DRVBL_FCTR_APLS_RTS_FLAG●Indicator (Y/N) for the drvbl fctr apls rts.
DRVBL_FCTR_DPNT_ELIG_FLAG●Indicator (Y/N) for the drvbl fctr dpnt elig.
DRVBL_FCTR_PRTN_ELIG_FLAG●Indicator (Y/N) for the drvbl fctr prtn elig.
EFFECTIVE_END_DATE●End date of the effective-dated record.
EFFECTIVE_START_DATEPK?●Start date of the effective-dated record.
ELIG_APLS_FLAG●Indicator (Y/N) for the elig apls.
ENRT_CD●Enrt code.
ENRT_CVG_END_DT_CD●Enrt cvg end date code.
ENRT_CVG_END_DT_RL●Enrt cvg end date rl.
ENRT_CVG_STRT_DT_CD●Enrt cvg strt date code.
ENRT_CVG_STRT_DT_RL●Enrt cvg strt date rl.
ENRT_INFO_RT_FREQ_CD●Enrt info rt freq code.
ENRT_MTHD_CD●Enrt mthd code.
ENRT_RL●Enrt rl.
GLOBAL_FLAG●Indicator (Y/N) for the global.
GSP_ALLOW_OVERRIDE_FLAG●Indicator (Y/N) for the gsp allow override.
IVR_IDENT●Ivr ident.
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.
LEGISLATION_CODE●Code identifying the legislation.
LEGISLATION_SUBGROUP●Legislation subgroup.
MX_DPNT_PCT_PRTT_LF_AMT●Mx dpnt percent prtt lf amount.
MX_SPS_PCT_PRTT_LF_AMT●Mx sps percent prtt lf amount.
NAME●Name.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
PER_CVRD_CD●Per cvrd code.
PGM_ATTRIBUTE1●Pgm attribute1.
PGM_ATTRIBUTE10●Pgm attribute10.
PGM_ATTRIBUTE11●Pgm attribute11.
PGM_ATTRIBUTE12●Pgm attribute12.
PGM_ATTRIBUTE13●Pgm attribute13.
PGM_ATTRIBUTE14●Pgm attribute14.
PGM_ATTRIBUTE15●Pgm attribute15.
PGM_ATTRIBUTE16●Pgm attribute16.
PGM_ATTRIBUTE17●Pgm attribute17.
PGM_ATTRIBUTE18●Pgm attribute18.
PGM_ATTRIBUTE19●Pgm attribute19.
PGM_ATTRIBUTE2●Pgm attribute2.
PGM_ATTRIBUTE20●Pgm attribute20.
PGM_ATTRIBUTE21●Pgm attribute21.
PGM_ATTRIBUTE22●Pgm attribute22.
PGM_ATTRIBUTE23●Pgm attribute23.
PGM_ATTRIBUTE24●Pgm attribute24.
PGM_ATTRIBUTE25●Pgm attribute25.
PGM_ATTRIBUTE26●Pgm attribute26.
PGM_ATTRIBUTE27●Pgm attribute27.
PGM_ATTRIBUTE28●Pgm attribute28.
PGM_ATTRIBUTE29●Pgm attribute29.
PGM_ATTRIBUTE3●Pgm attribute3.
PGM_ATTRIBUTE30●Pgm attribute30.
PGM_ATTRIBUTE4●Pgm attribute4.
PGM_ATTRIBUTE5●Pgm attribute5.
PGM_ATTRIBUTE6●Pgm attribute6.
PGM_ATTRIBUTE7●Pgm attribute7.
PGM_ATTRIBUTE8●Pgm attribute8.
PGM_ATTRIBUTE9●Pgm attribute9.
PGM_ATTRIBUTE_CATEGORY●Pgm attribute category.
PGM_DESC●Description of the pgm.
PGM_GRP_CD●Pgm grp code.
PGM_IDPK?●Identifier for the pgm.
PGM_PRVDS_CR_FLAG●Indicator (Y/N) for the pgm prvds cr.
PGM_PRVDS_NO_AUTO_ENRT_FLAG●Indicator (Y/N) for the pgm prvds number auto enrt.
PGM_PRVDS_NO_DFLT_ENRT_FLAG●Indicator (Y/N) for the pgm prvds number dflt enrt.
PGM_STAT_CD●Pgm status code.
PGM_TYP_CD●Pgm type code.
PGM_UOM●Pgm unit of measure.
PGM_USE_ALL_ASNTS_ELIG_FLAG●Indicator (Y/N) for the pgm use all asnts elig.
POE_LVL_CD●Poe lvl code.
PRTN_ELIG_OVRID_ALWD_FLAG●Indicator (Y/N) for the prtn elig ovrid alwd.
PRTT_CHC_UNCRS_TRTMT_FLAG●Indicator (Y/N) for the prtt chc uncrs trtmt.
RT_END_DT_CD●Rt end date code.
RT_END_DT_RL●Rt end date rl.
RT_STRT_DT_CD●Rt strt date code.
RT_STRT_DT_RL●Rt strt date rl.
SALARY_CALC_MTHD_CD●Salary calc mthd code.
SALARY_CALC_MTHD_RL●Salary calc mthd rl.
SCORES_CALC_MTHD_CD●Scores calc mthd code.
SCORES_CALC_RL●Scores calc rl.
SHORT_CODE●Code identifying the short.
SHORT_NAME●Name of the short.
TRK_INELIG_PER_FLAG●Indicator (Y/N) for the trk inelig per.
UPDATE_SALARY_CD●Update salary code.
URL_REF_NAME●Name of the url reference.
USES_ALL_ASMTS_FOR_RTS_FLAG●Indicator (Y/N) for the uses all asmts for rts.
USE_MULTI_PAY_RATES_FLAG●Indicator (Y/N) for the use multi pay rates.
USE_PROG_POINTS_FLAG●Indicator (Y/N) for the use prog points.
USE_SCORES_CD●Use scores code.
USE_VARIABLE_RATES_FLAG●Indicator (Y/N) for the use variable rates.
VRFY_FMLY_MMBR_CD●Vrfy fmly mmbr code.
VRFY_FMLY_MMBR_RL●Vrfy fmly mmbr rl.

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_PGM_F?
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