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.IGFBV_DL_STAFFORD_PROM_NOTES

Object Details

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

View Type

A Business Intelligence System view

Base view for the entity that holds Direct Stafford Loan Promissory Notes

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_SEQUENCE_NUMBER	NUMBER	(15)	Yes	Sequence number generated for the entire batch
LOAN_NUMBER	VARCHAR2	(30)	Yes	Unique identifier for Direct Loan or CommonLine loan
STUDENT_SSN	VARCHAR2	(20)		Student's social security number
STUDENT_FIRST_NAME	VARCHAR2	(150)		Student First Name
STUDENT_LAST_NAME	VARCHAR2	(150)		Student Last Name
STUDENT_MIDDLE_NAME	VARCHAR2	(60)		Student Middle Name
STUDENT_DATE_OF_BIRTH	DATE			Student Date of Birth
STUDENT_LICENSE_NUMBER	VARCHAR2	(60)		Indicates driver's license number of PLUS borrower
STUDENT_LICENSE_STATE	VARCHAR2	(30)		Indicates driver's license state of PLUS borrower
STUDENT_PERMIT_ADDRESS1	VARCHAR2	(240)		First line for address
STUDENT_PERMIT_ADDRESS2	VARCHAR2	(240)		Second line for address
STUDENT_PERMIT_CITY	VARCHAR2	(60)		City
STUDENT_PERMIT_STATE	VARCHAR2	(60)		State
STUDENT_PERMIT_ZIP_CODE	VARCHAR2	(60)		Zip Code
STUDENT_EMAIL_ADDRESS	VARCHAR2	(100)		Email Address
STUDENT_PHONE_NUMBER	VARCHAR2	(100)		Phone Number
PROM_NOTE_PRINT_STATUS_FLAG	VARCHAR2	(30)		Indicates whether the Promissory Note had been actually Printed or Not
LOAN_ID	NUMBER	(15)	Yes	Identifier for loans
PERSON_ID	NUMBER	(15)	Yes	Person identifier
PROMISSORY_NOTE_PRINT_ID	NUMBER	(15)	Yes	Identifier for the Stafford Loan details that have been selected for printing the Promissory Note
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

Query Text

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


SELECT BATCH_SEQUENCE_NUMBER
,      LOAN_NUMBER
,      STUDENT_SSN
,      STUDENT_FIRST_NAME
,      STUDENT_LAST_NAME
,      STUDENT_MIDDLE_NAME
,      STUDENT_DATE_OF_BIRTH
,      STUDENT_LICENSE_NUMBER
,      STUDENT_LICENSE_STATE
,      STUDENT_PERMIT_ADDRESS1
,      STUDENT_PERMIT_ADDRESS2
,      STUDENT_PERMIT_CITY
,      STUDENT_PERMIT_STATE
,      STUDENT_PERMIT_ZIP_CODE
,      STUDENT_EMAIL_ADDRESS
,      STUDENT_PHONE_NUMBER
,      PROM_NOTE_PRINT_STATUS_FLAG
,      LOAN_ID
,      PERSON_ID
,      PROMISSORY_NOTE_PRINT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGFBV_DL_STAFFORD_PROM_NOTES;

Dependencies

[top of page]

APPS.IGFBV_DL_STAFFORD_PROM_NOTES references the following:

APPS: IGF_SL_DL_PNOTE_S_P_ALL

APPS.IGFBV_DL_STAFFORD_PROM_NOTES is not referenced by any database object