Schema ndc_personnel has the following columns available:

• ndc_status (a dropdown list of things like Active Duty and Retired)
• ndc_branch (Navy, Legion, etc)
• ndc_jobcode (a dropdown list of all rank codes and ranks as listed on the NDC rank page)
• ndc_rank (a dropdown list of all rank codes and ranks as listed on the NDC rank page)
• ndc_assignment (wiki page of assignment, autocompletes)