CS_DOCT_USER_VW

(SQL View)
 Index Back

Doc Type by User

SCC 11/22/05: View of document types by user. There is one row for each user and document type. TBG 12/10/2015 change view definition to include contract styles for PO025 master contracts

SELECT A.OPRID , B.SETID , B.CS_SOURCE_TRANS , B.CS_DOCUMENT_TYPE , CS.CNTRCT_STYLE , B.DESCR , B.CS_ENABLE_PO_REQ , B.CS_DOCTYPE_STATUS FROM PSOPRDEFN A , PS_CS_DOC_TYPE_TBL B , PS_CNTRCT_STYLE CS WHERE B.CS_DOCTYPE_STATUS = '01' AND CS.STYLE_STATUS = 'A' AND EXISTS ( SELECT 'x' FROM PS_CS_DOCTYPE_ROLE C , PSROLEUSER D WHERE C.SETID=B.SETID AND C.CS_DOCUMENT_TYPE=B.CS_DOCUMENT_TYPE AND C.ROLENAME=D.ROLENAME AND D.ROLEUSER=A.OPRID AND C.CS_ACCESS = '01') AND ((CS.ALLOW_ALL_DOCTYPES = 'Y') OR (CS.ALLOW_ALL_DOCTYPES = 'N' AND B.CS_DOCUMENT_TYPE IN ( SELECT CS_DOCUMENT_TYPE FROM PS_CNTRCT_STYLE_DT WHERE CNTRCT_STYLE = CS.CNTRCT_STYLE AND SETID = B.SETID)))

  • Related Language Record: CS_DOCT_USR_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
    2 CS_SETID Character(5) VARCHAR2(5) NOT NULL setid for the document objects
    3 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
    4 CS_DOCUMENT_TYPE Character(20) VARCHAR2(20) NOT NULL Document Type
    001=Main Document
    002=Amendment
    003=Preview Document
    004=Compare File
    5 CNTRCT_STYLE Character(10) VARCHAR2(10) NOT NULL Contract Style
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 CS_ENABLE_PO_REQ Character(1) VARCHAR2(1) NOT NULL Use Only with PO Requisitions
    8 CS_DOCTYPE_STATUS Character(2) VARCHAR2(2) NOT NULL SCC 12/05/05: Document Type Status
    01=Available
    02=Obsolete