Lookup Tables

The tables in this section indicate which lookups are:

  • System Records - Lookups listed in red and with “ - SYSTEM RECORD” in the dialog header are core system values and should not be changed. They are used in different procedures and reporting functions. You cannot delete these lookups. If you believe you need to change or deactivate any of these lookups, contact One Application Support.
  • Mapping - Lookups used for mapping are involved in exporting data for statutory government returns, e.g. the NCCIS monthly XML report, the September Guarantee and the Annual Activity Survey. These values should not be changed or deleted without One Application Support consultation.
  • Simple Lookups - These lookups only require a description to be entered. No other configuration is necessary.
  • Complex Lookups - Complex lookups required unique and advanced configuration techniques and understanding. The configuration of each complex lookup is described explicitly in this handbook.

The lookups that are not controlled through the One IYSS System Administration Client, but are pulled through from One One can be viewed in the link below.

Additional InformationAdditional Information

  • Carer Contacts | Relationship Type
  • Client | Additional Needs | Primary SEN Category
  • Client | Additional Needs | Secondary SEN Category
  • Client | Additional Needs | SEN Status
  • Client | Summary | Address
  • Client | Summary | EthnicityClient | Summary | Ethnicity Source
  • Client | Summary | Gender
  • Client | Summary | Nationality
  • Client | Summary | Preferred Language

