Infectious Disease in the Uk Nhs Managed Market by vpd18472

VIEWS: 6 PAGES: 154

More Info
									  TRUE




                   SUS Payment By Results

                   SUS PbR File Extract Specifications

                   for managed service and default on-line reporting

                   And Frequently Asked Questions



                                               Version 2.2

                                               21st September 2006




3/4/2011:8:22 PM                                          1            37108bea-7726-4509-9d4e-21ceed471278.xls:Title
3/4/2011:8:22 PM   2   37108bea-7726-4509-9d4e-21ceed471278.xls:Title
SUS Payment By Results                        Frequently Asked Questions                Admitted Patient Care File Extract Specifications




                         Index


                         Index   Worksheet

                            3    FAQ APC                          APC Frequently Asked Questions

                            4    FAQ OutPatient                   Outpatient Frequently Asked Questions

                            5    FAQ A&E                          A&E Frequently Asked Questions

                            6    HRGCodes                         HRG fields - detailed response

                            7    ServiceID_mapping                Mapping of SUS to National Service IDs

                            8    APC Spell                        PbR SUS Spell Level Standard Extract

                            9    APC Episode                      PbR SUS Episode Level Standard Rep

                           10    OutPatient                       PbR SUS Outpatients Standard Extract

                           11    A&E                              PbR SUS A&E Standard Extract

                           12    Treatment Of Errors              Treatment of Errors in Spell Construction

                           13    Emergency Re-Admissions          Emergency readmissions




3/4/2011:8:22 PM                                          3                               37108bea-7726-4509-9d4e-21ceed471278.xls:SheetIndex
SUS Payment By Results                                                               Frequently Asked Questions                                      Admitted Patient Care File Extract Specifications




            Frequently Asked Questions v2.2
               Number   Question                           Response
                 1      Our Trust has a local              All local agreements should be approved by the Department of Health Payment by Results Team or reflect current Payment by
                        agreement with the PCT for a       Results guidance from the DH and the need for such agreements should be rare. There are also rare examples, such as designated
                        locally agreed set of patients     spinal treatment units, in which activity is outside the scope of PbR, but not excluded automatically by SUS. For both these types of
                        and we need to identify them       cases, it is necessary to be able to identify them in the extracts and there are two possible ways:
                        separately so we can make
                        the necessary adjustments.         1) Exclude them from PbR using the '=' sign in the contract ID field prior to submitting data. This will mean that the episodes will not
                                                           be part of spell construction which in some cases will remove spells (where the episode would otherwise have been the only non
                                                           excluded episode within the hospital provider spell) and in other cases will change the spell construction and thus (in many cases) the
                                                           HRG. Local unit prices or block values for the episodes can be handled without reference to the PbR extracts in these cases. Not that
                                                           the use of the "=" sign for exclusion should be notified to DH and agreed by them.
                                                           2) Identify them through analysis, for example through the use of the contract ID and undertake local adjustment by agreement.

                   2    As our Trust relies on our         This relates particularly to the issue identified above, as some Trusts can not have '=' appended to values in the Contract ID field so
                        PAS supplier, we can't control     episodes can not be excluded in this way. In this case the second of the options above should be adopted.
                        some of the things required        (It should be noted that the use of the "=" sign to mark exclusions should be exceptional as SUS handles routine exclusions
                        by SUS?                            automatically - see the document APC Exclusions in 2006/7 at http://www.connectingforhealth.nhs.uk/sus/reference/apcexclusions.pdf


                   3    What data is populating the        This issue has now been dealt with. The GP code appears in the GP code field and the practice code is populated. BT has updated
                        GP and Practice code fields        reference and implemented data changes to correct derived fields, however many derived fields will still be blank for data processed
                        in the extracts?                   earlier in the quarter.
                   4    Why are the age fields             8000 is the missing value indicator for the age field in PbR and ensures that a U code is assigned when age (which is presently a
                        populated with 8000 in some        mandatory grouper input) is absent.
                        instances?                         In addition in the spell extract, but not the episode extract, the 8000 appears where there is no dominant episode for the spell. It is
                                                           recognised that this is an error and will be corrected in a later version of the extract.
                   5    There are duplicate episodes Checking has confirmed that these issues arise because of errors in the submitted data (see previous response) and are one of
                        in the extract.              several errors which are trapped and flagged in spell construction. It is important that users check these errors and Commissioners
                                                     will wish to discuss implications for payment when they occur.
                                                     Extended spell error reports will be provided to accompany the flex date extracts and additional guidance will be provided on the use
                                                     of the interpretation of error flags as part of this
                   6    On the spells extract, the field   New values for PbR Qualified indicator have been used. These are 0 - PbR Qualifying spell
                        entitled 'PbR spell in PbR         1 - All episodes in the spell have been deleted and not replaced.
                        scheme Flag' shows only            2 - All episodes in the new version are excluded.
                        zeros and ones.                    3 - Multiple episodes in an AE/OP pseudo-spell. Not costed. (This flag is used for internal checking and should never be seen by
                                                           users)
                                                           4 - Spell end date < 01apr05




3/4/2011:8:22 PM                                                                                       4                                                  37108bea-7726-4509-9d4e-21ceed471278.xls:FAQ APC
SUS Payment By Results                                                            Frequently Asked Questions                                         Admitted Patient Care File Extract Specifications




            Frequently Asked Questions v2.2
                   7    There appear to be many null A number of PbR specific fields in the spell extract - such as dominant HRG - relate to the dominant episode. Where the spell is
                        values within the extracts.  outside of PbR, there is no dominant episode and these spell values are, correctly, not populated.
                        Why is this?                 However, some other fields such as Date of Birth, which should be populated under all circumstances are presently only being
                                                     populated for dominant episode. This is an error and is being pursued by CFH and BT.

                                                       It is recognised that this is an error and will be corrected in a later version of the extract.
                   8    Some of the fields appear      The approach has been to return as much episode level information, taking account of the limit on the number of fields which can be
                        unnecessary. Can they be       handled within desktop packages (e.g. MS-Access is limited to 255 columns). Only a subset of these are relevant for PbR.
                        ignored?                       More specifically the naming of the some of the HRG fields in the spell extract is not intuitive, because Organisations do not submit
                                                       spell level HRG so the word 'submitted' is not appropriate.
                                                       As set out in the specification, because of some mapping issues internal to SUS, some of the fields that were originally intended to be
                                                       checks against reference tables and return ???? or #### for example, do not do this. This is being looked into because where
                                                       commissioner codes do not tie up to a reference table of valid commissioner codes, no commissioner will receive the relavant records.

                                                       !!!! Not applicable, e.g. a column such as first attendance is in the spell master but does not apply to APC.

                                                       #### Missing value in the source data.

                                                       ???? Unknown value in the source data. Usually the data is not in NACS or the data dictionary but for some Q1 data there were
                                                       missing reference data values. CfH has been working with BT to correct these.

                                                       **** Orphan, this is where a derived value is required. SUS recognises the value in the data from the sender but there is no parent in
                                                       the SUS reference data. Again there have been reference data problems and work has been going on to fix these.



                   9    Private patient spells are     This has been resolved within the 06/07 algorithm by including additional functionality to deal with inconsistencies in the submitted
                        being processed as if they are data.
                        qualified under PbR
                   10   The specification of the       The most current specification can be found on the CfH website under reference documents PbR.
                        extracts in terms of field     http://www.connectingforhealth.nhs.uk/sus/reference/
                        names and in some cases,
                        field content has changed?
                   11   For some spells, we have a     This problem relates only to 2005/6 and was very rare. It arose because of an internal inconsistency in the standalone grouper. This
                        different top up value than    did not affect SUS as in 05/06 the SSC used as a basis for top-up calculation was derived within SUS.
                        that generated by SUS.         Because of the increased complexity of SSC calculation, in 2006/7 SUS uses the UNIX version IC/Woodward grouper to derive SSC
                                                       and this will ensure consistency.




3/4/2011:8:22 PM                                                                                     5                                                   37108bea-7726-4509-9d4e-21ceed471278.xls:FAQ APC
SUS Payment By Results                                                              Frequently Asked Questions                                        Admitted Patient Care File Extract Specifications




            Frequently Asked Questions v2.2
                   12   I have found a spell which     Inconsistencies were found in some 05/06 spells which both started on the same day where certain other conditions were met (see
                        seems to have fused two        earlier response). SUS spell construction has been reviewed for 06/07 to deal with the problem which is now resolved.
                        spells. Can this be explained?
                                                       Users should be aware that as part of the 06/07 solution, in discussion with DH, SUS departs from the strict data dictionary definition
                                                       of a spell in the specific case where a patient is admitted AND discharged more than once on the same day. Where this happens for
                                                       the same provider, the guidance given to SUS is that this should be treated as a single spell for PbR purposes.

                                                         At the present time this rule is enforced when data is updated. Until the next major SUS update in November, on initial load spells are
                                                         constructed on the data dictionary definition which allows for multiple spells to start and end on the same day.

                   13   There seem to be episodes in     This arises where there the information required to create a spell is missing.
                        the episode extract which do
                        not relate to a spell in the     As set out in the document ' A short guide to the PbR Algorithm', the identification of a spell for a patient requires the ability to identify
                        spell extract. What's            person, provider and a spell admission date. A number of fields can be used singly (in the case of NHS number) or in combination to
                        happened?                        provide a proxy patient identifier.


                   14   In the episode extract, the   This has now been resolved for 2006/7 extracts.
                        field entitled Episode HRG
                        calculated doesn't tally with
                        our view of the episode HRG.


                   15   In the episode extract, the      This has now been resolved for 2006/7 extracts.
                        field entitled 'PbR qualified
                        indicator' doesn't tie up with
                        the exclusion reason
                   16   In the spell extract, the        This has now been resolved for 2006/7 extracts.
                        provider and provider site
                        codes seem to be reversed
                   17   There are many null values in This has now been resolved for 2006/7 extracts.
                        the postcode field even
                        though this was present when
                        we submitted our data.


                   18   Is the Market Forces Factor      The tariff calculations are not adjusted for MFF (i.e. set to 1)
                        (MFF) applied in any of the
                        calculations?
                   19   Is it possible to tie back the   In 2006/7 interchange data is included on the tail of each episode, out-patient and A&E record
                        extracts to the interchanges
                        that were submitted?




3/4/2011:8:22 PM                                                                                      6                                                   37108bea-7726-4509-9d4e-21ceed471278.xls:FAQ APC
SUS Payment By Results                                                           Frequently Asked Questions                                      Admitted Patient Care File Extract Specifications




            Frequently Asked Questions v2.2
                   20   The service ID field does not This has been resolved for the Q1 flex and subsequent extracts in 2006/7 . However, due to an issue with service code hierarchy
                        show recognisable values in codes 11 and 30 (which do not give rise to top-up) allocated by the grouper do not have a reference and therefore appear as null in
                        many instances. How can I      the service code column. This issue is being addressed.
                        check that' it's doing what we
                        think it should be?
                   21   The control files issued with This is an identified issue which is being addressed. Information to help in handling these files is available on the CfH website.
                        the extracts are not delimited
                        which makes it fiddly getting
                        the data into my software?
                   22   Some of the dates in the       10000101 is a default value (null) which may appear for example when no valid spell start or end date has been provided. It is also
                        extracts are showing as        returned when the PbR spell is not qualified. In other words, for PbR fields, a valid date is only returned where both the spell qualifies
                        10000101. What does this       under PbR and there are no missing values in date fields on the incoming CDS.
                        mean?
                   23   The suffix orig seems to have In 0607 the orig field consistently refers to incoming data, rather than data which has been checked against reference files
                        different meaning for different
                        fields in the episode extract?

                   24   What is the difference         These are now correct. The calculated one for the spell is the one from the dominant episode. The original is the one supplied by the
                        between the different HRG      sender in the data sent to SUS. The HRG Codes tab is provided on this sheet for reference when examining old extracts.
                        fields in the spell extract
                   25   The site codes are presented This has now been resolved for 2006/7 extracts.
                        in three characters?




3/4/2011:8:22 PM                                                                                   7                                                  37108bea-7726-4509-9d4e-21ceed471278.xls:FAQ APC
OutPatient Frequently Asked Questions v1.0
  Number   Question                                  Response
    1      The size of the file posted to my inbox   The SUS link to N3 is 5Gb and is not the limiting factor. Some users
           was approx 85 Mb and took about 20        are on shared 2Mb connections and may experience slow
           minutes to transfer.                      connections particularly at peak times. Re-trying extracts at different
                                                     times may help.
                                                     Alternative options are being examined.
    2      What is the difference between the data See FAQ APC number 34
           in flex and freeze reports. Will the
           freeze report only contain changed
           data. Does all the data have to be
           updated if some of it is updated? Do I
           have to update all the episodes in a
           spell?

    3      The Ethnic Category field is populated    Ethnic category is not a data element for outpatients and although
           with “##”                                 there is a space in the Edifact message for it, it should not be used
                                                     and is ignored due to this information governance rule. See the CDS
                                                     manual V1.7 available here
                                                     http://www.connectingforhealth.nhs.uk/datastandards/xmlschemas/cd
                                                     smanual section A.4.3.4.1 THE COMMISSIONING DATA SETS -
                                                     OUT-PATIENT ATTENDANCE CDS TYPE

    4      Could you include a field called month    There are many local needs which cannot be met by re-presenting
           which has values 1-12 to help with        data in the extracts without making them unmanageable. In this
           importing data into SLAM.                 example it is suggested that a transformation function is used. For
                                                     example in access the month from discharge date could be
                                                     "IIf(Month([DISCHARGE_DATE])-3=-
                                                     1,10,IIf(Month([DISCHARGE_DATE])-3=-
                                                     2,11,IIf(Month([DISCHARGE_DATE])-3=-
                                                     3,12,Month([DISCHARGE_DATE])-3)))"

    5      Private patients in outpatients are       No, SUS does not exclude these automatically - it includes them for
           funded outside Payment by Results.        indicative purposes. To identify these separately and exclude them
           Does SUS automatically exclude these      from payment, the data need to be grouped by the Administrative
           from tariff?                              Category field (admincat). Those with a value of 2 and 4 should not
                                                     attract payment from an NHS commissioner.
