RBC_TMPLTYPE_VW

(SQL View)
 Index Back

Templete View

Templete Type View for Correspondence Management

SELECT A.TMPLT_CATEGRY_ID , A.TMPLT_TYPE_ID , A.TMPLT_TYPE_NAME , A.ACTIVE_FLAG FROM PS_RBC_TEMPLT_TYPE A

  • Related Language Record: RBC_TMPLTYPE_LG

    • # 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 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.
    4 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
    A=Active
    I=Inactive

    Y/N Table Edit

    Default Value: N