PAY LINES INTERFACE FILE#
The Pay Lines Interface File screen is used to import pay lines into the software data structures.
Pay Lines Interface File data is maintained on the INF_CV_PAYLINES table.
Tab 1#
- ID
- This field uniquely identifies the pay line record within the data base.
- Entity
- This field identifies the entity associated with the pay line.
- Person Code
- The employee associated with the pay line will be displayed in this field.
- Employment Type
- The employment associated with the pay line is displayed in this field.
- Date of Hire
- The date the employee was hired is displayed in this field.
- Pay #
- This field displays the pay number attached to the pay transaction.
- Pay Line Status
- This field displays the status of the pay line created.
- Unit
- The unit associated with the pay line is displayed in this field.
- Group
- The group associated with the pay line is displayed in this field.
- Leave Type
- The leave type associated with the pay line is displayed in this field.
- Plan
- This field identifies any benefit plan associated with the pay line.
- User Calc
- Any user calc associated with the pay line is identified in this field.
- Job
- The job associated with the pay line is displayed in this field.
- Department
- The department associated with the pay line is displayed in this field.
- Position
- The position associated with the pay line is displayed in this field.
- Start Date
- The start date of the assignment.
- Pay Component
- The pay component associated with the pay line is displayed in this field.
- Country Name
- The country where the employee resides is indicated in this field.
- State, Country
- The state or province where the employee resides is indicated in this field.
Tab 2#
- Tax Jurisdiction
- This field holds the GEO code of the city, county or state used for taxation purposes.
- Pay Point Type
- This field indicates the type of logic that is assigned to a pay point.
- Pay Line Task
- This field identifies the item being processed within the pay point in the payroll calculation.
- Seq #
- This field identifies the order of the tasks within each pay point type.
- Start Date/End Date
- These fields identify the start and end dates of the pay period.
- Journalized
- This field indicates if all of the pay lines and pay amounts for this header have been processed through the journalizing process.
- Posted Experience
- This field indicates if the pay line has been updated to the experience application through the track experience process (USEP).
- Work in Process
- This field is used to indicate if 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.
- Time Entered
- This field shows the amount or time entered for the pay component.
- Basis
- This field indicates the unit of measure that the time amount is expressed in.
- Standard Wage Rate
- This field holds the standard wage rate from the assignment.
- Standard Wage Basis
- This field holds the unit of measure that the standard wage rate is expressed in.
- WC Class
- This field displays the Workers’ Compensation classification used to determine the WC category for reporting.
Tab 3#
- Distribution Mask
- This is the edit mask for the distribution code that provides a default value which overlays the distribution code on the position and assignment records.
- Reference Information
- This field provides additional reference information.
- Detail Generated
- This field indicates if a pay line detail has been generated for this pay line through ‘Save’, UPTR or UPTL.
- Rate Overridden
- This field indicates if the pay line has had the defaulting rate altered to an override rate.
- Audit Text
- This field will display audit text generated for this line.
- Arrears Collected
- This field indicates this pay line is from Arrears and will be collected by UPCALC.
- Work Order
- This field identifies any work order attached to the pay line.
- Reason For Time
- If a reason for the time is required it will be indicated here.
- Element
- This field displays the element associated with the pay line.
- User Variable
- This field shows the user variable that may be used according to the pay component details set up.
- Premium
- If this pay line detail is a premium, it will contain the premium code.
- Pay Line Detail Status
- This field indicates if the pay line is ’Active’ or ‘To be deleted’.
- 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.
- Pay Detail Type
- This field indicates how the pay component amount is used. The two main types are 'Entered Value', and 'Computed Value'. The other types are maximums and declining balance, which are not as common.
- Calculation Method
- This field indicates the method by which an amount is calculated.
Tab 4#
- Wage Rate
- This is the standard wage rate from the assignment.
- O/R Wage Rate
- This field is the wage rate derived from the pay line rate and displayed in the basis of the pay component.
- Basis
- The rate basis is the unit of measure that the wage rate is being expressed in
- O/R Basis
- The rate basis is the unit of measure that the O/R wage rate is being expressed in.
- Amount $
- The wage amount is displayed in this field.
- Amount Override
- The wage override rate is displayed in this field.
- Amount Processed
- This field shows the amount actually processed by the pay calculation process, after performing 'gross to net' assessment.
- O/R User Variable
- This field shows an override to the user variable amount.
- Distribution DR Mask
- Distribution mask contains the distribution overlaid by the distribution mask based on the credit GL code of the pay component.
- Distribution CR Mask
- Distribution mask contains the distribution, overlaid by the distribution mask based on the debit GL code of the pay component.
- WC Regist Type
- This field indicates a WC Registration type for a group.
