Get the accrual type code table information
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
Name | Type | Length | Description |
---|---|---|---|
None | No input parameters to pass |
GET http://localhost/FusionServices/v3/Naviline/Payroll/AccrualTypeCodeTable
Name | Description |
---|---|
ErrorCode | Error Code |
ErrorDescription | Error Description |
ACCRUALTYPECODE | Accrual type code |
ACCRUALTYPEDESC | Accrual type description |
POOLACCRUALFLAG | Pool accrual balance flag Values: N=No, Y=Yes |
NEGATIVEACCRUALFLAG | Negative accrual flag Values: N= No, Y=Yes |
ALLOWACCRUALOVERMAX | Allow accrual over maximum Values: N=No, Y=Yes |
RANGEOFSERVICETYPE | Range of service type Values: BLANK=Not used, H=Hours, M=Months, Y=Years |
RANGEOFSVCDATETYPE | Range of service date type Values: BLANK=Not used, H=Hire, T=Total service |
SPENDPREVBALANCEONLY | Spend previous balance only Values: N=No, Y=Yes |
EXCLUDEFROMTIMESHTS | Exclude from time sheets Values: N= No, Y=Yes |
ACCRUALROLLOVERFLAG | Roll balances Values: BLANK=Keep all, A=Annual, F=Fiscal, H=Hire, T=Total service |
UPACCRUALSTEPFLAG | Up step before accruals Values: N=No, Y=Yes |
AUTOINACTIVEFLAGLOA | Auto inactive during leave of absence Values: N=No, Y=Yes |
ACCRUALLIABILITY | Accrual liability |
ACCRLIABILITYCYCLE | Accrual liability cycle Values: Blank= , A=Annual, P=Pay period, M=Monthly Q=Quarterly, F=Fiscal |
DATESENSITIVEFLAG | Date sensitive flag |
Error Code | Error Message |
---|---|
00000 | Success |
00001 | Error = Invalid environment parameters |
Other | SQL state for SQL error |
using System.Net;
using Newtonsoft.Json.Linq;
public void MethodName(parms)
{
string uri = "http://localhost/FusionServices/v3/Naviline/Payroll/AccrualTypeCodeTable";
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 ACCRUALTYPEDESC = row["ACCRUALTYPEDESC"].ToString();
string POOLACCRUALFLAG = row["POOLACCRUALFLAG"].ToString();
string NEGATIVEACCRUALFLAG = row["NEGATIVEACCRUALFLAG"].ToString();
string ALLOWACCRUALOVERMAX = row["ALLOWACCRUALOVERMAX"].ToString();
string RANGEOFSERVICETYPE = row["RANGEOFSERVICETYPE"].ToString();
string RANGEOFSVCDATETYPE = row["RANGEOFSVCDATETYPE"].ToString();
string SPENDPREVBALANCEONLY = row["SPENDPREVBALANCEONLY"].ToString();
string EXCLUDEFROMTIMESHTS = row["EXCLUDEFROMTIMESHTS"].ToString();
string ACCRUALROLLOVERFLAG = row["ACCRUALROLLOVERFLAG"].ToString();
string UPACCRUALSTEPFLAG = row["UPACCRUALSTEPFLAG"].ToString();
string AUTOINACTIVEFLAGLOA = row["AUTOINACTIVEFLAGLOA"].ToString();
string ACCRUALLIABILITY = row["ACCRUALLIABILITY"].ToString();
string ACCRLIABILITYCYCLE = row["ACCRLIABILITYCYCLE"].ToString();
string DATESENSITIVEFLAG = row["DATESENSITIVEFLAG"].ToString();
// TODO - YOUR CODE HERE
}
}
}
$.get('http://localhost/FusionServices/v3/Naviline/Payroll/AccrualTypeCodeTable', function(response) {
$('#resultDiv).html(response);
});
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 GetAccrualTypeCodeTable
{
// Add property for each input param in order to map a field to it
public GetAccrualTypeCodeTable()
{
//Set any defaults here
}
}
}
@* NOTE: Use Add->View to add the View. *@
@* NOTE: Check the 'Create strongly-typed view checkbox, and select the GetAccrualTypeCodeTable 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.GetAccrualTypeCodeTable
@{
ViewBag.Title = "GetAccrualTypeCodeTable";
string myUrl = "http://localhost/FusionServices/v3/Naviline/Payroll/AccrualTypeCodeTable";
}
<h2>GetAccrualTypeCodeTable</h2>
@using (Html.BeginForm()) {
@Html.AntiForgeryToken()
@Html.ValidationSummary(true)
<fieldset>
<legend>GetAccrualTypeCodeTable</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/GetAccrualTypeCodeTable
public ActionResult GetAccrualTypeCodeTable()
{
// Create a new instance of the model to pick up any default values.
GetAccrualTypeCodeTable model = new GetAccrualTypeCodeTable();
// pass model to set to default values
// NOTE: Change 'MyFolderPath' to the path to the .cshtml file.
return View("~/Views/MyFolderPath/GetAccrualTypeCodeTable.cshtml", model);
}
//
// POST: /MyController/GetAccrualTypeCodeTable
[HttpPost]
public ActionResult GetAccrualTypeCodeTable(FormCollection collection)
{
string url = "v3/Naviline/Payroll/AccrualTypeCodeTable";
// 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", "GetAccrualTypeCodeTable");
return View("Error", info);
}
}