PTL contents#
Priority Types#
-
Cancer / 2ww / 31/62 days - all patients suspected of or being treated for cancer
-
Routine
-
Urgent
-
Subs - cancer patients who have received their first difinitive treatment but remain on a pathway
-
Surveillane - non-cancer patients who have received their first difinitive treatment but remain on a pathway
Mapping#
Patient details#
|
label |
field(s) |
example data |
rendered |
for priority type |
comments |
|---|---|---|---|---|---|
|
Patient first name |
FORENAME |
Mikhail |
Mikhail |
ALL |
|
|
Patient surname |
SURNAME |
Antonio |
Antonio |
ALL |
|
|
Patient age |
((TODAY() - BIRTH_DTTM)/365) |
63 |
(63) |
ALL |
|
|
Patient NUH # |
PAS_ID |
K12345 |
K12345 |
ALL |
|
|
Patient NHS # |
NHS_NUMBER |
1234567890 |
1234567890 |
ALL |
PTL Service Summary#
|
label |
field(s) |
example data |
rendered |
for priority type |
comments |
|---|---|---|---|---|---|
|
PTL Service Summary |
tbc |
17/03/22 Awaiting sleep study |
17/03/22 Awaiting sleep study |
ALL |
awaiting access to data - will require minimum character parsing |
Pathway details#
|
label |
field(s) |
example data |
rendered |
for priority type |
comments |
|---|---|---|---|---|---|
|
Referral priority |
Referral priority |
01 |
CANCER (2WW) |
ALL |
need to see data to identify codes in use |
|
Referral date |
REQST_DTTM |
2022-01-04T11:00:00.000 |
04 Jan 2022 |
ALL |
|
|
Count of days on pathway |
((TODAY() - REQST_DTTM)) |
17 |
17 days |
CANCER |
|
|
Count of weeks on pathway |
((TODAY() - REQST_DTTM)/7) |
17 |
17 weeks |
NOT CANCER |
|
|
Time remaining |
((TODAY() - Pathway deadline)) |
17 |
17 days until target |
CANCER |
|
|
Time remaining |
((TODAY() - Pathway deadline)/7) |
17 |
17 weeks until target |
NOT CANCER |
|
|
Breach label |
If(TODAY()>Pathway deadline,”Breach”,””)) |
Breach symbol |
ALL |
Current Milestone (event) details#
|
label |
field(s) |
example data |
rendered |
for priority type |
comments |
|---|---|---|---|---|---|
|
Current event |
Patient’s latest milestone status |
Diagnostic |
Diagnostic |
ALL |
Calculation based on individual patient data update |
|
Time in event status |
((TODAY() - Event start date)) |
17 |
17 days |
CANCER |
|
|
Time in event status |
((TODAY() - Event start date)/7) |
17 |
17 weeks |
NOT CANCER |
|
|
Days remaining against event KPI |
(Event start date + Event KPI)-TODAY()) |
17 |
17 days |
ALL |
|
|
Breach label |
If(TODAY()>(Event start date + Event KPI),”Breach”,””)) |
Breach symbol |
ALL |
Sub-specialty & Consultant details#
|
label |
field(s) |
example data |
rendered |
for priority type |
comments |
|---|---|---|---|---|---|
|
Sub-specialty |
REFTO_SPECIALTY_CODE/REFTO_SPECIALTY_DESC |
Head & Neck |
Head & Neck |
ALL |
|
|
Consultant |
REFTO_HCP_MAINCODE/CONCAT(TRIM(ref.REFTO_HCP_TITLE_CODE),’ ‘,TRIM(ref.REFTO_HCP_FORENAME), ‘ ‘, TRIM(ref.REFTO_HCP_SURNAME)) |
Mr Barnes |
Mr Barnes |
ALL |
Next planned event#
|
label |
field(s) |
example data |
rendered |
for priority type |
comments |
|---|
Patient tracking notes#
|
label |
field(s) |
example data |
rendered |
for priority type |
comments |
|---|---|---|---|---|---|
|
Date of Birth |
BIRTH_DTTM, ((TODAY()-BIRTH_DTTM)/365)) |
01/01/1990, 32 |
01/01/1990 (32) |
ALL |
|
|
Referral priority |
RASSES_MAINCODE/RASSES_DESC |
01 |
CANCER (2WW) |
ALL |
need to see data to identify codes in use - MAY NOT BE REQUIRED |
|
Review date |
?tbc? |
ALL |
|||
|
Diagnosis |
PRIMPROC_MAIN_CODE/PRIMPROC_DESCRIPTION |
Squamous cell carinoma |
Squamous cell carinoma |
ALL |
where ‘null’ display ‘UNKNOWN’ |
|
PTL Status code |
PTL Current Status Code |
xyz |
xyz |
ALL |
need to see data to identify codes in use |