Overview

As part of the HBCIS 5.2 Software Release, Phase 2 in September 2004, Data Quality has recommended a number of field additions which have now become available with this release, in the Appointment Scheduling Module.

Could you please provide a quotation itemised for each of these requested enhancements.

HBCIS APP2 - Appointment Scheduling Upgrade

Referral Source

The valid Referral Source codes are listed below:

 

Code

Description

01

GENERAL PRACTICE

02

EMERGENCY DEPARTMENT

03

SPECALIST OUTPATIENT DEPT

04

UNIT/WARD – INPATIENT

05

UNIT/WARD-PST DIS REVIEW

06

OTHER QLD HLTH HOSP

07

PRIVATE HOSPITAL

08

QLD HLTH PRIV PRACT BILL

09

OTH PRIV MED SPEC/CONSLT

10

CORRECTIONAL FACILITY

11

COMM HLTH SERVICE QLD HLTH

12

OTHER

99

NOT STATED/INADEQ DESCRIBED

 

APP2 location

Screen: APP2.S208 – Appointment Referral Entry

Field Position: 05

Actions Required

Insert referral source code into field  Referral Source -HKKMTX - start position 782 in extract 15 (include leading zero)

110

HKKMTX

A

20

 

782

L#20

N

5.1.02

MRI Occupation

Referral Source

EMG2

The Data is stored in APP.REFERALS attribute 26, which is linked by APPOINTMENTS attribute 27.

 


Payment Class

The valid Payment Class codes are listed below:

 

Code

Description

CS  

CORRECTIONAL SERVICES

CU  

UNSIGHTED MEDICARE CARD

DD  

DEPT. OF DEFENCE

DVA 

DEPT OF VETERANS AFFAIRS

MC  

MEDICARE

MVO 

MOTOR VEHICLE OTHER

MVOI

MOTOR VEHICLE OTH.INELIGIB.

MVQ 

MOTOR VEHICLE QLD

MVQI

MOTOR VEHICLE QLD INELIGIB.

NE  

NOT ELIGIBLE

RC  

RECIPROCAL COUNTRY

TPE 

THIRD PARTY ELIGIBLE

TPI 

THIRD PARTY INELIGIBLE

WCO 

WORKERS COMPENSATION OTHER

WCOI

WORKERS COMP OTH.INELIGIBLE

WCQ 

WORKERS COMPENSATION QLD

WCQI

WORKERS COMP QLD INELIGIBLE 

 

APP2 location

Screen: APP2.S208 – Appointment Referral Entry

Field Position: 06

Actions Required

Insert payment class code into field  Payment Class - HKOHCD - start position 861 in extract 15

128

HKOHCD

A

5

 

861

L#5

Y

5.1.02

MRI Payor Code 1

Payment Class

The Data is stored in APP.REFERALS attribute 27, which is linked by APPOINTMENTS attribute 27. (The 27 is a coincidence) The Data is also stored in Attribute 24 of the APPOINTMENTS record. Data is drawn preferentially from the Appointment Record, then the referral, and finally as before from the FIN-STATUS

 

Public/Private

APP2 location

Screen: APP2.S187 – Appointment Entry

Field Position: 08

Public/Private Business Rules

*         If field 08 of Appointment Entry Screen APP2.S187 is 1 (public patient) then insert value 0 into extract 15 record field Public/Private status HKE0NR - at start position 834

*         If field 08 of Appointment Entry Screen APP2.S187 is 2 (private patient) then insert value 1 into extract 15 record field Public/Private status HKE0NR - at start position 834

*          

119

HKE0NR

N

3

0

834

R#3

Y

5.1.02

MRI Group 8 Procs

Private Patient = 1

 

In Attribute 31 of APPOINTMENTS file, Data “1” is public, “2” is Private

 Note prior business rules for public private status in talons allocated 1 to private patients not public patients

 

Session Type

The valid Session Type codes are listed below:

 

Code

Description

01

INDIVIDUAL

02

GROUP

99

NOT STATED/INADEQU DESC

 

APP2 location

Screen: APP2.S187 – Appointment Entry

Field Position: 13

Session Type Business Rules

*         If field 13 of Appointment Entry Screen APP2.S187 is 01 then insert value “IND” into extract 15 record field  Care Type -HKR2CD - at start position 338

