GPBR_ES_PER_AET(SQL Table) |
Index Back |
|---|---|
Process eSocial Basic LoadeSocial - Process information from HRMS to eSocial Basic Tables Load |
| # | 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 | GPBR_ESOC_YEAR | Number(4,0) | SMALLINT NOT NULL | Competency Year |
| 5 | GPBR_ESOC_MONTHCD | Character(2) | VARCHAR2(2) NOT NULL |
eSocial Competency Month
01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December |
| 6 | GPBR_ESOC_SRCH_CMP | Character(2) | VARCHAR2(2) NOT NULL |
eSocial Selectiom Criteria
01=Company 02=All Companies 03=Employee |
| 7 | GPBR_EVENT_1300 | Character(1) | VARCHAR2(1) NOT NULL | eSocial - Event Code |
| 8 | GPBR_EVENT_1200 | Character(1) | VARCHAR2(1) NOT NULL | eSocial - Event Code |
| 9 | GPBR_EVENT_1210 | Character(1) | VARCHAR2(1) NOT NULL | eSocial - Event Code |
| 10 | GPBR_EVENT_1280 | Character(1) | VARCHAR2(1) NOT NULL | eSocial - Event Code |
| 11 | GPBR_ES_CALENDAR | Character(1) | VARCHAR2(1) NOT NULL | eSocial - Calendar Flag - Run Control Periodics Events |
| 12 | GPBR_ES_VALIDATE | Character(1) | VARCHAR2(1) NOT NULL | Initial Loading - Reprocess |
| 13 | GPBR_ES_PREPARE | Character(1) | VARCHAR2(1) NOT NULL | Initial Loading - Reprocess |
| 14 | GPBR_ES_CANCEL | Character(1) | VARCHAR2(1) NOT NULL | Initial Loading - Reprocess |
| 15 | GPBR_ES_FINALIZE | Character(1) | VARCHAR2(1) NOT NULL | Initial Loading - Reprocess |
| 16 | GPBR_ES_REPROCESS | Character(1) | VARCHAR2(1) NOT NULL | Initial Loading - Reprocess |
| 17 | GPBR_ES_SKIP_ER | Character(1) | VARCHAR2(1) NOT NULL | Initial Loading - Reprocess |
| 18 | ASOFDATE | Date(10) | DATE | As of Date |
| 19 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 20 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 21 | COUNT1 | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |
| 22 | COUNT2 | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |
| 23 | SQL_TEXT1 | Character(254) | VARCHAR2(254) NOT NULL | SQL Text 1 |
| 24 | SQL_TEXT2 | Character(254) | VARCHAR2(254) NOT NULL | SQL Text 2 |
| 25 | SQL_TEXT3 | Character(254) | VARCHAR2(254) NOT NULL | Used to hold dynamic SQL Text |
| 26 | SQL_TEXT4 | Character(254) | VARCHAR2(254) NOT NULL | Used to hold dynamic SQL Text |
| 27 | GPBR_EVENT_CD | Character(6) | VARCHAR2(6) NOT NULL | eSocial - Event Code |
| 28 | GPBR_ES_SOURCE | Character(4) | VARCHAR2(4) NOT NULL |
Source process Batch
ILB=Initial Loading Basic Tables ILE=Initial Loading Employee MBT=Mapping Basic Tables MNP=Mapping Non Periodic PHR=Pre-Hiring Tables TER=Termination |
| 29 | SQL_TEXT | Character(80) | VARCHAR2(80) NOT NULL | SQL Text |
| 30 | SQLTEXT | Long Character(14000) | CLOB | SQL Statement Text |
| 31 | SQL_STMT_254 | Character(254) | VARCHAR2(254) NOT NULL | An internal work field that contains SQL text that is to be utilized in treasury application p |
| 32 | SQL_STMT_800 | Long Character(800) | VARCHAR2(800) | SQL_Stmt_800 |
| 33 | GPBR_EXCL_1200 | Character(1) | VARCHAR2(1) NOT NULL |
Exclusion 1200
N=No Y=Yes |
| 34 | GPBR_EXCL_1210 | Character(1) | VARCHAR2(1) NOT NULL |
Exclusion 1210
N=No Y=Yes |
| 35 | GPBR_EXCL_1280 | Character(1) | VARCHAR2(1) NOT NULL |
Exclusion 1280
N=No Y=Yes |
| 36 | GPBR_EXCL_1300 | Character(1) | VARCHAR2(1) NOT NULL |
Exclusion 1300
N=No Y=Yes |
| 37 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 38 | ID_TBL_ED_BRA | Character(8) | VARCHAR2(8) NOT NULL | Earn/ Ded ID Table |
| 39 | GPBR_EVENT | Character(6) | VARCHAR2(6) NOT NULL | eSocial Event Code |
| 40 | GPBR_ES_DT_FROM | Date(10) | DATE | Termination Date Through |
| 41 | GPBR_SQL1 | Character(254) | VARCHAR2(254) NOT NULL | eSocial SQL text 1 |
| 42 | GPBR_SQL2 | Character(254) | VARCHAR2(254) NOT NULL | eSocial SQL text 2 |
| 43 | GPBR_SQL3 | Long Character(800) | VARCHAR2(800) | eSocial SQL text 1 |
| 44 | GPBR_SQL4 | Character(254) | VARCHAR2(254) NOT NULL | eSocial SQL text 1 |
| 45 | GPBR_SQL5 | Character(254) | VARCHAR2(254) NOT NULL | eSocial SQL text 1 |
| 46 | GPBR_SQL6 | Character(254) | VARCHAR2(254) NOT NULL | eSocial SQL text 1 |
| 47 | GPBR_SQL7 | Character(254) | VARCHAR2(254) NOT NULL | eSocial SQL text 1 |
| 48 | GPBR_SQL8 | Character(254) | VARCHAR2(254) NOT NULL | eSocial SQL text 1 |
| 49 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 50 | PERIOD_BEGIN_DT | Date(10) | DATE | Period Begin Date |
| 51 | GPBR_ES_PERIOD_TP | Character(1) | VARCHAR2(1) NOT NULL |
eSocial Period Type
1=Monthly 2=Annual |
| 52 | PERIOD_END_DATE | Date(10) | DATE | Period End Date |