Role (initial and on-going) Import

HR/CORE-CT data is retrieved using the HRISWebAPI.

PS_JOBCODE_TBL_VW java field Page-Up field

JOBCODE jobcodeID RoleID

SETID setID

EFFDT effectiveDate

EFF_STATUS effectiveStatus

DESCR description RoleTitle

DESCRSHORT descriptionShort

JOB_FUNCTION jobFunction

SETID_SALARY setIDSalary

SAL_ADMIN_PLAN salAdminPlan part of PayPlanAndGrade

GRADE grade part of PayPlanAndGrade

STEP step

MANAGER_LEVEL managerLevel

UNION_CD unionCode part of UnionCode

CURRENCY_CD currencyCode

STD_HOURS standardHours StandardHours

STD_HRS_FREQUENCY standardHoursFrequency

COMP_FREQUENCY compFrequency

WORKERS_COMP_CD workersCompCode

JOB_FAMILY jobFamily use to find JobFamilyDescription

REG_TEMP regTemp

DIRECTLY_TIPPED directlyTipped

MED_CKUP_REQ medicalCheckRequired

FLSA_STATUS FLSAStatus use to convert into Exempt or Non-exempt

EEO1CODE eeo1Code

EEO4CODE eeo4Code

EEO5CODE eeo5Code

EEO6CODE eeo6Code

EEO_JOB_CODE eeoJobGroup

SEASONAL seasonal

ELS_STATUS ELSStatus

ENCUMBER_INDC encumberIndicator

ENCUMB_SAL_OPTN encumberSalaryOption

ENCUMB_SAL_AMT encumberSalaryAmount

WORK_DAY_HOURS workDayHours

DESCRLONG descriptionLong

JobFamilyDescription

BargainingUnit

SmartHRTemplate

PS_JOB_FAMILY_TBL_VW java field Page-Up field

JOB_FAMILY jobFamilyCode

EFFDT effectiveDate

EFF_STATUS effectiveStatus

DESCR description JobFamilyDescription

DESCRSHORT descriptionShort

PS_UNION_TBL_VW java field Page-Up field

ROWID rowid

UNION_CD unionCode

EFFDT effectiveDate

EFF_STATUS effectiveStatus

DESCR description part of UnionCode

DESCRSHORT descriptionShort

UNION_LOCAL_FLG unionLocalFlag

COUNTRY country

The Role integration is a list of selected jobcodes.

Selection Criteria:

Select active jobcodes for the most recent effective date.

Select jobcode = 3616SH(ExtenPrgmEduLias).

Select union codes:

02(Managerial)

03(Confidential)

04(Other Non-Bargaining)

06(Service/Maintenance, NP-2)

07(Administrative Clerical, NP-3)

09(Protective Services, NP-5)

28(UConn Faculty)

29(UConn Non-Faculty)

31(UConn - Exempt)

34(UConn – Law School Faculty)

36(GEU_UAW Graduate Empl).

Bypass Salary administration Plans:

CA

CR

FN

MD

MP

US

VR.

Processing:

The on-going role file only needs RoleID (jobcode) and RoleTitle (description), separated by a pip delimiter(|). The initial load file is the full role file.

Find job family description by querying the job family table, supplying the job family from the job code table.

Find union code description by querying the union code table, supplying the union code from the job code table. Select the most recent active union code description. Populate UnionCode with union code followed by a dash(-) followed by union code description.

Populate PayPlanAndGrade with salAdminPlan followed by a dash(-) followed by grade.

Put a space in BargainingUnit and SmartHRTemplate.

When FLSAStatus is an ‘X’, set to ‘Exempt’, otherwise set to Non-exempt.

To determine FLSAPeriodInDays do the following:

When FLSAStatus is anything other than ‘N’,

set FLSAPeriodInDays to “Not Applicable”.

When FLSAStatus is an ‘N’ and the JobCode is a police job code (6004PS, 6600PS, 9026PS, 9027PS, 9028PS, or 9036PS),

set FLSAPeriodInDays to “FLSA 28 days, 171 hours”.

When FLSAStatus is an ‘N’ and the JobCode is a fire job code (0481PS, 6364PS, 8954PS, 8955PS),

set FLSAPeriodInDays to “FLSA 28 days, 212 hours”.

For all other FLSAStatus is an ‘N’ cases,

Set FLSAPeriodInDays to “FLSA 7 days, 40 hours”.

All fields are separated by a pipe delimiter(|). The first record of the file will have the field names, separated by the pipe delimiter(|).

Names of the files:

Initial Load (Full File) - roles-initial-page-up.txt

Ongoing File - roles-page-up.txt

Sample data (Initial Load (Full File)):

Sample data (On-going File)):

RoleID|RoleTitle

2076CL|CollectionAgent

0253TC|AnimalCareSpecialistRC

1249PS|Bldgs&GrndSupvsngPatrlOfcr

6013CL|OfficeSupervisor

8191CL|StudentTrainee

Execution Command:

Initial Load (Full File) - /createRoleFullFileJob.html

Ongoing File - /createRoleFileJob.html

Control-M Schedule and Job:

Ongoing File:

UAT - UAT_AEWEB_SCHEDULE/UAT_RPM_ROLE_TO_PAGEUP

PRD - Not being run in production