Method GetEmpJobTable

Summary

Get employee job table information

Remarks

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

Requires

Input Parameters

NameTypeLengthDescription
None No input parameters to pass

Example

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

Return Values

NameDescription
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 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/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); 
 });

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 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);
   }
}