Union Deductions/Add-ons

Use this service to import Union Deductions and Add-on codes information.

Connection Information

URL = https://<SPECTRUM-SERVER>:8482/payroll/uniondedaddon

Authentication: Basic Authentication, Enhanced Authentication

Supported methods: POST

Supported formats: JSON

Sample JSON Body

{
	"unionDedAddOns": [
		{
			"Company_Code": "ABC",
			"Union_Code": "DF001",
			"Ded_Add_On_Code": "23",
			"Record_Type": "R",
			"Ded_Add_On_Description": "Description",
			"Method": "H",
			"Formula_Code": "",
			"Rate": 10,
			"Formula_Variable_1": 0,
			"Formula_Variable_2": 0,
			"Formula_Variable_3": 0,
			"Gross_Pay_Flag": "Y",
			"Override_GL_Account": "",
			"Status": "A",
			"Effective_Date": ""
		}
	]
}

Underlying File Maintenance

System Administration > Installation > Payroll > Deduction/Add-on Code Maintenance

System Administration > Installation > Payroll > Worker's Compensation Code Maintenance

System Administration > Installation > Payroll > Tax Table Maintenance

System Administration > Installation > Time + Material > Labor Billing Rates

Field Descriptions

Use the table below for reference when using this service.

Excel

 Element Name Description Req Type

Max

 Format Validation

B

 Company_Code

Company Code

 YES Text

3

 Valid Company in Spectrum

C

 Union_Code

Union Code

 YES Text

10

 Union File Maintenance

D

 Ded_Add_On_Code Deduction or Add-On Code YES Text

10

 Deduction/Add-on Maintenance Table (PR_VOL_DEDUCT_MASTER_MC)

E

Record_Type (if updating)

When updating this indicates whether the change is to rate or status, when adding a new deduction this field is ignored

YES (if updating)

Text

1

R = Rate change S = Status change

F

Ded_Add_On_Description

Description

Text

15

G

 Method Method YES Text

1

 G = % of gross B = % of base S = % of straight line R = Regular O = Overtime D = Double time A = All hours F = Fixed amount U = User-defined C = Prevailing wage adj H = Health and welfare N= Non-stated fringe

H

 Formula_Code Formula Code Text

5

 If Method = (U)ser-defined, this field is requiried, otherwise not available

I

 Rate Rate Numeric

7

 If NOT using Formula_Code Format = 3.3

J

 Formula_Variable_1 Formula Variable 1 (V1) Rate Numeric

7

 If using Formula_Code Format = 3.3

K

 Formula_Variable_2 Formula Variable 2 (V2) Rate Numeric

7

 If using Formula_Code Format = 3.3

L

 Formula_Variable_3 Formula Variable 3 (V3) Rate Numeric

7

 If using Formula_Code Format = 3.3

M

 Gross_Pay_Flag Include in Gross Pay Flag Text

1

 "Y" or "N" Include deduction in gross pay?

N

 Override_GL_Account GL Account Override Numeric

12

 Code must have an Active status G/L Master File Maintenance

O

 Status Text

1

 (A)ctive or (Inactive). Defaults to Active if blank

P

 Effective_Date Effective Date Date

10

 Enter MM/DD/CCYY Defaults to current payroll data