PKG_AGGR_BNW_VW

(SQL View)
 Index Back

Pkg Aggr New Vw

Pkg Aggr New Vw -- View used by packaging when posting new aggregates.

SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,A.BATCH_SEQ_NBR ,A.PKG_SEQ_NBR ,A.DISBURSEMENT_ID ,A.ITEM_TYPE ,E.STRM ,A.ACAD_CAREER ,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 ,D.PKG_STATUS_CD FROM PS_PKG_BATCH_DISB A ,PS_ITEM_TYPE_FA B ,PS_AGGR_LVL_XREF C ,PS_PKG_BATCH_AWD D ,PS_DISB_ID_TBL E WHERE A.INSTITUTION = D.INSTITUTION AND A.AID_YEAR = D.AID_YEAR AND A.BATCH_SEQ_NBR = D.BATCH_SEQ_NBR AND A.ACAD_CAREER = D.ACAD_CAREER AND A.PKG_PLAN_ID = D.PKG_PLAN_ID AND A.EMPLID = D.EMPLID AND A.PKG_SEQ_NBR = D.PKG_SEQ_NBR 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_AWD_PKG

    • # 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 BATCH_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL Batch Sequence Number
    5 PKG_SEQ_NBR Number(5,0) INTEGER NOT NULL Sequence Nbr
    6 DISBURSEMENT_ID Character(2) VARCHAR2(2) NOT NULL Disbursement ID
    7 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: ITEM_TP_FA_AWRD

    8 STRM Character(4) VARCHAR2(4) NOT NULL Term
    9 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

    Prompt Table: STDNT_CR_TRM_VW

    10 OFFER_BALANCE Number(12,2) DECIMAL(11,2) NOT NULL Offer Balance
    11 DISBURSED_BALANCE Signed Number(13,2) DECIMAL(11,2) NOT NULL Disbursed Balance
    12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: INSTALLATION.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    13 AGGREGATE_AREA Character(10) VARCHAR2(10) NOT NULL Aggregate Area
    14 AGGREGATE_LEVEL Character(2) VARCHAR2(2) NOT NULL Aggregate Level
    15 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code
    16 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
    17 GRADUATE_LVL_IND Character(1) VARCHAR2(1) NOT NULL Graduate Level
    18 PKG_STATUS_CD Number(5,0) INTEGER NOT NULL Package Status