ONETMDED

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.
UPDATED BY
BN100 BN101 BN102 BN103 BN104 BN105
BN145 BN150 BN245 BN305 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 ZB10.1 ZB31.1 ZB31.2 ZB32.1 ZB32.2
ZB32.3 HR11.1 HR11.2 HR28.1 HR511 LT101
PR521 ZH510 EXI2.1 EXI4.1 LP130 PA02.1
PA100 PA102 PA115 PA13.1 PA13.2 PA502
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PR05.1
PR110 PR113 PR12.6 PR120 PR128 PR13.1
PR13.2 PR13.5 PR13.6 PR13.8 PR13.9 PR130
PR131 PR132 PR134 PR135 PR136 PR137
PR139 PR14.1 PR14.2 PR140 PR15.1 PR15.2
PR189 PR195 PR197 PR205 PR214 PR239
PR26.1 PR26.2 PR29.1 PR30.2 PR32.1 PR32.2
PR33.1 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR35.9 PR36.1
PR37.1 PR38.1 PR39.1 PR39.2 PR39.4 PR45.1
PR47.1 PR47.2 PR514 PR529 PR530 PR539
PR560 PR582 PR80.1 PR80.3 PR80.4 PR82.1
PR89.1 PR999 UK102 UK47.1 UK47.2 UK560
ZP139 ZP530 TA147

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OTD-COMPANY
Element: Company Hr
Numeric 4
BN66.1 PR139
PR140 PR189
PR195 PR39.1
PR39.2 PR539
PR80.1 PR80.3
PR80.4 PR89.1
ZP139
OTD-EMPLOYEE
Element: Employee
Numeric 9
Valid in the Employee file.
BN66.1 PR139
PR140 PR189
PR195 PR39.1
PR39.2 PR539
PR80.1 PR80.3
PR80.4 PR89.1
ZP139
OTD-DED-CODE
Element: Ded Code
Alpha 4
Valid in the Deduction file.
BN66.1 PR139
PR140 PR189
PR195 PR39.1
PR39.2 PR539
PR80.1 PR80.3
PR80.4 PR89.1
ZP139
OTD-EDM-SEQ-NBR
Element: Edm Seq Nbr
Numeric 4
Contains an automatically assigned number to keep records unique.
BN66.1 PR139
PR140 PR189
PR195 PR39.1
PR39.2 PR539
PR80.1 PR80.3
PR80.4 PR89.1
ZP139
OTD-SEQ-NBR
Element: Seq Nbr
Numeric 4
Contains the one-time deduction 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.
BN66.1 PR139
PR140 PR189
PR195 PR39.1
PR39.2 PR539
PR80.1 PR80.3
PR80.4 PR89.1
ZP139
OTD-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
Contains the employee's process level. The value in this field defaults from the Process Level field in the Employee 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.
BN305 BN66.1
HR11.1 HR11.2
HR28.1 HR511
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR139 PR140
PR189 PR195
PR30.2 PR39.1
PR39.2 PR539
PR80.1 PR80.3
PR80.4 PR89.1
ZH510 ZP139
OTD-DED-AMT
Element: Ded Amt
Signed 13.2
Contains the deduction amount entered in PR39.1 (One Time Deduction) or calculated by PR140 (Earnings and Deductions Calculation).
BN66.1 PR139
PR140 PR189
PR195 PR39.1
PR39.2 PR539
PR80.1 PR80.3
PR80.4 PR89.1
ZP139
OTD-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
Contains the effective date of the 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).
BN66.1 PR139
PR140 PR189
PR195 PR39.1
PR39.2 PR539
PR80.1 PR80.3
PR80.4 PR89.1
ZP139
OTD-DED-TYPE
Element: Ded Type
Alpha 1
Contains the deduction type. System 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
BN66.1 PR139
PR140 PR189
PR195 PR39.1
PR39.2 PR539
PR80.1 PR80.3
PR80.4 PR89.1
ZP139
OTD-DED-PRIORITY
Element: Ded Priority
Numeric 1
Contains the deduction priority. The 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.
BN66.1 PR139
PR140 PR189
PR195 PR39.1
PR39.2 PR539
PR80.1 PR80.3
PR80.4 PR89.1
ZP139
OTD-RECORD-TYPE
Element: Record Type
Alpha 1
Contains the record type created by PR140 (Earnings and Deductions 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)
BN66.1 PR139
PR140 PR189
PR195 PR197
PR539 PR80.1
PR80.3 PR80.4
PR89.1 ZP139
OTD-STATUS
Element: Status
Numeric 1
Contains the status of the one-time deduction. A Future status record cannot be taken by PR140 (Earnings and Deductions Calculation) until it is changed to Current status by PR38.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
BN66.1 PR137
PR139 PR140
PR189 PR195
PR197 PR36.1
PR38.1 PR39.1
PR39.2 PR45.1
PR539 PR80.1
PR80.3 PR80.4
PR89.1 ZP139
OTD-CHECK-GRP
Element: Check Grp
Alpha 1
Contains the check group with which the 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.
BN66.1 PR139
PR140 PR189
PR195 PR39.1
PR39.2 PR539
PR80.1 PR80.3
PR80.4 PR89.1
ZP139
OTD-CHECK-DESC
Element: Check Desc
Alpha 8 (Lower Case)
Contains the payment description 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.
BN66.1 PR139
PR140 PR189
PR195 PR39.1
PR39.2 PR539
PR80.1 PR80.3
PR80.4 PR89.1
ZP139
OTD-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
BN66.1 PR140
PR189 PR195
PR39.1 PR39.2
PR539 PR80.1
PR80.3 PR80.4
PR89.1
OTD-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
BN66.1 PR140
PR189 PR195
PR39.1 PR39.2
PR539 PR80.1
PR80.3 PR80.4
PR89.1
OTD-BEN-PLAN-TYPE
Element: Ben Plan Type
Alpha 2
PR39.1 PR539
PR80.3
OTD-BEN-PLAN-CODE
Element: Ben Plan Code
Alpha 4
PR39.1 PR539
PR80.3
OTD-BEN-START-DATE
Element: Ben Start Date
Numeric 8 (yyyymmdd)
PR39.1 PR539
PR80.3
OTD-CHECK-ID
Element: Check Id
Numeric 12
Contains the payment identification number (unique payment identifier used in tracking payment information).
BN66.1 PR139
PR140 PR189
PR195 PR80.1
PR80.4 PR89.1
OTD-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
BN66.1 PR139
PR140 PR189
PR195 PR39.1
PR39.2 PR539
PR80.1 PR80.3
PR80.4 PR89.1
OTD-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN66.1 PR139
PR140 PR189
PR195 PR39.1
PR39.2 PR539
PR80.1 PR80.3
PR80.4 PR89.1
OTD-CREATE-USER-ID
Element: User Id
Alpha 10 (Lower Case)
Contains the user ID of the person who last changed this record.
BN66.1 PR139
PR140 PR189
PR195 PR39.1
PR39.2 PR539
PR80.1 PR80.3
PR80.4 PR89.1
OTD-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
BN305 BN66.1
HR11.1 HR11.2
HR28.1 HR511
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR137 PR139
PR140 PR189
PR195 PR197
PR30.2 PR36.1
PR38.1 PR39.1
PR39.2 PR45.1
PR539 PR80.1
PR80.3 PR80.4
PR89.1 ZH510
OTD-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN305 BN66.1
HR11.1 HR11.2
HR28.1 HR511
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR137 PR139
PR140 PR189
PR195 PR197
PR30.2 PR36.1
PR38.1 PR39.1
PR39.2 PR45.1
PR539 PR80.1
PR80.3 PR80.4
PR89.1 ZH510
OTD-USER-ID
Element: User Id
Alpha 10 (Lower Case)
Contains the user ID of the person who last changed this record.
BN305 BN66.1
HR11.1 HR11.2
HR28.1 HR511
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR137 PR139
PR140 PR189
PR195 PR197
PR30.2 PR36.1
PR38.1 PR39.1
PR39.2 PR45.1
PR539 PR80.1
PR80.3 PR80.4
PR89.1 ZH510


ONETMDED FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OTDSET1 COMPANY
EMPLOYEE
DED-CODE
EDM-SEQ-NBR
SEQ-NBR
...
BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
OTDSET2 COMPANY
EMPLOYEE
EFFECT-DATE
DED-CODE
EDM-SEQ-NBR
SEQ-NBR
KeyChange, Subset
WhereSTATUS =1
PR38.1
OTDSET3 COMPANY
EMPLOYEE
EFFECT-DATE
DED-PRIORITY
DED-CODE
EDM-SEQ-NBR
SEQ-NBR
KeyChange, Subset
WhereSTATUS =2
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1
OTDSET4 COMPANY
PROCESS-LEVEL
EMPLOYEE
DED-CODE
EDM-SEQ-NBR
SEQ-NBR
KeyChange
PR239 PR999


ONETMDED FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:27:07 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.