STDNT_ITEM_ASGN

(SQL Table)
 Index Back

Student Budget Item Work Table

This table contains those students who either need to have a budget assigned, or have had a budget assigned and have yet to have that budget assignment moved to the.

  • 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
    13 SFA_PELITMAMT_LHT Number(8,2) DECIMAL(7,2) NOT NULL Filed used for the calculation of Less than half time Pell COA Budget Item amount.