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_GR_REP_STDNT_V

Object Details

Object Name:	IGF_GR_REP_STDNT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGF_GR_REP_STDNT_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

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	Mandatory	Comments
DOCUMENT_ID_TXT	VARCHAR2	(30)		Indicates the Document ID
REP_ENTITY_ID_TXT	VARCHAR2	(30)		Indicates the reporting school entity ID
ATD_ENTITY_ID_TXT	VARCHAR2	(30)		Indicates the attending school entity ID
BASE_ID	NUMBER		Yes	Indicates the base ID for the student
S_SSN	VARCHAR2	(30)		Indicates the student's SSN
S_DATE_OF_BIRTH	VARCHAR2	(10)		Indicates the student's Date of Birth
S_LAST_NAME	VARCHAR2	(150)		Indicates the student's last name
S_CHG_SSN	VARCHAR2	(30)		Indicates the student's Changed SSN
DRIVER_LIC_STATE	VARCHAR2	(60)		Indicates the student's Driving License State
DRIVER_LIC_NUMBER	VARCHAR2	(30)		Indicates the student's Driving License Number
S_CHG_DATE_OF_BIRTH	VARCHAR2	(10)		Indicates the student's changed Date of Birth
FIRST_NAME	VARCHAR2	(60)		Indicates the student's First Name
MIDDLE_NAME	VARCHAR2	(60)		Indicates the student's Middle Name
S_CHG_LAST_NAME	VARCHAR2	(150)		Indicates the student's changed Last Name
CITZN_STATUS_CODE	VARCHAR2	(30)		Indicates the student's Citizen Status Code
NOTE_MESSAGE	VARCHAR2	(100)		Indicates the Note Message
PERMT_ADDR_FOREIGN_FLAG	VARCHAR2	(1)		Indicates if the permanent address is foreign or not
ADDR_TYPE_CODE	VARCHAR2	(30)		Indicates whether the address is Permanent or Temporary
PERMT_ADDR_LINE_1	VARCHAR2	(40)		Indicates the first line of permanent address
PERMT_ADDR_LINE_2	VARCHAR2	(40)		Indicates the second line of permanent address
PERMT_ADDR_LINE_3	VARCHAR2	(40)		Indicates the third line of permanent address
PERMT_ADDR_CITY	VARCHAR2	(60)		Indicates the permanent address's city
PERMT_ADDR_STATE_CODE	VARCHAR2	(30)		Indicates the permanent address's state code
PERMT_ADDR_POST_CODE	VARCHAR2	(30)		Indicates the permanent address's postal Code (zip code)
PERMT_ADDR_COUNTY	VARCHAR2	(30)		Indicates the permanent address's county
PERMT_ADDR_COUNTRY	VARCHAR2	(30)		Indicates the permanent address's country
PHONE_NUMBER	VARCHAR2	(30)		Indicating the person's phone number
EMAIL_ADDRESS	VARCHAR2	(138)		Indicates the E-mail address of the person

Query Text

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


SELECT DOCUMENT_ID_TXT
,      REP_ENTITY_ID_TXT
,      ATD_ENTITY_ID_TXT
,      BASE_ID
,      S_SSN
,      S_DATE_OF_BIRTH
,      S_LAST_NAME
,      S_CHG_SSN
,      DRIVER_LIC_STATE
,      DRIVER_LIC_NUMBER
,      S_CHG_DATE_OF_BIRTH
,      FIRST_NAME
,      MIDDLE_NAME
,      S_CHG_LAST_NAME
,      CITZN_STATUS_CODE
,      NOTE_MESSAGE
,      PERMT_ADDR_FOREIGN_FLAG
,      ADDR_TYPE_CODE
,      PERMT_ADDR_LINE_1
,      PERMT_ADDR_LINE_2
,      PERMT_ADDR_LINE_3
,      PERMT_ADDR_CITY
,      PERMT_ADDR_STATE_CODE
,      PERMT_ADDR_POST_CODE
,      PERMT_ADDR_COUNTY
,      PERMT_ADDR_COUNTRY
,      PHONE_NUMBER
,      EMAIL_ADDRESS
FROM APPS.IGF_GR_REP_STDNT_V;

Dependencies

[top of page]

APPS.IGF_GR_REP_STDNT_V references the following:

APPS: IGF_GR_COD_DTLS

APPS.IGF_GR_REP_STDNT_V is not referenced by any database object