| Column | Type | Length | Contents |
|---|
| CtID | int | | Code table ID |
| CtType | char | 6 | Code type |
| Code1 | char | 12 | Valid codes for CtType (e.g. for CtType=ADVIS, FYA=four-year advisor; for CtType=CC, ET=Ethiopia; etc.) |
| EffDt | datetime | | Beginning date that the code is valid |
| EndDt | datetime | | Ending date the the code is valid |
| RestrictFlag | char | 1 | Restrict flag (N=no, Y=yes) |
| Code2 | char | 12 | Second valid code |
| Code3 | char | 12 | Third valid code |
| CodeValue | varchar | 40 | Code value (e.g. for CtType=ADVIS and Code1=FYA, CodeValue=Four Year Advisor) |
| DefaultValue | char | 12 | Default value |
| MaintDt | datetime | | Last date record was updated |
| LastChgName | char | 45 | Name of last user who updated the record |