Docstoc

Salary Increment Format - DOC

Document Sample
Salary Increment Format - DOC 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




C:\Docstoc\Working\pdf\8ac885f8-26cf-46cb-bedd-fa35d4dba4b9.doc
7/22/2011 4:09 PM                              Page 1 of 17
Jiasoj

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




C:\Docstoc\Working\pdf\8ac885f8-26cf-46cb-bedd-fa35d4dba4b9.doc
7/22/2011 4:09 PM                              Page 2 of 17
Jiasoj

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




C:\Docstoc\Working\pdf\8ac885f8-26cf-46cb-bedd-fa35d4dba4b9.doc
7/22/2011 4:09 PM                              Page 3 of 17
Jiasoj

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




C:\Docstoc\Working\pdf\8ac885f8-26cf-46cb-bedd-fa35d4dba4b9.doc
7/22/2011 4:09 PM                              Page 4 of 17
Jiasoj

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




C:\Docstoc\Working\pdf\8ac885f8-26cf-46cb-bedd-fa35d4dba4b9.doc
7/22/2011 4:09 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.

C:\Docstoc\Working\pdf\8ac885f8-26cf-46cb-bedd-fa35d4dba4b9.doc
7/22/2011 4:09 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

 C:\Docstoc\Working\pdf\8ac885f8-26cf-46cb-bedd-fa35d4dba4b9.doc
 7/22/2011 4:09 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.

 C:\Docstoc\Working\pdf\8ac885f8-26cf-46cb-bedd-fa35d4dba4b9.doc
 7/22/2011 4:09 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


 C:\Docstoc\Working\pdf\8ac885f8-26cf-46cb-bedd-fa35d4dba4b9.doc
 7/22/2011 4:09 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.


 C:\Docstoc\Working\pdf\8ac885f8-26cf-46cb-bedd-fa35d4dba4b9.doc
 7/22/2011 4:09 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


 C:\Docstoc\Working\pdf\8ac885f8-26cf-46cb-bedd-fa35d4dba4b9.doc
 7/22/2011 4:09 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).


 C:\Docstoc\Working\pdf\8ac885f8-26cf-46cb-bedd-fa35d4dba4b9.doc
 7/22/2011 4:09 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.


 C:\Docstoc\Working\pdf\8ac885f8-26cf-46cb-bedd-fa35d4dba4b9.doc
 7/22/2011 4:09 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.


 C:\Docstoc\Working\pdf\8ac885f8-26cf-46cb-bedd-fa35d4dba4b9.doc
 7/22/2011 4:09 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:


 C:\Docstoc\Working\pdf\8ac885f8-26cf-46cb-bedd-fa35d4dba4b9.doc
 7/22/2011 4:09 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




C:\Docstoc\Working\pdf\8ac885f8-26cf-46cb-bedd-fa35d4dba4b9.doc
7/22/2011 4:09 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




C:\Docstoc\Working\pdf\8ac885f8-26cf-46cb-bedd-fa35d4dba4b9.doc
7/22/2011 4:09 PM                             Page 17 of 17

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:575
posted:7/22/2011
language:English
pages:17
Description: Salary Increment Format document sample