GPBR_DRIVER_SEQDefault Value: %date
1=Initial
2=Reopened
3=Death Communication
GPBR_DRVCAT_XRF(SQL Table) |
Index Back |
|---|---|
eSocial CAT RefereneSocial CAT 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 | GPBR_INCIDENT_NBR | Character(8) | VARCHAR2(8) NOT NULL | Incident Number. |
| 6 | GPBR_CAT_ID | Number(6,0) | INTEGER NOT NULL | CAT Number |
| 7 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 8 | GPBR_ES_PS | Date(10) | DATE | eSocial on PeopleSoft Date |
| 9 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 10 | CAT_TYPE_BRA | Character(1) | VARCHAR2(1) NOT NULL |
CAT Type
1=Initial 2=Reopened 3=Death Communication |