Skip to main content

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.