[Home] [Help] [Dependency Information]
Object Name: | BEN_ELP_EXTRA_INFO |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_ELP_EXTRA_INFO |
Subobject Name: | |
Status: | VALID |
BEN_ELP_EXTRA_INFO gives the Extra Information corresponding to the Eligibility Profiles.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_ELP_EXTRA_INFO_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | INFORMATION_TYPE |
BEN_ELP_EXTRA_INFO_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ELIGY_PRFL_ID
INFORMATION_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ELP_EXTRA_INFO_ID | NUMBER | (15) | Yes | System-generated primary key column. |
ELIGY_PRFL_ID | NUMBER | (15) | Yes | Foriegn Key to BEN_ELIGY_PRFL_F |
INFORMATION_TYPE | VARCHAR2 | (40) | Yes | Foreign Key to BEN_ELP_INFO_TYPES |
REQUEST_ID | NUMBER | (15) | Standard who column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard who column | |
PROGRAM_ID | NUMBER | (15) | Standard who column | |
PROGRAM_UPDATE_DATE | DATE | Standard who column | ||
ELI_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield | |
ELI_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield | |
ELI_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield | |
ELI_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield | |
ELI_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield | |
ELI_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield | |
ELI_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield | |
ELI_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield | |
ELI_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield | |
ELI_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield | |
ELI_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield | |
ELI_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield | |
ELI_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield | |
ELI_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield | |
ELI_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield | |
ELI_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield | |
ELI_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield | |
ELI_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield | |
ELI_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield | |
ELI_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield | |
ELI_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield | |
ELI_INFORMATION_CATEGORY | VARCHAR2 | (30) | Developer descriptive flexfield | |
ELI_INFORMATION1 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION2 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION3 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION4 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION5 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION6 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION7 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION8 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION9 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION10 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION11 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION12 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION13 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION14 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION15 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION16 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION17 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION18 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION19 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION20 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION21 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION22 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION23 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION24 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION25 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION26 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION27 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION28 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION29 | VARCHAR2 | (150) | Developer descriptive flexfield | |
ELI_INFORMATION30 | VARCHAR2 | (150) | Developer descriptive flexfield | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | System-generated version of row. Increments by one with each update |
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT ELP_EXTRA_INFO_ID
, ELIGY_PRFL_ID
, INFORMATION_TYPE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ELI_ATTRIBUTE_CATEGORY
, ELI_ATTRIBUTE1
, ELI_ATTRIBUTE2
, ELI_ATTRIBUTE3
, ELI_ATTRIBUTE4
, ELI_ATTRIBUTE5
, ELI_ATTRIBUTE6
, ELI_ATTRIBUTE7
, ELI_ATTRIBUTE8
, ELI_ATTRIBUTE9
, ELI_ATTRIBUTE10
, ELI_ATTRIBUTE11
, ELI_ATTRIBUTE12
, ELI_ATTRIBUTE13
, ELI_ATTRIBUTE14
, ELI_ATTRIBUTE15
, ELI_ATTRIBUTE16
, ELI_ATTRIBUTE17
, ELI_ATTRIBUTE18
, ELI_ATTRIBUTE19
, ELI_ATTRIBUTE20
, ELI_INFORMATION_CATEGORY
, ELI_INFORMATION1
, ELI_INFORMATION2
, ELI_INFORMATION3
, ELI_INFORMATION4
, ELI_INFORMATION5
, ELI_INFORMATION6
, ELI_INFORMATION7
, ELI_INFORMATION8
, ELI_INFORMATION9
, ELI_INFORMATION10
, ELI_INFORMATION11
, ELI_INFORMATION12
, ELI_INFORMATION13
, ELI_INFORMATION14
, ELI_INFORMATION15
, ELI_INFORMATION16
, ELI_INFORMATION17
, ELI_INFORMATION18
, ELI_INFORMATION19
, ELI_INFORMATION20
, ELI_INFORMATION21
, ELI_INFORMATION22
, ELI_INFORMATION23
, ELI_INFORMATION24
, ELI_INFORMATION25
, ELI_INFORMATION26
, ELI_INFORMATION27
, ELI_INFORMATION28
, ELI_INFORMATION29
, ELI_INFORMATION30
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM BEN.BEN_ELP_EXTRA_INFO;
BEN.BEN_ELP_EXTRA_INFO does not reference any database object
BEN.BEN_ELP_EXTRA_INFO is referenced by following:
|
|
|