قاموس
البيانات 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
|
|
إرسال تعليق