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

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

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
24 26-Nov-2021 10:22 3 KB jmyers to previous
23 26-Nov-2021 10:22 3 KB jmyers to previous | to last
22 26-Nov-2021 10:22 3 KB jmyers to previous | to last
21 26-Nov-2021 10:22 3 KB jmyers to previous | to last

Page References

Incoming links Outgoing links
IDGF
IDGF

Version management

Difference between version and

At line 2 changed one line
!!!DEFINE GENERAL LEDGER FUNDS
!!!DEFINE G/L FUNDS
At line 4 removed 2 lines
The Define General Ledger Funds (IDGF) allows you to define and maintain G/L funds within the system.
At line 8 changed 6 lines
;[G/L Fund|GL_FUND_CODE]:This field provides the name of the G/L fund being defined.
;[Description|DESCRIPTION]:A short description of the G/L fund is provided in this field.
;[Entity|ENTITY_CODE]:The entity associated with the G/L fund is defined here.
;[Dept|DEPARTMENT_CODE]:The department associated with the G/L fund is defined here.
;[Distribution Mask|DISTRIBUTION_MASK]:This field holds the distribution code or distribution mask associated with this GL account.
;[G/L Seq #|GL_SEGMENT_NUMBER]:This field defines the sequential order of the validation units.
;[G/L Fund|GL_FUND_CODE]:
;[Description|DESCRIPTION]:
;[Entity|ENTITY_CODE]:
;[Dept|DEPARTMENT_CODE]:
;[Distribution Mask|DISTRIBUTION_MASK]:
;[G/L Seq #|GL_SEGMENT_NUMBER]:
At line 15 changed 3 lines
;[Start Date|START_DATE]/[End Date|END_DATE]:If the G/L fund is for a specific time frame, the start and end dates are listed in these fields.
;[Program Code|PROGRAM_CODE]:If G/L fund is for a specific program, that program is indicated in this field.
;[Description|DESCRIPTION]:A short description of the program is provided in this field.
;[Start Date|START_DATE]:
;[End Date|END_DATE]:
;[Program Code|PROGRAM_CODE]:
;[Description|DESCRIPTION]:
At line 21 changed 6 lines
;[Fund Type|FUND_TYPE]:This field identifies the type of fund being defined.
;[Grant Code|GRANT_CODE]:If the fund type is a grant, the associated grant is defined.
;[Grant Type|GRANT_TYPE]:The type of grant is defined in this field.
;[Calc Method|FUND_CALC_METHOD]:This field dictates how the fund will be calculated.
;[Activity Code|ACTIVITY_CODE]:The activity associated with this fund will be listed in this field.
;[Account Manager|ACCOUNT_MANAGER]:The individual responsible for this account is listed in this field.
;[Fund Type|FUND_TYPE]:
;[Grant Code|GRANT_CODE]:
;[Grant Type|GRANT_TYPE]:
;[Calc Method|FUND_CALC_METHOD]:
;[Activity Code|ACTIVITY_CODE]:
;[Account Manager|ACCOUNT_MANAGER]:
At line 28 changed one line
;[User Calc|USER_CALC_CODE]:Any UserCalc associated with the fund should be identified in this field.
;[User Calc|USER_CALC_CODE]:
At line 32 changed one line
;[Evaluation Date|LAST_EVAL_DATE]:This field provides the last date this fund was evaluated.
;[Evaluation Date|LAST_EVAL_DATE]:
At line 37 changed 6 lines
!!Elements tab
This tab identifies elements associated with the G/L fund.
;[Fund Element Type|FUND_ELEMENT_TYPE]:This field is used to identify the type of fund element.
;[Element|ELEMENT_CODE]:The fund associated with the G/L fund is defined in this field.
;[Description|DESCRIPTION]:A description of the element is listed in this field.
;[Fund Amount|FUND_ELEMENT_AMOUNT]:This field displays the amount in the fund element.
!!
Elements tab
;[Fund Element Type|FUND_ELEMENT_TYPE]:
;[Element|ELEMENT_CODE]:
;[Description|DESCRIPTION]:
;[Fund Amount|FUND_ELEMENT_AMOUNT]:
At line 46 changed 3 lines
;[Employee|]:The employee associated with the assignment will be displayed in this field.
;[Emp Dept|DEPARTMENT_CODE]:The employee's department will be shown in this field.
;[Seq|SEQUENCE]:
;[Employee|]:
;[Emp Dept|]:
;[Seq|]:
At line 54 changed 4 lines
;[Start Date|START_DATE]/[End Date|END_DATE]:The start and end dates of the assignment will be listed in these fields.
;[Assignment|ASSIGNMENT_CODE]:The assignment will be identified in this field.
;[Dist %|SPLIT_PERCENT]:If the split rule is ‘by percent’ then the percent will appear in this field.
;[User %|USER_PERCENT]:If ‘Split By Percent’ has been selected as the split rule, then the user percentage will be displayed in this field.
;[Start Date|START_DATE]:
;[End Date|END_DATE]:
;[Assignment|ASSIGNMENT_CODE]:
;[Dist %|SPLINT_PERCENT]:If the split rule is ‘by percent’ then indicate the percent in this field. You must enter the percentage has a whole number, not a decimal. For example, to indicate 6% you would enter 6, not .06
;[User %|]:
At line 59 changed 2 lines
;[Eval Date|LAST_EVAL_DATE]:This field shows the date the fund was lasted evaluated on.
;[Last Pay #|LAST_PAY_NUMBER]:This field is a system controlled field that identifies the last pay number for this employee.
;[Eval Date|LAST_EVAL_DATE]:
;[Last Pay #|LAST_PAY_NUMBER]:
At line 63 added 15 lines
;[Group|GROUP_CODE]:This field holds a user-defined code that uniquely identifies the group to the organization. Group_Code is a 16-character alphanumeric mandatory field.
;[Standing|STANDING]:Standing is used to indicate whether the record is active, frozen or obsolete. Active will default. Standing is an optional fixed lexicon [(X_STANDING)].
;[Unit|UNIT_CODE]:This field displays the unit to which the group belongs. Unit_Code from [IDUN] [(P2K_CM_UNITS)] is a 16-character alphanumeric mandatory field.
;[Entity|ENTITY_CODE]:This field displays the entity to which the group belongs. Entity_Code from [IDEN] [(P2K_CM_ENTITIES)] is a 16-character alphanumeric mandatory field.
;[Change Reason|CHANGE_CODE]: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. Change_Code is a 16-character alphanumeric optional field.\\
\\
At line 64 changed 2 lines
![Notes|Edit:Internal.IDGF]
[{InsertPage page='Internal.IDGF' default='Click to create a new notes page'}]
!!Definition tag
;[Description|DESCRIPTION]:This field shows a user-defined description of the group.Description is a 50-character alphanumeric optional field.
!Definition
At line 83 added 99 lines
;[Employment Type|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. Employment_Type is an optional fixed lexicon [(X_EMPLOYMENT_TYPE)].
;[Group Type|GROUP_TYPE]:This field specifies whether the group is full time, part time, COBRA etc. Group_Type is an optional fixed lexicon [(X_GROUP_TYPE)].
;[Initial Status|STATUS_CODE]:The initial employment status describes the condition of an employee’s employment with the organization when hired into a group. This will default to the IEHR – Personnel Profile form for new hires. Status_Code from [IDES] [(P2K_CM_EMPLOYMENT_STATUSES)] is a 16-character alphanumeric mandatory field.
;[Ending Status|STATUS_CODE]:The ending employment status describes the condition of an employee’s employment with the organization after termination. Status_Code from [IDES] [(P2K_CM_EMPLOYMENT_STATUSES)] is a 16-character alphanumeric optional field.
;[Pay Type|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. Pay_Type is an optional fixed lexicon [(X_PAY_TYPE)].
;[Contract Type|CONTRACT_TYPE]: This field identifies what type of contract exists for the group. Contract_Type is an optional fixed lexicon [(X_CONTRACT_TYPE)]. Contracts will be discussed further during Basic Salary Administration training.
!Rate Details
;[Hourly Rounding|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. Hourly_Rounding is an optional numeric field.
;[Daily Rounding|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. Daily_Rounding is an optional numeric field.
;[Weeks Per Year|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. 52.0000 Weeks_Per_Year is an optional numeric field.
;[Months Per Year|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. 12.0000 Months_Per_Year is an optional numeric field.
;[Wage Step Rule|WAGE_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. Wage_Step_Rule_Code from [ISRS] [(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|ENABLE_OE_ELECTIONS]:Clients can determine which set of employees are eligible for Open Enrollment by checking ON this toggle. If a group does not have this toggled, they will not be picked up by the [UBOE] process.
\\
----
!!Work Rules tab
;[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. 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 \\then these standard hours will be defaulted in the following fields.
;[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 the payment method at timesheet level. 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. 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 earnings for time over the indicated base hours is to be paid. This is used by for [FLSA] processing. 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 [IMUC] [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. Calendar_Code from [IDCL] [P2K_CM_CALENDARS] is an optional 16-character alphanumeric field.
;[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|USER_CALC_CODE ]:GL Fund UserCalc indicates the [User Calc|USERCALC] 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. USER_CALC_Code from [IMUC] [P2K_AM_USER_CALCS] is an optional 16-character alphanumeric field.
\\
----
!!Registrations tab
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 [IDGV] [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\\This reporting is not used in Canada. If you are reporting for a Canadian company, select 'Regular' as the type of employment. W2_Employment_Type is a mandatory fixed lexicon [X_W2_EMPLOYMENT_TYPE].
;[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 [IDGV] [(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.\\ \\e.g. US State Regist 1, US State Regist 2 ..........…up to US State Regist 9 \\ Cdn Prov Regist 1, Cdn Prov Regist 2 ........…up to Cdn Prov Regist 9 \\ \\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 [IDGV] [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.\\ \\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.
;[WC Regist Type|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 Resigstration type. WC_Regist_Type is an optional field which you may complete with a value from the fixed lexicon [X_WC_REGIST_TYPE].
\\
----
!!Allocations and Elements tabs
The ‘Allocations’ and ‘Elements’ tabs will be discussed during [Payroll Advanced|] and [Basic Salary Administration|] training.
[{If var='loginstatus' contains 'authenticated'
----
![Discussion|Edit:Internal.IDGF]
[{InsertPage page='Internal.IDGF' default='Click to create a new discussion page'}]
}]
This page (revision-24) was last changed on 26-Nov-2021 10:22 by jmyersTop