STDNT_ITEM_ABVW

(SQL View)
 Index Back

Student Budget Item View

This view lists student item assign records that were inserted via the batch version of student budget assign process.

SELECT EMPLID, INSTITUTION, AID_YEAR, STRM, PROCESSING_MODE, BGT_ITEM_CATEGORY, BUDGET_ITEM_CD, BUDGET_ITEM_AMOUNT, PELL_ITEM_AMOUNT, BDGT_ERROR_TYPE, PROCESSING_RULE, BUDGET_ITEM_STATUS FROM PS_STDNT_ITEM_ASGN WHERE PROCESSING_MODE = 'B'

  • Parent record: STDNT_BDGT_ASGN

    • # 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 STRM Character(4) VARCHAR2(4) NOT NULL Term
    5 PROCESSING_MODE Character(1) VARCHAR2(1) NOT NULL This field is used to store the mode of processing, batch or online, for Student Budgets.
    B=Batch Mode
    O=Online Mode
    6 BGT_ITEM_CATEGORY Character(4) VARCHAR2(4) NOT NULL Budget Item Category

    Prompt Table: BUDGET_CATG_TBL

    7 BUDGET_ITEM_CD Character(6) VARCHAR2(6) NOT NULL Budget Item Code

    Prompt Table: BUDGET_ITEM_TBL

    8 BUDGET_ITEM_AMOUNT Number(8,2) DECIMAL(7,2) NOT NULL Budget Item Amount
    9 PELL_ITEM_AMOUNT Number(8,2) DECIMAL(7,2) NOT NULL Pell Amount
    10 BDGT_ERROR_TYPE Character(3) VARCHAR2(3) NOT NULL Error Processing
    ERR=Stop
    NON=None
    SKP=Skip
    WAR=Warning
    11 PROCESSING_RULE Character(1) VARCHAR2(1) NOT NULL Processing Rule
    E=Equation Based Calculation
    F=Formula Based Calculation
    N=Tree Nodes
    T=Tuition Calculation
    12 BUDGET_ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Item Status
    E=Error
    F=Found
    K=Skip
    M=Moved
    N=None
    S=Selected
    W=Warning