id                   integer                                 no
title                char(40)                                yes
rank                 char(2)                                 yes
campus               char(4)                                 no
bldg                 char(4)                                 no
room                 char(4)                                 no
pt                   char(1)                                 yes
ctrct                char(1)                                 yes
tenure_date          date                                    yes
ctrct_mos            smallint                                yes
ctrct_beg_date       date                                    yes
memo1                char(24)                                yes
memo2                char(24)                                yes
abbr_name            char(10)                                yes
stat                 char(1)                                 yes
stat_date            date                                    yes
accrl_meth           char(1)                                 yes
accrl_date           date                                    yes
dept                 char(4)                                 yes
prim_assoc           char(4)                                 yes
edu                  text                                    yes
interest             text                                    yes
url                  char(40)                                yes
phone                char(12)                                yes
email                char(3)                                 yes
titletxt             char(40)                                yes