Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| EntityID | bigint | 8 | null |
|
|
|||||
| ReferrerTypeDescription | varchar | 50 | √ | null |
|
|
||||
| ReferrerPrimaryDisplayName | varchar | 150 | √ | null |
|
|
||||
| ReferrerSecondaryDisplayName | varchar | 375 | √ | null |
|
|
||||
| LeadState | varchar | 30 | √ | null |
|
|
||||
| LeadStatus | varchar | 50 | √ | null |
|
|
||||
| StatusReason | varchar | 80 | √ | null |
|
|
||||
| EstRevenue | money | 21,4 | √ | null |
|
|
||||
| PayerType | varchar | 50 | √ | null |
|
|
||||
| SourceCategory | varchar | 60 | √ | null |
|
|
||||
| SourceType | varchar | 60 | √ | null |
|
|
||||
| LeadCreatedBy | varchar | 50 | √ | null |
|
|
||||
| LeadCreatedDate | datetime | 16,3 | √ | null |
|
|
||||
| RevisionBy | varchar | 50 | √ | null |
|
|
||||
| RevisionDate | datetime | 16,3 | √ | null |
|
|
||||
| CurrentLocation | varchar | 100 | √ | null |
|
|
||||
| LeadRating | varchar | 30 | √ | null |
|
|
||||
| LeadDate | date | 6 | √ | null |
|
|
||||
| Subject | varchar | 30 | √ | null |
|
|
||||
| MoveInDate | date | 6 | √ | null |
|
|
||||
| StdLevelOfCare | varchar | 50 | √ | null |
|
|
||||
| OtherMedicalInformation | varchar | 255 | √ | null |
|
|
||||
| PossiblePlacementFacilityID | int | 4 | √ | null |
|
|
||||
| PossiblePlacementFacilityCode | varchar | 5 | √ | null |
|
|
||||
| PossiblePlacementFacilityName | varchar | 375 | √ | null |
|
|
||||
| PossiblePlacementFacilityType | varchar | 254 | √ | null |
|
|
||||
| PossiblePlacementDeposit | bit | 1 | √ | null |
|
|
||||
| PossiblePlacementReserved | bit | 1 | √ | null |
|
|
||||
| PossiblePlacementWaitList | bit | 1 | √ | null |
|
|
||||
| PossiblePlacementCreatedBy | varchar | 50 | √ | null |
|
|
||||
| PossiblePlacementCreatedDate | datetime | 16,3 | √ | null |
|
|
||||
| PossiblePlacementStatus | varchar | 30 | √ | null |
|
|
||||
| PossiblePlacementStatusReason | varchar | 80 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
