CaseAssigned_vw

User identifier - Unique identifier for the staff member assigned to the case

Social security number - Encrypted social security number of the staff member

User status - Current status of the user account (Active, Inactive, etc.)

First name - First name of the assigned staff member

Middle name - Middle name or initial of the assigned staff member

Last name - Last name of the assigned staff member

Professional title - Links to title table for the staff member’s professional title

Contact comments - Comments about contacting this staff member

Gender - Gender of the assigned staff member

Hire date - Date when the staff member was hired

Birth date - Date of birth of the staff member

Email address - Email address of the assigned staff member

Street address - Street address of the staff member

City - City of the staff member’s address

State - State of the staff member’s address

Rate title - Links to rate title table for billing rate classification

ZIP code - ZIP code of the staff member’s address

Address line 2 - Additional address information for the staff member

Agency status - Status of the staff member within the agency

Supervisor - Links to AccessUser table for the staff member’s supervisor

NYS supervisor - Links to AccessUser table for New York State regulatory supervisor

Agency reference - Links to Agency table for the employing agency

Company identifier - Company identifier for the staff member

Phone number - Phone number of the staff member

ID value - Identifier value (license number or other ID)

ID type - Type of identifier (license, certification, etc.)

Role identifier - Links to Roles table for the staff member’s role

Updated by - UserID of the person who last updated this record

Update date - Date when this record was last updated

Created by - UserID of the person who created this record

Entry date - Date when this record was entered

Discipline list - Comma-separated list of discipline role IDs

Role list - Comma-separated list of role names for the staff member

Pay type reference - Links to pay type table for payroll classification

Termination date - Date when the staff member was terminated (if applicable)

License number - Professional license number of the staff member

Team list - Comma-separated list of team group IDs

Team name list - Comma-separated list of team names

Paylocity identifier - Payroll system identifier

Site identifier - Links to AgencySite table for work location

Assignment primary key - Unique identifier for the user-patient assignment

Case identifier - Links to PatientAdministration table for the case

Assignment comments - Comments about the staff assignment to this case

Patient identifier - Links to Patient table for the assigned patient

Work phone - Work phone number of the staff member

Home phone - Home phone number of the staff member

Cell phone - Cell phone number of the staff member

Other phone - Alternative phone number of the staff member

Work name - Name of the workplace or employer

Alternative address - Alternative address for the staff member

Occupation - Professional occupation of the staff member

Alternative city - City of the alternative address

Alternative state - State of the alternative address

Alternative ZIP - ZIP code of the alternative address

Assignment notes - Additional notes about the assignment

Relationship - Relationship of the staff member to the patient

iCentral access flag - Indicates if the staff member has access to iCentral system

Send welcome email flag - Indicates if welcome email should be sent

Allow pickup flag - Indicates if this person is allowed to pick up the patient

Emergency contact flag - Indicates if this is an emergency contact

Primary guardian flag - Indicates if this is the primary guardian

Pay source flag - Indicates if this person is responsible for payment

Welcome email sent - Status and date of welcome email sending

Assignment role ID - Role identifier for this specific assignment