GPBR_TC_CD_TBL (SQL Table)	Index Back
Timecard Code BRA eSocial Timecard Type Code BRA

GPBR_TC_CD_TBL

(SQL Table)

Timecard Code BRA

eSocial Timecard Type Code BRA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

2 TIMECARD_TYPE_BRA Character(2) VARCHAR2(2) NOT NULL Timecard Type Brazil for RAIS
00=00 Negative RAIS
01=01 Up 10 employees all months
02=02 Manual system control
03=03 Mechanical control system
04=04 SREP - Decree 1.510/2009
05=05 Art 1 Decree Alter non-elec
06=06 Decree Alternative electron

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

4 GPBR_TIMECARD_CD Character(1) VARCHAR2(1) NOT NULL Timecard Code
0=Not Applicable
1=Manual System Control
2=Mechanical Control Sysytem
3=SREP-Decree.510/2009
4=Decree Alternative no Eletron
5=Decree Alternative Eletronic
6=Electronic-Others

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
2	TIMECARD_TYPE_BRA	Character(2)	VARCHAR2(2) NOT NULL	Timecard Type Brazil for RAIS 00=00 Negative RAIS 01=01 Up 10 employees all months 02=02 Manual system control 03=03 Mechanical control system 04=04 SREP - Decree 1.510/2009 05=05 Art 1 Decree Alter non-elec 06=06 Decree Alternative electron
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	GPBR_TIMECARD_CD	Character(1)	VARCHAR2(1) NOT NULL	Timecard Code 0=Not Applicable 1=Manual System Control 2=Mechanical Control Sysytem 3=SREP-Decree.510/2009 4=Decree Alternative no Eletron 5=Decree Alternative Eletronic 6=Electronic-Others