*         Else if field 13 of Appointment Entry Screen APP2.S187 is 02 then insert value “GRP” into extract 15 record field Care Type -HKR2CD at start position 338

*         Else insert value “NS” into extract 15 record field Care Type -HKR2CD at start position 338

33

HKR2CD

A

3

 

338

L#3

Y

5.1.02

MRI Admit Type

Care Type

In Attribute 32 of APPOINTMENTS file

 

Delivery Mode

The valid Delivery Mode codes are listed below:

 

Code

Description

01

IN PERSON

02

TELEPHONE

03

MAIL OR EMAIL

04

TELEHEALTH

 

APP2 location

Screen: APP2.S187 – Appointment Entry

Field Position: 14

Actions Required

 Insert Delivery Mode code into field Type of Visit HKR0CD - at start position 321 in extract 15 (include leading zero)

HKR0CD

A

4

 

321

L#

Y

5.2.01

MRI County

Type of Visit

n/a

 

Type of visit for EDIS - Delivery Mode for APP2

 

In Attribute 33 of APPOINTMENTS file

 

Sub Speciality Code

The APP2 screen is below

 

APP2.S15                    CLINIC CODES                       427 LOGON-QLDWRK

                                                                               

                                                                               

 01 Clinic Code  [XXXXXXXXXXXXXX]                                               

 02 Description  [XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX]                        

 03 Clinic Group [XXXXX]    XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

 04 Sub-Specialty Code [XX] XXXXXXXXXXXXXXXXXXXXXXXXX                           

 05 Print Daily Appointments (Y/N)                   [X]                       

 06 Daily Appointments                                                         

    Show Moved/Cancelled Appointments (Y/N)          [X]                        

 07 Daily Appointments by Location                                             

    Show Moved/Cancelled Appointments (Y/N)          [X]                       

 08 Print Diagnostic Imaging List (Y/N)              [X]                       

 09 Exclude from help lookup lists (Y/N)             [X]                       

 10 Doctor/Clinic Schedules                                                    

    Reallocate Bookings from Appointment Date (Y/N)  [X]                       

                                                                                

 11 Restrict Overbookings (Y/N)                      [X]                       

 12 Date Restriction to Commence                     [XX XXX XX]              

 13 Date Restriction to Finish                       [XX XXX XX]               

                                                                              

 14 Pre Admission Clinic (Y/N)                       [X]                       

 

Enter Field Number or Code                     Filed                          

 

APP2 location

Screen: APP2.S15 – Clinic Codes Field Position: 04

Actions Required

The field in Transition II that lists a Clinic Type is limited to Two Characters for this reason a mapping table from the HBCIS code set to a two characters HEXADECIMAL set is required. This table is included below. The business rules which follow are required for each sub speciality code as per this table

Insert Mapped T2 Sub Speciality Clinic Code into field  Clinic Type –HKR6CD- start position 407 in extract 15

 

Code

Abbreviated Description

Full Description

T2 code

1

AUDIOLOGY

AUDIOLOGY

01

2

CLINICAL PHARMACY

CLINICAL PHARMACY

02

3

DIABETES EDUCATION

DIABETES EDUCATION

03

4

NEUROPSYCHOLOGY

NEUROPSYCHOLOGY

04

5

NUTRITION/DIETETICS

NUTRITION/DIETETICS

05

6

OCCUPATIONAL THERAPY

OCCUPATIONAL THERAPY

06

7

OPTOMETRY

OPTOMETRY

07

8

ORTHOPTICS

ORTHOPTICS

08

9

ORTHOTICS

ORTHOTICS

09

10

PHYSIOTHERAPY

PHYSIOTHERAPY

0A

11

PODIATRY

PODIATRY

0B

12

PROSTHETICS

PROSTHETICS

0C

13

PSYCHOLOGY

PSYCHOLOGY

0D

14

SOCIAL WORK

SOCIAL WORK

0E

15

SPEECH PATHOLOGY

SPEECH PATHOLOGY

0F

16

STOMAL THERAPY

STOMAL THERAPY

10

17

WOUND MANAGEMENT

WOUND MANAGEMENT

11

18

DENTAL

DENTAL

12

19

MEDICAL IMAGING

MEDICAL IMAGING

13

20

AGED CARE (GERIATRICS)

AGED CARE (GERIATRICS)

