[Home] [Help] [Dependency Information]
Object Name: | BEN_EXT_DATA_ELMT |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_EXT_DATA_ELMT |
Subobject Name: | |
Status: | VALID |
BEN_EXT_DATA_ELMT contains the list of data elements which may be selected for inclusion in an extract. It also identifies the type of element, mask format, string value (if the element is a string), default value, maximum length, and justification.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_EXT_DATA_ELMT_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | EXT_DATA_ELMT_ID |
BEN_EXT_DATA_ELMT_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EXT_FLD_ID |
BEN_EXT_DATA_ELMT_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_EXT_DATA_ELMT_FK3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TTL_SUM_EXT_DATA_ELMT_ID |
BEN_EXT_DATA_ELMT_FK4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TTL_COND_EXT_DATA_ELMT_ID |
BEN_EXT_DATA_ELMT_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXT_DATA_ELMT_ID | NUMBER | (15) | Yes | System generated primary key column. |
BUSINESS_GROUP_ID | NUMBER | (15) | Foreign Key to HR_ORGANIZATION_UNITS | |
TTL_FNCTN_CD | VARCHAR2 | (30) | Total function code. | |
TTL_COND_OPER_CD | VARCHAR2 | (30) | Total conditional operating code. | |
TTL_COND_VAL | VARCHAR2 | (600) | Total conditional value. | |
TTL_SUM_EXT_DATA_ELMT_ID | NUMBER | (15) | Foreign key to BEN_EXT_DATA_ELMT. | |
TTL_COND_EXT_DATA_ELMT_ID | NUMBER | (15) | Foreign key to BEN_EXT_DATA_ELMT. | |
EXT_FLD_ID | NUMBER | (15) | Foreign key to BEN_EXT_FLD. | |
XEL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
XEL_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
XEL_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 data element. | |
DATA_ELMT_TYP_CD | VARCHAR2 | (30) | Data element type. | |
DATA_ELMT_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
FRMT_MASK_CD | VARCHAR2 | (30) | Format mask. | |
STRING_VAL | VARCHAR2 | (600) | String value. | |
DFLT_VAL | VARCHAR2 | (600) | Default value. | |
MAX_LENGTH_NUM | NUMBER | (15) | Maximum length. | |
JUST_CD | VARCHAR2 | (30) | Justify code. | |
LEGISLATION_CODE | VARCHAR2 | (30) | Legislation Code | |
XML_TAG_NAME | VARCHAR2 | (80) | Reserved for future use. | |
DEFINED_BALANCE_ID | NUMBER | (15) | Stores the payroll balance extract data element info |
Cut, paste (and edit) the following text to query this object:
SELECT EXT_DATA_ELMT_ID
, BUSINESS_GROUP_ID
, TTL_FNCTN_CD
, TTL_COND_OPER_CD
, TTL_COND_VAL
, TTL_SUM_EXT_DATA_ELMT_ID
, TTL_COND_EXT_DATA_ELMT_ID
, EXT_FLD_ID
, XEL_ATTRIBUTE_CATEGORY
, XEL_ATTRIBUTE1
, XEL_ATTRIBUTE2
, XEL_ATTRIBUTE3
, XEL_ATTRIBUTE4
, XEL_ATTRIBUTE5
, XEL_ATTRIBUTE6
, XEL_ATTRIBUTE7
, XEL_ATTRIBUTE8
, XEL_ATTRIBUTE9
, XEL_ATTRIBUTE10
, XEL_ATTRIBUTE11
, XEL_ATTRIBUTE12
, XEL_ATTRIBUTE13
, XEL_ATTRIBUTE14
, XEL_ATTRIBUTE15
, XEL_ATTRIBUTE16
, XEL_ATTRIBUTE17
, XEL_ATTRIBUTE18
, XEL_ATTRIBUTE19
, XEL_ATTRIBUTE20
, XEL_ATTRIBUTE21
, XEL_ATTRIBUTE22
, XEL_ATTRIBUTE23
, XEL_ATTRIBUTE24
, XEL_ATTRIBUTE25
, XEL_ATTRIBUTE26
, XEL_ATTRIBUTE27
, XEL_ATTRIBUTE28
, XEL_ATTRIBUTE29
, XEL_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, NAME
, DATA_ELMT_TYP_CD
, DATA_ELMT_RL
, FRMT_MASK_CD
, STRING_VAL
, DFLT_VAL
, MAX_LENGTH_NUM
, JUST_CD
, LEGISLATION_CODE
, XML_TAG_NAME
, DEFINED_BALANCE_ID
FROM BEN.BEN_EXT_DATA_ELMT;
BEN.BEN_EXT_DATA_ELMT does not reference any database object
BEN.BEN_EXT_DATA_ELMT is referenced by following:
|
|
|