|
|
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 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 PR35.9 PR47.1 PR47.2 PR529 PR530
PR560 PR82.1 UK102 UK47.1 UK47.2 TA147
TP135
UPDATED BY
HR11.1 HR11.2 HR511 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 PR197 PR36.1
PR38.1 PR39.1 PR39.2 PR45.1 PR999 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OTD-COMPANY Numeric 4 PR39.1 PR39.2
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
OTD-EMPLOYEE Numeric 9 PR39.1 PR39.2
Element: Employee Valid in the Employee file.
OTD-DED-CODE Alpha 4 PR39.1 PR39.2
Element: Deduction CodeValid in the Deduction file.
OTD-EDM-SEQ-NBR Numeric 4 PR39.1 PR39.2
Emp Deduction Contains an automatically assigned
Sequence Number number to keep records unique.
OTD-SEQ-NBR Numeric 4 PR39.1 PR39.2
Element: Sequence NumbeContains 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.
OTD-PROCESS-LEVEL Alpha 5 HR11.1 HR11.2
Element: Process Lev HrContains the employee's process level. HR511 PA02.1
The value in this field defaults from PA100 PA102
the Process Level field in the Employee PA13.1 PA13.2
file. When you update processed one-time PA502 PA513
deductions the system uses the value in PA52.1 PA52.3
this field to set the PR140 (Earnings PA52.4 PA52.5
and Deductions Calculation) run flag to PR110 PR113
spaces for this process level. PR120 PR13.1
PR13.5 PR13.6
When you run PR199 (Payroll Close) by PR13.8 PR39.1
process level, the system uses the value PR39.2
in this field to determine if the
one-time deduction should be updated
during the run.
OTD-DED-AMT Signed 13.2 PR39.1 PR39.2
Element: Deduction AmouContains the deduction amount entered
in PR39.1 (One Time Deduction) or
calculated by PR140 (Earnings and
Deductions Calculation).
OTD-EFFECT-DATE Numeric 8 (yyyymmdd) PR39.1 PR39.2
Element: Effective DateContains 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).
OTD-DED-TYPE Alpha 1 PR39.1 PR39.2
Element: Deduction TypeContains 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
OTD-DED-PRIORITY Numeric 1 PR39.1 PR39.2
Element: Deduction PrioContains 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.
OTD-RECORD-TYPE Alpha 1 PR197
Element: Record Type 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)
OTD-STATUS Numeric 1 PR137 PR197
Element: Status Contains the status of the one-time PR36.1 PR38.1
deduction. A Future status record cannot PR39.1 PR39.2
be taken by PR140 (Earnings and PR45.1
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
OTD-CHECK-GRP Alpha 1 PR39.1 PR39.2
Element: Payment Group 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.
OTD-CHECK-DESC Alpha 8 (Lower Case) PR39.1 PR39.2
Element: Payment DescriContains 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.
OTD-CURRENCY-CODE Alpha 5 PR39.1 PR39.2
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
OTD-CURR-ND Numeric 1 PR39.1 PR39.2
Account Currency Represents the number of decimals
Code defined for the currency of the object.
OTD-BEN-PLAN-TYPE Alpha 2 PR39.1
Element: Ben Plan Type
OTD-BEN-PLAN-CODE Alpha 4 PR39.1
Element: Ben Plan Code
OTD-BEN-START-DATE Numeric 8 (yyyymmdd) PR39.1
Element: Ben Start Date
OTD-CHECK-ID Numeric 12
Internal Check ID Contains the payment identification
Number number (unique payment identifier used
in tracking payment information).
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 BN150
SEQ-NBR 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 HR11.1
HR11.2 HR511
PA02.1 PA100
PA102 PA115
...
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 PR999
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
|
