| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
EMPLMT_SRCH_GBL
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
BGN_DT |
Date(10) |
DATE NOT NULL |
Begin Date
|
| 4 |
END_DT |
Date(10) |
DATE |
end date
|
| 5 |
GPBR_SEFIP_RIS_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
SEFIP risk lever Brazil
00=Default
01=Non Exp.Harmful Agent
02=Exp. Ret. at 15 years
03=Exp. Ret. at 20 years
04=Exp. Ret. at 25 years
05=Non Exp. Harmful Agent M.Jobs
06=Exp. Ret. at 15 years M.Jobs
07=Exp. Ret. at 20 years M.Jobs
08=Exp. Ret. at 25 years M.Jobs
09=Not Applicable
Default Value: 00
|
| 6 |
GPBR_ADVANCE_OPT |
Number(1,0) |
SMALLINT NOT NULL |
Advance Option Brazil
1/0 Table Edit (1=True, 0=False)
|
| 7 |
GPBR_ADVANCE_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Advance Percentage Brazil
|
| 8 |
GPBR_FGTS_OPTION |
Number(1,0) |
SMALLINT NOT NULL |
FGTS Option
1/0 Table Edit (1=True, 0=False)
|
| 9 |
GPBR_FGTS_DT |
Date(10) |
DATE |
FGTS Date
|
| 10 |
GPBR_IR_DISCOUNT |
Number(1,0) |
SMALLINT NOT NULL |
Discount IR
1/0 Table Edit (1=True, 0=False)
Default Value: 0
|
| 11 |
GPBR_RISK_IND |
Character(2) |
VARCHAR2(2) NOT NULL |
Hazardous Indicator Brazil
00=Default
01=Applicable
02=Not Applicable
Default Value: 00
|
| 12 |
GPBR_TERM_NOTIF |
Date(10) |
DATE |
Termination Notification
|
| 13 |
GPBR_HOM_NEW_JOB |
Character(1) |
VARCHAR2(1) NOT NULL |
Homolognet New Job Indicator
Y/N Table Edit
Default Value: N
|
| 14 |
GPBR_HOM_NOTIF_ER |
Character(1) |
VARCHAR2(1) NOT NULL |
Previous Notification Excused by Employer
Y/N Table Edit
Default Value: N
|
| 15 |
GPBR_WEEKLY_HOURS |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Weekly Hours
|
| 16 |
GPBR_UNHEALTHY_IND |
Character(2) |
VARCHAR2(2) NOT NULL |
Unhealthy Ind
00=Default
01=Minimum Grade
02=Middle Grade
04=Maximum Grade
05=Not Applicable
Default Value: 00
|
| 17 |
GPBR_UNION_PAID |
Character(1) |
VARCHAR2(1) NOT NULL |
Union Contribution Paid BRA
Y/N Table Edit
Default Value: Y
|
| 18 |
GPBR_SERVICE_TAKER |
Character(3) |
VARCHAR2(3) NOT NULL |
Service Taker
Prompt Table:
GPBR_ST_EST_VW
|
| 19 |
GPBR_UNION_CD1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Union Code Brazil
Prompt Table:
UNION_TBL
|
| 20 |
GPBR_UNION_CD2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Union Code Brazil
Prompt Table:
UNION_TBL
|
| 21 |
GPBR_UNION_CD3 |
Character(3) |
VARCHAR2(3) NOT NULL |
Union Code Brazil
Prompt Table:
UNION_TBL
|
| 22 |
GPBR_WORK_REDUC |
Character(1) |
VARCHAR2(1) NOT NULL |
Reduction of 2 worked hours a day
Y/N Table Edit
Default Value: N
|
| 23 |
GPBR_TERM_CANCEL |
Date(10) |
DATE |
Cancellation Date
|
| 24 |
GPBR_RECON_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Reconsideration expected in article 489 of CLT
Y/N Table Edit
Default Value: N
|
| 25 |
GPBR_JUD_DET |
Character(1) |
VARCHAR2(1) NOT NULL |
Judicial Determination
Y/N Table Edit
Default Value: N
|
| 26 |
GPBR_COMP_LEG |
Character(1) |
VARCHAR2(1) NOT NULL |
Comply with legal norm
Y/N Table Edit
Default Value: N
|
| 27 |
GPBR_OTHER |
Character(1) |
VARCHAR2(1) NOT NULL |
Other Information
Y/N Table Edit
Default Value: N
|
| 28 |
GPBR_TERM_INFO |
Long Character(255) |
VARCHAR2(255) |
Termination Information Brazil
|
| 29 |
GPBR_PROCED_TER |
Character(20) |
VARCHAR2(20) NOT NULL |
Proceeding Number
|
| 30 |
GPBR_NOTICE_COMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Prior Notice Compliance information.
0=Full Compliance
1=Partial Compliance by Employee
2=Partial Compliance by Employer
3=Partial Compliance Oth reasons
|
| 31 |
GPBR_COMMON_AGRMNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Common agreement on working hours during prior notification period.
Y/N Table Edit
Default Value: N
|