Skip to main content

Looked After Codes sent to the NHS for CP-IS

In this article, we outline which Looked After Codes are included in the data sent to the NHS for CP-IS.

Y
Written by Yusef Abulaynain
Updated over 5 months ago

The Looked After Codes for the Child Protection Information Sharing (CPIS) are held in the mapping table MO_CPIS_LAC_LEGAL_STATUS_CODES.
​
The standard codes are C1, C2 and V2
You can now include E1 in the upload, but only if you are using Mosaic version 22.2.4.0 or higher, for further information please refer to E1 placement orders article
​
The following SQL can be amended to add a LAC code to the mapping table: (change E1 to the code to be added).

INSERT INTO mo_cpis_lac_legal_status_codes
(looked_after_code)
VALUES
('E1');
Did this answer your question?