14

21

IMMUNOLOGY - ALLERGY

IMMUNOLOGY – ALLERGY

15

22

IMMUNOLOGY - IMMUNOLOGY

IMMUNOLOGY – IMMUNOLOGY

16

23

ANTI-COAGULANT

ANTI-COAGULANT

17

24

CARDIOLOGY-CARDIOLOGY

CARDIOLOGY – CARDIOLOGY

18

25

CARDIOLOGY-PACEMAKER

CARDIOLOGY – PACEMAKER

19

26

CARDIOLOGY-STRESS TEST

CARDIOLOGY – STRESS TEST

1A

27

CARDIOLOGY-HOLTER CLINIC

CARDIOLOGY – HOLTER CLINIC

1B

28

CARDIOLOGY-HYPERTENSION

CARDIOLOGY – HYPERTENSION

1C

29

CLINICAL MEASUREMENT

CLINICAL MEASUREMENT

1D

30

DERMATOLOGY – DERMATOLOGY

DERMATOLOGY – DERMATOLOGY

1E

31

DERMATOLOGY – CRYOTHERAPY

DERMATOLOGY – CRYOTHERAPY

1F

32

DEMENTIA

DEMENTIA

20

33

DEVELOPMENTL DISABILITIES

DEVELOPMENTAL DISABILITIES

21

34

DIABETES/ENDOCRINE–DIABET.

DIABETES/ENDOCRINE – DIABETES

22

35

DIABETES/ENDOCRINE–ENDOCR.

DIABETES/ENDOCRINE – ENDOCRINE

23

36

DIABET/ENDOCRINE–THYROID

DIABETES/ENDOCRINE – THYROID

24

37

DIABET/ENDOCRINE–METABOLIC

DIABETES/ENDOCRINE – METABOL

25

38

EPILEPSY

EPILEPSY

26

39

FALLS

FALLS

27

40

GASTRONENTEROLOGY

GASTROENTEROLOGY

28

41

GENERAL INTERNAL MEDICINE

GENERAL INTERNAL MEDICINE

29

42

GENETIC

GENETIC

2A

43

HAEMATOLOGY

HAEMATOLOGY

2B

44

HEPATOBILIARY

HEPATOBILIARY

2C

45

HAEMOPHILIA

HAEMOPHILIA

2D

46

HYPERBARIC MEDICINE

HYPERBARIC MEDICINE

2E

47

INFEC DIS – INFEC DIS

INFECTIOUS DISEASES – INFECTIOUS DISEASES

2F

48

INFEC DIS – HEP B

INFECTIOUS DISEASES – HEPITATIS B

30

49

INFEC DIS – HEP C

INFECTIOUS DISEASES – HEPITATIS C

31

50

METOBOLIC BONE

METABOLIC BONE

32

51

NEPHROLOGY

NEPHROLOGY - NEPHROLOGY

33

52

NEPHROLOGY - RENAL

NEPHROLOGY – RENAL

34

53

NEUROLOGY

NEUROLOGY

35

54

OCCUPATIONAL MEDICINE

OCCUPATIONAL MEDICINE

36

55

ONCOLOGY - ONCOLOGY

ONCOLOGY – ONCOLOGY

37

56

ONCOLOGY – CHEMOTHERAPY

ONCOLOGY – CHEMOTHERAPY

38

57

ONCOL–MED ONCO CLINIC

ONCOLOGY – MEDICAL ONCOLOGY CLINIC

39

58

ONCOL-MED ONCO TREATMNT

ONCOLOGY – MEDICAL ONCOLOGY TREATMENT

3A

59

ONCOL-RADIAT ONCO CLINIC

ONCOLOGY – RADIATION ONCOLOGY CLINIC

3B

60

ONCOL-RADIAT ONCO TREAT

ONCOLOGY – RADIATION ONCOLOGY TREATMENT

3C

61

PALLIATIVE CARE

PALLIATIVE CARE

3D

62

PAIN MANAGEMENT

PAIN MANAGEMENT

3E

63

PHARMACOLOGY/TOXICOLOGY

PHARMACOLOGY/TOXICOLOGY – PHARMACOLOGY/TOXICOLOGY

3F

64

PHARM/TOXIC-ALCOHOL&DRUG

