GPBR_ES_CPE_AET(SQL Table) |
Index Back |
|---|---|
eSocial - Period Control 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 | 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 |
| 3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 5 | GPBR_EVENT_CD | Character(6) | VARCHAR2(6) NOT NULL | eSocial - Event Code |
| 6 | GPBR_ESOC_YEAR | Number(4,0) | SMALLINT NOT NULL | Competency Year |
| 7 | 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 |
| 8 | GPBR_ESOC_SRCH_CMP | Character(2) | VARCHAR2(2) NOT NULL |
eSocial Selectiom Criteria
01=Company 02=All Companies 03=Employee |
| 9 | GPBR_ES_VALIDATE | Character(1) | VARCHAR2(1) NOT NULL | Initial Loading - Reprocess |
| 10 | GPBR_ES_PREPARE | Character(1) | VARCHAR2(1) NOT NULL | Initial Loading - Reprocess |
| 11 | GPBR_ES_FINALIZE | Character(1) | VARCHAR2(1) NOT NULL | Initial Loading - Reprocess |
| 12 | GPBR_ES_REPROCESS | Character(1) | VARCHAR2(1) NOT NULL | Initial Loading - Reprocess |
| 13 | GPBR_ES_CALENDAR | Character(1) | VARCHAR2(1) NOT NULL | eSocial - Calendar Flag - Run Control Periodics Events |
| 14 | GPBR_ES_SKIP_ER | Character(1) | VARCHAR2(1) NOT NULL | Initial Loading - Reprocess |
| 15 | 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 |
| 16 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 17 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 18 | COUNT1 | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |
| 19 | COUNT2 | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |
| 20 | ENABLED | Character(1) | VARCHAR2(1) NOT NULL | A flag indicates whether this row is enabled or not. |
| 21 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 22 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 23 | ROW_COUNT | Number(8,0) | INTEGER NOT NULL | Number to Purge |
| 24 | GPBR_VERSION | Character(9) | VARCHAR2(9) NOT NULL | eSocial version |
| 25 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 26 | GPBR_PREV_YEAR | Number(4,0) | SMALLINT NOT NULL | Competency Year |
| 27 | GPBR_PREV_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 |
| 28 | GPBR_ES_PS | Date(10) | DATE | eSocial on PeopleSoft Date |
| 29 | GPBR_CRITERIA | Character(100) | VARCHAR2(100) NOT NULL | Driver Status SQL Criteria. |
| 30 | HRRFW_SQL_TEXT | Character(254) | VARCHAR2(254) NOT NULL | Conditional Text |
| 31 | ACTION_FLAG | Character(2) | VARCHAR2(2) NOT NULL | Action Flag |
| 32 | GPBR_ES_PERIOD_TP | Character(1) | VARCHAR2(1) NOT NULL |
eSocial Period Type
1=Monthly 2=Annual |
| 33 | REPORT_DEFN_ID | Character(12) | VARCHAR2(12) NOT NULL | Report Name (see PSXPRPTDEFN). |
| 34 | TMPLDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Template ID (see PSXPTMPLDEFN). |
| 35 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 36 | AE_PROGRAM | Character(12) | VARCHAR2(12) NOT NULL | Clear in Program |
| 37 | GPBR_EVNT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Event eSocial Brazil |
| 38 | GPBR_ES_SKIP_VA | Character(1) | VARCHAR2(1) NOT NULL | Skip Closing rule |