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_COD_REP_V

Object Details

Object Name:	IGF_SL_COD_REP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGF_SL_COD_REP_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
REP_ENTITY_ID_TXT	VARCHAR2	(30)		Indicates reporting entity id
ATD_ENTITY_ID_TXT	VARCHAR2	(30)		Indicates attending entity id
AWARD_ID	NUMBER			Indicates the Award ID
BASE_ID	NUMBER			Indicates the base ID for the student
SOURCE_ENTITY_ID_TXT	VARCHAR2	(30)		Indicates source entity id
DOCUMENT_ID_TXT	VARCHAR2	(30)		Indicates the document ID
LOAN_KEY_NUM	NUMBER			Indicates the Loan key
INTEREST_REBATE_PERCENT_NUM	NUMBER			Indicates the interest rebate percent
FIN_AWARD_YEAR	VARCHAR2	(30)		Indicates the financial award year
CPS_TRANS_NUM	VARCHAR2	(2)		Indicates the CPS Trnasaction Number
NOTE_MESSAGE	VARCHAR2	(100)		Indicates the note message
FULL_RESP_CODE	VARCHAR2	(30)		Indicates the full response code
ORIGINATION_ID	NUMBER	(15)	Yes	Indicates the origination ID
LOAN_NUMBER_TXT	VARCHAR2	(30)	Yes	Indicates the Loan Number
FIN_AWD_NUM	VARCHAR2	(30)		Indicates the financial award number
LOAN_TYPE	VARCHAR2	(30)	Yes	Indicates the Direct Loan type
LOAN_AMT_ACCEPTED	NUMBER	(12)		Indicates the Loan amount accepted
LOAN_PER_BEGIN_DATE	VARCHAR2	(10)		Indicates loan period begin date
LOAN_PER_END_DATE	VARCHAR2	(10)		Indicates loan period end date
ACAD_YR_BEGIN_DATE	VARCHAR2	(10)		Indicates academic period begin date
ACAD_YR_END_DATE	VARCHAR2	(10)		Indicates academic period end date
ORIG_BATCH_DATE	VARCHAR2	(10)		Indicates the award origination date
PNOTE_PRINT_IND	VARCHAR2	(30)
S_DEPNCY_STATUS	VARCHAR2	(30)
S_DEFAULT_STATUS	VARCHAR2	(30)
UNSUB_ELIG_FOR_HEAL	VARCHAR2	(30)		Indicates student is eligible for additional unsubsidized funds in case of health professions
DISCLOSURE_PRINT_IND	VARCHAR2	(30)		Indicates whether LOC should print disclosure
UNSUB_ELIG_FOR_DEPNT	VARCHAR2	(30)		Indicates student is eligible for additional unsubsidized funds
ORIG_FEE_PERCT	NUMBER	(6)		Indicates the origination fee percent
LOAN_STATUS	VARCHAR2	(30)		Indicates the loan status
LOAN_CHG_STATUS	VARCHAR2	(30)		Indicates the loan change status
GRADE_LEVEL_CODE	VARCHAR2	(30)		Indicates the grade level code
P_SSN	VARCHAR2	(30)		Indicates the borrower's SSN
P_LAST_NAME	VARCHAR2	(150)		Indicates the borrower's last name
P_FIRST_NAME	VARCHAR2	(150)		Indicates the borrower's first name
P_MIDDLE_INITIAL	VARCHAR2	(1)		Indicates the borrower's middle initial
B_CHG_BIRTH_DATE	VARCHAR2	(10)		Indicates the borrower's changed date of birth
B_CHG_SSN	VARCHAR2	(30)		Indicates the borrower's changed SSN
B_CHG_LAST_NAME	VARCHAR2	(150)		Indicates the borrower's changed Last Name
P_PERMT_ADDR1	VARCHAR2	(240)		Indicates the borrower's permanent address line1
P_PERMT_ADDR2	VARCHAR2	(240)		Indicates the borrower's permanent address line2
P_PERMT_CITY	VARCHAR2	(60)		Indicates the borrower's permanent address city
P_PERMT_STATE	VARCHAR2	(60)		Indicates the borrower's permanent address state
P_PERMT_ZIP	VARCHAR2	(60)		Indicates the borrower's permanent address zip code
P_PERMT_PHONE	VARCHAR2	(30)		Indicates the borrower's permanent phone
P_EMAIL_ADDR	VARCHAR2	(60)		Indicates the borrower's e-mail address
P_DATE_OF_BIRTH	VARCHAR2	(10)		Indicates the borrower's date of birth
P_LICENSE_NUM	VARCHAR2	(30)		Indicates the borrower's license number
P_LICENSE_STATE	VARCHAR2	(60)		Indicates the borrower's license state
P_CITIZENSHIP_STATUS	VARCHAR2	(30)		Indicates the borrower's citizenship status
P_ALIEN_REG_NUM	VARCHAR2	(30)		Indicates the borrower's alien registration number
P_DEFAULT_STATUS	VARCHAR2	(30)		Indicates the borrower's default status
B_PERMT_COUNTRY	VARCHAR2	(30)		Indicates the borrower's permanent country
B_PERMT_COUNTY	VARCHAR2	(30)		Indicates the borrower's permanent county
P_FOREIGN_POSTAL_CODE	VARCHAR2	(30)		Indicates the borrower's foreign postal code
P_STATE_OF_LEGAL_RES	VARCHAR2	(60)		Indicates the borrower's state of legal residence

