Wiki: IPTL

MAINTAIN LOADED PAY LINES#

They may be entered manually by the user through IPTL form or loaded into the system through the LMTD.

Pay lines loaded through LMTD may be sourced from the Time Scheduling applications or come from an external source such as another system. e.g. a time clock or PC application

The IPTL function can be used to correct transactions that have been rejected with errors. This screen imposes system security based on the employee’s “prime” assignment to restrict unauthorized access to entities, departments, authorization areas and units, payrolls and batch codes. Lookups are provided for all code fields and lexicons to ensure data integrity.

Manage Loaded Pay Lines data is stored on table P2K_PR_LOADED_PAY_LINES.

Row: DRV_ID is a mandatory 10-character numeric mandatory field that is assigned by the application when a row is added.

Entity: The entity code of the employee for the pay line being loaded is displayed here.Entity is a mandatory 16-character alphanumeric field that you must manually enter.

EE #: This field shows the Person Code of the employee for the pay line being added. Person_Code is an optional 16-character alphanumeric field you may fill manually.

Govt Code: This field shows the Social Security or Social Insurance Number of the employee for the pay line being loaded. Government_Code is an optional 16-character alphanumeric field you may fill manually.

Start: This field shows the start date of the pay line. Start_Date is a mandatory date field you must either manually enter or choose a value from the calendar icon (F9).

End: This field shows the end date of the pay line. End_Date is an optional date field you must either manually enter or choose a value from the calendar icon (F9).

Period: This field displays the pay period of the pay line being loaded. Pay_Period is an optional 10-character numeric field you may fill manually.

Time Code: This field shows the time code of the pay transaction or leave line being loaded. Time_Code is an optional 16-character alphanumeric field you may fill manually.

PC Code: This field holds the Pay Component of the pay line being loaded. PC_Code is an optional 4-character numeric field you may fill manually.

Time/Amt: This field holds the amount or time entered for the pay component on the pay line being loaded. Time_or_Amount is an optional 18-character numeric field you may fill manually.

Wage: This field shows the override wage rate of the employee for the pay line being loaded. If you are providing this field, you must also provide RATE_BASIS. Wage_Rate is an optional 18-character numeric field you may fill manually.

Basis: This field shows the rate basis of the wage for the pay line being loaded. Rate_Basis is a mandatory field with a fixed lexicon (X_RATE_BASIS) that you may use to look up the value.

Employment Type: Employment Type of the employee for the pay line being loaded is indicated here. Employment_Type is a mandatory field with a fixed lexicon (X_EMPLOYMENT_TYPE) that you may use to look up the value.

Pay Category: Pay category of the pay line being loaded is displayed here. Category_Code is a mandatory 16-character alphanumeric field that you must manually enter.

Destination: This field indicates if the lines are to be loaded into a Pay Line, Pay Transaction or Leave Line. Do not use Destination ‘UFLOAD’. It is handled by a different function. Destination_Type is an optional field you may fill with the fixed lexicon (X_DESTINATION_TYPE) provided.

Batch Number: This is the batch number for the batch that the pay line is being loaded into. Batch_Number is an optional 10-character numeric field you may fill manually.

UPTL Status: This field shows the status of Loaded Pay Line. UPTL_Status is an optional field you may fill with the fixed lexicon (X_UPTL_STATUS) provided.

Assignment: This field displays the employee’s assignment. Assignment_Code is an optional 16-character alphanumeric field you may fill manually.

Position: If applicable, the position code of the employee for the pay line being loaded is displayed here. Position_Code is an optional 16-character alphanumeric field you may fill manually.

Trans Pointer

Unit: The employee’s unit will be displayed here. Unit is an optional 16-character alphanumeric field you may fill manually.

Job: The job of the employee for which the pay line being loaded will be displayed here. Job_Code is an optional 16-character alphanumeric field you may fill manually.

Department: The employee’s department code will be displayed here. Department_Code is an optional 16-character alphanumeric field you may fill manually.

Batch Code: The batch code for the batch that the pay line is being loaded into will be displayed here. Batch_Code is an optional 16-character alphanumeric field you may fill manually.

Premium 1: The premium to be attached to the pay line being loaded will be displayed here. Premium_Code1 is an optional 16-character alphanumeric field you may fill manually.

Premium 2: The premium to be attached to the pay line being loaded will be displayed here. Premium_Code2 is an optional 16-character alphanumeric field you may fill manually.

Premium 3: The premium to be attached to the pay line being loaded will be displayed here. Premium_Code3 is an optional 16-character alphanumeric field you may fill manually.

Distribution Mask: The distribution keyed by the user on the pay line will be displayed here. Distribution_Mask is an optional 50-character alphanumeric field you may fill manually.

Cost Center: If the line is going to pay transactions, a cost center may be indicated. Cost_Center_Code is an optional 16-character alphanumeric field you may fill manually.

WIP: 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 payroll clearing account. If the toggle is OFF, the pay line is a not journalized as work in progress. WIP is an optional toggle.

Work Order: Work Order for the pay line being loaded may be indicated here. Work_Order is an optional 50-character field you may fill manually.

Reason for Time: If a reason for the time is required it may be indicated here. Reason_for_Time is an optional field you may fill from the user-defined lexicon (X_REASON_FOR_TIME) provided.

Leave Reason: If the line is going to a leave line, a leave reason may be indicated. Leave_Reason is an optional field you may fill with the fixed lexicon (X_LEAVE_REASON) provided.

Reference Info: Reference for the pay line being loaded may be indicated here. Reason_Info is an optional 2000-character field you may fill with manually.

Source Ref: The source of the loaded pay line (UPTL) will be indicated here. Source_Reference is an optional 50-character alphanumeric field you may fill manually.

Audit Info: If a transaction is rejected for some reason, UPTL will insert text into this column to help the user determine the nature of the error. Audit_Text is for internal use and should not be altered by the user.