I wonder why they are switching



  • 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


  • @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?



  •  WTF is a "CHICK JEEP"?



  • @cconroy said:

     WTF is a "CHICK JEEP"?

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



  • 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…



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



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



  • @cconroy said:

     WTF is a "CHICK JEEP"?

     

     



  • @cconroy said:

     WTF is a "CHICK JEEP"?

    Its the opposite of a "Jeep Chick"


Log in to reply
 

Looks like your connection to What the Daily WTF? was lost, please wait while we try to reconnect.