CS_DOCT_USER_V2

(SQL View)
 Index Back

Doc Type by User and Roles

SCC 11/22/05: View of document types by user. There could be more than one row if user belongs to more than one role.

SELECT A.ROLEUSER , B.SETID , C.CS_SOURCE_TRANS , B.CS_DOCUMENT_TYPE , A.ROLENAME , B.CS_OVERRIDE_CFG , C.CS_DOCTYPE_STATUS FROM PSROLEUSER A , PS_CS_DOCTYPE_ROLE B , PS_CS_DOC_TYPE_TBL C WHERE A.ROLENAME=B.ROLENAME AND B.SETID=C.SETID AND B.CS_DOCUMENT_TYPE=C.CS_DOCUMENT_TYPE AND B.CS_ACCESS = '01'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

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 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
6 CS_OVERRIDE_CFG Character(1) VARCHAR2(1) NOT NULL Allow Override Configurator ID

Y/N Table Edit

Default Value: N

7 CS_DOCTYPE_STATUS Character(2) VARCHAR2(2) NOT NULL SCC 12/05/05: Document Type Status
01=Available
02=Obsolete