| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 2 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 4 |
CONTRACT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Contract Type
Prompt Table:
%EDITTABLE
|
| 5 |
EXTEND_CONTRACT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Extend Contract
Y/N Table Edit
Default Value: N
|
| 6 |
RSN_DET_CONTRACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Reason for Determine Period
M=Maternity
N=Not Applicable
P=Special Project
R=Replacement
|
| 7 |
EMPLID_REPLACED |
Character(11) |
VARCHAR2(11) NOT NULL |
Empl ID Replaced
Prompt Table:
PERSON_NAME
|
| 8 |
PROJECT_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Displays the Project names.
|
| 9 |
PLAN_ID_ITA |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan ID
S=Sales Plan
T=Technical Plan
|
| 10 |
DURATION_MONTH |
Number(3,0) |
SMALLINT NOT NULL |
Duration (Months)
|
| 11 |
LABOR_AGREEMENT |
Character(6) |
VARCHAR2(6) NOT NULL |
Labor Agreement
Prompt Table:
EMPL_CTG
|
| 12 |
EMPL_CTG |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Category
Prompt Table:
EMPL_CTG_L1
|
| 13 |
EMPL_CTG_L1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory
Prompt Table:
EMPL_CTG_L2
|
| 14 |
EMPL_CTG_L2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory 2
Prompt Table:
EMPL_CTG_L3
|
| 15 |
CATEGORY_CD_GPFRA |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used as a System Element in Global Payroll. It is a French specific field.
A=Apprentice
C=Manager
D=Executive
|
| 16 |
CLNG_CALPRCT_GPFRA |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
This field is used as a System Element in Global Payroll. It is a French specific field.
Default Value: 100
|
| 17 |
EMPL_CNDTN_GPFRA |
Character(2) |
VARCHAR2(2) NOT NULL |
This field is used as a System Element in Global Payroll. It is a French specific field.
01=Full Time
02=Part Time (without L242-8)
04=Periodic Worker
05=Worker At Home
06=Seasonal Worker
07=Temporary Worker
08=Occasional Worker
90=No Additional Contract
|
| 18 |
REDUC_PRCT_GPFRA |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
This field is used as a System Element in Global Payroll. It is a French specific field.
|
| 19 |
SS_REGIM_CD_GPFRA |
Number(3,0) |
SMALLINT NOT NULL |
This field is used as a System Element in Global Payroll. It is a French specific field.
Prompt Table:
GPFR_URS_RATES
|
| 20 |
EE_PROF_STATUS_FRA |
Character(2) |
VARCHAR2(2) NOT NULL |
Employee Professional Status - FRA
Prompt Table:
PRF_STS_FRA_TBL
|
| 21 |
CTG_STATUS_FRA |
Character(2) |
VARCHAR2(2) NOT NULL |
Category Status - FRA
Prompt Table:
CTG_STS_FRA_TBL
|
| 22 |
BASE_SCHEME_FRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Mandatory Base Scheme
Prompt Table:
BSE_SCH_FRA_TBL
|
| 23 |
INT_COMP_CONTRACT |
Character(3) |
VARCHAR2(3) NOT NULL |
Inter Company Contract
Prompt Table:
INT_CMP_CNT_FRA
|
| 24 |
ARGMT_WORK_TIME |
Character(3) |
VARCHAR2(3) NOT NULL |
Arrangement of Working Time
Prompt Table:
ARGMT_WK_TM_FRA
|
| 25 |
STATUTE_BEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Statute
Prompt Table:
STATUTE_TBL_BEL
|
| 26 |
SUBSTATUTE_BEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Substatute
00=Not Applicable
01=Regular Employee
02=Sales Representative
03=Executive
Prompt Table:
SUBSTAT_BEL_VW
|
| 27 |
CONTR_DUR_BEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Duration
01=Indefinite duration
02=Temporary duration
03=Defined work
04=Replacement
|
| 28 |
INDEP_OCCUP_BEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Independent Profession
|
| 29 |
PROFESSION_BEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Profession
01=Architects
02=Lawyers
03=Bookkeepers
04=Dentists
05=Physicians and surgeons
06=Veterinarians
07=Accountants
08=Surveyors
09=Bailiffs
10=Physiotherapists
11=Notaries
12=Chemists
13=Auditors
|
| 30 |
IND_COMMITTEE_BEL |
Character(3) |
VARCHAR2(3) NOT NULL |
The Joint Industrial Committee is used for Belgium to track the 'Paritair Comite' on company-, business unit- and department-level,
Prompt Table:
UNION_TBL
|
| 31 |
CNT_RSZ_SUBM_BEL |
Character(1) |
VARCHAR2(1) NOT NULL |
RSZ-Submitted
|
| 32 |
CNT_RSZ_CAT_BEL |
Character(3) |
VARCHAR2(3) NOT NULL |
RSZ category Belgiums
000=Not Applicable
010=Former Entitled Man Worker
020=Entitled Manual Worker
030=Ent. appr. Retail Worker
031=Entitled Industrial Apprentice
032=Entitled Management Trainee
040=Non-Entitled Self-Employed
041=Non-Entitled Director
042=Non-Ent Manager Non-Prof Sect
043=Non-Entitled Active Partner
050=Man Worker on Early Retirement
051=Office Worker on Early Retirem
052=Retired Man Worker (OAP)
053=Retired Office Worker (OAP)
054=Widow Office Worker (Wid Pens)
055=Widow Man Worker (Wid Pens.)
056=Orphan
057=Disabled
060=Employed Non-Entitled
061=Non-Entitled Manual Worker
062=Non-Entitled Office Worker
070=Entitled Homeworker
080=Entitled Domestic
090=Entitled Office Worker
091=Entitled Off Worker - Director
092=Entitled Off Worker - Manager
094=Ent Off Worker -Representative
|
| 33 |
SOCIAL_BALANCE_BEL |
Character(3) |
VARCHAR2(3) NOT NULL |
The Social Balance Category is entered on the Belgian contracts and used for the Social Reporting.
400=Company Plan
403=Youth Employment
404=Low Salaries
405=Employment Agreement 1995-1996
408=Longterm unemployed
409=Maribel
410=Re-employment (>50 years)
500=1st Work experience
501=Start up Agreement
502=Youth internship
503=Work/training agreement
504=Apprenticeship
505=Successive Defined Terms
506=Conventional early retirement
511=Conv.early retirem. part-time
512=Career interruption full-time
513=Career interruption part-time
|