CS_TMPL_TBL_V1

(SQL View)
 Index Back

Doc Config Header Def View

RSX 03/22/06 - Document Configurator Header Definition View using Document Setid

SELECT setid , cs_template_id , descr60 , cs_tmpl_type , cs_tmpl_status , cs_source_trans , cs_wizard_id , cs_amendment_flg , cs_exec_summ_flg FROM PS_CS_TMPL_TBL

  • Related Language Record: CS_TMPL_TBL_LV1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CS_SETID Character(5) VARCHAR2(5) NOT NULL setid for the document objects
    2 CS_TEMPLATE_ID Character(20) VARCHAR2(20) NOT NULL SCC 09/01/04
    3 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    4 CS_TMPL_TYPE Character(4) VARCHAR2(4) NOT NULL SCC 09/01/04

    Prompt Table: CS_TMPL_TYPE

    5 CS_TMPL_STATUS Character(2) VARCHAR2(2) NOT NULL SCC 09/01/04
    01=In Progress
    02=Available
    03=Obsolete

    Default Value: 01

    6 CS_SOURCE_TRANS Character(2) VARCHAR2(2) NOT NULL Source Transaction 03/22/07 cel F-AHAYT-748L7: Added Purchase Order (03) as a new source transaction 01/12/11 tbg SCMT-92-MDEM-04: Added RFx (04) as new source transaction for strat sourcing (doc authoring)
    01=Ad Hoc
    02=Purchasing Contracts
    03=Purchase Orders
    04=Sourcing Events
    97=All Sources
    98=Multiple Sources
    99=Not Transactional
    7 CS_WIZARD_ID Character(30) VARCHAR2(30) NOT NULL Wizard ID

    Prompt Table: CS_WIZ_DOCCR_VW

    8 CS_AMENDMENT_FLG Character(1) VARCHAR2(1) NOT NULL Use for Amendments

    Y/N Table Edit

    Default Value: N

    9 CS_EXEC_SUMM_FLG Character(1) VARCHAR2(1) NOT NULL Use for Executive Summary

    Y/N Table Edit

    Default Value: N