SQL Table - RADplus_netsmart_university
Storage table for the Netsmart University section of the User Definition form.
| Table Column | Comment |
| ID | Unique row ID. |
| FACILITY | Associated facility. |
| USERID | User ID. |
| address_1 | Address 1 field. |
| address_2 | Address 2 field. |
| birthday | Birthday field. |
| cell_phone | Cell Phone field. |
| city | City field. |
| country | Country field. |
| county | County field. |
| date_of hire | Date of Hire field. |
| department | Department field. |
| department_ShVal |
|
| department_value |
|
| disability_code | Disability field code. |
| disability_value | Disability field value. |
| division | Division field. |
| email_address | E-mail Address field. |
| employee_number | Employee Number field. |
| employee_status | Emp Num field. |
| ethnicity_code | Ethnicity field code. |
| ethnicity_value | Ethnicity field value. |
| extension | Emp Num field. |
| first_name | First Name field |
| gender_code | Gender field code. |
| gender_value | Gender field value. |
| home_phone | Home Phone field. |
| job_code | Job Code field. |
| job_position | Job Position field. |
| job_title | Job Title field. |
| last_name | Last Name field. |
| location | Location field. |
| mail_stop | Mail Stop field. |
| marital_status_code | Marital Status field code. |
| marital_status_value | Marital Status field value. |
| middle_name | Middle Name or Initial field. |
| original_hire_date | Original Hire Date field. |
| pager | Pager field. |
| salutation_code | Salutation field code. |
| salutation_value | Salutation field value. |
| second_supervisor | Second Supervisor field. |
| smoker_code | Smoker field code. |
| smoker_value | Smoker field value. |
| ssn | Social Security Number field. |
| state | State field. |
| supervisor | Supervisor field. |
| user_defined | Sup field. |
| work_phone | Work Phone field. |
| zip_code | Zip Code field. |
