Job Codes
Job Codes
Job Codes
Item Overview: The Job Code Table is a delivered PeopleSoft table used to identify State of Connecticut job classifications in the system and define job family, compensation, and regulatory information for the particular job code. Menu Path: Go / Define Business Rules / Manage Human Resources / Setup / Job Code Table JOBCODE_TBL JOBCD_COMP_RATE JOBCD_TRN_PROG
SAL_R
JOBCODE_TBL
Jiasoj sl Jdfljsdoi
Jiasoj sl Jdfljsdoi
Jiasoj sl Jdfljsdoi
Jiasoj sl Jdfljsdoi
Approach: The State of Connecticut will utilize job code functionality. There will be a one to one relationship between a job code, a salary plan and a bargaining unit. An example being, a Clerk assigned to the Clerical bargaining unit would have a different job code than a Clerk working in HR who would not belong to a bargaining unit and would be assigned to the confidential pay plan. Currently there are approximately four thousand job codes maintained by DAS. Eight hundred and fifty unclassified job codes exist at UCONN-Storrs and three-hundred at UCONN-Health. The interfacing agencies, UCONN Storrs and UCHC are not currently maintained by DAS although DAS assigns the (class) jobcode number. The training module will not be used in phase one therefore the records associated with the Job Code Training Program Table will not be configured at this time. We will have one default compensation rate code for every Jobcode. Information Source: The information for this table will be gathered from the Department of Administrative Services. UCONN-Storrs, UCONN Health, Judicial, Legislative Management, the Community Colleges and Department of Education will also have to submit data. Data Entry Method: _____ On-Line Pages ___X_ Excel Spreadsheet Fields on Record: PS RECORD NAME/ PS FIELD NAME JOBCODE_TBL SETID
DESCRIPTION 6 Character field. The value for this field will be determined as part of the SETID work unit which defines how the State of Connecticut would like to organize Jobcode information for viewing purposes.
Jiasoj sl Jdfljsdoi
EFFDT
Effective Date
EFF_STATUS DESCR
DESCRSHORT
Short Description
JOB_FUNCTION
SETID_SALARY
Salary Set ID
Jiasoj sl Jdfljsdoi
GRADE
Salary Grade
STEP
Step
MANAGER_LEVEL SURVEY_SALARY
SURVEY_JOB_CODE
UNION_CD
Union Code
Jiasoj sl Jdfljsdoi
STD_HRS_FREQUEN CY
COMP_FREQUENCY
Compensation Frequency
WORKERS_COMP_C D JOB_FAMILY
JOB_KNOWHOW_POI NTS JOB_ACCNTAB_POIN TS JOB_PROBSLV_POIN TS JOB_POINTS_TOTAL JOB_KNOWHOW_PC T JOB_ACCNTAB_PCT JOB_PROBLSLV_PCT REG_TEMP DIRECTLY_TIPPED
Know how-Points Accountability-Points Problem-Solving-Points Total Points Know how-Percent Accountability-Percent Problem-Solving-Percent Regular / Temporary Tipped
Jiasoj sl Jdfljsdoi
EEO1CODE EEO4CODE
EEO5CODE
EEO6CODE
EEO_JOB_GROUP
US_SOC_CD IPEDSSCODE
JOBCD_CAN_SBR
Jiasoj sl Jdfljsdoi
PS RECORD NAME/ PS FIELD NAME CAN_PAYEQ_JOB_CL S CAN_NOC_CD SEASONAL BPS_ACTIVITY_CD JOBCD_GER_SBR FUNCTION_CD BA_CD TECHNICAL MED_SURV_REQ JOBCD_FRA_SBR EMP_CATEGRY_FRA ACTIVITY_TYPE_FR A INSEE_CD_FRA JOBCD_UK_SBR UK_SOC_CD JOBCD_FED_SBR GVT_PAY_PLAN GVT_OCC_SERIES TRN_PROGRAM COMPANY GVT_FUNC_CLASS GVT_POSN_TITLE_C D GVT_OFFICIAL_DES CR GVT_ORG_TTL_CD
Organizational Position Title Code GVT_ORG_TTL_DESC Organizational Position R Title GVT_PAY_BASIS Pay Basis GVT_SUB_AGENCY Sub-Agency GVT_POI Personnel Office ID
Jiasoj sl Jdfljsdoi
GVT_EXEC_FIN_DISC Executive Financial L Disclosure GVT_EMP_FIN_INT GVT_PATCOB_CD GVT_CLS_STANDAR D GVT_CLASSIFIER_ID GVT_DT_CLASSIFIED BARG_UNIT GVT_FUND_SOURCE GVT_LEO_POSITION GVT_PERF_PLAN GVT_TARGET_GRAD E GVT_PI_UPD_IND ENCUMBER_INDC Employee Financial Interests PATCOB Code Classification Standard Classifiers ID Date Classified Bargaining Unit Fund Source LEO/Fire Position Performance Plan Target Grade Pi upd ind Encumbrance Indicator
POSN_MGMT_INDC EG_ACAMEDIC_RAN K
Jiasoj sl Jdfljsdoi
ENCUMB_SAL_AMT
JOBCD_ITA_SBR INAIL_CODE DESCRLONG JOBCD_AUS_SBR ASCO_CD_AUS PKG_TEMPLATE_ID PKG_RULE_ID JOBCD_AUSHE_SBR FUNCTIN_AUS ANN_CNTACT_HRS_ AUS TEACH_WEEKS_AUS CASUAL_TYPE_AUS JOBCD_MYS_SBR WORK_DAY_HOURS JOBCD_FA_SBR FA_PAY_PROGRAM JOBCD_FP_SBR ELECTION_GROUP
INAIL Code Description ASCO Code Package Template ID Package Rule ID Job Function Annual Contact Hours Total weeks in teaching job Type of work performed Number of hours in a work day Festive Advance Pay Program Election Group
Jiasoj sl Jdfljsdoi
PS RECORD NAME/ PS FIELD NAME FP_PROF_CATG FP_JOB_FMLY FP_OFF_COLAG FP_MATRIX_TYP FP_BUSINESS_CD FP_JOBCD_ACC FP_ATCH_AREA FP_JOB_TYP FP_AUTO_RATFY LAST_UPDATE_DAT E REG_REGION
SAL_RANGE_MIN_R ATE SAL_RANGE_MID_R ATE SAL_RANGE_MAX_R ATE SAL_RANGE_CURRE NCY SAL_RANGE_FREQ CLASS_INDC
Salary Range Minimum Rate Salary Range Midpoint Rate Salary Range Maximum Rate Salary Range Currency Salary Range Frequency Classified/Unclassified Status
Jiasoj sl Jdfljsdoi
SetID
JOBCODE
Job Code
EFFDT
Effective Date
Currency Code Compensation Rate Points Rate Code Group Name Apply FTE for Annualization SetID
Jiasoj sl Jdfljsdoi
EFFDT
Effective Date
TRN_PROGRAM
Training Program
Dependencies and Timing: JOBFUNCTION_TBL Job Function Code %SAL_SETID_PRMP Salary Set ID %SAL_PLN_PRMPT2 - Salary Administration Plan %SAL_GRD_PRMPT2 Salary Grade %SAL_STP_PRMPT2 Salary Step UNION_TBL Union Code Table CURRENCY_CD_TBL Currency Code Table STDHRS_FREQ_VW Standard Work Period JOB_FAMILY_TBL Job Family SETID_TBL Set ID COMP_RATECD_TBL Compensation Rate Code Table Testing Considerations: Verify that the page can be viewed without error. Verify that multiple effective dated rows can be entered. Verify that security is set up appropriately based on Setids. Verify that there is only one salary plan and grade for each jobcode. Assumptions: State of Connecticut (Department of Administrative Services) will convert all existing job codes from their existing 4 digits in length to 6 digits in length in order to meet the one to one relationships between job code, salary plans and bargaining units. State of Connecticut (DAS) will convert their existing long job code description from 60 characters to 30 and their short job code description from 16 to 10. The full and complete job code title will be converted into DESCRLONG in the JOBCODE_TBL record. DAS Central will provide the information to configure the job function codes, job code task and the job family codes. Currently not maintained in legacy system. The Job Code Table, Evaluation Criteria page will not be visible to end-users, as it will not be used by the State of Connecticut. Evaluation Criteria will continue to be maintained in greater detail in the DAS Classification Database.
Jiasoj sl Jdfljsdoi
The Job Code Table, Non-Base Compensation page will not be visible to end-users, as it will not be used by the State of Connecticut. DAS Central will provide the information to configure the Medical Checkup Required on the job codes. Currently not maintained in legacy system. PeopleSoft delivers job codes to be set up as either regular or temporary. Job codes will be set up with a default of regular in Core-CT. DAS will need to configure the values for each job code. The State of Connecticut will not be utilizing the training module in phase one. Each Jobcode will have a default compensation rate code, but no other compensation rate code functionality will be utilized. Job Codes are associated with Position Data, which will be converted mostly from existing data in APS Employees cannot be hired or paid by PS unless they have been assigned a job code.
Input Provided By: Name Lina Simonu Lisa Lagus Bette Jenak
Title, Department HR Module Team Lead, DAS HR Team Lead Accenture HR Team Member, State of Connecticut
Jiasoj sl Jdfljsdoi
Configuration Team _________________________ _________________________ Configuration Team Leads _________________________ Ryan Oakes Module Team Leads _________________________ Team Leads _________________________ Rajeev Sharma _________________________ Sue Martin _________________________ Anne North _________________________ _________________________ Ron Kuehner _________________________ _________________________