ACTIVITYNAMEOPRIDSEQUENCE_NBRSTEPNOPATHNODIS=Disable Image
ENA=Enable Image
HID=Hide Image
INP=In Process Image
WRK=Work Image
DIS=Disable Link
ENA=Enable Link
HID=Hide Link
INP=In Process Link
WRK=Work Link
Default Value: %DATETIME
PSACTIVITYLOG(SQL Table) |
Index Back |
|---|---|
Activity Guide LogThis record tracks the history of which steps an operator has completed for an activity guide. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACTIVITYNAME |
Character(30) | VARCHAR2(30) NOT NULL | Name of a Business Process Activity (see PSACTIVITYDEFN). |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 4 | STEPNO |
Number(5,0) | INTEGER NOT NULL | Step Number |
| 5 | PATHNO |
Number(5,0) | INTEGER NOT NULL | Path Number |
| 6 | SERIAL | Character(1) | VARCHAR2(1) NOT NULL | Serial or Parallel |
| 7 | 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 |
| 8 | 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 |
| 9 | STEP_STATUS | Character(3) | VARCHAR2(3) NOT NULL | Event Guide Step Status |
| 10 | LASTCHANGEDTTM | DateTime(26) | TIMESTAMP NOT NULL |
Used to identify the last time the object was changed
Default Value: %DATETIME |
| 11 | EXPIRATION_DATE | Date(10) | DATE NOT NULL | Expiration Date |