Jiasoj Jdfljsdoi sl Configuration Approach State of Connecticut Core CT Project Salary Item Overview

Document Sample
Jiasoj Jdfljsdoi sl Configuration Approach State of Connecticut Core CT Project Salary Item Overview Powered By Docstoc
					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\6cb968bb-6a36-4057-b444-538a7720ffa9.doc
7/22/2011 4:03 PM                            Page 1 of 17
Jiasoj

Jdfljsdoi
                       sl
                               Configuration Approach
State of Connecticut
Core-CT Project
                               Salary




D:\Docstoc\Working\pdf\6cb968bb-6a36-4057-b444-538a7720ffa9.doc
7/22/2011 4:03 PM                            Page 2 of 17
Jiasoj

Jdfljsdoi
                       sl
                               Configuration Approach
State of Connecticut
Core-CT Project
                               Salary




D:\Docstoc\Working\pdf\6cb968bb-6a36-4057-b444-538a7720ffa9.doc
7/22/2011 4:03 PM                            Page 3 of 17
Jiasoj

Jdfljsdoi
                       sl
                               Configuration Approach
State of Connecticut
Core-CT Project
                               Salary




D:\Docstoc\Working\pdf\6cb968bb-6a36-4057-b444-538a7720ffa9.doc
7/22/2011 4:03 PM                            Page 4 of 17
Jiasoj

Jdfljsdoi
                       sl
                               Configuration Approach
State of Connecticut
Core-CT Project
                               Salary




D:\Docstoc\Working\pdf\6cb968bb-6a36-4057-b444-538a7720ffa9.doc
7/22/2011 4:03 PM                            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\6cb968bb-6a36-4057-b444-538a7720ffa9.doc
7/22/2011 4:03 PM                            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\6cb968bb-6a36-4057-b444-538a7720ffa9.doc
 7/22/2011 4:03 PM                            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\6cb968bb-6a36-4057-b444-538a7720ffa9.doc
 7/22/2011 4:03 PM                            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\6cb968bb-6a36-4057-b444-538a7720ffa9.doc
 7/22/2011 4:03 PM                            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\6cb968bb-6a36-4057-b444-538a7720ffa9.doc
 7/22/2011 4:03 PM                            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\6cb968bb-6a36-4057-b444-538a7720ffa9.doc
 7/22/2011 4:03 PM                            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\6cb968bb-6a36-4057-b444-538a7720ffa9.doc
 7/22/2011 4:03 PM                            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\6cb968bb-6a36-4057-b444-538a7720ffa9.doc
 7/22/2011 4:03 PM                            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\6cb968bb-6a36-4057-b444-538a7720ffa9.doc
 7/22/2011 4:03 PM                            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\6cb968bb-6a36-4057-b444-538a7720ffa9.doc
 7/22/2011 4:03 PM                            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\6cb968bb-6a36-4057-b444-538a7720ffa9.doc
7/22/2011 4:03 PM                            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\6cb968bb-6a36-4057-b444-538a7720ffa9.doc
7/22/2011 4:03 PM                            Page 17 of 17

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:18
posted:7/22/2011
language:English
pages:17
Description: Salary Increase Budget document sample