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 NameField TypeColumn TypeDescription
PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
CONTENTIDNumber(15,0)DECIMAL(15) NOT NULLReport ID
PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name
RQSTDTTMDateTime(26)TIMESTAMPRequest Date/Time
ENDDTTMDateTime(26)TIMESTAMPEnd Date/Time
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
TRANSFERINSTANCENumber(15,0)DECIMAL(15) NOT NULLTransfer Instance
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19