- 25 Sep 2024
- 10 Minutes to read
- Print
- DarkLight
Create a new PY Employee
- Updated on 25 Sep 2024
- 10 Minutes to read
- Print
- DarkLight
Create Employees
Basic authentication
The unique identifier of an employee
The Rate at which the Job is charged out
The Rate at which the Billing is done
Payroll Company code
‘A’- Active ,‘T’- Terminated, ‘D’- Deceased
Identifies the Pay Group
Identify the Emp Pay Run Code
Employee SIN/SSN Number
Identify the Trade
Employee date of Birth
Unique uuid of row
The name of the user who made the last update
Employee First Name
Employee Middle Name
Employee Last Name
Employee Prefix Name
Employee Suffix Name
Employee Nick Name
Identify the Country
Identify the State / Province
The Rate at which the Worker is to be paid
Zip or Postal Code of the Address
Employee Original Hire date
Identify the Location
Employee OT Eligibility
Payment Mode like C for Cash
Last Increament Date
Last Promotion Date
Last Transfer Date
Date and Time stamp of the last update
Flag that shows if employee has access to employee selfservice programs
TD1 Exemption flag for employee
Identify Whether Employee is on Hardship Suspension
Identify whether Employee is on on Hardship Suspension
Unique Key for Employee sequence
Allow user to select employee as Exempt or Non-Exempt ISSUE:11_55131
Hourly Employee Yearly Salary
Hourly Employee Type
Identify the Requisition Type
Employee Work Cell Phone
Employee Work Email Address
Identify Address To Populate Employee Vertext Geocode Valid Values M=Mailing Address; P=Physical Address
Flag Decides Employee Mailing Address Is Foreign Address Or Not?
Flag Decides Employee Physical Address Is Foreign Address Or Not?
Identify the Physical Address Country
Identify the Physical Address State / Province
Identify The Employee "Reports To" (Direct Manager)
Identify the Type of the employment as H/S/C/A
F=Full-time, P=Part-time
Identify the Status
Identify Employee relation with Union as Y/N
Union Membership Date
Identify the Union
Union Membership No. if applicable
Employee Job Title
Place of Birth of the Employee
Termination Date of the Employee
Re Hire Date of the employee
Date the employee Deceased
Date from which employee`s seniority will be considered
Main employee that this employee is linked to and duplicated from.
Employee Home Company Code for Inter-Branch costing
Employee Home Department Code for Inter-Branch costing
Salary Posting default Account Code
Payroll Clearance default Account Code
Payroll CR Clearance default Account Code
Identify the Location
Check location code
Default WCB Code
Default WCB Code
WCB by Job Yes/No
WCB by Job Yes/No
For new records in DA.PYEMPLOYEE_TABLE defaults value from Dispatch_flag of DA.PYPAYPRD
Annual Salary of the employee
Identify the Rate Code for OT working hours
Identify the Rate Code for DOT working hours
Identify the Rate Code for OTH working hours
Preffered Pay Rate for Employee J for Job, U for Union or E for E
Preferred Method For Receiving Direct Deposit Stubs: M-Mail, E-Email, N-None
Email Address For Direct Deposit Stubs
Optional minimum hours code for E-time. References table PYMINHR.
Phase Code
Default Job Category Code
Default job phase code for the piece of equipment
Home Address of the Employee
Home Address of the Employee
Home Address of the Employee
Identify the County
Identify the City / Town
Home Phone Number of the Employee
Home Fax Number of the Employee
Business Partner and Vendor Code Created For Employee
Preferred Method For Sending AP Direct Deposit Stubs For Employee
Residential Status of the Employee
Identify the Company
Identify the Side Address Code
Identify the Company Region
Identify the Region
Identify HCM Job Classification
Ability to travle
Maximum mileage/kilometer to travel
Sex of the Employee
Marital Status of the Employee
Ethnic Code of the Employee
Military status, can have multiple codes separated by commas.
Military separation/discharge date. For veterans, field used to determine if "newly separated" for Vet-100 reporting.
HCM Position Occupied By The Employee
Identity An Employee Is Available In The Field Tracking Screen
Pension registration number of the union to which the employee belongs
Employee with any kind of disability. Valid values may be Y=Yes; N=No; NULL=No Answer
Employee's Aboriginal Status. Valid values may be S=Status; Y=Non-Status; N=Not an Aboriginal
Employee belonging to a visible minority group. Valid values may be W=White; B=Black; E=East Asian / Southeast Asian; S=South Asian; N=Native Peoples; O=Other; NULL=No Answer
United Kingdom PAYE tax code
United Kingdom NIC category code
Tax Frequency
United Kingdom: New starter first payment company code.
United Kingdom: New starter first payment pay run code.
United Kingdom: New starter first payment year.
United Kingdom: New starter first payment period.
United Kingdom: New starter declaration: A=First Job This Year, B=Only Job, C=Have Another Job
United Kingdom: Passport number
United Kingdom: Student flag (Y/N/null)
United Kingdom: Previous employer HMRC office number
United Kingdom: Previous employer PAYE reference number
United Kingdom: Previous employer leaving date
United Kingdom: Previous employer PAYE tax code
United Kingdom: Previous employer W1/M1 flag (Y/N/null)
United Kingdom: Previous employer gross income for new starter year
United Kingdom: Previous employer income tax deducted for new starter year
United Kingdom: Seconded employee (Y/N/null)
United Kingdom: Seconded employee is a European Economic Area Citizen (Y/N/null)
United Kingdom: Seconded employee falls under EPM6 Modified Scheme (Y/N/null)
United Kingdom: Seconded employee residence: A=UK Over 6 Months, B=UK Under 6 Months, C=Abroad
Ireland: PAYE exclusion order flag (Y/N/null).
Ireland: Employee PRSI class (A,J,K,M) or class modifier (EJS,CES).
Employee Taxrelief, it is only for ireland and it is not available in History
Allow timesheet access for the employee through ESS or Mobile. Values=Y/N
Salaried Employee Frequency Salary
Salaried Employee Monthly Salary
Destination Airport Orasequence
Employee Religion Code
School Eligibility Percentage
Student Laon Plan Type, it is only for UK and it is not available in History
GC Monitor Charge Rate (Only to be used in GC Monitor calculations)
GC Monitor Bill Rate (Only to be used in GC Monitor calculations)
Employee Address Longitude
Employee Address Latitude
Employee Probation End Date
Last Posted Timesheet Document Number
Employee Contract type S:Single, M: Married, F:Family
description
---
Created
{
"EmpNo": "GEO-TEST-053",
"EmpCalcPref": "S",
"EmpComment": null,
"EmpResLoc": "SNY",
"EmpOtEligibility": null,
"EmpPaymentMode": null,
"EmpLastIncrDate": null,
"EmpLastPromDate": null,
"EmpLastTranDate": null,
"EmpUser": "DA",
"EmpIuCreateDatetime": null,
"EmpIuUpdateDatetime": null,
"EmpLastUpdDate": null,
"EmpTd1ExempAmt": null,
"EmpEiCode": null,
"EmpAdpFilingStatus": null,
"EmpCreateDate": null,
"EmpSseFlag": null,
"EmpTd1ExempFlag": null,
"EmpEligibilityFlag": null,
"EmpHardshipSuspFlag": null,
"EmpSecGrpEmpCode": null,
"EmpSecGrpEmpName": null,
"EmpFlsaType": "N",
"EmpHemplYearlySal": 0,
"EmpHemplType": "H",
"EmpHasCert": null,
"EmpHasSkill": null,
"EmpHrrTypeCode": null,
"EmpHrrTypeDesc": null,
"EmpLastTshJobCompCode": null,
"EmpLastTshJobCode": null,
"EmpLastTshJobDesc": null,
"EmpWorkCellPhone": null,
"EmpWorkEmailAddress": null,
"EmpVertexGeocodeSource": "M",
"EmpAddressForeignFlag": null,
"EmpPhAddressForeignFlag": null,
"EmpPhCountryCode": null,
"EmpPhCountryName": null,
"EmpPhStateCode": null,
"EmpPhStateName": null,
"EmpReportsTo": null,
"EmpReportsToName": null,
"EmpFullName": "Liam Kinder",
"EmpFirstName": "API",
"EmpMiddleName": null,
"EmpLastName": "Test",
"EmpPrefixName": null,
"EmpSuffixName": null,
"EmpNickName": null,
"EmpSinNo": "331601053",
"EmpType": "S",
"EmpFullPartTime": "F",
"EmpStatus": "A",
"EmpStatusDesc": "Active",
"EmpSubStatus": "W",
"EmpCalcAccruedLeave": "Y",
"EmpUnionized": "N",
"EmpMembershipDate": null,
"EmpRehireEligible": "Y",
"EmpUniCode": null,
"EmpUniName": null,
"EmpUnionMemNo": null,
"EmpJobTitle": null,
"EmpPlaceOfBirth": null,
"EmpDateOfBirth": "2000-01-01",
"EmpHireDate": "2023-10-03",
"EmpTerminationDate": null,
"EmpReHireDate": null,
"EmpDateDeceased": null,
"EmpSeniorityDate": null,
"EmpNextReviewDate": null,
"EmpAdjustedSeriviceDate": "2005-01-01",
"EmpPrimaryEmpNo": "GEO-TEST-053",
"EmpYearWorkingDays": 260,
"EmpYearWorkingHours": 2080,
"EmpServiceYears": 0,
"EmpUeValidFlag": "Y",
"EmpCompCode": "ZZ",
"EmpCompName": null,
"EmpHomeCompCode": "ZZ",
"EmpHomeCompName": null,
"EmpDeptCode": "00",
"EmpDeptName": null,
"EmpHomeDeptCode": "00",
"EmpHomeDeptName": null,
"EmpGlAccCode": "6000.100",
"EmpGlAccName": null,
"EmpPayrollClearAccCode": "6000.200",
"EmpPayrollClearAccName": null,
"EmpDrClearAccCode": "6000.200",
"EmpDrClearAccName": null,
"EmpLevAcruGlAccCode": "6002.101",
"EmpLevAcruGlAccName": null,
"EmpLevClearAccCode": "6002.101",
"EmpLevClearAccName": null,
"EmpPrnCode": "ZZWK",
"EmpPrnName": null,
"EmpPygCode": "WK",
"EmpPygName": null,
"EmpWrlCode": "ZCHI",
"EmpWrlName": null,
"EmpGrdCode": null,
"EmpGrdName": null,
"EmpTrdCode": "ZZ10",
"EmpTrdName": null,
"EmpExpAprvGrpCode": null,
"EmpExpAprvGrpName": null,
"EmpTshCode": "ZZWK",
"EmpTshName": null,
"EmpCklocCode": null,
"EmpCklocName": null,
"EmpWcbCode": "WC",
"EmpWcbName": null,
"EmpPlCode": "PL",
"EmpPlName": "Public Liab NY",
"EmpWcbByJob": "Y",
"EmpPlByJob": "Y",
"EmpWrlFlag": "Y",
"EmpExcpInclFlag": "N",
"EmpInclCertPyRepFlag": "Y",
"EmpAutogenerateTimesheet": "Y",
"EmpDispatchFlag": "N",
"EmpAnnualSalary": 80000,
"EmpHourlyRate": 50,
"EmpChargeOutRate": 100,
"EmpBillingRate": 150,
"EmpRateCode": "Z100",
"EmpRateName": null,
"EmpOtRateCode": "Z200",
"EmpOtRateName": null,
"EmpDotRateCode": "Z300",
"EmpDotRateName": null,
"EmpOthRateCode": "Z400",
"EmpOthRateName": null,
"EmpPreferPayRate": "J",
"EmpPreferChargeRate": "J",
"EmpPreferBillRate": "J",
"EmpDirectDepMethod": "M",
"EmpDirectDepEmail": null,
"EmpMinHourCode": null,
"EmpUserEnteredOt": null,
"EmpUserEnteredDt": null,
"EmpJobCompCode": "ZZ",
"EmpJobCompName": null,
"EmpJobCode": null,
"EmpJobName": null,
"EmpPhsCode": null,
"EmpPhsName": null,
"EmpCatCode": null,
"EmpCatName": null,
"EmpEquipmentNo": null,
"EmpEquipmentName": null,
"EmpEquipPhsCode": null,
"EmpEquipPhsName": null,
"EmpEquipCategory": null,
"EmpEquipCatName": null,
"EmpEquipTranCode": null,
"EmpEquipTranName": null,
"EmpAddress1": null,
"EmpAddress2": null,
"EmpAddress3": "Newark",
"EmpZipCode": "43055",
"EmpPhAddress1": null,
"EmpPhAddress2": null,
"EmpPhAddress3": null,
"EmpPhZipCode": null,
"EmpCountryCode": "US",
"EmpCountryName": null,
"EmpStateCode": "OH",
"EmpStateName": null,
"EmpCountyCode": null,
"EmpCountyName": null,
"EmpCityCode": null,
"EmpCityName": null,
"EmpPhone": null,
"EmpWorkPhone": null,
"EmpCellPhone": null,
"EmpPager": null,
"EmpFax": null,
"EmpWorkFax": null,
"EmpEmailAddress": "william.palo@cmic.ca",
"EmpResLatitude": null,
"EmpResLongitude": null,
"EmpBpCode": null,
"EmpPrefContactMth": "E",
"EmpVertexGeocode": null,
"EmpVertexSchdist": null,
"EmpResidentStatus": "C",
"EmpFilingStatus": "02",
"EmpFilingStatusName": null,
"EmpStateFilingStatus": null,
"EmpStateFilingStatusName": null,
"EmpCityFilingStatus": null,
"EmpCityFilingStatusName": null,
"EmpPrimExemp": 0,
"EmpSecnExemp": null,
"EmpTertExemp": null,
"EmpPrimExempAmt": null,
"EmpSuplExempAmt": null,
"EmpSuiState": null,
"EmpSuiStateName": null,
"EmpNrCertificate": "Y",
"EmpPensionFlag": null,
"EmpDefCompFlag": null,
"EmpAddrCompCode": null,
"EmpAddrCode": null,
"EmpAddrName": null,
"EmpRegCompCode": null,
"EmpRegionCode": null,
"EmpRegionName": null,
"EmpPosCode": null,
"EmpPosName": null,
"EmpDisabilityDisCode": null,
"EmpDisabilityDisName": null,
"EmpTravelFlag": null,
"EmpTravelDistance": null,
"EmpLanguageLangName": null,
"EmpApplicantAplNo": null,
"EmpLoginUser": null,
"EmpSex": "M",
"EmpMaritalStatus": "S",
"EmpEthnicCode": "W",
"EmpMilitaryStatus": "NV",
"EmpMilitarySeparationDate": null,
"EmpDominantHand": "R",
"EmpLeaveCalcPref": "R",
"EmhActionCode": null,
"EmhDateDeceased": null,
"EmhEffectiveDate": null,
"EmpEtimeAccessRoleCode": null,
"EmpMsgId": null,
"EmpPositionCode": null,
"EmpFieldTrackingFlag": "N",
"EmpTd1ProvExempAmt": 0,
"EmpWorkProvince": null,
"EmpPensionNumber": null,
"EmpDisabledFlag": null,
"EmpAboriginalFlag": null,
"EmpVisibleMinorityFlag": null,
"EmpTxtCode": null,
"EmpCreateAccessCode": null,
"EmpDeleteAccessCode": null,
"EmpDeleteFromAprvList": null,
"EmpBenDedEndDate": null,
"EmpSource": null,
"EmpVUuid": "",
"EmpBpFlag": null,
"EmpContractType": null,
"EmpMonthlySalary": null,
"EmpProbationDate": null,
"EmpReligionCode": null,
"EmpSalaryFrq": null,
"EmpSchoolPercent": null,
"EmpAirportCode": null,
"PyenEmiratesId": null,
"PyenLaborCardExpDate": null,
"PyenLaborCardIssueDate": null,
"PyenLaborCardNo": null,
"PyenMotherName": null,
"PyenPassportExpDate": null,
"PyenPassportIssueDate": null,
"PyenPassportNo": null,
"PyenPassportPlaceIssue": null,
"PyenPrimaryNation": null,
"PyenSecondNation": null,
"PyenVUuid": null,
"PyenVisaExpDate": null,
"PyenVisaIssueDate": null,
"PyenVisaNo": null,
"PyenVisaPlaceIssue": null,
"PyenPrevEmpNo": null,
"EmpIePayeExclusionFlag": null,
"EmpIePrsiClassCategory": null,
"EmpIeTaxrelief": null,
"EmpUk1stPayComp": null,
"EmpUk1stPayPeriod": null,
"EmpUk1stPayRun": null,
"EmpUk1stPayYear": null,
"EmpUkEeaCitizenFlag": null,
"EmpUkEpm6Flag": null,
"EmpUkNicCategory": null,
"EmpUkPassportNo": null,
"EmpUkPayeTaxCode": null,
"EmpUkPrvEmplrGrossAmt": null,
"EmpUkPrvEmplrLeaveDate": null,
"EmpUkPrvEmplrOfficeNum": null,
"EmpUkPrvEmplrPayeRef": null,
"EmpUkPrvEmplrTaxAmt": null,
"EmpUkPrvEmplrTaxCode": null,
"EmpUkPrvEmplrWm1Flag": null,
"EmpUkSecondedFlag": null,
"EmpUkSecondedResidence": null,
"EmpUkStarterDeclaration": null,
"EmpUkStudentFlag": null,
"EmpUkTaxFrq": null,
"links": [
{
"rel": "self",
"href": "https://dev6v12.cmic.ca:9999/cmicdevv12/hcm-rest-api/rest/1/pyemployee/",
"name": "pyemployee",
"kind": "item"
},
{
"rel": "canonical",
"href": "https://dev6v12.cmic.ca:9999/cmicdevv12/hcm-rest-api/rest/1/pyemployee/",
"name": "pyemployee",
"kind": "item"
}
]
}