PT_WF_NOTIFY_WL

index back

Generic Message Worklist


PeopleSoft Field NameField TypeColumn TypeDescription
BUSPROCNAMECharacter(30)VARCHAR2(30) NOT NULLBusiness Process Name (see PSBUSPROCDEFN).
ACTIVITYNAMECharacter(30)VARCHAR2(30) NOT NULLName of a Business Process Activity (see PSACTIVITYDEFN).
EVENTNAMECharacter(30)VARCHAR2(30) NOT NULLDefines a routing event for PS Workflow
WORKLISTNAMECharacter(30)VARCHAR2(30) NOT NULLWorklist Name
INSTANCEIDNumber(10,0)DECIMAL(10) NOT NULLFor a given worklist the unique number of rows in PSWORKLIST
TRANSACTIONIDNumber(10,0)DECIMAL(10) NOT NULLTransaction Identifier
CREATEOPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
CREATEDTTMDateTime(26)TIMESTAMP NOT NULLDateTime of Query Creation
LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
WL_SUBJECTCharacter(254)VARCHAR2(254) NOT NULLSubject
WORKLIST_DESCRCharacter(50)VARCHAR2(50) NOT NULLDescription
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19