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_BATCH_YEAR_SETUPS

Object Details

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

View Type

A Business Intelligence System view

Full View for the Entity that holds the System Award Year Mapping details

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
_LA:SYSTEM_AWARD_YEAR	CHAR	(72)		Lookup tag to denotes the system award year to which the Financial Aid award year, isir batch year and profile year map
_LA:AWARD_YEAR_STATUS	CHAR	(77)		Lookup tag to indicate which award years that are open, closed or which years contain historical legacy to Financial Aid
NUMBER_OF_DAYS_DIVISOR	NUMBER	(2)		Values - 28/29/30/31
_LA:ROUND_OFF_FACTOR	CHAR	(68)		Lookup tag for round off factor code
AWARD_YEAR	VARCHAR2	(10)		Alternate short reference code for identifying a calendar instance
AWARD_YEAR_DESCRIPTION	VARCHAR2	(30)		Description for the Calendar Instance
AWARD_YEAR_CALENDAR_TYPE	VARCHAR2	(10)	Yes	Indicates code for award year calendar type
AWARD_YEAR_CAL_SEQ_NUMBER	NUMBER	(15)	Yes	Indicates unique identifier for award year calendar instance
_LA:PUBLISH_IN_SS_FLAG	CHAR	(65)		Indicates whether this award year is published to the student in student self-service.
BAM_ID	NUMBER	(15)	Yes	Identifier for the isir batch year and award year mapping
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 _LA:SYSTEM_AWARD_YEAR
,      _LA:AWARD_YEAR_STATUS
,      NUMBER_OF_DAYS_DIVISOR
,      _LA:ROUND_OFF_FACTOR
,      AWARD_YEAR
,      AWARD_YEAR_DESCRIPTION
,      AWARD_YEAR_CALENDAR_TYPE
,      AWARD_YEAR_CAL_SEQ_NUMBER
,      _LA:PUBLISH_IN_SS_FLAG
,      BAM_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGFFV_BATCH_YEAR_SETUPS;

Dependencies

[top of page]

APPS.IGFFV_BATCH_YEAR_SETUPS references the following:

APPS: IGF_AP_BATCH_AW_MAP_ALL; IGS_CA_INST_ALL

APPS.IGFFV_BATCH_YEAR_SETUPS is not referenced by any database object