LM_TMPL

(SQL Table)
 Index Back

Template

  • Related Language Record: LM_TMPL_LNG

  • Parent Record Of LM_TMPL_DTL LM_TMPL_LE LM_TMPL_PAGE LM_TMPL_PAGE_LN LM_TMPL_SEC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Template ID
    2 LM_TMPL_NAME Character(30) VARCHAR2(30) NOT NULL Template Name
    3 LM_TMPL_STATUS Character(2) VARCHAR2(2) NOT NULL Status
    10=Active
    20=Inactive

    Default Value: 10

    4 LM_TMPL_TYPE_ID Character(25) VARCHAR2(25) NOT NULL Template Type ID

    Prompt Table: LM_TMPL_TYPE