PTESHISTORY_VW

index back

SELECT b.filename , %DateOut (b.dttm_created) , A.PRCSINSTANCE ,A.CONTENTID ,A.OPRID ,A.DISTSTATUS ,A.URL ,C.RUNSTATUS ,A.OUTPUTDIR FROM PS_CDM_LIST_VW A , PS_CDM_FILE_LIST B , psprcsrqst C WHERE b.prcsinstance=A.prcsinstance AND c.prcsinstance=A.prcsinstance AND A.prcsinstance IN ( SELECT prcsinstance FROM PS_PTESHISTORY )

PeopleSoft Field Name Field Type Column Type Description
FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created
PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
CONTENTID Number(15,0) DECIMAL(15) NOT NULL Report ID
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
DISTSTATUS Character(2) VARCHAR2(2) NOT NULL Distribution Status
0=None
1=Scheduled
2=Processing
3=Generated
4=Unable to Post
5=Posted to Web
6=Delete
7=Posting
9=Pending for Approval
URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
RUNSTATUS Character(2) VARCHAR2(2) NOT NULL Process Scheduler Process Run Status
1=Cancel
10=Not Successful
11=Posted
12=Unable to post
13=Resend
14=Posting
15=Content Generated
16=Pending
17=Success With Warning
18=Blocked
19=Restart
2=Delete
3=Error
4=Hold
5=Queued
6=Initiated
7=Processing
8=Cancelled
9=Success
OUTPUTDIR Character(100) VARCHAR2(100) NOT NULL Output Directory
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19