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

TABLE: IGF.IGF_AW_UPLOAD_AWARD_ALL

Object Details
Object Name: IGF_AW_UPLOAD_AWARD_ALL
Object Type: TABLE
Owner: IGF
FND Design Data: TableIGF.IGF_AW_UPLOAD_AWARD_ALL
Subobject Name:
Status: VALID


FA125_3160568_CS_DP1.doc - Obsolete


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGF_AW_UPLOAD_AWARD_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnUPLD_ID
Columns
Name Datatype Length Mandatory Comments
UPLD_ID NUMBER (15) Yes Sequence generated Primary Key Column
FUND_ID NUMBER (15) Yes Unique identifier for each fund
TERM VARCHAR2 (30) Yes The external Term which will be mapped to an existing term in our system
SSN VARCHAR2 (9) Yes Students SSN
FIRST_NAME VARCHAR2 (30)
Students First name
LAST_NAME VARCHAR2 (30)
Students Last Name
AMOUNT NUMBER (12) Yes External Award Amount
ORG_ID NUMBER (15)
Operating unit identifier
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
Query Text

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


SELECT UPLD_ID
,      FUND_ID
,      TERM
,      SSN
,      FIRST_NAME
,      LAST_NAME
,      AMOUNT
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGF.IGF_AW_UPLOAD_AWARD_ALL;

Dependencies

[top of page]

IGF.IGF_AW_UPLOAD_AWARD_ALL does not reference any database object

IGF.IGF_AW_UPLOAD_AWARD_ALL is referenced by following:

SchemaAPPS
SynonymIGF_AW_UPLOAD_AWARD_ALL