Accident & Emergency Frequently Asked Questions v1.0
 Number   Question                                   Response
    1     The Ethnic Category field is populated     Ethnic category is not a data element for A&E and although there is a
          with “##” or "??"                          space in the Edifact message for it, it should not be used and is
                                                     ignored due to this information governance rule. See the CDS
                                                     manual V1.7 available here
                                                     http://www.connectingforhealth.nhs.uk/datastandards/xmlschemas/cd
                                                     smanual section A.4.3.5 THE COMMISSIONING DATA SETS -
                                                     ACCIDENT AND EMERGENCY ATTENDANCE CDS TYPE

    2     Some fields are truncated                  These fields are truncated at the request of CfH for reporting
          Provider_code                              purposes. Provider and commissioner are explicitly truncated to 3
                                                     characters as reports are generated and costed against the 3
          Commissioner_code_orig                     character data (except for some specialist consortia). The
                                                     remaineder are truncated for ease of reporting. The orginal values
          org_code_sender                            have remained unchanged.

          extract_date_time

          report_period_start_date

          report_period_end_date

    3     The Report Start and End dates show        The report start and end dates are the dates of the interchange that
          Month of April- why is it called „Jun06‟   the episode arrived in. These are present for bulk update records
                                                     and have been included to help you identify where data has come
                                                     from. They do not relate to the date of the extract itself.
    4     I think clear explanations are needed      See FAQ APC number 34
          around what these Flex & Freeze
          reports contain. ie do they contain data
          from all CDS interchanges received with
          BT by the Flex/Freeze dates or is it all
          data received/processed in SUS
          Common Landing(?) by the Flex/Freeze
          dates or is it all data applied in the PbR
          Mart by the Flex/Freeze dates ? And
          are these snapshot reports, which, after
          the flex/freeze should not alter?
SUS Payment By Results                                                            Admitted Patient Care File Extract Specifications

                                                     Frequently Asked Questions
                   HRG fields - detail       NB: Not relevant to extracts from Q1 2006/7 Onwards.


                   Both the HRG submitted by the NHS and that calculated within SUS are maintained at episode and
                   spell level (for the dominant episode). Each case is provided in original form and after testing against
                   reference tables

                   This gives rise to eight HRG fields as set out below. However, as things stand at present the position is
                   complicated by a mapping error which has meant that values reported for SUS calculated fields in the
                   episode data is not as intended.
                   This is being addressed.

                   As intended

                                                  (submitted)           (Calculated)
                                              NHS submitted
                   Episode        (original data)                 SUS calculated HRG**
                                              HRG
                                              NHS submitted                                       * Will contain ??? If HRG is
                                                                  SUS calculated HRG              not in reference table or
                                              HRG after
                                                                  after testing against           HRG version is not
                                              checking against
                                                                  reference table**               specificed
                                              reference table*

                                                                                                  **The calculated HRG for
                                             The above values for the dominant episode.           Orig and non orig should be
                   Spell                                                                          the same; two values are
                                             Will be null if there is no dominant
                                                                                                  maintained for internal
                                                                                                  rasons.




                   Current position

                   The impact of the mapping error is that the values are presently as follows:

                                                 (submitted)            (Calculated)

                                              NHS submitted
                   Episode        (original data)                 not available
                                              HRG

                                             NHS submitted        Spell value - SUS
                                             HRG after            calculated dominant
                                             checking against     HRG after testing
                                             reference table*     against reference table

                   SPELL                          (submitted)           (Calculated)
                                              NHS submitted
                   Spell          (original data)                 SUS calculated HRG
                                              HRG
                                              NHS submitted
                                                                  SUS calculated HRG
                                              HRG after
                                                                  after testing against
                                              checking against
                                                                  reference table
                                              reference table*

                                             As intended: values for the dominant
                   Spell                     episode. Will be null if there is no dominant




3/4/2011:8:22 PM                                                   34              37108bea-7726-4509-9d4e-21ceed471278.xls:HRGCodes
SUS Payment By Results                                               Admitted Patient Care File Extract Specifications

                                         Frequently Asked Questions


                         SUS Service ID Codes - Mapping to National ID codes

                                     Service Id      Service Code
                                 ( Surrogate Key )     ( National
                                                      Service Id )   Description
                                        -1                 #         Not Known
                                         1                 34        Orthopaedics
                                         2                 33        Colorectal
                                         3                 13        Cardiology
                                         4                 6         Spinal
                                         5                 8         Neurosurgery
                                         6                 18        Infectious disease
                                         7                 19        Hepatology
                                         8                 29        Respiratory
                                         9                 1         Cancer
                                        10                 36        Children (U17) Specialised
                                        11                 98        Children Non-Specialised


                                NB: Not relevant to extracts from Q1 2006/7 Onwards.




3/4/2011:8:22 PM                                      35       37108bea-7726-4509-9d4e-21ceed471278.xls:ServiceID_mapping
Admitted Patient Care Spell File Extract Specification v5.0
Group           Seq Fields                      View Column Name             Caption




System            1 SUS_VERSION                                              SUS Version
Spell ID          2 SPELL_ID                    SPELL_ID                     Spell Identifier



                  3 PSEUDONYMISATION_STATUS                                  Pseudonymise
                                                                             d Status




                  4 Reason access provided                                   Reason access
                                                                             provided



Patient           5 LOCAL_PATIENT_ID            LOCAL_PATIENT_ID             Local Patient
Identifiers                                     (LPI_PSEUD is used for SHA   Identifier
                                                extracts)




                  6 ORG_CODE_LOCAL_PATIENT_ID   org_code_local_patient_id    Org Code Local
                                                                             Patient
                                                                             Identifier
                  7 NHS_Number                  NHS_NUMBER                   NHS Number
                                                (NHS_NUMBER_PSEUD is
                                                used for SHA extracts)




Birth and age     8 BIRTH_DATE                  to_char(BIRTH_DATE,          Birth Date
                                                'YYYYMMDD')
                                                (BIRTH_DATE_PSEUD is
                                                used for SHA extract)




                  9 AGE_ON_ADMISSION            age_on_admission             Age At Start of
                                                                             Spell
                 10 AGE_ON_DISCHARGE            age_on_discharge             Age At End of
                                                                             Spell
