This page (revision-39) was last changed on 26-Nov-2021 10:22 by kparrott

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
39 26-Nov-2021 10:22 13 KB kparrott to previous
38 26-Nov-2021 10:22 13 KB kparrott to previous | to last
37 26-Nov-2021 10:22 13 KB jmyers to previous | to last WORK_RULE_CODE ==> WORK_RULE (Field)
36 26-Nov-2021 10:22 13 KB jmyers to previous | to last
35 26-Nov-2021 10:22 13 KB JMyers to previous | to last
34 26-Nov-2021 10:22 13 KB JMyers to previous | to last
33 26-Nov-2021 10:22 16 KB JEscott to previous | to last
32 26-Nov-2021 10:22 16 KB JMyers to previous | to last
31 26-Nov-2021 10:22 16 KB JEscott to previous | to last
30 26-Nov-2021 10:22 16 KB JEscott to previous | to last
29 26-Nov-2021 10:22 16 KB JEscott to previous | to last
28 26-Nov-2021 10:22 16 KB JMyers to previous | to last
27 26-Nov-2021 10:22 16 KB JMyers to previous | to last
26 26-Nov-2021 10:22 16 KB JMyers to previous | to last
25 26-Nov-2021 10:22 16 KB JMyers to previous | to last
24 26-Nov-2021 10:22 16 KB JMyers to previous | to last
23 26-Nov-2021 10:22 16 KB JMyers to previous | to last
22 26-Nov-2021 10:22 16 KB JMyers to previous | to last
21 26-Nov-2021 10:22 16 KB JMyers to previous | to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 43 changed 20 lines
Wage Step Rule
The wage step rule determines the way that automatic step increases will be applied. The field of rate step rule is an LOV (List of Values); the list of rate step rules that is created for this field will be given further definition/rules in Salary Administration training.
Rate_Step_Rule_Code from P2K_SA_WAGE_STEP_RULES is an optional 16-character alphanumeric field.
Fulltime Wage
If the FTE indicated in the Work Arrangement area is less than 1.00, this toggle will indicate if the displayed salary or wage should be converted to a Full Time Equivalent factor (FTE).
The FTE is defined on several forms such as Maintain Positions (IDPS) or Maintain Assignments (IEAS).
Suppose an employee has an FTE of 0.5 and the wage rate indicated is $4,000. If the toggle is OFF, this means that the employee will actually receive the full $4,000.
If the toggle is turned ON, the displayed salary or wage is the 1.00 Full Time Equivalent amount. This means that in this case, where the FTE is 0.5, the employee will receive $2,000.
Use_FTE_Wages is an optional toggle field.
Enable OE Elections
Define Groups (IDGR) - Work Rules
Work Rule
Work rules are used to determine standard payroll processing information required to create pay headers and transactions for an employee.
Work_Rule_Code from P2K_CM_WORK_RULES is a 16-character alphanumeric mandatory field.
Work Rules are defined on the IDWR form and will be discussed further during Basic Salary Administration training.
If the work rule is specified and has the following defined on the IDWR form:
Std Hrs/Day,
Std Hrs/Week, and
Std Hrs/ Pay
;[Wage Step Rule|RATE_STEP_RULE_CODE]:The wage step rule determines the way that automatic step increases will be applied. The field of rate step rule is an LOV (List of Values); the list of rate step rules that is created for this field will be given further definition/rules in Salary Administration training. Rate_Step_Rule_Code from P2K_SA_WAGE_STEP_RULES is an optional 16-character alphanumeric field.
;[Fulltime Wage|USE_FTE_WAGES]: If the FTE indicated in the Work Arrangement area is less than 1.00, this toggle will indicate if the displayed salary or wage should be converted to a Full Time Equivalent factor (FTE). The FTE is defined on several forms such as Maintain Positions (IDPS) or Maintain Assignments (IEAS). Suppose an employee has an FTE of 0.5 and the wage rate indicated is $4,000. If the toggle is OFF, this means that the employee will actually receive the full $4,000. If the toggle is turned ON, the displayed salary or wage is the 1.00 Full Time Equivalent amount. This means that in this case, where the FTE is 0.5, the employee will receive $2,000. Use_FTE_Wages is an optional toggle field.
;[Enable OE Elections|]
!!Define Groups (IDGR) - Work Rules
;[Work Rule|WORK_RULE_CODE]:Work rules are used to determine standard payroll processing information required to create pay headers and transactions for an employee. Work_Rule_Code from P2K_CM_WORK_RULES is a 16-character alphanumeric mandatory field.
Work Rules are defined on the IDWR form and will be discussed further during Basic Salary Administration training. If the work rule is specified and has the following defined on the IDWR form:
*Std Hrs/Day,
*Std Hrs/Week, and
*Std Hrs/ Pay
At line 64 changed 31 lines
Std Hrs/Day
This field shows the standard hours in a normal work day.
You may accept the default Std Hrs/Day from the work rule or manually override it.
Std_Hours_Per_Day is an optional numeric field.
Std Hrs/Week
This field shows the standard hours in a normal work week.
You may accept the default Std Hrs/Week from the work rule or manually override it.
Std_Hours_Per_Week is an optional numeric field.
Std Hrs/Pay
This field shows the standard hours in a regular pay period.
You may accept the default Std Hrs/Pay from the work rule or manually override it.
Std_Hours_Per_Pay is an optional numeric field.
Payment Method
Payment method is used to define the default payment method for this group during the pay cycle. The employee may override Payment Method at timesheet level (see Payment Method in the Payroll manual.)
Pay_By_Check is an optional fixed lexicon (X_PAY_BY_METHOD).
Payroll
This field shows the payroll in which this group will be processed. May be completed during Payroll Training.
Payroll_Code from P2K_PR_PAYROLLS is an optional field.
Payroll codes will be discussed further during Payroll training.
This next section can be completed during Payroll and Payroll Advanced Training.
FLSA Hours
This field shows the base hours after which the FLSA calculation will begin.
FLSA_Hours is an optional numeric field.
FLSA Factor
This field shows the rate at which hours over the base need to be paid.
FLSA_Factor is an optional numeric field.
FLSA User Calc
If a UserCalc is needed to enhance the FLSA process it needs to be indicated here.
USER_CALC_Code from P2K_AM_USER_CALCS is an optional 16-character alphanumeric field.
FLSA Calendar
If FLSA is to be calculated over more than 7 days, a calendar must be set up to define the cycle.
;[Std Hrs/Day|STD_HOURS_PER_DAY]:This field shows the standard hours in a normal work day. You may accept the default Std Hrs/Day from the work rule or manually override it. Std_Hours_Per_Day is an optional numeric field.
;[Std Hrs/Week|STD_HOURS_PER_WEEK]: This field shows the standard hours in a normal work week. You may accept the default Std Hrs/Week from the work rule or manually override it.Std_Hours_Per_Week is an optional numeric field.
;[Std Hrs/Pay|STD_HOURS_PER_PAY]: This field shows the standard hours in a regular pay period. You may accept the default Std Hrs/Pay from the work rule or manually override it. Std_Hours_Per_Pay is an optional numeric field.
;[Payment Method|PAY_BY_CHECK]: Payment method is used to define the default payment method for this group during the pay cycle. The employee may override Payment Method at timesheet level (see Payment Method in the Payroll manual.) Pay_By_Check is an optional fixed lexicon (X_PAY_BY_METHOD).
;[Payroll|PAYROLL_CODE]:This field shows the payroll in which this group will be processed. May be completed during Payroll Training. Payroll_Code from P2K_PR_PAYROLLS is an optional field.
;[FLSA Hours|FLSA_HOURS]:This field shows the base hours after which the FLSA calculation will begin. FLSA_Hours is an optional numeric field.
;[FLSA Factor|FLSA_FACTOR]: This field shows the rate at which hours over the base need to be paid. FLSA_Factor is an optional numeric field.
;[FLSA User Calc|USER_CALC_CODE]: If a UserCalc is needed to enhance the FLSA process it needs to be indicated here. USER_CALC_Code from P2K_AM_USER_CALCS is an optional 16-character alphanumeric field.
;[FLSA Calendar|CALENDAR_CODE]: If FLSA is to be calculated over more than 7 days, a calendar must be set up to define the cycle.
At line 96 changed 31 lines
Accrual Method
The GL accrual method determines how to derive the accrual factor used in calculating end-of-month payroll accruals in the Payroll GL Process (UPGL).
The ‘Calendar Days’ method calculates the payroll accrual factor by dividing the number of calendar days that have not been accounted for in the month by the number of calendar days in a standard pay period.
The ‘Working Days’ method calculates the payroll accrual factor by dividing the number of working days that have not been accounted for in the month by the number of working days in a standard pay period.
Accrual_Method is an optional fixed lexicon (X_ACCRUAL_METHOD).
GL Fund User Calc
GL Fund User Calc indicates the user calc which will be used to calculate 'Balance To Complete' for the funds that are paid for employees of this group. This may be overridden at each individual fund level, on the IDGF screen.
Define Groups (IDGR) - Registrations
In the Registration tab you must define all levels of government registrations according to the Government Registrations on IDGV form. When an employee is paid under this group, all government reporting for the employee will be reported according to the registrations identified on this tab.
Fed Regist Set
This field allows you to set up the Federal Registrations sets which will allow you to define one or multiple registrations at the federal level.
You would most likely set up one government registration set on the IDGV form unless your company has multiple registrations with the government. For multiple government registrations, you may set up either different registrations sets or different registration types for registration set.
Govt_Regist_Set from P2K_CM_GOVT_REGIST_SETS is a 16-character alphanumeric mandatory field.
Fed Regist Type
For each registration set at the federal level, you can set up from 1 to 9 federal registration numbers. This field indicates the Federal Registration to which this group belongs.
e.g. US Fed Regist 1, US Fed Regist 2 .............… up to US Fed Regist 9
Cdn Fed Regist 1, Cdn Fed Regist 2 ........…. up to Cdn Fed Regist 9
Fed_Regist_Type is a mandatory fixed lexicon (X_GOVT_REGIST_TYPE) that you may use to look up the value.
Fed Regist #
This value in this field is defaulted from the IDGV form once the Fed Regist Set and Fed Regist Type fields are completed. You will not be able to alter this information directly from this screen.
This Fed Regist # is stored in GOVT_REGIST_NUMBER of the group.
W2 Emp Type
For US Quarterly and Year End Reporting, your are required to report to the USA government if the employee's type of employment is one of the following:
Regular
Agriculture
Household
Military
Medicare Qualified
Railroad
;[Accrual Method|ACCRUAL_METHOD]: The GL accrual method determines how to derive the accrual factor used in calculating end-of-month payroll accruals in the Payroll GL Process (UPGL). The ‘Calendar Days’ method calculates the payroll accrual factor by dividing the number of calendar days that have not been accounted for in the month by the number of calendar days in a standard pay period. The ‘Working Days’ method calculates the payroll accrual factor by dividing the number of working days that have not been accounted for in the month by the number of working days in a standard pay period. Accrual_Method is an optional fixed lexicon (X_ACCRUAL_METHOD).
;[GL Fund User Calc| ]:GL Fund User Calc indicates the user calc which will be used to calculate 'Balance To Complete' for the funds that are paid for employees of this group. This may be overridden at each individual fund level, on the IDGF screen.
!!Define Groups (IDGR) - Registrations
In the Registration tab you must define all levels of government registrations according to the Government Registrations on IDGV form. When an employee is paid under this group, all government reporting for the employee will be reported according to the registrations identified on this tab.\\
\\
;[Fed Regist Set|GOVT_REGIST_SET]: This field allows you to set up the Federal Registrations sets which will allow you to define one or multiple registrations at the federal level. You would most likely set up one government registration set on the IDGV form unless your company has multiple registrations with the government. For multiple government registrations, you may set up either different registrations sets or different registration types for registration set. Govt_Regist_Set from P2K_CM_GOVT_REGIST_SETS is a 16-character alphanumeric mandatory field.
;[Fed Regist Type|FED_REGIST_TYPE]: For each registration set at the federal level, you can set up from 1 to 9 federal registration numbers. This field indicates the Federal Registration to which this group belongs.
e.g. US Fed Regist 1, US Fed Regist 2 .............… up to US Fed Regist 9
Cdn Fed Regist 1, Cdn Fed Regist 2 ........…. up to Cdn Fed Regist 9
Fed_Regist_Type is a mandatory fixed lexicon (X_GOVT_REGIST_TYPE) that you may use to look up the value.
;[Fed Regist #|GOVT_REGIST_NUMBER]: This value in this field is defaulted from the IDGV form once the Fed Regist Set and Fed Regist Type fields are completed. You will not be able to alter this information directly from this screen. This Fed Regist # is stored in GOVT_REGIST_NUMBER of the group.
;[W2 Emp Type|W2_EMPLOYMENT_TYPE]: For US Quarterly and Year End Reporting, your are required to report to the USA government if the employee's type of employment is one of the following:
*Regular
*Agriculture
*Household
*Military
*Medicare Qualified
*Railroad
At line 129 changed 12 lines
CDN EI Rate
In Canada, if an employer belongs to a specific Labor Wage Loss plan that qualifies them to pay a lower ‘Employment Insurance Employer’ rate, then the government will issue the Reduced EI rate to that employer and may assign the employer a different Business Number.
If a secondary Business Number is assigned, then you must set up that number on the IDGV form. If only the EI Reduced Rate is assigned, then you may enter that rate on either the IDGR or IDGV form.
The Cdn EI rate defined on IDGR overrides the Cdn EI Reduced Rate registration defined on IDGV.
CDN_EI_Reduced_Rate is an optional numeric field.
State/Prov Regist Set
This field allows you to set up State and Provincial Registrations sets that allow you to define one or multiple registrations at the state and provincial level.
You would most likely set up one government registration set on the IDGV form unless your company has multiple registrations with the government. For multiple government registrations, you may set up either different registrations sets or different registration types for registration set.
The State/Prov Regist Set may be the same or different than the Fed Regist Set.
Govt_Regist_Set from P2K_CM_GOVT_REGIST_SETS is a 16-character alphanumeric mandatory field.
State Regist Type
For each registration set at the state and provincial level, you can set up from 1 to 9 state/provincial registration numbers. This field indicates the State/Prov Registration to which this group belongs.
;[CDN EI Rate|CDN_EI_REDUCED_RATE]: In Canada, if an employer belongs to a specific Labor Wage Loss plan that qualifies them to pay a lower ‘Employment Insurance Employer’ rate, then the government will issue the Reduced EI rate to that employer and may assign the employer a different Business Number. If a secondary Business Number is assigned, then you must set up that number on the IDGV form. If only the EI Reduced Rate is assigned, then you may enter that rate on either the IDGR or IDGV form.
The Cdn EI rate defined on IDGR overrides the Cdn EI Reduced Rate registration defined on IDGV. CDN_EI_Reduced_Rate is an optional numeric field.
;[State/Prov Regist Set|GOVT_REGIST_SET]: This field allows you to set up State and Provincial Registrations sets that allow you to define one or multiple registrations at the state and provincial level. You would most likely set up one government registration set on the IDGV form unless your company has multiple registrations with the government. For multiple government registrations, you may set up either different registrations sets or different registration types for registration set.
The State/Prov Regist Set may be the same or different than the Fed Regist Set. Govt_Regist_Set from P2K_CM_GOVT_REGIST_SETS is a 16-character alphanumeric mandatory field.
;[State Regist Type|STATE_REGIST_TYPE]: For each registration set at the state and provincial level, you can set up from 1 to 9 state/provincial registration numbers. This field indicates the State/Prov Registration to which this group belongs.
At line 143 changed 21 lines
State_Regist_Type is a mandatory fixed lexicon (X_GOVT_REGIST_TYPE).
Unlike the federal registration, IDGR will not retrieve and display the State/Prov Registration # after the State/Prov Regist Set and Regist Type are entered. This is because each group can have multiple employees who work and live in many State/Provinces. The actual State/Province Registration number will be retrieved by the Quarterly or Year End reports when the report is run.
Local Regist Set
This field allows you to set up Local Registrations sets that allow you to define one or multiple registrations at the local level.
In US, you must enter the appropriate Govt. Regist Set defined on the IDGV form.
In Canada, although there is currently no Local reporting at this moment, you should set this field to the same government registration set as defined for the Federal Regist Set for future expansion.
Govt_Regist_Set from P2K_CM_GOVT_REGIST_SETS is a 16-character alphanumeric mandatory field.
Local Regist Type
For each registration set at the local level, you can set up from 1 to 9 local registration numbers. This field indicates the Local Registration to which this group belongs.
eg US Local Regist 1, US Local Regist 2 ........… up to US Local Regist 9
In Canada, although there is currently no Local reporting at this moment, you should enter ‘Cdn Loc - N/A’ in this field for future expansion.
Local_Regist_Type is a mandatory fixed lexicon (X_GOVT_REGIST_TYPE).
Unlike the federal registration, IDGR will not retrieve and display the Local Registration # after the Local Regist Set and Regist Type are entered. This is because each group can be associated with many employees who work and live in many States. The actual Local Registration number will be retrieved by the Quarterly or Year End reports when the report is run.
WC Regist Type
This field will indicates the WC Registration type for htis group. The type and the employee’s state/province will determine the WC Clsses and WC Rates the employee receives. For this reason, a group can only belong to one WC Resigstration type.
WC_Regist_Type is an optional field which you may complete with a value from the fixed lexicon X_WC_REGIST_TYPE.
Define Groups (IDGR) - Allocations and Elements
State_Regist_Type is a mandatory fixed lexicon (X_GOVT_REGIST_TYPE). Unlike the federal registration, IDGR will not retrieve and display the State/Prov Registration # after the State/Prov Regist Set and Regist Type are entered. This is because each group can have multiple employees who work and live in many State/Provinces. The actual State/Province Registration number will be retrieved by the Quarterly or Year End reports when the report is run.
;[Local Regist Set|GOVT_REGIST_SET]: This field allows you to set up Local Registrations sets that allow you to define one or multiple registrations at the local level. In US, you must enter the appropriate Govt. Regist Set defined on the IDGV form.
In Canada, although there is currently no Local reporting at this moment, you should set this field to the same government registration set as defined for the Federal Regist Set for future expansion. Govt_Regist_Set from P2K_CM_GOVT_REGIST_SETS is a 16-character alphanumeric mandatory field.
;[Local Regist Type|LOCAL_REGIST_TYPE]: For each registration set at the local level, you can set up from 1 to 9 local registration numbers. This field indicates the Local Registration to which this group belongs.
eg US Local Regist 1, US Local Regist 2 ........… up to US Local Regist 9
In Canada, although there is currently no Local reporting at this moment, you should enter ‘Cdn Loc - N/A’ in this field for future expansion. Local_Regist_Type is a mandatory fixed lexicon (X_GOVT_REGIST_TYPE). Unlike the federal registration, IDGR will not retrieve and display the Local Registration # after the Local Regist Set and Regist Type are entered. This is because each group can be associated with many employees who work and live in many States. The actual Local Registration number will be retrieved by the Quarterly or Year End reports when the report is run.
;[WC Regist Type|WC_REGIST_TYPE]: This field will indicates the WC Registration type for htis group. The type and the employee’s state/province will determine the WC Clsses and WC Rates the employee receives. For this reason, a group can only belong to one WC Resigstration type. WC_Regist_Type is an optional field which you may complete with a value from the fixed lexicon X_WC_REGIST_TYPE.
!!Define Groups (IDGR) - Allocations and Elements