PHARMACOLOGY/TOXICOLOGY – ALCOHOL AND OTHER DRUG

40

65

REHABILITATION

REHABILITATION

41

66

RESP – ASTHMA

RESPIRATORY – ASTHMA

42

67

RESP – CYSTIC FIBROSIS

RESPIRATORY – CYSTIC FIBROSIS

43

68

RESP – SLEEP

RESPIRATORY – SLEEP

44

69

RESP – RESP

RESPIRATORY – RESPIRATORY

45

70

RESP – THORACIC

RESPIRATORY – THORACIC

46

71

RHEUMATOLOGY

RHEUMATOLOGY

47

72

SPINAL

SPINAL

48

73

TRANSPLANTS

TRANSPLANTS

49

74

FAMILY PLANNING

FAMILY PLANNING

4A

75

GYNAE-REPROD TECH-INFERT

GYNAECOLOGY – ASSISTED REPRODUCTIVE TECHNOLOGY (INFERTILITY)

4B

76

GYNAECOLOGY – COLPOSCOPY

GYNAECOLOGY – COLPOSCOPY

4C

77

GYNAECOLOGY – GYNAECOLOGY

GYNAECOLOGY – GYNAECOLOGY

4D

78

GYNAECOLOGY – MENOPAUSE

GYNAECOLOGY – MENOPAUSE

4E

79

GYNAECOLOGY – ONCOLOGY

GYNAECOLOGY – ONCOLOGY

4F

80

GYNAECOLOGY – PAP SMEAR

GYNAECOLOGY – PAP SMEAR

50

81

OBSTETRICS – OBSTETRICS

OBSTETRICS – OBSTETRICS

51

82

OBSTETRICS – ANTENATAL

OBSTETRICS – ANTE NATAL

52

83

OBSTETRICS – POSTNATAL

OBSTETRICS – POST NATAL

53

84

PATHOLOGY

PATHOLOGY

54

85

ADOLESCENT HEALTH

ADOLESCENT HEALTH

55

86

NEONATAL

NEONATAL

56

87

PAEDIATRIC – MEDICINE

PAEDIATRIC – MEDICINE

57

88

PAEDIATRIC – SURGERY

PAEDIATRIC – SURGERY

58

89

PAED-OTHER ASSESSMENT

PAEDIATRIC – OTHER – ASSESSMENT

59

90

PAED-OTHER-DEVELOPMENT

PAEDIATRIC – OTHER – DEVELOPMENT

5A

91

PAED-OTHER-REHABILITATION

PAEDIATRIC – OTHER – REHABILITION

5B

92

PHARMACY

PHARMACY

5C

93

PSYCHIATRY

PSYCHIATRY

5D

94

BREAST

BREAST

5E

95

BURNS

BURNS

5F

96

CARDIAC SURGERY – CARDIAC

CARDIAC SURGERY – CARDIAC

60

97

CARDIAC SURGERY-THORACIC

CARDIAC SURGERY – THORACIC

61

98

CARD SURG-CARDIO-THORASIC

CARDIAC SURGERY – CARDIO-THORASIC

62

99

COLORECTAL

COLORECTAL

63

100

CRANIOFACIAL

CRANIOFACIAL

64

101

EAR NOSE & THROAT - ENT

EAR, NOSE AND THROAT – ENT

65

102

ENT – MAXILLO FACIAL

EAR, NOSE AND THROAT – MAXILLO-FACIAL

66

103

EAR NOSE & THROAT - ORAL

EAR, NOSE AND THROAT – ORAL

67

104

GEN SURG – GEN SURG

GENERAL SURGERY – GENERAL SURGERY

68

105

GEN SURG – COLO-RECTAL

GENERAL SURGERY – COLO-RECTAL

69

106

NEUROSURGERY

NEUROSURGERY

6A

107

OPHTHALMOLOGY

OPHTHALMOLOGY

6B

108

ORTHOPAEDICS – ORTHOPAED.

ORTHOPAEDICS – ORTHOPAEDICS

6C

109

ORTHOPAEDICS – HAND

ORTHOPAEDICS – HAND

6D

110

ORTHOPAEDICS – FRACTURE

ORTHOPAEDICS – FRACTURE

6E

111

ORTHOPAEDICS – SCOLIOSIS

ORTHOPAEDICS – SCOLIOSIS

6F

112