Other person     11 CARER_SUPPORT_INDICATOR     carer_support_indicator      Carer Support
data                                                                         Indicator
                 12 LEGAL_STATUS_CODE           legal_status_code            Legal Status
                                                                             Classification
                                                                             Code
                 13 ETHNIC_CATEGORY             ethnic_category              Ethnic
                                                                             Category Code
                 14 MARITAL_STATUS              marital_status               Marital Status
                   15 NHS_Number_STATUS             nhs_number_status             NHS Number
                                                                                  Status Indicator

                   16 SEX                           sex                           Gender Code
                   17 POSTCODE_USUAL_ADDRESS        POSTCODE                Postcode of
                                                    (POSTCODE_PSEUD is used Usual Address
                                                    for SHA extracts)




                   18 POSTCODE_SECTOR_USUAL ADDR    postcode_sector_usual_addr    Postcode
                                                                                  Sector of Usual
                                                                                  Address
                   19 PCT_OF_RESIDENCE              pct_of_residence              Organisation
                                                                                  Code (PCT of
                   20 PATIENT_POSTCODE_PCT_TYPE_D   patient_postcode_pct_type_d   Patient
                                                                                  Postcode
                                                                                  Derived PCT
                                                                                  Type
                   21 PATIENT_POSTCODE_PCT_D        patient_postcode_pct_d        Patient
                                                                                  Postcode
                                                                                  Derived PCT
Spell, Admission   22 HOSPITAL_SPELL_NO             HOSPITAL_SPELL_NO       Hospital
                                                    (HOSPITAL_PROV_SPELL_N Provider Spell
                                                    O_PSEUD is used for SHA No
                                                    extracts)




& discharge        23 ADMINISTRATIVE_CATEGORY       administrative_category_fe    Administrative
                                                                                  Category
                   24 PATIENT_CLASSIFICATION        patient_classification        Patient
                                                                                  Classification
                   25 ADMISSION_METHOD              admission_method              Admission
                                                                                  Method
                                                                                  (Hospital
                                                                                  Provider Spell)
                   26 ADMISSION_TYPE_D              admission_type_d              Admission
                                                                                  Type (Derived)



                   27 ADMISSION_SUBTYPE_D           admission_subtype_d           Admission
                                                                                  Subtype
                                                                                  (Derived)


                   28 DISCHARGE_DESTINATION         discharge_destination         Discharge
                                                                                  Destination
                                                                                  (Hospital
                                                                                  Provider Spell)
                   29 DISCHARGE_METHOD              discharge_method              Discharge
                                                                                  Method
                                                                                  (Hospital
                                                                                  Provider Spell)
                   30 ADMISSION_SOURCE              admission_source              Source of
                                                                                  Admission
                                                                                  (Hospital
                                                                                  Provider Spell)
                   31 ADMISSION_DATE                admission_date                Start Date
                                                                                  (Hospital
                                                                                  Provider Spell)
               32 DISCHARGE_DATE                     discharge_date                 End Date
                                                                                    (Hospital
                                                                                    Provider Spell)
Contract       33 COMMISSIONER_SERIAL_NO             commissioner_serial_no         Commissioning
                                                                                    Serial No
                                                                                    (Agreement
                                                                                    No)
identifiers    34 AGREEMENT_LINE_NO                  agreement_line_no              NHS Service
                                                                                    Agreement
                                                                                    Line No
               35 PROVIDER_REFERENCE_NO              provider_reference_no          Provider
                                                                                    Reference No
               36 COMMISSIONER_REFERENCE_NO          commissioner_reference_no      Commissioner
                                                                                    Reference No
Provider &     37 PROVIDER_CODE                      provider_code                  Organisation
                                                                                    Code (Code of
                                                                                    Provider)
Commissioner   38 PROVIDER_CODE_ORIG                 provider_code_orig             Provider Code
                                                                                    (Original Data)

               39 PROVIDER_SITE_CODE                 PROVIDER_SITE_CODE             Provider Site
                                                                                    Code
               40 COMMISSIONER_CODE                  commissioner_code              Organisation
                                                                                    Code (Code of
                                                                                    Commissioner)
               41 COMMISSIONER_CODE_ORIG             commissioner_code_orig         Commissioner
                                                                                    Code (Original
                                                                                    Data)



               42 GP_PCT_D                           gp_pct_d                       PCT Derived
                                                                                    from GP




               43 GP_PRACTICE_PCT_D                  gp_practice_pct_d              PCT Derived
                                                                                    from GP
                                                                                    Practice



               44 COMMISSIONER_SITE_CODE             COMMISSIONER_SITE_COD Commissioner
                                                     E                          Site Code
               45 COMMISSIONER TYPE                  org_code_type_commissioner Commissioner
                                                                                Type
specialty      46 MAIN_SPECIALTY_CODE                main_specialty_code            Main Specialty
                                                                                    Code



               47 MAIN_SPECIALTY_CODE_ORIG           specialty_function_code_orig   Main Specialty
                                                                                    Code (Original
                                                                                    Data)
Treatment      48 TREATMENT_FUNCTION_CODE            treatment_function_code        Treatment
function                                                                            Function Code



               49 TREATMENT_FUNCTION_CODE_ORIG treatment_function_code_orig Treatment
                                                                            Function Code
                                                                            (Original Data)
               50 READY_FOR_DISCHARGE_DATE           ready_for_discharge_date       PbR Date
                                                                                    Ready for
                                                                                    Discharge
                 51 DELAY_DISCHARGE_REASON      delay_discharge_reason      PbR Reason
                                                                            for Delayed
                                                                            Discharge
GP & referrer    52 REGISTERED_GMP_CODE         registered_gmp_code         Registered
                                                                            GMP Code
                 53 GP_CODE_ORIG                gp_code_orig                GP Code
                                                                            (Original data)


                 54 GP_PRACTICE_CODE            gp_practice_code            GP Practice
                                                                            Code
                 55 GP_PRACTICE_CODE_ORIG       gp_practice_code_orig       GP Practice
                                                                            Code (Original
                                                                            Data)
                 56 GP_PRACTICE_D,              gp_practice_d               GP Practice
                                                                            Code (Derived)




                 57 ORG_CODE_TYPE_GP_PRACTICE   org_code_type_gp_practice   Org Code Type
                                                                            GP Practice
                 58 REFERRER_CODE               referrer_code               Referrer Code
                 59 ORG_CODE_REFERRER           org_code_referrer           Org Code
                                                                            Referrer
Wait & stay      60 ELECTIVE_WAIT_DURATION      elective_wait_duration      Duration of
                                                                            Elective Wait
                 61 INTENDED_MANAGEMENT         intended_management         Intended
                                                                            Management
                 62 DECISION_TO_ADMIT_DATE      decision_to_admit_date      Decided to
                                                                            Admit Date
                 63 HPS LOS                     length_of_stay              Length of Stay
                                                                            (Hospital
                                                                            Provider Spell)
PbR dates and    64 PBR_SPELL_START_DATE        pbr_spell_start_date        Start Date (PbR
days                                                                        Spell)
                 65 PBR_SPELL_END_DATE          pbr_spell_end_date          End Date (PbR
                                                                            Spell)
                 66 LENGTH_OF_STAY (PbR)        adj_length_of_stay          Length of Stay
                                                                            (PbR Spell)
                 67 EXCLUDED_CC_DAYS            excluded_cc_days            Excluded
                                                                            Critical Care
                                                                            Days (Hospital
                                                                            Provider Spell)
                 68 INCLUDED_CC_DAYS            included_cc_days            Included
                                                                            Critical Care
                                                                            Days (PbR
                                                                            Spell)
In spell PbR     69 NO_COMMISSIONERS            no_commissioners            Number of
                                                                            Commissioners
                                                                            in PbR Spell
counts           70 NO_EXCLUDED_EPISODES        no_excluded_episodes        Excluded
                                                                            Episodes in
                                                                            Hospital
                                                                            Provider Spell
Trimpoint        71 SPELL_TRIMPOINT_DAYS        spell_trimpoint_days        PbR Spell
                                                                            Trimpoint
(from Dominant   72 ADJ_LENGTH_OF_STAY          ( adj_length_of_stay -      PbR Adjusted
                                                delayed_discharge_days )    Length of Stay
episode)         73 DAYS_BEYOND_TRIMPOINT       days_beyond_trimpoint       PbR Days
                                                                            Beyond
                                                                            Trimpoint
Payment             74 APPLIED_MFF (%)                       applied_mff                 PbR Applied
breakdown                                                                                Market Forces
                                                                                         Factor
                    75 TARIFF_INITIAL_AMOUNT                 tariff_initial_amount       PbR Initial
                                                                                         Applicable
                                                                                         Tariff
                    76 TARIFF_SS_ADJUSTMENT                  tariff_ss_adjustment        PbR Short Stay
                                                                                         Adjustment
                    77 TARIFF_SERV_ADJUSTMENT                tariff_serv_adjustment      PbR Services
                                                                                         Adjustment
                    78 TARIFF_FINAL_AMOUNT                   tariff_final_amount         PbR Final
                                                                                         Applicable
                                                                                         Tariff
                    79 TARIFF_LS_RATE                        tariff_ls_rate              PbR Spell Long
                                                                                         Stay Per Diem
                                                                                         Rate
                    80 TARIFF_LS_PAYMENT                     tariff_ls_payment           PbR Spell Long
                                                                                         Stay Payment

                    81 TARIFF_TOTAL_PAYMENT                  tariff_total_payment        PbR Total
                                                                                         Payment for
                                                                                         Spell
Future use (06-     82 CCMDS payment (Excluded from TOTAL) critical_care_payment         CCMDS
B)                                                                                       payment
                                                                                         (Excluded from
                                                                                         TOTAL)
Extended open       83 EXTENDED_OPEN_SPELL_IND              extended_open_spell_ind      PbR Extended
                                                                                         Spell Flag
spell               84 EXTENDED_OPEN_DATE                   extended_open_date           PbR Last
                                                                                         Extended Spell
                                                                                         Check Date
                    85 Extended open spell length increment ext_openspell_length_increme Extended open
                                                            nt                           spell length
                                                                                         increment
                    86 PREV_EXTEND_SPELL_ID                 prev_extend_spell_id         Previous
                                                                                         Extended Spell
Freeze & spell      87 EFFECTIVE_DATE                       effective_date               Record ID
                                                                                         Spell Version
status                                                                                   As At Date
                    88 Extract type                                                      Extract type

                    89 SPELL_STATUS_IND                      spell_status_ind            PbR Spell
                                                                                         Status Indicator

                    90 SPELL_FROZEN_IND                      spell_frozen_ind            PbR Spell
                                                                                         Frozen
                                                                                         Indicator
Spell               91 PBR_QUALIFIED_INDICATOR               pbr_qualified_indicator     PbR Spell in
Qualification for                                                                        PbR Scheme
payment;                                                                                 Flag
costing             92 COSTED_INDICATOR                      costed_indicator            PbR Costed
                                                                                         Indicator
                    93 APPLICABLE_COSTING_PERIOD             applicable_costing_period   Applicable
                                                                                         Costing Period
                    94 DOMINANT HRG_CALCULATED               hrg_calculated              Dominant HRG
                                                                                         (Calculated)

                    95 HRG_VERSION_CALCULATED                hrg_version_calculated      Dominant HRG
                                                                                         Version
                                                                                         (Calculated)
Service ID          96 PbR SPELL SERVICE_ID                  service_id                  PBR Spell
                                                                                         Service ID
                    97 PbR SPELL SERVICE_ID_Version                                      PBR Spell
                                                                                         Service ID
                                                                                         Version
Spell             98 SPELL_ERROR_STATUS                  spell_error_status           Spell Error
construction                                                                          Status


                  99 SPELL Construction ALGORITHM slab   spell_const_algorithm_slab   SPELL
                                                                                      Construction
                                                                                      Algorithm slab
14 day            100 READMISSION_IND                    readmission_ind              PbR 7 Day
readmission                                                                           Readmission
                                                                                      Indicator

indicator         101 NO_SPELLS_PRIOR_READMIN            no_spells_prior_readmin      PbR
                                                                                      Readmission -
                                                                                      no of prior
                                                                                      spells
                  102 NO_SPELLS_FOLL_READMIN             no_spells_foll_readmin       PbR
                                                                                      Readmission -
                                                                                      no of following
                                                                                      spells
                  103 SPELL_ID_FIRST_READMIN             spell_id_first_readmin       First Spell
                                                                                      Identifier
                                                                                      (Readmission)
Future use (06-   104 CCMDS1_UY1_PERIODS                 Ccmds1_uy1_periods           Number of
B) CCMDS                                                                              CCMDS
derivations                                                                           Periods for
                                                                                      HRG CCMDS1
                                                                                      UY1
                  105 CCMDS2_YA1_PERIODS                 ccmds2_ya1_periods           Number of
                                                                                      CCMDS
                                                                                      Periods for
                                                                                      HRG CCMDS2
                                                                                      YA1
                  106 CCMDS2_YA2_PERIODS                 ccmds2_ya2_periods           Number of
                                                                                      CCMDS
                                                                                      Periods for
                                                                                      HRG CCMDS2
                                                                                      YA2
                  107 CCMDS2_YA3_PERIODS                 ccmds2_ya3_periods           Number of
                                                                                      CCMDS
                                                                                      Periods for
                                                                                      HRG CCMDS2
                                                                                      YA3
                  108 CCMDS2_YA4_PERIODS                 ccmds2_ya4_periods           Number of
                                                                                      CCMDS
                                                                                      Periods for
                                                                                      HRG CCMDS2
                                                                                      YA4
                  109 CCMDS2_YA5_PERIODS                 ccmds2_ya5_periods           Number of
                                                                                      CCMDS
                                                                                      Periods for
                                                                                      HRG CCMDS2
                                                                                      YA5
                  110 CCMDS2_YA6_PERIODS                 ccmds2_ya6_periods           Number of
                                                                                      CCMDS
                                                                                      Periods for
                                                                                      HRG CCMDS2
                                                                                      YA6
                  111 CCMDS2_YA7_PERIODS                 ccmds2_ya7_periods           Number of
                                                                                      CCMDS
                                                                                      Periods for
                                                                                      HRG CCMDS2
                                                                                      YA7
                  112 CCMDS1_UY1_DAYS                    ccmds1_uy1_days              Number of
                                                                                      CCMDS Days
                                                                                      for HRG
                                                                                      CCMDS1 UY1
                    113 CCMDS2_YA1_DAYS   ccmds2_ya1_days   Number of
                                                            CCMDS Days
                                                            for HRG
                                                            CCMDS2 YA1
                    114 CCMDS2_YA2_DAYS   ccmds2_ya2_days   Number of
                                                            CCMDS Days
                                                            for HRG
                                                            CCMDS2 YA2
                    115 CCMDS2_YA3_DAYS   ccmds2_ya3_days   Number of
                                                            CCMDS Days
                                                            for HRG
                                                            CCMDS2 YA3
                    116 CCMDS2_YA4_DAYS   ccmds2_ya4_days   Number of
                                                            CCMDS Days
                                                            for HRG
                                                            CCMDS2 YA4
                    117 CCMDS2_YA5_DAYS   ccmds2_ya5_days   Number of
                                                            CCMDS Days
                                                            for HRG
                                                            CCMDS2 YA5
                    118 CCMDS2_YA6_DAYS   ccmds2_ya6_days   Number of
                                                            CCMDS Days
                                                            for HRG
                                                            CCMDS2 YA6
                    119 CCMDS2_YA7_DAYS   ccmds2_ya7_days   Number of
                                                            CCMDS Days
                                                            for HRG
                                                            CCMDS2 YA7
                    120 CCMDS1_UY1_UKP    ccmds1_uy1_ukp    CCMDS
                                                            Payment for
                                                            HRG CCMDS1
                                                            UY1
                    121 CCMDS2_YA1_UKP    ccmds2_ya1_ukp    CCMDS
                                                            Payment for
                                                            HRG CCMDS2
                                                            YA1
                    122 CCMDS2_YA2_UKP    ccmds2_ya2_ukp    CCMDS
                                                            Payment for
                                                            HRG CCMDS2
                                                            YA2
                    123 CCMDS2_YA3_UKP    ccmds2_ya3_ukp    CCMDS
                                                            Payment for
                                                            HRG CCMDS2
                                                            YA3
                    124 CCMDS2_YA4_UKP    ccmds2_ya4_ukp    CCMDS
                                                            Payment for
                                                            HRG CCMDS2
                                                            YA4
                    125 CCMDS2_YA5_UKP    ccmds2_ya5_ukp    CCMDS
                                                            Payment for
                                                            HRG CCMDS2
                                                            YA5
                    126 CCMDS2_YA6_UKP    ccmds2_ya6_ukp    CCMDS
                                                            Payment for
                                                            HRG CCMDS2
                                                            YA6
                    127 CCMDS2_YA7_UKP    ccmds2_ya7_ukp    CCMDS
                                                            Payment for
                                                            HRG CCMDS2
                                                            YA7
Query Identifiers   128 Query date                          Query Date



                    129 Query UID                           Unique Query
                                                            Id
Key for       D     Dominant episode
derivations
              A     (For spell admission date)
                    algorithm implies that this cannot vary
                    across any episode in spell - Any source
                    is therefore acceptable, except that the
                    field must be populated whether or not the
                    spell qualifies for PbR
              L     Last episode in spell
              n/a   Not applicable (null)
              SUS SUS derived value
                                                                  Index
5.0
      Notes                  Required Derivation
                             Source
                             (key below)
                             Qualifying Non-       Format
                             Spell      Qualifying
                                        Spell
      System field           SUS        SUS        Char(255)
      Unique Spell ID        SUS        SUS        Number
      following SUS Spell
      creation
      To allow records       SUS        SUS        Number
      containing
      pseudonymised data
      to be distinguished. -
      need to agree values


      As provider,                                 Char(20)
      commissioner,
      responsible PCT (not
      commissioner) etc
      As NHS data            L          L          CHAR(10)
      dictionary -
      pseudonymised in
      DH/IC and SHA
      extract in managed
      service reports.
      Otherwise as
                                                   (Number if
      required by RBAC
                                                   _PSEUD form)
                             L          L          Char(12)


      As NHS data            L          L          CHAR(10)
      dictionary -
      pseudonymised in
      DH/IC and SHA
      extract in managed
      service reports.
      Otherwise as
                                                   (Number if
      required by RBAC
                                                   _PSEUD form)
      As NHS data            L          L          CHAR(8)
      dictionary -
      pseudonymised in
      DH/IC and SHA
      extract in managed
      service reports.
      Otherwise as
      required by RBAC                             (Number if
                                                   _PSEUD form)
                             L          L          Char(4)

                             L          L          Char(4)
      As NHS data            L          L          Char(2)
      dictionary
                             L          L          Char(2)


                             L          L          Char(2)

                             L          L          Char(1)
                     L   L   Char(2)


                     L   L   Char(1)
As NHS data          L   L   CHAR(35)
dictionary -
pseudonymised in
DH/IC and SHA
extract in managed
service reports.
Otherwise as
                             (Number if
required by RBAC
                             _PSEUD
                     L   L   used)
                             Char(9)


                     L   L   Char(12)
Derived Resident     D   L   Char(1)
PCT and type - see
NWCS301 - NDS

Data Derivation      D   L   Char(12)
Service Component
Design
As NHS data          L   L   CHAR(17)
dictionary -
pseudonymised in
DH/IC and SHA
extract in managed
service reports.             (Number if
Otherwise as                 _PSEUD is
required by RBAC             used)
                     L   L   Char(2)

                     L   L   Char(1)
                     L   L   Char(2)




Derived admission    L   L   Char(1)
type for PbR
(elective / non
elective)
Derived admission            Char(1)
type for PbR
(emergency / non-
emergency)
                     L   L   Char(2)




                     L   L   Char(1)




                     L   L   Char(2)




                     L   L   Char(8)
                             YYYYMMDD
                       L   L      Char(8)
                                  YYYYMMDD

As NHS data            D   Null   Char(6)
dictionary


                       D   Null   Char(10)


                       D   Null   Char(17)

                       D   Null   Char(17)

Org level provider A       A      Char(12)
code - as NHS data
dictionary
Value before testing   A   A      Char(12)
against reference
files
Provider site code                Char(12)

Org level              D   L      Char(12)
commissioner code

Org level              D   L      Char(12)
Commissioner code
before testing
against reference
files
Derived PCT for GP - D     L      Char(12)
see NWCS301 -
NDS Data Derivation
Service Component
Design
Derived PCT for GP - D     L      Char(12)
see NWCS301 -
NDS Data Derivation
Service Component
Design
                       D   L      Char(12)

                       D   L      Char(30)

As NHS data            D   L      Char(3)
dictionary - after
testing against
reference files
As NHS data            D   L      Char(3)
dictionary - as
submitted
As NHS data            D   L      Char(3)
dictionary - after
testing against
dimension files
As NHS data            D   L      Char(3)
dictionary - as
submitted
Will return data       L   L      Char(8)
relating to delay                 YYYYMMDD
discharge
when available         L     L     Char(4000)


As NHS data            L     L     Char(8)
dictionary
Value before testing   L     L     Char(12)
against reference
files
As NHS data            L     L     Char(12)
dictionary
Value before testing   L     L     Char(12)
against reference
files
Derived Practice for L       L     Char(12)
GP - see NWCS301
- NDS Data
Derivation Service
Component Design
                       L     L     Char(30)

                       L     L     Char(12)
                       L     L     Char(12)

As NHS data            L     L     Char(5)
dictionary
                       L     L     Char(1)

                       L     L     Char(8)
                                   YYYYMMDD
Hospital Provider      L     L     Number
Spell LOS

Start of first non-    SUS   n/a   Char(8)
excluded episode                   YYYYMMDD
End of last non-       SUS   n/a   Char(8)
excluded episode                   YYYYMMDD
Total non-excluded     SUS   n/a   Number
days in HPS
Critical care days     SUS   n/a   Number
within PbR spell


Critical care days     SUS   n/a   Number
outside PbR spell


N of distinct          SUS   n/a   Number
commissioners of
PbR Spells
N of excluded          SUS   n/a   Number
episodes in spell


Trimpoint of spell     SUS   n/a   Number
HRG
                       SUS   n/a   Number

Spell PbR days         SUS   n/a   Number
beyond spell
trimpoint
Applied Market        SUS    n/a   Number
forces factor

Tariff for dominant SUS      n/a   Number
episode HRG before
adjustment
Short stay            SUS    n/a   Number
adjustment
Specialised service   SUS    n/a   Number
adjustment
Tariff after          SUS    n/a   Number
adjustment

Long stay (Beyond     SUS    n/a   Number
trimpoint) rate

Long stay (beyond     SUS    n/a   Number
trimpoint) payment

Total payment for     SUS    n/a   Number
spell

                      SUS    n/a   Number




to support analysis  SUS     n/a   Number
of spells which have
been open for an     SUS           Char(8)
extended period at                 YYYYMMDD
year end
                     SUS           Number


                      SUS          Number

Date spell updated    SUS    SUS   Char(8)
                                   YYYYMMDD
Place Holder (Not     SUS    SUS   Char
Populated)
Spell status          SUS    SUS   Number


Indicates whether     SUS    SUS   Number
spell frozen

Indicates whether     SUS    SUS   Number
spell qualifies for
PbR & is tariffed
                      SUS    SUS   Number

                      SUS    SUS   Char(50)

The HRG version       SUS    SUS   Char(3)
calculated by SUS

The version of HRG    SUS    SUS   Char(3)
calculated by SUS

Service ID for service SUS   n/a   Number
top-up
                                   Char(0)
As set out in       SUS   SUS   Number
sheet
SpellErrorCode
                    SUS   SUS   Number



See           SUS         SUS   Number
EmergencyRead
mission
for detail          SUS   SUS   Number




                    SUS   SUS   Number




                    SUS   SUS   Number


Number of CCMDS     SUS   SUS   NUMBER(3)
periods for given
CCMDS HRG


                    SUS   SUS   NUMBER(3)




                    SUS   SUS   NUMBER(3)




                    SUS   SUS   NUMBER(3)




                    SUS   SUS   NUMBER(3)




                    SUS   SUS   NUMBER(3)




                    SUS   SUS   NUMBER(3)




                    SUS   SUS   NUMBER(3)




Number of CCMDS     SUS   SUS   NUMBER(5)
days for given
CCMDS HRG
Number of CCMDS
days for given
CCMDS HRG

                  SUS   SUS   NUMBER(5)




                  SUS   SUS   NUMBER(5)




                  SUS   SUS   NUMBER(5)




                  SUS   SUS   NUMBER(5)




                  SUS   SUS   NUMBER(5)




                  SUS   SUS   NUMBER(5)




                  SUS   SUS   NUMBER(5)




Payments by       SUS   SUS   Number
CCMDS HRG


                  SUS   SUS   Number




                  SUS   SUS   Number




                  SUS   SUS   Number




                  SUS   SUS   Number




                  SUS   SUS   Number




                  SUS   SUS   Number




                  SUS   SUS   Number




                  SUS   SUS   Char(16)
                              YYYYMMDDH
                              HMMSS
                  SUS   SUS   Char(50)
Admitted Patient Care Episode File Extract Specification v5.0
Group           Seq    Fields                     View Column Name

                      1 SUS_VERSION
Record ID             2 NHS_DEFINED_RID           NHS_DEFINED_RID




Spell ID              3 SPELL_ID                  SPELL_ID




Generated             4 GENERATED_RECORD_ID,      ede_id
Record ID
Record Type           5 CDS_RECORDS_TYPE          cds_records_type




                      6 Reason access provided




                      7 SPELL IN PBR/Not In PBR   pbr_qualified_indicator




Future use            8 PSEUDONYMISATION_STATUS




Patient               9 LOCAL_PATIENT_ID          LOCAL_PATIENT_ID (LPI_PSEUD is used for
Identifiers                                       SHA extracts)




                  10 ORG_CODE_LOCAL_PATIENT_ID    ORG_CODE_LOCAL_PATIENT_ID

                  11 NHS_Number                   NHS_NUMBER (NHS_NUMBER_PSEUD is
                                                  used for SHA extracts)




Birth and age     12 BIRTH_DATE                   to_char(BIRTH_DATE, 'YYYYMMDD')
                                                  (BIRTH_DATE_PSEUD is used for SHA extract)




                  13 AGE_EPISODE_START            age_episode_start

                  14 AGE_EPISODE_END              age_episode_end
Other person   15 CARER_SUPPORT_INDICATOR        carer_support_indicator
data
               16 LEGAL_STATUS_CLASSIFICATION    legal_status_code

               17 ETHNIC_CATEGORY                ethnic_category
               18 MARITAL_STATUS                 marital_status
               19 NHS_Number_STATUS              nhs_number_status

               20 SEX                            sex
               21 TOTAL_PREVIOUS_PREGNANCIES     total_previous_pregnancies

               22 POSTCODE_USUAL_ADDRESS         POSTCODE (POSTCODE_PSEUD is used for
                                                 SHA extracts)




               23 POSTCODE_SECTOR_USUAL ADDR     postcode_sector_usual_addr

               24 PCT_OF_RESIDENCE               PCT_OF_RESIDENCE

               25 PATIENT_POSTCODE_PCT_TYPE_D,   PATIENT_POSTCODE_PCT_TYPE_D

               26 PATIENT_POSTCODE_PCT_D,        PATIENT_POSTCODE_PCT_D




Spell,         27 HOSPITAL_SPELL_NO              HOSPITAL_SPELL_NO
Admission                                        (HOSPITAL_PROV_SPELL_NO_PSEUD is
                                                 used for SHA extracts)



& discharge    28 ADMINISTRATIVE_CATEGORY        administrative_category

               29 PATIENT_CLASSIFICATION         patient_classification
               30 ADMISSION_METHOD               admission_method



               31 ADMISSION_METHOD_ORIG          admission_method_orig

               32 ADMISSION_TYPE_D               ADMISSION_TYPE_D



               33 DISCHARGE_DESTINATION          discharge_destination



               34 DISCHARGE_METHOD               discharge_method



               35 ADMISSION_SOURCE               admission_source
                   36 ADMISSION_DATE                  admission_date

                   37 DISCHARGE_DATE                  dtd_hps_spell_end_date

Episode in         38 EPISODE_Number                  episode_number
spell
no / flags         39 FIRST_REG_DAY_NIGHT_ADMISSION   first_reg_day_night_admission

                   40 LAST_EPISODE_IN_SPELL_IND       last_episode_in_spell_ind

Additional spell   41 NEONATAL_LEVEL_OF_CARE          neonatal_level_of_care
data
                   42 OPERATION_STATUS                operation_status
                   43 PSYCHIATRIC_PATIENT_STATUS      psychiatric_patient_status

                   44 NO_AUGMENTED_CARE_PERIODS       no_augmented_care_periods

Episode dates      45 EPISODE_START_DATE              episode_start_date

                   46 EPISODE_END_DATE                episode_end_date

Contract           47 COMMISSIONER_SERIAL_NO          commissioner_serial_no

identifiers        48 AGREEMENT_LINE_NO               agreement_line_no

                   49 PROVIDER_REFERENCE_NO           provider_reference_no

                   50 COMMISSIONER_REFERENCE_NO       commissioner_reference_no

Provider &         51 PROVIDER_CODE                   PROVIDER_CODE

Commissioner       52 PROVIDER_SITE_CODE              PROVIDER_SITE_CODE
                   53 COMMISSIONER_CODE               COMMISSIONER_CODE



                   54 COMMISSIONER_CODE_ORIG          commissioner_code_orig




                   55 GP_PCT_D                        GP_PCT_D
               56 GP_PRACTICE_PCT_D          gp_practice_pct_d




               57 COMMISSIONER_SITE_CODE     COMMISSIONER_SITE_CODE

               58 Spell Commissioner code    Spell_commissioner_code




               59 SITE CODE (OF TREATMENT)   soe_site_code_of_treatment
                  (at start of episode)
Consultant &   60 CONSULTANT_CODE            consultant_code
specialty      61 MAIN_SPECIALTY_CODE        main_specialty_code
               62 TREATMENT_FUNCTION_CODE    treatment_function_code

GMP &          63 REGISTERED_GMP_CODE        REGISTERED_GMP_CODE
referrer       64 GP_CODE                    gp_code_orig
               65 GP_PRACTICE_CODE           gp_practice_code
               66 GP_PRACTICE_CODE_ORIG      gp_practice_code




               67 GP_PRACTICE_D              gp_practice_d




               68 REFERRER_CODE              referrer_code
               69 REFERRING_ORG_CODE         referring_org_code

Wait & stay    70 ELECTIVE_WAIT_DURATION     elective_wait_duration

               71 INTENDED_MANAGEMENT        intended_management
               72 DECISION_TO_ADMIT_DATE     decision_to_admit_date

               73 (episode) LENGTH_OF_STAY   episode_end_date - episode_start_date

               74 EFFECTIVE_DATE             EFFECTIVE_DATE
                75 APPLICABLE_COSTING_PERIOD   APPLICABLE_COSTING_PERIOD

Episode level   76 HRG_SUBMITTED               HRG_SUBMITTED



                77 HRG_VERSION_SUBMITTED       HRG_VERSION_SUBMITTED




                78 HRG_CALCULATED              HRG_CALCULATED




                79 HRG_VERSION_CALCULATED      HRG_VERSION_CALCULATED




                80 HRG_DIFFERS_IND             0 - if hrg_submitted and hrg_calculated code
                                               values are same, else 1




                81 Programme Budget Code




PbR Episode     82 SERVICE_ID                  SERVICE_ID
level data




                83 SERVICE_ID_VERSION          pbr_spell_service_id_version
                84 SIGNIFICANT_SID_IND         1 -- if dominat episode's service id , else 0




                85 DOMINANT_EPISODE_IND        dominant_episode_ind --1 if dominant episode --
                                               0 else




                86 PBR_EXCLUDED_INDICATOR      excluded_episode_ind
             87 EXCLUSION_REASON               exclusion_reason

Diagnoses    88 DIAGNOSIS_SCHEME_IN_USE        diagnosis_scheme_in_use
block
             89 PRIMARY_DIAGNOSIS _CODE        primary_diagnosis_code

             90 SECONDARY_DIAGNOSIS_CODE_1     secondary_diagnosis_code_1

             91 SECONDARY_DIAGNOSIS_CODE_2     secondary_diagnosis_code_2

             92 SECONDARY_DIAGNOSIS_CODE_3     secondary_diagnosis_code_3

             93 SECONDARY_DIAGNOSIS_CODE_4     secondary_diagnosis_code_4

             94 SECONDARY_DIAGNOSIS_CODE_5     secondary_diagnosis_code_5

             95 SECONDARY_DIAGNOSIS_CODE_6     secondary_diagnosis_code_6

             96 SECONDARY_DIAGNOSIS_CODE_7     secondary_diagnosis_code_7

             97 SECONDARY_DIAGNOSIS_CODE_8     secondary_diagnosis_code_8

             98 SECONDARY_DIAGNOSIS_CODE_9     secondary_diagnosis_code_9

             99 SECONDARY_DIAGNOSIS_CODE_10    secondary_diagnosis_code_10

             100 SECONDARY_DIAGNOSIS_CODE_11   secondary_diagnosis_code_11

             101 SECONDARY_DIAGNOSIS_CODE_12   secondary_diagnosis_code_12

Procedures   102 PROCEDURE_SCHEME_IN_USE       procedure_scheme_in_use,
block
             103 PRIMARY_PROCEDURE_CODE        primary_procedure_code

             104 PRIMARY_PROCEDURE_DATE        primary_procedure_date

             105 PROCEDURE_CODE_2              procedure_code_2
             106 PROCEDURE_DATE_2              procedure_date_2

             107 PROCEDURE_CODE_3              procedure_code_3
             108 PROCEDURE_DATE_3              procedure_date_3

             109 PROCEDURE_CODE_4              procedure_code_4
             110 PROCEDURE_DATE_4              procedure_date_4

             111 PROCEDURE_CODE_5              procedure_code_5
             112 PROCEDURE_DATE_5              procedure_date_5

             113 PROCEDURE_CODE_6              procedure_code_6
             114 PROCEDURE_DATE_6              procedure_date_6

             115 PROCEDURE_CODE_7              procedure_code_7
             116 PROCEDURE_DATE_7              procedure_date_7
            117 PROCEDURE_CODE_8                procedure_code_8
            118 PROCEDURE_DATE_8                procedure_date_8

            119 PROCEDURE_CODE_9                procedure_code_9
            120 PROCEDURE_DATE_9                procedure_date_9

            121 PROCEDURE_CODE_10               procedure_code_10
            122 PROCEDURE_DATE_10               procedure_date_10

            123 PROCEDURE_CODE_11               procedure_code_11
            124 PROCEDURE_DATE_11               procedure_date_11

            125 PROCEDURE_CODE_12               procedure_code_12
            126 PROCEDURE_DATE_12               procedure_date_12

Augmented   127 ACP_Number_1                    acp_number_1
care



            128 ACP_START_DATE_1                acp_start_date_1

            129 ACP_SOURCE_1                    acp_source_1
            130 ACP_INTENSIVE_CARE_DAYS_1       acp_intensive_care_days_1

            131 ACP_HIGH_DEPENDENCY_DAYS_1      acp_high_dependency_days_1

            132 ACP_ORGAN_SYSTEMS_SUPPORTED_1acp_organ_systems_supported_1

            133 ACP_PLANNED_INDICATOR_1         acp_planned_indicator_1

            134 ACP_OUTCOME_INDICATOR_1         acp_outcome_indicator_1

            135 ACP_DISPOSAL_1                  acp_disposal_1
            136 ACP_END_DATE_1                  acp_end_date_1

            137 ACP_MAIN_SPECIALTY_CODE_1       acp_main_specialty_code_1

            138 ACP_LOCATION_CLASS_1            acp_location_class_1
            139 ACP_LOCATION_1                  acp_location_1
            140 ACP_Number_2                    acp_number_2
            141 ACP_START_DATE_2                acp_start_date_2

            142 ACP_SOURCE_2                    acp_source_2
            143 ACP_INTENSIVE_CARE_DAYS_2       acp_intensive_care_days_2

            144 ACP_HIGH_DEPENDENCY_DAYS_2      acp_high_dependency_days_2

            145 ACP_ORGAN_SYSTEMS_SUPPORTED_2acp_organ_systems_supported_2

            146 ACP_PLANNED_INDICATOR_2         acp_planned_indicator_2
147 ACP_OUTCOME_INDICATOR_2         acp_outcome_indicator_2

148 ACP_DISPOSAL_2                  acp_disposal_2
149 ACP_END_DATE_2                  acp_end_date_2

150 ACP_MAIN_SPECIALTY_CODE_2       acp_main_specialty_code_2

151 ACP_LOCATION_CLASS_2            acp_location_class_2
152 ACP_LOCATION_2                  acp_location_2
153 ACP_Number_3                    acp_number_3
154 ACP_START_DATE_3                acp_start_date_3

155 ACP_SOURCE_3                    acp_source_3
156 ACP_INTENSIVE_CARE_DAYS_3       acp_intensive_care_days_3

157 ACP_HIGH_DEPENDENCY_DAYS_3      acp_high_dependency_days_3

158 ACP_ORGAN_SYSTEMS_SUPPORTED_3acp_organ_systems_supported_3

159 ACP_PLANNED_INDICATOR_3         acp_planned_indicator_3

160 ACP_OUTCOME_INDICATOR_3         acp_outcome_indicator_3

161 ACP_DISPOSAL_3                  acp_disposal_3
162 ACP_END_DATE_3                  acp_end_date_3

163 ACP_MAIN_SPECIALTY_CODE_3       acp_main_specialty_code_3

164 ACP_LOCATION_CLASS_3            acp_location_class_3
165 ACP_LOCATION_3                  acp_location_3
166 ACP_Number_4                    acp_number_4
167 ACP_START_DATE_4                acp_start_date_4

168 ACP_SOURCE_4                    acp_source_4
169 ACP_INTENSIVE_CARE_DAYS_4       acp_intensive_care_days_4

170 ACP_HIGH_DEPENDENCY_DAYS_4      acp_high_dependency_days_4

171 ACP_ORGAN_SYSTEMS_SUPPORTED_4acp_organ_systems_supported_4

172 ACP_PLANNED_INDICATOR_4         acp_planned_indicator_4

173 ACP_OUTCOME_INDICATOR_4         acp_outcome_indicator_4

174 ACP_DISPOSAL_4                  acp_disposal_4
175 ACP_END_DATE_4                  acp_end_date_4

176 ACP_MAIN_SPECIALTY_CODE_4       acp_main_specialty_code_4

177 ACP_LOCATION_CLASS_4            acp_location_class_4
178 ACP_LOCATION_4                  acp_location_4
179 ACP_Number_5                    acp_number_5
180 ACP_START_DATE_5                acp_start_date_5

181 ACP_SOURCE_5                    acp_source_5
182 ACP_INTENSIVE_CARE_DAYS_5       acp_intensive_care_days_5

183 ACP_HIGH_DEPENDENCY_DAYS_5      acp_high_dependency_days_5

184 ACP_ORGAN_SYSTEMS_SUPPORTED_5acp_organ_systems_supported_5

185 ACP_PLANNED_INDICATOR_5         acp_planned_indicator_5

186 ACP_OUTCOME_INDICATOR_5         acp_outcome_indicator_5

187 ACP_DISPOSAL_5                  acp_disposal_5
188 ACP_END_DATE_5                  acp_end_date_5

189 ACP_MAIN_SPECIALTY_CODE_5       acp_main_specialty_code_5

190 ACP_LOCATION_CLASS_5            acp_location_class_5
191 ACP_LOCATION_5                  acp_location_5
192 ACP_Number_6                    acp_number_6
193 ACP_START_DATE_6                acp_start_date_6

194 ACP_SOURCE_6                    acp_source_6
195 ACP_INTENSIVE_CARE_DAYS_6       acp_intensive_care_days_6

196 ACP_HIGH_DEPENDENCY_DAYS_6      acp_high_dependency_days_6

197 ACP_ORGAN_SYSTEMS_SUPPORTED_6acp_organ_systems_supported_6

198 ACP_PLANNED_INDICATOR_6         acp_planned_indicator_6

199 ACP_OUTCOME_INDICATOR_6         acp_outcome_indicator_6

200 ACP_DISPOSAL_6                  acp_disposal_6
201 ACP_END_DATE_6                  acp_end_date_6

202 ACP_MAIN_SPECIALTY_CODE_6       acp_main_specialty_code_6

203 ACP_LOCATION_CLASS_6            acp_location_class_6
204 ACP_LOCATION_6                  acp_location_6
205 ACP_Number_7                    acp_number_7
206 ACP_START_DATE_7                acp_start_date_7

207 ACP_SOURCE_7                    acp_source_7
208 ACP_INTENSIVE_CARE_DAYS_7       acp_intensive_care_days_7

209 ACP_HIGH_DEPENDENCY_DAYS_7      acp_high_dependency_days_7

210 ACP_ORGAN_SYSTEMS_SUPPORTED_7acp_organ_systems_supported_7
211 ACP_PLANNED_INDICATOR_7         acp_planned_indicator_7

212 ACP_OUTCOME_INDICATOR_7         acp_outcome_indicator_7

213 ACP_DISPOSAL_7                  acp_disposal_7
214 ACP_END_DATE_7                  acp_end_date_7

215 ACP_MAIN_SPECIALTY_CODE_7       acp_main_specialty_code_7

216 ACP_LOCATION_CLASS_7            acp_location_class_7
217 ACP_LOCATION_7                  acp_location_7
218 ACP_Number_8                    acp_number_8
219 ACP_START_DATE_8                acp_start_date_8

220 ACP_SOURCE_8                    acp_source_8
221 ACP_INTENSIVE_CARE_DAYS_8       acp_intensive_care_days_8

222 ACP_HIGH_DEPENDENCY_DAYS_8      acp_high_dependency_days_8

223 ACP_ORGAN_SYSTEMS_SUPPORTED_8acp_organ_systems_supported_8

224 ACP_PLANNED_INDICATOR_8         acp_planned_indicator_8

225 ACP_OUTCOME_INDICATOR_8         acp_outcome_indicator_8

226 ACP_DISPOSAL_8                  acp_disposal_8
227 ACP_END_DATE_8                  acp_end_date_8

228 ACP_MAIN_SPECIALTY_CODE_8       acp_main_specialty_code_8

229 ACP_LOCATION_CLASS_8            acp_location_class_8
230 ACP_LOCATION_8                  acp_location_8
231 ACP_Number_9                    acp_number_9
232 ACP_START_DATE_9                acp_start_date_9

233 ACP_SOURCE_9                    acp_source_9
234 ACP_INTENSIVE_CARE_DAYS_9       acp_intensive_care_days_9

235 ACP_HIGH_DEPENDENCY_DAYS_9      acp_high_dependency_days_9

236 ACP_ORGAN_SYSTEMS_SUPPORTED_9acp_organ_systems_supported_9

237 ACP_PLANNED_INDICATOR_9         acp_planned_indicator_9

238 ACP_OUTCOME_INDICATOR_9         acp_outcome_indicator_9

239 ACP_DISPOSAL_9                  acp_disposal_9
240 ACP_END_DATE_9                  acp_end_date_9

241 ACP_MAIN_SPECIALTY_CODE_9       acp_main_specialty_code_9

242 ACP_LOCATION_CLASS_9            acp_location_class_9
                  243 ACP_LOCATION_9                             acp_location_9
                  244 ORG_CODE_SENDER                            org_code_sender

                  245 LOADED_STG_DATE                            dtd_loaded_stage_date

                  246 PROTOCOL_IDENTIFIER                        protocol_identifier
                  247 UNIQUE_CDS_IDENTIFIER                      unique_cds_identifier
                  248 APPLICABLE_DATE_TIME                       applicable_date_time

                  249 EXTRACT_DATE_TIME,                         extract_date_time

                  250 REPORT_PERIOD_START_DATE,                  report_period_start_date

                  251 REPORT_PERIOD_END_DATE,                    report_period_end_date

                  252 Query date



                  253 Query UID

Note: all data in the episodes extract is at episode level unless explicitly identified otherwise (as "Y") in the Spell Derivation column
                                                                       Index

Caption                    Spell      Comment           Format
                           derivation
SUS Version                           System field      Char(255)
NHS RID (From                          The NHS       Char(35)
Provider)                              provided
                                       Unique Record
                                       Identifier if
                                       provided


Spell Identifier           Y           Unique Spell     Number
                                       ID following
                                       SUS Spell
                                       creation
Generated Record ID                                     Number

CDS Record Type                        CDS record       Char(3)
                                       type as
                                       defined in the
                                       CDS Manual
Reason access                          As provider,  Char(20)
provided                               commissioner,
                                       responsible
                                       PCT (not
                                       commissioner)
                                       etc

Spell in PbR/Not in        Y           Spell level flag - Number
PbR                                    Spell is / is not
                                       PbR
                                       qualified/untari
                                       ffed
Pseudonymised Status                   Future use -     Number
                                       flag to identify
                                       pseudonymisat
                                       ion status
Local Patient Identifier               As NHS data      CHAR(10)
                                       dictionary,
                                       clear or P14N
                                       depending on     (Number if
                                       RBAC             _PSEUD form)
Org Code Local Patient                                  Char(12)
Identifier
NHS Number                             As NHS data      CHAR(10)
                                       dictionary,
                                       clear or P14N
                                       depending on     (Number if
                                       RBAC             _PSEUD form)
Birth Date                             As NHS data      Char(8)
                                       dictionary,
                                                        YYYYMMDD
                                       clear or P14N
                                                        CHAR(8)
                                       depending on
                                       RBAC             (Number if
                                                        _PSEUD form)
Age at Start of Episode                                 Char(4)

Age at End of Episode                                   Char(4)
Carer Support Indicator   As NHS data      Char(2)
                          dictionary
Legal Status                               Char(2)
Classification Code
Ethnic Category Code                       Char(2)
Marital Status                             Char(1)
NHS Number Status                          Char(2)
Indicator
Gender Code                                Char(1)
Total Previous                             Char(4)
Pregnancies
Postcode of Usual         As NHS data      CHAR(35)
Address                   dictionary,
                          clear or P14N
                          depending on     (Number if
                          RBAC             _PSEUD used)
Postcode Sector of                         Char(9)
Usual Address
Organisation Code                          Char(12)
(PCT of Residence)
Patient Postcode                           Char(1)
Derived PCT Type
Patient Postcode          Derived PCT Char(12)
Derived PCT               for postcode -
                          see
                          NWCS301 -
                          NDS Data
                          Derivation
                          Service
                          Component
                          Design

Hospital Provider Spell   As NHS data      CHAR(17)
No                        dictionary,
                          clear or P14N    (Number if
                          depending on     _PSEUD is
                          RBAC             used)
Administrative                             Char(2)
Category
Patient Classification                     Char(1)
Admission Method                           Char(2)
(Hospital Provider
Spell)
Admission Method                           Char(2)
(Original Data)
Admission Type            Elective / non   Char(2)
(Derived)                 elective -
                          derived
Discharge Destination                      Char(2)
(Hospital Provider
Spell)
Discharge Method                           Char(1)
(Hospital Provider
Spell)
Source of Admission                        Char(2)
(Hospital Provider
Spell)
Start Date (Hospital                     Char(8)
Provider Spell)                          YYYYMMDD
End Date (Hospital                       Char(8)
Provider Spell)                          YYYYMMDD
Episode Number            As NHS data    Number
                          dictionary
First Regular Day Night                  Char(1)
Admission
Last Episode in Spell                    Char(1)
Indicator
Neonatal Level of Care                   Char(1)

Operation Status                         Char(1)
Psychiatric Patient                      Char(1)
Status
Number of Augmented                      Number
Care Periods
Episode Start Date                       Char(8)
                                         YYYYMMDD
Episode End Date                         Char(8)
                                         YYYYMMDD
Commissioner Serial                      Char(6)
No (Agreement No)
NHS Service                              Char(10)
Agreement Line No
Provider Reference No                    Char(17)

Commissioner                             Char(17)
Reference No
Organisation Code                        Char(12)
(Code of Provider)
Provider Site Code                       Char(12)
Organisation Code         Org level    Char(12)
(Code of                  commissioner
Commissioner)             code
Commissioner Code         Org level       Char(12)
(Original Data)           Commissioner
                          code before
                          testing against
                          reference files


PCT Derived from GP       Derived PCT    Char(12)
                          for GP - see
                          NWCS301 -
                          NDS Data
                          Derivation
                          Service
                          Component
                          Design
PCT Derived from GP          Derived PCT     Char(12)
Practice                     for GP - see
                             NWCS301 -
                             NDS Data
                             Derivation
                             Service
                             Component
                             Design

Commissioner Site                            Char(12)
Code
Spell Commissioner       Y   Commissioner Char(12)
code                         code (at
                             organisation
                             level) for PbR
                             Spell - null if
                             no dominant
                             episode in
                             spell

Site code of Treatment                       Char(12)
(at start of episode)

Consultant Code                              Char(8)
Main Specialty Code                          Char(3)
Treatment Function                           Char(3)
Code
Registered GMP Code                          Char(8)
GP Code                                      Char(8)
GP Practice Code             Practice code   Char(12)
GP Practice Code             Practice code Char(12)
(Original Data)              before testing
                             against
                             reference files


GP Practice Code             Derived         Char(12)
(Derived)                    Practice for
                             GP - see
                             NWCS301 -
                             NDS Data
                             Derivation
                             Service
                             Component
                             Design

Referrer Code                                Char(12)
Referring Organisation                       Char(12)
Code
Duration of Elective         As NHS data     Char(5)
Wait                         dictionary
Intended Management                          Char(1)
Decided To Admit Date                        Char(8)
                                             YYYYMMDD
Length of Stay                               Number
(Episode)
Spell Version As At      Y   Date spell      Char(8)
Date                         created         YYYYMMDD
Applicable Costing                          Char(50)
Period
Episode HRG                The HRG          Char(3)
(Submitted)                submitted by
                           the Provider
Episode HRG Version        The HRG          Char(3)
(Submitted)                version
                           submitted by
                           the provider
Episode HRG                The HRG          Char(3)
(Calculated)               version
                           calculated by
                           SUS
Episode HRG Version        The version of Char(3)
(Calculated)               HRG
                           calculated by
                           SUS
HRG Code Differs           Set if there is a Number
Indicator                  difference
                           between SUS
                           calculated and
                           locally
                           provided
                           values of HRG

Programme Budget           The PB code      Char(0)
Code                       calculated by
                           SUS
                           (incorporates
                           version in
                           code, hence
                           no separate
                           version field)

Service ID                 The service ID Number
                           associated
                           with the
                           episode (used
                           to calculate
                           specialist top-
                           up)

Service ID Version                          Char(0)
Significant ID for Spell   Is the           Number
                           significant ID
                           for Spell -
                           agree values
Dominant Episode           Indicates that Number
Indicator                  episode is the
                           "dominant for
                           purposes of
                           calculating he
                           PbR tariff
PbR Excluded Indicator     Indicates        Number
                           whether
                           episode
                           qualifies for
                           PbR
                           as present
Exclusion Reason      Text - reason   Char(100)
                      excluded
Diagnosis Scheme In   As NHS data     Char(3)
Use                   dictionary
Primary Diagnosis                     Char(7)
Code
Secondary Diagnosis                   Char(7)
Code 1
Secondary Diagnosis                   Char(7)
Code 2
Secondary Diagnosis                   Char(7)
Code 3
Secondary Diagnosis                   Char(7)
Code 4
Secondary Diagnosis                   Char(7)
Code 5
Secondary Diagnosis                   Char(7)
Code 6
Secondary Diagnosis                   Char(7)
Code 7
Secondary Diagnosis                   Char(7)
Code 8
Secondary Diagnosis                   Char(7)
Code 9
Secondary Diagnosis                   Char(7)
Code 10
Secondary Diagnosis                   Char(7)
Code 11
Secondary Diagnosis                   Char(7)
Code 12
Procedure Scheme In   As NHS data     Char(3)
Use                   dictionary
Primary Procedure                     Char(7)
Code
Primary Procedure                     Char(8)
Date                                  YYYYMMDD
Procedure Code 2                      Char(7)
Procedure Date 2                      Char(8)
                                      YYYYMMDD
Procedure Code 3                      Char(7)
Procedure Date 3                      Char(8)
                                      YYYYMMDD
Procedure Code 4                      Char(7)
Procedure Date 4                      Char(8)
                                      YYYYMMDD
Procedure Code 5                      Char(7)
Procedure Date 5                      Char(8)
                                      YYYYMMDD
Procedure Code 6                      Char(7)
Procedure Date 6                      Char(8)
                                      YYYYMMDD
Procedure Code 7                      Char(7)
Procedure Date 7                      Char(8)
                                      YYYYMMDD
Procedure Code 8                      Char(7)
Procedure Date 8                      Char(8)
                                      YYYYMMDD
Procedure Code 9                      Char(7)
Procedure Date 9                      Char(8)
                                      YYYYMMDD
Procedure Code 10                     Char(7)
Procedure Date 10                     Char(8)
                                      YYYYMMDD
Procedure Code 11                     Char(7)
Procedure Date 11                     Char(8)
                                      YYYYMMDD
Procedure Code 12                     Char(7)
Procedure Date 12                     Char(8)
                                      YYYYMMDD
ACP Number 1            Repeating     Number
                        blocks - As
                        NHS data
                        dictionary
ACP Start Date 1                      Char(8)
                                      YYYYMMDD
ACP Source 1                          Char(2)
ACP Intensive Care                    Char(4)
Days 1
ACP High Dependency                   Char(4)
Days 1
ACP Organ Systems                     Char(2)
Supported 1
ACP Planned Indicator                 Char(1)
1
ACP Outcome                           Char(2)
Indicator 1
ACP Disposal 1                        Char(2)
ACP End Date 1                        Char(8)
                                      YYYYMMDD
ACP Main Specialty                    Char(3)
Code 1
ACP Location Class 1                  Char(3)
ACP Location 1                        Char(6)
ACP Number 2                          Number
ACP Start Date 2                      Char(8)
                                      YYYYMMDD
ACP Source 2                          Char(2)
ACP Intensive Care                    Char(4)
Days 2
ACP High Dependency                   Char(4)
Days 2
ACP Organ Systems                     Char(2)
Supported 2
ACP Planned Indicator                 Char(1)
2
ACP Outcome             Char(2)
Indicator 2
ACP Disposal 2          Char(2)
ACP End Date 2          Char(8)
                        YYYYMMDD
ACP Main Specialty      Char(3)
Code 2
ACP Location Class 2    Char(3)
ACP Location 2          Char(6)
ACP Number 3            Number
ACP Start Date 3        Char(8)
                        YYYYMMDD
ACP Source 3            Char(2)
ACP Intensive Care      Char(4)
Days 3
ACP High Dependency     Char(4)
Days 3
ACP Organ Systems       Char(2)
Supported 3
ACP Planned Indicator   Char(1)
3
ACP Outcome             Char(2)
Indicator 3
ACP Disposal 3          Char(2)
ACP End Date 3          Char(8)
                        YYYYMMDD
ACP Main Specialty      Char(3)
Code 3
ACP Location Class 3    Char(3)
ACP Location 3          Char(6)
ACP Number 4            Number
ACP Start Date 4        Char(8)
                        YYYYMMDD
ACP Source 4            Char(2)
ACP Intensive Care      Char(4)
Days 4
ACP High Dependency     Char(4)
Days 4
ACP Organ Systems       Char(2)
Supported 4
ACP Planned Indicator   Char(1)
4
ACP Outcome             Char(2)
Indicator 4
ACP Disposal 4          Char(2)
ACP End Date 4          Char(8)
                        YYYYMMDD
ACP Main Specialty      Char(3)
Code 4
ACP Location Class 4    Char(3)
ACP Location 4          Char(6)
ACP Number 5            Number
ACP Start Date 5        Char(8)
                        YYYYMMDD
ACP Source 5            Char(2)
ACP Intensive Care      Char(4)
Days 5
ACP High Dependency     Char(4)
Days 5
ACP Organ Systems       Char(2)
Supported 5
ACP Planned Indicator   Char(1)
5
ACP Outcome             Char(2)
Indicator 5
ACP Disposal 5          Char(2)
ACP End Date 5          Char(8)
                        YYYYMMDD
ACP Main Specialty      Char(3)
Code 5
ACP Location Class 5    Char(3)
ACP Location 5          Char(6)
ACP Number 6            Number
ACP Start Date 6        Char(8)
                        YYYYMMDD
ACP Source 6            Char(2)
ACP Intensive Care      Char(4)
Days 6
ACP High Dependency     Char(4)
Days 6
ACP Organ Systems       Char(2)
Supported 6
ACP Planned Indicator   Char(1)
6
ACP Outcome             Char(2)
Indicator 6
ACP Disposal 6          Char(2)
ACP End Date 6          Char(8)
                        YYYYMMDD
ACP Main Specialty      Char(3)
Code 6
ACP Location Class 6    Char(3)
ACP Location 6          Char(6)
ACP Number 7            Number
ACP Start Date 7        Char(8)
                        YYYYMMDD
ACP Source 7            Char(2)
ACP Intensive Care      Char(4)
Days 7
ACP High Dependency     Char(4)
Days 7
ACP Organ Systems       Char(2)
Supported 7
ACP Planned Indicator   Char(1)
7
ACP Outcome             Char(2)
Indicator 7
ACP Disposal 7          Char(2)
ACP End Date 7          Char(8)
                        YYYYMMDD
ACP Main Specialty      Char(3)
Code 7
ACP Location Class 7    Char(3)
ACP Location 7          Char(6)
ACP Number 8            Number
ACP Start Date 8        Char(8)
                        YYYYMMDD
ACP Source 8            Char(2)
ACP Intensive Care      Char(4)
Days 8
ACP High Dependency     Char(4)
Days 8
ACP Organ Systems       Char(2)
Supported 8
ACP Planned Indicator   Char(1)
8
ACP Outcome             Char(2)
Indicator 8
ACP Disposal 8          Char(2)
ACP End Date 8          Char(8)
                        YYYYMMDD
ACP Main Specialty      Char(3)
Code 8
ACP Location Class 8    Char(3)
ACP Location 8          Char(6)
ACP Number 9            Number
ACP Start Date 9        Char(8)
                        YYYYMMDD
ACP Source 9            Char(2)
ACP Intensive Care      Char(4)
Days 9
ACP High Dependency     Char(4)
Days 9
ACP Organ Systems       Char(2)
Supported 9
ACP Planned Indicator   Char(1)
9
ACP Outcome             Char(2)
Indicator 9
ACP Disposal 9          Char(2)
ACP End Date 9          Char(8)
                        YYYYMMDD
ACP Main Specialty      Char(3)
Code 9
ACP Location Class 9    Char(3)
               ACP Location 9            Char(6)
               Organisation Code         Char(12)
               (Sender)
               Staging Loaded Date       Char(8)
                                         YYYYMMDD
               Protocol Identifier       Char(3)
               Unique CDS Identifier     Char(35)
               Applicable Date           Char(8)
                                         YYYYMMDD
               Extract Date              Char(8)
                                         YYYYMMDD
               Report Period Start       Char(8)
               Date                      YYYYMMDD
               Report Period End         Char(8)
               Date                      YYYYMMDD
               Query Date                Char(16)
                                         YYYYMMDDH
                                         HMMSS
               Unique Query Id           Char(50)

as "Y") in the Spell Derivation column
OutPatient File Extract Specification v5.0
Group           Seq     CDS Data Element            View Column Name
                      1 SUS_VERSION
