PTESHISTORY_VW3

index back

SELECT b.filename , b.dttm_created , A.PRCSINSTANCE ,A.CONTENTID ,A.OPRID ,A.DISTSTATUS ,A.URL FROM PS_CDM_LIST_VW A , PS_CDM_FILE_LIST B WHERE b.prcsinstance=A.prcsinstance

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)
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19