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_RESP_DTLS_V

Object Details

Object Name:	IGF_GR_RESP_DTLS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGF_GR_RESP_DTLS_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)	Yes	Indicates the Document ID
DOC_CREATED_DATE	DATE			Indicates the created date
SOURCE_ENTITY_ID_TXT	VARCHAR2	(30)		Indicates the source entity id
DEST_ENTITY_ID_TXT	VARCHAR2	(30)		Indicates the destination entity id
SOFT_PROVIDER	VARCHAR2	(30)		Indicates the software provider
SOFT_VERSION	VARCHAR2	(30)		Indicates the software version
FULL_RESP_CODE	VARCHAR2	(30)		Indicates the full response code
RECEIPT_DATE	DATE			Indicates the receipt
DOC_TYPE_CODE	VARCHAR2	(30)		Indicates the document type code
DOC_STATUS_CODE	VARCHAR2	(30)		Indicates the document status
PROCESS_DATE	DATE			Indicates the process date
REP_SCHL_RESP_ID	NUMBER		Yes	Indicates the reporting school response id
REP_ENTITY_ID_TXT	VARCHAR2	(30)		Indicates the reporting entity id
REP_RESP_CODE	VARCHAR2	(30)		Indicates the reporting school response code
ATT_SCHL_RESP_ID	NUMBER		Yes	Indicates the attending school response id
ATD_ENTITY_ID_TXT	VARCHAR2	(30)		Indicates the attending entity id
ATT_RESP_CODE	VARCHAR2	(30)		Indicates the attending response code
STDNT_RESP_ID	NUMBER		Yes	Indicates the student's response id
S_SSN	VARCHAR2	(30)	Yes	Indicates the student's social security number
FIRST_NAME	VARCHAR2	(60)		Indicates the student's first name
S_LAST_NAME	VARCHAR2	(60)	Yes	Indicates the student's last name
S_DATE_OF_BIRTH	DATE		Yes	Indicates the student's date of birth
STUDENT_RESP_CODE	VARCHAR2	(30)		Indicates the student's response code
PELL_RESP_ID	NUMBER		Yes	Indicates the pell response id
FIN_AWD_YR	VARCHAR2	(30)		Indicates the financial award year
CPS_TRANS_NUM	VARCHAR2	(2)		Indicates the CPS transaction number
AWARD_AMT	NUMBER			Indicates the award amount
NOTE_MESSAGE	VARCHAR2	(100)		Indicates the Note message
COA_AMT	NUMBER			Indicates the cost of attendance amount
LOW_TUTION_FEE	VARCHAR2	(30)		Indicates the low tuition fee.
INCARC_FLAG	VARCHAR2	(30)		Indicates the incarcerated indicator
VER_STATUS_CODE	VARCHAR2	(30)		Indicates the verification status code.
ENROLLMENT_DATE	DATE			Indicates the enrollment date.
SEC_EFC_CODE	VARCHAR2	(30)		Indicates the secondary efc code
YTD_DISB_AMT	NUMBER			Indicates the year to date disbursement amount
TOT_ELIG_USED	NUMBER			Indicates the total eligible amount used
SCHD_PELL_AMT	NUMBER			Indicates the scheduled pell amount
NEG_PEND_AMT	NUMBER			Indicates the negative pending amount
FSA_CODE_1	VARCHAR2	(30)		Indicates the FSA code
FSA_CODE_2	VARCHAR2	(30)		Indicates the FSA code
FSA_CODE_3	VARCHAR2	(30)		Indicates the FSA code
CPS_VERIF_FLAG	VARCHAR2	(30)		Indicates the CPS verification flag.
HIGH_CPS_TRANS_NUM	NUMBER			Indicates the high CPS transaction number
PELL_RESP_CODE	VARCHAR2	(30)		Indicates the pell response code.

Query Text

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


SELECT DOCUMENT_ID_TXT
,      DOC_CREATED_DATE
,      SOURCE_ENTITY_ID_TXT
,      DEST_ENTITY_ID_TXT
,      SOFT_PROVIDER
,      SOFT_VERSION
,      FULL_RESP_CODE
,      RECEIPT_DATE
,      DOC_TYPE_CODE
,      DOC_STATUS_CODE
,      PROCESS_DATE
,      REP_SCHL_RESP_ID
,      REP_ENTITY_ID_TXT
,      REP_RESP_CODE
,      ATT_SCHL_RESP_ID
,      ATD_ENTITY_ID_TXT
,      ATT_RESP_CODE
,      STDNT_RESP_ID
,      S_SSN
,      FIRST_NAME
,      S_LAST_NAME
,      S_DATE_OF_BIRTH
,      STUDENT_RESP_CODE
,      PELL_RESP_ID
,      FIN_AWD_YR
,      CPS_TRANS_NUM
,      AWARD_AMT
,      NOTE_MESSAGE
,      COA_AMT
,      LOW_TUTION_FEE
,      INCARC_FLAG
,      VER_STATUS_CODE
,      ENROLLMENT_DATE
,      SEC_EFC_CODE
,      YTD_DISB_AMT
,      TOT_ELIG_USED
,      SCHD_PELL_AMT
,      NEG_PEND_AMT
,      FSA_CODE_1
,      FSA_CODE_2
,      FSA_CODE_3
,      CPS_VERIF_FLAG
,      HIGH_CPS_TRANS_NUM
,      PELL_RESP_CODE
FROM APPS.IGF_GR_RESP_DTLS_V;

Dependencies

[top of page]

APPS.IGF_GR_RESP_DTLS_V references the following:

APPS: IGF_GR_RESP_DTLS; IGF_SL_AS_RESP_DTLS; IGF_SL_CR_RESP_DTLS; IGF_SL_RS_RESP_DTLS; IGF_SL_ST_RESP_DTLS

APPS.IGF_GR_RESP_DTLS_V is not referenced by any database object