GP_PKG_IDGPBR_WAGE_TYPES_IDRUN_TYPEGPBR_EVENT_CDGPBR_PAY_TP0=N/A
1=Payroll
2=Termination
3=Term Non Empl
7=Vacation
Default Value: 0
0=N/A
1=Monthly
2=Annual
Default Value: 0
GPBR_NRP_RNT_AD(SQL Table) |
Index Back |
|---|---|
eSocial Record Type RecordeSocial Record Type Record None Rule package AD Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | GPBR_WAGE_TYPES_ID |
Character(8) | VARCHAR2(8) NOT NULL | Wages Types IDs for eSocial Brazil |
| 3 | RUN_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | Run Type Name |
| 4 | GPBR_EVENT_CD |
Character(6) | VARCHAR2(6) NOT NULL | eSocial - Event Code |
| 5 | GPBR_PAY_TP |
Character(1) | VARCHAR2(1) NOT NULL |
Patyment TP
0=N/A 1=Payroll 2=Termination 3=Term Non Empl 7=Vacation Default Value: 0 |
| 6 | ENTRY_TYPE_ELEM | Character(3) | VARCHAR2(3) NOT NULL | entry type element |
| 7 | PIN_NET_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 8 | GPBR_TOTER_PIN_NUM | Number(8,0) | INTEGER NOT NULL | Total Earnings Pin number field |
| 9 | GPBR_TOTDD_PIN_NUM | Number(8,0) | INTEGER NOT NULL | Total Deductions Pin number field |
| 10 | GPBR_PAYROLL_TP | Character(1) | VARCHAR2(1) NOT NULL |
Payroll TP
0=N/A 1=Monthly 2=Annual Default Value: 0 |