RBC_TMPLTYPE_LG

(SQL View)
Index Back

Template Type

Template type used for Correspondence Management

SELECT A.TMPLT_CATEGRY_ID , A.TMPLT_TYPE_ID , B.LANGUAGE_CD , B.TMPLT_TYPE_NAME FROM PS_RBC_TEMPLT_TYPE A , PS_RBC_TYPE_LNG B WHERE A.TMPLT_CATEGRY_ID = B.TMPLT_CATEGRY_ID AND A.TMPLT_TYPE_ID = B.TMPLT_TYPE_ID

  • Related Language Record for RBC_TMPLTYPE_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TMPLT_CATEGRY_ID Number(6,0) INTEGER NOT NULL Template Category ID
    2 TMPLT_TYPE_ID Number(6,0) INTEGER NOT NULL Template Type ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 TMPLT_TYPE_NAME Character(30) VARCHAR2(30) NOT NULL Holds the names of the types. 01/16/03: Set the Format Type to "Mixedcase", from Uppercase.