PSACTIVITYLOG

index back

Activity Guide Log

This record tracks the history of which steps an operator has completed for an activity guide.

PeopleSoft Field Name Field Type Column Type Description
ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
STEPNO Number(5,0) INTEGER NOT NULL Step Number
PATHNO Number(5,0) INTEGER NOT NULL Path Number
SERIAL Character(1) VARCHAR2(1) NOT NULL Serial or Parallel
DISPLAY_IMG Character(3) VARCHAR2(3) NOT NULL DISPLAY IMAGE MODE
DIS=Disable Image
ENA=Enable Image
HID=Hide Image
INP=In Process Image
WRK=Work Image
DISPLAY_URL Character(3) VARCHAR2(3) NOT NULL DISPLAY URL
DIS=Disable Link
ENA=Enable Link
HID=Hide Link
INP=In Process Link
WRK=Work Link
STEP_STATUS Character(3) VARCHAR2(3) NOT NULL Event Guide Step Status
LASTCHANGEDTTM DateTime(26) TIMESTAMP NOT NULL Used to identify the last time the object was changed

Default: %DATETIME

EXPIRATION_DATE Date(10) DATE NOT NULL Expiration Date
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20