Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Object to be importedIdentifying fields that must be included in the fileOptional fields

NonContractCompensation

id  (this is a string of characters and numbers)838679cb-e524-45a2-bdcb-4fdb900916f3 - This column header can be found under the More option.

position.number

position.employee.number

payUnit

  • Daily
  • Hourly

supplementalTaxOption

  • None
  • ApplyAnnuitiesToSupplemental
  • ApplyAnnuititesToRegular

payPlan

  • Biweekly
  • Semimonthly
  • Monthly

jobCalendar.archived

jobCalendar.description

jobCalendar.id

jobCalendar.type

calendarDate.startDate

calendarDate.stopDate

dateRange.startDate (compensation)

dateRange.stopDate (compensation)

description

hoursInDay

label

position.employee.name.lastName

position.employee.name.firstName

position.jobStatus

customFields.localContractCode.value

position.positionDescription

unitAmount

customFields.reportableToEMIS.value

retirementHours

strsAdvance

type



AdjustmentJournal

Keep in mind if the adjustment should apply to a specific payroll item you will need to supply the Payroll Item Code and Position Number(if position level payroll item) to correctly create adjustments

Adjustments can only be created via mass load. You will not be able to update existing adjustments via mass load.

employee.number

payrollItem.code

amount

transactionDate

type - The Type column must contain one of the following values:

    • HealthInsurance
    • MovingExpense
    • TaxableBenefits
    • FringeBenefits
    • LifeInsurance
    • AdoptionAssistance
    • DependentCare
    • ThirdPartyPay
    • VehicleLease
    • TotalGross
    • ApplicableGross (this replaces TaxableGross in Adjustment Journal Mass Loading only)
    • AmountWithheld
    • ApplicableAnnuities
    • BoardAmount
    • EarnedIncomeCredit
    • AdditionalWithholding
    • RehiredRetireeBoardAmount
    • RehiredRetireeAmountWithheld
    • RehiredRetireeGross
    • OdjfsGross
    • OdjfsWeeks
    • SersRetirementDays
    • SersRetirementHours
    • StrsRetirementDays
    • StrsRetirementHours
    • EmisAttendance
    • EmisAbsence
    • BoardPickupAmount
    • AdvancedSickLeave


employee.name.firstName

employee.name.lastName

payrollItem.position.number

description

payrollItem.type

Employee


























































Custom Date Field

number









































































Custom Date Example-testingDate

customFields.accredDistrictExperience.value

address.city

address.street1

address.street2

address.state

address.postalCode

address.foreignAddress

address.province

address.country

customFields.authorizedExperience.value

birthDate

customFields.buildingExperience.value

checkDistribution

customFields.credentialID.value

customFields.degreeType.value

deleted (Concealed)

customFields.districtExperience.value

customFields.ECEQualification.value

eligibleForRetirement

emailDirectDeposit

customFields.emisId.value

employeePhoto

gender

customFields.handicapStatus.value

hireDate

customFields.homePhone.value

customFields.homePhoneUnlisted.value

customFields.lastEvaluation.value

lastPaid

legalName.firstName

legalName.lastName

legalName.middleName

legalname.suffix

customFields.longTermIllness.value

maritalStatus

middleName

customFields.militaryExperience.value

name.firstName

name.lastName

name.middleName

name.suffix

newHireReportedODJFS

customFields.nextEvaluation.value

non-CertificateEmployeeID

customFields.nonOhioPrivateExperience.value

customFields.nonOhioPublicExperience.value

odjfsHireDate

odjfsReportable

customFields.ohioPrivateExperience.value

customFields.ohioPublicExperience.value

osdiCode

customFields.otherCredentials.value

customFields.otherEmail.value

partTime

employee.customFields.payrollCode1.value

employee.customFields.payrollCode2.value

employee.customFields.payrollDate1.value

employee.customFields.payrollDate2.value

employee.customFields.payrollText1.value

customFields.principalExperience.value

customFields.primaryEmail.value

customFields.primaryRace.value

