AccessUser

Primary key - Unique identifier for each user account in the system

Social Security Number - Encrypted personal identifier for payroll and tax reporting purposes

Account status - Current status of the user account (Active, Inactive, Suspended, etc.) controlling system access

First name - User’s given name for identification and display purposes

Middle name - User’s middle name or initial for complete identification

Last name - User’s surname for identification and alphabetical sorting

Professional title reference - Links to lookup table for professional titles (Dr., Mr., Ms., etc.)

Contact notes - Administrative notes about contacting or working with this user

Gender - User’s gender for demographic reporting and appropriate assignment matching

Hire date - Date when the user was hired by the agency for employment tracking

Birth date - User’s date of birth for age verification and demographic reporting

Email address - Primary email for system notifications, password resets, and communication

Login password - Encrypted password for user authentication (legacy field, see UserPasswords table)

Agency affiliation - Links user to iCS2.dbo.Agency for centralized healthcare provider organization management and multi-tenant access control

User group - Legacy group assignment for role-based permissions (see UserInGroups for current implementation)

Employee identifier - Agency-specific employee ID for payroll and HR integration

Account creation date - Timestamp when the user account was first created in the system

Home address - User’s primary street address for contact and emergency purposes

Home city - City of user’s primary residence

Home state - State/province of user’s primary residence

Rate classification - Reference to rate structure for payroll and billing calculations

Postal code - ZIP/postal code for user’s primary address

Address line 2 - Additional address information (apartment, suite, etc.)

Alternate address line 1 - Secondary address for user contact

Alternate address line 2 - Additional information for secondary address

Alternate city - City for secondary address

Alternate state - State/province for secondary address

Alternate postal code - ZIP/postal code for secondary address

Employment status - Current employment status with the agency (Active, Terminated, On Leave, etc.)

Mailing address preference - Indicates which address to use for official mailings

Company identifier - External company/organization identifier for integration purposes

Login username - Unique username for system authentication (may differ from email)

Salutation - Preferred salutation for formal communications (Dr., Mr., Ms., etc.)

Job title - User’s professional job title or position within the agency

Termination date - Date when user’s employment ended (if applicable)

User category - Links to UserCategory table for user classification and permissions

Pay type - Links to UserPayType table for payroll classification (salary, hourly, contract, etc.)

Pay category - Links to UserPayCategory table for detailed payroll categorization

Primary site assignment - Links to AgencySite table for user’s primary work location

Created by user - UserID of the administrator who created this account

Last update date - Timestamp of the most recent profile update

Updated by user - UserID of the person who last modified this account

Digital signature - User’s digital signature for electronic document signing

Supervisor reference - UserID of this user’s direct supervisor for approval workflows

Support level - User’s support/supervision level for clinical oversight requirements

Pay discipline - Links to discipline table for payroll rate determination

NYS supervisor - UserID of supervisor for New York State regulatory compliance

Import identifier - Reference ID for data migration and import tracking

Board of Education flag - Indicates if user works with Board of Education programs

Payment processor data - Encrypted payment processing information for user billing

Professional occupation - User’s professional occupation or specialty area

Work organization - Name of user’s primary work organization or department

Home phone - User’s home telephone number for emergency contact

Work phone - User’s work telephone number for business communication

Mobile phone - User’s mobile/cell phone number for urgent contact

Additional phone - Alternative phone number for user contact

Administrative notes - General notes about the user for administrative reference

Time clock code - Secure passcode for time clock system authentication

Work location - User’s primary work location or office designation

Time clock expiration - Date when time clock access expires for security

Login attempt limit - Maximum number of failed login attempts before account lockout

Authentication token - Secure token for API access and single sign-on integration

Chat enabled - Flag indicating whether user has access to internal chat/messaging features

Paylocity integration ID - External payroll system identifier for integration

Welcome email date - Timestamp when welcome email was sent to new user

Alert notifications - Flag controlling whether user receives system alert notifications