CS_DOC_H_POVW

(SQL View)
 Index Back

Contract Document Header


SELECT DISTINCT PO.CS_DOC_ID ,H.DESCR60 ,'0008' ,PO.SETID ,PO.CNTRCT_ID ,F.CS_DOC_TYPE ,H.CS_DOC_STATUS ,H.CS_DOC_OWNER ,H.CS_SPONSOR ,H.DEPTID ,H.CS_SETID ,T.CS_TMPL_TYPE ,H.CS_TEMPLATE_ID ,H.CS_VERSION ,H.CS_AMENDMENT ,H.CS_TWOFILE_AMEND ,H.CS_SOURCE_TRANS ,H.CS_TRANKEY_REC ,H.CREATED_DTTM ,H.CREATED_BY_USER ,H.DATETIME_CHECKOUT ,H.CHECKED_OUT_BY ,H.COMMENT1 ,H.COLLABED_DTTM ,H.APPROVAL_DTTM ,H.DATETIME_DISPATCH ,H.EXECUTED_DTTM ,H.LAST_MODIFIED_DATE ,H.LASTUPDOPRID ,H.CLOSE_FLAG FROM PS_CS_DOC_PO_KEYS PO ,PS_CS_DOC_HDR H ,PS_CS_DOC_FILES F ,PS_CS_TMPL_TBL T WHERE PO.CS_DOC_ID = H.CS_DOC_ID AND H.CS_DOC_ID = F.CS_DOC_ID AND F.CS_DOC_TYPE IN ('001','002') AND H.CS_SETID = T.SETID AND H.CS_TEMPLATE_ID = T.CS_TEMPLATE_ID

  • Related Language Record: CS_DOCH_POV_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
    2 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    3 CS_CONTENT_TYPE Character(4) VARCHAR2(4) NOT NULL 06/08/09 F-AHAYT-XOES6 Add capability to use binds in headers and/or footers of contract document; new translate value added to support Where Used from Document Templates and Styles 06/25/07 F-AHAYT-XOES6 Added 0016 for Document Format and Options; this type is only used when displayed where a word template is used with doc options. We do not search doc format and options.
    0001=Clause
    0002=Section
    0003=Ad Hoc Clause
    0004=Rule
    0005=Bind Variables
    0006=Wizard Definition
    0007=Document Configurator
    0008=Document
    0009=Contract Agreement
    0010=Bid Factor
    0011=Contract
    0012=Sourcing Event
    0013=Question Group
    0014=Document Type
    0015=Word Template
    0016=Document Format and Options
    4 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    5 CS_CONTENT_ID Character(30) VARCHAR2(30) NOT NULL Content ID
    6 CS_DOC_TYPE Character(3) VARCHAR2(3) NOT NULL stores the file type -- main file, amendment, preview, throwaway Date Initials Issue Description ========================================== 06/2007 CEL F-AHAYT-25EQ8 added the external main and amendment types 7/2008 cel Added new executive summary file type. 9/30/2008 RMK Changed values 005 and 006 to 095 and 096, and added 010 for executive summary. This change is due to the search on file type using range (001-010 for non-attachment search, and 001-096 for attachment search)
    001=Main Document
    002=Amendment
    003=Preview Document
    004=Compare File
    005=Document Attachment
    006=Transaction Attachment
    007=Config Selector
    008=Main Signature Document
    009=Amendment Signature File
    010=Executive Summary
    011=Exec-Sign
    095=Document Attachment
    096=Transaction Attachment
    101=Main Document
    102=Amendment Document
    998=Main Document - ext collab
    999=Amendment External Collab
    7 CS_DOC_STATUS Character(2) VARCHAR2(2) NOT NULL Document Status
    AA=Approved
    AD=Denied
    AP=Pending Approval
    CC=Collaborated
    CP=Pending Collaboration
    CR=Collaborated, Pending Review
    DC=Complete
    DR=Draft
    DS=Dispatched
    EC=Pending External Collaboration
    EX=Executed
    PI=Pending Internal Review
    8 CS_DOC_OWNER Character(30) VARCHAR2(30) NOT NULL Document Administrator
    9 CS_SPONSOR Character(30) VARCHAR2(30) NOT NULL Sponsor

    Prompt Table: PSOPRDEFN_VW

    10 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    11 CS_SETID Character(5) VARCHAR2(5) NOT NULL setid for the document objects
    12 CS_TMPL_TYPE Character(4) VARCHAR2(4) NOT NULL SCC 09/01/04
    13 CS_TEMPLATE_ID Character(20) VARCHAR2(20) NOT NULL SCC 09/01/04
    14 CS_VERSION Number(6,2) DECIMAL(5,2) NOT NULL Version
    15 CS_AMENDMENT Number(3,0) SMALLINT NOT NULL Amendment
    16 CS_TWOFILE_AMEND Character(1) VARCHAR2(1) NOT NULL Amendment Option
    1=Amend Contract Only
    2=Amend Contract with Amendments
    3=Amendment Files Only

    Y/N Table Edit

    Default Value: N

    17 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
    18 CS_TRANKEY_REC Character(15) VARCHAR2(15) NOT NULL Source Key Record
    19 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time
    20 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
    21 DATETIME_CHECKOUT DateTime(26) TIMESTAMP Checked Out On
    22 CHECKED_OUT_BY Character(30) VARCHAR2(30) NOT NULL Checked Out By
    23 COMMENT1 Character(254) VARCHAR2(254) NOT NULL Comments
    24 COLLABED_DTTM DateTime(26) TIMESTAMP Collaborated On
    25 APPROVAL_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a given transaction is approved by an oper
    26 DATETIME_DISPATCH DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0
    27 EXECUTED_DTTM DateTime(26) TIMESTAMP Executed On
    28 LAST_MODIFIED_DATE DateTime(26) TIMESTAMP Last modified date
    29 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    30 CLOSE_FLAG Character(1) VARCHAR2(1) NOT NULL Close Contract Flag