[Home] [Help] [Dependency Information]
Object Name: | IGFFV_VERIFICATION_WORKSHEETS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGFFV_VERIFICATION_WORKSHEETS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Full View for the Entity that holds the information about the verification values for all user-defined ISIR fields
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person Number |
PERSON_NAME | VARCHAR2 | (360) | Yes | Person Name |
ITEM_VALUE | VARCHAR2 | (100) | Value of user-defined verification item | |
_LA:WAIVE_FLAG | CHAR | (50) | Lookup tag for Key which denotes whether verification item is waived | |
ISIR_FIELD | VARCHAR2 | (30) | Stores the ISIR SAR Column Number from Lookups. It is a Verification Item. | |
_LA:ISIR_FIELD_NAME | CHAR | (70) | Lookup tag for the ISIR SAR Column Names | |
_LA:INCL_IN_TOLERANCE_FLAG | CHAR | (64) | Lookup tag to indicate that the item is included in the Total Tolerance Amount | |
_LA:LEGACY_RECORD_FLAG | CHAR | (65) | Lookup tag to indicates weather the record was imported through a legacy process or not | |
_LA:USE_BLANK_FLAG | CHAR | (61) | Lookup tag for Y/N identifier which will determine if a null value is a documented value | |
AWARD_YEAR | VARCHAR2 | (10) | Alternate Code for Award Year | |
AWARD_YEAR_DESCRIPTION | VARCHAR2 | (30) | Award Year Description | |
AWARD_YEAR_CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Indicates code for award year calendar type |
AWARD_YEAR_CAL_SEQ_NUMBER | NUMBER | (6) | Yes | Indicates unique identifier for award year calendar instance |
UDF_VERN_ITEM_SEQ_NUM | NUMBER | (15) | Yes | Identifier for user-defined verification items |
BASE_ID | NUMBER | (10) | Yes | Unique identifier for student financial aid record |
PERSON_ID | NUMBER | (15) | Yes | Person Id |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_NUMBER
, PERSON_NAME
, ITEM_VALUE
, _LA:WAIVE_FLAG
, ISIR_FIELD
, _LA:ISIR_FIELD_NAME
, _LA:INCL_IN_TOLERANCE_FLAG
, _LA:LEGACY_RECORD_FLAG
, _LA:USE_BLANK_FLAG
, AWARD_YEAR
, AWARD_YEAR_DESCRIPTION
, AWARD_YEAR_CALENDAR_TYPE
, AWARD_YEAR_CAL_SEQ_NUMBER
, UDF_VERN_ITEM_SEQ_NUM
, BASE_ID
, PERSON_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGFFV_VERIFICATION_WORKSHEETS;
APPS.IGFFV_VERIFICATION_WORKSHEETS is not referenced by any database object
|
|
|