Record ID             2 NHS_DEFINED_RID             NHS_DEFINED_RID




Spell ID              3 SPELL_ID                    SPELL_ID




Generated             4 GENERATED_RECORD_ID,
Record ID                                           ede_id
Record Type           5 CDS_RECORDS_TYPE            CDS_RECORD_TYPE




                      6 SPELL IN PBR/Not In PBR     pbr_qualify_ind




                      7 Reason access provided




                      8 PSEUDONYMISATION_STATUS




Patient               9 LOCAL PATIENT IDENTIFIER
Identifiers

                                                  LOCAL_PATIENT_ID (LPI_PSEUD is used for
                                                  SHA extracts)
                      10 ORG_CODE_LOCAL_PATIENT_IDorg_code_local_patient_id

                      11 NHS Number                 NHS_NUMBER (NHS_NUMBER_PSEUD is
                                                    used for SHA extracts)




Birth and age         12 BIRTH DATE                 to_char(BIRTH_DATE, 'YYYYMMDD')
                                                    (BIRTH_DATE_PSEUD is used for SHA extract)
Birth and age     12 BIRTH DATE                   to_char(BIRTH_DATE, 'YYYYMMDD')
                                                  (BIRTH_DATE_PSEUD is used for SHA extract)




                  13 Age                          age_at_event_date
                  14 Field not used
