MAINTAIN EMPLOYEE PAYS#
Through the Maintain Employee Pays (IPPH) form, you may create and maintain employee pays.In addition, through this form:
- Users can override normal deposit information for an employee and pay by check for a single pay.
- Field access and rules for pay component values are defined by the Pay Component Rules (IPPC) form.
- Position, Job, Rate and/or Distribution code may be overridden.
You may access this feature under the Screens/Forms menu: Payroll > Maintain Employee Pays
Employee Pay data is stored on the P2K_PR_PAY_HEADERS, P2K_PR_PAY_LINES, and P2K_PR_PAY_LINE_DETAILS tables.
- Pay #
- This field shows the unique pay number assigned to each pay header that is created for a person. Pay_Number is a 5-digit mandatory field that is assigned by the Application.
- Period
- Pay periods are numbered by the year, followed by the period of the year. Pay_Periods from P2K_PR_PAY_PERIODS is a mandatory numeric field that is system updated from the information entered in the Pay Period field.
- Payroll
- This field shows the payroll associated to the group indicated. Payroll_Code from P2K_PR_PAYROLLS a 16-character alphanumeric mandatory field that will default from the group indicated.
- Group
- This is the group derived from the pay header assignment work rule. From the assignment of this pay header, it specifies a work rule on IEAS form. Then on IDWR for the Assignment Work Rule, it points to the Pay Header creation ‘Group Source’.
- Prime Assignment - Group code for this assignment is always from the employee’s prime assignment.
- Posn/Prime Assignment - Group code for this assignment will first check if this assignment is associated with a position, then use the Posn Group Code, otherwise use employee’s prime assignment.
- Job Only - Group code for this assignment is always from this assignment’s job code to look up the group code for this job.
- Group_Code from P2K_CM_GROUPS a mandatory 16-character alphanumeric field that will be defaulted from the Group Source tab located in IDWR.
- Unit
- This is the unit to which the group indicated belongs. Unit_Code from P2K_CM_UNITS a mandatory 16-character alphanumeric field that will default from the group indicated.
- Stage
- This field indicates the status of a pay header. Pay_Header_Stage is a mandatory fixed lexicon (X_PAY_HEADER_STAGE) that will be system updated.
- To Be Audited - The pay header has either not been audited or has failed to pass the audit process. In this state it cannot be selected for calculation.
- Audited - The pay header has passed the audit process and may be selected for calculation.
- Attached to Pay Run - The pay header has been selected for processing in a pay runs. At the beginning of UPCALC, the system selects all the pay headers that are eligible and changes their status to ‘Attached to Pay Run’.
- Pay in Progress - The calculation process is currently working on the pay header. After eligible pay headers are attached to the pay run, UPCALC then processes one pay header at a time by changing their status to “Pay in Progress’ as each time sheet is processed. If UPCALC aborts abnormally, you can find out which Pay Header has ‘Pay in Progress’ when UPCALC aborts. *Calculated/Paid - The pay calculation process has processed the pay header successfully. From here, it may be canceled or closed
- Approved - No longer used with this release.
- Closed - The pay header is attached to a closed pay run. This pay header is successfully paid and the user has run the ‘Closed’ process (UPCLOZ). The pay header is attached.
- Cancelled - The pay header has been cancelled and will be physically removed by the audit process (UPAUDT). To delete a time sheet, you must cancel the pay on the IPPH form with the ‘Cancel Pay’ icon. This will flag the time sheet as ‘Cancelled’ for deletion by UPAUDT.
- Seq #
- This field denotes the order that the pay header was processed within the pay run. This field will be displayed as ‘N/A’ if this pay headers is not attached to a pay run. Pay_Run_Number from P2K_PR_PAY_RUNS is an optional numeric field that will be system populated if this pay is calculated.
- Source
- Indicates the process that created the pay header.
- IPPH Screen
- IPTR Screen
- IPTL Loader
- UPTG Generator
- External Source
- UPCPAY Generator
- UPRETRO Pay
- UPCVAC Vacation Pay
- UPVEND Proc Vendors
- UPTL Loader
- Pay_Header_Source is a mandatory fixed lexicon (X_PAY_HEADER_SOURCE) that will be system updated.
Maintain Employee Pays (IPPH) - Pay Header#
A Pay Header is created to indicate that an employee must be processed through a pay cycle.
Pay headers are associated with a specific pay period, pay category and batch. They may be created by manual entry, or generated through several automated processes, such as the transaction generator and the transaction loader.
An employee can have multiple pay headers (time sheets) per period.
Each pay header for an employee should have a unique pay period and pay category combination.
- Assignment
- This field will display the assignment for which this pay is generated. This assignment is also established by UPTR or UPTL when loading transactions in bulk. During that process, multiple pays per period may be created for multiple assignments. Assignment_Code from P2K_HR_ASSIGNMENTS is a mandatory field that will default to the employee’s prime assignment and can be manually entered or use the LOV (F9).
- Batch #
- This field shows the batch to which this pay is attached. Batch_Number is a mandatory field you may select from the LOV (F9).
- Pay Period
- This field identifies the pay period for which this pay is being generated. Pay periods are numbered by the year, followed by the period of the year. Pay_Periods from P2K_PR_PAY_PERIODS is a mandatory numeric field that will default from the batch entered but you may manually enter or use the LOV (F9).
- Starting
- Period start is the date of the first day of the pay period. Pay_Period_Start_Date from P2K_PR_PAY_PERIODS is a mandatory date field that will default from the pay period entered.
- Ending
- Period end is the date of the last day of the pay period. Pay_Period_End_Date from P2K_PR_PAY_PERIODS is a mandatory date field that will default from the pay period entered.
- Category
- This field shows the user-assigned code that uniquely identifies the pay category. Pay_Category_Code from P2K_PR_PAY_CATEGORIES is a mandatory 16-character alphanumeric field that will default from the batch entered but you may manually enter or use the LOV (F9).
- Pay Point Set
- This field defines the set of tasks that will be used when calculating the pay. Pay_Point_Set_Code is a mandatory 16-character alphanumeric field that will default from the pay category but you may manually enter or use the LOV (F9).
- Trace Level
- When performing a trial calculation, you may specify the level of message that the calculation report should display. This field is used for troubleshooting purposes. Trace_Level is an optional fixed lexicon (X_TRACE_LEVEL) that you may use to look up the value.
- Pay By
- This field indicates whether the payment will be overridden by check or prime deposit. If this field is left blank, the pay method rules as defined in IPPM will be used for this pay. Pay_By_Method is an optional fixed lexicon (X_PAY_BY_METHOD) that you may use to choose the method of payment.
- First Pay in Period
- This field is populated during the UPAUDT process and is used to qualify processing frequencies. If the First Pay In Period toggle is ON, this is a regular pay category header, and the first time the employee has been paid in this pay period. If the toggle is OFF, the employee has already been paid in the pay period. First_Pay_In_Period is an optional toggle field that is system updated during UPAUDT.
- 1st Pay in Month
- This field is populated during the UPAUDT process and is used to qualify processing frequencies. If the First Pay In Month toggle is ON, the pay header is for the first time the employee has been paid in the calendar month for a regular pay. If the toggle is OFF, there has already been a regular pay created or paid for this (or a prior) period in the month. First_Pay_In_Month is an optional toggle field that is system updated.
- Audited
- This field is populated during the UPAUDT process. If the Audited toggle is ON, the pay header has passed all the validation checks of the audit process (UPAUDT) and is ready to be processed through pay calculation. If the toggle is OFF, either the pay header has not yet been audited, or it has failed to pass the transaction audit. The Audited toggle on the pay header is not set unless all of the individual pay lines associated with that header have also passed the transaction audit. Audited is an optional toggle field that is system updated.
- Sundry Attached
- This field is populated during the UPAUDT process. If the Prepared toggle is ON, the time sheet has been successfully processed by UPAUDT. To prepare this time sheet to be paid, UPAUDT has pulled together all related information (e.g. user calculations, sundry items, benefits, etc.) for this pay header from the Pay Point set (as defined in IPPP). If you are changing any ‘Pay Point Set’ information on IPPP form, you will need to run UPUNPREP and then run UPAUDT again to prepare. Sundry_Attached is an optional toggle field that is system updated.
- Journalized
- This field is populated during the UPGL process. If the Journalized toggle is ON, all of the pay lines and pay amounts for this header have been processed through the journalizing process. If the toggle is OFF, all or some of the pay lines have not yet been journalized. Journalized is an optional toggle field that is system updated.
- Journalized Fund
- This field is populated during the UPGL process. If the Journalized Fund toggle is ON, that segment of the GL Distribution can be used as a 'Fund'. Journalized_Fund is an optional toggle field that is system updated.
- Time Sheet Returned
- This field indicates to the system that the employee has returned the time sheet. If the Time sheet Required toggle on IDWR - Status Rules tab is ON, then a physical time sheet for the employee must be received at data entry time. You must physically turn the Time Sheet Returned toggle on, otherwise this time sheet will not pass the UPAUDT process. Timesheet_Returned is an optional toggle field.
- Trial Pay
- This button allows you to calculate one pay header in non-update mode. This field is very useful for trial runs and for testing.
- Cancel Pay
- This button allows you to mark a pay header as cancelled which in turn will be physically removed by the audit process.
- Revert Pay
- This button allows you to revert a pay and acts as a duel function:
- If a batch is in a calculated pay status, ‘Revert Pay’ allows you to pull the employee out of that pay and put them in to an audited status. This is the same function as UPPULL.
- If the batch is in an audited status, ‘Revert Pay’ allows you to unprepared the employee, take them back to an unaudited status. This is the same function as UPUNPREP.
Checks#
- Check Amount
- This field shows the amount of the check associated with the pay, only if it is a ‘hand check’. Check_Amount is an optional 18 digit numeric field that is either manually or system updated.
- Pay Issue Date
- The Pay Issue Date is the date that payment is issued for the time sheet. Pay_Issue_Date is a mandatory date field that will default from the pay period chosen, but may be overridden.
- Check #
- The check number is assigned by you from the manual check range for the organization’s bank from IPBA. This field is only used for manually issued checks. Check_Number is an optional numeric field that is system updated.
- Hand Check
- If the Hand Check toggle is ON, the pay header is for a pay which includes a hand written check that needs to be recorded in the system. If the toggle is OFF, this is a normal computer generated payment. Hand_Check is an optional toggle field.
Location#
In the US, jurisdictions are defined by the Vertex GEO code.In Canada, jurisdictions are supplied by High Line.
If an employee works in an area that is not in the province where they are required to pay taxes, you will identify their work area under the Work Province tab and the province to which they are paying taxes under the Work Jurisdiction tab.
For example, an Ontario employee works in Zimbabwe but is required to be taxed according to Ontario legislation. For this employee, you will then enter ‘Zimbabwe’ as their work province and ‘Ontario‘as their work jurisdiction.
- Work State/Prov
- This field shows the State or Province code standard abbreviation where the employee works. State_Province from P2K_CM_STATE_PROVINCES is a 16-character alphanumeric mandatory field that will default from the employee’s Assignment form but you may manually enter or use the LOV (F9).
- Work Jurisdiction
- This field holds the Geo code of the employee’s work tax jurisdiction. Jurisdiction from P2K_CM_TAX_JURISDICTIONS is a 16-character alphanumeric optional field that will default from the employee’s Assignment form however, you may manually enter or use the LOV (F9).
- Home State/Prov
- This field holds the state or province where the employee resides. State_Province from P2K_CM_STATE_PROVINCES is a mandatory 16-character alphanumeric field that will default from the employee’s Personal form but you may manually enter or use the LOV (F9).
- Home Jurisdiction
- This field holds the Geo code of the employee’s residence tax jurisdiction. Jurisdiction from P2K_CM_TAX_JURISDICTIONS is a 16-character alphanumeric optional field that will default from the employee’s Personal form but you may manually enter or use the LOV (F9).
- School District
- For U.S. installations only: This field shows the school district to which the employee pays taxes. School_District is a 16-character alphanumeric optional field that will default from the employee’s personal form but you may manually enter or use the LOV (F9).
- Final Pay Method
- The final pay method indicates whether or not a pay is considered to be an employee's final pay. The final pay method is set to 'final pay' automatically when this pay header’s employment has a termination date within the pay period and a termination reason defined as final pay on IDTR. When 'final pay' is set, certain events or processes may be triggered to happen automatically, such as the paying out of leave policy balances from attendance. Final_Pay_Method is an optional fixed lexicon (X_FINAL_PAY_METHOD) that will default based on the employee’s termination date falling within the pay period specified or you may use to look up the value.
- Tax Weeks
- This field shows the number of tax weeks associated with this pay for this pay frequency. The Tax Weeks field enables you to override the default number of pay weeks associated with a pay period. Changing the tax weeks changes the calculation of the normal period taxation that will be applied to that employee. For example, this is used when an employee who is on a biweekly payroll cycle is only receiving pay for working one of the two weeks in the biweekly pay period. Tax_Weeks is an optional numeric field that will default from the pay weeks indicated on the pay calendar of the pay period specified, but may be overridden.
- Reversal #
- If the category indicated is a reversal, then the pay that is to be reversed must be indicated in this field. The original pay # to be reversed must be disbursed (through UPDISB) before it can be reversed. Pay_Number is a 5-digit mandatory field (if the category is reversal) you must manually enter or use the LOV (F9).
Maintain Employee Pays (IPPH) - Pay Lines#
Pay Lines are the individual pay transactions. They are created in a number of different ways. They may be entered manually by you through data entry forms, they may be generated by the transaction generator, or loaded into the system through the transaction loader. Pay lines loaded into system may originate from the Time Scheduling application, or come from an external source such as another system. (e.g. a time clock or PC application such as Excel®).The information entered for the pay lines is used to generate the Pay Line Details. The pay calculation process (UPCALC) uses the data from the Pay Line Details for amounts and reference back to Pay Lines.
- Assign
- This field identifies the assignment by the assignment code defined on the employee’s assignment screen (IEAS).
- Starting
- This field shows the start date of the pay line. Start_Date is a mandatory date field that will default as the pay period start date but may be overridden.
- PC
- A pay component code is a unique number code from 1 to 9,999 assigned to uniquely identify the pay component. Only pay components with the toggle ‘Enter Pay Lines’ turned on will be accessible. Data may only be entered in the fields that have had their toggle turned ON in the Pay Component form’s PC Rules tab. PC_Code from P2K_PR_PAY_COMPONENTS is a 4-digit numeric mandatory field that you must manually enter or use the LOV (F9).
- Abbreviation
- This field provides a short description of the pay component which will be printed on check and deposit statements, lists and pay registers. PC_Abbreviation is a 16-character alphanumeric mandatory field that will default from the pay component chosen.
- Value
- This field shows the amount or time entered for the pay component indicated. Time_Entered is an 18 digit optional numeric field.
- Per
- The basis is the unit of measure that the associated value is being stored or displayed in:
- YR - Yearly/Annual
- MO - Monthly
- WK - Weekly
- DY - Daily
- HR - Hourly
- UN - Unit
- CT - Contract - Normally used for Premiums not Pay Lines
- KM - Kilometers - Normally used for Premiums not Pay Lines
- PC - Pieces - Normally used for Premiums not Pay Lines
- PP - Pay Period - Normally used for Premiums not Pay Lines
- DV - Days Variable
- HV - Hours Variable
- $ - Amount
- Time_Basis is an optional fixed lexicon (X_TIME_BASIS) that will default from the pay component set up but may be overridden.
- Position
- This field displays the position code from the pay line’s assignment. Position_Code will default from the play line’s assignment but may be overridden.
- Job
- This field shows the job code from the play line’s assignment. Job_Code will default from the employee’s assignment but may be overridden.
- Rate
- This is the standard wage rate from the assignment. STD_Wage_Rate will default from the pay line’s assignment and may be overridden.
- Per
- The rate basis is the unit of measure that the associated rate is being stored or displayed in:
- YR - Yearly/Annual
- MO - Monthly
- SM - Semi-monthly
- BW - Bi-weekly
- WK - Weekly
- DY - Daily
- HR - Hourly
- UN - Unit
- CT - Contract - Normally used for Premiums not Pay Lines
- CL - Contract Limit - Normally used for Premiums not Pay Lines
- $ - Amount
- STD_Wage_Rate_Basis will default from the pay line’s assignment and may be overridden.
- Audit Text
- This field will display audit text generated for this line. Click on the right hand side of the text block to open the editor window. Audit_Text is an optional alphanumeric field that will be updated by the system.
- Distribution
- This field holds the overridden distribution mask for this pay line that is applicable to all its pay line details for DR and CR journal entry postings. You may use the Distribution Editor button to enter the distribution.
- Reference
- This field displays a user-defined reference or note determined by the PC set up in the reference field in IPPC (either ‘Enter Description’ or ‘Enter Vendor Code’). This reference information may be either anecdotal or more structured (e.g. Union Code or Court Number). Reference_Info is a 50-character alphanumeric optional field.
- Department
- This is the department defined from the pay line assignment. Department_Code is a 16-character alphanumeric mandatory field that will default from the assignment type indicated but you may manually enter or retrieve from the LOV(F9).
- WCB Class
- This field shows the Workers’ Compensation class from the assignment indicated for the pay line. WCB_Class is an optional user-defined lexicon (X_WCB_CLASS) that will default from the assignment type indicated and may be overridden.
- Work Order
- Work Order is used to define work orders attached to a specific pay line. The Work Order Validation is defined on the ‘Define G/L Company’ (IDGC) form. The work order on each pay line can be unedited (no validation) or validated from an external system that has been programmed by High Line . Work_Order is a 50-character optional alphanumeric field.
- Cost Center
- Cost Center is used to define a short cut for cost center information attached to a specific pay line. Cost_Center from P2K_CM_COST_CENTERS is a 16-character alphanumeric optional field that you manually enter or use the LOV (F9).
- User Calc
- This field holds the UserCalc that may be attached to the pay component chosen or manually entered.
- Benefit Plan
- If this pay line is for a benefit, then the benefit plan is indicated in this field. Benefit_Plan_Code for P2K_BE_PLAN_DEFINITIONS is a 16-character alphanumeric optional field you may complete with a value from the LOV (F9) provided.
- Pay Point
- This field indicates when this pay component needs to be picked up for processing during the pay calculation. Pay_Point_Type is a mandatory fixed lexicon (X_PAY_POINT_TYPE) that will default from the pay component chosen for this pay line.
- Sequence
- This field shows the unique sequence number assigned to each item processed in a pay point and determines the order of processing within a ‘Pay Point Type’. Pay_Point_Sequence is an optional numeric field that will default from the pay component chosen for this pay line.
- Task
- The pay point task identifies the kind of process within the pay point. Pay_Point_Task is a mandatory fixed lexicon (X_PAY_POINT_TASK) that you may use to look up the value.
- Status
- This field indicates if the pay lines is ‘Active’ or ‘To be deleted’. You have the option of deleting the line or marking it for deletion. When you delete a pay line through the ‘delete and commit record’ button in the horizontal toolbar, it is temporarily removed from the screen and will be physically removed by UPAUDT. If you choose to mark a pay line ‘to be deleted’ in the status field, it will be removed from immediate view but is still in the database; the line will then be physically removed from the database by the audit process (UPAUDT). Pay_Line_Status is a fixed lexicon (X_PAY_LINE_STATUS) that you may use to look up the value.
- Leave Type
- If this is an attendance line then the leave type for that line is indicated in this field. Leave_Type_Code for P2K_AT_LEAVE_POLICY_TYPES is a 16-character alphanumeric optional field you may complete with a value from the LOV (F9) provided.
- End Date
- This field shows the end date of the pay line. End_Date is a mandatory date field that will initially default to the pay period end date but will change to the start date once the pay component is entered. It can be overridden.
- Audited
- If the Audited toggle is ON, the pay line has passed all the validation checks of the audit process (UPAUDT) and is ready to be processed through pay calculation. If the toggle is OFF, either the pay line has not yet been audited, or it has failed to pass the transaction audit. Audited is an optional toggle field that is system updated.
- Detail Generated
- If this toggle is ON, pay line detail has been generated for this pay line through ‘Save’, UPTR or UPTL. If this toggle is OFF, no pay line detail has been generated. Detail_Generated is an optional toggle field that is system updated.
- Posted Experience
- If the Posted Experience toggle is ON, the pay line has been updated to the experience application through the track experience process (USEP). If the toggle is OFF, the experience application has not been updated. Posted_Experience is an optional toggle field that is system updated.
- Journalized
- If the Journalized toggle is ON, the pay line has been processed through the journalizing process (UPLG, UPGL). If the toggle is OFF, the pay line has not yet been journalized, or is not an item that requires journalizing. Items may be journalized for costing and/or general ledger purposes, and may be statistical items such as hours, or financial items such as earnings, benefits and deductions. Journalized is an optional toggle field that is system updated.
- Work in Progress
- If the Work in Progress toggle is ON, this pay line is considered a WIP transaction, which will be journalized to the Work in Progress account of the general ledger, instead of the GL accounts defined on the IPPC form. If the toggle is OFF, the pay line is a not journalized as work in progress. Work_In_Progress is an optional toggle field that is system updated but you may manually adjust.
- Arrears Collected
- This pay line is created by UPAUDT from the Sundry Arrears transaction and this toggle indicates this pay line is from Arrears and will be collected by UPCALC. If the Arrears Collected toggle is OFF, then this pay line is not an arrears. Arrears_Collected is an optional toggle field that is system updated but you may manually adjust.
- Override Rate
- If the Override Rate toggle is ON, this pay line has had the defaulting rate altered. If the toggle is OFF, the pay line will display the original defaulting rate. Rate_Overridden is an optional toggle field that is system updated but you may manually adjust.
- Highest Rate Info
- This field applies the higher of the wage rates derived from either the 'Rate Source' chosen, or from the Employee Prime Assignment Rate. The 'Highest Rate of the Day' logic is invoked independently and at a later point in time. It compares the 'Wage Rate' stamped on the Pay Line Detail, to the highest 'Wage Rate' on all Pay Line Details. After choosing the higher, the calculation rule is applied and the individual amounts generated.
Pay Line Details#
Pay Line Details contain the results of applying the PC rules of the pay component to derive all of the required values associated with a pay line.Data may only be entered in the fields that have had their toggle turned ON in the pay component form’s PC Detail Rules tab.
- PC
- The details pay component code(s) that default from the pay line pay component code entered. For example, if a Time pay component is entered on the pay line, then the Time and Earnings pay components may be generated on the pay detail line. PC_Code from P2K_PR_PAY_COMPONENTS is a 4-digit numeric mandatory field that you must manually enter or use the LOV (F9).
- Abbreviation
- This field provides a short description of the pay component used for printing on check and deposit statements, lists and pay registers. PC_Abbreviation is a 16-character alphanumeric mandatory field that will default from the pay component chosen.
- Amount
- This field shows the amount calculated as a result of applying the PC Calc Method. Amount_Override is an optional numeric field that will be populated by the system based on the pay component rules.
- Rate
- This field is the wage rate derived from the pay line rate and displayed in the basis of the pay component. Wage_Rate_Override is an 18 digit optional numeric field that is system calculated based on the Time Basis indicated.
- Per
- The rate basis is the unit of measure that the associated rate is being stored or displayed in:
- YR - Yearly/Annual
- MO - Monthly
- SM - Semi-monthly
- BW - Bi-weekly
- WK - Weekly
- DY - Daily
- HR - Hourly
- UN - Unit
- CT - Contract - Normally used for Premiums not Pay Lines
- CL - Contract Limit - Normally used for Premiums not Pay Lines
- $ - Amount
- Rate_Basis_Override is an optional fixed lexicon (X_RATE_BASIS) that will be derived from the time basis indicated but may be overridden.
- Type
- 'PC Detail Type' is used to determine the nature of the' Pay Line Details' that will eventually be created. The two main types are 'Entered Value', and 'Computed Value'. The other types are maximums and declining balance, which are not as common. The 'Entered Value' is populated (during save) with the value entered on the Pay Line. The ‘Computed Values’ are calculated based on the 'Calculation Method'. Only one ‘Computed Value’ is allowed per pay component detail. PC_Detail_Type is a fixed lexicon (X_PC_DETAIL_TYPE) that you may use to look up the value.
- Calc. Method
- This field indicates the method by which an amount is calculated. PC_Calc_Method is an optional fixed lexicon (X_PC_CALC_METHOD) that will default from the pay component but may be overridden.
- Description
- This field provides detailed information on the Calc Method used. Description is a 50 character alphanumeric optional field that will default from the Calc Method.
- Rate Source
- This field indicates from where the wage rate is derived.
- Primary Assignment
- Matching Assignment
- Position or Job
- Job
- Prime + Premiums
- Assign + Premiums
- Job/Posn + Premiums
- Job + Premiums
- PC_Rate_Source is an optional fixed lexicon (X_PC_RATE_SOURCE) that will default from the pay component.
- O/R User Variable
- You may wish to manually enter the user variable amount.For example, the user variable field may indicate a rate or 1.5 but for this particular transaction you may wish to enter 1.55. User_Variable_Override is an 18 digit optional numeric field that you may manually enter.
- User Variable
- This field shows the user variable that may be used according to the pay component details set up. User_Variable_Code is a 16-character alphanumeric optional field that will default from the pay component but may be overridden.
- Element
- The element that is to be used according to the pay component details set up is shown in this field. Element_Code is an optional 16-character alphanumeric field that will default from the pay component but may be overridden.
- Premium
- If this pay line detail is a premium, it will contain the premium code. Premium_Code from P2K_SA_PREMIUMS is an optional 16-character field that you may complete with a value from the LOV (F9) provided.
- Audit Info
- This fields will display the audit text generated for this line. This text is derived from the Audit Text field on the Pay Lines tab. Audit_Text is an optional alphanumeric field that will be updated by the system.
- Pay Line Detail Status
- This field indicates if the pay line is ’Active’ or ‘To be deleted’. You have the option of deleting the line or marking it for deletion. When you delete a pay line through the ‘delete and commit record’ button in the horizontal toolbar, it is temporarily removed from the screen and will be physically removed by UPAUDT. If you chooses to mark a pay line detail ‘to be deleted’ in the status field, it will be removed from your immediate view but is still in the database; the line will then be physically removed from the database by the audit process (UPAUDT). Pay_Line_Status is a fixed lexicon (X_PAY_LINE_STATUS) that you may use to look up the value.
- Action
- The PC Action determines whether a transaction item entered under this pay component will be accumulated to the total value of the pay component, replace a prior transaction item, trigger a user calculation, or suppress a User calculation. PC_Action is a mandatory fixed lexicon (X_PC_ACTION) that will default from the pay component and may be overridden.
- Amount Processed
- This field shows the amount actually processed by the pay calculation process, after performing 'gross to net' assessment. The original transaction amount may be modified by the system based on the pay component rules. For example, if there are insufficient earnings to take a deduction amount, the rule may indicate to take as much as possible with an arrears transaction being created to recover the balance at a later date. The amount processed would be the modified 'as much as possible' value. Amount_Processed is an optional numeric field that is system maintained.
- Distribution CR Mask
- Distribution mask contains the distribution derived from the assignment, position, or job, overlaid by the distribution mask based on the credit GL code of the pay component. Distribution_CR_Mask is an optional 50-alphanumeric field that you manually enter or use the distribution editor to enter the value.
- Distribution DR Mask
- Distribution mask contains the distribution derived from the assignment, position, or job, overlaid by the distribution mask based on the debit GL code of the pay component. Distribution_DR_Mask is an optional 50-alphanumeric field that you manually enter or use the distribution editor to enter the value.
Premiums#
Premiums are usually system generated as defined for the pay component on the IPPC form. However users may enter additional premiums for a pay line on the Premium tab of IPPH.This tab is only used when a premium is to be manually attached to a pay line. These premiums are picked up during UPAUDT and turned into Pay Line Details for UPCALC.
All other premiums are system generated and displayed in the Pay Line Details tab.
- Premium
- This field provides a user defined premium code that uniquely identifies this premium within the organization. Premium_Code is a 16-character alphanumeric mandatory field that you must manually enter.
- Rate
- This field shows the premium rate that is used in the premium calculation. Premium_Rate is an 18-digit numeric field.
- Basis
- The rate basis is the unit of measure that the associated rate is being stored or displayed in, for example, hourly, weekly, biweekly, semi-monthly, monthly, or annual. Rate_Basis is an optional fixed lexicon (X_RATE_BASIS) that you may use to look up the value.
- O/R Rate
- This field holds the Premium Override rate you entered, which will be used in the premium calculation. Premium_Rate is an 18-digit numeric field.
- O/R Basis
- The rate basis is the unit of measure that the associated rate is being stored or displayed in, for example, hourly, weekly, biweekly, semi-monthly, monthly, or annual. Rate_Basis is an optional fixed lexicon (X_RATE_BASIS) that you may use to look up the value.
Maintain Employee Pays (IPPH) - Pay Amounts#
Pay Amounts store the pay component totals resulting from the pay calculation process. The pay amounts tab will show the results for all pay components that have the ‘Store Results’ toggle turned on the Pay Component form and all legislated amounts from taxation. Amounts are displayed in pay component order.This tab will only be displayed after the pay is calculated through UPCALC or the Trial Calc <Trial Pay> button on the Pay Header.
This is a view only tab.
Maintain Employee Pays (IPPH) - Journalized#
This tab will only be displayed if any pay line has been journalized by the Labour Gl (UPLG) process prior to Payroll calculation or if this Pay has been paid and closed by UPCLOZ and has been run by the Payroll GL process (UPGL). The pay can be distributed through UPGL or UPLG in trial or update mode. This is a view only screen.- Fiscal
- This field indicates the fiscal period for which the transaction will be journalized.
- Distribution
- This field holds the distribution code for the pay component displayed.
- GL Date
- This field displays the date that the journal entry is effective.
- GL Account
- This field displays the general ledger account for the journal entry.
- PC
- This field displays the pay component code attached to the GL account code for the journal entry.
- Abbrev
- This field displays the description abbreviation of the pay component for the journal entry.
- G/L Amount
- This field displays the amount of the journal entry.
- Journalized Source
- This field will display the process used to create the journalized record. e.g. UPGL, Trial Pay Line
- Fiscal End Date
- This field displays the last date of the fiscal period for the transaction.
- Created by mex id
- This field will contain the execution id of the journal source listed. This field will be populated by either UPLG or UPGL when the journal entries are being generated.
- Interface mex id
- This field holds the execution id of the GL interface.
- Costed by mex id
- If a detail costing file needs to be generated to the general ledger, you must turn on the 'Affects Costing' toggle within the IDGA screen. When UPGLF is run, you may enter an interface file for the costing. If UPGLF is run in update mode, this field will contain the mex id of that UPGLF run.
- Trial Journal
- If this toggle is checked, the Journal Entry is a trial journal after either the UPLG or UPGL is run.
- G/L Post Number
- This is a customized field not used for most clients.
- G/L Post Seq #
- UPGLF automatically assigns a GL Post Sequence on change of distribution code. This GL Post Sequence is updated to P2K_PR_JOURNAL_ENTRIES.
- G/L Pointer
- This is a customized field not used for most clients.
- Work Order
- This is a customized field not used for most clients.
- G/L Fund Code
- If using Fund Accounting, you need to define G/L Fund code on IDGF screen attached to each distribution mask. When UPLG and UPGL generates Journal Entries, the G/L Fund code is also attached to each journal entry.
