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