[Home] [Help] [Dependency Information]
Object Name: | IGF_AW_ANTICPT_INTS |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_AW_ANTICPT_INTS |
Subobject Name: | |
Status: | VALID |
Interface table for uploading student anticipated data
Scope: public
Product: IGF
Lifecycle: active
Display Name: Awards - Import Anticipated Data
Category: BUSINESS_ENTITY IGF_COA
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_AW_ANTICPT_INTS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BATCH_NUM
CI_ALTERNATE_CODE LD_ALTERNATE_CODE PERSON_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_NUM | NUMBER | Yes | Batch Number Indicating the batch through which data is uploaded | |
CI_ALTERNATE_CODE | VARCHAR2 | (10) | Yes | Alternate code for the Award year Calendar Instance. |
LD_ALTERNATE_CODE | VARCHAR2 | (10) | Yes | Alternate Code fro the Load Calendar Instance |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person number whose anticipated data is being uploaded. |
ORG_UNIT_CD | VARCHAR2 | (30) | Organization Unit Code | |
PROGRAM_TYPE | VARCHAR2 | (10) | Program Type | |
PROGRAM_LOCATION_CD | VARCHAR2 | (10) | Program Location | |
PROGRAM_CD | VARCHAR2 | (6) | Program Code | |
CLASS_STANDING | VARCHAR2 | (50) | Class Standing | |
RESIDENCY_STATUS_CODE | VARCHAR2 | (30) | Residency Status | |
HOUSING_STATUS_CODE | VARCHAR2 | (30) | Housing Status | |
ATTENDANCE_TYPE | VARCHAR2 | (2) | Attendance Type | |
ATTENDANCE_MODE | VARCHAR2 | (2) | Attendance Mode | |
MONTHS_ENROLLED_NUM | NUMBER | Months Enrolled | ||
CREDIT_POINTS_NUM | NUMBER | Credit Points | ||
IMPORT_STATUS_TYPE | VARCHAR2 | (1) | Yes | Import Status Type |
IMPORT_RECORD_TYPE | VARCHAR2 | (1) | Yes | Import Record Type |
CREATED_BY | NUMBER | (15) | Standard Who column | |
CREATION_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Standard Who column for concurrent programs | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Who column for concurrent programs | ||
PROGRAM_ID | NUMBER | Standard Who column for concurrent programs | ||
PROGRAM_UPDATE_DATE | DATE | Standard Who column for concurrent programs |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_NUM
, CI_ALTERNATE_CODE
, LD_ALTERNATE_CODE
, PERSON_NUMBER
, ORG_UNIT_CD
, PROGRAM_TYPE
, PROGRAM_LOCATION_CD
, PROGRAM_CD
, CLASS_STANDING
, RESIDENCY_STATUS_CODE
, HOUSING_STATUS_CODE
, ATTENDANCE_TYPE
, ATTENDANCE_MODE
, MONTHS_ENROLLED_NUM
, CREDIT_POINTS_NUM
, IMPORT_STATUS_TYPE
, IMPORT_RECORD_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM IGF.IGF_AW_ANTICPT_INTS;
IGF.IGF_AW_ANTICPT_INTS does not reference any database object
IGF.IGF_AW_ANTICPT_INTS is referenced by following:
|
|
|