GPBR_DRIVER_DAT(SQL Table) |
Index Back |
|---|---|
eSocial Driver Data TableeSocial Driver Data Table. This record is composed by fields that are common to all events. 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_DRV_SPLIT_SEQ |
Number(20,0) | DECIMAL(20) NOT NULL | eSocial - Split Sequence |
| 3 | GPBR_EVENT_CD | Character(6) | VARCHAR2(6) NOT NULL | eSocial - Event Code |
| 4 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 5 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 6 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 7 | GPBR_ACTION | Character(3) | VARCHAR2(3) NOT NULL |
eSocial Action
ADD=Row Inserted COR=Row Correction DEL=Row Deleted UPD=Row Updated |
| 8 | GPBR_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Status
CANC=Cancelled COMP=Completed DUPL=Duplicated ERRM=Error Mapping GERR=WS Return Error GSUC=WS Return Success HOLD=On Hold MAPP=Mapping NEW=New RDY=Ready SMOV=Without Movement SUCC=Success XCRT=XML Create XERR=XML Error XRDY=XML Ready XSEN=XML Sent |
| 9 | GPBR_ORIG_ESOC | Character(1) | VARCHAR2(1) NOT NULL |
eSocial Process Origin Drivers/Stages
B=Batch Process E=External Process I=Initial Load Process M=Manual Process O=On-Line Process |
| 10 | GPBR_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Instance Number |
| 11 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 12 | GPBR_PRE_DRV_SEQ | Number(30,0) | DECIMAL(30) NOT NULL | eSocial Pre Driver Sequence |
| 13 | GPBR_TIMESTAMP | DateTime(26) | TIMESTAMP | Process Time Stamp for Mass Termination |
| 14 | DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 15 | GPBR_PROTOC | Character(50) | VARCHAR2(50) NOT NULL | Protocol |
| 16 | GPBR_VERSION | Character(9) | VARCHAR2(9) NOT NULL | eSocial version |
| 17 | GPBR_BATCH_ID | Character(20) | VARCHAR2(20) NOT NULL | Batch ID |
| 18 | GPBR_FILESENT | Character(80) | VARCHAR2(80) NOT NULL | eSocial File Name Sent |
| 19 | GPBR_FILERETURN | Character(80) | VARCHAR2(80) NOT NULL | eSocial File Name Returned |
| 20 | GPBR_RECEIPT_NUM | Character(40) | VARCHAR2(40) NOT NULL | Receipt Num |
| 21 | GPBR_EVENT_ID | Character(40) | VARCHAR2(40) NOT NULL | eSocial - Generate ID Number Governant |
| 22 | GPBR_EVENT_SEQ_ID | Character(5) | VARCHAR2(5) NOT NULL | Generate ID Number Sequence Governant |
| 23 | GPBR_ES_MAP_DT | Date(10) | DATE | eSocial Mapping Date |
| 24 | GPBR_ES_PS | Date(10) | DATE | eSocial on PeopleSoft Date |
| 25 | GPBR_PRV_DT | Date(10) | DATE | eSocial Previous Date |