LN_CL_PN_SRCH_1

(SQL View)
 Index Back

CommonLine PNote Srch - Staf

CommonLine PNote Srch - Staf

SELECT A.EMPLID, A.INSTITUTION, A.AID_YEAR, A.LOAN_TYPE, A.LN_APPL_NUMBER, A.BORR_EMPLID, A.LN_AMT_BORRQSTD, A.LN_SUB_UNSUB_IND, A.LN_APPL_SEQ, 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, PS_LN_TYPE_TBL B WHERE A.INSTITUTION = B.INSTITUTION AND A.AID_YEAR = B.AID_YEAR AND A.LOAN_TYPE = B.LOAN_TYPE AND B.LOAN_PROGRAM = 'F' AND B.LOAN_CATEGORY IN ('B','S','U')

  • Parent record: STUDENT_AID

    • # 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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: AID_YEAR_TBL

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

    Prompt Table: %EDITTABLE

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

    Prompt Table: LN_BOR_RELAT_VW

    7 LN_AMT_BORRQSTD Number(12,2) DECIMAL(11,2) NOT NULL Borrower Requested Amount
    8 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

    Default Value: B

    9 LN_APPL_SEQ Number(2,0) SMALLINT NOT NULL Loan Application Seq Num
    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

    Default Value: N

    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

    Default Value: N

    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