GPBR_DRIVER_SEQGPBR_DRVEST_XRF(SQL Table) |
Index Back |
|---|---|
eSocial Establishment Cross ReeSocial Establishment Cross Reference Table This record is composed by fields that are common to events to Establishment . 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 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 4 | COUNTY_CD_BRA | Number(7,0) | INTEGER NOT NULL | COUNTY_CD_BRA County Code |
| 5 | GPBR_ES_PS | Date(10) | DATE | eSocial on PeopleSoft Date |
| 6 | GPBR_PRV_DT | Date(10) | DATE | eSocial Previous Date |