Table of Contents
GROUP INTERFACE FILE#
The Group Interface File screen is used to import groups codes into the software data structures.
Group Interface File data is maintained on the INF_CV_GROUPS table.
Description#
- Entity
- This field displays the entity to which the group belongs.
- Unit
- This field displays the unit to which the group belongs.
- Group
- This field holds a user-defined code that uniquely identifies the group to the organization.
- Standing
- Standing is used to indicate whether the record is active, frozen or obsolete. Active will default.
- Change Reason
- This field displays the ‘Change Reason’ code, which provides the rationale as to why information has been created or changed as of an effective date.
- Employment Status
- The initial employment status describes the condition of an employee’s employment with the organization when hired into a group.
- Ended as Status
- The ending employment status describes the condition of an employee’s employment with the organization after termination.
- Work Rule
- Work rules are used to determine standard payroll processing information required to create pay headers and transactions for an employee.
- Payroll
- This field shows the payroll in which this group will be processed.
- 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.
- Group Type
- This field specifies whether the group is full time, part time, COBRA etc.
- Pay Type
- This field indicates whether the pay type is hourly, salaried or commission. Pay type is used to control such things as forced balancing for semi-monthly and monthly paid employees and time sheet generation, as an example.
- 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 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 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.
- FTE 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.
Rate Details#
- Hourly Rounding
- This field shows the rounding factor to be used when converting a wage or salary amount to an hourly rate. To round to two decimals, use a rounding factor of 0.005. To round to four decimals, use a rounding factor of 0.00005.
- Daily Rounding
- This field shows the rounding factor to be used when converting a wage or salary amount to a daily rate. To round to two decimals, use a rounding factor of 0.005. To round to four decimals, use a rounding factor of 0.00005.
- Weeks Per Year
- The weeks per year factor will be used to annualize a weekly rate of pay. This factor is necessary whenever the rate basis is defined as weekly, as all other rates will be derived by converting the base rate first to an annual salary/wage.
- Months Per Year
- The months per year factor will be used to annualize a monthly rate of pay. This factor is necessary whenever the rate basis is defined as monthly; converting the base rate first to an annual salary/wage will derive all other rates.
- 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.
- Registration #
- This value in this field is defaulted from the IDGV form once the Fed Regist Set and Fed Regist Type fields are completed.
- 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.
- Contract Type
- This field identifies what type of contract exists for the group.
- Employment Type
- This field describes the type of relationship that the employees in this group have with the organization. When an employee is hired, their employment type will be inherited from the group, but you may override it. The employee's employment type will be displayed on the id line of all of the employee-related forms.
- FLSA Factor
- This field shows the rate at which earnings for time over the indicated base hours is to be paid. This is used by for FLSA processing.
- FLSA Hours
- This field shows the base hours after which the FLSA calculation will begin.
- FLSA Calendar
- If FLSA is to be calculated over more than 7 days, a calendar must be set up to define the cycle.
- FLSA User Calc
- If a UserCalc is needed to enhance the FLSA process it needs to be indicated here.
- 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
This reporting is not used in Canada. If you are reporting for a Canadian company, select 'Regular' as the type of employment.
- 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.
- State Regist Type
- 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.
- 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.
e.g.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.
- Govt Regist Set Fed
- 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.
Registration#
- Govt Regist Set Local
- 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.
- WC Regist Type
- This field will indicates the WC Registration type for this group. The type and the employee’s state/province will determine the WC Classes and WC Rates the employee receives. For this reason, a group can only belong to one WC Registration type.
