Fatal error: This message indicates an error exists in the file that the employer must fix and then re‐import the file. Follow the system prompt to remove the file from the system first and then resubmit the corrected file.
Fixable error: This message indicates an error in the file which can be fixed by employer on the site. Click the Fix Error Icon to begin correcting the error. Some errors require the employer to contact the Carpenters’ Employer Services Department. The Carpenters’ District Council (CDC) may update a Member/Trade level to match the employer’s import file. If this is not doable, then the employer must correct their file and re‐import.
Possible Whole File Errors
|
ERROR MESSAGE |
ERROR TYPE |
RESOLUTION |
|
Pay period does not match |
Fatal |
Fix file and re‐upload |
|
Check for employer block |
Fatal |
Call Employer Services 314‐644‐4802 x1030 or 877‐232‐3863 x1030 |
Possible Individual Record Errors
|
ERROR MESSAGE |
ERROR TYPE |
RESOLUTION |
|
Bad SSN (non‐numeric or <> 9 digits) |
Fatal |
Double check SSN. If incorrect, fix file and re‐ upload. |
|
Valid SSN that doesn’t exist |
Fixable |
Double check SSN. If correct then click Fix Error Icon and enter member’s info. |
|
Missing User Defined Codes |
Fixable |
Click on Fix Error Icon and select which Hours Type you want the listed User Defined Code to represent for the Hours Type on Estamps. |
|
Employer/Hours Type error |
Fatal |
This means you have used the wrong hours code for the member’s skill level (Ex. You used a 1st term apprentice code for a 5th term apprentice). You must fix this on the file and re‐upload. |
|
County error |
Fatal |
Make sure that if you are reporting commercial work you did not leave this column blank. This could also mean you are using a county that is not associated with the Hours Type you are reporting. Fix the file and re‐upload. |
|
Validate Member/trade levels |
Fixable by CRC |
Call CRC at (314)644‐4800 or Toll Free at (800)332‐7188 |
|
Regular and Overtime Hours error |
Fatal |
Make sure these fields are not blank. If member has zero hours worked in either field you must type “0” in the column. Fix file and re‐upload. |
|
Hours type code is mapped to a code that is not active for this period. |
Fatal |
Call Employer Services 314‐644‐4802 x1030 or 877‐232‐3863 x1030 |
|
Invalid Prevailing Wage Category for hours type |
Fixable |
Double check PWC. If incorrect, fix file and re‐ upload. |
Duplicate Rows Reported: If there is a carpenter with more than one line on an import file, the system will combine duplicates (based on SSN, pay period, hours type, county code) and notify you that those lines were combined.
|
COUNTY CODE LIST FOR ALL COUNTIES & STATES IN THE CARPENTERS’ DISTRICT COUNCIL OF GREATER ST LOUIS & VICINITY JURISDICTION | |||||
|
Import |
County Description |
Import |
County Description |
Import |
County Description |
|
AD |
Adair, MO |
COF |
Coffey, KS |
HAR |
Hardin, IL |
|
ALEX |
Alexander IL |
CO |
Cole, MO |
HRP |
Harper, KS |
|
ALN |
Allen, KS |
COM |
Comanche, KS |
HARR |
Harrison, MO |
|
AN |
Anderson, KS |
COOP |
Cooper, MO |
HRV |
Harvey, KS |
|
AND |
Andrew MO |
COW |
Cowley, KS |
HAS |
Haskell, KS |
|
ATC |
Atchison MO |
CRW |
Crawford, KS |
HEN |
Henry, MO |
|
AT |
Atchison, KS |
CR |
Crawford, MO |
HIC |
Hickory, MO |
|
AU |
Audrain, MO |
DA |
Dade, MO |
HOD |
Hodgeman, KS |
|
BARB |
Barber, KS |
DAL |
Dallas, MO |
HOL |
Holt, MO |
|
BARR |
Barry, MO |
DAV |
Davies, MO |
HOWD |
Howard, MO |
|
BAR |
Barton, KS |
DEC |
Decatur, KS |
HOW |
Howell, MO |
|
BART |
Barton, MO |
DEK |
DeKalb, MO |
IR |
Iron, MO |
|
BAT |
Bates, MO |
DE |
Dent, MO |
JACK |
Jackson, IL |
|
BEN |
Benton, MO |
DI |
Dickinson, KS |
JA |
Jackson, KS |
|
BOL |
Bollinger, MO |
DON |
Doniphan, KS |
JAC |
Jackson, MO |
|
BOND |
Bond, IL |
DO |
Douglas, KS |
JAS |
Jasper, MO |
|
BOO |
Boone, MO |
DOU |
Douglas, MO |
JEFF |
Jefferson, IL |
|
BOU |
Bourbon, KS |
DUN |
Dunklin, MO |
JEF |
Jefferson, KS |
|
BRO |
Brown, KS |
EDW |
Edwards, IL |
JE |
Jefferson, MO |
|
BUCH |
Buchanan, MO |
ED |
Edwards, KS |
JER |
Jersey, IL |
|
BUTL |
Butler, KS |
ELK |
Elk, KS |
JEW |
Jewell, KS |
|
BUT |
Butler, MO |
EL |
Ellis, KS |
JOHN |
Johnson, IL |
|
CALD |
Caldwell, MO |
ELLS |
Ellsworth, KS |
JOH |
Johnson, KS |
|
CAL |
Calhoun, IL |
EXMT |
EXEMPT |
JO |
Johnson, MO |
|
CALL |
Callaway, MO |
FAY |
Fayette, IL |
KE |
Kearney, KS |
|
CAM |
Camden, MO |
FIN |
Finney, KS |
KIN |
Kingman, KS |
|
CAPE |
Cape Girardeau, MO |
FO |
Ford, KS |
KIO |
Kiowa, KS |
|
CARR |
Carroll, MO |
FRAN |
Franklin, IL |
KN |
Knox, MO |
|
CAR |
Carter, MO |
FRA |
Franklin, KS |
LAB |
Labette, KS |
|
CA |
Cass, MO |
FR |
Franklin, MO |
LAC |
Laclede, MO |
|
CE |
Cedar, MO |
GALL |
Gallatin, IL |
LAF |
Lafayette, MO |
|
CHA |
Chariton, MO |
GA |
Gasconade, MO |
LAN |
Lane, KS |
|
CH |
Chase, KS |
GEA |
Geary, KS |
LAW |
Lawrence, IL |
|
CHAU |
Chautauqua, KS |
GEN |
Gentry, MO |
LAWR |
Lawrence, MO |
|
CHE |
Cherokee, KS |
GO |
Gove, KS |
LEA |
Leavenworth, KS |
|
CHEY |
Cheyenne, KS |
GR |
Graham, KS |
LE |
Lewis, MO |
|
CHR |
Christian, MO |
GRA |
Grant, KS |
LINC |
Lincoln, KS |
|
CLK |
Clark County, MO |
GRAY |
Gray, KS |
LI |
Lincoln, MO |
|
CLAY |
Clay, IL |
GREE |
Greeley, KS |
LINN |
Linn, KS |
|
CLY |
Clay, KS |
GRN |
Greene, MO |
LIN |
Linn, MO |
|
CL |
Clay, MO |
GRE |
Greenwood,KS |
LIV |
Livingston, MO |
|
CLIN |
Clinton, IL |
GRU |
Grundy, MO |
LO |
Logan, KS |
|
CLI |
Clinton, MO |
HAM |
Hamilton, IL |
LY |
Lyon, KS |
|
CLO |
Cloud, KS |
HA |
Hamilton, KS |
MAC |
Macon, MO |
|
COUNTY CODE LIST FOR ALL COUNTIES & STATES IN THE CARPENTERS’ DISTRICT COUNCIL OF GREATER ST LOUIS & VICINITY JURISDICTION CONT. | |||||
|
Import |
County Description |
Import |
County Description |
Import |
County Description |
|
MADI |
Madison, IL |
PER |
Perry, MO |
STC |
St. Charles County, MO |
|
MAD |
Madison, MO |
PET |
Pettis, MO |
STCL |
St. Clair, IL |
|
MRS |
Maries, MO |
PH |
Phelps, MO |
STF |
St. Francois, MO |
|
MAR |
Marion, IL |
PHI |
Phillips, KS |
STEG |
St. Genevieve, MO |
|
MARI |
Marion, KS |
PI |
Pike, MO |
STL |
St. Louis City, MO |
|
MRN |
Marion, MO |
PLA |
Platte, MO |
STLC |
St. Louis County, MO |
|
MARS |
Marshall, KS |
POL |
Polk, MO |
STA |
Stafford, KS |
|
MASS |
Massac, IL |
POP |
Pope, IL |
STAN |
Stanton, KS |
|
MCD |
McDonald, MO |
POT |
Pottawatomie, KS |
STE |
Stevens, KS |
|
MCP |
McPherson, KS |
PR |
Pratt, KS |
STOD |
Stoddard, MO |
|
MEA |
Meade, KS |
PUL |
Pulaski, IL |
STO |
Stone, MO |
|
MER |
Mercer, MO |
PU |
Pulaski, MO |
SUL |
Sullivan, MO |
|
MIA |
Miami, KS |
PUT |
Putnam, MO |
SUM |
Sumner, KS |
|
MIL |
Miller, MO |
RA |
Ralls, MO |
TAN |
Taney, MO |
|
MIS |
Mississippi, MO |
RAN |
Randolph, IL |
TX |
Texas, MO |
|
MIT |
Mitchell, KS |
RAND |
Randolph, MO |
THO |
Thomas, KS |
|
MONI |
Moniteau, MO |
RAW |
Rawlins, KS |
TR |
Trego, KS |
|
MONR |
Monroe, IL |
RAY |
Ray, MO |
UN |
Union, IL |
|
MNRW |
Monroe, MO |
REN |
Reno, KS |
VER |
Vernon, MO |
|
MONT |
Montgomery, KS |
REP |
Republic, KS |
WAB |
Wabash, IL |
|
MON |
Montgomery, MO |
RE |
Reynolds, MO |
WABA |
Wabaunsee, KS |
|
MOR |
Morgan, MO |
RIC |
Rice, KS |
WAL |
Wallace, KS |
|
MORR |
Morris, KS |
RICH |
Richland, IL |
WR |
Warren, MO |
|
MORT |
Morton, KS |
RIL |
Riley, KS |
WASH |
Washington, IL |
|
NEM |
Nemaha, KS |
RIP |
Ripley MO |
WAS |
Washington, KS |
|
NEO |
Neosho, KS |
RO |
Rooks, KS |
WA |
Washington, MO |
|
NES |
Ness, KS |
RU |
Rush, KS |
WAY |
Wayne, IL |
|
NEWM |
New Madrid, MO |
RUS |
Russell, KS |
WAYN |
Wayne, MO |
|
NEWT |
Newton, MO |
SAL |
Saline, IL |
WEB |
Webster, MO |
|
NOD |
Nodaway, MO |
SA |
Saline, KS |
WHI |
White, IL |
|
NO |
Norton, KS |
SALI |
Saline, MO |
WIC |
Wichita, KS |
|
ORE |
Oregon, MO |
SCH |
Schuyler, MO |
WILL |
Williamson, IL |
|
OSA |
Osage, KS |
SCTL |
Scotland, MO |
WILS |
Wilson, KS |
|
OS |
Osage, MO |
SCO |
Scott, KS |
WOOD |
Woodson, KS |
|
OSB |
Osborne, KS |
SCOT |
Scott, MO |
WO |
Worth, MO |
|
OT |
Ottawa, KS |
SED |
Sedgwick, KS |
WRT |
Wright, MO |
|
OTT |
Ottawa, OK |
SEW |
Seward, KS |
WY |
Wyandotte, KS |
|
OOA |
OUT OF AREA |
SH |
Shannon MO |
STC |
St. Charles County, MO |
|
OZK |
Ozark, MO |
SHA |
Shawnee, KS |
STCL |
St. Clair, IL |
|
PA |
Pawnee, KS |
GRN |
Greene, MO |
LIN |
Linn, MO |
|
PEM |
Pemiscot, MO |
GRE |
Greenwood, KS |
LIV |
Livingston, MO |
|
PERR |
Perry, IL |
GRU |
Grundy, MO |
LO |
Logan, KS |
|
MADI |
Madison, IL |
HAM |
Hamilton, IL |
LY |
Lyon, KS |
|
MAD |
Madison, MO |
HA |
Hamilton, KS |
MAC |
Macon, MO |