| # |
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 Rcd Nbr
|
| 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
|