DEP_BENEF_BEL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default Default Value: 01
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	ORPHAN_BEL	Character(1)	VARCHAR2(1) NOT NULL	The field Orphan is used by Belgium to track the fiscal status of Dependents and Beneficiaries. Y/N Table Edit Default Value: N
5	FISCAL_DEPEND_BEL	Character(1)	VARCHAR2(1) NOT NULL	Fiscally Dependent is used by Belgium to track the fiscal status of Dependents and Beneficiaries. Y/N Table Edit Default Value: N
6	FISCAL_DISABL_BEL	Character(1)	VARCHAR2(1) NOT NULL	The field Fiscally Disabled is used by Belgium to track the fiscal status of Dependents and Beneficiaries. Y/N Table Edit Default Value: N
7	PROF_SPOUSE_BEL	Character(2)	VARCHAR2(2) NOT NULL	The field Profession Category Spouse is used by Belgium to track the fiscal status of Dependents and Beneficiaries. 1=Employee 2=Worker 3=Self-employed 4=Public Institution 5=Servant 6=Out of Work
8	FISCAL_SITUAT_BEL	Character(2)	VARCHAR2(2) NOT NULL	The field Fiscal Situation Spouse is used by Belgium to track the fiscal status of Dependents and Beneficiaries. 1=No Income 2=Income 3=Income below limit 4=Pension 5=Pension below limit
9	FAM_ALLOW_BEL	Character(1)	VARCHAR2(1) NOT NULL	This field is used for Belgian employees to track whether dependents are eligible for family allowance, like children entitled for child allowance. Y/N Table Edit Default Value: N