CS_ESIGNSYNC_RC (SQL Table)	Index Back
state record CS_ESIGN_SYNC 01/2015 SCMT002 RMK

CS_ESIGNSYNC_RC

(SQL Table)

state record CS_ESIGN_SYNC

01/2015 SCMT002 RMK

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID
Prompt Table: OPR_DEF_TBL_PM

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 CS_ESEND_DTTM DateTime(26) TIMESTAMP SCMT002 2/11/2015 RMK Datetime stamp document is routed for electronic signature
Default Value: %date

4 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

5 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
Prompt Table: CS_SRC_TRAN_VW1

6 CS_DOC_STATUS Character(2) VARCHAR2(2) NOT NULL Document Status
AA=Approved
AD=Denied
AP=Pending Approval
CC=Collaborated
CP=Pending Collaboration
CR=Collaborated, Pending Review
DC=Complete
DR=Draft
DS=Dispatched
EC=Pending External Collaboration
EX=Executed
PI=Pending Internal Review

7 CS_DOCUMENT_TYPE Character(20) VARCHAR2(20) NOT NULL Document Type
001=Main Document
002=Amendment
003=Preview Document
004=Compare File
Prompt Table: CS_DOCT_ALL_VW

8 CS_ESEND_DT_FROM Date(10) DATE Submitted for E-Sign From

9 CS_ESEND_DT_TO Date(10) DATE SCMT002 March 2015

10 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

11 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
Prompt Table: CS_DOC_PO_SRVW4

12 CNTRCT_ID_TO Character(25) VARCHAR2(25) NOT NULL Contract ID To
Prompt Table: CS_DOC_PO_SRVW4

13 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_PM_NONVW

14 PO_ID_FROM Character(10) VARCHAR2(10) NOT NULL From/To
Prompt Table: CS_DOC_PURSRVW3

15 PO_ID_TO Character(10) VARCHAR2(10) NOT NULL PO_ID in a range
Prompt Table: CS_DOC_PURSRVW3

16 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

17 CS_ADHOC_ID_FROM Character(25) VARCHAR2(25) NOT NULL Adhoc ID From
Prompt Table: CS_DOC_ADHSRVW3

18 CS_ADHOC_ID_TO Character(25) VARCHAR2(25) NOT NULL To Adhoc ID
Prompt Table: CS_DOC_ADHSRVW3

19 CS_SIGN_METHOD Character(1) VARCHAR2(1) NOT NULL 5/16/2012 RMK Changed 'A' to deprecated, and added 'B' to use Office Word to convert xml document to PDF using "Save as PDF" feature
A=Adobe (Deprecated)
B=Adobe (Word)
D=DocuSign
E=Adobe Document Cloud services
W=Word

20 SELECT_PARM1 Character(254) VARCHAR2(254) NOT NULL Dynamic Where Select Parms 1

21 CS_LAST_SN_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Default Value: OPR_DEF_TBL_FS.OPRID Prompt Table: OPR_DEF_TBL_PM
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	CS_ESEND_DTTM	DateTime(26)	TIMESTAMP	SCMT002 2/11/2015 RMK Datetime stamp document is routed for electronic signature Default Value: %date
4	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
5	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 Prompt Table: CS_SRC_TRAN_VW1
6	CS_DOC_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Document Status AA=Approved AD=Denied AP=Pending Approval CC=Collaborated CP=Pending Collaboration CR=Collaborated, Pending Review DC=Complete DR=Draft DS=Dispatched EC=Pending External Collaboration EX=Executed PI=Pending Internal Review
7	CS_DOCUMENT_TYPE	Character(20)	VARCHAR2(20) NOT NULL	Document Type 001=Main Document 002=Amendment 003=Preview Document 004=Compare File Prompt Table: CS_DOCT_ALL_VW
8	CS_ESEND_DT_FROM	Date(10)	DATE	Submitted for E-Sign From
9	CS_ESEND_DT_TO	Date(10)	DATE	SCMT002 March 2015
10	CNTRCT_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
11	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID Prompt Table: CS_DOC_PO_SRVW4
12	CNTRCT_ID_TO	Character(25)	VARCHAR2(25) NOT NULL	Contract ID To Prompt Table: CS_DOC_PO_SRVW4
13	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PM_NONVW
14	PO_ID_FROM	Character(10)	VARCHAR2(10) NOT NULL	From/To Prompt Table: CS_DOC_PURSRVW3
15	PO_ID_TO	Character(10)	VARCHAR2(10) NOT NULL	PO_ID in a range Prompt Table: CS_DOC_PURSRVW3
16	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
17	CS_ADHOC_ID_FROM	Character(25)	VARCHAR2(25) NOT NULL	Adhoc ID From Prompt Table: CS_DOC_ADHSRVW3
18	CS_ADHOC_ID_TO	Character(25)	VARCHAR2(25) NOT NULL	To Adhoc ID Prompt Table: CS_DOC_ADHSRVW3
19	CS_SIGN_METHOD	Character(1)	VARCHAR2(1) NOT NULL	5/16/2012 RMK Changed 'A' to deprecated, and added 'B' to use Office Word to convert xml document to PDF using "Save as PDF" feature A=Adobe (Deprecated) B=Adobe (Word) D=DocuSign E=Adobe Document Cloud services W=Word
20	SELECT_PARM1	Character(254)	VARCHAR2(254) NOT NULL	Dynamic Where Select Parms 1
21	CS_LAST_SN_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.