Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| AHP_ID | int identity | 4 | √ | null |
|
|
AHP Contact ID |
|||
| CARE_ID | int | 4 | null |
|
|
Referral Record ID |
||||
| L_REF_DATE | smalldatetime | 16 | √ | null |
|
|
Date referred to AHP Contact |
|||
| L_SEEN_DATE | smalldatetime | 16 | √ | null |
|
|
Date of Contact |
|||
| L_AHP | int | 4 | null |
|
|
AHP Type (Derived) |
||||
| L_AHP_ID | int | 4 | √ | null |
|
|
AHP Name |
|||
| L_AHP_ROLE | int | 4 | √ | null |
|
|
||||
| L_AHP_NAME | varchar | 255 | √ | null |
|
|
Other AHP Name |
|||
| L_CONTACT_PAT | bit | 1 | ((0)) |
|
|
Contact With - Patient |
||||
| L_CONTACT_REL | bit | 1 | ((0)) |
|
|
Contact With - Relative |
||||
| L_CONTACT_CARER | bit | 1 | ((0)) |
|
|
Contact With - Carer |
||||
| L_CONTACT_PROF | bit | 1 | ((0)) |
|
|
Contact With - HCP |
||||
| L_HCP_ROLE | int | 4 | √ | null |
|
|
HCP Role |
|||
| L_HCP_NAME | varchar | 255 | √ | null |
|
|
HCP Name |
|||
| L_CONTACT_TYPE | int | 4 | √ | null |
|
|
Contact Type |
|||
| L_TOTAL_TIME | int | 4 | √ | null |
|
|
Duration |
|||
| L_CONTACT_PLACE | int | 4 | √ | null |
|
|
Contact Location |
|||
| L_PRIVACY | int | 4 | √ | null |
|
|
Privacy available for contact |
|||
| L_ADVICE | text | 2147483647 | √ | null |
|
|
Information and Advice |
|||
| L_ACTIVITY | text | 2147483647 | √ | null |
|
|
Clinical Activity |
|||
| L_DENTAL_TREATMENT | int | 4 | √ | null |
|
|
Dental Treatment |
|||
| R_SWALLOW | varchar | 3 | √ | null |
|
|
Swallow Assessment |
|||
| R_DIET | int | 4 | √ | null |
|
|
Diet |
|||
| R_DIET3MONTH | int | 4 | √ | null |
|
|
||||
| R_DIET12MONTH | int | 4 | √ | null |
|
|
||||
| R_SVR | varchar | 3 | √ | null |
|
|
SVR Assessment |
|||
| R_WHO_CONTACT | varchar | 1 | √ | null |
|
|
||||
| R_CONTACT_PURPOSE | varchar | 2 | √ | null |
|
|
Contact Purpose |
|||
| R_PT_STATUS | int | 4 | √ | null |
|
|
Patient Status |
|||
| R_COMM | varchar | 4 | √ | null |
|
|
Communication |
|||
| R_COMM_PRIMARY | varchar | 4 | √ | null |
|
|
||||
| R_COMM_OTHER | varchar | 4 | √ | null |
|
|
||||
| R_VOICING | int | 4 | √ | null |
|
|
Post-Op Voicing |
|||
| R_REMOVAL_REASON | int | 4 | √ | null |
|
|
Reason Valve Removed |
|||
| R_HEIGHT | real | 4 | √ | null |
|
|
Height |
|||
| R_WEIGHT | real | 4 | √ | null |
|
|
Weight |
|||
| OrganisationID | int | 4 | √ | null |
|
|
||||
| N_HN15_NUTRITION | varchar | 1 | √ | null |
|
|
Nutritional Support |
|||
| N_HN_DATE_SUPPORT_INSTIGATED | smalldatetime | 16 | √ | null |
|
|
Date Support Instigated |
|||
| N_HN16_NUTRITION_TYPE | varchar | 1 | √ | null |
|
|
Type of Support |
|||
| N_HN17_NUTRITION_PROCEDURE | int | 4 | √ | null |
|
|
Procedure |
|||
| N_HN_NUTRITION_PROC_DATE | smalldatetime | 16 | √ | null |
|
|
Nutritional Procedure Date |
|||
| N_HN18_NUTRITION_COMP | varchar | 5 | √ | null |
|
|
Complications |
|||
| R_SUPPORT_REMAIN | varchar | 1 | √ | null |
|
|
Support Remaining |
|||
| N_HN_DATE_SUPPORT_WITHDRAWN | smalldatetime | 16 | √ | null |
|
|
Date Support Withdrawn |
|||
| R_EST_WEIGHT | real | 4 | √ | null |
|
|
Patient Estimated Weight (kg) |
|||
| R_SALT_CONTACT_DURATION | int | 4 | √ | null |
|
|
SaLT Contact Period |
|||
| L_NOTES | text | 2147483647 | √ | null |
|
|
Notes |
|||
| OTHER_ROLE_ID | int | 4 | √ | null |
|
|
Other Sub Role |
|||
| ACTION_ID | int | 4 | √ | null |
|
|
Latest Audit entry ID |
|||
| COMPLAINT_ADVICE | int | 4 | √ | null |
|
|
Has the patient been compliant with dietetic advice for appropriate recording of BMI? |
|||
| MOUTH_OPENING_PRE | int | 4 | √ | null |
|
|
Mouth Opening Pre-treatment (mm) |
|||
| MOUTH_OPENING_POST | int | 4 | √ | null |
|
|
||||
| SITE_MEASUREMENT | int | 4 | √ | null |
|
|
Site of Measurement |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblAHP_CONTACTS | Primary key | Asc | AHP_ID |
| IX_tblAHP_CONTACTS | Performance | Asc | CARE_ID |