DFW_RD

index back

SELECT A.PRCSINSTANCE , A.CONTENTID , A.PRCSNAME , A.RQSTDTTM , A.ENDDTTM , A.DISTSTATUS , B.TRANSFERINSTANCE FROM PS_CDM_LIST A , PS_CDM_TRANSFER B WHERE A.TRANSFERINSTANCE = B.TRANSFERINSTANCE

PeopleSoft Field Name Field Type Column Type Description
PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
CONTENTID Number(15,0) DECIMAL(15) NOT NULL Report ID
PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
RQSTDTTM DateTime(26) TIMESTAMP Request Date/Time
ENDDTTM DateTime(26) TIMESTAMP End Date/Time
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
TRANSFERINSTANCE Number(15,0) DECIMAL(15) NOT NULL Transfer Instance
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19