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 PR130 PR131 PR132
PR134 PR136 PR14.1 PR15.1 PR15.2 PR205
PR214 PR239 PR26.1 PR26.2 PR29.1 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
PR529 PR530 PR560 PR82.1 UK102 TA147
UK120
UPDATED BY
BN66.1 HR11.1 HR11.2 HR511 HR650 PA02.1
PA100 PA102 PA13.1 PA13.2 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PR110 PR113
PR120 PR13.1 PR13.5 PR13.6 PR13.8 PR137
PR139 PR140 PR189 PR195 PR197 PR36.1
PR38.1 PR39.1 PR39.2 PR45.1 PR80.1 PR80.3
PR89.1 PR999 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OTD-COMPANY Numeric 4 BN66.1 PR139
Company The company number represents an PR140 PR189
established company and is entered on PR195 PR39.1
all function codes. PR39.2 PR80.1
PR80.3 PR89.1
OTD-EMPLOYEE Numeric 9 BN66.1 PR139
Employee Valid in the Employee file. PR140 PR189
PR195 PR39.1
PR39.2 PR80.1
PR80.3 PR89.1
OTD-DED-CODE Alpha 4 BN66.1 PR139
Deduction Code Valid in the Deduction file. PR140 PR189
PR195 PR39.1
PR39.2 PR80.1
PR80.3 PR89.1
OTD-EDM-SEQ-NBR Numeric 4 BN66.1 PR139
Emp Deduction Contains an automatically assigned PR140 PR189
Sequence Number number to keep records unique. PR195 PR39.1
PR39.2 PR80.1
PR80.3 PR89.1
OTD-SEQ-NBR Numeric 4 BN66.1 PR139
Sequence Number Contains the one-time deduction PR140 PR189
sequence number. The value in this field PR195 PR39.1
is automatically sequenced based on the PR39.2 PR80.1
value in the Last Deduction Sequence Nbr PR80.3 PR89.1
field in the Employee file.
OTD-PROCESS-LEVEL Alpha 5 BN66.1 HR11.1
Process Level Contains the employee's process level. HR11.2 HR511
The value in this field defaults from HR650 PA02.1
the Process Level field in the Employee PA100 PA102
file. When you update processed one-time PA13.1 PA13.2
deductions the system uses the value in PA502 PA513
this field to set the PR140 (Earnings PA52.1 PA52.3
and Deductions Calculation) run flag to PA52.4 PA52.5
spaces for this process level. PR110 PR113
PR120 PR13.1
When you run PR199 (Payroll Close) by PR13.5 PR13.6
process level, the system uses the value PR13.8 PR139
in this field to determine if the PR140 PR189
one-time deduction should be updated PR195 PR39.1
during the run. PR39.2 PR80.1
PR80.3 PR89.1
OTD-DED-AMT Signed 13.2 BN66.1 PR139
Deduction Amount Contains the deduction amount entered PR140 PR189
in PR39.1 (One Time Deduction) or PR195 PR39.1
calculated by PR140 (Earnings and PR39.2 PR80.1
Deductions Calculation). PR80.3 PR89.1
OTD-EFFECT-DATE Numeric 8 (yyyymmdd) BN66.1 PR139
Effective Date Contains the effective date of the PR140 PR189
one-time deduction. For the system to PR195 PR39.1
take the deduction, the value in this PR39.2 PR80.1
field must be equal or less than the PR80.3 PR89.1
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 PR189
created arrears deductions G PR195 PR39.1
(Garnishment) and W (Withholding) cannot PR39.2 PR80.1
be maintained by PR39.1 (One Time PR80.3 PR89.1
Deduction). PR999 (Payroll Year End
Close) deletes system- created
Withholding type records.
G = Garnishment
T = Tax
OTD-DED-PRIORITY Numeric 1 BN66.1 PR139
Deduction Priority Contains the deduction priority. The PR140 PR189
value in the Ded Priority field in the PR195 PR39.1
Deduction file defaults to this file for PR39.2 PR80.1
arrears deductions and one-time PR80.3 PR89.1
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 PR189
PR140 (Earnings and Deductions PR195 PR197
Calculation). PR80.1 PR80.3
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 = 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 PR140
deduction. A Future status record cannot PR189 PR195
be taken by PR140 (Earnings and PR197 PR36.1
Deductions Calculation) until it is PR38.1 PR39.1
changed to Current status by PR38.1 PR39.2 PR45.1
(Time Card Selection). A Current status PR80.1 PR80.3
record is taken in the next PR140 run. PR89.1
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 PR189
deduction is associated. PR140 (Earnings PR195 PR39.1
and Deductions Calculation) uses the PR39.2 PR80.1
value in this field to determine if the PR80.3 PR89.1
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 PR189
defined in PR39.1 (One Time Deduction) PR195 PR39.1
that overrides the payment description PR39.2 PR80.1
defined for the deduction. PR80.3 PR89.1
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 BN66.1 PR140
Currency Code This field contains the company base PR189 PR195
currency code established in Company PR39.1 PR39.2
(GL10.1 ). PR80.1 PR80.3
PR89.1
OTD-CURR-ND Numeric 1 BN66.1 PR140
Currency Number of Represents the number of decimals PR189 PR195
Decimals defined for the currency of the object. PR39.1 PR39.2
PR80.1 PR80.3
PR89.1
OTD-BEN-PLAN-TYPE Alpha 2 PR39.1 PR80.3
Ben Plan Type
OTD-BEN-PLAN-CODE Alpha 4 PR39.1 PR80.3
Ben Plan Code
OTD-BEN-START-DATE Numeric 8 (yyyymmdd) PR39.1 PR80.3
Ben Start Date
OTD-CHECK-ID Numeric 12 BN66.1 PR139
Internal Check ID Contains the payment identification PR140 PR189
Number number (unique payment identifier used PR195 PR80.1
in tracking payment information). PR89.1
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
HR11.1 HR11.2
HR511 HR650
...
OTDSET2 COMPANY KeyChange, Subset PR38.1
EMPLOYEE Where STATUS = 1
EFFECT-DATE
DED-CODE
EDM-SEQ-NBR
SEQ-NBR
OTDSET3 COMPANY KeyChange, Subset BN66.1 PR140
EMPLOYEE Where STATUS = 2 PR189 PR195
EFFECT-DATE PR80.1 PR89.1
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
|
