# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
3 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
5 |
GPIT_CUD_QUALIF |
Character(1) |
VARCHAR2(1) NOT NULL |
Field for CUD Report
|
6 |
GPIT_CUD_TIPOPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Part time code for CUD
|
7 |
GPIT_CUD_TIPORAPP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/temporary employees for CUD
|
8 |
GPIT_CUD_ENTE |
Character(2) |
VARCHAR2(2) NOT NULL |
Field that contains the value of the box 4 related to the Previdential CUD
|
9 |
INPS_CODE_ITA |
Character(12) |
VARCHAR2(12) NOT NULL |
INPS Code ITA
|
10 |
GPIT_INPS_CDCTR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
INPS Contribution Code
|
11 |
GPIT_EVT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Field for the Previdential CUD Report which is used to save the value of special payment in case of 'AS' or 'AE'
|
12 |
ROW_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Row Number
|