Note: The data is extracted from aDvance for the dates between '2018-07-01' and '2018-07-31';
Note: The referral Outcome is used to identify the Referral group
Note: The Age of client is calculated as of the Referral data
Distinct Count of FILENUMBER
Age at Referral
Referral Outcome Annotation
Referral_Outcome_Desc
Over 65
Under 65
Grand Total
(blank)
5
57
62
(blank)
5
57
62
Case Co-ordination
2
35
37
CC Level 2
9
10
s 47F
CC Level 3
28
29
Client Liason Unit
s 47F
s 47F
CLU
Declined
6
42
48
Declined
6
42
48
Service Co-ordination
5
6
s 47F
SC Level 2
2
3
SC Level 3
4
5
Grand Total
8
83
91
INTEGRATEDCASETYP REFERRALID
STATUSCODRECORDED_DATCONCERNROLEID FIRSTNAME
SURNAME
DATEOFBIRTHDATEOFDEATFILENUMBER
SERVICESTATUSCCS_Referral_Outcome Referral_Outcome_Desc
ANNOTATION
Age at Referral
DVA003 0x80000000000000RST1
2018-07-04 0x80000000000000
RS01
Under 65
DVA003 0x80000000000000RST1
2018-07-17 0x00000000000000
RS02
RO04
SC Level 3
Service Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-19 0x80000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-10 0x80000000000000
RS01
RO06
Declined
Declined
Under 65
DVA003 0x00000000000000RST1
2018-07-20 0x80000000000000
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-30 0x80000000000000
RS02
RO06
Declined
Declined
Under 65
s 47F
DVA003 0x80000000000000RST1
2018-07-25 0x80000000000000
RS01
Under 65
DVA003 0x00000000000000RST1
2018-07-05 0x80000000000000
RO01
CC Level 2
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-09 0x00000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-26 0x80000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-17 0x80000000000000
RS02
RO02
CC Level 3
Case Co-ordination
Over 65
DVA003 0x80000000000000RST1
2018-07-16 0x00000000000000
RS01
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-12 0x80000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-03 0x00000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-04 0x80000000000000
RS01
Under 65
DVA003 0x80000000000000RST1
2018-07-10 0x80000000000000
RS02
Under 65
DVA003 0x00000000000000RST1
2018-07-05 0x80000000000000
Under 65
DVA003 0x80000000000000RST1
2018-07-17 0x00000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-30 0x00000000000000
RS01
RO01
CC Level 2
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-09 0x80000000000000
Under 65
DVA003 0x80000000000000RST1
2018-07-30 0x00000000000000
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-20 0x00000000000000
RS02
RO04
SC Level 3
Service Co-ordination
Under 65
DVA003 0x00000000000000RST1
2018-07-10 0x80000000000000
RS01
Under 65
DVA003 0x00000000000000RST1
2018-07-25 0x00000000000000
RO01
CC Level 2
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-25 0x80000000000000
RS01
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x00000000000000RST1
2018-07-02 0x80000000000000
RS01
Under 65
DVA003 0x00000000000000RST1
2018-07-31 0x00000000000000
RS02
RO06
Declined
Declined
Over 65
DVA003 0x00000000000000RST1
2018-07-18 0x00000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-19 0x80000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x00000000000000RST1
2018-07-31 0x00000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-30 0x80000000000000
RS01
Under 65
DVA003 0x00000000000000RST1
2018-07-05 0x00000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-23 0x80000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-26 0x80000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x00000000000000RST1
2018-07-10 0x80000000000000
RS01
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x00000000000000RST1
2018-07-23 0x80000000000000
RS01
Under 65
DVA003 0x80000000000000RST1
2018-07-04 0x80000000000000
RO03
SC Level 2
Service Co-ordination
Under 65
DVA003 0x00000000000000RST1
2018-07-16 0x00000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-23 0x80000000000000
RS02
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x00000000000000RST1
2018-07-10 0x00000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x00000000000000RST1
2018-07-25 0x00000000000000
RS01
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-17 0x80000000000000
RO05
CLU
Client Liason Unit
Under 65
DVA003 0x00000000000000RST1
2018-07-05 0x00000000000000
RS01
Under 65
DVA003 0x00000000000000RST1
2018-07-03 0x00000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x00000000000000RST1
2018-07-25 0x00000000000000
RS02
RO01
CC Level 2
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-26 0x80000000000000
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x00000000000000RST1
2018-07-30 0x00000000000000
RS01
RO06
Declined
Declined
Under 65
DVA003 0x00000000000000RST1
2018-07-17 0x80000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-09 0x00000000000000
RS01
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-09 0x00000000000000
RS02
Under 65
DVA003 0x00000000000000RST1
2018-07-10 0x00000000000000
Under 65
DVA003 0x80000000000000RST1
2018-07-04 0x80000000000000
RS01
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-19 0x00000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-10 0x80000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x00000000000000RST1
2018-07-17 0x80000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-04 0x80000000000000
RS01
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x00000000000000RST1
2018-07-06 0x00000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-30 0x00000000000000
Under 65
DVA003 0x80000000000000RST1
2018-07-30 0x00000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-06 0x00000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-23 0x00000000000000
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-20 0x00000000000000
RS02
Over 65
DVA003 0x00000000000000RST1
2018-07-11 0x00000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-17 0x80000000000000
RS02
RO03
SC Level 2
Service Co-ordination
Over 65
DVA003 0x00000000000000RST1
2018-07-02 0x80000000000000
RS01
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x00000000000000RST1
2018-07-23 0x80000000000000
RO01
CC Level 2
Case Co-ordination
Over 65
DVA003 0x80000000000000RST1
2018-07-12 0x80000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x00000000000000RST1
2018-07-20 0x00000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-16 0x80000000000000
RS01
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-26 0x80000000000000
Under 65
DVA003 0x00000000000000RST1
2018-07-06 0x00000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x00000000000000RST1
2018-07-02 0x00000000000000
RS01
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-13 0x80000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-17 0x80000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-16 0x00000000000000
RS01
Under 65
DVA003 0x80000000000000RST1
2018-07-27 0x00000000000000
RO06
Declined
Declined
Over 65
DVA003 0x80000000000000RST1
2018-07-05 0x80000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-23 0x80000000000000
RS02
Under 65
DVA003 0x00000000000000RST1
2018-07-05 0x00000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-04 0x80000000000000
RS02
Under 65
DVA003 0x00000000000000RST1
2018-07-10 0x00000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-30 0x00000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x00000000000000RST1
2018-07-02 0x80000000000000
RS01
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-16 0x00000000000000
RS02
RO04
SC Level 3
Service Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-30 0x00000000000000
RS01
Under 65
DVA003 0x80000000000000RST1
2018-07-31 0x80000000000000
RS02
RO06
Declined
Declined
Over 65
DVA003 0x80000000000000RST1
2018-07-25 0x80000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x00000000000000RST1
2018-07-16 0x00000000000000
RS02
RO04
SC Level 3
Service Co-ordination
Under 65
DVA003 0x00000000000000RST1
2018-07-25 0x00000000000000
RS01
Under 65
DVA003 0x00000000000000RST1
2018-07-02 0x80000000000000
RS01
RO01
CC Level 2
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-04 0x80000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-02 0x00000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-13 0x00000000000000
RS02
Over 65
DVA003 0x00000000000000RST1
2018-07-16 0x00000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-16 0x00000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-09 0x00000000000000
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-10 0x80000000000000
RS02
Over 65
DVA003 0x80000000000000RST1
2018-07-19 0x00000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-18 0x80000000000000
Under 65
DVA003 0x80000000000000RST1
2018-07-20 0x00000000000000
RS02
RO06
Declined
Declined
Over 65
DVA003 0x80000000000000RST1
2018-07-03 0x00000000000000
RS02
RO01
CC Level 2
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-18 0x80000000000000
RO01
CC Level 2
Case Co-ordination
Under 65
DVA003 0x00000000000000RST1
2018-07-23 0x80000000000000
Over 65
DVA003 0x00000000000000RST1
2018-07-30 0x80000000000000
RS02
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-10 0x80000000000000
RS02
RO06
Declined
Declined
Over 65
DVA003 0x80000000000000RST1
2018-07-30 0x80000000000000
RS01
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x00000000000000RST1
2018-07-23 0x00000000000000
RS01
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-17 0x00000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-11 0x00000000000000
RS02
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x00000000000000RST1
2018-07-26 0x80000000000000
RS02
RO04
SC Level 3
Service Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-17 0x80000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x00000000000000RST1
2018-07-10 0x00000000000000
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-09 0x00000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x00000000000000RST1
2018-07-25 0x00000000000000
RS01
Under 65
DVA003 0x00000000000000RST1
2018-07-25 0x00000000000000
Under 65
DVA003 0x80000000000000RST1
2018-07-09 0x00000000000000
Under 65
DVA003 0x80000000000000RST1
2018-07-03 0x00000000000000
RS02
Under 65
DVA003 0x00000000000000RST1
2018-07-30 0x00000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-20 0x80000000000000
RS02
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x00000000000000RST1
2018-07-23 0x80000000000000
RS01
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-23 0x80000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-25 0x80000000000000
RS02
Under 65
DVA003 0x00000000000000RST1
2018-07-31 0x00000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-13 0x80000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x00000000000000RST1
2018-07-30 0x00000000000000
RS01
Under 65
DVA003 0x80000000000000RST1
2018-07-30 0x80000000000000
RS01
RO01
CC Level 2
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-05 0x80000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-13 0x00000000000000
RS02
RO06
Declined
Declined
Over 65
DVA003 0x80000000000000RST1
2018-07-30 0x80000000000000
RS02
Under 65
DVA003 0x00000000000000RST1
2018-07-06 0x00000000000000
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-02 0x00000000000000
RS01
Under 65
DVA003 0x00000000000000RST1
2018-07-25 0x00000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-02 0x00000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-06 0x00000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-03 0x00000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-02 0x00000000000000
RS01
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-02 0x00000000000000
RS01
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x00000000000000RST1
2018-07-05 0x00000000000000
RS01
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-27 0x00000000000000
RS01
Under 65
DVA003 0x80000000000000RST1
2018-07-10 0x80000000000000
RS01
Under 65
DVA003 0x00000000000000RST1
2018-07-25 0x00000000000000
RS01
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-13 0x00000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-16 0x80000000000000
RS01
Under 65
DVA003 0x80000000000000RST1
2018-07-17 0x80000000000000
RS02
RO04
SC Level 3
Service Co-ordination
Over 65
DVA003 0x00000000000000RST1
2018-07-02 0x00000000000000
RS02
Under 65
DVA003 0x00000000000000RST1
2018-07-05 0x00000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x00000000000000RST1
2018-07-20 0x00000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x00000000000000RST1
2018-07-31 0x00000000000000
RS02
Over 65
DVA003 0x00000000000000RST1
2018-07-02 0x80000000000000
RS01
Under 65
DVA003 0x00000000000000RST1
2018-07-25 0x00000000000000
RS01
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-05 0x80000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x00000000000000RST1
2018-07-11 0x00000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x00000000000000RST1
2018-07-02 0x00000000000000
RS01
Under 65
DVA003 0x80000000000000RST1
2018-07-16 0x00000000000000
RO01
CC Level 2
Case Co-ordination
Under 65
DVA003 0x00000000000000RST1
2018-07-30 0x00000000000000
RS02
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-09 0x80000000000000
RO06
Declined
Declined
Under 65
DVA003 0x80000000000000RST1
2018-07-18 0x80000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-12 0x80000000000000
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-27 0x00000000000000
RS01
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x00000000000000RST1
2018-07-25 0x00000000000000
RS01
Under 65
DVA003 0x80000000000000RST1
2018-07-09 0x00000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x00000000000000RST1
2018-07-02 0x80000000000000
RS01
RO02
CC Level 3
Case Co-ordination
Under 65
DVA003 0x80000000000000RST1
2018-07-18 0x80000000000000
RS02
RO06
Declined
Declined
Under 65
DVA003 0x00000000000000RST1
2018-07-05 0x00000000000000
RS02
Under 65
DVA003 0x80000000000000RST1
2018-07-20 0x00000000000000
RS02
RO03
SC Level 2
Service Co-ordination
Under 65
DVA003 0x00000000000000RST1
2018-07-25 0x00000000000000
RS01
RO02
CC Level 3
Case Co-ordination
Under 65
s 47F
DVA003 0x00000000000000RST1
2018-07-02 0x00000000000000
RS02
RO02
CC Level 3
Case Co-ordination
Under 65
Document Outline