[Home] [Help] [Dependency Information]
Object Name: | BEN_EXT_DATA_ELMT_IN_RCD |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_EXT_DATA_ELMT_IN_RCD |
Subobject Name: | |
Status: | VALID |
BEN_EXT_DATA_ELMT_IN_RCD identifies which extract data elements are part of an extract record. For example, the data elements of person full name and person national identifier may be defined as part of the person identifier record.
.
The table is the intersection of BEN_EXT_DATA_ELMT and BEN_EXT_RCD.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_EXT_DATA_ELMT_IN_RCD_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
EXT_DATA_ELMT_IN_RCD_ID
ZD_EDITION_NAME |
BEN_EXT_DATA_ELMT_IN_RCD_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EXT_DATA_ELMT_ID |
BEN_EXT_DATA_ELMT_IN_RCD_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EXT_RCD_ID |
BEN_EXT_DATA_ELMT_IN_RCD_FK3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXT_DATA_ELMT_IN_RCD_ID | NUMBER | (15) | Yes | System generated primary key column. |
BUSINESS_GROUP_ID | NUMBER | (15) | Foreign Key to HR_ORGANIZATION_UNITS | |
RQD_FLAG | VARCHAR2 | (30) | Yes | Required Y or N. |
HIDE_FLAG | VARCHAR2 | (30) | Yes | Hide Y or N. |
EXT_DATA_ELMT_ID | NUMBER | (15) | Yes | Foreign key to BEN_EXT_DATA_ELMT. |
EXT_RCD_ID | NUMBER | (15) | Yes | Foreign key to BEN_EXT_RCD. |
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. | |
SEQ_NUM | NUMBER | (15) | Sequence number. | |
STRT_POS | NUMBER | (15) | Start position. | |
DLMTR_VAL | VARCHAR2 | (90) | Delimiter value. | |
SPRS_CD | VARCHAR2 | (30) | Suppress code. | |
ANY_OR_ALL_CD | VARCHAR2 | (30) | Any or all. | |
LEGISLATION_CODE | VARCHAR2 | (30) | Legislation Code. | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT EXT_DATA_ELMT_IN_RCD_ID
, BUSINESS_GROUP_ID
, RQD_FLAG
, HIDE_FLAG
, EXT_DATA_ELMT_ID
, EXT_RCD_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, SEQ_NUM
, STRT_POS
, DLMTR_VAL
, SPRS_CD
, ANY_OR_ALL_CD
, LEGISLATION_CODE
, ZD_EDITION_NAME
FROM BEN.BEN_EXT_DATA_ELMT_IN_RCD;
BEN.BEN_EXT_DATA_ELMT_IN_RCD does not reference any database object
BEN.BEN_EXT_DATA_ELMT_IN_RCD is referenced by following:
|
|
|