PCC_CRM_Lead

233799 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
EntityID bigint 8 null
VW_PCC_CRM_LeadsCountedOnce.EntityID Implied ConstraintR
VW_PCC_CRM_LeadsWithMultiplePP.EntityID Implied ConstraintR
ReferrerTypeDescription varchar 50 √ null
ReferrerPrimaryDisplayName varchar 150 √ null
ReferrerSecondaryDisplayName varchar 375 √ null
LeadState varchar 30 √ null
LeadStatus varchar 50 √ null
LeadStatusCode char 3 √ null
StatusReason varchar 80 √ null
StatusReasonCode char 3 √ null
EstRevenue money 21,4 √ null
PayerType varchar 50 √ null
SourceCategory varchar 60 √ null
SourceType varchar 60 √ null
CreatedByLoginName varchar 60 √ null
CreatedBy varchar 50 √ null
CreatedDate datetime 16,3 √ null
RevisionByLoginName varchar 60 √ null
RevisionBy varchar 50 √ null
RevisionDate datetime 16,3 √ null
IsDeleted char 1 null
DeletedBy varchar 60 √ null
DeletedDate datetime 16,3 √ null
CurrentLocation varchar 100 √ null
LeadRating varchar 30 √ null
LeadDate date 6 √ null
Subject varchar 30 √ null
MoveInDate date 6 √ null
MpiID int 4 √ null
ExtFacilityID int 4 √ null
StdLevelOfCare varchar 50 √ null
OtherMedicalInformation varchar 255 √ null
AVA_insdate datetime2 16,3 (getdate())

Indexes

Constraint Name Type Sort Column(s)
PK_PCC_CRM_Lead Primary key Asc EntityID

Relationships

Close relationships within degrees of separation