Other person      15 CARER SUPPORT INDICATOR      carer_support_indicator
data
                  16 Field not used
                  17 ETHNIC CATEGORY              ethnic_category
                  18 MARITAL STATUS               marital_status
                  19 NHS_Number_STATUS            nhs_number_status

                  20 SEX                          sex
                  21 Field not used
                  22 POSTCODE OF USUAL            POSTCODE (POSTCODE_PSEUD is used for
                     ADDRESS                      SHA extracts)




                  23 POSTCODE_SECTOR_USUAL        postcode_sector_usual_addr
                     ADDR
                  24 PCT_OF_RESIDENCE             PCT_OF_RESIDENCE

                  25 PATIENT_POSTCODE_PCT_TY PATIENT_POSTCODE_PCT_TYPE_D
                     PE_D,
                  26 PATIENT_POSTCODE_PCT_D,      PATIENT_POSTCODE_PCT_D




Attendance        27 ATTENDANCE IDENTIFIER        spell_id
characteristics
                  28 ADMINISTRATIVE CATEGORY      administrative_category
                  29 ATTENDED OR DID NOT          ATTENDANCE_STATUS
                     ATTEND
                  30 FIRST ATTENDANCE             first_attendance
                  31 OUTCOME OF ATTENDANCE        attendance_outcome

                  32 MEDICAL STAFF TYPE SEEING staff_type_seeing_patient
                     PATIENT
                  33 SOURCE OF REFERRAL FOR       source_of_referral_for_op
                     OUT-PATIENTS
                  34 APPOINTMENT DATE             admission_date


                  35 OPERATION STATUS             operation_status
