GPBR_WAGE_TYPES_IDGPBR_ALIM_INC_TYPE11=Monthly Salary
12=13th Salary
13=Vacation
14=PLR
18=RRA
79=Nontaxable Income
ENTRY_TYPE_ELEMPIN_ELEM_NUMGPBR_NRP_SAW_VW(SQL View) |
Index Back |
|---|---|
Wage Type Alimony ParmsWage Type Alimony Parms |
| SELECT GPBR_WAGE_TYPES_ID ,GPBR_ALIM_INC_TYPE ,ENTRY_TYPE_ELEM ,PIN_ELEM_NUM + 50000000 FROM PS_GPBR_SPAL_WAGE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPBR_WAGE_TYPES_ID |
Character(8) | VARCHAR2(8) NOT NULL | Wages Types IDs for eSocial Brazil |
| 2 | GPBR_ALIM_INC_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Alimony Income Type.
11=Monthly Salary 12=13th Salary 13=Vacation 14=PLR 18=RRA 79=Nontaxable Income |
| 3 | ENTRY_TYPE_ELEM |
Character(3) | VARCHAR2(3) NOT NULL | entry type element |
| 4 | PIN_ELEM_NUM |
Number(8,0) | INTEGER NOT NULL | Element Number |