Method GetEmpAccrualMasterTable

Summary

Get employee accrual master table information

Remarks

Excludes any rows where the employee unique key is less than zero

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

Excludes any rows where the “Final check printed” flag has been set to “F”

Excludes any rows where the employee job has no corresponding employee demographic information

Excludes any rows where the pay frequency has been excluded in the “Pay Frequency” area of the “Time and attendance filters” function in the NaviLine Payroll application

Excludes any rows where the department, division, and activity have been excluded in the “Department/Division/Activity” area of the “Time and attendance filters” function in the NaviLine Payroll application

Excludes any rows where the authorized department, division, and activity have been excluded in the “Department/Division/Activity” area of the “Time and attendance filters” function in the NaviLine Payroll application

Excludes any rows where the position has been excluded in the “Positions” area of the “Time and attendance filters” function in the NaviLine Payroll application

Excludes any rows where the authorized position has been excluded in the “Positions” area of the “Time and attendance filters” function in the NaviLine Payroll application

Excludes any rows where the employee job has been excluded in the “Employee Job” area of the “Time and attendance filters” function in the NaviLine Payroll application

Excludes any rows where the employee number is zero

Requires

Input Parameters

NameTypeLengthDescription
None No input parameters to pass

Example

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

Return Values

NameDescription
ErrorCode Error Code
ErrorDescription Error Description
EMPLOYEEUNIQUEKEY Employee unique key
ACCRUALTYPECODE Accrual type code
ACCRUALCODE Accrual code
ACCRUALBALANCEPREV Accrual balance previous
CURYEARACCRUALHOURS Current year accrual hours
UNUSEDBALANCE Unused balance
ACCRUALAVAILABLEDATE Accrual available date
ACCRUALSTARTDATE Accrual start date
MTDACCRUALHRSEARNED M-T-D accrual hours earned
MTDACCRUALHOURSUSED M-T-D accrual hours used
QTDACCRUALHRSEARNED Q-T-D accrual hours earned
QTDACCRUALHOURSUSED Q-T-D accrual hours used
YTDACCRUALHRSEARNED Y-T-D accrual hours earned
YTDACCRUALHOURSUSED Y-T-D accrual hours used
FTDACCRUALHRSEARNED F-T-D accrual hours earned
FTDACCRUALHOURSUSED F-T-D accrual hours used
LTDACCRUALHRSEARNED L-T-D accrual hours earned
LTDACCRUALHOURSUSED L-T-D accrual hours used
FACTORTABLEHOURS Factor table hours
PERIODRNGOFSVCHOURS Period range of service hours
ACCRUALINACTIVEFLAG Accrual inactive flag
ACCRUALLEVELDATE Accrual level date
LASTROLLDATE Last roll date
LASTACCRUEDATE Last accrue date
PENDINGACCRUAL Pending accrual
MONETARYVALUE Monetary value

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/EmpAccrualMasterTable";
    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 EMPLOYEEUNIQUEKEY = row["EMPLOYEEUNIQUEKEY"].ToString();
             string ACCRUALTYPECODE = row["ACCRUALTYPECODE"].ToString();
             string ACCRUALCODE = row["ACCRUALCODE"].ToString();
             string ACCRUALBALANCEPREV = row["ACCRUALBALANCEPREV"].ToString();
             string CURYEARACCRUALHOURS = row["CURYEARACCRUALHOURS"].ToString();
             string UNUSEDBALANCE = row["UNUSEDBALANCE"].ToString();
             string ACCRUALAVAILABLEDATE = row["ACCRUALAVAILABLEDATE"].ToString();
             string ACCRUALSTARTDATE = row["ACCRUALSTARTDATE"].ToString();
             string MTDACCRUALHRSEARNED = row["MTDACCRUALHRSEARNED"].ToString();
             string MTDACCRUALHOURSUSED = row["MTDACCRUALHOURSUSED"].ToString();
             string QTDACCRUALHRSEARNED = row["QTDACCRUALHRSEARNED"].ToString();
             string QTDACCRUALHOURSUSED = row["QTDACCRUALHOURSUSED"].ToString();
             string YTDACCRUALHRSEARNED = row["YTDACCRUALHRSEARNED"].ToString();
             string YTDACCRUALHOURSUSED = row["YTDACCRUALHOURSUSED"].ToString();
             string FTDACCRUALHRSEARNED = row["FTDACCRUALHRSEARNED"].ToString();
             string FTDACCRUALHOURSUSED = row["FTDACCRUALHOURSUSED"].ToString();
             string LTDACCRUALHRSEARNED = row["LTDACCRUALHRSEARNED"].ToString();
             string LTDACCRUALHOURSUSED = row["LTDACCRUALHOURSUSED"].ToString();
             string FACTORTABLEHOURS = row["FACTORTABLEHOURS"].ToString();
             string PERIODRNGOFSVCHOURS = row["PERIODRNGOFSVCHOURS"].ToString();
             string ACCRUALINACTIVEFLAG = row["ACCRUALINACTIVEFLAG"].ToString();
             string ACCRUALLEVELDATE = row["ACCRUALLEVELDATE"].ToString();
             string LASTROLLDATE = row["LASTROLLDATE"].ToString();
             string LASTACCRUEDATE = row["LASTACCRUEDATE"].ToString();
             string PENDINGACCRUAL = row["PENDINGACCRUAL"].ToString();
             string MONETARYVALUE = row["MONETARYVALUE"].ToString();
             // TODO - YOUR CODE HERE
        }
    }
}

$.get('http://localhost/FusionServices/v3/Naviline/Payroll/EmpAccrualMasterTable', 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 GetEmpAccrualMasterTable
   {
       // Add property for each input param in order to map a field to it
       public GetEmpAccrualMasterTable()
       {
           //Set any defaults here
       }
   }
}
@* NOTE: Use Add->View to add the View. *@
@* NOTE: Check the 'Create strongly-typed view checkbox, and select the GetEmpAccrualMasterTable 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.GetEmpAccrualMasterTable

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

<h2>GetEmpAccrualMasterTable</h2>
@using (Html.BeginForm()) {
   @Html.AntiForgeryToken()
   @Html.ValidationSummary(true)
   <fieldset>
   <legend>GetEmpAccrualMasterTable</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/GetEmpAccrualMasterTable
public ActionResult GetEmpAccrualMasterTable()
{
   // Create a new instance of the model to pick up any default values.
   GetEmpAccrualMasterTable model =  new GetEmpAccrualMasterTable();

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

// 
// POST: /MyController/GetEmpAccrualMasterTable
[HttpPost]
public ActionResult GetEmpAccrualMasterTable(FormCollection collection)
{
   string url = "v3/Naviline/Payroll/EmpAccrualMasterTable";
   // 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", "GetEmpAccrualMasterTable");
       return View("Error", info);
   }
}