(carrier = insurance company that we're trying to get a license from)
They also told me that License Status and Appointment Status are different - here is what they gave me:
I know this is a lot, and I'd normally be able to do this on my own, but I haven't delt with a layout as complex as this one before.
I'm looking for someone who could help me with the layout of a database for keeping track of the above.
Any help is very much appreciated!
In my experience, if you don't know how to structure the database, you need to understand the business process better.
- Is the "appointment" a test-like session with some sort of pass/fail? (Do you need to track multiple attempts to qualify for the one license?)
- Does the license expire and can be renewed, or is a new one needed, with (perhaps) a new "appointment"?