CS_RPT_RUN_AET

(SQL Table)
Index Back

Contracts State Record

Contracts State Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 ASOFDATE Date(10) DATE NOT NULL As of Date

Default Value: %date

5 CS_SETID Character(5) VARCHAR2(5) NOT NULL setid for the document objects

Prompt Table: SP_SETID_NONVW

6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
7 LANGUAGE_OPTION Character(1) VARCHAR2(1) NOT NULL Language Option
O=Specified Language
R=Recipient's Language

Default Value: O

8 PAGE_NAME Character(18) VARCHAR2(18) NOT NULL Page Name
9 REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Report Name (see PSXPRPTDEFN).
10 TMPLDEFN_ID Character(30) VARCHAR2(30) NOT NULL Template ID (see PSXPTMPLDEFN).

Prompt Table: %EDITTABLE

11 AUC_ID_FROM Character(10) VARCHAR2(10) NOT NULL Event ID

Prompt Table: CS_DOC_AUCSRVW3

12 AUC_ID_TO Character(10) VARCHAR2(10) NOT NULL Event ID

Prompt Table: CS_DOC_AUCSRVW3

13 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PM_NONVW

14 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

Prompt Table: CS_DOC_PO_SRVW4

15 CNTRCT_ID_TO Character(25) VARCHAR2(25) NOT NULL Contract ID To

Prompt Table: CS_DOC_PO_SRVW4

16 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

17 CREATED_DT_FROM Date(10) DATE Created Date and time
18 CREATED_DT_TO Date(10) DATE Created Date and time
19 CS_ADHOC_ID_FROM Character(25) VARCHAR2(25) NOT NULL Adhoc ID From

Prompt Table: CS_DOC_ADHSRVW3

20 CS_ADHOC_ID_TO Character(25) VARCHAR2(25) NOT NULL To Adhoc ID

Prompt Table: CS_DOC_ADHSRVW3

21 CS_DOC_OWNER Character(30) VARCHAR2(30) NOT NULL Document Administrator

Prompt Table: PSOPRDEFN_VW

22 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
23 CS_DOCUMENT_TYPE Character(20) VARCHAR2(20) NOT NULL Document Type
001=Main Document
002=Amendment
003=Preview Document
004=Compare File

Prompt Table: %EDITTABLE2

24 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

25 CS_SPONSOR Character(30) VARCHAR2(30) NOT NULL Sponsor

Prompt Table: PSOPRDEFN_VW

26 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: CS_DEPTID_VW

27 DRAFT_DUE_DATE Date(10) DATE Draft Due Date
28 DRAFT_DUE_DATE2 Date(10) DATE Draft Due Date
29 LAST_MOD_DT_FROM Date(10) DATE Last modified date
30 LAST_MOD_DT_TO Date(10) DATE Last modified date
31 PO_ID_FROM Character(10) VARCHAR2(10) NOT NULL From/To

Prompt Table: CS_DOC_PURSRVW3

32 PO_ID_TO Character(10) VARCHAR2(10) NOT NULL PO_ID in a range

Prompt Table: CS_DOC_PURSRVW3

33 RENEWAL_DT_FR Date(10) DATE Renewal Date From
34 RENEWAL_DT_TO Date(10) DATE To Date
35 SELECT_PARM1 Character(254) VARCHAR2(254) NOT NULL Dynamic Where Select Parms 1
36 SELECT_PARM2 Character(254) VARCHAR2(254) NOT NULL Dynamic Where Select Parms 2
37 SELECT_PARM3 Character(254) VARCHAR2(254) NOT NULL Dynamic Where Select Parms 3
38 SELECT_PARM4 Character(254) VARCHAR2(254) NOT NULL Dynamic Where Select Parms 4
39 SELECT_PARM Character(254) VARCHAR2(254) NOT NULL Dynamic Where Clause Sel Parms
40 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: CS_DOC_ADH_STVW

41 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_VW1

42 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

Prompt Table: SP_SETVND_NONVW

43 CREATED_DT_FR2 Date(10) DATE NOT NULL Created Date and time

Default Value: 01012000

44 CREATED_DT_TO2 Date(10) DATE NOT NULL Created Date and time

Default Value: %DATE

45 CS_CLASS Character(20) VARCHAR2(20) NOT NULL Class

Prompt Table: CS_CLS_CLASS
Set Control Field: CS_SETID

46 CS_APPROVAL_TYPE Character(30) VARCHAR2(30) NOT NULL Approval Type

Prompt Table: CS_CLASS_APP_VW
Set Control Field: CS_SETID

47 CS_CLAUSE_TYPE Character(2) VARCHAR2(2) NOT NULL New with 9.1 to indicate if Table Clause or other
G=General Clause
T=Table Clause
48 CS_CONTENT_TYPE Character(4) VARCHAR2(4) NOT NULL 06/08/09 F-AHAYT-XOES6 Add capability to use binds in headers and/or footers of contract document; new translate value added to support Where Used from Document Templates and Styles 06/25/07 F-AHAYT-XOES6 Added 0016 for Document Format and Options; this type is only used when displayed where a word template is used with doc options. We do not search doc format and options.
0001=Clause
0002=Section
0003=Ad Hoc Clause
0004=Rule
0005=Bind Variables
0006=Wizard Definition
0007=Document Configurator
0008=Document
0009=Contract Agreement
0010=Bid Factor
0011=Contract
0012=Sourcing Event
0013=Question Group
0014=Document Type
0015=Word Template
0016=Document Format and Options
49 CS_INCL_ADD_DEL Character(1) VARCHAR2(1) NOT NULL Incl Add/Del Library Content

Y/N Table Edit

Default Value: N

50 CS_INCL_CHG Character(1) VARCHAR2(1) NOT NULL Include Manually Added Text

Y/N Table Edit

Default Value: Y

51 CS_INCL_IN_PROCESS Character(1) VARCHAR2(1) NOT NULL Include Only In-Process Docs

Y/N Table Edit

Default Value: N

52 CS_OBJECT_TYPE Character(4) VARCHAR2(4) NOT NULL 06/08/09 F-AHAYT-XOES6 Add capability to use binds in headers and/or footers of contract document; new translate value added to support Where Used from Document Templates and Styles
0001=Clause
0002=Section
0003=Ad Hoc Clause
0004=Rule
0005=Bind Variables
0006=Wizard Definition
0007=Document Configurator
0008=Document
0015=Word Template
1000=All

Prompt Table: CS_OBJ_TYPE_VW3
Set Control Field: XLATLONGNAME

53 EFFDT_FROM Date(10) DATE NOT NULL Effective Date From

Default Value: 01012000

54 EFFDT_TO Date(10) DATE NOT NULL Effective Date To

Default Value: %DATE

55 LAST_MOD_DT_FR2 Date(10) DATE NOT NULL Last modified date

Default Value: 01012000

56 LAST_MOD_DT_TO2 Date(10) DATE NOT NULL Last modified date

Default Value: %DATE

57 CS_TMP_TABLE_PROC Character(2) VARCHAR2(2) NOT NULL Temporary Table Processing
CR=Create Only - No Report
PC=Create and Purge Current
PP=Purge Prior Only - No Report

Default Value: PC

58 PROC_INSTANCE_TO Number(10,0) DECIMAL(10) NOT NULL Process Instance From field used in Voucher Maintenance Component

Prompt Table: %EDITTABLE3