Contract          36 COMMISSIONING SERIAL         commissioner_serial_no
                     Number
identifiers       37 NHS SERVICE AGREEMENT        agreement_line_no
                     LINE Number
                  38 PROVIDER REFERENCE           provider_reference_no
                     Number
               39 COMMISSIONER REFERENCE     commissioner_reference_no
                  Number
Provider &     40 PROVIDER_CODE              provider_code

Commissioner   41 PROVIDER_SITE_CODE         provider_code_orig

               42 COMMISSIONER_CODE          commissioner_code

               43 COMMISSIONER_CODE_ORIG     commissioner_code_orig

               44 GP_PCT_D,                  GP_PCT_D




               45 GP_PRACTICE_PCT_D,         GP_PRACTICE_PCT_D




               46 COMMISSIONER_SITE_CODE     commissioner_site_code
               47 LOCATION CLASS             attendance_location_class
               48 SITE CODE (OF TREATMENT)   attendance_site_code
Consultant &   49 CONSULTANT CODE            consultant_code
specialty      50 MAIN SPECIALTY CODE        main_specialty_code
               51 TREATMENT FUNCTION CODE    treatment_function_code

GMP &          52 REGISTERED_GMP_CODE        registered_gmp_code
referrer       53 GP_CODE                    gp_code_orig
               54 GP_PRACTICE_CODE           gp_practice_code
               55 GP_PRACTICE_CODE_ORIG      gp_practice_code_orig




               56 GP_PRACTICE_D




                                             gp_practice_code_fe
               57 REFERRER_CODE              referrer_code
               58 REFERRING_ORG_CODE         org_code_referrer
