| Column name |
Type |
Definition |
| OBSERVER_JOIN |
number(6,0) |
A unique number that identifies a specific observer. |
| LAST_NAME |
varchar2(30) |
The last name of the observer. |
| MIDDLE_NAME |
varchar2(15) |
The middle name of the observer. |
| FIRST_NAME |
varchar2(15) |
The first name of the observer. |
| E-MAIL_ADDRESS |
varchar2(50) |
The e-mail address of the observer. |
| HOLD_LEVEL2_CERTIFICATION_FLAG |
varchar2(1) |
A one-digit alpha code. Y = Yes, the observer has Level 2 status; N = No, the observer does not have Level 2 status. |
| REHIRE_STATUS |
varchar2(2) |
A two-digit alpha code indicating the rehire status of the observer. EL = eligible for rehire; NE = not eligible for rehire; NA = not applicable (hasn't gone out yet). |
| SEX |
varchar2(1) |
The sex of the observer. M = Male; F = Female; U = Unknown. |
| DATE_OF_BIRTH |
date |
The date of the observer's birth. |
| PERMANENT_ADDRESS |
varchar2(50) |
The permanent street address of the observer. |
| PERMANENT_CITY |
varchar2(25) |
The permanent city address of the observer. |
| PERMANENT_STATE |
varchar2(2) |
The permanent state address of the observer. |
| PERMANENT_ZIPCODE |
varchar2(10) |
The permanent zipcode of the observer. |
| PERMANENT_PHONE |
number(10,0) |
The permanent phone number of the observer. |
| PREVIOUS_NAME |
varchar2(30) |
Any previous name of the observer. |
| RESUME_ON_FILE |
varchar2(1) |
A one-digit alpha code indicating whether the observer's resume is on file or not. Y = Yes; N = No. |
| LAST_PHYSICAL_DATE |
date |
The date of the observer's last physical. |
| ARCHIVED_FILE |
varchar2(1) |
A one-digit alpha code indicating whether the observer's file is present or not. Y = Yes; N = No. |
| PHOTO_PRESENT |
varchar2(1) |
A one-digit alpha code indicating whether the observer's photo is on file or not. Y = Yes; N = No. |
| CREATE_DATE |
date |
Date record was inputted into database. |
| CREATED_BY |
varchar2(30) |
Person who loaded data into database. |
| LAST_UPDATE_DATE |
date |
Date data record was last altered. First entered in December 2003. |
| LAST_UPDATED_BY |
varchar2(30) |
Person who last altered data record. First entered in December 2003. |
