SFA_BRPKG_DSBVW

(SQL View)
 Index Back

Batch Repackaging - Disb View

Batch repackaging view of disbursements.

SELECT A.INSTITUTION ,A.AID_YEAR ,A.BATCH_SEQ_NBR ,A.ACAD_CAREER ,A.PKG_PLAN_ID ,B.PKG_STDNT_COUNT ,A.EMPLID ,A.PKG_SEQ_NBR ,A.DISBURSEMENT_ID ,A.ITEM_TYPE ,A.OFFER_BALANCE ,A.OFFER_BALANCE_ORIG ,A.ACCEPT_BALANCE ,A.ACCEPT_BALNCE_ORIG ,A.AUTHORIZED_BALANCE ,A.DISBURSED_BALANCE ,A.NET_DISB_BALANCE ,A.CURRENCY_CD ,A.BUSINESS_UNIT ,A.AGGREGATE_AREA ,A.AGGREGATE_LEVEL ,A.CPS_SCHOOL_CODE ,A.LN_FEE_AMT ,A.OFFER_BAL_LN_FEE ,A.ACCEPT_BAL_LN_FEE ,A.OFFER_BAL_REBATE ,A.ACCEPT_BAL_REBATE FROM PS_PKG_BATCH_DISB A , PS_PKG_BATCH_STDNT B , PS_PKG_BATCH_SUMM C WHERE A.INSTITUTION = B.INSTITUTION AND A.AID_YEAR = B.AID_YEAR AND A.BATCH_SEQ_NBR = B.BATCH_SEQ_NBR AND A.ACAD_CAREER = B.ACAD_CAREER AND A.PKG_PLAN_ID = B.PKG_PLAN_ID AND A.EMPLID = B.EMPLID AND A.INSTITUTION = C.INSTITUTION AND A.AID_YEAR = C.AID_YEAR AND A.BATCH_SEQ_NBR = C.BATCH_SEQ_NBR AND C.SFA_BPKG_MODE = 'R'

  • Parent record: STDNT_AWD_PKG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: AID_YEAR_TBL

    3 BATCH_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL Batch Sequence Number

    Prompt Table: PKG_BATCH_SUMM

    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

    Prompt Table: ACAD_CAR_TBL

    5 SFA_RPKG_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Repackaging Plan ID

    Prompt Table: SFA_RPKG_PLAN

    6 PKG_STDNT_COUNT Number(5,0) INTEGER NOT NULL Student Packaging Sequence
    7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    8 PKG_SEQ_NBR Number(5,0) INTEGER NOT NULL Sequence Nbr
    9 DISBURSEMENT_ID Character(2) VARCHAR2(2) NOT NULL Disbursement ID

    Prompt Table: DISB_ID_TBL

    10 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: ITEM_TP_FA_AWRD

    11 OFFER_BALANCE Number(12,2) DECIMAL(11,2) NOT NULL Offer Balance
    12 OFFER_BALANCE_ORIG Number(12,2) DECIMAL(11,2) NOT NULL Original Offer Balance
    13 ACCEPT_BALANCE Number(12,2) DECIMAL(11,2) NOT NULL Accept Balance
    14 ACCEPT_BALNCE_ORIG Number(12,2) DECIMAL(11,2) NOT NULL Original Accept Balance
    15 AUTHORIZED_BALANCE Number(12,2) DECIMAL(11,2) NOT NULL Authorized Balance
    16 DISBURSED_BALANCE Signed Number(13,2) DECIMAL(11,2) NOT NULL Disbursed Balance
    17 NET_DISB_BALANCE Number(12,2) DECIMAL(11,2) NOT NULL Net Disb Balance
    18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    19 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    20 AGGREGATE_AREA Character(10) VARCHAR2(10) NOT NULL Aggregate Area
    21 AGGREGATE_LEVEL Character(2) VARCHAR2(2) NOT NULL Aggregate Level
    22 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code
    23 LN_FEE_AMT Number(7,2) DECIMAL(6,2) NOT NULL Loan Fee Amount
    24 OFFER_BAL_LN_FEE Number(7,2) DECIMAL(6,2) NOT NULL Offer Balance Loan Fee
    25 ACCEPT_BAL_LN_FEE Number(7,2) DECIMAL(6,2) NOT NULL Accept Balance Loan Fee
    26 OFFER_BAL_REBATE Number(7,2) DECIMAL(6,2) NOT NULL Offer Balance Rebate
    27 ACCEPT_BAL_REBATE Number(7,2) DECIMAL(6,2) NOT NULL Accept Balance Rebate