customFields.purchasedExperience.value

race.americanIndianAlaskaNative

race.asian

race.black

race.hispanicLatinoOption

race.nativeHawaiianPacificIslander

race.white

reportToEmis

customFields.retireSystemExperience.value

customFields.secondaryEmail.value

customFields.semesterHours.value

spouseFirstName

ssn

subDays

terminationDate

customFields.testingDate.value

customFields.totalExperience.value

customFields.tradeExperience.value

customFields.workPhone.value


Position

number


appointmentType

assignmentArea

buildingCode

buildingIRN

compensations.calendarDate.startDate

compensations.calendarDate.stopDate

compensations.contractAmount

compensations.contractDaysWorked

compensations.contractObligation

compensations.contractType

compensations.contractWorkDays

compensations.dateRange.startDate

compensations.dateRange.stopDate

compensations.description

compensations.hoursInDay

compensations.jobCalendar.type

compensations.jobCalendar.description

compensations.label

compensations.payPerPeriod

compensations.payPerPeriodManualCalculationMode

contractAmount

contractWorkDays

eligibleForPersonalLeave

eligibleForSickLeave

eligibleForVacationLeave

experienceCurrentClass

extendedService

fullTimeEquivalence

fundingSourceCode1

fundingSourceCode2

fundingSourceCode3

highGrade

highQualityProfessionalDevelopment

hireDate

hoursInTheDay

isSupplemental

jobStatus

lowGrade

paraprofessional

paraprofessionalHireDate

percent1

percent2

percent3

positionCode

positionDescription

positionStatus

positionType

raiseDate

reportableToEmis

retirementCode

separationDate

separationReason

specialEducationFullTimeEquivalence

positionDate.startDate

stateReportingAppointmentType

positionDate.stopDate

supervisor.number

terminationDate

Payroll Item Configuration

Adopt Assistance Item Config

Annuity Item Config

Child Support Item Config

City Tax Item Config

Dependent Care Item Config

Employer Sers Item Config

Employer Strs Item Config

Federal Tax Item Config

Health Savings Account Item Config

Medical Saving Item Config

Medicare Tax Item Config

Ohio State Tax Item Config

Osdi Tax Item Config

Regular Item Config

Savings Bond Item Config

Sers Annuity Item Config

Sers Buy Back Annuity Item Config

Sers Item Config

Social Security Tax Item Config

State Tax Item Config

Strs Annuity Item Config

Strs Buy Back Annuity Item Config

Strs Item Config


code


abbrev

achSource

annuityType

cca

ccaDescription

certifiedObj

city

classifiedObj

designatedRoth

employerHealthCoverage

jobLevel

medicarePickup

name

nonWages125

osdiCode

otherObject

payee

paymentCycle

postalCode

printEmployerAmount

rita

ritaDescription

reportToCCA

required

showOnCreateWizard

state

stateId

street1

suppressSsnId

taxEmployerAmounts

taxEntityCode

taxNonCashEarn

voluntary

w2abbrev

Payroll Item

Adopt Assistance Item

Annuity Item

Child Support Item

City Tax Item

Dependent Care Item

Employer Sers Item

Employer Strs Item

Federal Tax Item

Health Savings Account Item

Medical Saving Item

Medicare Tax Item

Ohio State Tax Item

Osdi Tax Item

Regular Item

Savings Bond Item

Sers Annuity Item

Sers Buy Back Annuity Item

Sers Item

Social Security Tax Item

State Tax Item

Strs Annuity Item

Strs Buy Back Annuity Item

Strs Item


configuration.code

employee.number





















accountNumber

achConfiguration

  • achAccountNumber
  • achDirectDeposit
  • achRouteNumber
  • achXrefCode

additionalWithHolding

advanceErrorAdjustment

deductionType

effectiveRetirmentDate

employee.lastPaid

employeeDeductMaxAmount

  • employeeDeductMaxAmount.deductMaxStartDate
  • employeeDeductMaxAmount.maxAmount
  • employeeDeductMaxAmount.specificDate

