gistfile1.txt

mysql> describe cim_hrdb_year_in_school;
+-----------+----------+------+-----+---------+----------------+
| Field     | Type     | Null | Key | Default | Extra          |
+-----------+----------+------+-----+---------+----------------+
| year_id   | int(11)  | NO   | PRI | NULL    | auto_increment | 
| year_desc | char(50) | NO   |     |         |                | 
+-----------+----------+------+-----+---------+----------------+
2 rows in set (0.00 sec)

mysql> describe cim_hrdb_person_year;   
+---------------+---------+------+-----+------------+----------------+
| Field         | Type    | Null | Key | Default    | Extra          |
+---------------+---------+------+-----+------------+----------------+
| personyear_id | int(50) | NO   | PRI | NULL       | auto_increment | 
| person_id     | int(50) | NO   | MUL | 0          |                | 
| year_id       | int(50) | NO   | MUL | 0          |                | 
| grad_date     | date    | YES  |     | 0000-00-00 |                | 
+---------------+---------+------+-----+------------+----------------+
4 rows in set (0.00 sec)

mysql> select * from cim_hrdb_year_in_school;
+---------+----------------------+
| year_id | year_desc            |
+---------+----------------------+
|       1 | 1st Year (Undergrad) | 
|       2 | 2nd Year (Undergrad) | 
|       3 | 3rd Year (Undergrad) | 
|       4 | 4th Year (Undergrad) | 
|       5 | 5th Year (Undergrad) | 
|       6 | 1st Year (Grad)      | 
|       7 | 2nd Year (Grad)      | 
|       8 | 3rd Year (Grad)      | 
|       9 | Other                | 
|      10 | Alumni               | 
+---------+----------------------+
10 rows in set (0.02 sec)

mysql> describe cim_hrdb_assignment;
+---------------------+---------+------+-----+---------+----------------+
| Field               | Type    | Null | Key | Default | Extra          |
+---------------------+---------+------+-----+---------+----------------+
| assignment_id       | int(50) | NO   | PRI | NULL    | auto_increment | 
| person_id           | int(50) | NO   | MUL | 0       |                | 
| campus_id           | int(50) | NO   | MUL | 0       |                | 
| assignmentstatus_id | int(10) | NO   |     | 0       |                | 
+---------------------+---------+------+-----+---------+----------------+
4 rows in set (0.01 sec)

mysql> describe cim_hrdb_assignmentstatus;
+-----------------------+-------------+------+-----+---------+----------------+
| Field                 | Type        | Null | Key | Default | Extra          |
+-----------------------+-------------+------+-----+---------+----------------+
| assignmentstatus_id   | int(10)     | NO   | PRI | NULL    | auto_increment | 
| assignmentstatus_desc | varchar(64) | NO   |     |         |                | 
+-----------------------+-------------+------+-----+---------+----------------+
2 rows in set (0.01 sec)

mysql> select * from cim_hrdb_assignmentstatus;
+---------------------+-----------------------+
| assignmentstatus_id | assignmentstatus_desc |
+---------------------+-----------------------+
|                   1 | Current Student       | 
|                   2 | Alumni                | 
|                   3 | Staff                 | 
|                   4 | Attended              | 
|                   5 | Staff Alumni          | 
|                   0 | Unknown Status        | 
|                   6 | Campus Alumni         | 
+---------------------+-----------------------+
7 rows in set (0.02 sec)