CS_DOC_H_ALLLVW

(SQL View)
Index Back

Document Language View

Language View for processing

SELECT DISTINCT '0008' , PO.CS_DOC_ID , PO.SETID , PO.CS_CONTENT_ID , PO.CS_DOC_TYPE , PO.SCM_ATTACH_ID , PO.ATT_VERSION , H.LANGUAGE_CD , H.DESCR60 FROM PS_CS_DOC_H_ALL_VW PO , PS_CS_DOC_HDR_LANG H , PS_CS_DOC_FILES F 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')

  • Related Language Record for CS_DOC_H_ALL_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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
    2 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
    3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    4 CS_CONTENT_ID Character(30) VARCHAR2(30) NOT NULL Content ID
    5 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
    6 SCM_ATTACH_ID Character(64) VARCHAR2(64) NOT NULL The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
    7 ATT_VERSION Number(3,0) SMALLINT NOT NULL The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.
    8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description