GPBR_DRIVER_SEQGPBR_DRVEMP_XRF(SQL Table) |
Index Back |
|---|---|
eSocial Employee Cross RefereneSocial Employee 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_EVENT_CD | Character(6) | VARCHAR2(6) NOT NULL | eSocial - Event Code |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 6 | BGN_DT | Date(10) | DATE | Begin Date |
| 7 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 8 | ACTION | Character(3) | VARCHAR2(3) NOT NULL | Action |
| 9 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL | Reason Code |
| 10 | GPBR_ES_PS | Date(10) | DATE | eSocial on PeopleSoft Date |
| 11 | GPBR_PRV_DT | Date(10) | DATE | eSocial Previous Date |
| 12 | GPBR_RECT | Number(30,0) | DECIMAL(30) NOT NULL | eSocial Ind Calculation |
| 13 | GPBR_PRE_DRV_SEQ | Number(30,0) | DECIMAL(30) NOT NULL | eSocial Pre Driver Sequence |