| # |
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 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 4 |
GPHK_REPORT_ELM |
Character(2) |
VARCHAR2(2) NOT NULL |
Report elements are predetermined values that appear in a report. This field contains labels of various monetary informations' that should be reported on a statutory report.
|
| 5 |
PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 6 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 7 |
GPHK_MTRY_ADJST |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Users need to have the ability to override an amount calculated by the process. Instead of modifying the generated amount, they can enter an adjustment that will be used to recalculate the amount to be reported.
|
| 8 |
GPHK_PRD_BGN_DT |
Date(10) |
DATE |
The Begin date is required for the purpose of reporting.
|
| 9 |
GPHK_PRD_END_DT |
Date(10) |
DATE |
The End date is required for the purpose of reporting.
|