LNAGGRRPTVWLNG

(SQL View)
 Index Back

Ln Aggr Vw-Loan Doc Print SQR

LNAGGRRPTVWLNG is the related language recordfor the record LN_AGGR_RPT_VW Loan Aggregate View for Loan Document Printing

SELECT A.EMPLID , A.AGGREGATE_AREA , A.AID_YEAR , A.AGGREGATE_LEVEL ,Z.LANGUAGE_CD , Z.DESCR , F.DESCRSHORT FROM PS_STDNT_AGGR_AY A , PS_STDNT_AGGR_SCHL B , PS_AGGR_LIMIT_TBL C , PS_AGGR_LVLXREFLNG F , PS_AGGR_LIMIT_LANG Z WHERE Z.AGGREGATE_AREA=C.AGGREGATE_AREA AND Z.AID_YEAR=C.AID_YEAR AND Z.EFFDT=C.EFFDT AND A.EMPLID = B.EMPLID AND A.AID_YEAR = B.AID_YEAR AND A.AID_YEAR = C.AID_YEAR AND A.AGGREGATE_LEVEL = B.AGGREGATE_LEVEL AND A.AGGREGATE_AREA = B.AGGREGATE_AREA AND A.AGGREGATE_AREA = C.AGGREGATE_AREA AND A.AGGREGATE_LEVEL = F.AGGREGATE_LEVEL AND C.FIN_AID_TYPE = 'L' AND C.EFFDT = ( SELECT MAX (C1.EFFDT) FROM PS_AGGR_LIMIT_TBL C1 , PS_AGGR_LIMIT_TBL Z WHERE Z.AGGREGATE_AREA=C1.AGGREGATE_AREA AND Z.AID_YEAR=C1.AID_YEAR AND Z.EFFDT=C1.EFFDT AND C1.AGGREGATE_AREA = C.AGGREGATE_AREA AND C1.EFFDT <= %CurrentDateIn) AND C.EFF_STATUS = 'A'

  • Related Language Record for LN_AGGR_RPT_VW

  • 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description