PROCESS_INSTANCEA=Add
D=Delete
O=Override
F=Finalize
P=Process Data
F=Finalized
I=Invalid
V=Valid
N=No Errors Found
S=Stop the Processing
GPBR_EH_AET(SQL Table) |
Index Back |
|---|---|
eSocial Event Hist Data AETLoad of eSocial event historical data AET. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | GPBR_EVENT_CD | Character(6) | VARCHAR2(6) NOT NULL | eSocial - Event Code |
| 7 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 8 | GPBR_VERSION | Character(9) | VARCHAR2(9) NOT NULL | eSocial version |
| 9 | GPBR_ACTION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Action Type in processing historical data of eSocial events.
A=Add D=Delete O=Override |
| 10 | GPBR_BATCH_CODE | Character(15) | VARCHAR2(15) NOT NULL | Batch Code for Vacation Credit |
| 11 | GPBR_PROC_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Processing option for historical data of eSocial events.
F=Finalize P=Process Data |
| 12 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 13 | GPBR_ES_PS | Date(10) | DATE | eSocial on PeopleSoft Date |
| 14 | GPBR_LOAD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Import Load Status
F=Finalized I=Invalid V=Valid |
| 15 | GPBR_ES_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Initial Loading - Event Selected |
| 16 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 17 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 18 | START_DTTM | DateTime(26) | TIMESTAMP | Start Date/Time |
| 19 | END_DTTM | DateTime(26) | TIMESTAMP | Shift End Date/Time |
| 20 | TOTAL_ROWS | Number(6,0) | INTEGER NOT NULL | Values Found |
| 21 | GPBR_TOTAL_VAL | Number(6,0) | INTEGER NOT NULL | Total number of valid rows in eSocial staging tables. |
| 22 | GPBR_TOTAL_INVAL | Number(6,0) | INTEGER NOT NULL | Total number of invalid rows in eSocial staging tables. |
| 23 | GPBR_TOTAL_CREATED | Number(6,0) | INTEGER NOT NULL | Total number of rows created in eSocial driver tables. |
| 24 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 25 | BASE_LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 26 | GPBR_TOTAL_DEL | Number(6,0) | INTEGER NOT NULL | Total number of rows deleted from eSocial staging tables. |
| 27 | RUN_FINAL_IND | Character(1) | VARCHAR2(1) NOT NULL | Finalize Entire Run |
| 28 | GPBR_ERR_FOUND | Character(1) | VARCHAR2(1) NOT NULL |
Error(s) found during the processing that need to be addressed previously to run the process to success.
N=No Errors Found S=Stop the Processing |