Appointment      59 PRIORITY TYPE                   priority_type
request
                 60 SERVICE TYPE REQUESTED          service_type_requested

                 61 REFERRAL REQUEST                referral_request_received_date
                    RECEIVED DATE

                 62 LAST DNA OR PATIENT             last_dna_or_patient_canc_date
                    CANCELLED DATE

Freeze & spell   63 EFFECTIVE_DATE                  Version_effective_date
status

                 64 APPLICABLE_COSTING_PERIO applicable_costing_period
                    D
                 65 SPELL_STATUS_IND                SPELL_STATUS_IND

                 66 SPELL_FROZEN_IND

                                                    spell_frozen_ind
HRG              67 HRG_SUBMITTED                   hrg_submitted
                 68 HRG_VERSION_SUBMITTED           hrg_version_submitted

                 69 Field not used
                 70 Field not used
                 71 Field not used
                 72 Field not used
Diagnosis        73 DIAGNOSIS SCHEME IN USE         DIAGNOSIS_SCHEME_IN_USE

                 74 PRIMARY DIAGNOSIS (ICD)         primary_diagnosis_code
                 75 SECONDARY DIAGNOSIS (ICD) secondary_diagnosis_code_1

Procedure        76 PROCEDURE SCHEME IN USE         procedure_scheme_in_use

                 77 PRIMARY PROCEDURE (OPCS) primary_procedure_code

                 78 PROCEDURE (OPCS) 2              procedure_code_2
                 79 PROCEDURE (OPCS) 3              procedure_code_3
                 80 PROCEDURE (OPCS) 4              procedure_code_4
                 81 PROCEDURE (OPCS) 5              procedure_code_5
                 82 PROCEDURE (OPCS) 6              procedure_code_6
                 83 PROCEDURE (OPCS) 7              procedure_code_7
                 84 PROCEDURE (OPCS) 8              procedure_code_8
                 85 PROCEDURE (OPCS) 9              procedure_code_9
                 86 PROCEDURE (OPCS) 10             procedure_code_10
                 87 PROCEDURE (OPCS) 11             procedure_code_11
                 88 PROCEDURE (OPCS) 12             procedure_code_12
Tariff           89 Tariff for SPECIALTY            tariff_for_specialty
                 90 Adjusted Tariff for PRIMARY     PRIMARY_PROCEDURE_TARIFF
                    PROCEDURE (OPCS)
                 91 Adjusted Tariff for PROCEDURE   PROCEDURE_CODE2_TARIFF
                    (OPCS) 2
               92 Adjusted Tariff for PROCEDURE   PROCEDURE_CODE3_TARIFF
                  (OPCS) 3
               93 Adjusted Tariff for PROCEDURE   PROCEDURE_CODE4_TARIFF
                  (OPCS) 4
               94 Adjusted Tariff for PROCEDURE   PROCEDURE_CODE5_TARIFF
                  (OPCS) 5
               95 Adjusted Tariff for PROCEDURE   PROCEDURE_CODE6_TARIFF
                  (OPCS) 6
               96 Adjusted Tariff for PROCEDURE   PROCEDURE_CODE7_TARIFF
                  (OPCS) 7
               97 Adjusted Tariff for PROCEDURE   PROCEDURE_CODE8_TARIFF
                  (OPCS) 8
               98 Adjusted Tariff for PROCEDURE   PROCEDURE_CODE9_TARIFF
                  (OPCS) 9
               99 Adjusted Tariff for PROCEDURE   PROCEDURE_CODE10_TARIFF
                  (OPCS) 10
              100 Adjusted Tariff for PROCEDURE   PROCEDURE_CODE11_TARIFF
                  (OPCS) 11
              101 Adjusted Tariff for PROCEDURE   PROCEDURE_CODE12_TARIFF
                  (OPCS) 12
              102 Total Tariff                    tariff_total_payment
Interchange   103 ORG_CODE_SENDER                 ORG_CODE_SENDER

              104 LOADED_STG_DATE                 LOADED_STG_DATE


              105 PROTOCOL_IDENTIFIER             PROTOCOL_IDENTIFIER
              106 UNIQUE_CDS_IDENTIFIER           UNIQUE_CDS_IDENTIFIER

              107 APPLICABLE_DATE_TIME            APPLICABLE_DATE_TIME


              108 EXTRACT_DATE_TIME,              EXTRACT_DATE_TIME




              109 REPORT_PERIOD_START_DAT REPORT_PERIOD_START_DATE
                  E,

              110 REPORT_PERIOD_END_DATE,         REPORT_PERIOD_END_DATE


Query         111 Query date



              112 Query UID
                                                           Index

Caption                    Comment          Format
SUS Version                System field     Char(255)
NHS RID (From              The NHS       Char(35)
Provider)                  provided
                           Unique Record
                           Identifier if
                           provided


Spell Identifier           Unique Spell    Number
                           ID following
                           SUS Spell
                           creation (note:
                           to be
                           presented to
                           user as
                           OP_EPISODE
                           _ID)

Generated Record ID                         Number

CDS Record Type            CDS record       Char(3)
                           type as
                           defined in the
                           CDS Manual
Spell in PbR/Not in PbR Spell level flag - Number
                        Spell is / is not
                        PbR
                        qualified/untari
                        ffed
Reason access provided As provider,  Char(20)
                       commissioner,
                       responsible
                       PCT (not
                       commissioner)
                       etc

Pseudonymised Status       Future use -     Number
                           flag to identify
                           pseudonymisat
                           ion status
Local Patient Identifier   As NHS data      CHAR(10)
                           dictionary,
                           clear or P14N
                           depending on     (Number if
                           RBAC             _PSEUD form)
Org Code Local Patient                      Char(12)
Identifier
NHS Number                 As NHS data      CHAR(10)
                           dictionary,
                           clear or P14N
                           depending on     (Number if
                           RBAC             _PSEUD form)
Birth Date                 As NHS data      Char(8)
                           dictionary,
                                            YYYYMMDD
                           clear or P14N
                                            CHAR(8)
                           depending on
                           RBAC
Birth Date                As NHS data
                          dictionary,
                          clear or P14N
                          depending on
                          RBAC            (Number if
                                          _PSEUD form)
Age                                       Char(4)
Field 14 not used                         Char(0)
Carer Support Indicator                   Char(2)

Field 16 not used                         Char(0)
Ethnic Category Code                      Char(2)
Marital Status                            Char(1)
NHS Number Status                         Char(2)
Indicator
Gender Code                               Char(1)
Field 21 not used                         Char(0)
Postcode of Usual         As NHS data     CHAR(35)
Address                   dictionary,
                          clear or P14N
                          depending on    (Number if
                          RBAC            _PSEUD used)
Postcode Sector of                        Char(9)
Usual Address
Organisation Code (PCT                    Char(12)
of Residence)
Patient Postcode                          Char(1)
Derived PCT Type
Patient Postcode          Derived - see Char(12)
Derived PCT               NWCS301 -
                          NDS Data
                          Derivation
                          Service
                          Component
                          Design


Attendance Identifier                     Number
Administrative Category                   Char(2)
Attended Or Did Not                       Char(1)
Attend
First Attendance                          Number
Outcome Of Attendance                     Char(1)

Medical Staff Type                        Char(2)
Seeing Patient
Source of Referral for                    Char(2)
Outpatients
Appointment Date                          Char(8)
                                          YYYYMMDD
Operation Status                          Char(1)
Commissioning Serial                      Char(6)
No (Agreement No)
NHS Service Agreement                     Char(10)
Line No
Provider Reference No                     Char(17)
Commissioner                             Char(17)
Reference No
Organisation Code                        Char(12)
(Code of Provider)
Provider Site Code                       Char(12)

Organisation Code                        Char(12)
(Code of Commissioner)
Commissioner Code                        Char(12)
(Original Data)
PCT Derived from GP      Derived PCT     Char(12)
                         for GP - see
                         NWCS301 -
                         NDS Data
                         Derivation
                         Service
                         Component
                         Design

PCT Derived from GP      Derived PCT     Char(12)
Practice                 Practice for
                         GP - see
                         NWCS301 -
                         NDS Data
                         Derivation
                         Service
                         Component
                         Design

Commissioner Site Code                   Char(12)
Location Class                           Char(3)
Site code of Treatment                   Char(12)
Consultant Code                          Char(8)
Main Specialty Code                      Char(3)
Treatment Function                       Char(3)
Code
Registered GMP Code                      Char(8)
GP Code                                  Char(8)
GP Practice Code         Practice code   Char(12)
GP Practice Code         Practice code Char(12)
(Original Data)          before testing
                         against
                         reference files


GP Practice Code         Derived         Char(12)
(Derived)                Practice for
                         GP - see
                         NWCS301 -
                         NDS Data
                         Derivation
                         Service
                         Component
                         Design

Referrer Code                            Char(12)
Referring Organisation                   Char(12)
Code
Priority Type                                Char(1)
Service Type Requested                       Char(1)

Referral Request                             Char(8)
Received Date
                                             YYYYMMDD
Last DNA or Patient                          Char(8)
Cancelled Date
                                             YYYYMMDD
Effective Date            "As at date"       Char(8)
                                             YYYYMMDD
Applicable Costing                           Char(50)
Period
PbR Spell Status          Spell status       Number
Indicator
                          Indicates          Number
PbR Spell Frozen          whether spell
Indicator                 frozen
HRG (Submitted)           Note: for future   Char(3)
                          use - fields
HRG Version                                  Char(3)
                          66,67 are
(Calculated)
                          identified in
Field 69 not used         schema but         Char(0)
Field 70 not used         will not           Char(0)
                          necessarily be
Field 71 not used         populated          Char(0)
Field 72 not used                            Char(0)
Diagnosis Scheme In                          Char(3)
Use
Primary Diagnosis Code                       Char(7)
Secondary Diagnosis                          Char(7)
Code
Procedure Scheme In                          Char(3)
Use
Primary Procedure Code                       Char(7)

Procedure Code 2                             Char(7)
Procedure Code 3                             Char(7)
Procedure Code 4                             Char(7)
Procedure Code 5                             Char(7)
Procedure Code 6                             Char(7)
Procedure Code 7                             Char(7)
Procedure Code 8                             Char(7)
Procedure Code 9                             Char(7)
Procedure Code 10                            Char(7)
Procedure Code 11                            Char(7)
Procedure Code 12                            Char(7)
Tariff For Specialty                         Number
Adj Tariff Primary Proc                      Number
OPCS
Adj Tariff Procedure                         Number
OPCS 2
Adj Tariff Procedure                   Number
OPCS 3
Adj Tariff Procedure                   Number
OPCS 4
Adj Tariff Procedure                   Number
OPCS 5
Adj Tariff Procedure                   Number
OPCS 6
Adj Tariff Procedure                   Number
OPCS 7
Adj Tariff Procedure                   Number
OPCS 8
Adj Tariff Procedure                   Number
OPCS 9
Adj Tariff Procedure                   Number
OPCS 10
Adj Tariff Procedure                   Number
OPCS 11
Adj Tariff Procedure                   Number
OPCS 12
Total Tariff                           Number
Organisation Code       Sender code    Char(12)
(Sender)
Staging Loaded Date     Date loaded to Char(8)
                        PbR staging
                                       YYYYMMDD
Protocol Identifier     Net/bulk       Char(3)
Unique CDS Identifier   Sender's       Char(35)
                        identifier
Applicable Date         Interchange     Char(8)
                        applicable time
                                        YYYYMMDD
Extract Date            Sender's    Char(8)
                        extract
                        date_time -
                        from
                        PBR_EPISOD
                        ES?         YYYYMMDD
Report Period Start Date Interchange   Char(8)
                         parameters.
                                       YYYYMMDD
Report Period End Date Interchange     Char(8)
                       parameters
                                       YYYYMMDD
Query Date                             Char(16)
                                       YYYYMMDDH
                                       HMMSS
Unique Query Id                        Char(50)
Accident & Emergency File Extract Specification v5.0
Group                 Seq CDS Data Element            View Column Name
                        1 SUS_VERSION
Record ID               2 NHS_DEFINED_RID             NHS_DEFINED_RID




Spell ID                3 SPELL_ID                    spell_id




Generated Record ID     4 GENERATED_RECORD_ID,        EDE_ID

Record Type             5 CDS_RECORDS_TYPE            cds_record_type




                        6 Reason access provided




                        7 SPELL IN PBR/Not In PBR     pbr_qualifier




                        8 PSEUDONYMISATION_STATUS




Patient Identifiers     9 LOCAL PATIENT IDENTIFIER    lLOCAL_PATIENT_ID (LPI_PSEUD is used for
                                                      SHA extracts)




                       10 ORG_CODE_LOCAL_PATIENT_IDorg_code_local_patient_id

                       11 NHS Number                  NHS_NUMBER (NHS_NUMBER_PSEUD is
                                                      used for SHA extracts)




Birth and age          12 BIRTH DATE                  to_char(BIRTH_DATE, 'YYYYMMDD')
                                                      (BIRTH_DATE_PSEUD is used for SHA extract)
                    13 Age                          age_on_admission
                    14 Field not used
Other person data   15 CARER SUPPORT INDICATOR      carer_support_indicator
                    16 ETHNIC CATEGORY              ethnic_category
                    17 Field not used
                    18 MARITAL STATUS               marital_status
                    19 NHS Number STATUS            nhs_number_status
                       INDICATOR
                    20 SEX                          sex
                    21 Field not used
                    22 POSTCODE OF USUAL
                       ADDRESS
                                                    POSTCODE (POSTCODE_PSEUD is used for
                                                    SHA extracts)
                    23 POSTCODE_SECTOR_USUAL        postcode_usual_address
                       ADDR
                    24 PCT_OF_RESIDENCE             pct_of_residence

                    25 PATIENT_POSTCODE_PCT_TY PATIENT_POSTCODE_PCT_TYPE_D
                       PE_D,




                    26 PATIENT_POSTCODE_PCT_D,      PATIENT_POSTCODE_PCT_D




