COURSE STATUS CODES
The course list contains codes which give a bit of information. They are shown below:
A - Active course
04, 05 etc - Restored to list after 10 year expiration. "04," "05" refers to date of renewal.
X - Expired
D - Deleted by certifier
F - Failed post-race validation
M - No map on file - some early courses.
P - Passed post-race validation
R - Replaced by another course
U - Course unusable
V - Prevalidated
Sometimes two or more letters are used in combination. For example, "PD" means passed validation, but later deleted
Note: "Active" does not mean that the course is still used. It means only that the course has neither expired nor been deleted by the state certifier. A number of race courses have several certification numbers. In these cases, the latest number may be presumed to be the currently-used course.
Status Codes in the Course list
If it is known that due to road changes/construction the course as shown on the map is no longer accurate, which code should be used, course unusable?
That's right. Unusable.
Okay, I give up. Why can't I find any expired courses in the list I downloaded from the Website? I asked for the entire list, all fields.
I looked, but could find no courses with status "X".
What am I missing? Having expired courses in the list would help me in my endeavor to list all certified races in 2008, as a way to cross-check my info.
Thanks,
Confused
I looked, but could find no courses with status "X".
What am I missing? Having expired courses in the list would help me in my endeavor to list all certified races in 2008, as a way to cross-check my info.
Thanks,
Confused
If you downloaded all 29,000 courses, you should have no trouble finding one that's expired. If you didn't, I can send it to you.
You'll want Microsoft Access for best results.
You'll want Microsoft Access for best results.
I see now that I had to go over to the right and change "Active" to "Any". Now I am downloading all courses. My oversight.
Thanks
Thanks