[Home] [Help] [Dependency Information]
Object Name: | IGF_AP_LI_TODO_INTS |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_AP_LI_TODO_INTS |
Subobject Name: | |
Status: | VALID |
Interface table for To Do Items
Scope: public
Product: IGF
Lifecycle: active
Display Name: Legacy - To Do Item Import Process
Category: BUSINESS_ENTITY IGF_TODO
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_AP_LI_TODO_INTS_PK | NORMAL | UNIQUE | APPS_TS_INTERFACE | TDINT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_NUM | NUMBER | (15) | Yes | Batch Identifier, used to identify the set of records to be processed. |
TDINT_ID | NUMBER | Yes | Uniquely identify each record in the interface table. | |
CI_ALTERNATE_CODE | VARCHAR2 | (10) | Yes | Award Year |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Identifier for student |
ITEM_CODE | VARCHAR2 | (10) | Yes | Identifier for to-do item |
ITEM_ADD_DATE | DATE | Yes | Holds date on which to-do item instance was created | |
ITEM_STATUS_CODE | VARCHAR2 | (30) | Yes | Holds to-do item instance status. Values are requested, received complete, or received incomplete |
ITEM_STATUS_DATE | DATE | Holds to-do item status date | ||
CORSP_DATE | DATE | Holds date on which to-do item was last included in correspondence to student | ||
CORSP_COUNT_NUM | NUMBER | (15) | Holds information on number of times to-do item has been included in correspondence to student | |
MAX_ATTEMPT_NUM | NUMBER | (15) | Indicates the max number of time a correspondence should be sent to the student | |
FREQ_ATTEMPT_NUM | NUMBER | (15) | Indicates the frequency at which the correspondence should be sent to the student | |
REQD_FOR_APPLICATION_FLAG | VARCHAR2 | (1) | Denotes whether fulfillment of this to do item is mandatory for the Completion of Application Processing | |
INACTIVE_FLAG | VARCHAR2 | (1) | Describes whether to-do item has been inactivated for student | |
IMPORT_STATUS_TYPE | VARCHAR2 | (1) | Yes | Record's Import status |
IMPORT_RECORD_TYPE | VARCHAR2 | (1) | Determines whether this record has to update the System record if found in the system.Can have a value of U or Null | |
CREATED_BY | NUMBER | (15) | Standard Who Column | |
CREATION_DATE | DATE | Standard Who Column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
REQUEST_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
PROGRAM_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
PROGRAM_UPDATE_DATE | DATE | Standard Who column for concurrent programs | ||
RELATIONSHIP_CD | VARCHAR2 | (30) | Lender that the student selected as preferred |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_NUM
, TDINT_ID
, CI_ALTERNATE_CODE
, PERSON_NUMBER
, ITEM_CODE
, ITEM_ADD_DATE
, ITEM_STATUS_CODE
, ITEM_STATUS_DATE
, CORSP_DATE
, CORSP_COUNT_NUM
, MAX_ATTEMPT_NUM
, FREQ_ATTEMPT_NUM
, REQD_FOR_APPLICATION_FLAG
, INACTIVE_FLAG
, 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
, RELATIONSHIP_CD
FROM IGF.IGF_AP_LI_TODO_INTS;
IGF.IGF_AP_LI_TODO_INTS does not reference any database object
IGF.IGF_AP_LI_TODO_INTS is referenced by following:
|
|
|