# |
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 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
5 |
GPIT_PAY_PRD_ENDDT |
Date(10) |
DATE |
Pay Period End Date of Event
|
6 |
TAKE_CONFIG2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Field reserved for custom attribution to an Absence Take
|
7 |
ABS_BGN_DT |
Date(10) |
DATE |
Absence Begin Date
|
8 |
GPIT_S503_B_ROW_N |
Number(2,0) |
SMALLINT NOT NULL |
Row number for S503 Square B
|
9 |
TAKE_CONFIG1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Field reserved for custom attribution to an Absence Take
|
10 |
GPIT_MAT_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Maternity INPS Percentage
|
11 |
GPIT_GG_INPS |
Number(2,0) |
SMALLINT NOT NULL |
INPS days for reports
|
12 |
GPIT_DAYS_NOPAY |
Number(2,0) |
SMALLINT NOT NULL |
Field useful in the Previdential CUD Report which contains the value of the INPS Days without payment
|
13 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
14 |
END_DT |
Date(10) |
DATE |
end date
|
15 |
GPIT_SS_PAYMNT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Social Secutiy Payment
|
16 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|