Functional Description
The purpose of this Named ER is to scrub and edit the pay type based on the processing options (#1, 2)
Setup Notes
Technical Specifications
Parameters
Data Item Data Structure DescriptionI/ORequiredTableNotes
PDBADBA Code I & O Grid PDBA Entered
OHFOvertime Code I
EV01Processing Option 1 value I 'U', 'E' or blank
PDBAPO2 PDBA1 I Blank
PDBAPO2 PDBA2 IA
PDBAPO2 PDBA3 IB
PDBAPO2 PDBA4 IC
PDBAPO2 PDBA5 ID
DEDMMethod of Calculation O
IIAPAuto Pay Methods O
NMTHEffect on GL O
PAYGEffect on Gross Pay O
PAYMMultiplier Pay Type MultiplierO
DEP1Deduction Period 1 O
DEP2Deduction Period 2 O
DEP3Deduction Period 3 O
DEP4Deduction Period 4 O
DEP5Deduction Period 5 O
PAYNEffect on Net Pay O
PBSource of PayO
PCKMethod of Printing O
CMTHShif/Diff Calc O Used in rate calcs
TT01Non-Taxable Authority Types 01O
TT02Non-Taxable Authority Types 02O
TT03Non-Taxable Authority Types 03O
TT04Non-Taxable Authority Types 04O
TT05Non-Taxable Authority Types 01O
TT06Non-Taxable Authority Types 06O
TT07Non-Taxable Authority Types 07O
TT08Non-Taxable Authority Types 08O
TT09Non-Taxable Authority Types 09O
TT10Non-Taxable Authority Types 10O
TT11Non-Taxable Authority Types 11O
TT12Non-Taxable Authority Types 12O
TT13Non-Taxable Authority Types 13O
TT14Non-Taxable Authority Types 14O
TT15Non-Taxable Authority Types 15O
EXRName/Explanation O If PO 10 = '1', GC EXR = EXA (F069116)
RTAMAmount or Rate O Used in Rates Calc
* - may have EV01 (PO1) and PAY 5 times corresponding the (PO2)'85assign this parm's in mbf before calling this. (in begin doc cache the po's coming
in'85then will have po values through mbf)
Related Tables
Table Table Description
F069116Transaction Parameters File
Processing
1.Scrub and edit - Pay/Deduction/Benefit Type
A, B, C, D, or is blank use the Rate from the Union Rates File; or if pay type is one from processing options, assume A, B, C, D. Update the hidden
field OHF Overtime Code with the letter that corresponds to the Pay Type for the Union Table. (see processing option #2) If the Pay Type was left
blank or it is the 'Regular' pay type, update OHF with an 'R'.
If occupational rate table used, (proc opt #1 is set to 'E') default pay type to proc opt. for regular pay only. Do not update OHF.
During the change mode, if the Pay Type field is changed on an existing record issue a 'soft' error, #2271. Update workfield HSERR with 'Y'.
Validate the pay type using the XS069116 server as follows:
If all edits are passed, save the following fields for future reference (write to cache). If any edits are not passed, do not continue editing.
IIAPAuto Pay Methods
NMTHEffect on GL
PAYGEffect on Gross Pay
PAYMMultiplier - Pay Type Multiplier
DEP1 Deduction Period 1
DEP2 Deduction Period 2
DEP3 Deduction Period 3
DEP4 Deduction Period 4
DEP5 Deduction Period 5
PAYN Effect on Net Pay
PB Source of Pay
PCK Method of Printing
TT01 Non-Taxable Authority Types 01
TT02 Non-Taxable Authority Types 02
TT03 Non-Taxable Authority Types 03
TT04 Non-Taxable Authority Types 04
TT05 Non-Taxable Authority Types 05
TT06 Non-Taxable Authority Types 06
TT07 Non-Taxable Authority Types 07
TT08 Non-Taxable Authority Types 08
TT09Non-Taxable Authority Types 09
TT10 Non-Taxable Authority Types 10
TT11 Non-Taxable Authority Types 11
TT12 Non-Taxable Authority Types 12
TT13 Non-Taxable Authority Types 13
TT14 Non-Taxable Authority Types 14
TT15Non-Taxable Authority Types 15
SHDShift Differential * used in Shift Diff calc
CMTHShift Diff Calc Sequence
If Processing Option #10 is set to '1', update the Grid field EXR with EXA from F069116.
If PO1 = 'U'
If substr(GC PDBA,0,1) = blank or GC PDBA = PDBA1
OHF = R
PDBA = PDBA1
End
If substr(GC PDBA,0,1) = 'A' or GC PDBA = PDBA2
OHF = A
PDBA = PDBA2
End
If substr(GC PDBA,0,1) = 'B' or GC PDBA = PDBA3
OHF = B
PDBA = PDBA3
End
If substr(GC PDBA,0,1) = 'C' or GC PDBA = PDBA4
OHF = C
PDBA = PDBA4
End
If substr(GC PDBA,0,1) = 'D' or GC PDBA = PDBA5
OHF = D
PDBA = PDBA5
End
End
If PO1 = 'E'
If substr(GC PDBA,0,1) = blank or GC PDBA = PDBA1
OHF = blank (no assignment needed)
PDBA = PDBA1
End
End
If PO 1 = 'U' '85.OHF = 'R'
OHF = Blank (default)
If PO1= ' ' (default)
Fetch against F069116 using PDBA as key
If successful:
If DISO != 'P'
If SACC !- blank, and RSC = blank
Fetch from F060116 using??
If FICM = 'C' and TT01 from F069116 != '*'
Error #4575
Exit NER
If PO10 = '1'
GC EXR = EXA (F069116) ** Put this in mbf when return **
Return Error ID to MBF..set error, highlight PDBA. IF ERRORS LEAVE MBF..DO NOT CONTINUE.
HSERR If Form mode = UPDATE'85soft error'85keep track that it has changed..
When calculating Gross Pay
If OHF != 'R' and rate came from Union (SEC$ = 'U') and rate hasn't changed'85paym = '1' (NOT USED HERE****** SEC$ is set when rate is derived)
^
DN050006 - Scrub and Edit DBA Code
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cOvertimeCode | OHF | char | NONE | NONE |
This code is used to designate the type of overtime being entered. The codes have the following meaning:
1 Regular Overtime
2
| ||||
cDeductionBenefitMethod | DEDM | char | NONE | NONE |
A user defined code (07/DM) that specifies the method that the system uses to perform certain calculations. For example, the system uses
| ||||
cIncludeInAutoPayCode | IIAP | char | NONE | NONE |
A code that determines how the system treats this pay type when computing automatically generated pay (typically for salaried
| ||||
cEmployeeMemoHoursFlag | NMTH | char | NONE | NONE |
A code that indicates whether the system writes journal entries from the Payroll system to the general ledger, and the method to use.
Valid
| ||||
cGrossPayEffect | PAYG | char | NONE | NONE |
A code that indicates whether the pay type is added to, subtracted from, or does not affect the employee's gross pay. Valid values
| ||||
mnMultiplierPayTypeMult | PAYM | MATH_NUMERIC | NONE | NONE |
A factor by which the base hourly rate is multiplied to obtain the actual payment hourly rate. For example, you could use 1.5 to designate
| ||||
cDeductionPeriod001 | DEP1 | char | NONE | NONE |
A code designating the pay period in which the system calculates the DBA/auto deposit. Valid codes are:
Y
Take the DBA/auto deposit
| ||||
cDeductionPeriod002 | DEP2 | char | NONE | NONE |
A code designating the pay period in which the system calculates the DBA/auto deposit. Codes are:
Y
Take the DBA/auto deposit during
| ||||
cDeductionPeriod003 | DEP3 | char | NONE | NONE |
A code designating the pay period in which the system calculates the DBA/auto deposit. Codes are:
Y
Take the DBA/auto deposit during
| ||||
cDeductionPeriod004 | DEP4 | char | NONE | NONE |
A code designating the pay period in which the system calculates the DBA/auto deposit. Codes are:
Y
Take the DBA/auto deposit during
| ||||
cDeductionPeriod005 | DEP5 | char | NONE | NONE |
A code designating the pay period in which the system calculates the DBA/auto deposit. Codes are:
Y
Take the DBA/auto deposit during
| ||||
cNetPayEffect | PAYN | char | NONE | NONE |
A code that indicates whether the pay type is added to, subtracted from, or does not affect the employee's net pay.
Valid values are:
+
| ||||
cPayBasis | PB | char | NONE | NONE |
A user defined code (07/PB) that defines the value upon which the system bases the employee's pay. H (hours worked) is the default
| ||||
cPrintOnPaycheckYN | PCK | char | NONE | NONE |
A code that identifies whether the PDBA is to be printed on the paystub or whether it is to be printed on a payment that is separate from
| ||||
szTaxExemptTypes01 | TT01 | char | NONE | NONE |
You can specify up to 15 tax types for which the respective payroll tax is not to be computed for a pay, deduction, or benefit code.
If you
| ||||
szTaxExemptTypes02 | TT02 | char | NONE | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
| ||||
szTaxExemptTypes03 | TT03 | char | NONE | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
| ||||
szTaxExemptTypes04 | TT04 | char | NONE | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
| ||||
szTaxExemptTypes05 | TT05 | char | NONE | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
| ||||
szTaxExemptTypes06 | TT06 | char | NONE | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
| ||||
szTaxExemptTypes07 | TT07 | char | NONE | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
| ||||
szTaxExemptTypes08 | TT08 | char | NONE | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
| ||||
szTaxExemptTypes09 | TT09 | char | NONE | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
| ||||
szTaxExemptTypes10 | TT10 | char | NONE | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
| ||||
szTaxExemptTypes11 | TT11 | char | NONE | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
| ||||
szTaxExemptTypes12 | TT12 | char | NONE | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
| ||||
szTaxExemptTypes13 | TT13 | char | NONE | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
| ||||
szTaxExemptTypes14 | TT14 | char | NONE | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
| ||||
szTaxExemptTypes15 | TT15 | char | NONE | NONE |
You may specify up to 15 tax types for which the respective payroll tax is NOT to be computed for a pay, deduction, or benefit code.
If you
| ||||
mnPayDeductBenAccType | PDBA | MATH_NUMERIC | NONE | NONE |
A code that defines the type of pay, deduction, benefit, or accrual.
Pay types are numbered from 1 to 999. Deductions and benefits are
| ||||
mnPayDeductBenAccType_Blk | PDBA | MATH_NUMERIC | NONE | NONE |
A code that defines the type of pay, deduction, benefit, or accrual.
Pay types are numbered from 1 to 999. Deductions and benefits are
| ||||
mnPayDeductBenAccType_A | PDBA | MATH_NUMERIC | NONE | NONE |
A code that defines the type of pay, deduction, benefit, or accrual.
Pay types are numbered from 1 to 999. Deductions and benefits are
| ||||
mnPayDeductBenAccType_B | PDBA | MATH_NUMERIC | NONE | NONE |
A code that defines the type of pay, deduction, benefit, or accrual.
Pay types are numbered from 1 to 999. Deductions and benefits are
| ||||
mnPayDeductBenAccType_C | PDBA | MATH_NUMERIC | NONE | NONE |
A code that defines the type of pay, deduction, benefit, or accrual.
Pay types are numbered from 1 to 999. Deductions and benefits are
| ||||
mnPayDeductBenAccType_D | PDBA | MATH_NUMERIC | NONE | NONE |
A code that defines the type of pay, deduction, benefit, or accrual.
Pay types are numbered from 1 to 999. Deductions and benefits are
| ||||
cProcessiongOption1 | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cErrorFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cTransactTypeTimePay | DISO | char | NONE | NONE |
A code used to distinguish between the following types of payroll entries:
P
Time Cards (Earnings)
D
Deductions withheld
B
Benefit (both
| ||||
szSpendingAccountType | SACC | char | NONE | NONE |
Defines which type of spending account is being used. An example of a spending account type setup might be:
MED Medical expenses
| ||||
cTaxCalcMethod | FICM | char | NONE | NONE |
A code that specifies the tax method that the Vertex payroll-tax calculation system uses to calculate certain taxes. The codes are defined in
| ||||
szNameAlphaExplanation | EXA | char | NONE | NONE |
A description, remark, explanation, name, or address. | ||||
cRecordStatusCode | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
szErrorNumber | ERNO | char | NONE | NONE |
The error number assigned by the JDE edit/update programs designating the exact error that occured. | ||||
mnAmtShiftDifferential | SHD | MATH_NUMERIC | NONE | NONE |
An additional rate, expressed in dollars or percent, added to an employee's hourly rate, depending on the shift worked. This rate can be
| ||||
cShiftDiffCalcSequence | CMTH | char | NONE | NONE |
A code that specifies how the system should calculate shift differential.
1 The pay type multiplier is applied to the shift differential: Gross
| ||||
mnAmtOrRate | RTAM | MATH_NUMERIC | NONE | NONE |
A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used. Valid values are:
1
For a deduction,
| ||||
mnJobnumberA | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
cEnableLeaveTracking | LVPT | char | OPT | NONE |
A code that enables two types of leave tracking and verification. You can enable leave tracking for this pay type so that the system
|
None |
None |