AGC_SBNR_LVW

(SQL View)
 Index Back

AGC Sub Banner Rel Lang View

Activity Guide Sub Banner 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_SUB_BNR_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_SBNR_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_SUB_BNR_TYPE Character(4) VARCHAR2(4) NOT NULL Activity Guide Sub Banner Type
    0000=No Sub Banner
    0001=Image with 1 Primary Field
    0002=Image, No Primary Field
    0003=No Image with 1 Primary Field
    0004=No Image, No Primary Field
    0005=Display Page
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description