CNT_RSZ_TBL_BEL(SQL Table) |
Index Back |
---|---|
Contract Type-RSZ CategoryThis 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 |