After modified TA_TRANS_DAILY.DAY <>12, the report got a little improve but correct data haven't emerged.  I believe that I should add one more condition at 'WHERE' clause. As you can see on the time card, 'Federal H.' corresponds 14 days, I'm thinking to add 'Leave start time' & 'end time' >0, but I haven't find the related fields in the tables so far.

 

The attachment is a part of report.

 

LASTNAME			PAY_PERIOD	LEAVE_YEAR		DESCRIPTION		DAY
t27			13	2009		Federal Holiday		0
t22			13	2009		Federal Holiday		0
t27			13	2009		Federal Holiday		1
t22			13	2009		Federal Holiday		1
t27			13	2009		Federal Holiday		2
t22			13	2009		Federal Holiday		2
t27			13	2009		Federal Holiday		3
t22			13	2009		Federal Holiday		3
t27			13	2009		Federal Holiday		4
t22			13	2009		Federal Holiday		4
t27			13	2009		Federal Holiday		5
t22			13	2009		Federal Holiday		5
t27			13	2009		Federal Holiday		6
t22			13	2009		Federal Holiday		6

...

 SELECT "TA_USER"."LASTNAME", "TA_MASTER"."PAY_PERIOD", "TA_MASTER"."LEAVE_YEAR", "TA_TRANS_DAILY"."DAY", "TA_TCODE_TIP"."DESCRIPTION"
 FROM   "BEPWEBTA"."TA_MASTER" "TA_MASTER" INNER JOIN (("BEPWEBTA"."TA_TRANS_DAILY" "TA_TRANS_DAILY" INNER JOIN "BEPWEBTA"."TA_USER" "TA_USER" ON "TA_TRANS_DAILY"."EMP_ID"="TA_USER"."EMP_ID") INNER JOIN "BEPWEBTA"."TA_TCODE_TIP" "TA_TCODE_TIP" ON "TA_TRANS_DAILY"."TC_ID"="TA_TCODE_TIP"."TC_ID") ON "TA_MASTER"."EMP_ID"="TA_USER"."EMP_ID"
 WHERE  "TA_MASTER"."PAY_PERIOD"='13' AND "TA_TCODE_TIP"."DESCRIPTION"='Federal Holiday' AND "TA_TRANS_DAILY"."DAY"<>'12' AND "TA_MASTER"."LEAVE_YEAR"='2009'