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_GR_ATTEND_PELL

Object Details

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

Entity holding Attending Pell Identifiers of an Organization

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_GR_ATTEND_PELL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACAMPUS_ID
IGF_GR_ATTEND_PELL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RCAMPUS_ID
IGF_GR_ATTEND_PELL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CI_CAL_TYPE CI_SEQUENCE_NUMBER ATTENDING_PELL_CD
IGF_GR_ATTEND_PELL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CI_CAL_TYPE CI_SEQUENCE_NUMBER ATD_ENTITY_ID_TXT

Columns

Name	Datatype	Length	Mandatory	Comments
ACAMPUS_ID	NUMBER		Yes	Unique identifier for Attending Pell Record
RCAMPUS_ID	NUMBER		Yes	Identifier referencing to the reporting pell identifier
CI_CAL_TYPE	VARCHAR2	(10)	Yes	Name of the type of the calendar used within the Organization
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Unique identifier for the calendar instance
ATTENDING_PELL_CD	VARCHAR2	(30)		Attending Pell Identifier of the Organization
OPE_CD	VARCHAR2	(20)		OPE Identifier of the Organization
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
ATD_ENTITY_ID_TXT	VARCHAR2	(8)		Indicates Attending Entity ID

Query Text

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


SELECT ACAMPUS_ID
,      RCAMPUS_ID
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      ATTENDING_PELL_CD
,      OPE_CD
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATD_ENTITY_ID_TXT
FROM IGF.IGF_GR_ATTEND_PELL;

Dependencies

[top of page]

IGF.IGF_GR_ATTEND_PELL does not reference any database object

IGF.IGF_GR_ATTEND_PELL is referenced by following:

APPS: IGF_GR_ATTEND_PELL