STDNT_AGGR_SCHL

(SQL Table)
 Index Back

Aggregate Data by School

This rercord contains all of the Student Aggregate Data specific to a certain school code. Mainly used to keep tack of incoming aggregate data.

  • Parent record: STDNT_AGGR_LIFE

    • # 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 AGGREGATE_AREA Character(10) VARCHAR2(10) NOT NULL Aggregate Area

    Prompt Table: STDNT_AGGR_LIFE

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

    Prompt Table: FED_AID_YR_TBL

    4 AGGREGATE_LEVEL Character(2) VARCHAR2(2) NOT NULL Aggregate Level

    Prompt Table: AGGR_LVL_VW

    5 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code

    Prompt Table: TITLE_IV_SRCH

    6 AGGREGATE_STATUS Character(1) VARCHAR2(1) NOT NULL Aggregate Status
    I=Imported
    R=Internal to System

    Default Value: I

    7 EXPECTED_AWARD Number(12,2) DECIMAL(11,2) NOT NULL Expected Award
    8 ACTUAL_AWARD Number(12,2) DECIMAL(11,2) NOT NULL Actual Award
    9 SCHEDULED_AWARD Number(12,2) DECIMAL(11,2) NOT NULL Scheduled Award
    10 TERM_COUNT Number(2,0) SMALLINT NOT NULL Terms for Level
    11 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year
    12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: INSTALLATION.EXCHNG_TO_CURRENCY