LN_CL_PNOTE_VW

(SQL View)
 Index Back

Loan CL Pnote View

View by LN_APPL_SEQ instead of LN_APPL_NUMBER.

SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,A.LOAN_TYPE ,A.LN_APPL_SEQ ,A.LN_APPL_NUMBER ,A.BORR_EMPLID ,A.LN_AMT_BORRQSTD ,A.LN_SUB_UNSUB_IND ,A.CL_FED_APP_FRM_CD ,A.LEND_UNQ_ID ,A.GUAR_UNQ_ID ,A.LN_PNOTE_SIGNED ,A.PNOTE_SGNTR_DT ,A.LN_STU_SIGNTR ,A.LN_STU_SIG_DT ,A.LN_DCMNT_ID ,A.LN_REQ_DEFRMNT ,A.CAPTLZ_INTRST ,A.LN_EFT_AUTHRZTN ,A.LN_PERIOD_START ,A.LN_PERIOD_END ,A.CL_BORR_REF_CD FROM PS_LN_CL_PNOTE A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

Prompt Table: AID_YEAR_TBL

4 LOAN_TYPE Character(4) VARCHAR2(4) NOT NULL Loan Type Cd

Prompt Table: LOAN_TYPE_VW

5 LN_APPL_SEQ Number(2,0) SMALLINT NOT NULL Loan Application Seq Num
6 LN_APPL_NUMBER Number(3,0) SMALLINT NOT NULL Loan Application Number
7 BORR_EMPLID Character(11) VARCHAR2(11) NOT NULL Borrower ID

Prompt Table: LN_BOR_RELAT_VW

8 LN_AMT_BORRQSTD Number(12,2) DECIMAL(11,2) NOT NULL Borrower Requested Amount
9 LN_SUB_UNSUB_IND Character(1) VARCHAR2(1) NOT NULL Sub/Unsub Request Fields on the Common Application
B=Both Sub/Unsub
S=Subsidized
U=Unsubsidized
10 CL_FED_APP_FRM_CD Character(1) VARCHAR2(1) NOT NULL Federal App Form Cd
B=Stafford Version 1/3/94
G=Graduate PLUS MPN
M=Stafford MPN
P=PLUS Version 4/25/94
Q=PLUS MPN
11 LEND_UNQ_ID Number(3,0) SMALLINT NOT NULL Lender ID

Prompt Table: LENDER_TBL

12 GUAR_UNQ_ID Number(3,0) SMALLINT NOT NULL Guarantor ID

Prompt Table: GUARANTOR_TBL

13 LN_PNOTE_SIGNED Character(1) VARCHAR2(1) NOT NULL Borrower Signature

Y/N Table Edit

14 PNOTE_SGNTR_DT Date(10) DATE Promissory Note Signature Dt
15 LN_STU_SIGNTR Character(1) VARCHAR2(1) NOT NULL Student Signature

Y/N Table Edit

16 LN_STU_SIG_DT Date(10) DATE Student Signature Date
17 LN_DCMNT_ID Character(16) VARCHAR2(16) NOT NULL Loan Document ID
18 LN_REQ_DEFRMNT Character(1) VARCHAR2(1) NOT NULL Request Loan Deferment
N=No
Y=Yes
19 CAPTLZ_INTRST Character(1) VARCHAR2(1) NOT NULL Capitalize Interest Cd
N=Capitalize while in school
Y=Pay interest while in school
20 LN_EFT_AUTHRZTN Character(1) VARCHAR2(1) NOT NULL Loan EFT Authorization
N=No
Y=Yes
21 LN_PERIOD_START Date(10) DATE Loan Period Start
22 LN_PERIOD_END Date(10) DATE Loan Period End
23 CL_BORR_REF_CD Character(1) VARCHAR2(1) NOT NULL Borrower References Cd
N=No, references incomplete
Y=Yes, references complete