I wonder why they are switching

campkev

I am currently writing a conversion application to convert data from one document tracking system to another. Below is some anonymized sample data from the timesheet table of the source database. No constraints, no foreign keys, no sanity. All the fields with [] around the name are varchar(255) fields. And in case you are wondering, no that isn't an anonymization mistake in the last two rows. They actually have records in the timesheet table for both a truck and a person with the same employee number.

docid	[employee name]	[employee number]	[date]	[document type]	[work order number]	[vehicle number]	createdate
158689	NULL	NULL	NULL	NULL	NULL	NULL	2003-07-14 17:48:52.357
159387	SMITH BOB	555	NULL	NULL	NULL	NULL	2003-07-14 17:48:57.217
159428	CHICK JEEP	865	12/19/97	NULL	NULL	NULL	2003-07-14 17:48:57.513
219711	JOHNSON, STEVE	986	04/11/02	ANNLV	NULL	NULL	2003-07-14 17:56:06.700
447890	MILLER DICK, WALTERS CHRIS, BIRD SUE, PERVIS JOE, WILSON KENNTY	587,695,875,124,986	03/15/06	TIMHT	213,253,990	1044,1030	2006-03-20 22:43:39.180
187186	PICKUP, 1998 FORD SERV TRUCK	2012	06/13/01	TIMSHT	NULL	NULL	2003-07-14 17:52:14.200
466310	TRASK MANNY, HUDSON KATY, SALLY JON	251, 541, 741	06/26/07	06/26/07	NULL	2101, 3001, 2011	2007-06-28 00:21:41.450
674235	PICKUP, 1997 FORD SERV TRUCK	1044	12/9/2002	TIMSHT	NULL	NULL	2003-08-21 18:43:43.113
473397	SEAVER, TOM	1044	01/15/08	TIMSHT	NULL	1044	2008-01-17 21:06:01.503

Zylon

@campkev said:

And in case you are wondering, no that isn't an anonymization mistake in the last two rows. They actually have records in the timesheet table for both a truck and a person with the same employee number.

Polymorphism, doi. Why do you hate object-oriented design?

cconroy

WTF is a "CHICK JEEP"?

campkev

@cconroy said:

WTF is a "CHICK JEEP"?

Based on the the database design, I can confidently say that I have NFI.

snover

Based on the name above that (Smith Bob), maybe they don’t actually know the name of that employee and just refer to her as the Jeep Chick. Of course, that just raises more questions…

SlyEcho

Maybe it's a Jeep that female employees (chicks) drive. Like a pink one or something.

AJAXdrivenBuzzwords

Who is this TIM and why is he SHTing all over the place?

@cconroy said:

WTF is a "CHICK JEEP"?

TheRider

@cconroy said:

WTF is a "CHICK JEEP"?

Its the opposite of a "Jeep Chick"