Eclipse BIRT Designer Version 2.3.2.v20090331-1440 Build <2.3.2.v20090331-1200>
in
/templates/blank_report.gif
ltr
com.mysql.jdbc.Driver
jdbc:mysql://apricothr.co.uk:3306/apricoth_hr
apricoth_admin
bfff50101d647cfbae3e4ade1f55c1f2
emp_number
emp_number
employee_id
employee_id
emp_lastname
emp_lastname
emp_firstname
emp_firstname
emp_middle_name
emp_middle_name
emp_nick_name
emp_nick_name
emp_smoker
emp_smoker
emp_workingtime
emp_workingtime
emp_registered
emp_registered
ethnic_race_code
ethnic_race_code
emp_birthday
emp_birthday
nation_code
nation_code
emp_gender
emp_gender
emp_marital_status
emp_marital_status
emp_ssn_num
emp_ssn_num
emp_sin_num
emp_sin_num
emp_other_id
emp_other_id
emp_dri_lice_num
emp_dri_lice_num
emp_dri_lice_exp_date
emp_dri_lice_exp_date
emp_military_service
emp_military_service
emp_status
emp_status
job_title_code
job_title_code
eeo_cat_code
eeo_cat_code
work_station
work_station
emp_street1
emp_street1
emp_street2
emp_street2
city_code
city_code
coun_code
coun_code
provin_code
provin_code
emp_zipcode
emp_zipcode
emp_hm_telephone
emp_hm_telephone
emp_mobile
emp_mobile
emp_work_telephone
emp_work_telephone
emp_work_email
emp_work_email
sal_grd_code
sal_grd_code
joined_date
joined_date
emp_oth_email
emp_oth_email
terminated_date
terminated_date
termination_reason
termination_reason
custom1
custom1
custom2
custom2
custom3
custom3
custom4
custom4
custom5
custom5
custom6
custom6
custom7
custom7
custom8
custom8
custom9
custom9
custom10
custom10
1
emp_number
integer
2
employee_id
string
3
emp_lastname
string
4
emp_firstname
string
5
emp_middle_name
string
6
emp_nick_name
string
7
emp_smoker
integer
8
emp_workingtime
integer
9
emp_registered
integer
10
ethnic_race_code
string
11
emp_birthday
date
12
nation_code
string
13
emp_gender
integer
14
emp_marital_status
string
15
emp_ssn_num
string
16
emp_sin_num
string
17
emp_other_id
string
18
emp_dri_lice_num
string
19
emp_dri_lice_exp_date
date
20
emp_military_service
string
21
emp_status
string
22
job_title_code
string
23
eeo_cat_code
string
24
work_station
integer
25
emp_street1
string
26
emp_street2
string
27
city_code
string
28
coun_code
string
29
provin_code
string
30
emp_zipcode
string
31
emp_hm_telephone
string
32
emp_mobile
string
33
emp_work_telephone
string
34
emp_work_email
string
35
sal_grd_code
string
36
joined_date
date
37
emp_oth_email
string
38
terminated_date
date
39
termination_reason
string
40
custom1
string
41
custom2
string
42
custom3
string
43
custom4
string
44
custom5
string
45
custom6
string
46
custom7
string
47
custom8
string
48
custom9
string
49
custom10
string
Data Source
1
emp_number
emp_number
integer
4
2
employee_id
employee_id
string
12
3
emp_lastname
emp_lastname
string
12
4
emp_firstname
emp_firstname
string
12
5
emp_middle_name
emp_middle_name
string
12
6
emp_nick_name
emp_nick_name
string
12
7
emp_smoker
emp_smoker
integer
5
8
emp_workingtime
emp_workingtime
integer
5
9
emp_registered
emp_registered
integer
5
10
ethnic_race_code
ethnic_race_code
string
12
11
emp_birthday
emp_birthday
date
91
12
nation_code
nation_code
string
12
13
emp_gender
emp_gender
integer
5
14
emp_marital_status
emp_marital_status
string
12
15
emp_ssn_num
emp_ssn_num
string
12
16
emp_sin_num
emp_sin_num
string
12
17
emp_other_id
emp_other_id
string
12
18
emp_dri_lice_num
emp_dri_lice_num
string
12
19
emp_dri_lice_exp_date
emp_dri_lice_exp_date
date
91
20
emp_military_service
emp_military_service
string
12
21
emp_status
emp_status
string
12
22
job_title_code
job_title_code
string
12
23
eeo_cat_code
eeo_cat_code
string
12
24
work_station
work_station
integer
4
25
emp_street1
emp_street1
string
12
26
emp_street2
emp_street2
string
12
27
city_code
city_code
string
12
28
coun_code
coun_code
string
12
29
provin_code
provin_code
string
12
30
emp_zipcode
emp_zipcode
string
12
31
emp_hm_telephone
emp_hm_telephone
string
12
32
emp_mobile
emp_mobile
string
12
33
emp_work_telephone
emp_work_telephone
string
12
34
emp_work_email
emp_work_email
string
12
35
sal_grd_code
sal_grd_code
string
12
36
joined_date
joined_date
date
91
37
emp_oth_email
emp_oth_email
string
12
38
terminated_date
terminated_date
date
91
39
termination_reason
termination_reason
string
12
40
custom1
custom1
string
12
41
custom2
custom2
string
12
42
custom3
custom3
string
12
43
custom4
custom4
string
12
44
custom5
custom5
string
12
45
custom6
custom6
string
12
46
custom7
custom7
string
12
47
custom8
custom8
string
12
48
custom9
custom9
string
12
49
custom10
custom10
string
12
select *
from hs_hr_employee order by emp_number;
1.0
emp_number
1
4
7
0
NotNullable
emp_number
emp_number
7
employee_id
2
12
50
0
Nullable
employee_id
employee_id
50
emp_lastname
3
12
100
0
NotNullable
emp_lastname
emp_lastname
100
emp_firstname
4
12
100
0
NotNullable
emp_firstname
emp_firstname
100
emp_middle_name
5
12
100
0
NotNullable
emp_middle_name
emp_middle_name
100
emp_nick_name
6
12
100
0
Nullable
emp_nick_name
emp_nick_name
100
emp_smoker
7
5
6
0
Nullable
emp_smoker
emp_smoker
6
emp_workingtime
8
5
6
0
Nullable
emp_workingtime
emp_workingtime
6
emp_registered
9
5
6
0
Nullable
emp_registered
emp_registered
6
ethnic_race_code
10
12
13
0
Nullable
ethnic_race_code
ethnic_race_code
13
emp_birthday
11
91
10
0
Nullable
emp_birthday
emp_birthday
10
nation_code
12
12
13
0
Nullable
nation_code
nation_code
13
emp_gender
13
5
6
0
Nullable
emp_gender
emp_gender
6
emp_marital_status
14
12
20
0
Nullable
emp_marital_status
emp_marital_status
20
emp_ssn_num
15
12
100
0
Nullable
emp_ssn_num
emp_ssn_num
100
emp_sin_num
16
12
100
0
Nullable
emp_sin_num
emp_sin_num
100
emp_other_id
17
12
100
0
Nullable
emp_other_id
emp_other_id
100
emp_dri_lice_num
18
12
100
0
Nullable
emp_dri_lice_num
emp_dri_lice_num
100
emp_dri_lice_exp_date
19
91
10
0
Nullable
emp_dri_lice_exp_date
emp_dri_lice_exp_date
10
emp_military_service
20
12
100
0
Nullable
emp_military_service
emp_military_service
100
emp_status
21
12
13
0
Nullable
emp_status
emp_status
13
job_title_code
22
12
13
0
Nullable
job_title_code
job_title_code
13
eeo_cat_code
23
12
13
0
Nullable
eeo_cat_code
eeo_cat_code
13
work_station
24
4
6
0
Nullable
work_station
work_station
6
emp_street1
25
12
100
0
Nullable
emp_street1
emp_street1
100
emp_street2
26
12
100
0
Nullable
emp_street2
emp_street2
100
city_code
27
12
100
0
Nullable
city_code
city_code
100
coun_code
28
12
100
0
Nullable
coun_code
coun_code
100
provin_code
29
12
100
0
Nullable
provin_code
provin_code
100
emp_zipcode
30
12
20
0
Nullable
emp_zipcode
emp_zipcode
20
emp_hm_telephone
31
12
50
0
Nullable
emp_hm_telephone
emp_hm_telephone
50
emp_mobile
32
12
50
0
Nullable
emp_mobile
emp_mobile
50
emp_work_telephone
33
12
50
0
Nullable
emp_work_telephone
emp_work_telephone
50
emp_work_email
34
12
50
0
Nullable
emp_work_email
emp_work_email
50
sal_grd_code
35
12
13
0
Nullable
sal_grd_code
sal_grd_code
13
joined_date
36
91
10
0
Nullable
joined_date
joined_date
10
emp_oth_email
37
12
50
0
Nullable
emp_oth_email
emp_oth_email
50
terminated_date
38
91
10
0
Nullable
terminated_date
terminated_date
10
termination_reason
39
12
256
0
Nullable
termination_reason
termination_reason
256
custom1
40
12
250
0
Nullable
custom1
custom1
250
custom2
41
12
250
0
Nullable
custom2
custom2
250
custom3
42
12
250
0
Nullable
custom3
custom3
250
custom4
43
12
250
0
Nullable
custom4
custom4
250
custom5
44
12
250
0
Nullable
custom5
custom5
250
custom6
45
12
250
0
Nullable
custom6
custom6
250
custom7
46
12
250
0
Nullable
custom7
custom7
250
custom8
47
12
250
0
Nullable
custom8
custom8
250
custom9
48
12
250
0
Nullable
custom9
custom9
250
custom10
49
12
250
0
Nullable
custom10
custom10
250
]]>
attendance_id
attendance_id
employee_id
employee_id
punchin_time
punchin_time
punchout_time
punchout_time
in_note
in_note
out_note
out_note
timestamp_diff
timestamp_diff
status
status
1
attendance_id
integer
2
employee_id
integer
3
punchin_time
date-time
4
punchout_time
date-time
5
in_note
string
6
out_note
string
7
timestamp_diff
integer
8
status
string
Data Source
1
attendance_id
attendance_id
integer
4
2
employee_id
employee_id
integer
4
3
punchin_time
punchin_time
date-time
93
4
punchout_time
punchout_time
date-time
93
5
in_note
in_note
string
12
6
out_note
out_note
string
12
7
timestamp_diff
timestamp_diff
integer
4
8
status
status
string
12
select hs_hr_attendance.attendance_id,
hs_hr_attendance.employee_id,
hs_hr_attendance.punchin_time,
hs_hr_attendance.punchout_time,
hs_hr_attendance.in_note,
hs_hr_attendance.out_note,
hs_hr_attendance.timestamp_diff,
hs_hr_attendance.status
from hs_hr_attendance
1.0
attendance_id
1
4
11
0
NotNullable
attendance_id
attendance_id
11
employee_id
2
4
11
0
NotNullable
employee_id
employee_id
11
punchin_time
3
93
19
0
Nullable
punchin_time
punchin_time
19
punchout_time
4
93
19
0
Nullable
punchout_time
punchout_time
19
in_note
5
12
250
0
Nullable
in_note
in_note
250
out_note
6
12
250
0
Nullable
out_note
out_note
250
timestamp_diff
7
4
11
0
NotNullable
timestamp_diff
timestamp_diff
11
status
8
12
1
0
Nullable
status
status
1
]]>
0.25in
0.25in
0.25in
0.25in
html
new Date()]]>
Data Set1
attendance_id
dataSetRow["attendance_id"]
integer
employee_id
dataSetRow["employee_id"]
integer
punchin_time
dataSetRow["punchin_time"]
date-time
punchout_time
dataSetRow["punchout_time"]
date-time
in_note
dataSetRow["in_note"]
string
out_note
dataSetRow["out_note"]
string
timestamp_diff
dataSetRow["timestamp_diff"]
integer
status
dataSetRow["status"]
string
Data Set1
attendance_id
dataSetRow["attendance_id"]
integer
employee_id
dataSetRow["employee_id"]
integer
punchin_time
dataSetRow["punchin_time"]
date-time
punchout_time
dataSetRow["punchout_time"]
date-time
in_note
dataSetRow["in_note"]
string
out_note
dataSetRow["out_note"]
string
timestamp_diff
dataSetRow["timestamp_diff"]
integer
status
dataSetRow["status"]
string
attendance_id