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.IGF_AP_AWARD_YEAR_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Database rowid for the calender instance
CAL_TYPE	VARCHAR2	(10)	Yes	Indicates the code for the award year calender type, used within the operating unit
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Indicates a unique identifier for the award year calender instance
START_DT	DATE		Yes	Indicates the award year start date
END_DT	DATE		Yes	Indicates the award year end date
CAL_STATUS	VARCHAR2	(10)	Yes	Status of the calendar instance, that indicates the level of activity of the calendar. Each status is mapped to one of the system statuses of ACTIVE, INACTIVE, or PLANNED.
ALTERNATE_CODE	VARCHAR2	(10)		Indicates the alternate short reference code for identifying a award year calendar instance
SUP_CAL_STATUS_DIFFER_IND	VARCHAR2	(1)	Yes	System-set indicator that specifies if the status of a calendar instance differs from the status of any of its superior calendar instances
PRIOR_CI_SEQUENCE_NUMBER	NUMBER	(6)		Unique identifier for a prior calendar instance. Set when calendar instance is the result of a rolled over calendar.
ORG_ID	NUMBER	(15)		Identifies the operating unit identifier
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
CAL_DESCRIPTION	VARCHAR2	(30)		The description associated with the Calender instance.
AWARD_YEAR_STATUS_CODE	VARCHAR2	(30)		Identfies code for different statuses of award year
AWARD_YEAR_STATUS_DESC	VARCHAR2	(4000)		Identify different statuses of award year
PELL_PARTICIPANT_CODE	VARCHAR2	(80)		Code for whether the school is full participant or phase-in-participant for Pell
PELL_PARTICIPANT_DESC	VARCHAR2	(4000)		Indicates whether the school is full participant or phase-in-participant for Pell
DL_PARTICIPANT_CODE	VARCHAR2	(80)		Code for whether the school is full participant or phase-in-participant for Direct Loan
DL_PARTICIPANT_DESC	VARCHAR2	(4000)		Indicates whether the school is full participant or phase-in-participant for Direct Loan
PUBLISH_IN_SS_FLAG	VARCHAR2	(1)		Indicates whether this award year is published to the student in student self-service.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      CAL_TYPE
,      SEQUENCE_NUMBER
,      START_DT
,      END_DT
,      CAL_STATUS
,      ALTERNATE_CODE
,      SUP_CAL_STATUS_DIFFER_IND
,      PRIOR_CI_SEQUENCE_NUMBER
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CAL_DESCRIPTION
,      AWARD_YEAR_STATUS_CODE
,      AWARD_YEAR_STATUS_DESC
,      PELL_PARTICIPANT_CODE
,      PELL_PARTICIPANT_DESC
,      DL_PARTICIPANT_CODE
,      DL_PARTICIPANT_DESC
,      PUBLISH_IN_SS_FLAG
FROM APPS.IGF_AP_AWARD_YEAR_V;

Dependencies

[top of page]

APPS.IGF_AP_AWARD_YEAR_V references the following:

APPS: IGF_AP_BATCH_AW_MAP_ALL; IGF_AW_GEN - show dependent code; IGS_CA_INST

APPS.IGF_AP_AWARD_YEAR_V is referenced by following:

APPS: IGF_DB_SF_INTEGRATION - show dependent code; IGF_GR_GEN - show dependent code