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 NameField TypeColumn TypeDescription
FILENAMECharacter(80)VARCHAR2(80) NOT NULLFile Name
DTTM_CREATEDDateTime(26)TIMESTAMPDatetime Created
PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
CONTENTIDNumber(15,0)DECIMAL(15) NOT NULLReport ID
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
DISTSTATUSCharacter(2)VARCHAR2(2) NOT NULLDistribution 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
URLCharacter(254)VARCHAR2(254) NOT NULLInternet URL (Universal Resource Locator)
RUNSTATUSCharacter(2)VARCHAR2(2) NOT NULLProcess 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
OUTPUTDIRCharacter(100)VARCHAR2(100) NOT NULLOutput Directory
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19