| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
CONTRACT_BEGIN_DT |
Date(10) |
DATE |
Contract Begin Date
|
| 3 |
CONTRACT_END_DT |
Date(10) |
DATE |
Contract End Date
|
| 4 |
SIGNATURE_DT |
Date(10) |
DATE |
Signature Date
|
| 5 |
CONTRACT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Status -
The values 'N - N/A' and 'P - Pending' are suppressed from release 8.
A=Active
I=Inactive
|
| 6 |
ADD_CONTRACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional Contract
|
| 7 |
CNT_MIN_HRS |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Minimum Hours Per Contract
|
| 8 |
CNT_MAX_HRS |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Maximum Hours Per Contract
|
| 9 |
RESPONSIBLE_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Responsible ID
|
| 10 |
YEAR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
More than one year expected
|
| 11 |
COMMENTSHORT |
Character(30) |
VARCHAR2(30) NOT NULL |
Short Comment
|
| 12 |
CNT_TEMPLATE_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Contract Template ID
|
| 13 |
BEGIN_WEEKDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Begin Day of Week
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
|
| 14 |
END_WEEKDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
End Day of Week
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
|
| 15 |
HIRE_CTR_CD_ESP |
Character(3) |
VARCHAR2(3) NOT NULL |
Hiring Center
|
| 16 |
COMP_RATE_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Compensation Rate Description
|
| 17 |
PROBATION_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Probation Period
|
| 18 |
DURATION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Duration
D=Days
M=Months
Y=Years
|
| 19 |
VACATION_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Vacation Period
|
| 20 |
VACN_PERIOD_UNIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Vacation Period Type
D=Work Days
M=Months
N=Natural Days
W=Weeks
|
| 21 |
CONTRCT_EXP_END_DT |
Date(10) |
DATE |
Contract Expected End Date
|
| 22 |
NEE_PROVIDER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
The ID for the Non Employee Provider, Agency, or Employer.
|
| 23 |
CONTRACT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Contract Type
|
| 24 |
EXTEND_CONTRACT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Extend Contract
|
| 25 |
CNT_RSZ_SUBM_BEL |
Character(1) |
VARCHAR2(1) NOT NULL |
RSZ-Submitted
Y/N Table Edit
Default Value: Y
|
| 26 |
CNT_RSZ_CAT_BEL |
Character(3) |
VARCHAR2(3) NOT NULL |
RSZ-Category
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
|
| 27 |
RED_CHRG_CAT_BEL |
Character(6) |
VARCHAR2(6) NOT NULL |
Reduced Charges Category
Prompt Table:
REDUCT_TBL_BEL
|
| 28 |
REDCH_STARTDT_BEL |
Date(10) |
DATE |
Reduced Charges Start Date
|
| 29 |
REDCH_ENDDT_BEL |
Date(10) |
DATE |
Reduce Charge End Date
|
| 30 |
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
|
| 31 |
CONTRIB_ID_ESP |
Character(5) |
VARCHAR2(5) NOT NULL |
Soc.Sec. Contribution ID - ESP
|
| 32 |
SCHEME_ID_ESP |
Character(4) |
VARCHAR2(4) NOT NULL |
Scheme ID - ESP
|
| 33 |
ACTIVE_RENT_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Social Security Active Rent
|
| 34 |
FIRST_SELFWRKR_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
First self employer worker
|
| 35 |
PART_TIME_PERC_ESP |
Number(3,0) |
SMALLINT NOT NULL |
Percentage of Part Time
|
| 36 |
RE_JOIN_DSB_EE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Re-Joined Disabled Employee
|
| 37 |
SOC_EXCLUSION_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Social Exclusion Employee
0=None
1=Social Exclusion
2=Domestic Violence Victim
3=Gender Violence Victim
4=Soc Excl - Insertion Itinerary
5=Soc Excl - Relapse
|
| 38 |
UNEMPLYMNT_CND_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Unemployment Condition
1=Booked in Unemployment Office
2=Booked in Office more than 12
3=Agricultural
4=With subsidy over one year
5=Booked in Office more than 6 m
6=With One-yr-remaining Subsidy
7=W/ subsidy. Older than 52 yrs.
A=W/ Benefit. RDL 2/2009
B=With Employability Problems
C=Unemployed at 1-1-2011
D=Unemployed at 1-1-2011. 12/18
E=Unemployed 16-08-2011
F=Unemployed with Family support
G=Unemployed >6 m. Fam Support
H=Under 3 m. of work experience
I=Unemployed from another sector
J=Youth Employment
K=Unemployed w/o Education Certf
M=Part Time<333. RDL 2/2009
P=RDL 3/2014 - Fix rate
R=RDL 1/2015 Reduced rate
|
| 39 |
CLAUSE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Clause Status
1=Optional
2=Required
|
| 40 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 41 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|