PLASTIC SURGERY

PLASTIC SURGERY

70

113

PRE-ADMISSION

PRE-ADMISSION

71

114

ANAESTHETIC

ANAESTHETIC

72

115

UROLOGY

UROLOGY

73

116

VASCULAR SURGERY

VASCULAR SURGERY

74

117

OTHER SURGERY

OTHER SURGERY

75

118

EMERGENCY DEPARTMENT

EMERGENCY DEPARTMENT

76

 

 

HKR6CD

A

2

 

407

L#

N

5.2.01

MRI Clinic Type

Clinic Type

n/a

 

Clinic Type from Mapping table with APP2 sub specialty code

 

 

 

Attribute 31 of Clinics file, from CLINIC ID in APPOINTMENTS file Record ID, convert Code to HEX, gives us values for 00 to FF

 

Clinic Funding Source

APP2 screen

APP2.Snn              CLINIC FUNDING SOURCE CODES         442 LOGON-QLDWRK

APP2.S246                                                                               

                                                                               

      O1 Clinic Funding Source    [XX]                                       

                                                                                

      02 Description              [XXXXXXXXXXXXXXXXXXXXXXXXX]                  

                                                                               

      03 Public/Private           [X]

                                                                               

      04 Start Date               [DD MM YY]                                   

                                                                                

      05 End date                 [DD MM YY]                                                                                                              

                                                                          

                                                                                                                                                                                                                                           

                                                                                

Enter Field Number or Code                   Filed  [          ] 

 Table of Valid Values

Code

Abbreviated Description

Full Description

01

OPER’ING BUDGET–THIS HOSP

OPERATING BUDGET – THIS HOSPITAL

02

OTHER QLD HEALTH HOSPITAL

OTHER QUEENSLAND HEALTH HOSPITAL

03

QLD HLTH PRIV PRACT BILL

QUEENSLAND HEALTH PRIVATE PRACTICE BILL AGENCY

04

OTHER PRIVATE PRACTICE

OTHER PRIVATE PRACTICE

05

QLD HLTH TRUST FUND

QUEENSLAND HEALTH TRUST FUND

06

COMM HLTH BUDGET-QLD HLTH

COMMUNITY HEALTH BUDGET – QUEENSLAND HEALTH

07

ROYAL FLYING DR SERVICE

ROYAL FLYING DOCTOR SERVICE

08

OTHER

OTHER

99

NOT STATED/INADEQ DESCRIB

NOT STATED/INADEQUATLEY DESCRIBED

 

APP2 location

Screen: APP2.Snn – Clinic Funding Source Codes Field Position: 01

Actions Required

Insert Clinic Funding Source Code into field  Funding Source –HKDZHR- start position 610 in extract 15  - include leading zero from code set as above

 

HKDZNR

N

3

0

610

R%

Y

5.2.01

MRI Phone Exchange

Funding Source

n/a 

 

Funding Source From APP2

 

TBA Link to appropriate Source Data not identified as yet, information is only stored on TEMPLATES and not at detail APPOINTMENT record level.

 

New Repeat Status

APP2 screen

APP2.Snn                   NEW/REPEAT STATUS             442 LOGON-QLDWRK                                                                                 

                                                                              

      O1 New/Repeat Status     [XX]                                       

                                                                                

      02 Description              [XXXXXXXXXXXXXXXXXXXXXXXXX]                  

                                                                               

      03 Start Date               [DD MM YY]                                   

                                                                               

      04 End date                 [DD MM YY]                                   

                                                                                

NOTES

-----------------

       The following codes must not be altered:

1.         Code  N – NEW

2.         Code  R – REPEAT

3.         Code  O - OTHER                                                                           

                                                                        

                                                                               

Enter Field Number or Code                   Filed  [          ]       

 Table of Valid Values

Note sites may add additional codes to the above list

APP2 location

Screen: APP2.Snn – New/repeat Status Field Position: 01

Actions Required

Insert New/repat Status Code into field  Admission Status –HKSFCD- start position 615 in extract 15 -

 

HKSFCD

A

2

 

615

L#

Y

5.2.01

MRI Patient Type

Admission Status

ADM

85

For inpatients 1=Emergecy,

2=Elective 3=Other For APP2 New/Repeat Status codes

 

Attribute 2 of APPOINTMENTS file.