LOAN_MPN_VW

(SQL View)
 Index Back

PNote Vw-Loan Doc print SQR

Promissory Note view for Loan Document Printing

SELECT A.EMPLID, A.INSTITUTION, A.AID_YEAR, A.ACAD_CAREER, A.LOAN_TYPE, A.LN_APPL_SEQ, C.ITEM_TYPE, A.LN_MPN_SEQ, A.BORR_SSN, A.BORR_BIRTHDATE, A.BORR_CTZNSHP_STAT, A.BORR_VISA_WKPT_NBR, A.LN_BORR_DFLT_RFND, A.SSN, A.BIRTHDATE, A.CITIZENSHIP_STATUS, A.VISA_WRKPMT_NBR, A.LN_STDNT_DFLT_RFND, A.DRIVERS_LIC_NBR, A.LN_PERIOD_START, A.LN_PERIOD_END, A.FED_EFC, A.FED_YEAR_COA, A.LN_FIN_AID, A.LN_NET_COST, A.NSLDS_LOAN_YEAR, A.ACADEMIC_LOAD, A.LN_PRGCMPLT_DT, A.BORR_DRIVER_LIC_ST, E.DESCR, E.CPS_SCHOOL_CODE, E.ADDRESS1, E.CITY, E.STATE, E.POSTAL, F.LN_PNOTE_INTEREST, F.LOAN_INT_VARIABLE, T.LOAN_FEE_RT, C.LOAN_INTEREST_ATTR, C.LN_AMT_CERTIFIED, C.LN_APPL_ID, C.LN_ANTIC_FEE_TOT, C.LN_ANTIC_NET_TOT, T.LOAN_CATEGORY, B.LN_MPN_ACPT_AMT, F.LN_RPT_FORM_ID, ' ',' ',' ',' ',' ',' ',' ',' ',' ',' ', ' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ' FROM PS_LOAN_ORIGNATN A, PS_LOAN_MPN B, PS_LOAN_ORIG_DTL C, PS_LN_INSTUTN_TBL E, PS_LN_PNOTE_TBL F, PS_LN_TYPE_TBL T WHERE A.EMPLID = B.EMPLID AND A.INSTITUTION = B.INSTITUTION AND A.AID_YEAR = B.AID_YEAR AND A.ACAD_CAREER = B.ACAD_CAREER AND A.LN_MPN_SEQ = B.LN_MPN_SEQ AND A.EMPLID = C.EMPLID AND A.INSTITUTION = C.INSTITUTION AND A.AID_YEAR = C.AID_YEAR AND A.ACAD_CAREER = B.ACAD_CAREER AND A.LOAN_TYPE = C.LOAN_TYPE AND A.LN_APPL_SEQ = C.LN_APPL_SEQ AND A.INSTITUTION = E.INSTITUTION AND A.AID_YEAR = E.AID_YEAR AND A.ACAD_CAREER = E.ACAD_CAREER AND A.INSTITUTION = F.INSTITUTION AND A.AID_YEAR = F.AID_YEAR AND A.LOAN_TYPE = F.LOAN_TYPE AND A.INSTITUTION = T.INSTITUTION AND A.AID_YEAR = T.AID_YEAR AND A.LOAN_TYPE = T.LOAN_TYPE AND F.LN_DCMNT_TYPE = 'M' AND T.LOAN_CATEGORY IN ('S','U')

  • Related Language Record: LOANMPNVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
    4 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine
    5 LOAN_TYPE Character(4) VARCHAR2(4) NOT NULL Loan Type Cd
    6 LN_APPL_SEQ Number(2,0) SMALLINT NOT NULL Loan Application Seq Num
    7 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
    8 LN_MPN_SEQ Character(3) VARCHAR2(3) NOT NULL Loan MPN Sequence
    9 BORR_SSN Character(9) VARCHAR2(9) NOT NULL Borrower SSN
    10 BORR_BIRTHDATE Date(10) DATE Borrower Date of Birth
    11 BORR_CTZNSHP_STAT Character(1) VARCHAR2(1) NOT NULL Borrower Citizenship Stat
    1=Native
    2=Naturalized
    3=Alien Permanent
    4=Alien Temporary
    5=Permanent Resident
    N=Not Indicated
    12 BORR_VISA_WKPT_NBR Character(15) VARCHAR2(15) NOT NULL Borrower Visa/Permit Nbr
    13 LN_BORR_DFLT_RFND Character(1) VARCHAR2(1) NOT NULL Borr Default / Owes Refund
    N=No
    Y=Yes
    Z=Overridden by School
    14 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
    15 BIRTHDATE Date(10) DATE Date of Birth
    16 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status

    Prompt Table: HCR_CTZN_STS_I

    17 VISA_WRKPMT_NBR Character(15) VARCHAR2(15) NOT NULL Visa/Permit Number
    18 LN_STDNT_DFLT_RFND Character(1) VARCHAR2(1) NOT NULL Stdnt Default / Owes Refund
    N=No
    Y=Yes
    Z=Overridden by School
    19 DRIVERS_LIC_NBR Character(20) VARCHAR2(20) NOT NULL Driver's License #
    20 LN_PERIOD_START Date(10) DATE Loan Period Start
    21 LN_PERIOD_END Date(10) DATE Loan Period End
    22 FED_EFC Signed Number(7,0) DECIMAL(6) NOT NULL Federal EFC
    23 FED_YEAR_COA Number(9,2) DECIMAL(8,2) NOT NULL Fed Year COA
    24 LN_FIN_AID Number(6,0) INTEGER NOT NULL Loan Financial Aid
    25 LN_NET_COST Signed Number(6,0) DECIMAL(5) NOT NULL Loan Net Cost
    26 NSLDS_LOAN_YEAR Character(1) VARCHAR2(1) NOT NULL NSLDS Loan Year
    0=1st Year - Never Attended
    1=1st Year - Previously Attended
    2=2nd Year
    3=3rd Year
    4=4th Year
    5=5th Year+
    A=1st Year Graduate
    B=2nd Year Graduate
    C=3rd Year Graduate
    D=4th or more Graduate
    G=Graduate/Professional
    27 ACADEMIC_LOAD Character(1) VARCHAR2(1) NOT NULL Academic Load
    F=Enrolled Full-Time
    H=Enrolled Half-Time
    L=Less than Half-Time
    N=No Unit Load
    P=Enrolled Part-Time
    T=Three Quarter Time
    28 LN_PRGCMPLT_DT Date(10) DATE Program Completion Dt
    29 BORR_DRIVER_LIC_ST Character(6) VARCHAR2(6) NOT NULL Borrower Drivers license State
    30 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    31 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code
    32 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    33 CITY Character(30) VARCHAR2(30) NOT NULL City
    34 STATE Character(6) VARCHAR2(6) NOT NULL State
    35 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    36 LN_PNOTE_INTEREST Number(5,2) DECIMAL(4,2) NOT NULL Loan P-Note Interest Rate
    37 LOAN_INT_VARIABLE Character(1) VARCHAR2(1) NOT NULL Variable Interest Rate
    38 LOAN_FEE_RT Number(6,3) DECIMAL(5,3) NOT NULL Loan Fee Rate
    39 LOAN_INTEREST_ATTR Character(1) VARCHAR2(1) NOT NULL Loan Interest Attribute
    S=Subsidized
    U=Unsubsidized
    40 LN_AMT_CERTIFIED Number(12,2) DECIMAL(11,2) NOT NULL Loan Certified Amount
    41 LN_APPL_ID Character(21) VARCHAR2(21) NOT NULL Loan Application ID
    42 LN_ANTIC_FEE_TOT Number(12,2) DECIMAL(11,2) NOT NULL Anticipated Loan Fee Total
    43 LN_ANTIC_NET_TOT Number(12,2) DECIMAL(11,2) NOT NULL Anticipated Loan Net Total
    44 LOAN_CATEGORY Character(1) VARCHAR2(1) NOT NULL Loan Category
    B=Sub / Unsub
    O=Alternative Loan
    P=PLUS
    S=Subsidized
    U=Unsubsidized
    45 LN_MPN_ACPT_AMT Number(5,0) INTEGER NOT NULL MPN Accepted Amount
    46 LN_RPT_FORM_ID Character(10) VARCHAR2(10) NOT NULL Loan Report Form ID
    47 LN_MPN_SECT_A_LBL Character(1) VARCHAR2(1) NOT NULL MPN Section A
    48 LN_MPN_LABEL_1 Character(1) VARCHAR2(1) NOT NULL MPN Label 1
    49 LN_MPN_DL_ST_NO Character(1) VARCHAR2(1) NOT NULL MPN DL State and No Frmt
    50 LN_MPN_LABEL_2 Character(1) VARCHAR2(1) NOT NULL MPN Label 2
    51 LN_MPN_LABEL_3 Character(1) VARCHAR2(1) NOT NULL MPN Label 3
    52 LN_MPN_LABEL_4 Character(1) VARCHAR2(1) NOT NULL MPN Label 4
    53 LN_MPN_LABEL_4A Character(1) VARCHAR2(1) NOT NULL MPN Label 4
    54 LN_MPN_LABEL_5 Character(1) VARCHAR2(1) NOT NULL MPN Label 5
    55 LN_MPN_LABEL_6 Character(1) VARCHAR2(1) NOT NULL MPN Label 6
    56 LN_MPN_NAME_LFM Character(1) VARCHAR2(1) NOT NULL MPN Last, First, M.I.
    57 LN_MPN_ADDR_1_FRMT Character(1) VARCHAR2(1) NOT NULL MPN Borr Address Formatted
    58 LN_MPN_ADDR_2_FRMT Character(1) VARCHAR2(1) NOT NULL MPN Borr Address Formatted
    59 LN_MPN_LN_AMT_LBL Character(1) VARCHAR2(1) NOT NULL MPN LN Amt Label
    60 LN_MPN_SECT_B_LBL Character(1) VARCHAR2(1) NOT NULL MPN Section B
    61 LN_MPN_LABEL_9 Character(1) VARCHAR2(1) NOT NULL MPN Label 9
    62 LN_MPN_SCHL_NAME Character(1) VARCHAR2(1) NOT NULL MPN School Name
    63 LN_MPN_SCHL_ADDR_1 Character(1) VARCHAR2(1) NOT NULL MPN School Addr 1
    64 LN_MPN_SCHL_ADDR_2 Character(1) VARCHAR2(1) NOT NULL MPN School Addr 2
    65 LN_MPN_LABEL_10A Character(1) VARCHAR2(1) NOT NULL MPN Label 10a
    66 LN_MPN_LABEL_10B Character(1) VARCHAR2(1) NOT NULL MPN Label 10b
    67 LN_MPN_LABEL_11 Character(1) VARCHAR2(1) NOT NULL MPN Label 11
    68 LN_MPN_LN_ID_FRMT Character(1) VARCHAR2(1) NOT NULL MPN LN ID Formatted