Search results for query: *

Hi, I'm using oracle (hosted) and need to turn Date_C and Date_D from the EMPLOYMENT_TBL into one column. It is possible that an employee has a date in each field, which I would then need that employee to have two lines. I also need to be able to have a field that can then tell me if that...

Hi, I hope you had a great weekend! I am creating letters using forms. I'm creating the body of the letter in a derived field as I am using text and fields from other tables. So for example the body derived field may state: 'Based on your rehire date of ' || "PS_EMPLOYMENT"."REHIRE_DT" ||...

I am trying to create a derived field that looks like this: DECODE(SUBSTR("PS_EMPLOYMENT"."CUSTOM_AREA1",1,4), LIKE '1%%%', 'FEDERAL', LIKE '2%%%', 'STATE', 'UNKNOWN') However, it does not like my statement. I know I can do it the long way: DECODE(SUBSTR("PS_EMPLOYMENT"."CUSTOM_AREA1",1,4)...

I need to create a derived field that if PERSONAL_DATA.SSN <> AUDIT_PERSONAL.SSN that it will list the AUDIT_PERSONAL.SSN. If it is not applicable (meaning that the 2 SSN's match) then I need it to be a space (' ') so that is is blank. What I don't know is what function to use with this...

I am trying to create a report where you select a check date and earning code and it will compare that information to the last check date and if that earning code is not there it will list that employee on the report. We thought of doing this with a derived field. We created the following...

I created the following macro: Sub Percent () X=VAL((Field$("OVERTIME_HOURS")) / VAL(FIELD$("AL_HOURS")) DerivedField Str$(X) End Sub "OVERTIME_HOURS" is a derived field "AL_HOURS" is a column from the AL_CHK_HRS_ERN table. When I test the macro it states it is compiled successfully. When I go...

Hi, I am trying to create a report that uses AL_CHK_DATA (for the TEMP_DEPTID and AL_CHK_HRS_ERN (to pull the earnings that go with the TEMP_DEPTID). I can have up to 9 TEMP_DEPTID's and neeed to find a way to include all of them in one report, one line for each TEMP_DEPTID. In looking at the...

I have created the following macro: Sub udr5() If (Field$("CombineYear")) = "Under 15" Then X = (Field$("AccumNYTDinOne")) End if DerivedField str$(X) End Sub Is there a way that within the above macro I can add a line to say something like X = (Field$("AccumNYTDinOne"))*.04 (but of course...

Hi, I am trying to create the following derived field: SUM(DISTINCT CASE "PS_AL_CHK_HRS_ERN"."ROW_NBR" WHEN '1' THEN "PS_AL_CHK_HRS_ERN"."AL_HOURS" ELSE 0 END) but it keeps giving me the error message "ORA-00932: inconsistent datatypes: expected NUMBER got CHAR" It is an Oracle database. Thanks!

I have created a form report and need to pull in the last 5 history rows from the JOB table. Since a form report only shows one row of data I added the JOB table into the report 5 times, one for each history row. I have the Reports Effective Date set to None. I am trying to translate the Reason...

In the report I am creating I need to pull the check date and what the month-to-date(MTD) deduction would be within the month that the check date is in. I am not sure if I am going the “easy” way about this, but I can’t think of another way, so I am open to all suggestions. The If/Then...

I am trying to create a report that basically shows the break down of an employee's earnings. What we would like is to see one line per employee per check date. So we would like all of the earnings, taxes and deductions to appear on one line. We are using Oracle and we feel that we are...

I am creating a report that uses the following tables: PS_Job, PS_Personal_Data, PS_Employee_Review, PS_Jobcode_tbl and the Xlattable table (translating the review rating from the employee_review table). When I finish creating the reports I have over 2200 records. When I close out of the...

I have created a derived field in which I am adding/subtracting 6 different fields. Then in another derived field I need to take the results from the first derived field and multiply the result by the employee's hourly rate. When I try to create this I am getting an error message "ORA-00037...