employerDeductMaxAmount

  • employerDeductMaxAmount.deductMaxStartDate
  • employerDeductMaxAmount.maxAmount
  • employerDeductMaxAmount.specificDate

employerErrorAdjustments

  • errorAdjustments.amount
  • errorAdjustments.date
  • errorAdjustments.datePaid
  • errorAdjustments.description
  • errorAdjustments.id
  • errorAdjustments.paid

employmentComplianceWithORC3307353

employmentUnderORC3307353

employerRate

errorAdjustments

  • errorAdjustments.amount
  • errorAdjustments.date
  • errorAdjustments.datePaid
  • errorAdjustments.description
  • errorAdjustments.id
  • errorAdjustments.paid

fullOrPartTime

increasedCompensation

lastModifiedDate

maritalStatus

newEmployee

numberOfExpemptions

ohioRetirementSystem

osdiCode

payCycle

pensionPlan

percentOfGross

position.number - only needed if payroll item is deduction by job

rate

rateType

rehiredDate

rehiredRetiree

specificDate

activeDateRange.startDate (not specific on how date is entered)

activeDateRange.stopDate (not specific on how date is entered)

surchargeExempt

type

typeOfBenefit


Absence

employee.number

activityDate

length

category

unit

Category options include:

Calamity

Dock

Holiday

JuryDuty

Military

Other

Personal

Professional

Sick

Unknown

Vacation


Unit options include:

Daily

Hourly

Weeks

None



Attendance

employee.number

activityDate

length

category

unit


Category options include:

Attendance

Substituting


Unit options include:

Daily

Hourly

Weeks

None

appliedToBalance

appointmentType

dayOfWeek

id (Compensation)

payDate

subCategory

substituteFor

type

usasPostingIndicator

Leave

Sick Leave

Personal Leave

Vacation Leave


employee.number

type


Type Options include:

SICK

VACATION

PERSONAL

Due to how Leaves are being handled in redesign you will not be able to create new Leaves through Mass Load. The Employee must already have Leaves created through the normal Leaves UI. Mass load can only be used to update specific leave information.


accumPerMonth

accumulateBasedOnHours

advancedUnitsUsed

balance

currentServiceHours

employee.name.lastName

employee.name.firstName

leaveUnit

maxAdvanceLeave

maxLeaveAmount

number

personalLeaveAccum

resetValue

serviceHoursAccumulator

Compensation Journals

Compensation

Headers that are required for compensation journal entry:

  • id  (this is a string of characters and numbers) 838679cb-e524-45a2-bdcb-4fdb900916f3 - This column header can be found under the More option.
  • position.employee.name.lastName
  • position.employee.name.firstName
  • position.employee.number
  • position.number
  • amountPaid - Big Decimal formatted to 2 decimals
  • amountEarned - Big Decimal formatted to 2 decimals
  • amountDocked - Big Decimal formatted to 2 decimals
  • daysWorked - Big Decimal formatted to 2 decimals
  • description
  • paidPaid - Integer 

Once the Excel spreadsheet has been created, you must manually add in all the following headers:

  • amountPaid
  • amountEarned
  • amountDocked
  • daysWorked
  • description
  • paysPaid

In the spreadsheet file, you need to manually enter in the amount fields, days Worked and description. The amount fields and days worked cannot be blank. Enter zeros if no amount is needed.

**NOTE**Once the spreadsheet file has been created and data has been filled in, go to Mass Load and select the CompensationJournal entity.


Pay Account

Currently not implemented

Date Master

Date Text Field Definition


name

propertyName

appliesTo (AppliesTo must be org.ssdt_ohio.usps.model.employee.Employee for each record


Date Detail

Select 'Employee' from the select box

number

customFields.testDate.date (Date to be imported)

customFields.testDate.dateText (Description)


In this example 'testDate' is the property name of the Date Detail to be loaded. This part of the header will be different for each Date. This can be found on the Date Codes view.


Multiple dates can be imported per employee per file as long as each date has the correct header.


...