GPBR_EH_S107001(SQL Table) |
Index Back |
|---|---|
S-1070 Dtl Stg Import Hist DtStaging table used in Import Historical Data process for event S-1070 to store batch codes with its respective detail information. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | GPBR_BATCH_CODE |
Character(15) | VARCHAR2(15) NOT NULL | Batch Code for Vacation Credit |
| 3 | ROW_REFERENCE_NUM |
Number(10,0) | DECIMAL(10) NOT NULL | helper fields for H-Grid reference |
| 4 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 5 | GPBR_EVENT_CD | Character(6) | VARCHAR2(6) NOT NULL | eSocial - Event Code |
| 6 | PRC_TYPE_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Process Type
1=Administrative 2=Judicial 3=Benefit Number - INSS 4=FAP - Process before 2019 |
| 7 | PROC_NBR_BRA | Character(21) | VARCHAR2(21) NOT NULL | Proceeding Number BRA |
| 8 | GPBR_ACTION | Character(3) | VARCHAR2(3) NOT NULL |
eSocial Action
ADD=Row Inserted COR=Row Correction DEL=Row Deleted UPD=Row Updated |
| 9 | 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 |
| 10 | GPBR_RECEIPT_NUM | Character(40) | VARCHAR2(40) NOT NULL | Receipt Num |
| 11 | GPBR_DATE_CHAR | Character(8) | VARCHAR2(8) NOT NULL | Date in text format YYYYMMDD. |
| 12 | GPBR_ES_PER | Character(6) | VARCHAR2(6) NOT NULL | eSocial period in format YYYYMM. |
| 13 | GPBR_ES_MAP_DT | Date(10) | DATE | eSocial Mapping Date |
| 14 | GPBR_ES_PS | Date(10) | DATE | eSocial on PeopleSoft Date |