GPBR_DRVRIS_XRF

(SQL Table)
Index Back

eSocial Employee Cross Referen

eSocial 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_EVENT_CD Character(6) VARCHAR2(6) NOT NULL eSocial - Event Code
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
6 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification
7 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
8 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
9 GPBR_PIS_ID Character(11) VARCHAR2(11) NOT NULL eSocial National ID Number
10 GPBR_NID_ID Character(11) VARCHAR2(11) NOT NULL eSocial National ID Number
11 GPBR_CPF_ID Character(11) VARCHAR2(11) NOT NULL eSocial National ID Number
12 GPBR_ES_PS Date(10) DATE eSocial on PeopleSoft Date
13 GPBR_RECT Number(30,0) DECIMAL(30) NOT NULL eSocial Ind Calculation
14 GPBR_PRE_DRV_SEQ Number(30,0) DECIMAL(30) NOT NULL eSocial Pre Driver Sequence
15 LAST_UPDT_DTTM DateTime(26) TIMESTAMP Last Updated Date-Time Stamp