GPBR_ES_IDCAL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPBR_ESOC_YEAR	Number(4,0)	SMALLINT NOT NULL	Competency Year
2	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
3	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
4	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
5	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
6	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
7	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
8	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
9	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
10	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
11	PERIOD_BEGIN_DT	Date(10)	DATE	Period Begin Date
12	PERIOD_END_DATE	Date(10)	DATE	Period End Date
13	PAYMENT_DT	Date(10)	DATE	Payment Date
14	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
15	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
16	GPBR_CPF_ID	Character(11)	VARCHAR2(11) NOT NULL	eSocial National ID Number
17	GPBR_PIS_ID	Character(11)	VARCHAR2(11) NOT NULL	eSocial National ID Number
18	GPBR_NID_ID	Character(11)	VARCHAR2(11) NOT NULL	eSocial National ID Number
19	PYE_CALC_STAT	Character(2)	VARCHAR2(2) NOT NULL	Calculation Status: field indicates the processing status of a segment (payment) 00=Identified 02=Calculation Error 03=Calculation Error - Bypassed 04=Calculation Error - By Rule 11=No Segment Created 50=Calculation Successful 55=Frozen For Further Calc 70=Finalized 75=Finalized - With Banking
20	GPBR_1200_STATUS	Character(4)	VARCHAR2(4) NOT NULL	1200 Status AFC=Awaiting Finalize Calendar ARG=Awaiting Return Government ART=Awaiting Return Termination ERRE=Error Event FIN=Finalized IDEN=Identified MSET=Not Eligible NCOM=Next Competency PCOM=Previous Competency STE=Termination in Progress
21	GPBR_1210_STATUS	Character(4)	VARCHAR2(4) NOT NULL	1210 Status AFC=Awaiting Finalize Calendar ARG=Awaiting Return Government ART=Awaiting Return Termination ERRE=Error Event FIN=Finalized IDEN=Identified MSET=Not Eligible NCOM=Next Competency PCOM=Previous Competency STE=Termination in Progress
22	RUN_FINALIZED_IND	Character(1)	VARCHAR2(1) NOT NULL	Finalized Run
23	RUN_FINALIZED_TS	DateTime(26)	TIMESTAMP	Finalized Timestamp
24	GPBR_EVENT_1200	Character(1)	VARCHAR2(1) NOT NULL	eSocial - Event Code
25	GPBR_EVENT_1210	Character(1)	VARCHAR2(1) NOT NULL	eSocial - Event Code
26	GPBR_PRC_IND	Character(1)	VARCHAR2(1) NOT NULL	Process indicator A=Assign Benefit Program E=Elect Options N=Normal Processing P=Prepare Options R=Re-Enter V=Void Y/N Table Edit Default Value: Y
27	GPBR_WAGE_TYPES_ID	Character(8)	VARCHAR2(8) NOT NULL	Wages Types IDs for eSocial Brazil
28	GP_NUM_VAL	Number(20,6)	DECIMAL(19,6) NOT NULL	Used to store Number value used on the banking preparation definition page
29	LAST_UPDT_DTTM	DateTime(26)	TIMESTAMP	Last Updated Date-Time Stamp
30	GPBR_ES_CAL_CNT	Number(2,0)	SMALLINT NOT NULL	eSocial Calendar Count 1200 Default Value: 0
31	GPBR_ES_CAL_CNT2	Number(2,0)	SMALLINT NOT NULL	eSocial Calendar Count 1210
32	GPBR_PAYROLL_TP	Character(1)	VARCHAR2(1) NOT NULL	Payroll TP 0=N/A 1=Monthly 2=Annual Default Value: 0
33	EMPL_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Employee Classification
34	GPBR_ES_PERIOD_TP2	Character(1)	VARCHAR2(1) NOT NULL	eSocial Period Type 1=Monthly 2=Annual Default Value: 1