Get employee job table information
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 unique key is less than zero
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
Name | Type | Length | Description |
---|---|---|---|
None | No input parameters to pass |
GET http://localhost/FusionServices/v3/Naviline/Payroll/EmpJobTable
Name | Description |
---|---|
ErrorCode | Error Code |
ErrorDescription | Error Description |
UNIQUEID | Unique ID |
LASTNAME | Last name |
FIRSTNAME | First name |
MIDDLEINITIAL | Middle initial |
PAYFREQUENCYCODE | Pay frequency code |
SCHEDULEDHOURSCODE | Scheduled hours code |
ACTUALPOSITIONNUMBER | Actual position number |
POSITIONNUMBER | Position number |
POSITIONSEQUENCE | Position sequence |
DEPARTMENTNUMBER | Department number |
DIVISIONNUMBER | Division number |
ACTIVITYNUMBER | Activity number |
AUTHDEPARTMENTNUMBER | Authorized department number |
AUTHDIVISIONNUMBER | Authorized division number |
AUTHACTIVITYNUMBER | Authorized activity number |
ELEMENTNUMBER | Element number |
OBJECTNUMBER | Object number |
HOURLYORSALARIED | Hourly or salaried |
FULLORPARTTIME | Full or part time |
EEOTYPE | Equal employment opportunity type |
GRADE | Grade |
STEP | Step |
CURRENTHOURLYRATE | Current hourly rate |
ANNUALSALARY | Annual salary |
ADDITIONALHOURLYRATE | Additional hourly rate |
OVERTIMERATE | Overtime rate |
PREMIUMHOURLYRATE | Premium hourly rate |
SHIFT2HOURLYRATE | 2nd shift hourly rate |
SHIFT3HOURLYRATE | 3rd shift hourly rate |
SHIFT4HOURLYRATE | 4th shift hourly rate |
GROUPCODE | Group code |
CHECKLOCATIONCODE | Check location code |
EMPLOYEESTATUSCODE | Employee status code |
WORKCOMPCODE | Worker’s compensation code |
WORKCOMPSUBCODE | Worker’s compensation sub-code |
EEOCATEGORYCODE | Equal employment opportunity category code |
EEOFUNCTIONCODE | Equal employment opportunity function code |
STATERETIREPLAN | State retirement plan |
STATERETIREPOSITION | State retirement position |
STATERETIREACCOUNT | State retirement account |
HOURSWORKEDPERYEAR | Hours worked per year |
EXEMPTFROMOVERTIME | Exempt from overtime |
TRIGGEROVERTIMEHOURS | Trigger overtime hours |
OVERTIMEHOURSTYPE | Overtime hours type |
OVERTIMETYPE | Overtime type |
SHIFT | Shift |
PROJECT | Project |
RANGEOFSERVICEHOURS | Range of service hours |
CURRANGEOFSVCHOURS | Current range of service hours |
NUMBEROFDAYSWORKED | Number of days worked |
NUMBEROFMONTHSWORKED | Number of months worked |
NUMBEROFYEARSWORKED | Number of years worked |
WORKHOURSINDAY | Normal work hours in day |
HIREDATE | Hire date (CCYYMMDD) |
TOTALSERVICEDATE | Total service date (CCYYMMDD) |
NEXTREVIEWDATE | Next review date (CCYYMMDD) |
NEXTREVIEWTYPECODE | Next review type code |
TERMINATIONDATE | Termination date (CCYYMMDD) |
TERMINATIONCODE | Termination code |
FINALCHECKPRINTED | Final check printed |
TAXATTWENTYPERCENT | Tax at twenty percent |
NOPAYCOUNTER | No pay counter |
SALARYINCENTIVEDATE | Salary incentive date (CCYYMMDD) |
SALARYINCENTIVERANK | Salary incentive rank code |
MTDGROSSAMOUNT | Month-to-date gross amount |
QTDGROSSAMOUNT | Quarter-to-date gross amount |
YTDGROSSAMOUNT | Year-to-date gross amount |
FYTDGROSSAMOUNT | Fiscal year-to-date gross amount |
MTDNETAMOUNT | Month-to-date net amount |
QTDNETAMOUNT | Quarter-to-date net amount |
YTDNETAMOUNT | Year-to-date net amount |
FYTDNETAMOUNT | Fiscal year-to-date net amount |
OUTSTANDADVANCEAMOUNT | Outstanding advance amount |
EFFECTIVEDATE | Effective date (CCYYMMDD) |
MULTIPOSITIONSTATUS | Multi-position status |
EMPLOYEEUNIQUEKEY | Employee unique key |
INFISYSCONTROL | INFISYS control |
INFISYSENTITY | INFISYS entity |
LONGEVITYDATE | Longevity date |
RETIREMENTDATE | Retirement date |
SENIORITYDATE | Seniority date |
BENEFITPLAN | Benefit plan |
UNIONCODE | Union code |
WORKPHONEAREACODE | Work phone area code |
WORKPHONE | Work phone number |
WORKPHONEEXTENSION | Work phone extension |
OTHERAREACODE | Other phone area code |
OTHERPHONE | Other phone number |
OTHERPHONEDESC | Other phone description |
SUPERVISORKEY | Supervisor key |
T4CODE | T4 code |
SUFFIX | Suffix |
PRIMARYJOB | Primary job |
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/EmpJobTable";
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 UNIQUEID = row["UNIQUEID"].ToString();
string LASTNAME = row["LASTNAME"].ToString();
string FIRSTNAME = row["FIRSTNAME"].ToString();
string MIDDLEINITIAL = row["MIDDLEINITIAL"].ToString();
string PAYFREQUENCYCODE = row["PAYFREQUENCYCODE"].ToString();
string SCHEDULEDHOURSCODE = row["SCHEDULEDHOURSCODE"].ToString();
string ACTUALPOSITIONNUMBER = row["ACTUALPOSITIONNUMBER"].ToString();
string POSITIONNUMBER = row["POSITIONNUMBER"].ToString();
string POSITIONSEQUENCE = row["POSITIONSEQUENCE"].ToString();
string DEPARTMENTNUMBER = row["DEPARTMENTNUMBER"].ToString();
string DIVISIONNUMBER = row["DIVISIONNUMBER"].ToString();
string ACTIVITYNUMBER = row["ACTIVITYNUMBER"].ToString();
string AUTHDEPARTMENTNUMBER = row["AUTHDEPARTMENTNUMBER"].ToString();
string AUTHDIVISIONNUMBER = row["AUTHDIVISIONNUMBER"].ToString();
string AUTHACTIVITYNUMBER = row["AUTHACTIVITYNUMBER"].ToString();
string ELEMENTNUMBER = row["ELEMENTNUMBER"].ToString();
string OBJECTNUMBER = row["OBJECTNUMBER"].ToString();
string HOURLYORSALARIED = row["HOURLYORSALARIED"].ToString();
string FULLORPARTTIME = row["FULLORPARTTIME"].ToString();
string EEOTYPE = row["EEOTYPE"].ToString();
string GRADE = row["GRADE"].ToString();
string STEP = row["STEP"].ToString();
string CURRENTHOURLYRATE = row["CURRENTHOURLYRATE"].ToString();
string ANNUALSALARY = row["ANNUALSALARY"].ToString();
string ADDITIONALHOURLYRATE = row["ADDITIONALHOURLYRATE"].ToString();
string OVERTIMERATE = row["OVERTIMERATE"].ToString();
string PREMIUMHOURLYRATE = row["PREMIUMHOURLYRATE"].ToString();
string SHIFT2HOURLYRATE = row["SHIFT2HOURLYRATE"].ToString();
string SHIFT3HOURLYRATE = row["SHIFT3HOURLYRATE"].ToString();
string SHIFT4HOURLYRATE = row["SHIFT4HOURLYRATE"].ToString();
string GROUPCODE = row["GROUPCODE"].ToString();
string CHECKLOCATIONCODE = row["CHECKLOCATIONCODE"].ToString();
string EMPLOYEESTATUSCODE = row["EMPLOYEESTATUSCODE"].ToString();
string WORKCOMPCODE = row["WORKCOMPCODE"].ToString();
string WORKCOMPSUBCODE = row["WORKCOMPSUBCODE"].ToString();
string EEOCATEGORYCODE = row["EEOCATEGORYCODE"].ToString();
string EEOFUNCTIONCODE = row["EEOFUNCTIONCODE"].ToString();
string STATERETIREPLAN = row["STATERETIREPLAN"].ToString();
string STATERETIREPOSITION = row["STATERETIREPOSITION"].ToString();
string STATERETIREACCOUNT = row["STATERETIREACCOUNT"].ToString();
string HOURSWORKEDPERYEAR = row["HOURSWORKEDPERYEAR"].ToString();
string EXEMPTFROMOVERTIME = row["EXEMPTFROMOVERTIME"].ToString();
string TRIGGEROVERTIMEHOURS = row["TRIGGEROVERTIMEHOURS"].ToString();
string OVERTIMEHOURSTYPE = row["OVERTIMEHOURSTYPE"].ToString();
string OVERTIMETYPE = row["OVERTIMETYPE"].ToString();
string SHIFT = row["SHIFT"].ToString();
string PROJECT = row["PROJECT"].ToString();
string RANGEOFSERVICEHOURS = row["RANGEOFSERVICEHOURS"].ToString();
string CURRANGEOFSVCHOURS = row["CURRANGEOFSVCHOURS"].ToString();
string NUMBEROFDAYSWORKED = row["NUMBEROFDAYSWORKED"].ToString();
string NUMBEROFMONTHSWORKED = row["NUMBEROFMONTHSWORKED"].ToString();
string NUMBEROFYEARSWORKED = row["NUMBEROFYEARSWORKED"].ToString();
string WORKHOURSINDAY = row["WORKHOURSINDAY"].ToString();
string HIREDATE = row["HIREDATE"].ToString();
string TOTALSERVICEDATE = row["TOTALSERVICEDATE"].ToString();
string NEXTREVIEWDATE = row["NEXTREVIEWDATE"].ToString();
string NEXTREVIEWTYPECODE = row["NEXTREVIEWTYPECODE"].ToString();
string TERMINATIONDATE = row["TERMINATIONDATE"].ToString();
string TERMINATIONCODE = row["TERMINATIONCODE"].ToString();
string FINALCHECKPRINTED = row["FINALCHECKPRINTED"].ToString();
string TAXATTWENTYPERCENT = row["TAXATTWENTYPERCENT"].ToString();
string NOPAYCOUNTER = row["NOPAYCOUNTER"].ToString();
string SALARYINCENTIVEDATE = row["SALARYINCENTIVEDATE"].ToString();
string SALARYINCENTIVERANK = row["SALARYINCENTIVERANK"].ToString();
string MTDGROSSAMOUNT = row["MTDGROSSAMOUNT"].ToString();
string QTDGROSSAMOUNT = row["QTDGROSSAMOUNT"].ToString();
string YTDGROSSAMOUNT = row["YTDGROSSAMOUNT"].ToString();
string FYTDGROSSAMOUNT = row["FYTDGROSSAMOUNT"].ToString();
string MTDNETAMOUNT = row["MTDNETAMOUNT"].ToString();
string QTDNETAMOUNT = row["QTDNETAMOUNT"].ToString();
string YTDNETAMOUNT = row["YTDNETAMOUNT"].ToString();
string FYTDNETAMOUNT = row["FYTDNETAMOUNT"].ToString();
string OUTSTANDADVANCEAMOUNT = row["OUTSTANDADVANCEAMOUNT"].ToString();
string EFFECTIVEDATE = row["EFFECTIVEDATE"].ToString();
string MULTIPOSITIONSTATUS = row["MULTIPOSITIONSTATUS"].ToString();
string EMPLOYEEUNIQUEKEY = row["EMPLOYEEUNIQUEKEY"].ToString();
string INFISYSCONTROL = row["INFISYSCONTROL"].ToString();
string INFISYSENTITY = row["INFISYSENTITY"].ToString();
string LONGEVITYDATE = row["LONGEVITYDATE"].ToString();
string RETIREMENTDATE = row["RETIREMENTDATE"].ToString();
string SENIORITYDATE = row["SENIORITYDATE"].ToString();
string BENEFITPLAN = row["BENEFITPLAN"].ToString();
string UNIONCODE = row["UNIONCODE"].ToString();
string WORKPHONEAREACODE = row["WORKPHONEAREACODE"].ToString();
string WORKPHONE = row["WORKPHONE"].ToString();
string WORKPHONEEXTENSION = row["WORKPHONEEXTENSION"].ToString();
string OTHERAREACODE = row["OTHERAREACODE"].ToString();
string OTHERPHONE = row["OTHERPHONE"].ToString();
string OTHERPHONEDESC = row["OTHERPHONEDESC"].ToString();
string SUPERVISORKEY = row["SUPERVISORKEY"].ToString();
string T4CODE = row["T4CODE"].ToString();
string SUFFIX = row["SUFFIX"].ToString();
string PRIMARYJOB = row["PRIMARYJOB"].ToString();
// TODO - YOUR CODE HERE
}
}
}
$.get('http://localhost/FusionServices/v3/Naviline/Payroll/EmpJobTable', 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 GetEmpJobTable
{
// Add property for each input param in order to map a field to it
public GetEmpJobTable()
{
//Set any defaults here
}
}
}
@* NOTE: Use Add->View to add the View. *@
@* NOTE: Check the 'Create strongly-typed view checkbox, and select the GetEmpJobTable 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.GetEmpJobTable
@{
ViewBag.Title = "GetEmpJobTable";
string myUrl = "http://localhost/FusionServices/v3/Naviline/Payroll/EmpJobTable";
}
<h2>GetEmpJobTable</h2>
@using (Html.BeginForm()) {
@Html.AntiForgeryToken()
@Html.ValidationSummary(true)
<fieldset>
<legend>GetEmpJobTable</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/GetEmpJobTable
public ActionResult GetEmpJobTable()
{
// Create a new instance of the model to pick up any default values.
GetEmpJobTable model = new GetEmpJobTable();
// pass model to set to default values
// NOTE: Change 'MyFolderPath' to the path to the .cshtml file.
return View("~/Views/MyFolderPath/GetEmpJobTable.cshtml", model);
}
//
// POST: /MyController/GetEmpJobTable
[HttpPost]
public ActionResult GetEmpJobTable(FormCollection collection)
{
string url = "v3/Naviline/Payroll/EmpJobTable";
// 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", "GetEmpJobTable");
return View("Error", info);
}
}