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