|
|
ONETMDED FILE
Payroll One-time Deduction
This file has two purposes in the Payroll system. PR140 (Earnings and
Deductions Calculation) uses this file to create arrears deductions when the
system cannot take an employee deduction in a payroll cycle. Secondly, you can
create Payroll One-time Deduction file records in PR39.1 (One Time Deduction).
If an Employee Deduction file record does not exist when you add a one-time
deduction, PR39.1 (One Time Deduction) creates one. One-time deductions follow
a status flow similar to time records (see the Status field in the Payroll
One-time Deduction file). After PR140 (Earnings and Deductions Calculation)
takes a Payroll One-time Deduction file record, PR199 (Payroll Close) deletes
the deduction.
REFERENCED BY
BN100 BN101 BN102 BN103 BN104 BN105
BN145 BN245 BN31.1 BN31.2 BN32.1 BN32.2
BN32.3 BN45.1 BN531 BN65.1 BN71.1 BN72.1
BS13.1 BS14.1 BS15.1 BS32.1 HR511 PA02.1
PA100 PA102 PA502 PA52.1 PA52.3 PA52.4
PA52.5 PR05.1 PR13.1 PR13.2 PR14.1 PR15.1
PR15.2 PR205 PR214 PR239 PR26.1 PR26.2
PR514
UPDATED BY
BN66.1 PR137 PR139 PR140 PR195 PR199
PR36.1 PR38.1 PR39.1 PR39.2 PR45.1 PR80.1
PR89.1 PR999 HR11.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OTD-COMPANY Numeric 4 BN66.1 PR139
Company The company number represents an PR140 PR195
established company and is entered on PR39.1 PR39.2
all function codes. PR80.1 PR89.1
OTD-EMPLOYEE Numeric 9 BN66.1 PR139
Employee Valid in the Employee file. PR140 PR195
PR39.1 PR39.2
PR80.1 PR89.1
OTD-DED-CODE Alpha 4 BN66.1 PR139
Deduction Code Valid in the Deduction file. PR140 PR195
PR39.1 PR39.2
PR80.1 PR89.1
OTD-EDM-SEQ-NBR Numeric 4 BN66.1 PR139
Emp Deduction Contains an automatically assigned PR140 PR195
Sequence Number number to keep records unique. PR39.1 PR80.1
PR89.1
OTD-SEQ-NBR Numeric 4 BN66.1 PR139
Sequence Number Contains the one-time deduction PR140 PR195
sequence number. The value in this field PR39.1 PR39.2
is automatically sequenced based on the PR80.1 PR89.1
value in the Last Deduction Sequence Nbr
field in the Employee file.
OTD-PROCESS-LEVEL Alpha 5 BN66.1 PR139
Process Level Contains the employee's process level. PR140 PR195
The value in this field defaults from PR39.1 PR39.2
the Process Level field in the Employee PR80.1 PR89.1
file. When you update processed one-time
deductions the system uses the value in
this field to set the PR140 (Earnings
and Deductions Calculation) run flag to
spaces for this process level.
When you run PR199 (Payroll Close) by
process level, the system uses the value
in this field to determine if the
one-time deduction should be updated
during the run.
OTD-DED-AMT Signed 9.2 BN66.1 PR139
Deduction Amount Contains the deduction amount entered PR140 PR195
in PR39.1 (One Time Deduction) or PR39.1 PR39.2
calculated by PR140 (Earnings and PR80.1 PR89.1
Deductions Calculation).
OTD-EFFECT-DATE Numeric 8 (yyyymmdd) BN66.1 PR139
Effective Date Contains the effective date of the PR140 PR195
one-time deduction. For the system to PR39.1 PR39.2
take the deduction, the value in this PR80.1 PR89.1
field must be equal or less than the
payment date entered in PR140 (Earnings
and Deductions Calculation).
OTD-DED-TYPE Alpha 1 BN66.1 PR139
Deduction Type Contains the deduction type. System PR140 PR195
created arrears deductions G PR39.1 PR39.2
(Garnishment) and W (Withholding) cannot PR80.1 PR89.1
be maintained by PR39.1 (One Time
Deduction). PR999 (Payroll Year End
Close) deletes system- created
Withholding type records.
G = Garnishment
W = Withholding
OTD-DED-PRIORITY Numeric 1 BN66.1 PR139
Deduction Priority Contains the deduction priority. The PR140 PR195
value in the Ded Priority field in the PR39.1 PR39.2
Deduction file defaults to this file for PR80.1 PR89.1
arrears deductions and one-time
deductions that have not been overridden
in PR39.1 (One Time Deduction). The
system uses the value in this field to
determine the order in which one-time
deductions are taken.
OTD-RECORD-TYPE Alpha 1 BN66.1 PR139
Record Type Contains the record type created by PR140 PR195
PR140 (Earnings and Deductions PR199 PR80.1
Calculation). PR89.1
PR140 changes type S (System) records
to T (Taken) if the deduction is created
and taken by PR140 in the same run.
PR199 (Payroll Close) sets system
created records to A (Arrears).
A = Arrears
S = System
T = Taken
N = No Payment
OTD-STATUS Numeric 1 BN66.1 PR137
Status Contains the status of the one-time PR139 PR140
deduction. A Future status record cannot PR195 PR199
be taken by PR140 (Earnings and PR36.1 PR38.1
Deductions Calculation) until it is PR39.1 PR39.2
changed to Current status by PR38.1 PR45.1 PR80.1
(Time Card Selection). A Current status PR89.1
record is taken in the next PR140 run.
If a Processed record is changed, the
run flag is set to spaces and the
employee's time records are set to Error
status. This forces you to rerun PR140.
1 = Future
2 = Current
4 = Processed
OTD-CHECK-GRP Alpha 1 BN66.1 PR139
Payment Group Contains the check group with which the PR140 PR195
deduction is associated. PR140 (Earnings PR39.1 PR39.2
and Deductions Calculation) uses the PR80.1 PR89.1
value in this field to determine if the
one-time deduction is included in the
group.
OTD-CHECK-DESC Alpha 8 (Lower Case) BN66.1 PR139
Payment Description Contains the payment description PR140 PR195
defined in PR39.1 (One Time Deduction) PR39.1 PR39.2
that overrides the payment description PR80.1 PR89.1
defined for the deduction.
For one-time arrears and one-time
deductions with no override payment
description, the system uses the
description in the Payment Description
field in the Deduction file.
ONETMDED FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OTDSET1 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
DED-CODE BN104 BN105
EDM-SEQ-NBR BN145 BN245
SEQ-NBR BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN45.1
BN531 BN65.1
BN66.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR511 PA02.1
PA100 PA102
PA502 PA52.1
...
OTDSET2 COMPANY KeyChange, Subset PR38.1
EMPLOYEE Where STATUS = 1
EFFECT-DATE
DED-CODE
EDM-SEQ-NBR
SEQ-NBR
OTDSET3 COMPANY KeyChange, Subset PR140
EMPLOYEE Where STATUS = 2
EFFECT-DATE
DED-PRIORITY
DED-CODE
EDM-SEQ-NBR
SEQ-NBR
ONETMDED FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
OTD-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Deduction Code DEDCODE Required
OTD-COMPANY -> DDC-COMPANY
OTD-DED-CODE -> DDC-DED-CODE
Employee EMPLOYEE Required
OTD-COMPANY -> EMP-COMPANY
OTD-EMPLOYEE -> EMP-EMPLOYEE
Process Level PRSYSTEM Required
When OTD-PROCESS-LEVEL != Spaces
OTD-COMPANY -> PRS-COMPANY
OTD-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
|