DBA Data[Home] [Help] [Dependency Information]

TABLE: BEN.BEN_EXT_DFN

Object Details
Object Name: BEN_EXT_DFN
Object Type: TABLE
Owner: BEN
FND Design Data: TableBEN.BEN_EXT_DFN
Subobject Name:
Status: VALID


BEN_EXT_DFN identifies the extract name as well as the inclusion criteria, file layout, output and processing options for the extract.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: BEN_EXT_DFN_PK
  1. ColumnEXT_DFN_ID
Indexes
Index Type Uniqueness Tablespace Column
BEN_EXT_DFN_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXT_DFN_ID
BEN_EXT_DFN_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXT_CRIT_PRFL_ID
BEN_EXT_DFN_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXT_FILE_ID
BEN_EXT_DFN_FK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
EXT_DFN_ID NUMBER (15) Yes System generated primary key column.
BUSINESS_GROUP_ID NUMBER (15)
Foreign Key to HR_ORGANIZATION_UNITS
KICKOFF_WRT_PRC_FLAG VARCHAR2 (30) Yes Kickoff write process Y or N.
APND_RQST_ID_FLAG VARCHAR2 (30) Yes Append concurrent request identifier Y or N,.
PRMY_SORT_CD VARCHAR2 (30)
No longer used.
SCND_SORT_CD VARCHAR2 (30)
No longer used.
STRT_DT VARCHAR2 (90)
Start date.
END_DT VARCHAR2 (90)
End date.
SPCL_HNDL_FLAG VARCHAR2 (30)
Special handling Y or N.
UPD_CM_SENT_DT_FLAG VARCHAR2 (30)
Updated Communication Sent Date Y or N.
USE_EFF_DT_FOR_CHGS_FLAG VARCHAR2 (30)
Use Effective Date For Changes Y or N.
EXT_CRIT_PRFL_ID NUMBER (15)
Foreign key to BEN_EXT_CRIT_PRFL.
EXT_FILE_ID NUMBER (15)
Foreign key to BEN_EXT_FILE.
EXT_POST_PRCS_RL NUMBER (15)
Foreign key to FF_FORMULAS_F.
XDF_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column.
XDF_ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flexfield segment column.
XDF_ATTRIBUTE30 VARCHAR2 (150)
Descriptive Flexfield segment column.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated primary key. Increments by one each update.
NAME VARCHAR2 (600)
Name of the extract definition.
DATA_TYP_CD VARCHAR2 (30)
Data type.
EXT_TYP_CD VARCHAR2 (30)
Extract type.
DRCTRY_NAME VARCHAR2 (150)
Directory name for extract files. Defaults to /sqlcom/out.
OUTPUT_NAME VARCHAR2 (90)
Output name.
LEGISLATION_CODE VARCHAR2 (30)
Legislation Code.
OUTPUT_TYPE VARCHAR2 (30)
Output Type
XML_TAG_NAME VARCHAR2 (80)
Reserved for future use.
XDO_TEMPLATE_ID NUMBER (15)
foreign key to xdo_templates_b table.
EXT_GLOBAL_FLAG VARCHAR2 (30) Yes To determine the Global Extract.
CM_DISPLAY_FLAG VARCHAR2 (30)
Display the extract results in the concurrent manager log
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EXT_DFN_ID
,      BUSINESS_GROUP_ID
,      KICKOFF_WRT_PRC_FLAG
,      APND_RQST_ID_FLAG
,      PRMY_SORT_CD
,      SCND_SORT_CD
,      STRT_DT
,      END_DT
,      SPCL_HNDL_FLAG
,      UPD_CM_SENT_DT_FLAG
,      USE_EFF_DT_FOR_CHGS_FLAG
,      EXT_CRIT_PRFL_ID
,      EXT_FILE_ID
,      EXT_POST_PRCS_RL
,      XDF_ATTRIBUTE_CATEGORY
,      XDF_ATTRIBUTE1
,      XDF_ATTRIBUTE2
,      XDF_ATTRIBUTE3
,      XDF_ATTRIBUTE4
,      XDF_ATTRIBUTE5
,      XDF_ATTRIBUTE6
,      XDF_ATTRIBUTE7
,      XDF_ATTRIBUTE8
,      XDF_ATTRIBUTE9
,      XDF_ATTRIBUTE10
,      XDF_ATTRIBUTE11
,      XDF_ATTRIBUTE12
,      XDF_ATTRIBUTE13
,      XDF_ATTRIBUTE14
,      XDF_ATTRIBUTE15
,      XDF_ATTRIBUTE16
,      XDF_ATTRIBUTE17
,      XDF_ATTRIBUTE18
,      XDF_ATTRIBUTE19
,      XDF_ATTRIBUTE20
,      XDF_ATTRIBUTE21
,      XDF_ATTRIBUTE22
,      XDF_ATTRIBUTE23
,      XDF_ATTRIBUTE24
,      XDF_ATTRIBUTE25
,      XDF_ATTRIBUTE26
,      XDF_ATTRIBUTE27
,      XDF_ATTRIBUTE28
,      XDF_ATTRIBUTE29
,      XDF_ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      NAME
,      DATA_TYP_CD
,      EXT_TYP_CD
,      DRCTRY_NAME
,      OUTPUT_NAME
,      LEGISLATION_CODE
,      OUTPUT_TYPE
,      XML_TAG_NAME
,      XDO_TEMPLATE_ID
,      EXT_GLOBAL_FLAG
,      CM_DISPLAY_FLAG
FROM BEN.BEN_EXT_DFN;

Dependencies

[top of page]

BEN.BEN_EXT_DFN does not reference any database object

BEN.BEN_EXT_DFN is referenced by following:

SchemaAPPS
SynonymBEN_EXT_DFN
TriggerBEN_EXT_DFN_WHO