SFA_CRC_PNSRCH1

(SQL View)
 Index Back

CRC PNote Srch - Staf

CRC 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.LN_PNOTE_SIGNED ,A.PNOTE_SGNTR_DT ,A.LN_STU_SIGNTR ,A.LN_STU_SIG_DT ,A.LN_REQ_DEFRMNT ,A.CAPTLZ_INTRST ,A.LN_EFT_AUTHRZTN ,A.CL_BORR_REF_CD ,A.SFA_CR_AWARD_ID ,A.SFA_CR_LNDR_BRANCH ,A.SFA_CR_LNDR_OPEID ,A.SFA_CR_GUAR_BRANCH ,A.SFA_CR_GUAR_OPEID FROM PS_SFA_CRC_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 LN_PNOTE_SIGNED Character(1) VARCHAR2(1) NOT NULL Borrower Signature

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    14 LN_STU_SIG_DT Date(10) DATE Student Signature Date
    15 LN_REQ_DEFRMNT Character(1) VARCHAR2(1) NOT NULL Request Loan Deferment
    N=No
    Y=Yes
    16 CAPTLZ_INTRST Character(1) VARCHAR2(1) NOT NULL Capitalize Interest Cd
    N=Capitalize while in school
    Y=Pay interest while in school
    17 LN_EFT_AUTHRZTN Character(1) VARCHAR2(1) NOT NULL Loan EFT Authorization
    N=No
    Y=Yes
    18 CL_BORR_REF_CD Character(1) VARCHAR2(1) NOT NULL Borrower References Cd
    N=No, references incomplete
    Y=Yes, references complete
    19 SFA_CR_AWARD_ID Character(21) VARCHAR2(21) NOT NULL Award ID
    20 SFA_CR_LNDR_BRANCH Character(4) VARCHAR2(4) NOT NULL Lender Branch ID

    Prompt Table: SFA_CRC_DSL_VW2

    21 SFA_CR_LNDR_OPEID Character(8) VARCHAR2(8) NOT NULL Lender OPEID

    Prompt Table: SFA_CRC_DESL_VW

    22 SFA_CR_GUAR_BRANCH Character(4) VARCHAR2(4) NOT NULL Guarantor Branch ID
    23 SFA_CR_GUAR_OPEID Character(8) VARCHAR2(8) NOT NULL Guarantor OPEID

    Prompt Table: SFA_CRC_DESG_VW