Method GetAccrualCodeTable

Summary

Get accrual code table information

Remarks

Retrieves accrual code table

Excludes any rows where accrual type code has been excluded in the “Accruals” area of the “Time and attendance filters” function in the NaviLine Payroll application

Requires

Input Parameters

NameTypeLengthDescription
None No input parameters to pass

Example

GET http://localhost/FusionServices/v3/Naviline/Payroll/AccrualCodeTable

Return Values

NameDescription
ErrorCode Error Code
ErrorDescription Error Description
ACCRUALTYPECODE Accrual type code
ACCRUALCODE Accrual code
ACCRUALCODEDESC Accrual code description
ACCRUALFIXEDAMOUNT Accrual fixed amount (numeric)
MAXHOURSACCRUABLE Maximum hours accruable (numeric)
MAXHOURSACCRUABLEATROLLOVER Maximum hours accruable at rollover (numeric)
MAXHOURSTOBEROLLED Maximum hours to be rolled (numeric)
OVERMAXIMUMACCRUALCODE Over maximum accrual code
MINIMUMHOURSACCRUABLE Minimum hours accruable (numeric)
UNDERMINIMUMACCRUALCODE Under minimum accrual code
RANGEOFSERVICELOWERLIMIT Range of service lower limit (numeric)
RANGEOFSERVICEUPPERLIMIT Range of service upper limit (numeric)
ACCRUALCYCLE Accrual cycle
TABLEFACTORED Table factored
ACCRUALFACTOR Accrual factor (numeric)
MAXFACTORHOURSPERCYCLE Maximum factor hours per cycle (numeric)
ACCRUALLIABILITYPERCENT Accrual liability percentage (numeric)

Error Details

Error CodeError Message
00000 Success
00001 Error = Invalid environment parameters
Other SQL state for SQL error

Sample Responses

Sample Code

using System.Net;
using Newtonsoft.Json.Linq;

public void MethodName(parms)
{
    string uri = "http://localhost/FusionServices/v3/Naviline/Payroll/AccrualCodeTable";
    WebClient wc = new WebClient();
    wc.Headers.Set("X-APPID", "YOURID");
    wc.Headers.Set("X-APPKEY", "YOURKEY");
    string stringResult = wc.DownloadString(new Uri(uri));
    
    JObject response = JObject.Parse(stringResult);
    string error = response["OutputParms"]["ErrorCode"].ToString();
    if (error == "0000")
    {
        JArray jRows = (JArray)response["Rows"];
        foreach (JObject row in jRows)
        {
             string ACCRUALTYPECODE = row["ACCRUALTYPECODE"].ToString();
             string ACCRUALCODE = row["ACCRUALCODE"].ToString();
             string ACCRUALCODEDESC = row["ACCRUALCODEDESC"].ToString();
             string ACCRUALFIXEDAMOUNT = row["ACCRUALFIXEDAMOUNT"].ToString();
             string MAXHOURSACCRUABLE = row["MAXHOURSACCRUABLE"].ToString();
             string MAXHOURSACCRUABLEATROLLOVER = row["MAXHOURSACCRUABLEATROLLOVER"].ToString();
             string MAXHOURSTOBEROLLED = row["MAXHOURSTOBEROLLED"].ToString();
             string OVERMAXIMUMACCRUALCODE = row["OVERMAXIMUMACCRUALCODE"].ToString();
             string MINIMUMHOURSACCRUABLE = row["MINIMUMHOURSACCRUABLE"].ToString();
             string UNDERMINIMUMACCRUALCODE = row["UNDERMINIMUMACCRUALCODE"].ToString();
             string RANGEOFSERVICELOWERLIMIT = row["RANGEOFSERVICELOWERLIMIT"].ToString();
             string RANGEOFSERVICEUPPERLIMIT = row["RANGEOFSERVICEUPPERLIMIT"].ToString();
             string ACCRUALCYCLE = row["ACCRUALCYCLE"].ToString();
             string TABLEFACTORED = row["TABLEFACTORED"].ToString();
             string ACCRUALFACTOR = row["ACCRUALFACTOR"].ToString();
             string MAXFACTORHOURSPERCYCLE = row["MAXFACTORHOURSPERCYCLE"].ToString();
             string ACCRUALLIABILITYPERCENT = row["ACCRUALLIABILITYPERCENT"].ToString();
             // TODO - YOUR CODE HERE
        }
    }
}

$.get('http://localhost/FusionServices/v3/Naviline/Payroll/AccrualCodeTable', function(response) {
    $('#resultDiv).html(response); 
 });

C# Razor MVC Sample Code

using System;
using System.Linq;
using System.Web;
using System.ComponentModel.DataAnnotations;
using System.Collections.Specialized;
using FusionServiceHelper.Models;

// NOTE: Use the namespace generated when you add the class, so that it is correct.
namespace FusionRazor.Models
{
   public class GetAccrualCodeTable
   {
       // Add property for each input param in order to map a field to it
       public GetAccrualCodeTable()
       {
           //Set any defaults here
       }
   }
}
@* NOTE: Use Add->View to add the View. *@
@* NOTE: Check the 'Create strongly-typed view checkbox, and select the GetAccrualCodeTable class. *@
@* NOTE: Select Edit as the Scaffold template. *@
@* NOTE: Use the @model line that is generated at the top.  Replace the rest with the lines below.
@model FusionRazor.Models.GetAccrualCodeTable

@{
   ViewBag.Title = "GetAccrualCodeTable";
   string myUrl = "http://localhost/FusionServices/v3/Naviline/Payroll/AccrualCodeTable";
}

<h2>GetAccrualCodeTable</h2>
@using (Html.BeginForm()) {
   @Html.AntiForgeryToken()
   @Html.ValidationSummary(true)
   <fieldset>
   <legend>GetAccrualCodeTable</legend>
       <div class="editor-label">Use the fields below to change the values and resubmit.</div>
       <p>
       <input type="submit" value="Submit"/>
       </p>
   </fieldset>

}

@section Scripts {
   @Scripts.Render("~/bundles/jqueryval")
}
using System;
using System.Collections.Specialized;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using FusionServiceHelper.Models;

// NOTE: Replace 'MyController' with the name of your controller.

// 
// GET: /MyController/GetAccrualCodeTable
public ActionResult GetAccrualCodeTable()
{
   // Create a new instance of the model to pick up any default values.
   GetAccrualCodeTable model =  new GetAccrualCodeTable();

   // pass model to set to default values
   // NOTE: Change 'MyFolderPath' to the path to the .cshtml file.
   return View("~/Views/MyFolderPath/GetAccrualCodeTable.cshtml", model);
}

// 
// POST: /MyController/GetAccrualCodeTable
[HttpPost]
public ActionResult GetAccrualCodeTable(FormCollection collection)
{
   string url = "v3/Naviline/Payroll/AccrualCodeTable";
   // Get the value from each input field
   NameValueCollection inputParms = new NameValueCollection();

   try
   {
       // Send the request
       FusionServiceRequest request = new FusionServiceRequest();
       FusionServiceResult result = request.Get(url, inputParms);

       return View("Result", result);
   }
   catch(Exception e)
   {
       HandleErrorInfo info = new HandleErrorInfo(e, "MyController", "GetAccrualCodeTable");
       return View("Error", info);
   }
}