| PeopleSoft Field Name |
Field Type |
Column Type |
Description |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| PROCESS_NAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
|
| OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| BEGINDTTM |
DateTime(26) |
TIMESTAMP |
Begin Date/Time
|
| ENDDTTM |
DateTime(26) |
TIMESTAMP |
End Date/Time
|
| TIME_ELAPSED |
Number(15,0) |
DECIMAL(15) NOT NULL |
Elapsed Time (in milliseconds)
|
| TIME_IN_PC |
Number(15,0) |
DECIMAL(15) NOT NULL |
PeopleCode Time (in millisecs)
|
| TIME_IN_SQL |
Number(15,0) |
DECIMAL(15) NOT NULL |
SQL Time (in milliseconds)
|
| TRACE_LEVEL |
Number(5,0) |
INTEGER NOT NULL |
Trace level (AE)
|
| TRACE_LEVEL_SAM |
Number(5,0) |
INTEGER NOT NULL |
SAM Trace Level
|