SFA_NSLDS_AGGVW

(SQL View)
 Index Back

Aggr_limit_Tbl view for Pell

This record contains all of the user defined aggregate types for financial aid awards and their associated limits.

SELECT DISTINCT A.AGGREGATE_AREA ,A.EFFDT ,A.EFF_STATUS ,A.DESCR FROM PS_AGGR_LIMIT_TBL A WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_AGGR_LIMIT_TBL A1 WHERE A1.AGGREGATE_AREA = A.AGGREGATE_AREA AND A1.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' AND A.AGGREGATE_AREA IN ( SELECT B.AGGREGATE_AREA FROM PS_SFA_AGGR_XREF B)

  • Related Language Record: AGGR_LIMITVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AGGREGATE_AREA Character(10) VARCHAR2(10) NOT NULL Aggregate Area
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description