The matrices listed below represents a folder in the One IYSS System Administration Client. Each matrix provides a One IYSS address for the lookup, indicates whether it is simple or complex, whether it is used for mapping and whether it is a system record.

  • AddressAddress

    Lookup

    Address

    Further Information

    System?

    Used for Mapping?

    Connexions Partnership

    No longer used.

    Geographical Grouping Type

    (Complex)

    Client | Summary | Postcode Groupings

    Geographical areas deduced from clients’ postcodes or that of their situation provider, e.g. Ward, District.

    For more information, see Geographical Grouping Type .

    y

    n

    Geographical Area

    (Simple)

    Client | Aspirations | Desired Locations

    Opportunity | General | Geog Area

    Provider | Summary | Geographical Area

    Matches clients with opportunities. Should be kept to a manageable number of areas to facilitate usage, e.g. City Centre, Inner East, Outer East.

    n

    n

    TEC area

    (Simple)

    Client | Administration | LSC area

    Identifies the Learning and Skills Council responsible for the clients, e.g. Yorkshire and the Humber, West Midlands.

    n

    n
  • AssessmentsAssessments

    Lookup

    Address

    Further Information

    System?

    Used for Mapping?

    Assessment Element

    (Complex)

    Client | Documents, Notes and Assessments | Assessments | Assessment Elements

    Identifies elements within assessments, e.g. Participation, Key Skills and Housing in the APIR assessment.

    n

    n

    Assessment Progress Set

    (Complex)

    Client | Documents, Notes and Assessments | Assessments | Are issues being addressed

    Identifies client progress against each element, e.g. Is the Housing element of APIR being addressed? Yes, No, More information required.

    For more information, see Assessments.

    n

    n

    Assessment Template

    (Complex)

    Client | Documents, Notes and Assessments | Assessments

    Collates all assessment values to create a single assessment template, e.g. APIR; Jobs and Skills Action Plan.

    For more information, see Assessments.

    n

    n

    Assessment Value Set

    Client | Documents, Notes and Assessment | Assessments

    Identifies client ratings against each element, e.g. for APIR: Critical or complex issues, No issues, Positive strength.

    For more information, see Assessments.

     

     
  • ClientClient

    Lookup

    Address

    Further Information

    System?

    Used for Mapping?

    Additional Needs - Plan Reason

    (Simple)

    Client | Additional Needs | Plan Details | Not Completed Reason

    Explains why assessment* is incomplete, e.g. Unable to contact client.

    *Assessment section may be 140, 130 or MOP depending on local language.

    n

    n

    Additional Needs - Plan Status

    (Simple)

    Client | Additional Needs | Plan Details | Status

    Identifies how assessment* has been completed, e.g. Completed, Refused.

    *Assessment section may be 140, 130 or MOP depending on local language.

    y

    n

    Aspiration Types

    (Complex)

    Client | Aspiration

    Identifies the life situation to which the client aspires, e.g. Employment/Training.

    y

    n

    Aspiration Sub Types

    (Simple)

    Client | Aspiration | Sub Type

    Provides more details about the Aspiration Type, e.g. Employment with Training, Employment Without Training.

    y

    n

    Baseline Header

    (Complex)

    Client | Baseline | Baseline

    Creates sub-cohorts of clients of whom a census can be taken, e.g. the annual September Guarantee.

    For more information, see Baseline Management.

    n

    y

    Baseline Status

    (Complex)

    Client | Baseline | Status

    Identifies clients’ statuses under each baseline, e.g. the annual September Guarantee may have the status ‘Offer of education and training to start by October Conditional’.

    For more information, see Baseline Management.

    y

    y

    Baseline Status Group

    (Simple)

    Reporting

    Groups statuses together for reporting purposes, e.g. No Offer Made, Not Ready for Learning.

    For more information, see Baseline Management.

    y

    y

    Benefit Claim Status

    (Simple)

    Client | Benefit and Allowances | Claim Status

    Identifies the status of clients’ benefit claims, e.g. Rejected, Pending, Successful.

    y

    n

    Benefit Type

    (Complex)

    Client | Benefit and Allowances | Benefit Type

    Identifies the type of benefit clients are claiming or attempting to claim, e.g. Housing.

    n

    n

    Caseload Type

    (Complex)

    Client | Professional Contacts | Caseload Type

    Client Search | Caseload | Caseload Type

    Identifies differences between clients in a caseload depending on how the PA is working with them, e.g. Active, Passive, Low.

    n

    n

    Client in Danger Reason

    (Simple)

    Client | Client in Danger

    Informs ContactPoint why a record has been shielded.

    n

    n

    Endorsement Category

    (Simple)

    Client | Additional Needs | Endorsement Category

    Identifies whether clients can be endorsed for training purposes, e.g. ALN (Additional Learning Needs), ASN ( Additional Social Need).

    y

    n

    Examination Board

    (Simple)

    Client | Qualifications and Achievements | Examination Board

    Identifies the exam board governing relevant qualifications, e.g. AQA, RSA.

    n

    n

    Health Status

    This function is not in use in One IYSS

    Individual Circumstance Type

    (Complex)

    Client | Individual Circumstances | Individual Circumstance

    Identifies clients’ individual circumstances, e.g. Looked After, Pregnant.

    y

    y

    Intended Destination Post 16

    (Simple)

    Client | Aspirations | Post 16 Intended Destination | Intended Destination

    Indicates clients’ post-Year 12/13 intentions, e.g. Higher Education, Undecided/Unknown.

    y

    n

    Intended Destination Pre 16

    (Simple)

    Client | Aspirations | Year 11 Intended Destination | Intended Destination

    Indicates clients’ post-Year 11 intentions, e.g. Staying at same school, Undecided/Unknown.

    y

    y

    Interview Priority

    (Simple)

    Client | Administration | Interview Priority

    Identifies clients who need interviews soonest, e.g. Low, Medium, High.

    n

    n

    Interview Priority Reason

    (Simple)

    Client | Administration | Interview Priority Reason

    Provides reasons why clients have certain interview priorities, e.g. Unrealistic Ideas, Poor Attendee.

    n

    n

    Key Skill

    (Simple)

    Client | Qualifications and Achievements | Skills In

    Opportunity | General | Skills In

    Identifies skills not otherwise indicated by qualifications. Assists with employment recruitment by matching client skills to employer requirements, e.g. ICT, Teamwork.

    n

    n

    Level of Need

    (Simple)

    Client | Individual Circumstances | Level of Need

    Caseload Management

    Cohort Management

    Identifies client levels of need as defined by CCIS, e.g. Minimum Intervention, Intensive Support.

    y

    y

    Positive Activities

    (Simple)

    Client | Qualifications and Achievements | Achievements and Positive Activities | Activities

    Identifies the types of positive activity undertaken by clients as part of the annual Participation in Positive Activities survey, e.g. Sports Club or Class, Youth Club

    y

    n

    Positive Activity Barriers

    (Simple)

    Client | Qualifications and Achievements | Achievements and Positive Activities | Barriers

    Identifies barriers preventing clients from participating in positive activities, e.g. Too Expensive, No Provision in the Area.

    y

    n

    Positive Activity Involvement

    (Simple)

    Client | Qualifications and Achievements | Achievements and Positive Activities | Involved

    Identifies whether clients have been involved with positive activities, e.g. Yes, No, Don’t Know.

    y

    n

    Positive Activity Occurrence

    (Simple)

    Client | Qualifications and Achievements | Achievements and Positive Activities | Occurrence

    Indicates the frequency with which clients have been involved with positive activities, e.g. Once, Twice, Can’t Remember.

    y

    n

    Positive Activity Responses

    (Simple)

    Client | Qualifications and Achievements | Achievements and Positive Activities | Weekend

    Indicates whether clients have access to positive activities, e.g. Agree, Disagree, Don’t Know.

    y

    n

    Positive Activity Source

    (Simple)

    Client | Qualifications and Achievements | Achievements and Positive Activities | Source

    Identifies the source of information used for the Positive Activities survey, e.g. Paper Survey, Verbal.

    y

    n

    Project

    (Complex)

    Client | Situations

    Creates a secondary situation to enable collection of time-bound locally specified data. Provides five configurable fields, e.g. Millennium Volunteers, Green Apples.

    n

    n

    Qualification Diploma Type

    (Complex)

    Client | Qualifications and Achievements | Qualifications | Type

    Identifies the types of 14-19 Diploma being taken by clients, e.g. Public Services, Creative and Media.

    For more information, see Specific Qualification Level.

    y

    n

    Qualification Subject

    (Simple)

    Client | Qualifications and Achievements | Qualifications | Subject

    Identifies individual subjects being studied by clients, e.g. English, Maths.

    n

    n

    SEN Category

    (Simple)

    Client | Additional Needs | Primary SEN Category

    Client | Additional Needs | Secondary SEN Category

    Values are imported from the One One system, e.g. MSI (Multi-Sensory Impairment), VI Visual Impairment).

    y

    n

    Sexual Health Contact Type

    (Simple)

    Client | Sexual Health | Contact Type

    Makes records of the types of contact used for delivering sexual health services, e.g. Group Session, One to One.

    n

    n

    Sexual Health Cur Contr Use

    (Simple)

    Client | Sexual Health | Current Contraceptive Use

    This identifies the types of contraceptives used by clients, e.g. None, Contraceptive Pill, Condom.

    A Youth Service licence is needed to access this section of client records.

    n

    n

    Sexual Health Items

    (Simple)

    Client | Sexual Health | Items Issued

    Identifies the sexual health products or services issued, e.g. Pregnancy Test, Condoms.

    n

    n

    Sexual Health LGBT

    (Simple)

    Client | Summary | LGBT

    Identifies clients’ sexual orientation, e.g. Lesbian, Gay.

    This field is only displayed in the Client Summary Change screen.

    n

    n

    Sexual Health Referral Source

    (Simple)

    Client | Sexual Health | Referral Source

    Identifies how clients are put in touch with sexual health services, e.g. Connexions Website, Social Services.

    n

    n

    Sexual Health Referrals

    (Simple)

    Client | Sexual Health | Referral To

    Identifies to whom clients have been referred as part of their sexual health record, e.g. GP, PCT.

    n

    n

    Sexual Health Topics

    (Simple)

    Client | Sexual Health | Topics Discussed

    Identifies the topics and services that have been discussed with clients, e.g. Pregnancy, STIs.

    n

    n

    Shared Information Type

    (Simple)

    Client | Consent | Information Sharing

    Identifies the type of data the client has agreed to share with others as part of Data Protection consent, e.g. Criminal Record, Health Issues.

    n

    n

    Situation Change Reason

    (Simple)

    Clients | Situations | Reason for Change

    Identifies why clients leave situations, e.g. Sacked, Found Employment.

    n

    n

    Situation Group

    (Complex)

    Client | Situations | Situations

    Opportunity | Summary | Situation Group

    Identifies the situations of clients and opportunities, e.g. NEET, Statutory Education.

    For more information, see Situation Management.

    y

    y

    Situation Status

    (Complex)

    Client | Situations | Situations

    Enables the length of time clients spend in certain situations to be tracked and displayed on client records, e.g. 0 - 3 months, 6+ months.

    Status is calculated overnight and displayed in client record. There is also a search field available.

    n

    n

    Situation Sub Group

    (Complex)

    Client | Situations | Situations

    Opportunity | Summary | Situation Group

    Identifies client and opportunity situation sub groups, e.g. Not Work Ready, Year 11. Can define whether the Actively Seeking alert is triggered when changing client situations.

    For more information, see Creating Situation Sub Groups

    y

    y

    Situation Super Group

    (Complex)

    Client Search

    Opportunity | Summary

    Organises Situation Groups by type, e.g. Education, Employment.

    For more information, see Create Situation Super Groups.

    y

    n

    Situation Verification Source

    (Simple)

    Client | Situations | Situations

    Identifies the source of situation expiry confirmation, e.g. Family Member, School/College.

    y

    n

    Special Needs Support

    This function is not in use in One IYSS
  • Client Substance MisuseClient Substance Misuse

    Lookup

    Address

    Further Information

    System?

    Used for Mapping?

    Client SM - Accommodation Needs

    (Simple)

    Client | Episode | Accommodation

    Identifies clients’ current living arrangements, e.g. No Fixed Abode, Living with Relative.

    Y

    Y

    Client SM - Children

    This function is not in use in One IYSS

    Client SM - Child Living With

     

     

     

     

    Client SM - DAAT of Residence

    (Simple)

    Client | Episode | DAAT of Residence.

    Identifies the DAAT team boundaries within which the client resides, e.g. Leeds - South.

    Y

    Y

    Client SM - Discharge

    (Simple)

    Client | Treatment Exit | Discharge Reason

    Identifies the reasons for which clients were discharged, e.g. Treatment complete - drug free.

    Y

    Y

    Client SM - Discharge Dest

    (Simple)

    Client | Client | Treatment Exit | Discharge Destination

    Identifies to whom the client is being discharged, e.g. Lead Professional, Targeted Youth Support.

    Y

    Y

    Client SM - Drug

    (Simple)

    Client | Episode | Main Drug

    Client | Episode | Secondary Drug

    Client | Episode | Third Drug

    Identifies the types of drugs clients use, e.g. Cannabis, Ketamine.

    Y

    Y

    Client SM - Drug-Alcohol Use

    (Simple)

    Client | Treatment Exit | Reduced Drug / Alcohol Use

    Identifies clients’ reductions in substance misuse at the treatment exit stage, e.g. Stayed the Same, Drug free.

    Y

    Y

    Client SM - Education Status

    (Simple)

    Client | Episode | Education Status

    Identifies clients’ educational statuses, e.g. Mainstream Education, Permanently Excluded.

    Y

    Y

    Client SM - Employment Status

    (Simple)

    Client | Episode | Employment Status

    Identified clients’ employment statuses, e.g. Economically Inactive, Regular Employment.

    Y

    Y

    Client SM - Hep B Inter Status

    (Simple)

    Client | Episode | Hep B Intervention Status

    Identifies clients’ Hepatitis B intervention statuses, e.g. Immunised Already.

    Y

    Y

    Client SM - Hep C Inter Status

    (Simple)

    Client | Episode | Hep C Intervention Status

    Identifies clients’ Hepatitis C intervention statuses, e.g. Immunised Already.

    Y

    Y

    Client SM - Injecting Status

    (Simple)

    Client | Episode | Injecting Status

    Identifies whether clients inject, e.g. Currently Injecting, Previously Injected.

    Y

    Y

    ClientSM - Inter Setting

     

     

     

     

    Client SM - Local Authority

    (Simple)

    Client | Episode | Local Authority

    Identifies LA in which clients live, e.g. Sheffield.

    Y

    Y

    Client SM - Offered STI Screen

     

     

     

     

    Client SM - Offered Support

     

     

     

     

    Client SM - PCT of Residence

    (Simple)

    Client | Episode | PCT of Residence

    Identifies Primary Care Trust boundaries within which clients live, e.g. Sunderland Teaching PCT.

    Y

    Y

    Client SM - Parental Status

    (Simple)

    Client | Episode | Parental Status

    Identifies clients’ parental statuses, e.g. Not a Parent, All Children Live with Client.

    Y

    Y

    Client SM - Referral Source

    (Simple)

    Client | Substance Misuse Referral | Referral Source

    Identifies the agencies referring clients for Substance Misuse services, e.g. Frank, YOT.

    Y

    Y

    Client SM - Route of Admin

    (Simple)

    Client | Episode | Main Drug Route

    Client | Episode | Secondary Drug Route

    Client | Episode | Third Drug Route

    Identifies clients’ methods of drug administration, e.g. Oral, Inject, Smoke.

    Y

    Y

    Client SM - Sexuality

    (Simple)

    Client | Episode | Sexuality

    Identifies clients’ sexuality, e.g. Heterosexual, Gay.

    Y

    Y

    Client SM - Treatment Deliverd

     

     

     

     

    Client SM - YesNoNotAsked

     

     

     

     

    Client SM-Hep B Vacc Count

    (Simple)

    Client | Episode | Hep B Vaccination Count

    Identifies clients’ Hepatitis B vaccination counts, e.g. One Vaccination Completed Course.

    Y

    Y

    Client SM-Lead Prof Treat Exit

    (Simple)

    Client | Treatment Exit | Lead Professional

    Identifies the types of organisation taking the Lead Professional roles on clients’ exit from treatment, e.g. Drug Agency, Not Known.

    Y

    Y

    Client SM-Modality Exit Status

    (Simple)

    Client | Treatment | Treatment Exit Status

    Identifies why clients have ended treatment, e.g. Mutually agreed planned exit, Client unilateral unplanned exit.

    Y

    Y

    Client SM-Sex Worker Category

    (Simple)

    Client | Episode | Sex Worker Category

    Identifies if clients are sex workers, e.g. Not a sex worker, Selling sex from the street.

    Y

    Y

    Client SM-Sexually Active

     

     

     

     

    Client SM-TOP Treatment Stage

    (Simple)

    Client | Treatment Outcome Profile | Treatment Stage

    Identifies the stage of the Treatment Outcome Profile, e.g. Start.

    Y

    Y

    Client SM-Treat modality serv

     

     

     

     

    Client SM - Treatment Prov Types

    (Simple)

    Client | Treatment | Treatment Type

    Identifies the treatment type clients are receiving, e.g. Psychosocial Intervention, Family Work.

    Y

    Y
  • CommonCommon

    Lookup

    Address

    Further Information

    System?

    Used for Mapping?

    Attribute

    (Complex)

    Client | Administration | Additional Attributes

    Provider | Details | Other Attributes

    Opportunity | General | Other Attributes

    Multi-select fields that enable administrators to capture true/false data not available in the rest of client, provider or opportunity records, e.g. Do Not Email, Year Behind.

    N

    N

    Centre

    (Complex)

    Client | Administration | Managing Centre

    Opportunity | General | Managing Loc

    YS Activity | Summary | Locality

    YS Session | Summary | Staff Attending | Filter By Locality

    Identifies the centres managing clients and opportunities, e.g Seacroft.

    Where clients’ postcodes are unknown, the NCCIS XML extract will use their centre’s postcode for reporting purposes.

    N

    Y

    Health Issue

    (Complex)

    Client | Additional Needs | Health Issues

    Opportunity | Health and Safety | Health Issues

    Identifies clients’ health issues and feeds these into the special needs information, and identifies where clients’ health may be affected by certain opportunities, e.g. Asthma, Dyslexia.

    N

    N

    Occupational Area Group

    (Complex)

    Client | Aspirations | Aspirations | Employment/Training | Group

    Client | Aspirations | Aspirations | Work Experience | Group

    Client | Aspirations | Year 11 intended Destination | Occupational Area

    Client | Aspirations | Post 16 Intended Destination | Occupational Area

    Client | Situations | Occupational Area

    Opportunity | General | Occupational Area

    This informs different areas of One IYSS about the type of employment clients have or are seeking, e.g. Agriculture, Hairdressing and Beauty.

    In Aspirations, this identifies clients’ occupationally-based post 16/Year 11 intended destinations. It also identifies jobs and training currently being sought by clients, and assists with vacancy matching.

    In Situations, this identifies the types of jobs and training clients have entered. The data here informs the DCSF returns.

    In Opportunities, this identifies the types of jobs, training and WEX opportunities being offered. This assists with vacancy matching.

    For more information, see Occupation Management.

    N

    Y

    Overall Qualification Level

    (Complex)

    Client | Qualifications and Achievements | Actual Qualification Level

    Client | Qualifications and Achievements | Potential Qualification Level

    Opportunity | General | Inbound Qualification Level

    Identifies clients’ actual and potential overall academic achievement levels, e.g. NVQ Level 2.

    It also identifies qualification levels sought by employers, and can provide vacancy matching.

    Y

    N

    Phone Number Extra Info

    (Simple)

    Provider | Contact | Contact Details

    Provides additional information for recorded telephone numbers, e.g. Ex-directory, Evenings only.

    N

    N

    Specific Qualification Level

    (Complex)

    Client | Situations | Course Level

    Client | Qualifications and Achievements | Qualifications

    Opportunity | General | Outbound Qualification Level

    In Situations, this identifies the level of qualification clients will attain if they successfully complete the situation.

    In Qualifications, this identifies the level at which subjects are being studied, e.g. GCSE.

    In Opportunities, this identifies the level of qualification clients will attain if they successfully complete the opportunity.

    N

    N

    Submission Status

    (Complex)

    Client | Opportunity Submissions | Status

    Identifies where clients are in relation to submission processes, e.g. CV Sent, Interview Arranged.

    N

    N

    Submission Unsuccessful Reason

    (Simple)

    Client | Opportunity Submission | Not Started Reason

    Identifies why clients were unsuccessful with submissions to opportunities, once concluded, e.g. Did Not Attend Interview.

    N

    N
  • ContactPointContactPoint

    Lookup

    Address

    Further Information

    System?

    Used for Mapping?

    CP - Consent Source

    (Simple)

    Client | ContactPoint Administration | Consent Source

    Identifies who agreed to share the data with ContactPoint, e.g. Client, Mother, Father.

    n

    n

    CP - Retention Period

    (Simple)

    Client | ContactPoint Administration | Retention Period

    The length of time agreed for data to be shared, e.g. 1 Year, 2 Years.

    y

    n
  • Document and ParagraphsDocument and Paragraphs

    Lookup

    Address

    Further Information

    System?

    Used for Mapping?

    Document Type

    (Complex)

    Client | Documents Notes and Assessments | Document Type

    Provider | Documents and Notes | Document Type

    Opportunity | Documents and Notes | Document Type

    Organises document templates by type, e.g. CV, Action Plan.

    N

    N

    User Document Group

    (NA)

    Homepage | IYSS Links | View User Document

    Creates folders to group documents in the View User Document facilities, e.g. How To Guides, User Group Minutes.

    NA

    NA
  • Import - See the Import data  for import lookups.
  • InteractionsInteractions

    For more information, see Interaction Management.

    Lookup

    Address

    Further Information

    System?

    Used for Mapping?

    Default Interaction

    (Complex)

     

    The interactions used by the system.

    Y

    N

    Interaction Activity Type

    (Complex)

    Client | Interactions

    Provider | Interactions

    Identifies available activities within an interaction, e.g. Action Plan Completed.

     

    N

    N

    Interaction Category

    (Simple)

    Client | Interactions

    Provider | Interactions

    Identifies the category into which the interaction fits, e.g. Activity Survey, Guidance.

     

    N

    N

    Interaction Outcome

    (Complex)

    Client | Interactions

    Provider | Interactions

    Identifies interactions outcomes, e.g. Client DNA Interview, Follow Up.

     

    N

    N

    Interaction Type

    (Complex)

    Client | Interactions

    Provider | Interactions

    Identifies the interaction type, e.g. PA Interview, Follow Up. It also links the interaction options together.

     

    N

    N

    Venue

    (Simple)

    Client | Interactions

    Provider | Interactions

    Identifies the location of the interactions, e.g. School, Job Centre.

     

    N

    N
  • Personal Development ActivitiesPersonal Development Activities

    Lookup

    Address

    Further Information

    System?

    Used for Mapping?

    PD Category

    (Simple)

    Opportunity | Summary | Category

    Categorises the personal development opportunities, e.g. Arts, Health, Leisure.

    N

    N

    PD District

    (Simple)

    Provider | Personal Development Details | Districts

    Personal Development Opportunity | Summary | District

    Identifies the area in which the personal development provider or opportunity are found, e.g. East, Inner East.

    N

    N

    PD Organisation

    (Simple)

    Provider | Personal Development Details | Organisation Type

    Identifies the type of organisation running the opportunity, e.g. Charity, Voluntary Body.

    N

    N

    PD Provider CRB Checked

    (Simple)

    Provider | Personal Development Details | CRB Checked

    Indicates whether the provider carries out CRB checks on volunteers and staff, e.g. CRB Evidence Seen.

    Y

    N

    PD Provision Types

    (Simple)

    Provider | Personal Development Details | Type of Provision

    Identifies types of personal development activities offered, e.g. Volunteering, Youth Club.

    N

    N

    PD Target Group

    (Simple)

    Provider | Personal Development Details | Target Group

    Personal Development Opportunity | Summary | Target Group

    Identifies groups targeted by the provider or opportunity, e.g. 14 - 19 Year Olds, Years 7 - 11

    N

    N
  • Provider & OpportunityProvider & Opportunity

    Lookup

    Address

    Further Information

    System?

    Used for Mapping?

    Agency Type

    (Simple)

    Provider | Summary | Agency Type

    Client | Individual Circumstance | Link to Agency | Agency Type

    Identifies what type of agency the provider is, e.g. Mental Health, Teenage Pregnancy.

    Y

    N

    EBP Activity Category

    (Simple)

    Provider | EBP Activities | Category

    Identifies provider involvement with education business partnership activities, e.g. Actively Involved, Will Consider, Will Not Consider.

    N

    N

    EBP Activity Code

    (Simple)

    Provider | EBP Activities | Activity

    Identifies the type of education business activity offered by providers, e.g. Practice Interviews, School Talks.

    N

    N

    EBP Team

    This function is not in use in One IYSS.

    H & S Issue

    (Complex)

    Provider | Health and Safety Details | Health and Safety Issues

    Opportunity | Health and Safety Details | Health and Safety Issues

    Identifies health and safety issues needing attention when on site with a provider or opportunity, e.g. Hard Hat Area, Cold Environment.

    N

     

    N

    H & S Registration

    (Simple)

    Provider | Health and Safety Details | Health and Safety Registered With

    Identifies with whom the provider is registered for health and safety purposes, e.g. Health and Safety Executive.

    N

    N

    High Level Subject Area

    (Simple)

    Opportunity | Summary

    Client | Opportunity Submission

    For use in further education opportunity records, e.g. AS Levels.

    Y

    N

    Institute Type

    (Simple)

    Provider | Details | Institute Type

    Identifies education providers by institution type, e.g. Grant Maintained, Independent School.

    N

    N

    Insurance Company

    (Simple)

    Provider | Health and Safety Details\ Insurance | Insurers

    Identifies the provider’s insurer covering public and employee liability, e.g. Prudential, National Farmers Union.

    N

    N

    Internet Opp Category

    (Simple)

    Public opportunity search module

    Enables System Administrators to create client friendly occupational sub groups, e.g. Motor Vehicle Trades, Office Work.

    This supports One IYSS public opportunity search modules.

    For more information, see Occupation Management.

    N

    N

    Internet Opp Narrative Type

    (Complex)

    Public opportunity search module

    Enables System Administrators to display narrative sections of opportunities.

    This supports One IYSS public opportunity search modules.

    For more information, see Occupation Management.

    Y

    N

    Lunch Arrangements

    This function is not in use in One IYSS.

    Opportunity Narrative Type

    (Simple)

    Opportunity | Narratives

    Creates memo fields to add narrative content to opportunities, e.g. Detailed Duties, Payment Details.

    N

     

    N

    Opportunity Place Outcome

    (Simple)

    Opportunity | Monitoring | Status

    Identifies the status of opportunity places, e.g. Active, Filled by Others, cancelled.

    Y

    N

    Opportunity Status

    (Simple)

    Opportunity | Summary | Status

    Identifies the status of opportunities, e.g. Live, Suspended, Cancelled.

    Y

    N

    Opportunity Type

    (Complex)

    My Homepage | New opportunity

    Enables configuration of the options that are displayed under the Opportunity Types, e.g. Vacancy, Training.

    Y

    N

    Protective Clothing

    (Simple)

    Opportunity | Health and Safety | Protective Equipment Supplied

    Identifies protective equipment supplied by provider when starting an opportunity, e.g. Gloves, Goggles.

    N

    N

    Provider Contact Role

    (Simple)

    Provider | Contacts | Role

    Categorises providers’ different contact roles, e.g. HR Adviser, Director, Careers Teacher.

    N

    N

    Provider Role Type

    (Complex)

    Provider | Contacts | Role

    Enables Provider Contact Roles to be filtered by Provider Type, e.g. Employer General, School General.

    N

    N

    Provider HS Status

    (Simple)

    Provider | Health and Safety | Health and Safety

    Identifies providers’ health and safety status and warns of unapproved providers, e.g. Approved, Not Applicable.

    N

    N

    Provider Size Band

    (Simple)

    Provider | Provider LMI | Size Band

    Identifies number of people employed by providers, e.g. 0 - 5, 500+.

    N

    N

    Provider Status

    (Simple)

    Provider | Summary | Status

    Identifies status of entire provider records, e.g. Live, Inactive.

    Y

    N

    Provider Turnover Band

    (Simple)

    Provider | Provider LMI | Turnover Band

    Identifies providers’ annual turnover, e.g. £500,000 - £999,999, Over £100,000.

    N

    N

    Provider Type

    (Simple)

    Provider | Summary | Type

    Identifies the type of provider record and configures fields in the rest of the record accordingly, e.g. Employer, School, Training Provider.

    Y

    N

    Risk Category

    (Complex)

    Opportunity | Summary | Risk Category

    Identifies opportunity risk levels, e.g. Low, Medium, High.

    N

    N

    SIC Code

    (Simple)

    Provider | Provider LMI | SIC

    Identifies under which Standard Industrial Classifications providers are classified, e.g. Metal Goods Manufacturer, Wholesale Distribution.

    N

    N

    SIMS Version

    This function is not in use in One IYSS.

    SOC Code

    (Simple)

    Opportunity | General | SOC Code

     

    Only shown in the opportunity record, this is the four digit Standard Occupational Classification (SOC) number which links to all occupational groupings, e.g. 1132, 2000.

    For more information, see Occupation Management.

    N

    Y

     

    School Dates

    (Complex)

    Client | Situation | Statutory Education Leaving Date

    Defines key dates in client records by year, e.g. 2017.

    N

    Y

    School Year Group

    (Simple)

    Client | Situation | Year Group

    Identifies clients’ actual year groups in cases where clients are moved forward or held back a year, e.g. Year 11.

    Y

    Y

    Vacancy Contract Type

    (Simple)

    Opportunity | Summary | Contract Type

    Identifies contract types offered by opportunities, e.g. Full Time, Temporary.

    N

    N

    Vacancy Handling Priority

    (Simple)

    Opportunity | General | Handling Priority

    Identifies what priority levels are given to vacancies being processed, e.g. Low, High.

    N

    N

    Vacancy Pay Band

    This function is not in use in One IYSS.

    Vacancy Pay Period

    This function is not in use in One IYSS.

    Vacancy Source

    (Simple)

    Opportunity | General | Source

    Identifies who first received each vacancy, e.g. Connexions, Job Centre Plus.

    N        

    N

    Working Hours

    This function is not in use in One IYSS.
  • Security -  Security Groups for these lookups.
  • Statistics - Refer to the DX Manual for these lookups.
  • SystemSystem

    Lookup

    Address

    Further Information

    System?

    Used for Mapping?

    Client ID Description

    (Simple)

    Client | Administration | IDs

    Enables System Administrators to change the descriptions of local ID fields to capture identifiers unique to the locale, e.g. Connexions Card, NI Number.

    Y

    N

    Lookup Header

    (Complex)

     

    Enables System Administrators to determine whether lookup fields are determined by user-defined sort sequences.

    Y

    N

    System Value

    (Complex)

     

    Sets system-wide values.

    See System Values

    Y

    Y

    Useful Links

    (Complex)

    My Homepage | Useful Links

    Creates hyperlinks to external internet resources that are displayed in my homepage, e.g. BBC, DCSF, Every Child Matters.

    N

    N
  • TYSTYS

    Lookup

    Address

    Further Information

    System?

    Used for Mapping?

    Client TYS - Age Police Contact

    (Simple)

    Client | Crime Prevention Case | Age at first Police Contact

    The age when first contacted by police, e.g. 11, 12, Don’t Know.

    Y

    N

    Client TYS - Case Outcome

    (Complex)

    Client | Crime Prevention Case | Case Outcome

    Client | Other TYS Case | Case Outcome

    Client | Teenage Pregnancy Case | Case Outcome

    Case Outcomes are filtered by Service to enable the use of service-specific options, e.g. Left Early, Reoffended, Gave Birth.

    N

    N

    Client TYS - Case Type

    (Complex)

    Client | Crime Prevention Case | Case Type

    Client | Other TYS Case | Case Type

    Client | Teenage Pregnancy Case | Case Type

    Case Types are filtered by Service to enable the use of service-specific options, e.g. Reoffending Risk, Emergency Housing.

    N

    N

    Client TYS - CR Offence

    (Simple)

    Client | Crime Prevention Case | Community Resolution | Offence

    Possible offences, e.g. Criminal Damage, Theft from Car.

    N

    N

    Client TYS - CR Outcome

    (Simple)

    Client | Crime Prevention Case | Community Resolution | Outcome

    Possible outcomes, e.g. Client Absconded, Returned to Custody.

    N

    N

    Client TYS - CR Recommendation

    (Simple)

    Client | Crime Prevention Case | Community Resolution | Recommendation

    Possible recommendations, e.g. Community Order, Victim Liaison.

    N

    N

    Client TYS - CurrentPreviousNoDK

    (Complex)

    Anywhere where the values of Current, Previous or Don’t Know are found in TYS.

    Client | all service types | History of Care:

    Accommodated by voluntary agreement with parents

    Subject to Care Order

    On Child Protection Register

    Subject to CAF

    Provides the Current, Previous, No, Don’t Know options for the relevant fields.

    Y

    N

    Client TYS - Homeless Sub Cat

    (Simple)

    Client | all service types | Homeless Sub Category

    Describes homeless clients’ current living arrangements, e.g. Hostel, Night Shelter, Roofless.

    Y

    N

    Client TYS - Living With

    (Simple)

    Client | all service types | Accommodation and Family Details | YP Living With

    Provides details of person with whom clients are currently living, e.g. Care of LA, Sibling, Father.

    N

    N

    Client TYS - Referral Outcome

    (Complex)

    Client | all service types | Referral Outcome

     

    Identifies why a referral was closed. Referral Outcomes are filtered by Service to enable the use of service-specific options, e.g. Unilateral Departure, Mutually Agreed Departure.

    N

    N

    Client TYS - Referral Source

    (Simple)

    Client | all service types | Referral Source

     

    Identifies the organisation that referred the client, e.g. School, PCT, Police.

    N

    N

    Client TYS - Victim Type

    (Simple)

    Client | Crime Prevention Case | History of Offending | Victim Type

    Enables details to be provided about offences with victims, e.g. Racially Motivated, Specific, Targeted Victim(s).

    Y

    N

    Client TYS - YesDKNA

    (Complex)

    Anywhere where the values of Yes, Not Applicable or Don’t Know are found in TYS

    Client | Crime Prevention Case |

    Educational Attendance Known

    Frequency of Police Contact Known

    Provides the Yes, No, Don’t Know options for relevant fields.

    Y

    N
  • YJ AssetYJ Asset

    Lookup

    Address

    Further Information

    System?

    Used for Mapping?

    Case Stage

    (Simple)

    Client | YJ Case | Assessments Plans and Reviews | Asset | Case Stage

    Identifies the client case’s current stage when an assessment is completed.

    N

    N

    Plan Intervention Method

    (Simple)

    Client | YJ Case | Assessments Plans and Reviews | Intervention Plan | Target | Method

    Identifies the method of delivery of an intervention plan target.

    N

    N
  • YJ CaseYJ Case

    Lookup

    Address

    Further Information

    System?

    Used for Mapping?

    Accommodation Impact

    (Simple)

    Client | Summary | Accommodation Impact

    Evaluates the impact clients’ accommodation has on their offending behaviour, e.g. Positive, Negative.

    N

    N

    Accommodation Suitable

    (Simple)

    Client | Summary | Accommodation Suitability

    Describes if clients’ current accommodation is suitable, e.g. Yes, No.

    N

    N

    Accommodation Type

    (Complex)

    Client | Summary | Accommodation Type

    Describes clients’ current accommodation, e.g. Sofa surfing, hostel.

    N

    N

    Additional Aggravated Circs

    (Simple)

    Client | YJ Case | Offence | Additional Aggravated Circumstances

    Indicates any aggravated circumstances related to the offence, e.g. Knife used on school premises; Gang related.

    N

    N

    Additional Worker Role

    (Simple)

    Client | YJ Case | Case Details | Additional Worker

    Identifies the role of additional workers, e.g. Volunteer; SM Worker.

    N

    N

    Additional Workers

    (Complex)

    Client | YJ Case | Case Details | Additional Worker

    Identifies additional workers, e.g. Daniel Norris.

    N

    N

    Adjourned Information

    (Simple)

    Client | YJ Case | Court Appearances | Adjourned Additional Information

    Identifies the reason a court hearing was adjourned, e.g. Arrested on Old Charges; Adjourned for Review of Money Payments.

    N

    N

    Bail Remand Information

    (Complex)

    Client | YJ Case | Court Appearances | Bail/Remand Additional Information

    Provides additional information about clients’ actual remand status, e.g. Bail Refused - Offence Committed Very Serious; Grounds for Secure - History of Absconding/Offence.

    N

    N

    Breach Decision Reason

    (Complex)

    Client | YJ Case | Events | Breach Decision Reason

    Additional information as to why a breach may have been initiated or stayed.

    N

    N

    Case Outcome

    (Simple)

    Client | YJ Case | Case Details | Case Outcome

    Identifies the reason a case has been closed, e.g. Moved Away; Deceased.

    N

    N

    Case Role

    (Simple)

    Client | YJ Case | Case Worker | Role

    Identifies the role of a case worker linked to a client.

    N

    N

    Case Type

    (Simple)

    Client | YJ Case | Case Details | Case Type

    Identifies the type of case, e.g. Active; Inactive.

    N

    N

    Client Relationship Type

    (Simple)

    Client | YJ Case | Gangs and Relationships | Relationship

    Identifies the links or relationships between YJ clients, e.g. Ally, Rival.

    N

    N

    Court

    (Complex)

    Client | YJ Case | Court Appearances | Court

    Client | YJ Case | various EYE Documents

    Identifies the court at which a client’s hearing is taking place.

    N

    Y

    Event Type

    (Complex)

    Client | YJ Case | Events | Type

    Identifies the types of events or contacts with which the client is involved, e.g. First Contact; Initiate Breach

    Y

    Y

    Gang Member Type

    (Simple)

    Client | YJ Case | Gangs and Relationships | Membership Type

    Identifies position in a gang or relationship to a gang, e.g. Member; Leader.

    Y

    N

    Gang Relationship Type

    (Complex)

    Unseen in system

    Determines whether the relationship is categorised as putting clients in alliance or in conflict with each other, e.g. Ally (Alliance), Rival (Conflict).

    This is indicated by the colour in which they are displayed in YJ, Conflict = red, Alliance = green.

    Y

    N

    Gangs

    (Complex)

    Client | YJ Case | Gangs and Relationships | Gang

    Identifies the name, territory, and relationships of gangs.

    N

    N

    Intervention Programme Outcome

    (Simple)

    Client | YJ Case | Intervention Programme | Outcome

    Identifies the outcome of an intervention programme, e.g. Complete; Consecutive.

    N

    N

    Intervention Programme Type

    (Complex)

    Client | YJ Case | Intervention Programme | Type

    Identifies the type of intervention programme the client has been handed and can be configured to automatically add prescribed events as part of the programme, e.g. Youth Rehabilitation Order; Reparation Order.

    Programme types can be identified as custodial sentences. Clients undergoing custodial interventions are denoted as Currently in Custody in their core record.

    Programme types can be identified as preventative interventions. Prevention intervention programmes do not require linking to offences.

    N

    Y

    Interview Outcome

    (Simple)

    Client | YJ Case | Pre-Court Decisions and Interviews | Pre-Court Interview | Interview Outcome

    Identifies the outcome of a pre-court interview

    N

    N

    Interview Type

    (Simple)

     

    Identifies the type of interview the client attended.

     

     

    Legal Representative

    (Complex)

    Client | YJ Case | Court Appearances | Legal Representative

    Client | YJ Case | various EYE Documents

    Displays the Legal Representative present at court.

    NOTE: These can also be added via the web application.

    N

    N

    Legal Representative Role

    (Simple)

    Client | YJ Case | Court Appearances | Legal Representative

    Client | YJ Case | various EYE Documents

    Displays the role of the Legal Representative present at court.

    NOTE: These can also be added via the web application.

    N

    N

    Magistrate

    (Complex)

    Client | YJ Case | Court Appearances | Magistrate

    Client | YJ Case | various EYE Documents

    Displays the name of the court personnel in attendance at a hearing.

    NOTE: These can also be added via the web application.

    N

    N

    Magistrate Role

    (Simple)

    Client | YJ Case | Court Appearances | Magistrate

    Client | YJ Case | various EYE Documents

    Displays the role of the attending member of court personnel at a hearing, e.g. Magistrate; Justice’s Clerk.

    NOTE: These can also be added via the web application.

    Y

    N

    Offence Outcome

    (Complex)

    Client | YJ Case | Court Appearances | Offences | Outcome

    Client | YJ Case | Offences | Latest Outcome

    Client | YJ Case | various EYE Documents

    Identifies the court’s outcome for an offence.

    Y

    Y

    Offence Plea

    (Simple)

    Client | YJ Case | Court Appearances | Offence | Plea

    Client | YJ Case | various EYE Documents

    Identifies the client’s plea to the offences heard in court, e.g. Guilty; Not Guilty.

    N

    N

    Offence Type

     

    For more information, see Offence Types and YOGRS.

     

     

    Other Additional Information

    (Simple)

    Client | YJ Case | Court Appearance | Other Additional Information

    Shows additional information for when a court appearance is concluded with the action of ‘Other’, e.g. Trial Collapsed.

    N

    N

    Parental Responsibility

    (Simple)

    Client | YJ Case | Summary | Address Details | Parental Responsibility

    Client | Summary | Current Address Details | Parental Responsibility

    Identifies parental responsibilities of people at clients’ current addresses, e.g. Birth Mother; Adoptive Parents.

    N

    N

    Parenting Activity Type

    (Simple)

    Client | YJ Case | Parenting Intervention | Activities

    Identifies the activities linked to a Parenting Intervention.

    N

    N

    Parenting Intervention Outcome

    (Simple)

    Client | YJ Case | Parenting Intervention | Outcome

    Identifies the outcome of a Parenting Intervention.

    N

    N

    Parenting Intervention Type

    (Complex)

    Client | YJ Case | Parenting Intervention | Type

    Identifies the nature of the parenting intervention, e.g. Voluntary Parenting Programme, Parenting Order.

    N

    N

    Pre Court - Issued By

    (Simple)

    Client | YJ Case | Pre Court Decisions | Issued By

    Identifies the type of person issuing the pre-court decision, e.g. Custody Officer.

    N

    N

    Pre Court Decision Type

    (Simple)

    Client | YJ Case | Pre Court Decisions | Type

    Identifies the type of pre-court decision, e.g. Charged; Not Charged.

    N

    N

    RJ Intervention Type

    (Complex)

    Client | YJ Case | Victim | RJ Intervention Types

    Identifies the nature of restorative justice offered to victims, e.g. Letter of Apology, Mediation.

    N

    Y

    Referral Category

    (Simple)

    Client | YJ Case | Referral | Category

    Identifies the category of a referral, e.g. Positive Activities, Notification.

    N

    N

    Referral Outcome

    (Simple)

    Client | YJ Case | Notifications | Outcome

    Identifies the outcome of any notifications, e.g. Case Opened, Deceased.

    N

    N

    Referral Source

    (Simple)

    Client | YJ Case | Notifications | Notification Source

    Identifies the source of the notification, e.g. Police, Court.

    N

    N

    Referral Stage

    (Simple)

    Client | YJ Case | Referral | Referral Stage | Stage

    Identifies the current stage of referrals, e.g. Accepted, Being Assessed.

    N

    N

    Report Type

    (Simple)

    Client | YJ Case | Court Appearances | Report Request | Report Type

    Identifies the type of report a court has requested, e.g. Parenting Order Assessment; Action Plan Order Assessment

    N

    N

    Review Outcome

    (Simple)

    Client | YJ Case | Case Details | Case Review | Outcome

    Identifies the outcome of a case review, e.g. Completed; Outstanding.

    N

    N

    Sentenced Information

    (Simple)

    Client | YJ Case | Court Appearances | Sentenced Additional Information

    Provides additional information for concluded court appearances resulting in a Sentenced action, e.g. Appeal Against Sentence, Verdict Reached.

    N

    N

    Situation Impact

    (Simple)

    Client | Summary | Current Situation | Impact

    Client | Situation | Impact

    Describes the impact clients’ current situations are likely to have on their offending behaviour, e.g. Add To Behaviour, Positive, Negative

    N

    N

    Substantive Outcome Req Type

    (Complex)

    Client | YJ Case | Court Appearances | Offences | Outcome

    Client | YJ Case | Offences | Latest Outcome

    Client | YJ Case | various EYE Documents

    Identifies the courts’ outcomes following sentencing, e.g. Unpaid Work, Drug Testing

    Y

    Y
  • Youth ServiceYouth Service

    Note: You need a Youth Service license code to access this area.

    Lookup

    Address

     

    Further Information

    System?

    Used for Mapping?

    Challenging Discrimination

    (Simple)

    YS Session | Curriculum, Activities and Issues | Challenging Discrimination and Prejudice

    YS Opportunity | Detached / Outreach Session | Challenging Discrimination and Prejudice

    Identifies the areas of discrimination to be challenged during YS sessions, e.g. Age, Race, Gender.

    N

    N

    YS Funding

    (Simple)

    Opportunity | Summary | ‘Funding\ Partnership’

    Identifies funding source or partnership of personal development opportunities.

    N

    N

    YS Session Achievement Type

    (Complex)

    Client | Qualifications and Achievements | Achievements and Positive Activities | Achievement

    Records client achievements, e.g. accredited achievements, session learning outcomes.

    N

    N

    YS Session Activity

    (Simple)

    YS Session | Curriculum, Activities and Issues | Activities

    Identifies activities covered during YS sessions, e.g. Social Education Programme, PSHE.

    N

    N

    YS Session Curriculum

    (Complex)

    YS Session | Curriculum, Activities and Issues | Curriculum Area

    YS Opportunity | Detached / Outreach Session | Curriculum Area

    Identifies the curriculum area being addressed at the YS session, e.g. Enjoy and Achieve, Be Healthy.

    For more information, see YS Session Curriculum.

    N

    N

    YS Session Curriculum Sub Area

    (Simple)

    YS Session | Curriculum, Activities and Issues | Curriculum Area

    YS Opportunity | Detached / Outreach Session | Curriculum Area

    Identifies which part of the curriculum area is being addressed at the YS session, e.g. Diet, Exercise, Harm Reduction.

     

    N

    N

    YS Session Evaluation

    (Simple)

    YS Session | Evaluation | Young Persons Evaluation of Session

    YS Session | Evaluation | Overall Evaluation of Session

    Gives the YS session a quality rating, e.g. Good, Very Good, Weak.

    N

    N

    YS Session Level of Contact (Simple)

    YS Opportunity | Detached / Outreach Session | Level of Contact

    Establishes the level of contact with clients in detached and outreach sessions, e.g. Observation, Conversation, Intervention.

    N

    N

    YS Session Staff

    (Complex)

    YS Session | Summary | Staff Attending

    YS Opportunity | Detached / Outreach Session | Staff Attending

    Identifies staff in attendance at YS sessions. Can be filtered by Locality

    For more information, see YS Session Staff .

    N

    N