Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| UserID | int identity | 4 | null |
|
|
User identifier - Unique identifier for each system user |
||
| SSN | varchar | 100 | √ | null |
|
|
Social Security Number - Masked SSN for reporting purposes |
|
| UserStatus | varchar | 10 | √ | null |
|
|
User status - Current status of the user account |
|
| FirstName | varchar | 50 | √ | null |
|
|
First name - User’s given name |
|
| MidName | varchar | 50 | √ | null |
|
|
Middle name - User’s middle name or initial |
|
| LastName | varchar | 50 | √ | null |
|
|
Last name - User’s surname |
|
| Title | int | 4 | √ | null |
|
|
Professional title - User’s job title or professional designation |
|
| ContactComments | varchar | 5000 | √ | null |
|
|
Contact notes - Additional contact information or notes |
|
| Sex | varchar | 10 | √ | null |
|
|
Gender - User’s gender |
|
| DateHire | datetime | 16,3 | √ | null |
|
|
Hire date - Date when user was hired |
|
| DateOfBirth | datetime | 16,3 | √ | null |
|
|
Birth date - User’s date of birth |
|
| varchar | 50 | √ | null |
|
|
Email address - User’s email for communication |
||
| StreetAddr | varchar | 50 | √ | null |
|
|
Street address - User’s street address |
|
| City | varchar | 30 | √ | null |
|
|
City - User’s city of residence |
|
| State | varchar | 30 | √ | null |
|
|
State - User’s state of residence |
|
| RateTitle | int | 4 | √ | null |
|
|
Rate title - Title used for rate determination |
|
| Zip | varchar | 10 | √ | null |
|
|
ZIP code - User’s postal code |
|
| HomeAddr2 | varchar | 50 | √ | null |
|
|
Address line 2 - Additional address information |
|
| AgencyStatus | varchar | 20 | √ | null |
|
|
Agency status - User’s status within the agency |
|
| Supervisor | int | 4 | √ | null |
|
|
Supervisor - User’s supervisor |
|
| NysSupervisor | int | 4 | √ | null |
|
|
NYS supervisor - New York State supervisor designation |
|
| AgencyID | int | 4 | √ | null |
|
|
Agency reference - Links to Agency table |
|
| companyID | varchar | 20 | √ | null |
|
|
Company ID - Company identifier |
|
| number | varchar | 20 | √ | null |
|
|
Phone number - User’s phone number |
|
| IDvalue | varchar | 100 | √ | null |
|
|
ID value - User identification value |
|
| IDTypeID | int | 4 | null |
|
|
ID type - Type of identification |
||
| RoleId | uniqueidentifier | 16 | √ | null |
|
|
Role reference - Links to Roles table |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by - UserID who last updated the record |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Update date - Date of last update |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by - UserID who created the record |
|
| dateentered | smalldatetime | 16 | √ | null |
|
|
Entry date - Date when record was created |
|
| DisciplineList | nvarchar | 1073741823 | √ | null |
|
|
Discipline list - Comma-separated list of discipline IDs |
|
| RoleList | nvarchar | 1073741823 | √ | null |
|
|
Role list - Comma-separated list of role names |
|
| fkUserPayTypeID | int | 4 | √ | null |
|
|
Pay type - Links to user pay type |
|
| DateTerminate | datetime | 16,3 | √ | null |
|
|
Termination date - Date when user was terminated |
|
| LicenseNumber | varchar | 100 | √ | null |
|
|
License number - Professional license number |
|
| TeamList | nvarchar | 1073741823 | √ | null |
|
|
Team list - Comma-separated list of team IDs |
|
| ListTeamName | nvarchar | 1073741823 | √ | null |
|
|
Team names - Comma-separated list of team names |
|
| PaylocityID | varchar | 255 | √ | null |
|
|
Paylocity ID - Payroll system identifier |
|
| Siteid | int | 4 | √ | null |
|
|
Site ID - Primary site assignment |
Relationships
Close relationships within degrees of separation
