GPBR_NRP_RNT_VW(SQL View) |
Index Back |
|---|---|
eSocial Record Type RecordeSocial Record Type Record |
| SELECT GPBR_WAGE_TYPES_ID ,RUN_TYPE ,GPBR_EVENT_CD ,GPBR_PAY_TP ,ENTRY_TYPE_ELEM ,PIN_NET_NUM + 50000000 ,GPBR_TOTER_PIN_NUM + 50000000 ,GPBR_TOTDD_PIN_NUM + 50000000 ,GPBR_PAYROLL_TP FROM PS_GPBR_RUN_TYPE |
| # | 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 | RUN_TYPE |
Character(10) | VARCHAR2(10) NOT NULL |
Run Type Name
Prompt Table: GP_RUN_TYPE_VW |
| 3 | GPBR_EVENT_CD |
Character(6) | VARCHAR2(6) NOT NULL |
eSocial - Event Code
Prompt Table: GPBR_EVNT_SETUP |
| 4 | 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 |
| 5 | ENTRY_TYPE_ELEM | Character(3) | VARCHAR2(3) NOT NULL |
entry type element
Prompt Table: GPBR_ENT_EDA_VW |
| 6 | PIN_NET_NUM | Number(8,0) | INTEGER NOT NULL |
Element number field
Prompt Table: GP_PIN_AC4_VW |
| 7 | GPBR_TOTER_PIN_NUM | Number(8,0) | INTEGER NOT NULL | Total Earnings Pin number field |
| 8 | GPBR_TOTDD_PIN_NUM | Number(8,0) | INTEGER NOT NULL | Total Deductions Pin number field |
| 9 | GPBR_PAYROLL_TP | Character(1) | VARCHAR2(1) NOT NULL |
Payroll TP
0=N/A 1=Monthly 2=Annual Default Value: 0 |