| # |
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 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
SEFIP_RISK_LVL_BRA |
Character(2) |
VARCHAR2(2) NOT NULL |
SEFIP Risk Level 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 |
UNHEALTHY_IND_BRA |
Character(2) |
VARCHAR2(2) NOT NULL |
Unhealthy Indicator Brazil
00=Default
01=Minimum Grade
02=Middle Grade
04=Maximum Grade
05=Not Applicable
Default Value: 00
|
| 7 |
RISK_INDICATOR_BRA |
Character(2) |
VARCHAR2(2) NOT NULL |
Risk Indicator Brazil
00=Default
01=Applicable
02=Not Applicable
Default Value: 00
|
| 8 |
MULTIPLE_JOBS_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Jobs Brazil
Y/N Table Edit
Default Value: N
|
| 9 |
UNEM_INSU_BEN_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Unemplyment Insurace Beneficiary BRA
Y/N Table Edit
Default Value: N
|
| 10 |
REG_NUMBER_BRA |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee Registration Number
|
| 11 |
REGISTRY_TYPE_BRA |
Character(2) |
VARCHAR2(2) NOT NULL |
Registry Type Brazil
00=Not Applicable
01=Civilian
02=Military
03=Professional
04=Foreigner
05=Other
Default Value: 00
|
| 12 |
INDIC_HIRE_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Hire Type
1=Regular
2=Fiscal Action
3=Court Decision
Default Value: 1
|
| 13 |
REG_ESOCIAL_BRA |
Character(30) |
VARCHAR2(30) NOT NULL |
eSocial Reg. Number
|
| 14 |
JUDGE_AWARD_BRA |
Character(20) |
VARCHAR2(20) NOT NULL |
Court Process (Labor Child)
|
| 15 |
REHIR_TYPE_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Reintegration Type
1=Judicial Decision
2=Amnesty
9=Others
|
| 16 |
REHIRE_EFFDT_BRA |
Date(10) |
DATE |
Reintegration Effect Date
|
| 17 |
PAY_COURT_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment in Court
N=No
Y=Yes
|
| 18 |
REH_COURT_BRA |
Character(20) |
VARCHAR2(20) NOT NULL |
Judge Court Nbr
|
| 19 |
LAW_AMNES_BRA |
Character(13) |
VARCHAR2(13) NOT NULL |
Amnesty Law
|
| 20 |
REG_JORN_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Working Time Type
0=Not Applicable
1=Submitted to Work Schedule
2=External Activity
3=Functions Specific
4=Telecommuting
Default Value: 1
|
| 21 |
PROCEED_NBR_BRA |
Character(20) |
VARCHAR2(20) NOT NULL |
Proceeding Number
|