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_SL_REP_STDNT_V

Object Details

Object Name:	IGF_SL_REP_STDNT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGF_SL_REP_STDNT_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	Comments
BASE_ID	NUMBER		Indicates the base ID for the student
S_SSN	VARCHAR2	(30)	Indicates the student's SSN
S_LAST_NAME	VARCHAR2	(150)	Indicates the student's last name
S_FIRST_NAME	VARCHAR2	(150)	Indicates the student's middle name
S_MIDDLE_INITIAL	VARCHAR2	(1)	Indicates the student's middle initial name
S_PERMT_ADDR1	VARCHAR2	(240)	Indicates the student's permanent address line1
S_PERMT_ADDR2	VARCHAR2	(240)	Indicates the student's permanent address line2
S_PERMT_CITY	VARCHAR2	(60)	Indicates the student's permanent address city
S_PERMT_STATE	VARCHAR2	(60)	Indicates the student's permanent address state
S_PERMT_ZIP	VARCHAR2	(60)	Indicates the student's permanent address zip code
S_PERMT_PHONE	VARCHAR2	(30)	Indicates the student's permanent phone
S_EMAIL_ADDR	VARCHAR2	(60)	Indicates the student's e-mail address
S_DATE_OF_BIRTH	VARCHAR2	(10)	Indicates the student's date of birth
S_CHG_BIRTH_DATE	VARCHAR2	(10)	Indicates the changed date of birth
S_CHG_SSN	VARCHAR2	(30)	Indicates the changed SSN
S_PERMT_COUNTY	VARCHAR2	(30)	Indicates the student's county
S_PERMT_COUNTRY	VARCHAR2	(30)	Indicates the student's country
S_CHG_LAST_NAME	VARCHAR2	(150)	Indicates the changed Last Name
S_LICENSE_NUM	VARCHAR2	(30)	Indicates the student's license number
S_LICENSE_STATE	VARCHAR2	(60)	Indicates the student's license state
S_DEPNCY_STATUS	VARCHAR2	(30)	Indicates the student's dependency status
S_CITIZENSHIP_STATUS	VARCHAR2	(30)	Indicates the student's citizenship status
S_FOREIGN_POSTAL_CODE	VARCHAR2	(30)	Indicates the student's foreign postal code
ATD_ENTITY_ID_TXT	VARCHAR2	(30)	Indicates the attending school entity ID
REP_ENTITY_ID_TXT	VARCHAR2	(30)	Indicates the reporting school entity ID
DOCUMENT_ID_TXT	VARCHAR2	(30)	Indicates the Document ID

Query Text

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


SELECT BASE_ID
,      S_SSN
,      S_LAST_NAME
,      S_FIRST_NAME
,      S_MIDDLE_INITIAL
,      S_PERMT_ADDR1
,      S_PERMT_ADDR2
,      S_PERMT_CITY
,      S_PERMT_STATE
,      S_PERMT_ZIP
,      S_PERMT_PHONE
,      S_EMAIL_ADDR
,      S_DATE_OF_BIRTH
,      S_CHG_BIRTH_DATE
,      S_CHG_SSN
,      S_PERMT_COUNTY
,      S_PERMT_COUNTRY
,      S_CHG_LAST_NAME
,      S_LICENSE_NUM
,      S_LICENSE_STATE
,      S_DEPNCY_STATUS
,      S_CITIZENSHIP_STATUS
,      S_FOREIGN_POSTAL_CODE
,      ATD_ENTITY_ID_TXT
,      REP_ENTITY_ID_TXT
,      DOCUMENT_ID_TXT
FROM APPS.IGF_SL_REP_STDNT_V;

Dependencies

[top of page]

APPS.IGF_SL_REP_STDNT_V references the following:

APPS: IGF_SL_LOR_LOC_ALL

APPS.IGF_SL_REP_STDNT_V is referenced by following:

APPS: IGF_SL_DL_GEN_XML - show dependent code