GPBR_ES_BAT_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	ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Number to Purge
5	GPBR_ES_PS	Date(10)	DATE	eSocial on PeopleSoft Date
6	GPBR_ES_LAST	Date(10)	DATE	eSocial on PeopleSoft Last Date
7	GPBR_EVENT_CD	Character(6)	VARCHAR2(6) NOT NULL	eSocial - Event Code
8	GPBR_SELECT_ALL	Character(1)	VARCHAR2(1) NOT NULL	Initial Loading - Select All companies
9	GPBR_ES_REPROCESS	Character(1)	VARCHAR2(1) NOT NULL	Initial Loading - Reprocess Y/N Table Edit Default Value: N
10	GPBR_ES_FINALIZE	Character(1)	VARCHAR2(1) NOT NULL	Initial Loading - Reprocess Y/N Table Edit Default Value: N
11	GPBR_ES_PREPARE	Character(1)	VARCHAR2(1) NOT NULL	Initial Loading - Reprocess Y/N Table Edit Default Value: N
12	GPBR_ES_SKIP_ER	Character(1)	VARCHAR2(1) NOT NULL	Initial Loading - Reprocess Y/N Table Edit Default Value: N
13	GPBR_ES_DELETE	Character(1)	VARCHAR2(1) NOT NULL	Initial Loading - Reprocess Y/N Table Edit Default Value: N
14	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
15	OUTPUTDIR	Character(100)	VARCHAR2(100) NOT NULL	Output Directory
16	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
17	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
18	RECNAME1	Character(15)	VARCHAR2(15) NOT NULL	Record Name 1
19	RECNAME_2	Character(15)	VARCHAR2(15) NOT NULL	Record 2 Name
20	AE_CACHE_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Cache Record
21	ROW_COUNT2	Number(8,0)	INTEGER NOT NULL	Number of rows.
22	GPBR_VERSION	Character(9)	VARCHAR2(9) NOT NULL	eSocial version
23	GPBR_ES_E_ACT	Character(1)	VARCHAR2(1) NOT NULL	Activity
24	GPBR_ES_E_INACT	Character(1)	VARCHAR2(1) NOT NULL	Activity
25	GPBR_ES_DT_ACT	Date(10)	DATE	Termination Date Through
26	GPBR_ES_DT_FROM	Date(10)	DATE	Termination Date Through
27	GPBR_ES_DT_TO	Date(10)	DATE	Termination Date Through
28	ASOFDATE	Date(10)	DATE	As of Date
29	GPBR_ES_ADHERE	Date(10)	DATE	eSocial Adhere Date
30	ENABLED	Character(1)	VARCHAR2(1) NOT NULL	A flag indicates whether this row is enabled or not.
31	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
32	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
33	GPBR_ALL_ESTAB	Character(1)	VARCHAR2(1) NOT NULL	All Establishment N=No Y=Yes
34	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
35	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
36	COUNT1	Number(12,0)	DECIMAL(12) NOT NULL	AUS WGEA counts
37	SQL_ID	Character(30)	VARCHAR2(30) NOT NULL	TL
38	AE_PROGRAM	Character(12)	VARCHAR2(12) NOT NULL	Clear in Program
39	GPBR_EVNT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Event eSocial Brazil
40	GPBR_ES_VALIDATE	Character(1)	VARCHAR2(1) NOT NULL	Initial Loading - Reprocess
41	GPBR_EXCL_2299	Character(1)	VARCHAR2(1) NOT NULL	eSocial termination field N=No Y=Yes Y/N Table Edit Default Value: N
42	GPBR_EXCL_2399	Character(1)	VARCHAR2(1) NOT NULL	eSocial termination field Y/N Table Edit Default Value: N
43	SQL_TEXT1	Character(254)	VARCHAR2(254) NOT NULL	SQL Text 1
44	GPBR_ESOC_YEAR	Number(4,0)	SMALLINT NOT NULL	Competency Year
45	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
46	ROW_COUNT3	Number(8,0)	INTEGER NOT NULL	Number of rows.