قاموس البيانات Data Dictionary

قاموس البيانات Data Dictionary

Data Dictionary: نظام رواتب الموظفين

Name of file: assasy_ tb جدول البيانات الأساسية للموظف

No	Name of field		Width	Type	comments
1.		Emp_no	4	Number (long)
2.		First_name	255	Text
3.		Father	255	Text
4.		Grand	255	Text
5.		Family	255	text
6.		Last_grade	8	Date/ time
7.		Appoint_type	30	Text
8.		Job_name	255	Text
9.		Dept_name	255	Text
10.		Section_name	255	Text
11.		Hier_date	8	Date/time
12.		Al_malak	255	Text
13.		No_of_years	8	Double
14.		Relegon	20	Text
15.		Home_address	220	Text
16.		Birth_date	8	Date/ time
17.		Birth_place	120	Text
18.		Bank_name	190	Text
19.		Account_no	100	Text
20.		Has_insurance	30	Text
21.		Moal_no	8	Double
22.		University_no	8	Double
23.		Badal_ejar	8	double
24.		Salary_type	40	Text
25.		Sex	20	Text
26.		Insur_no	8	Double
27.		Material_status	20	Text
28.		Child_no	8	double
29.		Job_place	220	Text
30.		Id_no	9	text
31.		Fixed_date	8	Date/time
32.		No_of_wifes	8	Double
33.		Fixed_no	3	number
34.		Job_alawa	8	Double
35.		Culture_alawa	8	Double
36.		Fixed_al	8	Double
37.		Part_pay	8	Double
38.		In_trans	8	Double
39.		Out_trans	8	Double
40.		Host	8	Double
41.		Travel	8	Double
42.		Badal_serafa	8	Double
43.		Final_salary	8	Double
44.		Grade_code	255	Text
45.		Next_grade	8	Date/time
46.		Taeen_date	8	Date/time

Name of file: bank_tb ويستخدم لإدخال أسماء البنوك الرئيسية التي تتعامل معها البلدية

No	Name of field	Width	Type	comments
1	Bank_no	2	Number (integer)
2	Bank_ name	50	text

Name of file: department_tb ويستخدم لإدخال أسماء الدوائر الرئيسية في  البلدية

No	Name of field	Width	Type	comments
1	Dept_no	2	Number (integer)
2	dept_ name	50	text

Name of file: grade_tb ويستخدم لإدخال رموز الدرجات للموظفين 

No	Name of field	Width	Type	Comments
1	Grade_code	10	text
2	Grade _amount	8	Currency
3	No_of_days	8	double

Name of file: fixedamt_tb ويستخدم لإدخال العلاوات الشهرية الثابتة

No	Name of field	Width	Type	Comments
1	Special_alawa	2	Double
2	Wife_alawa	50	Double
3	Child_alawa	8	Double
4	Alawa125	8	Double
5	Khasm10	8	Double
6	Insurance_khasm	8	Double
7	For_month	8	Date/ time

Name of file: tax_alawa_tb ويستخدم لإدخال بنود الاعفاء الضريبي

No	Name of field	Width	Type	Comments
1	For_month	8	Date/ time
2	Single_alawa	8	Double
3	Married_alawa	8	Double
4	Child_alawa	8	Double
5	Less_ejar_rate	8	Double
6	More_ejar_rate	8	Double
7	Jamey_alawa	8	Date/ time
8	Moal_alawa	8	Double
9	Maximum_alawa	8	Double
10	Salary_deduct	8	curency

Name of file: tax_rate ويستخدم لإدخال نسب شرائح ضريبة الدخل

No	Name of field	Width	Type	comments
1	Rate1	8	Double
2	Rate2	8	Double
3	Rate3	8	Double
4	Rate4	8	Double
5	Amount 1	8	double
6	Amount 2	8	Double
7	Amount 3	8	Double
8	Amount 4	8	Double

Name of file: kard_tb ويستخدم لإدخال بيانات القروض لكل موظف

No	Name of field	Width	Type	comments
1	Emp_no	8	Double
2	Kard_amount	8	Double
3	No_of_kests	8	Double
4	First_date	8	Double
5	Kest_amount	8	Double
6	Kard_remain	8	Double
7	Kest_remain	8	Date/ time
8	End_date	8	Date/ time

Name of file: transaction_tb ويستخدم لإدخال الحركات الشهرية(اضافات خصميات)

No	Name of field	Width	Type	comments
1	Emp_no	4	long
2	Over_time	8	Double
3	Other_alawa	8	Double
4	Khasm_solfa	8	Double
5	Khasm_jamea	8	Double
6	Absent_days	8	Double
7	Badal_serafa	8	double
8	Other_khasm	8	Double
9	Salary_remain	8	currency

Name of file: holidays_tb ويستخدم لإدخال بيانات اجازات

No	Name of field	Width	Type	comments
1	Emp_no	4	Long
2	From_date	8	Date/ time
3	To_date	8	Date/ time
4	H_of_year	10	Text
5	Ord_holy	8	double
6	Sik_holy	8	Double
7	Moth_holy	8	Double
8	Haj_holy	8	Double
9	Study_holy	8	Double
10	Other_holy	8	Double
11	Place	30	Text
12	Address	30	Text
13	remarks	50	Text

Name of file: Calc_tb ويستخدم لإدخال بيانات الاحتساب لكل الموظفين

No	Name of field	Width	Type	comments
1	Emp_no	2	Double
2	Calc_date	50	Double
3	Wife_alawa		Double
4	Job_alawa		Double
5	Culture_alawa		Double
6	Badal_serafa		Double
7	In_trans		Date/ time
8	Out_trans		Double
9	Travel		double
10	Final_salary		Currency
11	Host		double
12	Other_alawa		double
13	Fixed_al		double
14	Total_salary		Currency
15	Over_time		double
16	Khasm_solfa		double
17	Other_khasm		double
18	Khasm_jamea		double
19	Absent_days		double
20	Net_salary		Currency
21	Ins_khasm		double
22	Staff_khasm		double
23	Khasm 125		double
24	Child_alawa		double
25	Tax_amt		double
26	Part_pay		double
27	Khasm_kard		double
28	Ejtodareba		double
29	Tafkeet		Text
30	Dept_name		Text
31	Ejmalkhasm		double
32	Name		Text
33	Bank_name		Text
34	Salary_remain		Currency
35	Account_no		Text