AccessUserCustom


Description

Extended user profile information containing additional custom fields and professional details for healthcare providers. This table stores specialized information such as credentials, certifications, training records, and other professional qualifications required for healthcare service delivery.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkID int identity 4 √ null

Primary key - Unique identifier for each custom user profile record
fkUserID int 4 null
AccessUser.UserID FK_AccessUserCustom_AccessUser R

User reference - Links to AccessUser table for the associated user account
Suffix nvarchar 1073741823 √ null

Name suffix - Professional or personal suffix (Jr., Sr., III, etc.)
Agency nvarchar 1073741823 √ null

Agency information - Additional agency or organization details
SecondaryPhone nvarchar 100 √ null

Secondary phone - Additional phone number for user contact
TextingNumber nvarchar 510 √ null

Text messaging number - Phone number for SMS notifications and communication
Fax nvarchar 100 √ null

Fax number - Fax number for document transmission
PrimaryAddress nvarchar 1073741823 √ null

Primary address - Complete primary address information
ProviderSpecialty nvarchar 1073741823 √ null

Provider specialty - Healthcare provider’s area of specialization or expertise
DateCreated datetime 16,3 √ null

Creation date - Timestamp when the custom profile was created
CreatedBy int 4 √ null

Created by user - UserID of the person who created this profile
DateUpdated datetime 16,3 √ null

Last update date - Timestamp of the most recent profile update
UpdatedBy int 4 √ null

Updated by user - UserID of the person who last modified this profile
DeletedDate datetime 16,3 √ null

Deletion date - Soft delete timestamp for audit trail purposes
Initials nvarchar 510 √ null

User initials - Professional initials for document signing and identification
Signature nvarchar 1073741823 √ null

Digital signature - Primary digital signature for electronic documents
SecondSignature nvarchar 1073741823 √ null

Secondary signature - Alternative digital signature for different document types
Languages nvarchar 1998 √ null

Languages spoken - List of languages the provider can communicate in
Regions nvarchar 1998 √ null

Service regions - Geographic regions where the provider can deliver services
Specialities nvarchar 1998 √ null

Specialties - Detailed list of provider’s professional specialties
IdentificationValue nvarchar 510 √ null

ID number - Professional identification number (license, certification, etc.)
IdentificationType nvarchar 510 √ null

ID type - Type of professional identification (license type, certification type, etc.)
Credentials nvarchar 510 √ null

Professional credentials - Academic degrees and professional certifications
EmployeeType nvarchar 1073741823 √ null

Employment type - Classification of employment (full-time, part-time, contractor, etc.)
LicenseExpiration nvarchar 510 √ null

License expiration - Date when professional license expires
CertificationNumber nvarchar 1073741823 √ null

Certification number - Professional certification identification number
CertificationExpiration nvarchar 510 √ null

Certification expiration - Date when professional certification expires
CertificationPermanent nvarchar 510 √ null

Permanent certification - Indicates if certification is permanent or requires renewal
PhysicalExpirationDate nvarchar 510 √ null

Physical exam expiration - Date when required physical examination expires
OPRARevalidationDate nvarchar 510 √ null

OPRA revalidation date - Date for OPRA (Office of Professional Responsibility and Accountability) revalidation
CPRTrainingExpirationDate nvarchar 510 √ null

CPR training expiration - Date when CPR certification expires
SexualHarassmentPreventionTrainingExpirationDate nvarchar 510 √ null

Sexual harassment training expiration - Date when required training expires
InfectionControltrainingExpirationDate nvarchar 510 √ null

Infection control training expiration - Date when infection control training expires
ScrClearanceReceived datetime 16,3 √ null

Background clearance date - Date when background screening clearance was received
ActivityDate datetime 16,3 √ null

Activity date - Date of recorded activity or event
ActivityEndTime nvarchar 510 √ null

Activity end time - End time for recorded activity
ActivityNotes nvarchar 1073741823 √ null

Activity notes - Notes about recorded activities or events
ActivityStartTime nvarchar 510 √ null

Activity start time - Start time for recorded activity
AddReq nvarchar 510 √ null

Additional requirements - Additional requirements or qualifications needed
Date datetime 16,3 √ null

General date - General purpose date field for various uses
DateDis datetime 16,3 √ null

Discharge date - Date of discharge or separation
DateDisc datetime 16,3 √ null

Discontinuation date - Date when services or employment was discontinued
DateReqRec datetime 16,3 √ null

Requirements received date - Date when required documentation was received
DesPHI nvarchar 1073741823 √ null

PHI description - Description of Protected Health Information handling
NameReq nvarchar 510 √ null

Name requirements - Requirements related to name or identification
NonClientActivityCodes nvarchar 510 √ null

Non-client activity codes - Codes for activities not directly related to client care
Person2pick nvarchar 510 √ null

Person to contact - Designated person to contact for this user
PurpReq nvarchar 1073741823 √ null

Purpose requirements - Requirements related to purpose or intent
TitleSuffix nvarchar 510 √ null

Title suffix - Professional title suffix (MD, RN, LCSW, etc.) for formal identification
Availability nvarchar 510 √ null

Availability status - Current availability status for scheduling and assignments
AvailabilityTime nvarchar 510 √ null

Availability time - Specific time periods when provider is available for services
CaseCalendar nvarchar 510 √ null

Case calendar - Calendar information related to case management and scheduling
CaseDate datetime 16,3 √ null

Case date - Important date related to case assignment or management
CertificationExpireDate datetime 16,3 √ null

Certification expiration date - Date when professional certification expires
CertificationLevel nvarchar 510 √ null

Certification level - Level or grade of professional certification achieved
CertificationStartDate datetime 16,3 √ null

Certification start date - Date when professional certification became effective
CertificationType nvarchar 510 √ null

Certification type - Type or category of professional certification held
ChildEI int 4 √ null

Child early intervention - Flag or count related to early intervention services for children
ClockNumber nvarchar 1073741823 √ null

Clock number - Time clock or payroll identification number for time tracking
DayforceManager nvarchar 510 √ null

Dayforce manager - Manager information for Dayforce payroll/HR system integration
Department nvarchar 1073741823 √ null

Department - Department or division where the provider is assigned
EmployersAddress nvarchar 2200 √ null

Employer address - Address information for the provider’s employer
EmployersPhoneNumber nvarchar 2200 √ null

Employer phone - Phone number for the provider’s employer
JobName nvarchar 1073741823 √ null

Job name - Official job title or position name
Language nvarchar 510 √ null

Primary language - Primary language spoken by the provider
LicenseExpireDate datetime 16,3 √ null

License expiration date - Date when professional license expires
LicenseStartDate datetime 16,3 √ null

License start date - Date when professional license became effective
LicenseType nvarchar 510 √ null

License type - Type or category of professional license held
Location nvarchar 510 √ null

Primary location - Primary work location or service area
Notes nvarchar 510 √ null

Additional notes - General notes and additional information about the provider
Region nvarchar 510 √ null

Service region - Geographic region where provider delivers services
ServiceMethod nvarchar 510 √ null

Service method - Method or approach used for service delivery (in-person, telehealth, etc.)
TroubleShoot nvarchar 510 √ null

Troubleshooting notes - Technical or operational troubleshooting information
ZipCodes nvarchar 510 √ null

Service ZIP codes - ZIP codes where provider can deliver services

Indexes

Constraint Name Type Sort Column(s)
PK_AccessUserCustom Primary key Asc pkID
IX_fkUserID Performance Asc fkUserID

Relationships

Close relationships within degrees of separation