Get the position control table information
Excludes any rows where position control status is equal to “C”
Excludes any rows where position control number has been excluded in the “Positions” 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/PositionControlTable
Name | Description |
---|---|
ErrorCode | Error Code |
ErrorDescription | Error Description |
POSITIONNUMBER | Position number (numeric) |
POSITIONTITLE | Position title |
EEOTYPE | Equal employment opportunity type (numeric) |
GRADE | Pay grade |
STATERETIREPLAN | State retirement plan |
STATERETIREPOSITION | State retirement position (numeric) |
EEOCATEGORYCODE | Equal employment opportunity category code |
EEOFUNCTIONCODE | Equal employment opportunity function code |
EXEMPTFROMOT | Exempt from overtime Values: N=No, Y=Yes |
FROMSTEP | Paygrade from step |
TOSTEP | Paygrade to step |
RANKCRITERIACODE | Rank criteria code |
MONTHSTOKEEPAPPLS | Months to keep applications |
WORKCOMPCODE | Worker’s compensation code |
WORKCOMPSUBCODE | Worker’s compensation sub-code |
ELECTEDPOSITIONFLAG | Elected position flag Values: N=No, Y=Yes |
CIVILSERVICEFLAG | Civil service flag Values: N=No, Y=Yes |
COMPETITIVEFLAG | Competitive position flag Values: N=No, Y=Yes |
WORKHOURSINDAY | Normal daily work hours |
GROUPCODE | Group plan code |
POSITIONSTATUS | Position status |
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/PositionControlTable";
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 POSITIONNUMBER = row["POSITIONNUMBER"].ToString();
string POSITIONTITLE = row["POSITIONTITLE"].ToString();
string EEOTYPE = row["EEOTYPE"].ToString();
string GRADE = row["GRADE"].ToString();
string STATERETIREPLAN = row["STATERETIREPLAN"].ToString();
string STATERETIREPOSITION = row["STATERETIREPOSITION"].ToString();
string EEOCATEGORYCODE = row["EEOCATEGORYCODE"].ToString();
string EEOFUNCTIONCODE = row["EEOFUNCTIONCODE"].ToString();
string EXEMPTFROMOT = row["EXEMPTFROMOT"].ToString();
string FROMSTEP = row["FROMSTEP"].ToString();
string TOSTEP = row["TOSTEP"].ToString();
string RANKCRITERIACODE = row["RANKCRITERIACODE"].ToString();
string MONTHSTOKEEPAPPLS = row["MONTHSTOKEEPAPPLS"].ToString();
string WORKCOMPCODE = row["WORKCOMPCODE"].ToString();
string WORKCOMPSUBCODE = row["WORKCOMPSUBCODE"].ToString();
string ELECTEDPOSITIONFLAG = row["ELECTEDPOSITIONFLAG"].ToString();
string CIVILSERVICEFLAG = row["CIVILSERVICEFLAG"].ToString();
string COMPETITIVEFLAG = row["COMPETITIVEFLAG"].ToString();
string WORKHOURSINDAY = row["WORKHOURSINDAY"].ToString();
string GROUPCODE = row["GROUPCODE"].ToString();
string POSITIONSTATUS = row["POSITIONSTATUS"].ToString();
// TODO - YOUR CODE HERE
}
}
}
$.get('http://localhost/FusionServices/v3/Naviline/Payroll/PositionControlTable', 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 GetPositionControlTable
{
// Add property for each input param in order to map a field to it
public GetPositionControlTable()
{
//Set any defaults here
}
}
}
@* NOTE: Use Add->View to add the View. *@
@* NOTE: Check the 'Create strongly-typed view checkbox, and select the GetPositionControlTable 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.GetPositionControlTable
@{
ViewBag.Title = "GetPositionControlTable";
string myUrl = "http://localhost/FusionServices/v3/Naviline/Payroll/PositionControlTable";
}
<h2>GetPositionControlTable</h2>
@using (Html.BeginForm()) {
@Html.AntiForgeryToken()
@Html.ValidationSummary(true)
<fieldset>
<legend>GetPositionControlTable</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/GetPositionControlTable
public ActionResult GetPositionControlTable()
{
// Create a new instance of the model to pick up any default values.
GetPositionControlTable model = new GetPositionControlTable();
// pass model to set to default values
// NOTE: Change 'MyFolderPath' to the path to the .cshtml file.
return View("~/Views/MyFolderPath/GetPositionControlTable.cshtml", model);
}
//
// POST: /MyController/GetPositionControlTable
[HttpPost]
public ActionResult GetPositionControlTable(FormCollection collection)
{
string url = "v3/Naviline/Payroll/PositionControlTable";
// 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", "GetPositionControlTable");
return View("Error", info);
}
}