COLL_LTRTMP_TBL

(SQL Table)
 Index Back

Collection Letter Template Tbl

  • Parent Record Of COLL_LTRITM_TBL COLL_LTRITM_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 TEMPLATE_CODE Character(10) VARCHAR2(10) NOT NULL Template Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: COLL_LTRTMP_TBL.DESCR

    7 ADDR_USAGE Character(10) VARCHAR2(10) NOT NULL Address Usage

    Prompt Table: ADDR_USAGE_TBL

    8 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name

    Prompt Table: HCR_NM_TYP_I

    9 SCC_CHECKLIST_TYPE Character(3) VARCHAR2(3) NOT NULL Checklist Type.
    ADC=Condition List
    CML=Communication List
    HIR=Hiring
    MED=Medical
    OTH=Other
    PRM=Promise
    RQL=Requirements List
    SAL=Staff Assignment List
    TER=Termination
    TRN=Training
    XFR=Transfer
    10 MAILING_CD Character(1) VARCHAR2(1) NOT NULL Mailing Code
    C=Days in Collection
    D=Day of Month

    Default Value: D

    11 SERVICE_IMPACT Character(5) VARCHAR2(5) NOT NULL Service Impact

    Prompt Table: SRVC_IMPCT_SFVW

    12 DESCRLONG Long Character CLOB Long Description