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

BEN_CRT_ORDR_PL_DPNT

BenefitsUsed in 0 subject areas122 reporting columnsBICC incremental-ready

Benefits (BEN).

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

Columns

ColumnKeyIn reportsDescription (inferred)
BUSINESS_GROUP_ID●Identifier for the business group.
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.
CONTACT_PERSON_ID●Identifier for the contact person.
CRD_ATTRIBUTE1●Crd attribute1.
CRD_ATTRIBUTE10●Crd attribute10.
CRD_ATTRIBUTE11●Crd attribute11.
CRD_ATTRIBUTE12●Crd attribute12.
CRD_ATTRIBUTE13●Crd attribute13.
CRD_ATTRIBUTE14●Crd attribute14.
CRD_ATTRIBUTE15●Crd attribute15.
CRD_ATTRIBUTE16●Crd attribute16.
CRD_ATTRIBUTE17●Crd attribute17.
CRD_ATTRIBUTE18●Crd attribute18.
CRD_ATTRIBUTE19●Crd attribute19.
CRD_ATTRIBUTE2●Crd attribute2.
CRD_ATTRIBUTE20●Crd attribute20.
CRD_ATTRIBUTE21●Crd attribute21.
CRD_ATTRIBUTE22●Crd attribute22.
CRD_ATTRIBUTE23●Crd attribute23.
CRD_ATTRIBUTE24●Crd attribute24.
CRD_ATTRIBUTE25●Crd attribute25.
CRD_ATTRIBUTE26●Crd attribute26.
CRD_ATTRIBUTE27●Crd attribute27.
CRD_ATTRIBUTE28●Crd attribute28.
CRD_ATTRIBUTE29●Crd attribute29.
CRD_ATTRIBUTE3●Crd attribute3.
CRD_ATTRIBUTE30●Crd attribute30.
CRD_ATTRIBUTE4●Crd attribute4.
CRD_ATTRIBUTE5●Crd attribute5.
CRD_ATTRIBUTE6●Crd attribute6.
CRD_ATTRIBUTE7●Crd attribute7.
CRD_ATTRIBUTE8●Crd attribute8.
CRD_ATTRIBUTE9●Crd attribute9.
CRD_ATTRIBUTE_CATEGORY●Crd attribute category.
CRD_ATTRIBUTE_DATE1●Crd attribute date1.
CRD_ATTRIBUTE_DATE10●Crd attribute date10.
CRD_ATTRIBUTE_DATE11●Crd attribute date11.
CRD_ATTRIBUTE_DATE12●Crd attribute date12.
CRD_ATTRIBUTE_DATE13●Crd attribute date13.
CRD_ATTRIBUTE_DATE14●Crd attribute date14.
CRD_ATTRIBUTE_DATE15●Crd attribute date15.
CRD_ATTRIBUTE_DATE2●Crd attribute date2.
CRD_ATTRIBUTE_DATE3●Crd attribute date3.
CRD_ATTRIBUTE_DATE4●Crd attribute date4.
CRD_ATTRIBUTE_DATE5●Crd attribute date5.
CRD_ATTRIBUTE_DATE6●Crd attribute date6.
CRD_ATTRIBUTE_DATE7●Crd attribute date7.
CRD_ATTRIBUTE_DATE8●Crd attribute date8.
CRD_ATTRIBUTE_DATE9●Crd attribute date9.
CRD_ATTRIBUTE_NUMBER1●Crd attribute number1.
CRD_ATTRIBUTE_NUMBER10●Crd attribute number10.
CRD_ATTRIBUTE_NUMBER11●Crd attribute number11.
CRD_ATTRIBUTE_NUMBER12●Crd attribute number12.
CRD_ATTRIBUTE_NUMBER13●Crd attribute number13.
CRD_ATTRIBUTE_NUMBER14●Crd attribute number14.
CRD_ATTRIBUTE_NUMBER15●Crd attribute number15.
CRD_ATTRIBUTE_NUMBER16●Crd attribute number16.
CRD_ATTRIBUTE_NUMBER17●Crd attribute number17.
CRD_ATTRIBUTE_NUMBER18●Crd attribute number18.
CRD_ATTRIBUTE_NUMBER19●Crd attribute number19.
CRD_ATTRIBUTE_NUMBER2●Crd attribute number2.
CRD_ATTRIBUTE_NUMBER20●Crd attribute number20.
CRD_ATTRIBUTE_NUMBER3●Crd attribute number3.
CRD_ATTRIBUTE_NUMBER4●Crd attribute number4.
CRD_ATTRIBUTE_NUMBER5●Crd attribute number5.
CRD_ATTRIBUTE_NUMBER6●Crd attribute number6.
CRD_ATTRIBUTE_NUMBER7●Crd attribute number7.
CRD_ATTRIBUTE_NUMBER8●Crd attribute number8.
CRD_ATTRIBUTE_NUMBER9●Crd attribute number9.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
CRT_ORDR_ID●Identifier for the crt ordr.
CRT_ORDR_PL_DPNT_IDPK?●Identifier for the crt ordr pl dpnt.
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.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
ORDR_END_DATE●Ordr end date.
ORDR_START_DATE●Ordr start date.
PL_ID●Identifier for the pl.
PL_TYP_ID●Identifier for the pl type.
PRVNT_DEENRT_FLAG●Indicator (Y/N) for the prvnt deenrt.
RLSHP_TYP_CD●Rlshp type code.

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