eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.IGFFV_VERIFICATION_WORKSHEETS

Object Details

Object Name:	IGFFV_VERIFICATION_WORKSHEETS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGFFV_VERIFICATION_WORKSHEETS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Full View for the Entity that holds the information about the verification values for all user-defined ISIR fields

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.IGFFV_VERIFICATION_WORKSHEETS references the following:

APPS: HZ_PARTIES; IGF_AP_BATCH_AW_MAP_ALL; IGF_AP_FA_BASE_REC_ALL; IGF_AP_INST_VER_ITEM_ALL; IGF_FC_SAR_CD_MST; IGS_CA_INST_ALL

APPS.IGFFV_VERIFICATION_WORKSHEETS is not referenced by any database object