This report can be used to help audit a new client in the system. It will show what details are missing and give you hyperlinks to quickly modify the existing information.

Here is the user report type required to create this user report:

Here is the additional custom calc field information from the report defined above:

Seq #5 - '<a href="../Assignment/Assignment.aspx?EmployeeID=' + [EmployeeID] + '&AssignmentID=' + [AssignmentID] + '"Target="New">View/Edit</a>'

Seq #7 - iif([CWTemplateID] is NULL, '<a href="../../CompWorksheet/CompensationWorksheet/CompensationWorksheet_List.aspx?AssignmentID=' + [AssignmentID] + '"Target="New">Add New</a>', '<a href="../../CompWorksheet/CompensationWorksheet/AssignmentCWTemplate.aspx?AssignmentID=' + [AssignmentID] + '&CompWorksheetAssignmentTemplateID=' + [CWTemplateID] + '"Target="New">View/Edit</a>')

Seq #16 - iif([Base Pay Amount] > 0, [Base Pay Amount], '<a href="../AssignmentCompensation/AssignmentCompensation.aspx?AssignmentID=' + [AssignmentID] + '&AssignmentCompensationSalaryID=0' + '"Target="New">Add New</a>') + ' ' + iif([Base Pay Currency] is not null,[Base Pay Currency],'')

Seq #18 - iif([Home Family Size] is not null, [Home Family Size], '?') + '/' +iif([Host Family Size] is not null, [Host Family Size], '?')

Here is a sample result set. The hyperlinks will not run appropriately to PDF or EXCEL, so please run them in HTML. It would be easy to add other employee or assignment level information to a report like this.

This report can be used to quickly add one-time payments to an existing compensation worksheet, add notes to the worksheet or update individual line items. Utilizing a report like this should shorten the time required to create balance sheets and run payroll each month by limiting the number of clicks required to complete your task.

Here is the user report type required to create this user report:

Here are the details of the Custom Calc & SQL Fields from the report above:

Seq. #6 - ISNULL([Comp Worksheet: Exchange Rate Override],[Comp Worksheet: Exchange Rate])

Seq. #7 - ROUND([Comp Worksheet Line Item: (Home) Payperiod Pay Amount],2)

Seq. #8 - ROUND([Comp Worksheet Line Item: (Host) Payperiod Pay Amount],2)

Seq. #11 – '<a href="../../CompWorksheet/CompensationWorksheet/CompensationWorksheetLineItem.aspx?AssignmentID=' + [AssignmentID] + '&CompWorksheetID=' + [CWID] + '&CompWorksheetLineItemID=' + [CWLIID] + '"Target="New">View/Edit</a>'

Seq. #12 – '<a href="../../CompWorksheet/CompensationWorksheet/CompensationWorksheetLineItem.aspx?AssignmentID=' + [AssignmentID] + '&CompWorksheetID=' + [CWID] + '&CompWorksheetLineItemID=0"Target="New">New</a>'

Seq. #13 - '<a href="../../CompWorksheet/CompensationWorksheet/CompensationWorksheetDefinition.aspx?AssignmentID=' + [AssignmentID] + '&CompWorksheetID=' + [CWID] + '"Target="New">Edit Note</a>'

The report will prompt you for the begin date of the pay period (possibly a payroll system and company as well):

Here is a sample result set. The hyperlinks will not run appropriately to PDF or EXCEL, so please run them in HTML. It would be easy to add other employee, assignment or compensation worksheet information to a report like this.