Person

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Person_Id int 4 null
Insert_Date datetime 16,3 null
Insert_User varchar 50 null
Last_Update_Date datetime 16,3 null
Last_Update_User varchar 50 null
Delete_Ind bit 1 √ null
Population_Information_Id int 4 null
Population_Information.Population_Information_id Implied ConstraintR
Source_System_Id int 4 √ null
Source_System.Source_System_id Implied ConstraintR
FirstName varchar 15 null
LastName varchar 25 null
MiddleInitial varchar 1 √ null
StaffTitle varchar 50 √ null
IsStaff bit 1 null
IsUser bit 1 null
IsVisitor bit 1 null
IsInactive bit 1 null
SSN varchar 12 √ null
CompanyName varchar 50 √ null
PrimaryFacility_ID int 4 √ null
SupervisorPerson_ID int 4 √ null
EmployeeNo varchar 30 √ null
NPI varchar 10 √ null
IsRemoteUser bit 1 √ null
IsGiftRAPStaff bit 1 null
LockoutDate datetime 16,3 √ null
SignatureText varchar 75 null
Messaging varchar 10 null
CreatedDate datetime 16,3 null
ProductivityTarget decimal 17,2 √ null
EfficiencyTarget decimal 17,2 √ null
ExternalUpdateRule varchar 25 null
IsCustomerStaff bit 1 null
IsChainAdmin bit 1 null
Chain_ID int 4 √ null
MobileCarrier_ID int 4 √ null
AllowSMS varchar 10 null
NPIVerified bit 1 null
ASHAMemberID varchar 50 √ null
NOMSCertificationDate date 6 √ null
Taxonomy_ID int 4 √ null
ClinicianPointQuota int 4 √ null
IsSalesRepresentative bit 1 null

Relationships

Close relationships within degrees of separation