Get documents about "Employee Salary Increment Letter
Description
Employee Salary Increment Letter document sample
Document Sample
Jiasoj
Jdfljsdoi
sl
Configuration Approach
State of Connecticut
Core-CT Project
Salary
Item Overview:
Use the Salary Plan Default Values page to define default budget and salary increase plan control dates,
currency defaults, the salary increase method, eligibility dates, and salary increase effective date. Use the
default values you set up here when you define salary increase plans for employee groups. Use the Salary
Increase Matrix page to establish the minimum and maximum percentage increases permitted for each
review rating by position in range.
Menu Path:
Home / Administer Workforce / Plan Salaries (GBL) / Use / Salary Plan Default Values
Home / Administer Workforce / Plan Salaries (GBL) / Setup / Salary Increase Matrix Table
Home / Administer Workforce / Administer Workforce U.S. / Setup / Salary Plan Table
Home / Administer Workforce / Administer Workforce U.S. / Setup / Salary Grades Tables
Home / Administer Workforce / Plan Salaries (GBL) / Use / Salary Increase by Group
SAL_GRADE_TBL
SAL_PLAN_TBL
SAL_STEP_TBL
SAL_MATRIX_PCT
SAL_MATRIX_TBL
SAL_PLN_CONTROL
SAL_RATECD_TBL
D:\Docstoc\Working\pdf\f1c3a0c1-117d-4c41-a871-f9b3cb1f685a.doc
1/31/2011 11:26 AM Page 1 of 17
Jiasoj
Jdfljsdoi
sl
Configuration Approach
State of Connecticut
Core-CT Project
Salary
D:\Docstoc\Working\pdf\f1c3a0c1-117d-4c41-a871-f9b3cb1f685a.doc
1/31/2011 11:26 AM Page 2 of 17
Jiasoj
Jdfljsdoi
sl
Configuration Approach
State of Connecticut
Core-CT Project
Salary
D:\Docstoc\Working\pdf\f1c3a0c1-117d-4c41-a871-f9b3cb1f685a.doc
1/31/2011 11:26 AM Page 3 of 17
Jiasoj
Jdfljsdoi
sl
Configuration Approach
State of Connecticut
Core-CT Project
Salary
D:\Docstoc\Working\pdf\f1c3a0c1-117d-4c41-a871-f9b3cb1f685a.doc
1/31/2011 11:26 AM Page 4 of 17
Jiasoj
Jdfljsdoi
sl
Configuration Approach
State of Connecticut
Core-CT Project
Salary
D:\Docstoc\Working\pdf\f1c3a0c1-117d-4c41-a871-f9b3cb1f685a.doc
1/31/2011 11:26 AM Page 5 of 17
Jiasoj
Jdfljsdoi
sl
Configuration Approach
State of Connecticut
Core-CT Project
Salary
Record Information:
PS RECORD NAME RECORD NAME DESCRIPTION
SAL_GRADE_TBL Salary Grade Table This record is the reference table for salary
ranges.
SAL_PLAN_TBL Salary Administration This record is a reference table for Salary
Plan Table Administration Plans. Different plans may exist
in an organization based on geographical
location, currency, or company, to name a few.
Each plan would have its own salary ranges for
each salary grade.
SAL_STEP_TBL Salary Step Table This record is used to store the salary for each
step when multi-step grade is used. The control
flag for multi-step grade is found on the
Installation record. When it is set to 'Yes',
employees salaries are automatically set to the
one stored on this table for their Salary
Administration Plan, Grade, and Step.
SAL_MATRIX_PCT Salary Matrix Percent This is the record in which the acceptable
Table percentage ranges for salary increases are stored
for each rating and quartile through the salary
range. The quartile represents the position in
range calculated using the salary grade table.
SAL_MATRIX_TBL Salary Increase Matrix This record contains the identifier for each set of
Table salary increase guidelines. The name of the
matrix and what rating scale is used for the
ranges are kept in this table.
SAL_PLN_CONTROL Salary Plan Control This record is a control record for the Salary
Planning application. It contains information
regarding the budget period being planned and
the start date of the planning process.
SAL_RATECD_TBL Salary Rate Code Table This record associates the Salary Administration
Plan, Grade and Step with the appropriate
Compensation Rate Code.
Approach:
The State of Connecticut will be configuring several salary plans for each bargaining unit and will
populate these plans with existing negotiated values. Multiple pay plans for certain bargaining units
will continue to be required to address such differences as standard hours, length of school year,
trainee or working test period status, confidential exclusion of certain personnel and/or level of
educational achievement depending on individual bargaining unit contract terms.
Since there are only 4 characters allowed for salary plan names, it would be prudent to use the current
two letter designators (CL, CA, MP, VR, EX, etc.) or utilize the current bargaining unit 2 digit codes
as the first two characters and develop additional characters to indicate the standard hours.
D:\Docstoc\Working\pdf\f1c3a0c1-117d-4c41-a871-f9b3cb1f685a.doc
1/31/2011 11:26 AM Page 6 of 17
Jiasoj
Jdfljsdoi
sl
Configuration Approach
State of Connecticut
Core-CT Project
Salary
During the lifecycle of the HRMS implementation there will be many new contracts signed that affect
the entry of salary plans. Specifically, a new contract may result in entirely different salary amounts
at the plan, grade, and/or step level. Carol Sullivan will be the contact person for ensuring that the
Core-CT project team is abreast of any pending and final changes. She will work particularly with
OLR (as well as any other appropriate entity) to ensure that there are no major transition issues during
the go-live timeframe.
The State of Connecticut will not be using the Salary Matrix functionality or enabling the review
rating scales functionality as salary increases even for executive level personnel are not tied to
employee review process.
Part-time personnel who are not yet eligible for their first step increase (an annual increment in the
State of Connecticut‟s terminology) until after working the hourly equivalent of nine months of full-
time employment for that bargaining unit will continue to have their status manually reviewed
regularly by the Agency HR Specialist. The next annual increment date originally projected by the
Agency HR Specialist at the time of hire may need revision if the part-timer has routinely worked
more hours than the position was established for. Extra hours worked by a part-timer may also
change the projected probation date, which requires the part-timer to work the equivalent of six
months of full time employment before attaining permanency. Agency HR Specialists will need to be
reminded to examine both dates. Once the first step increase has been paid, future step increases for
the part-timer would be date based.
The State of Connecticut will not be using the Salary Planning application at the agency level as all
salary increases are driven by the collective bargaining process for unionized workers and by the
central control agencies for excluded personnel.
Higher Education (including the University of Connecticut, University of Connecticut Health Center
and the State Universities), Judicial, Legislative Management will be utilizing their legacy systems
for salary plan administration and will only enter certain data into Core-CT sufficient for the Office of
the State Comptroller to issue payroll checks.
Information Source:
The information for these tables should be gathered from the Department of Administrative Services
(DAS), the Office of Labor Relations (OLR) within the Office of Policy and Management, all other
union negotiation entities, and Office of the State Comptroller (OSC).
Data Entry Method:
_____ On-Line Pages
__X__Excel Spreadsheet
Fields on Record:
PS RECORD NAME/
PS FIELD NAME FIELD NAME DESCRIPTION
SAL_GRADE_TBL
SetID Required field of 5 uppercase characters. Prompt
SETID table: SETID_TBL_VLD_VW which use
D:\Docstoc\Working\pdf\f1c3a0c1-117d-4c41-a871-f9b3cb1f685a.doc
1/31/2011 11:26 AM Page 7 of 17
Jiasoj
Jdfljsdoi
sl
Configuration Approach
State of Connecticut
Core-CT Project
Salary
SET_CNTRL_REC and SETID_TBL. This
field will be set appropriately to one of the four
setid values that the State will use to differentiate
various salary plans. The four values that will b
used are; AGNCY, UNIVS, JUDCL, LEGMN
and SHARE.
Salary Administration Required field of 4 uppercase characters. Prompt
Plan table: SAL_PLAN_TBL Configure with the
name of the salary plan to which the grade
SAL_ADMIN_PLAN belongs.
Salary Grade Required field of 3 uppercase characters.
Configure with numbers 001 – XXX depending
on the number of the grade in the subject salary
GRADE plan.
Effective Date Required field of 10 characters in date format.
Defaults to system date, configure with date the
EFFDT Salary Plan is effective..
Status as of Effective Date XLAT. Required field of 1 uppercase character,
representing “Active” or “Inactive” status as of
effective date. Defaults to “A.” Accept the
EFF_STATUS default.
Description Required field of 30 mixed case characters
containing the long description of the salary
grade. Since the State of Connecticut does not
currently describe the grades, configure with the
name of the salary plan followed by the subject
DESCR grade number (such as CL 40 Hour – 001).
Short Description 10 mixed case characters containing the short
description of the salary – defaults to first 10
characters of DESCR. Make sure it is a
DESCRSHORT meaningful value.
Salary Matrix Code Prompt: SAL_MATRIX_TBL. The State of
Connecticut will not be using salary matrices so
SALARY_MATRIX_CD this field will not be configured.
Rating Scale Prompt: REVW_SCALE_TBL. Since the State
of Connecticut will not be tying employee salary
increases to review results via salary matrices,
RATING_SCALE this field will not be configured
Currency Code Prompt: CURRENCY_CD_TBL. Configure
CURRENCY_CD with “USD.”
Minimum Pay Rate- Accommodates 12 integers and 6 decimals.
Hourly Configure with the minimum hourly rate for the
MIN_RT_HOURLY described salary grade.
Midpoint Pay Rate-Hourly Accommodates 12 integers and 6 decimals.
System automatically calculates by adding the
MID_RT_HOURLY min and max and dividing by two.
D:\Docstoc\Working\pdf\f1c3a0c1-117d-4c41-a871-f9b3cb1f685a.doc
1/31/2011 11:26 AM Page 8 of 17
Jiasoj
Jdfljsdoi
sl
Configuration Approach
State of Connecticut
Core-CT Project
Salary
Maximum Pay Rate- Accommodates 12 integers and 6 decimals.
Hourly Configure with the maximum hourly rate for the
MAX_RT_HOURLY described salary grade.
Minimum Pay Rate- Accommodates 15 integers and 3 decimals.
Monthly System will automatically calculate based on the
MIN_RT_MONTHLY entries made in the hourly fields.
Midpoint Pay Rate- Accommodates 15 integers and 3 decimals.
Monthly System will automatically calculate based on the
MID_RT_MONTHLY entries made in the hourly fields.
Maximum Pay Rate- Accommodates 15 integers and 3 decimals.
Monthly System will automatically calculate based on the
MAX_RT_MONTHLY entries made in the hourly fields.
Minimum Pay Rate- Accommodates 15 integers and 3 decimals.
Annual System will automatically calculate based on the
MIN_RT_ANNUAL entries made in the hourly fields.
Midpoint Pay Rate-Annual Accommodates 15 integers and 3 decimals.
System will automatically calculate based on the
MID_RT_ANNUAL entries made in the hourly fields.
Maximum Pay Rate- Accommodates 15 integers and 3 decimals.
Annual System will automatically calculate based on the
MAX_RT_ANNUAL entries made in the hourly fields.
Step Increment Type XLAT. This field can be populated with 1 of 5
possible upper case character values. Choices
are: D for date based, E for either hours or date
based, H for hours based, M for manual based,
W for weeks based (USF only). Since the State
of Connecticut has a unique Salary Step increase
method, and has created a custom Salary Step
increase program, this value can be set to „M‟, as
STEP_INCREM_TYPE the delivered program will not be used.
Spec Accum for Step This functionality will not be used by the State of
Increments Connecticut due to the custom Salary Step
STEP_INCREM_ACCUM increase program. Leave Blank.
Minimum Pay Rate-Daily Accommodates 15 integers and 3 decimals.
Populate based on the entries made in the hourly
MIN_RT_DAILY fields.
Midpoint Pay Rate-Daily Populate based on the entries made in the hourly
MID_RT_DAILY fields.
Maximum Pay Rate-Daily Populate based on the entries made in the hourly
MAX_RT_DAILY fields.
Labor Agreement 6 uppercase characters to tie the relevant
collective bargaining agreement to a particular
salary grade. Prompt: EMPL_CTG. Field will
LABOR_AGREEMENT not be used – leave blank.
EMPL_CTG Employee Category The State of Connecticut doesn‟t categorize
D:\Docstoc\Working\pdf\f1c3a0c1-117d-4c41-a871-f9b3cb1f685a.doc
1/31/2011 11:26 AM Page 9 of 17
Jiasoj
Jdfljsdoi
sl
Configuration Approach
State of Connecticut
Core-CT Project
Salary
employees within bargaining units. Field will
not be used – leave blank.
Employee Subcategory The State of Connecticut doesn‟t categorize
employees within bargaining units. Field will not
be used by the State of Connecticut – leave
EMPL_CTG_L1 blank.
Employee Subcategory 2 The State of Connecticut doesn‟t categorize
employees within bargaining units. Field will not
be used by the State of Connecticut – leave
EMPL_CTG_L2 blank.
SALGRD_FED_SBR
Maximum Pay Rate- US Federal sub-record. Field will not be used by
GVT_MAX_RT_BIWK Biweekly the State of Connecticut – leave blank.
Midpoint Pay Rate- US Federal sub-record. Field will not be used by
GVT_MID_RT_BIWK Biweekly the State of Connecticut – leave blank.
Minimum Pay Rate- US Federal sub-record. Field will not be used by
GVT_MIN_RT_BIWK Biweekly the State of Connecticut – leave blank.
CAP_GRD_JPN_SBR
Grade Name Japanese sub-record. Field will not be used by
GRADE_TITLE_JPN the State of Connecticut – leave blank.
Minimum Required Years Japanese sub-record. Field will not be used by
MIN_YRS_GRADE the State of Connecticut – leave blank.
Maximum Years Japanese sub-record. Field will not be used by
MAX_YRS_GRADE the State of Connecticut – leave blank.
Minimum Age Japanese sub-record. Field will not be used by
MIN_GRD_AGE the State of Connecticut – leave blank.
Number of Years Japanese sub-record. Field will not be used by
REVIEW_COUNT the State of Connecticut – leave blank.
Required Eligibility Points Japanese sub-record. Field will not be used by
the State of Connecticut – leave blank.
ELIGIBILITY_POINTS
Regulatory Region Prompt from REG_STANDARD_VW. Select
REG_REGION “USA”
SAL_PLAN_TBL
SETID SetID Prompt field: SET_SAL_VLD_VW which uses
SET_CNTRL_REC and SETID_TBL. Required
field containing 5 uppercase characters. Default:
OPR_DEF_TBL_HR.SETID
SAL_ADMIN_PLAN Salary Administration Required field, configure with 4 uppercase
Plan characters. Each salary plan will be assigned a
unique value based on negotiated criteria as
described in approach above.
EFFDT Effective Date The Effective Date will default to the system
date. Required field. Default should be set to a
date that accounts for employee and job history.
D:\Docstoc\Working\pdf\f1c3a0c1-117d-4c41-a871-f9b3cb1f685a.doc
1/31/2011 11:26 AM Page 10 of 17
Jiasoj
Jdfljsdoi
sl
Configuration Approach
State of Connecticut
Core-CT Project
Salary
Configure for 1/1/1901.
EFF_STATUS Status as of Effective Date Xlat. Required field with values of “A” for
Active, “I” for Inactive. Default to “A”. Accept
the default
DESCR Description Configure with values that describe the salary
plan such as “NP-3 40 Hour Pay Plan” or “P3-B
Teacher 205.5 Da Pay Plan.” Required field,
allowing 30 mixed case characters.
DESCRSHORT Short Description Not required, will accommodate 10 mixed case
characters. Abbreviated values that describe the
salary plan such as “NP-3 40 H” or “P3-B
205.5.” Defaults to first 10 characters of DESCR.
Make sure it is a meaningful value
STD_HOURS Standard Hours Standard Hours for this salary plan. Required
field which will accept 4 integer and 2 decimal
characters. Configure for 35, 36.25, 37.5, 38.75
or 40 depending on the salary plan. Default:
OPR_DEF_TBL_HR.STD_HRS_DEFAULT
STD_HRS_FREQUENCY Standard Work Period Prompt Field: STDHRS_FREQ_VW. Use “W”
for weekly as this is the way the State of
Connecticut quotes its work schedules and names
its pay plans. Default:
OPR_DEF_TBL_HR.STD_HRS_FREQUENCY
CURRENCY_CD Currency Code Prompt Field: CURRENCY_CD_TBL. Default:
OPR_DEF_TBL_HR.EXCHNG_TO_CURREN
CY. Default to “USD”.
SALARY_MATRIX_CD Salary Matrix Code Prompt Field: SAL_MATRIX_TBL. Will not
use, leave blank.
RATING_SCALE Rating Scale Prompt Field: REVW_SCALE_TBL. Will not
use, leave blank.
COMPANY Company Prompt Field: COMPANY_TBL. Configure
with “CT” for all salary plans.
FREQ_ID_MONTHLY Monthly Frequency Prompt Field: MTH_FREQ_TBL_VW. Default
to “M” for Monthly.
FREQ_ID_DAILY Daily Frequency Prompt Field: DAY_FREQ_TBL_VW. Default
to “D” for Daily.
FREQ_ID_HOURLY Hourly Frequency Prompt Field: HOUR_FREQ_TBL_VW.
Default to “H” for Hourly.
AUTO_CALC_PREM_SW Auto Calculated Premium This field is for employees with complex salary
packages and does not apply to the State of
Connecticut‟s workforce. Leave blank.
CMP_RTCD_PREM_ABS Absorbing Premium This field is for employees with complex salary
packages and does not apply to the State of
Connecticut‟s workforce. Leave blank.
CMP_RTCD_PREM_NONA Non-Absorbing Premium This field is for employees with complex salary
D:\Docstoc\Working\pdf\f1c3a0c1-117d-4c41-a871-f9b3cb1f685a.doc
1/31/2011 11:26 AM Page 11 of 17
Jiasoj
Jdfljsdoi
sl
Configuration Approach
State of Connecticut
Core-CT Project
Salary
packages and does not apply to the State of
Connecticut‟s workforce. Leave blank.
SALPLN_FED_SBR Federal Sub-record that will not be used.
GVT_SAL_BASIS Salary Basis for Table Xlat. Fields on Federal sub-record that will not
Entry be used.
GVT_GEOG_SCOPE Geographic Scope of Plan Xlat. Fields on Federal sub-record that will not
be used.
GVT_NEXT_PAY_ADJ Government Next Fields on Federal sub-record that will not be
Scheduled Pay Adjustment used.
SALPLAN_GER_SBR German sub-record that will not be used.
TARIFF_GER Tariff Xlat. Fields on German sub-record that will not
be used.
TARIFF_AREA_GER Tariff Area Prompt Field: TARIFF_AREA_GER. Fields on
German sub-record that will not be used.
SP_ATTACH_SBR Salary Plan Attachment Sub-record. The State of
Connecticut will not be compiling attachments to
salary plans.
ATTACHSYSFILENAME Unique System file name The State of Connecticut will not be compiling
attachments to salary plans.
ATTACHUSERFILE Attached file The State of Connecticut will not be compiling
attachments to salary plans.
URL_ID URL identifier The State of Connecticut will not be compiling
attachments to salary plans.
DESCR254 Long description The State of Connecticut will not be compiling
attachments to salary plans.
ADDED_BY Added by The State of Connecticut will not be compiling
attachments to salary plans.
ADDED_DT Date added The State of Connecticut will not be compiling
attachments to salary plans.
Standard Days Per Year Custom field in which standard days per year for
Department of Education Vocational Instructors
(or other employees who are docked at a
different rate than they are paid) will be stored in
order to dock them correctly for unpaid absences.
CT_STND_DAYS Accommodates 3 integers.
SAL_STEP_TBL
SetID Required field of 5 upper case characters.
Prompt table: SET_SAL_VLD_VW. Default
SETID value: OPR_DEF_TBL_HR.SETID
Salary Administration Required field of 4 upper case characters.
SAL_ADMIN_PLAN Plan Prompt table: SAL_PLAN_TBL
Salary Grade Required field of 3 upper case characters (though
all examples appear as 3 numbers which would
be the method preferred by the State of
GRADE Connecticut as that is our current method).
D:\Docstoc\Working\pdf\f1c3a0c1-117d-4c41-a871-f9b3cb1f685a.doc
1/31/2011 11:26 AM Page 12 of 17
Jiasoj
Jdfljsdoi
sl
Configuration Approach
State of Connecticut
Core-CT Project
Salary
Prompt table: SAL_GRADE_TBL. Configure
with the appropriate grade number (salary group
number in State of Connecticut parlance) from
existing salary plans, usually not exceeding 43
grades per salary plan.
Effective Date Required field of 10 characters in date format.
Defaults to system date, configure with
EFFDT 01/01/1901.
Step Required field of 2 numbers. Configure with
appropriate step numbers from existing salary
plans, usually not exceeding 14 steps per salary
STEP grade in the executive branch agencies.
Currency Code Prompt: CURRENCY_CD_TBL. Configure
CURRENCY_CD with “USD.”
Hourly Rate Hourly rate for the step, numerical format
accommodating 12 integers and 6 decimals.
Configure from hourly step values from existing
HOURLY_RT pay plans.
Monthly Rate Numerical format accommodating 15 integers
and 3 decimals. Populate based on Annual Rate
MONTHLY_RT divided by 12.
Annual Rate Accommodates 15 integers and 3 decimals.
Configure with annual step values from existing
ANNUAL_RT pay plans.
Months to Next Step Accommodates 3 numbers. Field will not be
INCREM_MONTHS Increment used, leave blank.
Hours to Next Step Accommodates 5 integers and 2 decimals. Field
INCREM_HOURS Increment will not be used, leave blank.
Daily Rate Accommodates 15 integers and 3 decimals.
Configure with the daily rates for each step from
DAILY_RT current pay plans.
SALSTP_FED_SBR US Federal sub-record. – will not be used.
GVT_BIWEEKLY_RT Biweekly Rate US Federal sub-record. – will not be used.
Days to Next Step US Federal sub-record. – will not be used.
GVT_INCREM_DAYS Increment
Weeks to Next Step US Federal sub-record. – will not be used.
GVT_INCREM_WEEKS Increment
GVT_STEP US Federal Step US Federal sub-record. – will not be used.
US Federal WGI US Federal sub-record. – will not be used.
GVT_WGI_ADJ Adjustment
SALSTP_AUS_SBR Australian sub-record – will not be used.
CLASSN_CURRENT_AUS Aus Job Classification Australian sub-record – will not be used.
Aus Minimum Australian sub-record – will not be used.
APS_MIN_CLS_AUS Classification
APS_MAX_CLS_AUS Aus Maximum Australian sub-record – will not be used.
D:\Docstoc\Working\pdf\f1c3a0c1-117d-4c41-a871-f9b3cb1f685a.doc
1/31/2011 11:26 AM Page 13 of 17
Jiasoj
Jdfljsdoi
sl
Configuration Approach
State of Connecticut
Core-CT Project
Salary
Classification
Step Description Accommodates 30 mixed characters wherein the
step can be described. Populate with Step 1, Step
2, Step 3 etc. so descrs will appear throughout
STEP_DESCR the system and on reports.
SAL_MATRIX_PCT The State of Connecticut will not be using the
salary matrix functionality as salary increases are
not automatically tied to employee reviews.
SETID SetID Will not be using – leave blank.
SALARY_MATRIX_CD Salary Matrix Code Will not be using – leave blank.
EFFDT Effective Date Will not be using – leave blank.
REVIEW_RATING Review Rating Will not be using – leave blank.
Below Minimum Will not be using – leave blank.
BELOW_MINIMUM_MIN Minimum Increase
Below Minimum Will not be using – leave blank.
BELOW_MINIMUM_MAX Maximum Increase
QUARTILE1_MIN First Quartile Minimum Will not be using – leave blank.
QUARTILE1_MAX First Quartile Maximum Will not be using – leave blank.
QUARTILE2_MIN Second Quartile Minimum Will not be using – leave blank.
Second Quartile Will not be using – leave blank.
QUARTILE2_MAX Maximum
QUARTILE3_MIN Third Quartile Minimum Will not be using – leave blank.
QUARTILE3_MAX Third Quartile Maximum Will not be using – leave blank.
QUARTILE4_MIN Fourth Quartile Minimum Will not be using – leave blank.
QUARTILE4_MAX Fourth Quartile Maximum Will not be using – leave blank.
SAL_MATRIX_TBL The State of Connecticut will not be using the
salary matrix functionality as salary increases are
not automatically tied to employee reviews.
SETID SetID Will not be using – leave blank.
SALARY_MATRIX_CD Salary Matrix Code Will not be using – leave blank.
EFFDT Effective Date Will not be using – leave blank.
EFF_STATUS Status as of Effective Date Will not be using – leave blank.
DESCR Description Will not be using – leave blank.
DESCRSHORT Short Description Will not be using – leave blank.
RATING_SCALE Rating Scale Will not be using – leave blank.
Salary Planning and Budgeting will not occur in
SAL_PLAN_CONTROL Core-CT HRMS.
CONTROL_ID Plan Default ID Will not be using – leave blank.
BUDGET_START_DT Budget Period Start Date Will not be using – leave blank.
BUDGET_END_DT Budget Period End Date Will not be using – leave blank.
SAL_PLAN_START_DT Salary Plan Start Date Will not be using – leave blank.
Employee Anniversary Will not be using – leave blank.
ANNIVERSARY_SW Raises
NEW_HIRE_ELIG_DT New Hire Eligibility Date Will not be using – leave blank.
D:\Docstoc\Working\pdf\f1c3a0c1-117d-4c41-a871-f9b3cb1f685a.doc
1/31/2011 11:26 AM Page 14 of 17
Jiasoj
Jdfljsdoi
sl
Configuration Approach
State of Connecticut
Core-CT Project
Salary
SAL_PLAN_EFFDT Salary Plan Effective Date Will not be using – leave blank.
CURRENCY_CD Currency Code Will not be using – leave blank.
EXCHNG_TO_RT_TYPE Currency Rate Type Will not be using – leave blank.
FREQUENCY_ID Frequency ID Will not be using – leave blank.
SALPCTL_MEX_SBR Mex Sal Percentile Mexican sub-record – leave blank.
Mex Increment Budget Mexican sub-record – leave blank.
USE_MATRIX_MEX Rec
SAL_RATECD_TBL
SetID Required field of 5 characters. Prompt table:
SET ID_TBL. Default:
OPR_DEF_TBL_HR.SETID. Will be
configured with one of five values: AGNCY,
SETID UNIVS, JUDCL, LEGMN or SHARE.
Salary Administration Required field of 4 uppercase characters. Prompt
Plan table: SAL_PLAN_TBL. Configure with the
name of the salary plan to which the grade and
SAL_ADMIN_PLAN step belong.
Salary Grade Required field of 3 uppercase characters.
Configure with numbers 001 – XXX depending
on the number of the grade in the subject salary
GRADE plan.
Effective Date Required field of 10 characters in date format.
Defaults to system date, configure with effective
EFFDT date of subject salary plan.
Step Required field of 2 numbers. Configure with
appropriate step numbers from existing salary
plans, usually not exceeding 14 steps per salary
STEP grade in the executive branch agencies.
Compensation Eff Accommodates 3 numbers. Configure with 0.
COMP_EFFSEQ Sequence
Comp Rate Code Required field of 6 uppercase characters.
Prompt: BASE_RATECD_VW. Configure with
COMP_RATECD „CTBASE.‟
Dependencies and Timing:
The Company, Union, Business Unit, Setid, Regulatory, and Job Code Tables will be configured
prior to the Salary Plan, Grade and Step Tables.
Testing Considerations
Test that the automatic calculations for minimum, midpoint and maximum for a sampling of
salary grades are correctly computed.
Verify that the Standard Days per Year field on the Salary Plan table is only populated for those
plans that dock at a different rate than employees are paid.
Assumptions:
D:\Docstoc\Working\pdf\f1c3a0c1-117d-4c41-a871-f9b3cb1f685a.doc
1/31/2011 11:26 AM Page 15 of 17
Jiasoj
Jdfljsdoi
sl
Configuration Approach
State of Connecticut
Core-CT Project
Salary
The State of Connecticut will have one company code, “CT.”
The State of Connecticut will have five setids: AGNCY, UNIVS, JUDCL, LEGMN and
SHARE.
Incumbents in per diem job codes such as State School Substitute Teacher will have their Job
compensation frequency set to Daily. It is assumed that incumbents in per diem job codes will
continue to receive their daily rate even when they do not work a full day just as they do in the
legacy system.
The bi-weekly rate will be reflected in the Compensation Rate Code record for each Salary Step
table record. See the Compensation Rate Code Configuration Work Unit for details.
The Agency HR Specialist will continue to manually monitor the Employment annual increment
eligibility date for part-time employees just they do in the legacy system.
Only those salary plans on which an employee is docked at a different rate than they are paid will
have the appropriate number of days entered in the custom Standard Days per Year field on the
Salary Plan Table.
The State of Connecticut will not be enabling the salary planning and budgeting functionality.
Revisions:
Date:
Comments:
Name:
Changes Needed:
Reasons:
Input Provided By:
Name Title, Department
Carol Sullivan Personnel Manager, Department of Correction
Ron Kinney University Director, UCHC
Ryan Oakes Configuration Team Lead, Accenture
Lisa Lagus HR Module Team Lead, Accenture
Lina Simonu HR Team Lead, DAS
D:\Docstoc\Working\pdf\f1c3a0c1-117d-4c41-a871-f9b3cb1f685a.doc
1/31/2011 11:26 AM Page 16 of 17
Jiasoj
Jdfljsdoi
sl
Configuration Approach
State of Connecticut
Core-CT Project
Salary
SIGNOFFS
Configuration Team
_________________________ _________________________
_________________________ _________________________
Configuration Team Leads
_________________________ _________________________
Ryan Oakes Ron Kuehner
Module Team Leads
_________________________ _________________________
Team Leads
_________________________ _________________________
Rajeev Sharma Anne North
_________________________
Sue Martin
D:\Docstoc\Working\pdf\f1c3a0c1-117d-4c41-a871-f9b3cb1f685a.doc
1/31/2011 11:26 AM Page 17 of 17
