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

BEN_CRT_ORDR_F

BenefitsUsed in 0 subject areas138 reporting columnsBICC incremental-ready

Benefits (BEN).

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

Columns

ColumnKeyIn reportsDescription (inferred)
ADDRESS_LINE_1●Address line 1.
ADDRESS_LINE_2●Address line 2.
ADDRESS_LINE_3●Address line 3.
ADDRESS_LINE_4●Address line 4.
BUSINESS_GROUP_ID●Identifier for the business group.
CITY●City.
CONFIG_CHAR_1●Config char 1.
CONFIG_CHAR_10●Config char 10.
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_CHAR_6●Config char 6.
CONFIG_CHAR_7●Config char 7.
CONFIG_CHAR_8●Config char 8.
CONFIG_CHAR_9●Config char 9.
CONFIG_DATE_1●Config date 1.
CONFIG_DATE_10●Config date 10.
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_DATE_6●Config date 6.
CONFIG_DATE_7●Config date 7.
CONFIG_DATE_8●Config date 8.
CONFIG_DATE_9●Config date 9.
CONFIG_ID_1●Config id 1.
CONFIG_ID_10●Config id 10.
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_ID_6●Config id 6.
CONFIG_ID_7●Config id 7.
CONFIG_ID_8●Config id 8.
CONFIG_ID_9●Config id 9.
CONFIG_NUM_1●Config number 1.
CONFIG_NUM_10●Config number 10.
CONFIG_NUM_2●Config number 2.
CONFIG_NUM_3●Config number 3.
CONFIG_NUM_4●Config number 4.
CONFIG_NUM_5●Config number 5.
CONFIG_NUM_6●Config number 6.
CONFIG_NUM_7●Config number 7.
CONFIG_NUM_8●Config number 8.
CONFIG_NUM_9●Config number 9.
COUNTRY●Country.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
CRT_ATTRIBUTE1●Crt attribute1.
CRT_ATTRIBUTE10●Crt attribute10.
CRT_ATTRIBUTE11●Crt attribute11.
CRT_ATTRIBUTE12●Crt attribute12.
CRT_ATTRIBUTE13●Crt attribute13.
CRT_ATTRIBUTE14●Crt attribute14.
CRT_ATTRIBUTE15●Crt attribute15.
CRT_ATTRIBUTE16●Crt attribute16.
CRT_ATTRIBUTE17●Crt attribute17.
CRT_ATTRIBUTE18●Crt attribute18.
CRT_ATTRIBUTE19●Crt attribute19.
CRT_ATTRIBUTE2●Crt attribute2.
CRT_ATTRIBUTE20●Crt attribute20.
CRT_ATTRIBUTE21●Crt attribute21.
CRT_ATTRIBUTE22●Crt attribute22.
CRT_ATTRIBUTE23●Crt attribute23.
CRT_ATTRIBUTE24●Crt attribute24.
CRT_ATTRIBUTE25●Crt attribute25.
CRT_ATTRIBUTE26●Crt attribute26.
CRT_ATTRIBUTE27●Crt attribute27.
CRT_ATTRIBUTE28●Crt attribute28.
CRT_ATTRIBUTE29●Crt attribute29.
CRT_ATTRIBUTE3●Crt attribute3.
CRT_ATTRIBUTE30●Crt attribute30.
CRT_ATTRIBUTE4●Crt attribute4.
CRT_ATTRIBUTE5●Crt attribute5.
CRT_ATTRIBUTE6●Crt attribute6.
CRT_ATTRIBUTE7●Crt attribute7.
CRT_ATTRIBUTE8●Crt attribute8.
CRT_ATTRIBUTE9●Crt attribute9.
CRT_ATTRIBUTE_CATEGORY●Crt attribute category.
CRT_ATTRIBUTE_DATE1●Crt attribute date1.
CRT_ATTRIBUTE_DATE10●Crt attribute date10.
CRT_ATTRIBUTE_DATE11●Crt attribute date11.
CRT_ATTRIBUTE_DATE12●Crt attribute date12.
CRT_ATTRIBUTE_DATE13●Crt attribute date13.
CRT_ATTRIBUTE_DATE14●Crt attribute date14.
CRT_ATTRIBUTE_DATE15●Crt attribute date15.
CRT_ATTRIBUTE_DATE2●Crt attribute date2.
CRT_ATTRIBUTE_DATE3●Crt attribute date3.
CRT_ATTRIBUTE_DATE4●Crt attribute date4.
CRT_ATTRIBUTE_DATE5●Crt attribute date5.
CRT_ATTRIBUTE_DATE6●Crt attribute date6.
CRT_ATTRIBUTE_DATE7●Crt attribute date7.
CRT_ATTRIBUTE_DATE8●Crt attribute date8.
CRT_ATTRIBUTE_DATE9●Crt attribute date9.
CRT_ATTRIBUTE_NUMBER1●Crt attribute number1.
CRT_ATTRIBUTE_NUMBER10●Crt attribute number10.
CRT_ATTRIBUTE_NUMBER11●Crt attribute number11.
CRT_ATTRIBUTE_NUMBER12●Crt attribute number12.
CRT_ATTRIBUTE_NUMBER13●Crt attribute number13.
CRT_ATTRIBUTE_NUMBER14●Crt attribute number14.
CRT_ATTRIBUTE_NUMBER15●Crt attribute number15.
CRT_ATTRIBUTE_NUMBER16●Crt attribute number16.
CRT_ATTRIBUTE_NUMBER17●Crt attribute number17.
CRT_ATTRIBUTE_NUMBER18●Crt attribute number18.
CRT_ATTRIBUTE_NUMBER19●Crt attribute number19.
CRT_ATTRIBUTE_NUMBER2●Crt attribute number2.
CRT_ATTRIBUTE_NUMBER20●Crt attribute number20.
CRT_ATTRIBUTE_NUMBER3●Crt attribute number3.
CRT_ATTRIBUTE_NUMBER4●Crt attribute number4.
CRT_ATTRIBUTE_NUMBER5●Crt attribute number5.
CRT_ATTRIBUTE_NUMBER6●Crt attribute number6.
CRT_ATTRIBUTE_NUMBER7●Crt attribute number7.
CRT_ATTRIBUTE_NUMBER8●Crt attribute number8.
CRT_ATTRIBUTE_NUMBER9●Crt attribute number9.
CRT_IDENT●Crt ident.
CRT_ISSNG●Crt issng.
CRT_ORDR_IDPK?●Identifier for the crt ordr.
CRT_ORDR_STAT_CD●Crt ordr status code.
CRT_ORDR_TYP_CD●Crt ordr type code.
DESCRIPTION●Description.
DETD_QLFD_ORDR_DT●Detd qlfd ordr date.
EFFECTIVE_END_DATE●End date of the effective-dated record.
EFFECTIVE_START_DATEPK?●Start date of the effective-dated record.
ELIGIBLE_DT●Eligible date.
ISSUE_DT●Issue date.
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.
NOTES●Notes.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
ORDR_END_DATE●Ordr end date.
ORDR_START_DATE●Ordr start date.
PASSD_FIN_ASSMNT●Passd fin assmnt.
PERSON_ID●Identifier for the person.
POSTAL_CODE●Code identifying the postal.
RCVD_DT●Rcvd date.
STATE●State.

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_CRT_ORDR_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