| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Default Value: NEW
Prompt Table:
PERSON
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 3 |
TAXCODE_UK |
Character(15) |
VARCHAR2(15) NOT NULL |
Tax Code
|
| 4 |
TAX_BASIS_UK |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Basis
0=Cumulative
1=Week 1/Month 1
Default Value: 0
|
| 5 |
WORKER_TYPE_MEX |
Character(4) |
VARCHAR2(4) NOT NULL |
Worker Type Mexico
0010=Permanent Worker
0020=Eventual Worker
0030=Construction Eventual
|
| 6 |
REDUCED_WEEK_MEX |
Character(4) |
VARCHAR2(4) NOT NULL |
Detail of Reduced Week for Mexico
0000=Complete Week
0010=1 Day per Week
0020=2 Day per Week
0030=3 Day per Week
0040=4 Day per Week
0050=5 Day per Week
0060=Workday less than 8 Hours
|
| 7 |
LOCATED_CD_MEX |
Character(18) |
VARCHAR2(18) NOT NULL |
Location Code for Mexico.
|
| 8 |
SALARY_TYPE_MEX |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Type Mexico
0010=Fixed Salary
0020=Mixed Salary
0030=Variable Salary
0040=All Salaries
|
| 9 |
IMS_TERM_DT_MEX |
Date(10) |
DATE |
Mexico IMSS Termination Date
|
| 10 |
BALANCE_GRP_NUM |
Character(3) |
VARCHAR2(3) NOT NULL |
This field will be used to determine the grouping of balances from the different jobs of the employee.
|
| 11 |
FP_ACTION_2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Action after Retroactive Event
|
| 12 |
CTG_RATE |
Number(3,0) |
SMALLINT NOT NULL |
Category Rate
|
| 13 |
FP_LEGALSTAT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Civil Service Position Code
Prompt Table:
FPMLEGALSTA_TBL
|
| 14 |
FP_SCNDMT_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee on Secondment
Y/N Table Edit
|
| 15 |
FP_SCND_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Secondment Type (Int,Ext)
B=No Effect
E=External Secondment
I=Internal Secondment
|
| 16 |
FP_CIVIL_PENSION |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Leads to Civil Pension
Y/N Table Edit
Default Value: N
|
| 17 |
FP_SOURCE_ORG |
Character(50) |
VARCHAR2(50) NOT NULL |
Home Organization
|
| 18 |
FP_RECEP_ORG |
Character(30) |
VARCHAR2(30) NOT NULL |
Receiving Organization
|
| 19 |
FP_RETURN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Return
Y/N Table Edit
|
| 20 |
FP_PR_LEGSTA |
Character(3) |
VARCHAR2(3) NOT NULL |
Position before Return
Prompt Table:
FPMLEGALSTA_TBL
|
| 21 |
FP_FOREND_DT |
Date(10) |
DATE |
Position Expected End Date
|
| 22 |
FP_END_DT |
Date(10) |
DATE |
Position Actual End Date
|
| 23 |
FP_CAREFRZPCT |
Number(3,0) |
SMALLINT NOT NULL |
Career Advancement %
|
| 24 |
FP_HIR_DOS_SIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Hire Status
00=Contract Signed
01=Hiring Done
02=Hiring Validated
|
| 25 |
FP_PT_PCT_DET |
Character(3) |
VARCHAR2(3) NOT NULL |
Working Time % on Secondment
100=100
50=50
60=60
70=70
80=80
90=90
|
| 26 |
FP_TITLE_NUM |
Character(10) |
VARCHAR2(10) NOT NULL |
Title Number
|
| 27 |
FP_DURATION_PCT |
Number(3,0) |
SMALLINT NOT NULL |
Advancement % Service Length
|
| 28 |
FP_RATING_PRS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rating AttendanceFlag
Y/N Table Edit
Default Value: N
|
| 29 |
FP_BUDGET_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Budget Headcount
|
| 30 |
FP_HDCNT_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Statutory Headcount
|
| 31 |
FP_POTENT_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Potential Full-Time Equivalent
|
| 32 |
FP_RANK_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Grade
|
| 33 |
FP_STEP_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Step
|
| 34 |
FP_RK_ENT_DT |
Date(10) |
DATE |
Grade Entry Date
|
| 35 |
FP_CORPS_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Corps
Prompt Table:
FPMCORPS_TBL
|
| 36 |
FP_CHG_COR_DT |
Date(10) |
DATE |
Corps Change Date
|
| 37 |
FP_CATG_FP |
Character(2) |
VARCHAR2(2) NOT NULL |
Civil Service Category
A=A
B=B
C=C
D=D
X=No Existing Category
|
| 38 |
FP_CATG_LEVEL |
Character(3) |
VARCHAR2(3) NOT NULL |
Category Level
|
| 39 |
FP_RK_TRIALPD |
Character(1) |
VARCHAR2(1) NOT NULL |
Probation Period Grade
Y/N Table Edit
|
| 40 |
FP_STEP_END_DT |
Date(10) |
DATE |
(Sub)Step Actual End Date
|
| 41 |
FP_FOR_PROM_DT |
Date(10) |
DATE |
Expected Advancement Date
|
| 42 |
FP_NOMINATION_DT |
Date(10) |
DATE |
Appointment Date
|
| 43 |
FP_TRAINEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Trainee
Y/N Table Edit
|
| 44 |
FP_TRNE_POSN |
Character(1) |
VARCHAR2(1) NOT NULL |
Probationary Period State
A=Rejected
B=None
E=In progress
V=Validated
|
| 45 |
FP_RK_PD_END_DT |
Date(10) |
DATE |
PPd Expected End Date
|
| 46 |
FP_SANCTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Sanction
N=
S=Sanction Extension
Y=Sanction
|
| 47 |
FP_DOWN_GRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Demotion
N=
Y=Downgrading
|
| 48 |
FP_APPL_SAL_DT |
Date(10) |
DATE |
Compensation Application Date
|
| 49 |
FP_CHG_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Forced Index
Y/N Table Edit
|
| 50 |
FP_CLD_INST |
Character(1) |
VARCHAR2(1) NOT NULL |
Instance Terminated
Y/N Table Edit
|
| 51 |
FP_SETID_RANK |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 52 |
FP_INSTALL_DT |
Date(10) |
DATE |
Installation Date
|
| 53 |
FP_EQUIV_STEP |
Character(4) |
VARCHAR2(4) NOT NULL |
Corresponding Step
|
| 54 |
FP_STEP_CD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Derived Step
|
| 55 |
FP_BUSINESS_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Occupation Code
Prompt Table:
FPMBUISNESS_TBL
|
| 56 |
FP_APPL_DT |
Date(10) |
DATE |
Application Date
|
| 57 |
FP_CHG_SAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Forced Salary
Y/N Table Edit
|
| 58 |
FP_POINTYP_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Point Type Code
Prompt Table:
FPMPOINTYP_TBL
|
| 59 |
FP_GROSS_IND |
Number(4,0) |
SMALLINT NOT NULL |
Gross Index
|
| 60 |
FP_INCS_IND |
Number(4,0) |
SMALLINT NOT NULL |
Increased Index
|
| 61 |
FP_INCS_IND2 |
Number(4,0) |
SMALLINT NOT NULL |
Increased Index 2
|
| 62 |
FP_PT_PCT |
Character(3) |
VARCHAR2(3) NOT NULL |
Working Time Percentage
050=50
060=60
070=70
080=80
090=90
100=100
|
| 63 |
FP_PT_END_DT |
Date(10) |
DATE |
Part-Time End Date
|
| 64 |
FP_PT_FOREND_DT |
Date(10) |
DATE |
PT Expected End Date
|
| 65 |
FP_COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Rate
|
| 66 |
FP_INST_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Instance Status
D=Request
R=Actual
|
| 67 |
FP_RETROSPECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Retroactivity Code
Y/N Table Edit
|
| 68 |
FP_ROW_END_DT |
Date(10) |
DATE |
JOB Instance End Date
|
| 69 |
LAST_UPDATE_DATE |
Date(10) |
DATE |
Date of last update
|
| 70 |
OTHER_ID_JPN |
Character(11) |
VARCHAR2(11) NOT NULL |
Other Identifier
|
| 71 |
INTCP_XFR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Intercompany Transfer Flag
1=Home Company Information
2=Host Company Information
|
| 72 |
INTCP_XFR_START_DT |
Date(10) |
DATE |
Intercompany Transfer Start Dt
|
| 73 |
INTCP_XFR_END_DT |
Date(10) |
DATE |
Intercompany Transfer End Date
|
| 74 |
INTCP_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
BUSUNIT_HR_VW
|
| 75 |
INTCP_DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_INT_VW_JPN
|
| 76 |
INTCP_DEPTID2 |
Character(10) |
VARCHAR2(10) NOT NULL |
External DeptID
Prompt Table:
INTCPX_DPT_JPN
|
| 77 |
INTCP_SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Intcmpny Trasnfer Dept SetID
|
| 78 |
INTCP_COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Intercompany Transfer Company
Prompt Table:
COMPANY_TBL
|
| 79 |
INTCP_COMPANY2 |
Character(3) |
VARCHAR2(3) NOT NULL |
External Company
Prompt Table:
INTCPX_CPY_JPN
|
| 80 |
INTCP_SUPV_LVL_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Intcmpny Transfer Supv Lvl
Prompt Table:
SUPV_INT_VW_JPN
|
| 81 |
INTCP_SUPV_LVL_ID2 |
Character(8) |
VARCHAR2(8) NOT NULL |
External Supv Lvl
Prompt Table:
INTCPX_SPV_JPN
|
| 82 |
START_DATE_JPN |
Date(10) |
DATE |
Tracks the beginning date of an additional appointment assignment.
|
| 83 |
EXP_END_DATE_JPN |
Date(10) |
DATE |
Tracks the date in the future when the additional appointment assignment is expected to be completed.
|
| 84 |
END_DATE_JPN |
Date(10) |
DATE |
The actual date that an additional appointment assignment was completed.
|
| 85 |
DUTIES_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
The type of duties for Temporary Assignments.
Prompt Table:
TEMP_DUTIES_TBL
|
| 86 |
ASSIGNMENT_ID |
Number(8,0) |
INTEGER NOT NULL |
This is a system assigned number solely for Temporary Assignment jobs. It is used as a link between the Temporary Assignment job row and its respective Substantive job that is temporarily put on hold.
|
| 87 |
TARGET_COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Target Compensation Rate
|
| 88 |
CMP_DONT_ABSORB |
Character(1) |
VARCHAR2(1) NOT NULL |
Don't Absorb Changes
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 89 |
SSN_EMPLOYER |
Character(13) |
VARCHAR2(13) NOT NULL |
Employer Social Security number
Prompt Table:
ESTB_CCC_ALL_VW
|
| 90 |
UNITA_PROD_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Productive Unit
Prompt Table:
UNITA_PROD_TBL
|
| 91 |
ACTION_ITA |
Character(3) |
VARCHAR2(3) NOT NULL |
Turnover - Action
HIR=Hire
LAY=Lay off
LEA=Leave of Absence
TER=Termination
|
| 92 |
ACTION_REASON_ITA |
Character(3) |
VARCHAR2(3) NOT NULL |
Turnover Action Reason
Prompt Table:
TRV_ACTRSN_ITA
|
| 93 |
SPECIAL_HIRCTG_ITA |
Character(1) |
VARCHAR2(1) NOT NULL |
Special Hiring Category
1=Mobility List
2=CIG List
3=Unemployed List
4=Unemployed - Weak Wrap
5=Protected
|
| 94 |
PART_TIME_TYPE_ITA |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Part Time - ITA
C=Cyclic
H=Horizontal
V=Vertical
|
| 95 |
PART_TIME_PERC_ITA |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Percentage of Part Time
|
| 96 |
PARTTIME_ENDDT_ITA |
Date(10) |
DATE |
Part Time End Date
|
| 97 |
WORKDAYS_NLD |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Number of working days per week...
This field keeps track on the number of days an employee is working.
Default Value: 5
|
| 98 |
CONT_SAL_TYPE_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Salary Type Brazil
1=Monthly
2=Fortnightly
3=Weekly
4=Daily
5=Hourly
6=Per Task
7=Commission
8=Other
Default Value: 1
|
| 99 |
CBO_CD_BRA |
Character(7) |
VARCHAR2(7) NOT NULL |
Occupation Code for Brazil
Default Value: JOBCODE_TBL_BRA.CBO_CD_BRA
|
| 100 |
SEFIP_CATEGORY_BRA |
Character(2) |
VARCHAR2(2) NOT NULL |
SEFIP CATEGORY Brazil
01=Employee
02=Temporary Worker
03=Worker w/FGTS benefit w/o link
04=Limited Period Employee
05=Director not employed w/FGTS
07=Underaged Intern
11=Director not employed w/o FGTS
12=Other Public Agents
13=Self-empl w/payment withholdng
14=Selfempl w/base-sal withholdng
15=Ind. transporter w/contr compe
16=Ind. transporter w/contr salar
17=Coop worker, Service Provider
18=Freight Coop, service provider
19=Political Agent
20=Non-permanent Governmnt Worker
21=Permanent Government Worker
22=Not Applicable
Default Value: 01
|
| 101 |
UNION_CD_ALT_BRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Alternate Union Code Brazil
Prompt Table:
UNION_TBL
|
| 102 |
ELS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Employment and Labour Standards Status
1=Exempt
2=Non-Exempt
Default Value: 2
|