Shipping method code table needs a clean up and we need to separate the who from the how

[ccicero]

I'm working on a loan right now that will be shipped to Norway via World Courier. That is not an option now in the Shipped Method. We could either add it as a method or add a generic 'other' and put the method in the shipment remarks, since this probably won't be a common method used (it's the first time in my 30+ years that we've used it, but that's what the Norwegians want).

@Jegelewicz @dustymc Thoughts?

[dustymc]

https://arctos.database.museum/info/ctDocumentation.cfm?table=ctshipped_carrier_method, not https://arctos.database.museum/info/ctDocumentation.cfm?table=ctshipment_type, correct?

Agree with something generic, I'm actually not sure all the existing companies in there make sense nowadays - if you've got a tracking number you can figure out who you shipped with from it, and if you don't have that then this isn't doing you much good anyway!

[Jegelewicz]

I mean, Alaska Air Cargo is in there....

but a generic shipper might be good - the code table needs some definitions.

[Jegelewicz]

But also - shouldn't these just be agents?

[ccicero]

That makes sense to have them as agents, but there are also other options such as 'electronic' (for media) or 'hand carried'

correct @dustymc https://arctos.database.museum/info/ctDocumentation.cfm?table=ctshipped_carrier_method

So what to do now as I need to get this loan sent?

[campmlc]

Let's add "World Courier" for now so Carla can do her loan. I do need hand-carried, so unless we also shift that to hand-carried by agent, recommend we just leave for now.

[Jegelewicz]

So this table is a mix of who and how. Seems like it should just be how. Who should come from agents (who was the hand carrier?).

To get the loan out, maybe just add something generic, but this needs more thought and I think we can do better.

[Jegelewicz]

+1 for adding World Courier" we can convert to an agent later if we go that way.

[ccicero]

OK, great! I agree that it would be better to separate the who from the how: who ---> agents how ---> maybe something simple like:

cargo/mail electronic hand carried

each of those could have an agent attached so you know who hand carried, sent, or shipped it

I'll go ahead and add World Courier for now. Thanks!

[Jegelewicz]

I'll hijack this issue so we can get the bigger picture on the to do list.

[ccicero]

While I'm at it, I took a first stab at definitions in https://arctos.database.museum/info/ctDocumentation.cfm?table=ctshipped_carrier_method. Most were just 'pending' previously.

[Jegelewicz]

I don't know why this was closed. We still need to clean up this code table.

[mkoo]

I see serviceable definitions in the entire code table. Closing for now and open a new one if there's something new to be done