GPBR_NRP_UNP_AD (SQL Table)	Index Back
Union Parameters This record is used to set some parameters for Union types Brazil

GPBR_NRP_UNP_AD

(SQL Table)

Union Parameters

This record is used to set some parameters for Union types Brazil

# 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 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code

3 EFFDT Date(10) DATE Effective Date

4 GPBR_DSR_TYPE Character(1) VARCHAR2(1) NOT NULL DSR Calculation Type
0=Worked Days
1=Entire Month

5 GPBR_MGD_COMISSN Number(13,2) DECIMAL(12,2) NOT NULL Minimum Guaranteed for Commission Agents, Brazil.

6 GPBR_M_UNION_PCT Number(6,2) DECIMAL(5,2) NOT NULL Monthly Union Percentage.

7 GPBR_MAXLIM_MLY_U Number(13,2) DECIMAL(12,2) NOT NULL Maximum Union Monthly Contribution

8 GPBR_FED_CONT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Confederative Contribution Percentage

9 GPBR_ATTN_CON_PCT Number(6,2) DECIMAL(5,2) NOT NULL Attendance Contribution Percentage.

10 GPBR_MAXLIM_CFD_CN Number(13,2) DECIMAL(12,2) NOT NULL Confederate Contribution Maximum Limit

11 GPBR_MAXLIM_ATT_C Number(13,2) DECIMAL(12,2) NOT NULL Maximum Attendance Contribution Limit

12 GPBR_XNSP_COUP_PCT Number(6,2) DECIMAL(5,2) NOT NULL Transport Coupons Percentage

13 GPBR_INS_AGREEMENT Number(1,0) SMALLINT NOT NULL INSS Agreement

14 GPBR_SALARY_TYPE Character(2) VARCHAR2(2) NOT NULL Salary Type for GP Brazil
01=Calendar Days
02=30 days Monthly Basis

15 GPBR_WRK_DAYS_ABS Character(1) VARCHAR2(1) NOT NULL By Worked Days For Absents

16 GPBR_DAYS_NOTICE Number(1,0) SMALLINT NOT NULL Count Days-13 sal/prior notif

17 GPBR_ENTITLED_FRAC Number(1,0) SMALLINT NOT NULL Prorate Average - 13h salary

18 GPBR_ENTITLED_VAC Number(1,0) SMALLINT NOT NULL Prorate Average - Vacation

19 GPBR_PIN_WKACC_NUM Number(8,0) INTEGER NOT NULL Work Related Accident, used for Termination Process

20 GPBR_EMPL_TENURE Number(1,0) SMALLINT NOT NULL Allows termination when tenure.

21 GPBR_13TH_AVG_PAY Number(1,0) SMALLINT NOT NULL Averages - Brazil Averages 13th Salary 1/0

22 GPBR_RECALC_13 Number(1,0) SMALLINT NOT NULL 13th Salary Recalculation

23 GPBR_HOM_TCAL_13TH Character(1) VARCHAR2(1) NOT NULL 13th Salary Calculation Type
1=CLT
2=Convention

24 GPBR_AVG_13TH Character(10) VARCHAR2(10) NOT NULL 13th Salary Average Version

25 GPBR_HOM_TCAL_VAC Character(1) VARCHAR2(1) NOT NULL Vacations Calculation Type
1=CLT
2=Convention

26 GPBR_AVG_VAC Character(10) VARCHAR2(10) NOT NULL Vacations Average Version

27 GPBR_HOM_TCAL_PREV Character(1) VARCHAR2(1) NOT NULL Previous Notification Calculation Type
1=CLT
2=Convention

28 GPBR_AVG_PREV Character(10) VARCHAR2(10) NOT NULL Previous Notification Average Version

29 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	UNION_CD	Character(3)	VARCHAR2(3) NOT NULL	Union Code
3	EFFDT	Date(10)	DATE	Effective Date
4	GPBR_DSR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	DSR Calculation Type 0=Worked Days 1=Entire Month
5	GPBR_MGD_COMISSN	Number(13,2)	DECIMAL(12,2) NOT NULL	Minimum Guaranteed for Commission Agents, Brazil.
6	GPBR_M_UNION_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Monthly Union Percentage.
7	GPBR_MAXLIM_MLY_U	Number(13,2)	DECIMAL(12,2) NOT NULL	Maximum Union Monthly Contribution
8	GPBR_FED_CONT_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Confederative Contribution Percentage
9	GPBR_ATTN_CON_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Attendance Contribution Percentage.
10	GPBR_MAXLIM_CFD_CN	Number(13,2)	DECIMAL(12,2) NOT NULL	Confederate Contribution Maximum Limit
11	GPBR_MAXLIM_ATT_C	Number(13,2)	DECIMAL(12,2) NOT NULL	Maximum Attendance Contribution Limit
12	GPBR_XNSP_COUP_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Transport Coupons Percentage
13	GPBR_INS_AGREEMENT	Number(1,0)	SMALLINT NOT NULL	INSS Agreement
14	GPBR_SALARY_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Salary Type for GP Brazil 01=Calendar Days 02=30 days Monthly Basis
15	GPBR_WRK_DAYS_ABS	Character(1)	VARCHAR2(1) NOT NULL	By Worked Days For Absents
16	GPBR_DAYS_NOTICE	Number(1,0)	SMALLINT NOT NULL	Count Days-13 sal/prior notif
17	GPBR_ENTITLED_FRAC	Number(1,0)	SMALLINT NOT NULL	Prorate Average - 13h salary
18	GPBR_ENTITLED_VAC	Number(1,0)	SMALLINT NOT NULL	Prorate Average - Vacation
19	GPBR_PIN_WKACC_NUM	Number(8,0)	INTEGER NOT NULL	Work Related Accident, used for Termination Process
20	GPBR_EMPL_TENURE	Number(1,0)	SMALLINT NOT NULL	Allows termination when tenure.
21	GPBR_13TH_AVG_PAY	Number(1,0)	SMALLINT NOT NULL	Averages - Brazil Averages 13th Salary 1/0
22	GPBR_RECALC_13	Number(1,0)	SMALLINT NOT NULL	13th Salary Recalculation
23	GPBR_HOM_TCAL_13TH	Character(1)	VARCHAR2(1) NOT NULL	13th Salary Calculation Type 1=CLT 2=Convention
24	GPBR_AVG_13TH	Character(10)	VARCHAR2(10) NOT NULL	13th Salary Average Version
25	GPBR_HOM_TCAL_VAC	Character(1)	VARCHAR2(1) NOT NULL	Vacations Calculation Type 1=CLT 2=Convention
26	GPBR_AVG_VAC	Character(10)	VARCHAR2(10) NOT NULL	Vacations Average Version
27	GPBR_HOM_TCAL_PREV	Character(1)	VARCHAR2(1) NOT NULL	Previous Notification Calculation Type 1=CLT 2=Convention
28	GPBR_AVG_PREV	Character(10)	VARCHAR2(10) NOT NULL	Previous Notification Average Version
29	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.