Attendance          27 A+E ATTENDANCE Number        ae_attendance_no
characteristics
                    28 A+E ARRIVAL MODE             ae_arrival_mode
                    29 A+E ATTENDANCE CATEGORY
                                                    ae_attendance_category
                    30 A+E ATTENDANCE DISPOSAL
                                                    ae_attendance_disposal
                    31 A+E INCIDENT LOCATION TYPE
                                                    ae_incident_location_type
                    32 A+E STAFF MEMBER CODE        ae_staff_member_code
                    33 SOURCE OF REFERRAL FOR
                       A+E                          ae_referral_source
                    34 ARRIVAL DATE

                                                    admission_date
                    35 A+E PATIENT GROUP            ae_patient_group
                    36 A+E ATTENDANCE
                       CONCLUSION TIME              ae_attendance_conclusion_time
                    37 A+E DEPARTURE TIME           ae_departure_time
               38 A+E INITIAL ASSESSMENT
                  TIME                     ae_initial_assessment_time
               39 A+E TIME SEEN FOR
                  TREATMENT                ae_time_seen_for_treatment
               40 ARRIVAL TIME

                                           ARRIVAL_DATE
Contract       41 COMMISSIONING SERIAL
                  Number                   commissioner_serial_no
identifiers    42 NHS SERVICE AGREEMENT
                  LINE Number              agreement_line_no
               43 PROVIDER REFERENCE       provider_reference_no
                  Number
               44 COMMISSIONER REFERENCE
                  Number                   commissioner_reference_no
Provider &     45 PROVIDER_CODE            provider_code

Commissioner   46 PROVIDER_SITE_CODE       provider_code_orig
               47 COMMISSIONER_CODE        commissioner_code

               48 COMMISSIONER_CODE_ORIG   decode(substr(commissioner_code_orig,1,3),
                                           'YDD', substr(commissioner_code_orig,1,5),
                                           substr(commissioner_code_orig,1,3) )
               49 GP_PCT_D,                GP_PCT_D




               50 GP_PRACTICE_PCT_D,       GP_PRACTICE_PCT_D




               51 COMMISSIONER_SITE_CODE   commissioner_code_orig
GMP &          52 REGISTERED_GMP_CODE      registered_gmp_code_fe
referrer       53 GP_CODE                  gp_code_orig

               54 GP_PRACTICE_CODE_ORIG    gp_practice_code_fe
                        55 GP_PRACTICE_D,




                                                         gp_practice_code_fe
Freeze & spell status   56 EFFECTIVE_DATE                Version_effective_date


                        57 APPLICABLE_COSTING_PERIO applicable_costing_period
                           D
                        58 SPELL_STATUS_IND              SPELL_STATUS_IND
                        59 SPELL_FROZEN_IND              SPELL_FROZEN_IND
HRG                     60 HRG_SUBMITTED                 hrg_submitted
                        61 HRG_VERSION_SUBMITTED         hrg_version_submitted

                        62 HRG_CALCULATED                hrg_calculated
                        63 HRG_VERSION_CALCULATED        hrg_version_calculated

                        64 HRG_DIFFERS_IND               decode(hrg_submitted,hrg_calculated,0,1)
Diagnosis               65 DIAGNOSIS SCHEME IN USE
                                                         diagnosis_scheme_in_use
                        66 A & E DIAGNOSIS - FIRST       ae_diagnosis_first
                        67 A & E DIAGNOSIS - SECOND      ae_diagnosis_second
Investigation           68 INVESTIGATION SCHEME IN
                           USE                           investigation_scheme_in_use
                        69 A & E INVESTIGATION - FIRST   ae_investigation_first
                        70 A & E INVESTIGATION -
                           SECOND                        ae_investigation_second
Procedure               71 PROCEDURE SCHEME IN USE
                                                         procedure_scheme_in_use
                        72 A & E TREATMENT - FIRST       PRIMARY_PROCEDURE_CODE
                        73 A & E TREATMENT - SECOND      PROCEDURE_CODE_2
Tariff                  74 Derived A&E Department Type
                                                         ae_department_type
                        75 A&E tariff value              tariff_total_payment
Interchange             76 ORG_CODE_SENDER               ORG_CODE_SENDER

                        77 LOADED_STG_DATE               dtd_loaded_stage_date


                        78 PROTOCOL_IDENTIFIER           PROTOCOL_IDENTIFIER
                        79 UNIQUE_CDS_IDENTIFIER         UNIQUE_CDS_IDENTIFIER
                        80 APPLICABLE_DATE_TIME          APPLICABLE_DATE_TIME


                        81 EXTRACT_DATE_TIME,            EXTRACT_DATE_TIME


                        82 REPORT_PERIOD_START_DAT REPORT_PERIOD_START_DATE
                           E,
        83 REPORT_PERIOD_END_DATE,   REPORT_PERIOD_END_DATE


Query   85 Query date



        86 Query UID
                                                           Index

Caption                    Comment          Format
SUS Version                System field     Char(255)
NHS RID (From Provider) The NHS       Char(35)
                        provided
                        Unique Record
                        Identifier if
                        provided


Spell Identifier           Unique Spell    Number
                           ID following
                           SUS Spell
                           creation (note:
                           to be
                           presented to
                           user as
                           OP_EPISODE
                           _ID)

Generated Record ID                         Number

CDS Record Type            CDS record       Char(3)
                           type as
                           defined in the
                           CDS Manual
Reason Access Provided As provider,  Char(20)
                       commissioner,
                       responsible
                       PCT (not
                       commissioner)
                       etc
Spell In PbR/Not In PbR    Attendance is / Number
                           is not PbR
                           qualified/untari
                           ffed
Pseudonymised Status       Future use -     Number
                           flag to identify
                           pseudonymisat
                           ion status
Local Patient Identifier   As NHS data      CHAR(10)
                           dictionary,
                           clear or P14N
                           depending on     (Number if
                           RBAC             _PSEUD form)
Org Code Local Patient                      Char(12)
Identifier
NHS Number                 As NHS data      CHAR(10)
                           dictionary,
                           clear or P14N
                           depending on     (Number if
                           RBAC             _PSEUD form)
Birth Date                 As NHS data      Char(8)
                           dictionary,
                                            YYYYMMDD
                           clear or P14N
                                            CHAR(8)
                           depending on
                           RBAC             (Number if
                                            _PSEUD form)
Age at Attendance          Derived age   Char(4)
Field 14 not used                        Char(0)
Carer Support Indicator                  Char(2)
Ethnic Category Code                     Char(0)
Field 17 not used                        Char(2)
Marital Status                           Char(1)
NHS Number Status                        Char(2)
Indicator
Gender Code                              Char(1)
Field 21 not used                        Char(0)
Postcode of Usual                        CHAR(35)
Address
                                         (Number if
                                         _PSEUD used)
Postcode Sector of Usual                 Char(9)
Address
Organisation Code (PCT                 Char(12)
of Residence)
Patient Postcode Derived Derived - see Char(1)
PCT Type                 NWCS301 -
                         NDS Data
                         Derivation
                         Service
                         Component
                         Design


Patient Postcode Derived Derived - see Char(12)
PCT                      NWCS301 -
                         NDS Data
                         Derivation
                         Service
                         Component
                         Design


A&E Attendance Number                    Char(12)
A&E Mode of Arrival                      Char(1)
A&E Attendance                           Char(1)
Category
A&E Attendance Disposal                  Char(2)

A&E Incident Location                    Char(2)
Type
A&E Staff Member Code                    Char(3)
A&E Referral Source                      Char(2)

Arrival Date                             Char(8)
                                         YYYYMMDD
A&E Patient Group                        Char(2)
A&E Attendance                           Char(19)
Conclusion Time
A&E Departure Time                       Char(19)
A&E Initial Assessment                  Char(19)
Time
A&E Time Seen for                       Char(19)
Treatment
Arrival Time                            Char(8)
                                        YYYYMMDD
Commissioning Serial No                 Char(6)
(Agreement No)
NHS Service Agreement                   Char(10)
Line No
Provider Ref No                         Char(17)
Commissioner Ref No                     Char(17)

Organisation Code (Code                 Char(12)
of Provider)
Provider Site Code                      Char(12)
Organisation Code (Code                 Char(12)
of Commissioner)
Commissioner Code                       Char(5)
(Original Data)

PCT Derived from GP       Derived - see Char(12)
                          NWCS301 -
                          NDS Data
                          Derivation
                          Service
                          Component
                          Design


PCT Derived from GP       Derived - see Char(12)
Practice                  NWCS301 -
                          NDS Data
                          Derivation
                          Service
                          Component
                          Design


Commissioner Site Code                  Char(12)
Registered GMP Code                     Char(8)
Registered GMP Code                     Char(8)
(Original Data)
GP Practice Code          Derived - see Char(12)
(Original Data)           NWCS301 -
                          NDS Data
                          Derivation
                          Service
                          Component
                          Design
GP Practice Code            Derived - see Char(12)
                            NWCS301 -
                            NDS Data
                            Derivation
                            Service
                            Component
                            Design


Version Effective Date                    Char(8)
                                          YYYYMMDD
Applicable Costing Period                 Char(50)


Spell Status Indicator                    Number

Spell Frozen Indicator                    Number
HRG Code - Submitted                      Char(3)
HRG Code Version -                        Char(3)
Submitted
HRG Code - Calculated                     Char(3)
HRG Code Version -                        Char(3)
Calculated
HRG Differs Indicator                     Number
Diagnosis Scheme In Use                   Char(3)

A&E Diagnosis First                       Char(7)
A&E Diagnosis Second                      Char(7)
Investigation Scheme In                   Char(3)
Use
A&E Investigation First                   Char(7)
A&E Investigation Second                  Char(7)

Procedure Scheme In                       Char(3)
Use
A&E Treatment First                       Char(7)
A&E Treatment Second                      Char(7)
Derived AE Department                     Char(3)
Type
A&E Tariff Value                          Number
Organisation Code                         Char(12)
(Sender)
Staging Loaded Date                       Char(8)
                                          YYYYMMDD
Protocol Identifier                       Char(3)
Unique CDS Identifier                     Char(35)
Applicable Date and Time                  Char(8)
                                          YYYYMMDD
Extract Date                              Char(8)
                                          YYYYMMDD
Report Period Start Date                  Char(8)
                                          YYYYMMDD
Report Period End Date   Char(8)
                         YYYYMMDD
Query Date               Char(16)
                         YYYYMMDDH
                         HMMSS
Unique Query Id          Char(50)
ANNEX A – Treatment of Errors in Spell Construction                           Index

    Error                      Notes                    ErrorCode   PbR Pay
A.
1 Non-contiguous EPISODE       Where gaps are           1           Y
    START DATE/EPISODE         present within a spell
    END DATE                   according to episodes
                               start and end dates.
2 Missing EPISODE START                                 2           Y
    DATE
3   Missing EPISODE END                                 3           Y
    DATE
4   Overlapping EPISODE                                 4           Y
    START DATE/EPISODE
    END DATE values within a
    spell
B.
1 Non-consecutive EPISODE Example; EPISODE              5           Y
    ORDER                      ORDER 1, 2, 4
2 EPISODE ORDER and            Where the ordering of    6           Y
    EPISODE START
    DATE mismatch              EPISODE START
                               DATE contradicts
                               EPISODE ORDER
3 Duplicate EPISODE ORDER                               7           Y

4 Missing EPISODE ORDER                                 8           Y
C.
1 EPISODE END DATE later                                9           Y
    than DISCHARGE
2   Single episode spell      Implies that other        10          Y
    mismatch between          episodes exist outside
    EPISODE START             submission.
    DATE/ADMISSION DATE or
    EPISODE END
    DATE/DISCHARGE DATE
3   DISCHARGE DATE missing                              11          Y
    on any later
    episodes within the spell
4 Duplicate ADMISSION          First spell              12          Y
    DATE with different



5 Missing ADMISSION DATE                                14          N
D. UNIQUE
1 Missing Unique Identifier                             15          N
Annex B - Emergency Re-Admissions

PbR Emergency Re-Admission

There is a requirement to identify PbR Spells which involve the emergency re-admission of a
patient within 14 days of discharge from the same provider to support local flexible funding
arrangements.

In the diagram below, each HOSPITAL PROVIDER SPELL involving emergency admissions 1 to n
for a given patient will need to be identified as an emergency re-admission and linked back to the
initial HOSPITAL PROVIDER SPELL.

   Initial HOSPITAL                   HPS 2- Emergency                HPS 3 - Emergency               HPS n- Emergency
   PROVIDER SPELL                     Admission 1                     Admission 2                     Admission n



                      Less than readmit                  Less than readmit            Less than readmit
                      interval                           interval                     interval

   HPS = Hospital Provider Spell                         Readmit interval = 14 days




The approach is to derive and maintain on each spell affected:

• A unique identifier for the initial spell
· The number of prior Readmission spells (including the initial spell)[1]
• The number of subsequent re-admission spells

        This allows a query to be run which identifies a “parent” initial HOSPITAL PROVIDER SPELL
        together with the chain of related emergency re-admissions.

Further derivation and analysis would be subject to local analysis. Allowing different local
definitions to be applied to readmissions

The following definitions apply:
         • The re-admission interval relates to the period between DISCHARGE DATE (HOSPITAL
         PROVIDER SPELL) and the START DATE (HOSPITAL PROVIDER SPELL) of the immediately
         following (HOSPITAL PROVIDER SPELL)
         • An Emergency Spell is defined as one with ADMISSION METHOD (HOSPITAL PROVIDER
         SPELL) between 20 and 30.

The re-admission interval will is 14 days, but should maintained as a parameter. The re admission
interval will be nationally mandated and not subject to change by individual commissioners or
providers.
Index

								
To top