Oracle Fusion · Data dictionary
BEN_PIL_ELCTBL_CHC_POPL
BenefitsUsed in 0 subject areas104 reporting columnsBICC incremental-ready
Benefits (BEN).
Likely primary key: PIL_ELCTBL_CHC_POPL_ID (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): PER_IN_LER_ID → BEN_PER_IN_LER
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTY_REF_PERD_CD | ● | Acty reference perd code. | |
| ASSIGNMENT_ID | ● | Identifier for the assignment. | |
| AUTO_ASND_DT | ● | Auto asnd date. | |
| BDGT_ACC_CD | ● | Bdgt acc code. | |
| BUSINESS_GROUP_ID | ● | Identifier for the business group. | |
| CBR_ELIG_PERD_END_DT | ● | Cbr elig perd end date. | |
| CBR_ELIG_PERD_STRT_DT | ● | Cbr elig perd strt date. | |
| CLS_ENRT_DT_TO_USE_CD | ● | Cls enrt date to use code. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DFLT_ASND_DT | ● | Dflt asnd date. | |
| DFLT_ENRT_DT | ● | Dflt enrt date. | |
| ELCNS_MADE_DT | ● | Elcns made date. | |
| ENRT_PERD_END_DT | ● | Enrt perd end date. | |
| ENRT_PERD_ID | ● | Identifier for the enrt perd. | |
| ENRT_PERD_STRT_DT | ● | Enrt perd strt date. | |
| ENRT_TYP_CYCL_CD | ● | Enrt type cycl code. | |
| 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. | |
| LEE_RSN_ID | ● | Identifier for the lee rsn. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| PEL_ATTRIBUTE1 | ● | Pel attribute1. | |
| PEL_ATTRIBUTE10 | ● | Pel attribute10. | |
| PEL_ATTRIBUTE11 | ● | Pel attribute11. | |
| PEL_ATTRIBUTE12 | ● | Pel attribute12. | |
| PEL_ATTRIBUTE13 | ● | Pel attribute13. | |
| PEL_ATTRIBUTE14 | ● | Pel attribute14. | |
| PEL_ATTRIBUTE15 | ● | Pel attribute15. | |
| PEL_ATTRIBUTE16 | ● | Pel attribute16. | |
| PEL_ATTRIBUTE17 | ● | Pel attribute17. | |
| PEL_ATTRIBUTE18 | ● | Pel attribute18. | |
| PEL_ATTRIBUTE19 | ● | Pel attribute19. | |
| PEL_ATTRIBUTE2 | ● | Pel attribute2. | |
| PEL_ATTRIBUTE20 | ● | Pel attribute20. | |
| PEL_ATTRIBUTE21 | ● | Pel attribute21. | |
| PEL_ATTRIBUTE22 | ● | Pel attribute22. | |
| PEL_ATTRIBUTE23 | ● | Pel attribute23. | |
| PEL_ATTRIBUTE24 | ● | Pel attribute24. | |
| PEL_ATTRIBUTE25 | ● | Pel attribute25. | |
| PEL_ATTRIBUTE26 | ● | Pel attribute26. | |
| PEL_ATTRIBUTE27 | ● | Pel attribute27. | |
| PEL_ATTRIBUTE28 | ● | Pel attribute28. | |
| PEL_ATTRIBUTE29 | ● | Pel attribute29. | |
| PEL_ATTRIBUTE3 | ● | Pel attribute3. | |
| PEL_ATTRIBUTE30 | ● | Pel attribute30. | |
| PEL_ATTRIBUTE4 | ● | Pel attribute4. | |
| PEL_ATTRIBUTE5 | ● | Pel attribute5. | |
| PEL_ATTRIBUTE6 | ● | Pel attribute6. | |
| PEL_ATTRIBUTE7 | ● | Pel attribute7. | |
| PEL_ATTRIBUTE8 | ● | Pel attribute8. | |
| PEL_ATTRIBUTE9 | ● | Pel attribute9. | |
| PEL_ATTRIBUTE_CATEGORY | ● | Pel attribute category. | |
| PEL_ATTRIBUTE_DATE1 | ● | Pel attribute date1. | |
| PEL_ATTRIBUTE_DATE10 | ● | Pel attribute date10. | |
| PEL_ATTRIBUTE_DATE11 | ● | Pel attribute date11. | |
| PEL_ATTRIBUTE_DATE12 | ● | Pel attribute date12. | |
| PEL_ATTRIBUTE_DATE13 | ● | Pel attribute date13. | |
| PEL_ATTRIBUTE_DATE14 | ● | Pel attribute date14. | |
| PEL_ATTRIBUTE_DATE15 | ● | Pel attribute date15. | |
| PEL_ATTRIBUTE_DATE2 | ● | Pel attribute date2. | |
| PEL_ATTRIBUTE_DATE3 | ● | Pel attribute date3. | |
| PEL_ATTRIBUTE_DATE4 | ● | Pel attribute date4. | |
| PEL_ATTRIBUTE_DATE5 | ● | Pel attribute date5. | |
| PEL_ATTRIBUTE_DATE6 | ● | Pel attribute date6. | |
| PEL_ATTRIBUTE_DATE7 | ● | Pel attribute date7. | |
| PEL_ATTRIBUTE_DATE8 | ● | Pel attribute date8. | |
| PEL_ATTRIBUTE_DATE9 | ● | Pel attribute date9. | |
| PEL_ATTRIBUTE_NUMBER1 | ● | Pel attribute number1. | |
| PEL_ATTRIBUTE_NUMBER10 | ● | Pel attribute number10. | |
| PEL_ATTRIBUTE_NUMBER11 | ● | Pel attribute number11. | |
| PEL_ATTRIBUTE_NUMBER12 | ● | Pel attribute number12. | |
| PEL_ATTRIBUTE_NUMBER13 | ● | Pel attribute number13. | |
| PEL_ATTRIBUTE_NUMBER14 | ● | Pel attribute number14. | |
| PEL_ATTRIBUTE_NUMBER15 | ● | Pel attribute number15. | |
| PEL_ATTRIBUTE_NUMBER16 | ● | Pel attribute number16. | |
| PEL_ATTRIBUTE_NUMBER17 | ● | Pel attribute number17. | |
| PEL_ATTRIBUTE_NUMBER18 | ● | Pel attribute number18. | |
| PEL_ATTRIBUTE_NUMBER19 | ● | Pel attribute number19. | |
| PEL_ATTRIBUTE_NUMBER2 | ● | Pel attribute number2. | |
| PEL_ATTRIBUTE_NUMBER20 | ● | Pel attribute number20. | |
| PEL_ATTRIBUTE_NUMBER3 | ● | Pel attribute number3. | |
| PEL_ATTRIBUTE_NUMBER4 | ● | Pel attribute number4. | |
| PEL_ATTRIBUTE_NUMBER5 | ● | Pel attribute number5. | |
| PEL_ATTRIBUTE_NUMBER6 | ● | Pel attribute number6. | |
| PEL_ATTRIBUTE_NUMBER7 | ● | Pel attribute number7. | |
| PEL_ATTRIBUTE_NUMBER8 | ● | Pel attribute number8. | |
| PEL_ATTRIBUTE_NUMBER9 | ● | Pel attribute number9. | |
| PER_IN_LER_ID | ● | Identifier for the per in ler. | |
| PGM_ID | ● | Identifier for the pgm. | |
| PIL_ELCTBL_CHC_POPL_ID | PK? | ● | Identifier for the pil elctbl chc popl. |
| PIL_ELCTBL_POPL_STAT_CD | ● | Pil elctbl popl status code. | |
| PL_ID | ● | Identifier for the pl. | |
| POP_CD | ● | Pop code. | |
| PROCG_END_DT | ● | Procg end date. | |
| PROGRAM_APP_NAME | ● | Name of the program app. | |
| PROGRAM_NAME | ● | Name of the program. | |
| PROGRAM_UPDATE_DATE | ● | Program update date. | |
| REINSTATE_CD | ● | Reinstate code. | |
| REINSTATE_OVRDN_CD | ● | Reinstate ovrdn code. | |
| REQUEST_ID | ● | Identifier of the process that created or last updated the row. | |
| 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_PIL_ELCTBL_CHC_POPL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table