CNT_RSZ_TBL_BEL

(SQL Table)
Index Back

Contract Type-RSZ Category

This record is used for the Belgium Employment Terms

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: BEL

2 CONTRACT_TYPE Character(3) VARCHAR2(3) NOT NULL Contract Type

Prompt Table: PERS_CNTRCT_TYP

3 STATUTE_BEL Character(2) VARCHAR2(2) NOT NULL Statute

Prompt Table: STATUTE_TBL_BEL

4 SUBSTATUTE_BEL Character(2) VARCHAR2(2) NOT NULL Substatute
00=Not Applicable
01=Regular Employee
02=Sales Representative
03=Executive

Prompt Table: SUBSTAT_TBL_BEL

5 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

6 CNT_RSZ_SUBM_BEL Character(1) VARCHAR2(1) NOT NULL RSZ-Submitted

Y/N Table Edit

Default Value: Y

7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

8 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