Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| PathwayUpdateEventID | int identity | 4 | √ | null |
|
|
||||
| CareID | int | 4 | null |
|
|
|||||
| NextActionID | int | 4 | null |
|
|
|||||
| NextActionSpecificID | int | 4 | √ | null |
|
|
||||
| AdditionalDetails | varchar | 255 | √ | null |
|
|
||||
| OwnerID | int | 4 | √ | null |
|
|
||||
| OwnerRole | varchar | 55 | √ | null |
|
|
||||
| OwnerName | varchar | 55 | √ | null |
|
|
||||
| TargetDate | date | 20 | √ | null |
|
|
||||
| Escalate | int | 4 | √ | null |
|
|
||||
| OrganisationID | int | 4 | √ | null |
|
|
||||
| ActionComplete | bit | 1 | null |
|
|
|||||
| ACTION_ID | int | 4 | √ | null |
|
|
||||
| DateLastTracked | date | 20 | √ | null |
|
|
||||
| OwnerUpdate | varchar | 255 | √ | null |
|
|
||||
| DelayReason | varchar | 255 | √ | null |
|
|
||||
| DateOfEscalation | date | 20 | √ | null |
|
|
||||
| EscalatedTo | varchar | 55 | √ | null |
|
|
||||
| ForPTLDiscuss | bit | 1 | √ | null |
|
|
||||
| DateActionCompleted | date | 20 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblPathwayUpdateEvents | Primary key | Asc | PathwayUpdateEventID |