GPBR_DRVCMP_XRF(SQL Table) |
Index Back |
|---|---|
eSocial Employee Cross RefereneSocial Employee Rslt Cross Reference Table This record is composed by fields that are common to events to Employee. Each event that shall be sent to the government has an entry on this table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPBR_DRIVER_SEQ |
Number(30,0) | DECIMAL(30) NOT NULL | Driver Sequence |
| 2 | GPBR_ESOC_YEAR |
Number(4,0) | SMALLINT NOT NULL | Competency Year |
| 3 | GPBR_ESOC_MONTHCD |
Character(2) | VARCHAR2(2) NOT NULL |
eSocial Competency Month
01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December |
| 4 | GPBR_EVENT_CD |
Character(6) | VARCHAR2(6) NOT NULL | eSocial - Event Code |
| 5 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 6 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 7 | GPBR_CPF_ID |
Character(11) | VARCHAR2(11) NOT NULL | eSocial National ID Number |
| 8 | GPBR_PIS_ID | Character(11) | VARCHAR2(11) NOT NULL | eSocial National ID Number |
| 9 | GPBR_NID_ID | Character(11) | VARCHAR2(11) NOT NULL | eSocial National ID Number |
| 10 | GPBR_ES_PS | Date(10) | DATE | eSocial on PeopleSoft Date |
| 11 | GPBR_RECT | Number(30,0) | DECIMAL(30) NOT NULL | eSocial Ind Calculation |
| 12 | GPBR_PRE_DRV_SEQ | Number(30,0) | DECIMAL(30) NOT NULL | eSocial Pre Driver Sequence |
| 13 | GPBR_ES_CAL_CNT | Number(2,0) | SMALLINT NOT NULL | eSocial Calendar Count 1200 |
| 14 | GPBR_ES_CAL_CNT2 | Number(2,0) | SMALLINT NOT NULL | eSocial Calendar Count 1210 |
| 15 | GPBR_WAGE_TYPES_ID | Character(8) | VARCHAR2(8) NOT NULL | Wages Types IDs for eSocial Brazil |
| 16 | GP_NUM_VAL | Number(20,6) | DECIMAL(19,6) NOT NULL | Used to store Number value used on the banking preparation definition page |
| 17 | LAST_UPDT_DTTM | DateTime(26) | TIMESTAMP | Last Updated Date-Time Stamp |
| 18 | GPBR_PAYROLL_TP | Character(1) | VARCHAR2(1) NOT NULL |
Payroll TP
0=N/A 1=Monthly 2=Annual Default Value: 0 |