Query Text

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


SELECT REP_ENTITY_ID_TXT
,      ATD_ENTITY_ID_TXT
,      AWARD_ID
,      BASE_ID
,      SOURCE_ENTITY_ID_TXT
,      DOCUMENT_ID_TXT
,      LOAN_KEY_NUM
,      INTEREST_REBATE_PERCENT_NUM
,      FIN_AWARD_YEAR
,      CPS_TRANS_NUM
,      NOTE_MESSAGE
,      FULL_RESP_CODE
,      ORIGINATION_ID
,      LOAN_NUMBER_TXT
,      FIN_AWD_NUM
,      LOAN_TYPE
,      LOAN_AMT_ACCEPTED
,      LOAN_PER_BEGIN_DATE
,      LOAN_PER_END_DATE
,      ACAD_YR_BEGIN_DATE
,      ACAD_YR_END_DATE
,      ORIG_BATCH_DATE
,      PNOTE_PRINT_IND
,      S_DEPNCY_STATUS
,      S_DEFAULT_STATUS
,      UNSUB_ELIG_FOR_HEAL
,      DISCLOSURE_PRINT_IND
,      UNSUB_ELIG_FOR_DEPNT
,      ORIG_FEE_PERCT
,      LOAN_STATUS
,      LOAN_CHG_STATUS
,      GRADE_LEVEL_CODE
,      P_SSN
,      P_LAST_NAME
,      P_FIRST_NAME
,      P_MIDDLE_INITIAL
,      B_CHG_BIRTH_DATE
,      B_CHG_SSN
,      B_CHG_LAST_NAME
,      P_PERMT_ADDR1
,      P_PERMT_ADDR2
,      P_PERMT_CITY
,      P_PERMT_STATE
,      P_PERMT_ZIP
,      P_PERMT_PHONE
,      P_EMAIL_ADDR
,      P_DATE_OF_BIRTH
,      P_LICENSE_NUM
,      P_LICENSE_STATE
,      P_CITIZENSHIP_STATUS
,      P_ALIEN_REG_NUM
,      P_DEFAULT_STATUS
,      B_PERMT_COUNTRY
,      B_PERMT_COUNTY
,      P_FOREIGN_POSTAL_CODE
,      P_STATE_OF_LEGAL_RES
FROM APPS.IGF_SL_COD_REP_V;

Dependencies

[top of page]

APPS.IGF_SL_COD_REP_V references the following:

APPS: IGF_SL_LOR_LOC_ALL

APPS.IGF_SL_COD_REP_V is referenced by following:

APPS: IGF_SL_DL_GEN_XML - show dependent code