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_FA_SETUP_ALL

Object Details

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

FA126_3102439_CS_DP2.doc - Obsolete

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_AP_FA_SETUP_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FAS_ID
IGF_AP_FA_SETUP_ALL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	FAO_ID ORG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FAO_ID	VARCHAR2	(30)	Yes	Unique identifier for financial aid office
FAO_NAME	VARCHAR2	(100)	Yes	Indicates unique name for financial aid office
PARTY_ID	NUMBER	(15)	Yes	Organization identifier for financial aid office
OPE_ID	VARCHAR2	(30)		Identifies Office of Post secondary Education identifier. Assigned by U.S. Department of Education for financial aid office.
PELL_ID	VARCHAR2	(30)		Identifies Pell grant institution identifier. Assigned by U.S. Department of Education for financial aid office.
DUNS_ID	VARCHAR2	(30)		Identifies DUNS identifier. Assigned by U.S. Department of Education for financial aid office.
CSS_ID	VARCHAR2	(30)		Identifier of financial aid office for college scholarship service. Assigned by CSS.
STATE_AGENCY_ID	VARCHAR2	(30)		Identifier assigned by state in which institution is located
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
FAS_ID	NUMBER	(15)	Yes	Identifier for Financial Aid setup
CAMPUS_ID	VARCHAR2	(30)		Identifier for School Campus
CRS_ID	VARCHAR2	(30)		Unique Identifier
LOW_DEFAULT	VARCHAR2	(30)		Indicates that the Organization is a low default school
QA_SCHOOL	VARCHAR2	(30)		Indicates that the Organization is a quality assurance school
EXPERIMENTAL	VARCHAR2	(30)		Indicates one of the setup attributes
GRADE_CALC_OPT	VARCHAR2	(30)		Indicates the grade calculation option
FSEOG_MATCH_MTHD	VARCHAR2	(30)		To determine the Matching Method to be used for Matching funds at the Fund Manager Level.
FSEOG_FED_PCT	NUMBER	(5)		To determine the FED FSEOG Fund Percentage.
FSEOG_WAIVER	VARCHAR2	(1)		To determine whether the institution has got a waiver for the FSEOG Funds.
DEST_NUM	VARCHAR2	(10)		Indicates the ISIR Destination Number assigned to the school.

Query Text

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


SELECT FAO_ID
,      FAO_NAME
,      PARTY_ID
,      OPE_ID
,      PELL_ID
,      DUNS_ID
,      CSS_ID
,      STATE_AGENCY_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      FAS_ID
,      CAMPUS_ID
,      CRS_ID
,      LOW_DEFAULT
,      QA_SCHOOL
,      EXPERIMENTAL
,      GRADE_CALC_OPT
,      FSEOG_MATCH_MTHD
,      FSEOG_FED_PCT
,      FSEOG_WAIVER
,      DEST_NUM
FROM IGF.IGF_AP_FA_SETUP_ALL;

Dependencies

[top of page]

IGF.IGF_AP_FA_SETUP_ALL does not reference any database object

IGF.IGF_AP_FA_SETUP_ALL is referenced by following:

APPS: IGF_AP_FA_SETUP_ALL