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
AC541 AC542 BN100 BN101 BN102 BN103
BN104 BN105 BN145 BN150 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 PR05.1 PR128 PR131 PR132 PR134
PR136 PR14.1 PR15.1 PR15.2 PR205 PR214
PR239 PR26.1 PR26.2 PR32.2 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR47.1 PR47.2 PR514 PR530 PR82.1
UK102 UK120
UPDATED BY
BN66.1 HR511 HR650 PA502 PA513 PR13.1
PR13.5 PR13.6 PR13.8 PR137 PR139 PR195
PR197 PR36.1 PR38.1 PR39.1 PR39.2 PR45.1
PR89.1 PR999
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OTD-COMPANY Numeric 4 PR139 PR39.1
Company The company number represents an PR39.2
established company and is entered on
all function codes.
OTD-EMPLOYEE Numeric 9 PR139 PR39.1
Employee Valid in the Employee file. PR39.2
OTD-DED-CODE Alpha 4 PR139 PR39.1
Deduction Code Valid in the Deduction file. PR39.2
OTD-EDM-SEQ-NBR Numeric 4 PR139 PR39.1
Emp Deduction Contains an automatically assigned
Sequence Number number to keep records unique.
OTD-SEQ-NBR Numeric 4 PR139 PR39.1
Sequence Number Contains the one-time deduction PR39.2
sequence number. The value in this field
is automatically sequenced based on the
value in the Last Deduction Sequence Nbr
field in the Employee file.
OTD-PROCESS-LEVEL Alpha 5 HR511 HR650
Process Level Contains the employee's process level. PA502 PA513
The value in this field defaults from PR13.1 PR13.5
the Process Level field in the Employee PR13.6 PR13.8
file. When you update processed one-time PR139 PR39.1
deductions the system uses the value in PR39.2
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 13.2 PR139 PR39.1
Deduction Amount Contains the deduction amount entered PR39.2
in PR39.1 (One Time Deduction) or
calculated by PR140 (Earnings and
Deductions Calculation).
OTD-EFFECT-DATE Numeric 8 (yyyymmdd) PR139 PR39.1
Effective Date Contains the effective date of the PR39.2
one-time deduction. For the system to
take the deduction, the value in this
field must be equal or less than the
payment date entered in PR140 (Earnings
and Deductions Calculation).
OTD-DED-TYPE Alpha 1 PR139 PR39.1
Deduction Type Contains the deduction type. System PR39.2
created arrears deductions G
(Garnishment) and W (Withholding) cannot
be maintained by PR39.1 (One Time
Deduction). PR999 (Payroll Year End
Close) deletes system- created
Withholding type records.
G = Garnishment
T = Tax
OTD-DED-PRIORITY Numeric 1 PR139 PR39.1
Deduction Priority Contains the deduction priority. The PR39.2
value in the Ded Priority field in the
Deduction file defaults to this file for
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 PR195 PR197
PR140 (Earnings and Deductions PR89.1
Calculation).
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 = Payment Arrears
S = System Temporary
T = Temp Taken
N = No Payment Arrears
M = Manual Selected Blank
X = Manual Selected Arrears
Z = Manual Selected No Pmt Arrears
" " = User Entered (Blank)
OTD-STATUS Numeric 1 BN66.1 PR137
Status Contains the status of the one-time PR139 PR195
deduction. A Future status record cannot PR197 PR36.1
be taken by PR140 (Earnings and PR38.1 PR39.1
Deductions Calculation) until it is PR39.2 PR45.1
changed to Current status by PR38.1 PR89.1
(Time Card Selection). A Current status
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 PR139 PR39.1
Payment Group Contains the check group with which the PR39.2
deduction is associated. PR140 (Earnings
and Deductions Calculation) uses the
value in this field to determine if the
one-time deduction is included in the
group.
OTD-CHECK-DESC Alpha 8 (Lower Case) PR139 PR39.1
Payment Description Contains the payment description PR39.2
defined in PR39.1 (One Time Deduction)
that overrides the payment description
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.
OTD-CURRENCY-CODE Alpha 5 PR39.1 PR39.2
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
OTD-CURR-ND Numeric 1 PR39.1 PR39.2
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
OTD-BEN-PLAN-TYPE Alpha 2 PR39.1
Ben Plan Type
OTD-BEN-PLAN-CODE Alpha 4 PR39.1
Ben Plan Code
OTD-BEN-START-DATE Numeric 8 (yyyymmdd) PR39.1
Ben Start Date
OTD-CHECK-ID Numeric 12 BN66.1 PR139
Internal Check ID Contains the payment identification PR195 PR89.1
Number number (unique payment identifier used
in tracking payment information).
ONETMDED FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OTDSET1 COMPANY AC541 AC542
EMPLOYEE BN100 BN101
DED-CODE BN102 BN103
EDM-SEQ-NBR BN104 BN105
SEQ-NBR BN145 BN150
BN245 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
HR511 HR650
PA502 PA513
...
OTDSET2 COMPANY KeyChange, Subset PR38.1
EMPLOYEE Where STATUS = 1
EFFECT-DATE
DED-CODE
EDM-SEQ-NBR
SEQ-NBR
OTDSET3 COMPANY KeyChange, Subset
EMPLOYEE Where STATUS = 2
EFFECT-DATE
DED-PRIORITY
DED-CODE
EDM-SEQ-NBR
SEQ-NBR
OTDSET4 COMPANY KeyChange PR239
PROCESS-LEVEL
EMPLOYEE
DED-CODE
EDM-SEQ-NBR
SEQ-NBR
OTDSET5 COMPANY KeyChange
DED-CODE
EMPLOYEE
EDM-SEQ-NBR
SEQ-NBR
OTDSET6 COMPANY Subset
EMPLOYEE Where BEN-PLAN-TYPE != Spaces
BEN-START-DATE
BEN-PLAN-TYPE
BEN-PLAN-CODE
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 (PRSSET1)
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
|
