Table details: CRDA/38/DS/1986/2

Data Relating to the Care Episode, 1986 (1986_EPISODE)

: Browsing NDAD catalogues

View in hierarchy

Table title

Data Relating to the Care Episode, 1986

NDAD reference

CRDA/38/DS/1986/2

Table name

1986_EPISODE

Dataset

1986

Scope and content

Untitled

The EPISODE table lists the child's ID code and coded data for all the care episodes relevant to each child. This includes the episode number, dates on which the episode of care commenced and ceased, reasons given for commencement and cease of care episode, and details of legal status of child, accommodation in care, and resolution. For every child mentioned in the CHILD table, there can be several care episodes.

Access conditions

There are no access restrictions on this table.

You can use the NDAD Query Builder to view and query data in this and other tables in this dataset.

Number of Fields

Number of Records

109,185

Fields

1	Child_ID ¤	Integer	Identity no. of child
2	EpisodeNumber	Integer	Each episode for an individual child is numbered
3	CommencingDate	Date as Fixed Length String	Item 5 Date episode commenced
4	LegalStatus	Integer	Item 6 Legal status of child
5	ReasonCommenced	Integer	Item 7 Reason episode commenced
6	Accommodation	Integer	Item 8 Manner of accommodation
7	Resolution	Integer	Item 9 Subject to resolution
8	CeasedDate	Date as Fixed Length String	Item 10 Date care episode ceased.
9	ReasonCeased	Integer	Item 11 Reason episode ceased

* maximum list length: 1000 derived field: § key field: ¤

NDAD v3.0

Table details: CRDA/38/DS/1986/2

Data Relating to the Care Episode, 1986 (1986_EPISODE)

Getting in touch

Site help

About us

Websites