CS_DOCT_RPT_VW

(SQL View)
Index Back

All Document Types


SELECT B.SETID , B.CS_SOURCE_TRANS , B.CS_DOCUMENT_TYPE , B.DESCR , B.CS_USAGE , B.CS_APPL_STATUS FROM PS_CS_DOC_TYPE_TBL B

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CS_SETID Character(5) VARCHAR2(5) NOT NULL setid for the document objects

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 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
3 CS_DOCUMENT_TYPE Character(20) VARCHAR2(20) NOT NULL Document Type
001=Main Document
002=Amendment
003=Preview Document
004=Compare File
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 CS_USAGE Character(2) VARCHAR2(2) NOT NULL Internal Document
01=External Document
02=Internal Document
6 CS_APPL_STATUS Character(2) VARCHAR2(2) NOT NULL SCC 12/13/05: Applicable Statuses for document type
01=Draft, Complete Statuses Only
02=Draft, Approve Statuses Only
03=Full Life Cycle Statuses