BAS_OE_TMPL_LVW

(SQL View)
Index Back

GDP Template List

View of the GDP AG Template and PTAI_LIST

SELECT A.AGC_TEMPLATE_ID ,LANGUAGE_CD ,A.EFFDT , A.DESCR100 ,A.DESCRLONG FROM PS_AGC_TMPL_LNG A

  • Related Language Record for BAS_OE_TMPL_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    5 DESCRLONG Long Character CLOB Long Description