| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 5 |
STRM_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Stream Number
|
| 6 |
GPNZ_LEAVE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Check box that users select to run Leave Entitlement process.
|
| 7 |
RUN_CALC_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate Payees
|
| 8 |
GPNZ_CHART_REMAP |
Character(1) |
VARCHAR2(1) NOT NULL |
Check box that users select to run Australian GL Chart Field remapping process.
|
| 9 |
RUN_FINAL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Finalize Entire Run
|
| 10 |
UPDATE_STATS_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Statistics
|
| 11 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 12 |
GPNZ_GLCALC_TS |
DateTime(26) |
TIMESTAMP |
This is the date/time when GL Calc process is run. This process needs to be run before Leave Entitlement can be processed.
|
| 13 |
GPNZ_LVEENT_TS |
DateTime(26) |
TIMESTAMP |
This is the date/time that the Leave Entitlement process is run. It is used to determine if rerun is possible. If timestamp is earlier than GL Calc timestamp, the calculation needs to be re-run first.
|
| 14 |
GPNZ_CHARTREMAP_TS |
DateTime(26) |
TIMESTAMP |
Date/time GL Chartfield remap process was run
|