Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
Introduction
Introduction

Panel
titleIntroduction

This page lists and defines the key data terms used across the Application Dashboard suite of Tableau workbooks.


Anchor
Contents
Contents

Panel
titleTable of contents

...

Panel
titleData Terms contained in the Application workbooks

Definitions

The below definitions have been agreed upon with SRA and are used throughout the applications data set. For the purposes of theses definitions a Potential Student is defined as any person who has had a official interaction with the University of York applications and admissions process. From a technical standpoint this is defined as any person who has a record in the CAPS table of the SITS database.


NB see also recent changes to definitions (below)

Term

Business Definition

Technical Definition

Application

A recorded instance of a Potential Student applying for a place on a Programme at the University of York (that is not due to a miscoding).

A CAPS record where the Status Code is not like 'Z%'


WithdrawalAn Application that has been withdrawn by the Potential Student.A record where the Status Code  is not like 'Z%' and like 'W%'
Live ApplicationAn Application which is not a Withdrawal; not invalidated due to the Potential Student firmly accepting an Unconditional offer for another Programme either at York or another institution; and not superseded by a replacement/adjusted application record.

A CAPS record where the Status Code is like 'A%'


Offer

An Application that has led to a Potential Student being offered a Conditional or Unconditional place at the University of York.

It is worth noting that, though this offer may later be rescinded or turned down, these offers will still be included. This field records the fact that the Offer was made, not that the offer is currently live (see Live Offer).

A record where the Status Code is not like 'Z%' and the Decision/Response Code is like '%C%' or like '%U%'
Live Offer

An Application that resulted in the Potential Student currently holding a Conditional or Unconditional offer for a Programme at the University of York.

Unlike the above Offer definition this will not include offers that have been subsequently rescinded or turned down. As such offers will be excluded where they have been Declined or Rejected, or the Application has been Withdrawn, or the Potential Student has firmly accepted an Unconditional offer for another programme either at York or another institution.

A record where the Status Code is not like 'Z%' not like 'W%' and not like 'UF%' and the Decision/Response Code is not like '%D', not like '%R%' and (like '%C%' or like '%U%')

Pending Offer Decision

Live Application for which the University has neither made a Conditional or Unconditional Offer, nor Rejected the Application.

A record where the Status Code is like 'A%' the Decision/Response Code is NULL

Offer Decision MadeAn Application for which the University has either made a Conditional or Unconditional Offer, or Rejected the Application.A record where the Status Code is not like 'Z%' and the Decision/Response Code is like '%C%' or like '%U%' or like '%R%'
Firm Acceptance

Live Offer which the Potential Student has subsequently firmly accepted.

A record where the Status Code  is not like 'Z%' not like 'W%' and not like 'UF%' and the Decision/Response Code is like %F'

Conditional Firm

Live Offer that is Conditional to which the Potential Student has responded with a Firm Acceptance.A record where the Status Code is not like 'Z%' not like 'W%' and not like 'UF%' and the Decision/Response Code is like %CF'

Unconditional Firm

Live Offer that is Unconditional to which the Potential Student has responded with a Firm Acceptance.A record where the Status Code is not like 'Z%' not like 'W%' and not like 'UF%' and the Decision/Response Code is like %UF'
Conditional Decline

An Application that has resulted in the Potential Student being made a Conditional offer for a Programme at the University of York which they have now Declined.

Where Potential Students in receipt of a Conditional offer subsequently firmly accept an Unconditional offer for another Programme, either at York or another institution, this is considered equivalent to a Conditional Decline.

A record where the Status Code is not like 'Z%' and not like 'W%' and the Decision/Response Code is like %CD' and additionally as a record where Status Code is not like 'Z%' and like 'UF%' and the Decision/Response Code is like '%CF' or like '%CI' or like '%C'
Unconditional Decline

An Application that has resulted in the Potential Student being made a Unconditional offer for a Programme at the University of York which they have now Declined.

Where Potential Students in receipt of a Unconditional offer subsequently firmly accept an Unconditional offer for another Programme, either at York or another institution, this is considered equivalent to a Unconditional Decline.

A record where the Status Code is not like 'Z%' and not like 'W%' and the Decision/Response Code is like %UD' and additionally as a record where Status Code is not like 'Z%' and like 'UF%' and the Decision/Response Code is like '%UF' or like '%UI' or like '%U'

Rejected Without Offer

An Application that has not been Withdrawn by the Potential Student, and which the University has rejected without making an offer.A record where the Status Code  is not like 'Z%' and not like 'W%' and the Decision/Response Code is like %R%' and not like '%C%'
Rejected After Offer

An Application that has not been Withdrawn by the Potential Student, and which the University has rejected after having previously made an offer.

A record where the Status Code  is not like 'Z%' and not like 'W%' and the Decision/Response Code is like %R%' and like '%C%'

Initial Offer TypeThe type (Conditional or Unconditional) of the first offer to be made in respect of an application (i.e. irrespective of prior rejections and subsequent changes to the offer type).n/a
Initial Response TypeThe type (Insurance, Firm, or Declined) of the first response made by the applicant in respect of an offer (i.e. irrespective to subsequent changes to the response type).n/a
Firm Proportion of Conditional Offers

AllOffers where the Initial Offer Type was Conditional andthe Initial Response Typewas Firm

/

All Offers where the Initial Offer Type was Conditional 

n/a

Insurance Proportion of Conditional Offers

AllOffers where the Initial Offer Type was Conditional andthe Initial Response Typewas Insurance

/

All Offers where the Initial Offer Type was Conditional 

n/a

Decline Proportion of Conditional Offers

AllOffers where the Initial Offer Type was Conditional andthe Initial Response Typewas Declined

/

All Offers where the Initial Offer Type was Conditional 

n/a

No Response Proportion of Conditional Offers

AllOffers where the Initial Offer Type was Conditional andthe Initial Response Typeis Null*

/

All Offers where the Initial Offer Type was Conditional 

n/a

*i.e. the applicant has not made any response to the offer.

Firm Proportion of Unconditional Offers

AllOffers where the Initial Offer Type was Unconditional andthe Initial Response Typewas Firm

/

All Offers where the Initial Offer Type was Unconditional

n/a

Insurance Proportion of Unconditional Offers

AllOffers where the Initial Offer Type was Unconditional andthe Initial Response Typewas Insurance

/

All Offers where the Initial Offer Type was Unconditional

n/a

Decline Proportion of Unconditional Offers

AllOffers where the Initial Offer Type was Unconditional andthe Initial Response Typewas Declined

/

All Offers where the Initial Offer Type was Unconditional

n/a

No Response Proportion of Unconditional Offers

AllOffers where the Initial Offer Type was Unconditional andthe Initial Response Typeis Null*

/

All Offers where the Initial Offer Type was Unconditional

n/a

*i.e. the applicant has not made any response to the offer.

...