AGGRAREAVWLNG

(SQL View)
 Index Back

Fiscal Aggregate Area Vw

AGGRAREAVWLNG is the language record related to AGGR_AREA_VW. A related language record enables text fields on a table to be translated into various languages for use in other countries.

SELECT A.SETID , B.AGGREGATE_AREA , A.AID_YEAR , C.LANGUAGE_CD , C.DESCR FROM PS_ITEM_TYPE_FISCL A , PS_ITEM_TYPE_FA B , PS_AGGR_LIMIT_LANG C WHERE B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ITEM_TYPE_FA D WHERE B.SETID = D.SETID AND B.ITEM_TYPE = D.ITEM_TYPE AND B.AID_YEAR = D.AID_YEAR AND D.EFFDT <= %CurrentDateIn) AND A.SETID = B.SETID AND A.ITEM_TYPE = B.ITEM_TYPE AND A.AID_YEAR = B.AID_YEAR AND B.AGGREGATE_AREA = C.AGGREGATE_AREA AND B.AID_YEAR = C.AID_YEAR

  • Related Language Record for AGGR_AREA_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_CS.SETID

    Prompt Table: SP_SETID_NONVW

    2 AGGREGATE_AREA Character(10) VARCHAR2(10) NOT NULL Aggregate Area

    Prompt Table: AGGR_LIMIT_VW

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

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: FED_AID_YR_TBL

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description