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

Test

Data Set1

attendance_id