PKG_AGGR_OLD_VW

(SQL View)
 Index Back

Pkg Aggr Old View

Packaging Aggr Old View -- A view of disbursements used by packaging when updating aggregates

SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,A.ITEM_TYPE ,A.ACAD_CAREER ,A.DISBURSEMENT_ID ,E.STRM ,A.OFFER_BALANCE ,A.DISBURSED_BALANCE ,A.CURRENCY_CD ,A.AGGREGATE_AREA ,A.AGGREGATE_LEVEL ,A.CPS_SCHOOL_CODE ,B.FEDERAL_ID ,C.GRADUATE_LVL_IND FROM PS_STDNT_AWRD_DISB A ,PS_ITEM_TYPE_FA B ,PS_AGGR_LVL_XREF C ,PS_STDNT_AWARDS D ,PS_DISB_ID_TBL E WHERE A.EMPLID = D.EMPLID AND A.INSTITUTION = D.INSTITUTION AND A.AID_YEAR = D.AID_YEAR AND A.ITEM_TYPE = D.ITEM_TYPE AND A.ACAD_CAREER = D.ACAD_CAREER AND D.SETID = B.SETID AND A.ITEM_TYPE = B.ITEM_TYPE AND A.AID_YEAR = B.AID_YEAR AND B.EFFDT = (SELECT MAX(X.EFFDT) FROM PS_ITEM_TYPE_FA X WHERE B.SETID = X.SETID AND B.ITEM_TYPE = X.ITEM_TYPE AND B.AID_YEAR = X.AID_YEAR) AND A.AGGREGATE_LEVEL = C.AGGREGATE_LEVEL AND D.INSTITUTION = E.INSTITUTION AND D.AID_YEAR = E.AID_YEAR AND D.ACAD_CAREER = E.ACAD_CAREER AND D.DISBURSEMENT_PLAN = E.DISBURSEMENT_PLAN AND A.DISBURSEMENT_ID = E.DISBURSEMENT_ID

  • Parent record: STDNT_AWARDS

    • # 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 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
    5 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
    6 DISBURSEMENT_ID Character(2) VARCHAR2(2) NOT NULL Disbursement ID
    7 STRM Character(4) VARCHAR2(4) NOT NULL Term
    8 OFFER_BALANCE Number(12,2) DECIMAL(11,2) NOT NULL Offer Balance
    9 DISBURSED_BALANCE Signed Number(13,2) DECIMAL(11,2) NOT NULL Disbursed Balance
    10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: INSTALLATION.EXCHNG_TO_CURRENCY

    11 AGGREGATE_AREA Character(10) VARCHAR2(10) NOT NULL Aggregate Area
    12 AGGREGATE_LEVEL Character(2) VARCHAR2(2) NOT NULL Aggregate Level
    13 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code
    14 FEDERAL_ID Character(4) VARCHAR2(4) NOT NULL Federal ID
    ACG=Academic Competitiveness Grant
    FWSP=Federal Work Study Program
    GAAN=Grad Assistance in Natl Need
    GPLS=Graduate PLUS Loan
    HEAL=Health Education Assistance Ln
    HPSL=Health Profession Student Loan
    IASA=Iraq/Afghan Service Award
    JVTS=Jacob K Javits Fellowship
    LDS=Loans for Disadvantaged Stdnts
    NIH=National Institute of Health
    NSF=National Science Foundation
    NURS=Nursing Loan
    OTHR=Other Federal Fund
    PCL=Primary Care Loan
    PELL=Federal PELL Grant
    PERK=Federal Perkins Loan Program
    PLUS=Federal Stafford Loan, PLUS
    SEOG=Federal SEOG
    SMRT=National Smart Grant
    STFS=Fed Stafford Loan - Subsidized
    STFU=Fed Stafford Loan-Unsubsidized
    TCH=TEACH Grant
    15 GRADUATE_LVL_IND Character(1) VARCHAR2(1) NOT NULL Graduate Level