AGC_TYPE_LVW

(SQL View)
 Index Back

AGC Type Rel Lang View

Activity Guide Type Related Language View

SELECT TMPL.AGC_TEMPLATE_ID , TMPL.EFFDT , XLAT.FIELDVALUE , XLATL.LANGUAGE_CD , XLATL.XLATLONGNAME FROM PS_AGC_TMPL_TBL TMPL , PSXLATITEM XLAT , PSXLATITEMLANG XLATL WHERE XLAT.FIELDNAME = 'AGC_TYPE' AND XLAT.EFF_STATUS = 'A' AND XLAT.EFFDT = ( SELECT MAX(XLAT_ED.EFFDT) FROM PSXLATITEM XLAT_ED WHERE XLAT_ED.FIELDNAME = XLAT.FIELDNAME AND XLAT_ED.FIELDVALUE = XLAT.FIELDVALUE AND XLAT_ED.EFFDT <= TMPL.EFFDT) AND XLAT.FIELDNAME = XLATL.FIELDNAME AND XLAT.FIELDVALUE = XLATL.FIELDVALUE AND XLAT.EFFDT = XLATL.EFFDT

  • Related Language Record for AGC_TYPE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AGC_TEMPLATE_ID Character(7) VARCHAR2(7) NOT NULL Activity Guide Composer Template Id
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 AGC_TYPE Character(4) VARCHAR2(4) NOT NULL Activity Guide Composer Type
    HOGP=Horizontal Sequential
    VNSP=Vertical Non Sequential
    VSGP=Vertical Sequential
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description