COMPANYGPBR_EVENT_CDGPBR_BATCH_CODEF=Finalized
I=Invalid
V=Valid
GPBR_EH_S1070_H(SQL Table) |
Index Back |
|---|---|
S-1070 Hdr Stg Import Hist DtStaging table used in Import Historical Data process for event S-1070 to store batch codes with its respective header information. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | GPBR_EVENT_CD |
Character(6) | VARCHAR2(6) NOT NULL | eSocial - Event Code |
| 3 | GPBR_BATCH_CODE |
Character(15) | VARCHAR2(15) NOT NULL | Batch Code for Vacation Credit |
| 4 | GPBR_LOAD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Import Load Status
F=Finalized I=Invalid V=Valid |
| 5 | GPBR_TOTAL_VAL | Number(6,0) | INTEGER NOT NULL | Total number of valid rows in eSocial staging tables. |
| 6 | GPBR_TOTAL_INVAL | Number(6,0) | INTEGER NOT NULL | Total number of invalid rows in eSocial staging tables. |
| 7 | DTTM_IMPORTED | DateTime(26) | TIMESTAMP | Imported Date Time |
| 8 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |