GPBR_NRP_ATR_AD (SQL Table)	Index Back
Absence Take/Reason ADS Rec. eSocial Absence Take/Reason Element Relationship ADS Record.

GPBR_NRP_ATR_AD

(SQL Table)

Absence Take/Reason ADS Rec.

eSocial Absence Take/Reason Element Relationship ADS Record.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take

4 ABSENCE_REASON Character(3) VARCHAR2(3) NOT NULL absence reason

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

6 GPBR_ABS_CODE Character(2) VARCHAR2(2) NOT NULL eSocial: Absence Legal Code.

7 GPBR_REPORTED_DUR Number(2,0) SMALLINT NOT NULL eSocial: Reported Duration

8 GPBR_MULTPLE_OCCUR Character(1) VARCHAR2(1) NOT NULL If It is Multiple Occurs
Default Value: N

9 GPBR_ABS_CODE2 Character(2) VARCHAR2(2) NOT NULL eSocial: Absence Legal Code.

10 GPBR_ACCR_ABS_DAYS Number(2,0) SMALLINT NOT NULL eSocial: Cumulative Duration

11 GPBR_EVENT_CD Character(6) VARCHAR2(6) NOT NULL eSocial - Event Code

12 GPBR_EMPL_CATEGRY Character(1) VARCHAR2(1) NOT NULL eSocial : Employee Category.
0=Employee
1=Non-Employee

13 GPBR_DAYS_BEFORE Number(3,0) SMALLINT NOT NULL This field is used to indicate how many days before the current date to show the history date range.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take
4	ABSENCE_REASON	Character(3)	VARCHAR2(3) NOT NULL	absence reason
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
6	GPBR_ABS_CODE	Character(2)	VARCHAR2(2) NOT NULL	eSocial: Absence Legal Code.
7	GPBR_REPORTED_DUR	Number(2,0)	SMALLINT NOT NULL	eSocial: Reported Duration
8	GPBR_MULTPLE_OCCUR	Character(1)	VARCHAR2(1) NOT NULL	If It is Multiple Occurs Default Value: N
9	GPBR_ABS_CODE2	Character(2)	VARCHAR2(2) NOT NULL	eSocial: Absence Legal Code.
10	GPBR_ACCR_ABS_DAYS	Number(2,0)	SMALLINT NOT NULL	eSocial: Cumulative Duration
11	GPBR_EVENT_CD	Character(6)	VARCHAR2(6) NOT NULL	eSocial - Event Code
12	GPBR_EMPL_CATEGRY	Character(1)	VARCHAR2(1) NOT NULL	eSocial : Employee Category. 0=Employee 1=Non-Employee
13	GPBR_DAYS_BEFORE	Number(3,0)	SMALLINT NOT NULL	This field is used to indicate how many days before the current date to show the history date range.