Oracle Fusion · Data dictionary
BEN_BILL_ENRT_RSLT
BenefitsUsed in 0 subject areas69 reporting columnsBICC incremental-ready
Benefits (BEN).
Likely primary key: BILL_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
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| BENEFIT_RELATION_ID | ● | Identifier for the benefit relation. | |
| BER_ATTRIBUTE1 | ● | Ber attribute1. | |
| BER_ATTRIBUTE10 | ● | Ber attribute10. | |
| BER_ATTRIBUTE2 | ● | Ber attribute2. | |
| BER_ATTRIBUTE3 | ● | Ber attribute3. | |
| BER_ATTRIBUTE4 | ● | Ber attribute4. | |
| BER_ATTRIBUTE5 | ● | Ber attribute5. | |
| BER_ATTRIBUTE6 | ● | Ber attribute6. | |
| BER_ATTRIBUTE7 | ● | Ber attribute7. | |
| BER_ATTRIBUTE8 | ● | Ber attribute8. | |
| BER_ATTRIBUTE9 | ● | Ber attribute9. | |
| BER_ATTRIBUTE_CATEGORY | ● | Ber attribute category. | |
| BER_ATTRIBUTE_DATE1 | ● | Ber attribute date1. | |
| BER_ATTRIBUTE_DATE2 | ● | Ber attribute date2. | |
| BER_ATTRIBUTE_DATE3 | ● | Ber attribute date3. | |
| BER_ATTRIBUTE_DATE4 | ● | Ber attribute date4. | |
| BER_ATTRIBUTE_DATE5 | ● | Ber attribute date5. | |
| BER_ATTRIBUTE_NUMBER1 | ● | Ber attribute number1. | |
| BER_ATTRIBUTE_NUMBER2 | ● | Ber attribute number2. | |
| BER_ATTRIBUTE_NUMBER3 | ● | Ber attribute number3. | |
| BER_ATTRIBUTE_NUMBER4 | ● | Ber attribute number4. | |
| BER_ATTRIBUTE_NUMBER5 | ● | Ber attribute number5. | |
| BILL_END_DATE | ● | Bill end date. | |
| BILL_ENRT_RSLT_ID | PK? | ● | Identifier for the bill enrt rslt. |
| BILL_START_DATE | ● | Bill start date. | |
| BNFT_AMT | ● | Bnft amount. | |
| BUSINESS_GROUP_ID | ● | Identifier for the business group. | |
| CONFIG_CHAR_1 | ● | Config char 1. | |
| CONFIG_CHAR_2 | ● | Config char 2. | |
| CONFIG_CHAR_3 | ● | Config char 3. | |
| CONFIG_CHAR_4 | ● | Config char 4. | |
| CONFIG_CHAR_5 | ● | Config char 5. | |
| CONFIG_DATE_1 | ● | Config date 1. | |
| CONFIG_DATE_2 | ● | Config date 2. | |
| CONFIG_DATE_3 | ● | Config date 3. | |
| CONFIG_DATE_4 | ● | Config date 4. | |
| CONFIG_DATE_5 | ● | Config date 5. | |
| CONFIG_NUM_1 | ● | Config number 1. | |
| CONFIG_NUM_2 | ● | Config number 2. | |
| CONFIG_NUM_3 | ● | Config number 3. | |
| CONFIG_NUM_4 | ● | Config number 4. | |
| CONFIG_NUM_5 | ● | Config number 5. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| ELECTION_DATE | ● | Election date. | |
| ENRT_CVG_STRT_DT | ● | Enrt cvg strt date. | |
| ENRT_CVG_THRU_DT | ● | Enrt cvg thru date. | |
| 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. | |
| LER_TYP_CD | ● | Ler type code. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| OIPL_ID | ● | Identifier for the oipl. | |
| OPT_ID | ● | Identifier for the opt. | |
| ORGNL_ENRT_DT | ● | Orgnl enrt date. | |
| ORGNL_PRTT_ENRT_RSLT_ID | ● | Identifier for the orgnl prtt enrt rslt. | |
| PERSON_ID | ● | Identifier for the person. | |
| PER_IN_LER_ID | ● | Identifier for the per in ler. | |
| PGM_ID | ● | Identifier for the pgm. | |
| PL_ID | ● | Identifier for the pl. | |
| PL_TYP_ID | ● | Identifier for the pl type. | |
| PRORATE_DAYS | ● | Prorate days. | |
| PRORATE_PERCENT | ● | Prorate percentage. | |
| PRORATE_TYPE | ● | Type of prorate. | |
| PTIP_ID | ● | Identifier for the ptip. | |
| SRC_CD | ● | Src code. | |
| STOP_BILL_FLAG | ● | Indicator (Y/N) for the stop bill. |
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_BILL_ENRT_RSLT?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table