| # |
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_BEGIN_DT |
Date(10) |
DATE |
Contract Begin Date
Default Value: %Date
|
| 5 |
CONTRACT_END_DT |
Date(10) |
DATE |
Contract End Date
|
| 6 |
SIGNATURE_DT |
Date(10) |
DATE |
Signature Date
|
| 7 |
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
Default Value: A
|
| 8 |
ADD_CONTRACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional Contract
Y/N Table Edit
Default Value: N
|
| 9 |
CNT_MIN_HRS |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Minimum Hours Per Contract
Default Value: BUS_UNIT_OPT_HR.MIN_STD_HRS
|
| 10 |
CNT_MAX_HRS |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Maximum Hours Per Contract
Default Value: BUS_UNIT_OPT_HR.MAX_STD_HRS
|
| 11 |
RESPONSIBLE_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Responsible ID
Prompt Table:
PERSON
|
| 12 |
YEAR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
More than one year expected
Y/N Table Edit
Default Value: N
|
| 13 |
COMMENTSHORT |
Character(30) |
VARCHAR2(30) NOT NULL |
Short Comment
|
| 14 |
CNT_TEMPLATE_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Contract Template ID
Prompt Table:
CNT_TEMPL_VW
|
| 15 |
CNT_RSZ_SUBM_BEL |
Character(1) |
VARCHAR2(1) NOT NULL |
RSZ-Submitted
Y/N Table Edit
Default Value: Y
|
| 16 |
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
|
| 17 |
RED_CHRG_CAT_BEL |
Character(6) |
VARCHAR2(6) NOT NULL |
Reduced Charges Category
Prompt Table:
REDUCT_TBL_BEL
|
| 18 |
REDCH_STARTDT_BEL |
Date(10) |
DATE |
Reduced Charges Start Date
|
| 19 |
REDCH_ENDDT_BEL |
Date(10) |
DATE |
Reduce Charge End Date
|
| 20 |
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
|
| 21 |
BEGIN_WEEKDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Begin/End Week
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
Default Value: 2
|
| 22 |
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
Default Value: 6
|
| 23 |
HIRE_CTR_CD_ESP |
Character(3) |
VARCHAR2(3) NOT NULL |
Hiring Center
Prompt Table:
HIRING_CTR_ESP
|
| 24 |
COMP_RATE_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Compensation Rate Description
|
| 25 |
PROBATION_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Probation Period
|
| 26 |
DURATION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Duration
D=Days
M=Months
Y=Years
Default Value: M
|
| 27 |
VACATION_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Vacation period
|
| 28 |
VACN_PERIOD_UNIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Vacation period unit
D=Work Days
M=Months
N=Natural Days
W=Weeks
Default Value: M
|
| 29 |
SCHEME_ID_ESP |
Character(4) |
VARCHAR2(4) NOT NULL |
Scheme ID - ESP
Prompt Table:
SCHEME_ESP_VW
|
| 30 |
CONTRIB_ID_ESP |
Character(5) |
VARCHAR2(5) NOT NULL |
Soc.Sec. Contribution ID - ESP
Prompt Table:
CONTRIB_ESP_VW
|
| 31 |
CONTRCT_EXP_END_DT |
Date(10) |
DATE |
Contract Expected End Date
|
| 32 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
Default Value: OPR_DEF_TBL_HR.SETID
|
| 33 |
NEE_PROVIDER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
The ID for the Non Employee Provider, Agency, or Employer.
Prompt Table:
NEE_PROVIDR_TBL
|
| 34 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 35 |
CONTRACT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Contract Type
|
| 36 |
EXTEND_CONTRACT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Extend Contract
|
| 37 |
COMMENTS |
Long Character |
CLOB |
Comment
|