Wage Codes
Use this service to add or update wage codes assigned to unions.
Connection Information
URL = https://<SPECTRUM-SERVER>:8482/payroll/wagecode
Authentication: Basic Authentication, Enhanced Authentication
Supported methods: POST
Supported formats: JSON
Sample JSON Body
{
"wageCodes": [
{
"Company_Code": "ABC",
"Wage_Code": "WC",
"Union_Code": "DF001",
"Full_Description": "Full Description!!",
"Abbrev_Description": "Desc",
"Workers_Comp_Code": "8000",
"Certified_Labor_Code": "66",
"Benefit_Tier_Code": "",
"Status": "A",
"Effective_Date": "",
"Regular_Std_Job_Rate": 9999.999,
"Overtime_Std_Job_Rate": -9999.999,
"Double_Time_Std_Job_Rate": 123,
"Total_Regular_Rate_Level_1": 1.00,
"Total_Regular_Rate_Level_2": 2.34,
"Total_Regular_Rate_Level_3": 3.4,
"Total_Regular_Rate_Level_4": 4,
"Total_Regular_Rate_Level_5": 5.6,
"Total_Regular_Rate_Level_6": 6.78,
"Total_Regular_Rate_Level_7": 7.890,
"Total_Regular_Rate_Level_8": 8.90,
"Total_Regular_Rate_Level_9": 9.0,
"Regular_Base_Rate_Level_1": 1.123,
"Regular_Base_Rate_Level_2": 2.34,
"Regular_Base_Rate_Level_3": 3.4,
"Regular_Base_Rate_Level_4": 4,
"Regular_Base_Rate_Level_5": 5.6,
"Regular_Base_Rate_Level_6": 6.78,
"Regular_Base_Rate_Level_7": 7.890,
"Regular_Base_Rate_Level_8": 8.90,
"Regular_Base_Rate_Level_9": 9.0,
"Total_Overtime_Rate_Level_1": 1.123,
"Total_Overtime_Rate_Level_2": 2.34,
"Total_Overtime_Rate_Level_3": 3.4,
"Total_Overtime_Rate_Level_4": 4,
"Total_Overtime_Rate_Level_5": 5.6,
"Total_Overtime_Rate_Level_6": 6.78,
"Total_Overtime_Rate_Level_7": 7.890,
"Total_Overtime_Rate_Level_8": 8.90,
"Total_Overtime_Rate_Level_9": 9.0,
"Overtime_Base_Rate_Level_1": 1.123,
"Overtime_Base_Rate_Level_2": 2.34,
"Overtime_Base_Rate_Level_3": 3.4,
"Overtime_Base_Rate_Level_4": 4,
"Overtime_Base_Rate_Level_5": 5.6,
"Overtime_Base_Rate_Level_6": 6.78,
"Overtime_Base_Rate_Level_7": 7.890,
"Overtime_Base_Rate_Level_8": 8.90,
"Overtime_Base_Rate_Level_9": 9.0,
"Total_Double_Time_Rate_Level_1": 1.123,
"Total_Double_Time_Rate_Level_2": 2.34,
"Total_Double_Time_Rate_Level_3": 3.4,
"Total_Double_Time_Rate_Level_4": 4,
"Total_Double_Time_Rate_Level_5": 5.6,
"Total_Double_Time_Rate_Level_6": 6.78,
"Total_Double_Time_Rate_Level_7": 7.890,
"Total_Double_Time_Rate_Level_8": 8.90,
"Total_Double_Time_Rate_Level_9": 9.0,
"Double_Time_Base_Rate_Level_1": 1.123,
"Double_Time_Base_Rate_Level_2": 2.34,
"Double_Time_Base_Rate_Level_3": 3.4,
"Double_Time_Base_Rate_Level_4": 4,
"Double_Time_Base_Rate_Level_5": 5.6,
"Double_Time_Base_Rate_Level_6": 6.78,
"Double_Time_Base_Rate_Level_7": 7.890,
"Double_Time_Base_Rate_Level_8": 8.90,
"Double_Time_Base_Rate_Level_9": 9.0,
"Bill_Code_Level_1": "L1",
"Bill_Code_Level_2": "LF",
"Bill_Code_Level_3": "O1",
"Bill_Code_Level_5": "",
"Bill_Code_Level_6": "T1",
"Bill_Code_Level_7": "T1",
"Bill_Code_Level_8": "TO",
"Bill_Code_Level_9": " "
}
]
}Underlying File Maintenance
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 |
Wage Code |
YES |
Text |
10 |
Unique code |
||
|
D |
Union_Code |
Union Code |
YES | Text | 10 | Union File Maintenance | |
|
E |
Full_Description |
Full Description |
Text |
30 |
|||
|
F |
Abbrev_Description |
Abbreviated Description |
Text |
10 |
|||
|
G |
Workers_Comp_Code |
Workers Comp Code |
Text |
6 |
Workers Comp Maintenance |
||
|
H |
Certified_Labor_Code |
Certified Labor Code |
Text |
20 |
|||
|
I |
Benefit_Tier_Code |
Benefit Tier Code |
Text |
10 |
Benefit Tiers for the Union code listed above (PR_UNION_BENEFIT_TIER_MC) |
||
|
J |
Status |
Status |
Text |
1 |
(A)ctive or (Inactive). Defaults to Active if blank. |
||
|
K |
Effective_Date |
Effective Date |
Date |
10 |
Enter MM/DD/CCYY |
||
|
L |
Regular_Std_Job_Rate |
Regular Standard Job Rate |
Numeric |
9 |
Format = -5.3 |
||
|
M |
Overtime_Std_Job_Rate |
Overtime Standard Job Rate |
Numeric |
9 |
Format = -5.3 |
||
|
N |
Double_Time_Std_Job_Rate |
Double Time Standard Job Rate |
Numeric |
9 |
Format = -5.3 |
||
|
O |
Total_Regular_Rate_Level_1 |
Total regular rate level 1 |
Numeric |
9 |
Format = -5.3 |
||
|
P |
Total_Regular_Rate_Level_2 |
Total regular rate level 2 |
Numeric |
9 |
Format = -5.3 |
||
|
Q |
Total_Regular_Rate_Level_3 |
Total regular rate level 3 |
Numeric |
9 |
Format = -5.3 |
||
|
R |
Total_Regular_Rate_Level_4 |
Total regular rate level 4 |
Numeric |
9 |
Format = -5.3 |
||
|
S |
Total_Regular_Rate_Level_5 |
Total regular rate level 5 |
Numeric |
9 |
Format = -5.3 |
||
|
T |
Total_Regular_Rate_Level_6 |
Total regular rate level 6 |
Numeric |
9 |
Format = -5.3 |
||
|
U |
Total_Regular_Rate_Level_7 |
Total regular rate level 7 |
Numeric |
9 |
Format = -5.3 |
||
|
V |
Total_Regular_Rate_Level_8 |
Total regular rate level 8 |
Numeric |
9 |
Format = -5.3 |
||
|
W |
Total_Regular_Rate_Level_9 |
Total regular rate level 9 |
Numeric |
9 |
Format = -5.3 |
||
|
X |
Regular_Base_Rate_Level_1 |
Base regular rate level 1 |
Numeric |
9 |
Format = -5.3 |
||
|
Y |
Regular_Base_Rate_Level_2 |
Base regular rate level 2 |
Numeric |
9 |
Format = -5.3 |
||
|
Z |
Regular_Base_Rate_Level_3 |
Base regular rate level 3 |
Numeric |
9 |
Format = -5.3 |
||
|
AA |
Regular_Base_Rate_Level_4 |
Base regular rate level 4 |
Numeric |
9 |
Format = -5.3 |
||
|
AB |
Regular_Base_Rate_Level_5 |
Base regular rate level 5 |
Numeric |
9 |
Format = -5.3 |
||
|
AC |
Regular_Base_Rate_Level_6 |
Base regular rate level 6 |
Numeric |
9 |
Format = -5.3 |
||
|
AD |
Regular_Base_Rate_Level_7 |
Base regular rate level 7 |
Numeric |
9 |
Format = -5.3 |
||
|
AE |
Regular_Base_Rate_Level_8 |
Base regular rate level 8 |
Numeric |
9 |
Format = -5.3 |
||
|
AF |
Regular_Base_Rate_Level_9 |
Base regular rate level 9 |
Numeric |
9 |
Format = -5.3 |
||
|
AG |
Total_Overtime_Rate_Level_1 |
Numeric |
9 |
Format = -5.3 |
|||
|
AH |
Total_Overtime_Rate_Level_2 |
Numeric |
9 |
Format = -5.3 |
|||
|
AI |
Total_Overtime_Rate_Level_3 |
Numeric |
9 |
Format = -5.3 |
|||
|
AJ |
Total_Overtime_Rate_Level_4 |
Numeric |
9 |
Format = -5.3 |
|||
|
AK |
Total_Overtime_Rate_Level_5 |
Numeric |
9 |
Format = -5.3 |
|||
|
AL |
Total_Overtime_Rate_Level_6 |
Numeric |
9 |
Format = -5.3 |
|||
|
AM |
Total_Overtime_Rate_Level_7 |
Numeric |
9 |
Format = -5.3 |
|||
|
AN |
Total_Overtime_Rate_Level_8 |
Numeric |
9 |
Format = -5.3 |
|||
|
AO |
Total_Overtime_Rate_Level_9 |
Numeric |
9 |
Format = -5.3 |
|||
|
AP |
Overtime_Base_Rate_Level_1 |
Numeric |
9 |
Calculates from base rate if blank. Format = -5.3 |
|||
|
AQ |
Overtime_Base_Rate_Level_2 |
Numeric |
9 |
Format = -5.3 |
|||
|
AR |
Overtime_Base_Rate_Level_3 |
Numeric |
9 |
Format = -5.3 |
|||
|
AS |
Overtime_Base_Rate_Level_4 |
Numeric |
9 |
Format = -5.3 |
|||
|
AT |
Overtime_Base_Rate_Level_5 |
Numeric |
9 |
Format = -5.3 |
|||
|
AU |
Overtime_Base_Rate_Level_6 |
Numeric |
9 |
Format = -5.3 |
|||
|
AV |
Overtime_Base_Rate_Level_7 |
Numeric |
9 |
Format = -5.3 |
|||
|
AW |
Overtime_Base_Rate_Level_8 |
Numeric |
9 |
Format = -5.3 |
|||
|
AX |
Overtime_Base_Rate_Level_9 |
Numeric |
9 |
Format = -5.3 |
|||
|
AY |
Total_Double_Time_Rate_Level_1 |
Numeric |
9 |
Format = -5.3 |
|||
|
AZ |
Total_Double_Time_Rate_Level_2 |
Numeric |
9 |
Format = -5.3 |
|||
|
BB |
Total_Double_Time_Rate_Level_3 |
Numeric |
9 |
Format = -5.3 |
|||
|
BC |
Total_Double_Time_Rate_Level_4 |
Numeric |
9 |
Format = -5.3 |
|||
|
BD |
Total_Double_Time_Rate_Level_5 |
Numeric |
9 |
Format = -5.3 |
|||
|
BE |
Total_Double_Time_Rate_Level_6 |
Numeric |
9 |
Format = -5.3 |
|||
|
BF |
Total_Double_Time_Rate_Level_7 |
Numeric |
9 |
Format = -5.3 |
|||
|
BG |
Total_Double_Time_Rate_Level_8 |
Numeric |
9 |
Format = -5.3 |
|||
|
BH |
Total_Double_Time_Rate_Level_9 |
Numeric |
9 |
Format = -5.3 |
|||
|
BI |
Double_Time_Base_Rate_Level_ 1 |
Numeric |
1 |
Calculates from base rate if blank. Format = -5.3 |
|||
|
BJ |
Double_Time_Base_Rate_Level_ 2 |
Numeric |
1 |
Format = -5.3 |
|||
|
BK |
Double_Time_Base_Rate_Level_ 3 |
Numeric |
1 |
Format = -5.3 |
|||
|
BL |
Double_Time_Base_Rate_Level_4 |
Numeric |
1 |
Format = -5.3 |
|||
|
BM |
Double_Time_Base_Rate_Level_5 |
Numeric |
1 |
Format = -5.3 |
|||
|
BN |
Double_Time_Base_Rate_Level_ 6 |
Numeric |
1 |
Format = -5.3 |
|||
|
BO |
Double_Time_Base_Rate_Level_7 |
Numeric |
1 |
Format = -5.3 |
|||
|
BP |
Double_Time_Base_Rate_Level_8 |
Numeric |
1 |
Format = -5.3 |
|||
|
BQ |
Double_Time_Base_Rate_Level_ 9 |
Numeric |
1 |
Format = -5.3 |
|||
|
BR |
Bill_Code_Level_1 |
Text |
10 |
T&M Billing Code Maintenance |
|||
|
BS |
Bill_Code_Level_2 |
Text |
10 |
T&M Billing Code Maintenance |
|||
|
BT |
Bill_Code_Level_3 |
Text |
10 |
T&M Billing Code Maintenance |
|||
|
BU |
Bill_Code_Level_4 |
Text |
10 |
T&M Billing Code Maintenance |
|||
|
BV |
Bill_Code_Level_5 |
Text |
10 |
T&M Billing Code Maintenance |
|||
|
BW |
Bill_Code_Level_6 |
Text |
10 |
T&M Billing Code Maintenance |
|||
|
BX |
Bill_Code_Level_7 |
Text |
10 |
T&M Billing Code Maintenance |
|||
|
BY |
Bill_Code_Level_8 |
Text |
10 |
T&M Billing Code Maintenance |
|||
|
BZ |
Bill_Code_Level_9 |
Text |
10 |
T&M Billing Code Maintenance |
