CONTRRSZ_BEL_VW (SQL View)	Index Back
Contract Type RSZ-link - BEL Actual Contract type RSZ-link - Belgium

CONTRRSZ_BEL_VW

(SQL View)

Contract Type RSZ-link - BEL

Actual Contract type RSZ-link - Belgium

SELECT a.contract_type ,a.statute_bel ,a.substatute_bel ,a.cnt_rsz_subm_bel ,a.cnt_rsz_cat_bel FROM PS_CNT_RSZ_TBL_BEL a WHERE a.eff_status ='A' AND a.effdt =( SELECT MAX(effdt) FROM PS_CNT_RSZ_TBL_BEL b WHERE b.contract_type = a.contract_type AND b.statute_bel = a.statute_bel AND b.substatute_bel = a.substatute_bel AND b.cnt_rsz_subm_bel = a.cnt_rsz_subm_bel AND b.effdt <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

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

5 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Contract Type
2	STATUTE_BEL	Character(2)	VARCHAR2(2) NOT NULL	Statute
3	SUBSTATUTE_BEL	Character(2)	VARCHAR2(2) NOT NULL	Substatute 00=Not Applicable 01=Regular Employee 02=Sales Representative 03=Executive
4	CNT_RSZ_SUBM_BEL	Character(1)	VARCHAR2(1) NOT NULL	RSZ-Submitted
5	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