CS_RPT_DSTATTVW

(SQL View)
 Index Back

Doc Stat Run Controls


SELECT PROCESS_INSTANCE ,OPRID ,RUN_CNTL_ID ,ASOFDATE ,CS_SETID ,LANGUAGE_CD ,LANGUAGE_OPTION ,PAGE_NAME ,REPORT_DEFN_ID ,TMPLDEFN_ID ,AUC_ID_FROM ,AUC_ID_TO ,BUSINESS_UNIT ,CNTRCT_ID ,CNTRCT_ID_TO ,CNTRCT_SETID ,CREATED_DT_FROM ,CREATED_DT_TO ,CS_ADHOC_ID_FROM ,CS_ADHOC_ID_TO ,CS_DOC_OWNER ,CS_DOC_STATUS ,CS_DOCUMENT_TYPE ,CS_SOURCE_TRANS ,CS_SPONSOR ,DEPTID ,DRAFT_DUE_DATE ,DRAFT_DUE_DATE2 ,LAST_MOD_DT_FROM ,LAST_MOD_DT_TO ,PO_ID_FROM ,PO_ID_TO ,RENEWAL_DT_FR ,RENEWAL_DT_TO ,SELECT_PARM1 ,SELECT_PARM2 ,SELECT_PARM3 ,SELECT_PARM ,SETID ,VENDOR_ID ,VENDOR_SETID FROM PS_CS_RPT_DSTATTMP

# 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
12 AUC_ID_TO Character(10) VARCHAR2(10) NOT NULL Event ID
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_SRVW3
Set Control Field: CNTRCT_SETID

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

Prompt Table: CS_DOC_PO_SRVW3
Set Control Field: CNTRCT_SETID

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
Set Control Field: CS_SETID

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

Prompt Table: PSOPRDEFN_VW
Set Control Field: CS_SETID

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
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
Set Control Field: BUSINESS_UNIT

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

Prompt Table: CS_DOC_PURSRVW3
Set Control Field: BUSINESS_UNIT

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_PARM Character(254) VARCHAR2(254) NOT NULL Dynamic Where Clause Sel Parms
39 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

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

Prompt Table: VNDR_ACT_VW

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

Prompt Table: SP_SETVND_NONVW