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