[Home] [Help] [Dependency Information]
Object Name: | IGFBV_TRACK_STUDENT_TODO_ITEMS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGFBV_TRACK_STUDENT_TODO_ITEMS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Base View for the Entity that stores the item instance information
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
_LA:ITEM_STATUS | CHAR | (59) | Holds to-do item instance status | |
ITEM_STATUS_DATE | DATE | Holds to-do item status date | ||
ITEM_ADD_DATE | DATE | Holds date on which to-do item instance was created | ||
CORRESPONDENCE_DATE | DATE | Holds date on which to-do item was last included in correspondence to student | ||
CORRESPONDENCE_COUNT | NUMBER | (15) | Holds information on number of times to-do item has been included in correspondence to student | |
_LA:INACTIVE_FLAG | CHAR | (61) | Lookup tag indicates whether to-do item has been inactivated for student | |
_LA:REQD_FOR_COMPLETION_FLAG | CHAR | (72) | Lookup tag indicates whether fulfillment of this todo item is mandatory for the Completion of Application Processing | |
FREQUENCY_ATTEMPTS | NUMBER | (15) | Indicates the frequency at which the correspondence should be sent to the student | |
MAXIMUM_ATTEMPTS | NUMBER | (15) | Indicates the max number of time a correspondence should be sent to the student | |
_LA:LEGACY_RECORD_FLAG | CHAR | (66) | Indicates weather the record was imported through a legacy process or not | |
AWARD_YEAR | VARCHAR2 | (10) | Alternate short reference code for identifying a calendar instance. | |
AWARD_YEAR_DESCRIPTION | VARCHAR2 | (30) | Description for the Calendar Instance | |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person Unique identification number |
PERSON_NAME | VARCHAR2 | (360) | Yes | Person Name |
ITEM_CODE | VARCHAR2 | (10) | Yes | Holds the To do item code |
ITEM_DESCRIPTION | VARCHAR2 | (30) | Yes | Holds the description of the ToDo Item |
BASE_ID | NUMBER | (15) | Yes | Identifier for student financial aid record |
ITEM_SEQUENCE_NUMBER | NUMBER | (15) | Yes | Identifier for to-do item instance |
CLPRL_ID | NUMBER | Lender that the student selected as preferred | ||
CREATED_BY | NUMBER | (15) | Yes | WHO column |
CREATION_DATE | DATE | Yes | WHO column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | WHO column |
LAST_UPDATE_DATE | DATE | Yes | WHO column | |
PERSON_ID | NUMBER | (15) | Yes | Person identifier |
Cut, paste (and edit) the following text to query this object:
SELECT _LA:ITEM_STATUS
, ITEM_STATUS_DATE
, ITEM_ADD_DATE
, CORRESPONDENCE_DATE
, CORRESPONDENCE_COUNT
, _LA:INACTIVE_FLAG
, _LA:REQD_FOR_COMPLETION_FLAG
, FREQUENCY_ATTEMPTS
, MAXIMUM_ATTEMPTS
, _LA:LEGACY_RECORD_FLAG
, AWARD_YEAR
, AWARD_YEAR_DESCRIPTION
, PERSON_NUMBER
, PERSON_NAME
, ITEM_CODE
, ITEM_DESCRIPTION
, BASE_ID
, ITEM_SEQUENCE_NUMBER
, CLPRL_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, PERSON_ID
FROM APPS.IGFBV_TRACK_STUDENT_TODO_ITEMS;
APPS.IGFBV_TRACK_STUDENT_TODO_ITEMS is not referenced by any database object
|
|
|