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_ATTEND_MAP_ALL

Object Details

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

This table stores the mapping from Attendance Types, which are user-defined in OSS to the Attendance Types(enrollment status of Pell Grants/FFELP Loans/Application Processing) which is used in Financial Aid

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_AP_ATTEND_MAP_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ATM_ID
IGF_AP_ATTEND_MAP_ALL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ATTENDANCE_TYPE ORG_ID CAL_TYPE SEQUENCE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
ATM_ID	NUMBER	(15)	Yes	Sequence generated Column
ATTENDANCE_TYPE	VARCHAR2	(30)	Yes	Code of an institution-defined attendance type. An attendance type identifies whether a student is classified as part-time or full-time in the program,based on their study load in the reference year. Each attendance type must be mapped to a government attendance type, DETYA element 330
PELL_ATT_CODE	VARCHAR2	(30)		Holds the PELL grant mapping code for attendance type or enrollment status
CL_ATT_CODE	VARCHAR2	(30)		Holds the FFELP Loan mapping code for attendance type or enrollment status
AP_ATT_CODE	VARCHAR2	(30)		Holds the application processing used mapping code for attendance type or enrollment status
ORG_ID	NUMBER	(15)		Operating Unit Identifier
CREATED_BY	NUMBER	(15)	Yes	Standard Who Columns
CREATION_DATE	DATE		Yes	Standard Who Columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Columns
LAST_UPDATE_DATE	DATE		Yes	Standard Who Columns
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Columns
CAL_TYPE	VARCHAR2	(10)		Award Calendar Type
SEQUENCE_NUMBER	NUMBER	(6)		Award Calendar Sequence Number

Query Text

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


SELECT ATM_ID
,      ATTENDANCE_TYPE
,      PELL_ATT_CODE
,      CL_ATT_CODE
,      AP_ATT_CODE
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CAL_TYPE
,      SEQUENCE_NUMBER
FROM IGF.IGF_AP_ATTEND_MAP_ALL;

Dependencies

[top of page]

IGF.IGF_AP_ATTEND_MAP_ALL does not reference any database object

IGF.IGF_AP_ATTEND_MAP_ALL is referenced by following:

APPS: IGF_AP_ATTEND_MAP_ALL