CS_WDGEN_PARM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	CS_TEMPLATE_ID	Character(20)	VARCHAR2(20) NOT NULL	SCC 09/01/04
4	CNTRCT_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
5	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
6	CS_DOC_ID	Character(25)	VARCHAR2(25) NOT NULL	Document ID
7	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
8	CS_SETID	Character(5)	VARCHAR2(5) NOT NULL	setid for the document objects
9	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
10	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID