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]

TABLE: IGF.IGF_AP_BATCH_AW_MAP_ALL

Object Details

Object Name:	IGF_AP_BATCH_AW_MAP_ALL
Object Type:	TABLE
Owner:	IGF
FND Design Data:	IGF.IGF_AP_BATCH_AW_MAP_ALL
Subobject Name:
Status:	VALID

IGF_AP_BATCH_AW_MAP_ALL stores the ISIR batch year and award year mapping.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_AP_BATCH_AW_MAP_ALL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	BAM_ID
IGF_AP_BATCH_AW_MAP_ALL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	CI_CAL_TYPE CI_SEQUENCE_NUMBER
IGF_AP_BATCH_AW_MAP_ALL_U6	NORMAL	UNIQUE	APPS_TS_TX_IDX	SYS_AWARD_YEAR

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_YEAR	NUMBER	(2)		Contains batch year as present in ISIR data file
CI_SEQUENCE_NUMBER	NUMBER	(15)	Yes	Indicates unique identifier for award year calendar instance
CI_CAL_TYPE	VARCHAR2	(10)	Yes	Indicates code for award year calendar type. Used within operating unit.
CI_SEQUENCE_NUMBER_ACAD	NUMBER	(15)		Indicates unique identifier for academic year calendar instance - Obsoleted
CI_CAL_TYPE_ACAD	VARCHAR2	(10)		Indicates code for academic year calendar type. Used within operating unit. - Obsoleted
CI_CAL_TYPE_ADM	VARCHAR2	(10)		Indicates code for admission calendar type. Used within operating unit. - Obsoleted
CI_SEQUENCE_NUMBER_ADM	NUMBER	(15)		Indicates unique identifier for admission calendar instance - Obsoleted
CSS_ACADEMIC_YEAR	NUMBER			CSS Academic Year
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
ORG_ID	NUMBER	(15)		Operating unit identifier
BAM_ID	NUMBER	(15)	Yes	Identifier for the ISIR batch year and Award year mapping
EFC_FRML	VARCHAR2	(30)		EFC formula code with lookup_type as 'IGF_AP_EFC_FRML'
NUM_DAYS_DIVISOR	NUMBER	(2)		Status values - 28/29/30/31
ROUNDOFF_FACT	VARCHAR2	(30)		Stores the round off factor code. comes from lookups with lookup_type 'IGF_AP_EFC_ROUND_FACT'
EFC_DOB	DATE			Indicates Default Date of Birth for Family Contribution Calculation
DL_CODE	VARCHAR2	(30)		Indicates Direct Loan Record Version
FFEL_CODE	VARCHAR2	(30)		Indicates FFEL Record Version
PELL_CODE	VARCHAR2	(30)		Indicates Pell Record Version
ISIR_CODE	VARCHAR2	(30)		Indicates ISIR Record Version
PROFILE_CODE	VARCHAR2	(30)		Indicates Profile Record Version
SYS_AWARD_YEAR	VARCHAR2	(30)		Stores the system award year to which the Financial aid award year , ISIR batch year and Profile year map
TOLERANCE_LIMIT	NUMBER	(14)		Indicates extent to which any difference in ISIR amount and verification amount is ignored
AWARD_YEAR_STATUS_CODE	VARCHAR2	(30)		Indicates which award years that are open, closed or which years contain historical legacy to Financial Aid
PELL_PARTICIPANT_CODE	VARCHAR2	(80)		Indicates whether the school is full participant or phase-in-participant for Pell
DL_PARTICIPANT_CODE	VARCHAR2	(80)		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 BATCH_YEAR
,      CI_SEQUENCE_NUMBER
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER_ACAD
,      CI_CAL_TYPE_ACAD
,      CI_CAL_TYPE_ADM
,      CI_SEQUENCE_NUMBER_ADM
,      CSS_ACADEMIC_YEAR
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      BAM_ID
,      EFC_FRML
,      NUM_DAYS_DIVISOR
,      ROUNDOFF_FACT
,      EFC_DOB
,      DL_CODE
,      FFEL_CODE
,      PELL_CODE
,      ISIR_CODE
,      PROFILE_CODE
,      SYS_AWARD_YEAR
,      TOLERANCE_LIMIT
,      AWARD_YEAR_STATUS_CODE
,      PELL_PARTICIPANT_CODE
,      DL_PARTICIPANT_CODE
,      PUBLISH_IN_SS_FLAG
FROM IGF.IGF_AP_BATCH_AW_MAP_ALL;

Dependencies

[top of page]

IGF.IGF_AP_BATCH_AW_MAP_ALL does not reference any database object

IGF.IGF_AP_BATCH_AW_MAP_ALL is referenced by following:

APPS: IGF_AP_BATCH_AW_MAP_ALL