Safety in Mines Research Advisory Committee Final Project Report The development of an occupational diseases database, to be managed by the Department of Minerals and Energy
Yüklə 0,49 Mb. Pdf görüntüsü
|
- Bu səhifədəki naviqasiya:
- 4.3.3 Main Working Tables D3 – PERSONAL DISEASE RECORD
- D3 – PERSONAL DISEASE RECORD
- D4 – OCCUPATIONAL HISTORY
- D5 – ANNUAL WORKFORCE
- 4.3.4 Code Lists, Diseases M1 – DISEASE
- M2 – DISEASE GROUP
- 4.3.5 Code Lists, General C3 – COMPENSATION SUBMISSION RESULT TYPE
- C4 – COMPENSATION SUBMISSION RESULT ITEM
- C5 – REPORTING CENTRE
|
D2 – PERSONAL IDENTIFICATION Key Field Name Fmt Description **+
PersonNumber LI Internally-used identifier for person's records. ** IDTypeCode C1 Code for type of ID. Valid values: (N) SA National ID; (P) Passport; (I) Industry Number; (F) PF Number; or (T) TEBA Number. IDNumber
C20 The number of an issued ID. Notes: • There must be at least one Personal Identification record for each Person record. • There may be at most one of each IDTypeCode for a Person. A- 20
D3 – PERSONAL DISEASE RECORD Key Field Name Fmt Description **+
PersonNumber LI Internally-used identifier for patient's records. **+
DiseaseCode C4 National code for disease. ** EntryDate D Date examined or diagnosed. (+) PreviousEntryDate D Previous date examined or diagnosed for this disease, if any. This date is used for linking several Personal Disease Records together, typically when a subsequent diagnosis shows a change in the patient’s condition. May be null. See note below. + MineCode SI Current employer of patient, or previous employer if unemployed. (Mine Code used by Minerals Bureau.) + RepCentreCode C4 “Submitted by” – code for the centre which reported the disease to the database. MineRefNo C10 The mine’s (or “submitter’s”) case number for this disease occurrence. (+)
CCCentreCode C4 RepCentreCode for the MBOD, RMA or CC that issued the CCRefNo. (Only those Centre Types with IsCompCom==True can be referenced here.) CCRefNo
C10 MBOD, RMA or CC’s case number for this disease occurrence. UserID
C8 Login UserID of user who entered data. SystemDate D Date record was entered in this database. EmployeeID C16
The employee’s current company number, if available. MonthsInMining SI Number of months the patient had been working in the mining industry when the disease was diagnosed. IsNotifiable L Whether the disease is serious enough to be Notifiable. Default is False. See note below.
NotifiableReason C16
Why Notifiable. Used in various ways; see note below. SubmittedToCC L Whether submitted for a Compensation hearing. DateSubmitted D Date submitted for a Compensation hearing. DateReturned D Date returned from a Compensation hearing. A- 21
Key Field Name Fmt Description IsCompensable C1 Whether Compensable. Possible values are: (Y) Yes, (N) No and (U) Undecided. U is the default. CompensableReason C16
Why Compensable. Used in various ways; see Note, below. + ResultTypeCode C2 Code for type of result. Not accessible to the user. See notes below. (+)
ResultCode C3 Code for final result of compensation submission. Default null. CompensablePPD SI Result of Compensation hearing, giving severity as a percentage permanent disablement. Default zero. See note below. DiseaseCausedDeath C1 Whether the patient died as a result of the disease. Possible values are: (Y) Yes, (N) No and (U) Undecided (meaning that the patient died, but the cause has not yet been determined). The default is N. EmployStatusChanged L Whether the patient had to change employment permanently as a result of the disease.
DateEmployChanged D Date the patient had to change employment as a result of the disease. May be null. IsDeleted L Records will not normally be physically deleted, but will be marked as deleted, to remove them from view. Notes: • There could be a further diagnosis because of deterioration or death. This should result in the creation of a new record, which would need to be related to the original record, by means of PreviousEntryDate. A parent record may have several child records, but only one level of parent-child relationship between records should be permitted, as follows: • If the Personal Disease Record’s PreviousEntryDate is null, the record is neither a parent nor a child. • If PreviousEntryDate is the same as its own EntryDate, the record is a parent. • Otherwise, the record is a child, whose parent record has the key PersonNumber + DiseaseCode + PreviousEntryDate (extracted from the current record). • The NotifiableReason is used in different ways, depending on the Disease Group. • For NIHL, it will be a map of logical flags (“NNYYNNN…”) for the 15 and 20 dB loss measurements. The default contents are: sixteen N’s, being eight N’s each, for the 15 and 20 dB loss measurements, regardless of the (smaller) number of characters on the screen. The user may change any of the displayed N’s to a Y, in which case, the IsNotifiable flag will be automatically set to True.
A- 22 • For PNEU (the Pneumoconioses), it will store 5 or 6 characters, e.g. “p 2/2”. These are not interpreted by the software. Default is an empty string. The user must set the IsNotifiable flag manually. • For CRTB (Tuberculosis), it will be an Initial ResultCode; i.e. a partial foreign key into the Compensation Submission Result Item table. There will thus be two ResultCodes in a CRTB record (after the compensation result has been returned). Default is an empty string. • For COAD, it will be a map of logical flags (e.g. “YNN”) for the 3 measure- ments. Default is “NNN”. • The CompensableReason is used in different ways, depending on the Disease Group. • For NIHL, it will be the average hearing loss measurement. • It is unused (empty) for the other Disease Groups. • ResultTypeCode is copied from the applicable Disease record when the Personal Disease Record is created. • It is envisaged that the ResultTypeCode may change at some stage for certain diseases, if ODMWA is incorporated into COIDA. This will be handled as a one-off adjustment to the contents of the database, and is not catered for in the system design. •
the Compensation Submission Result Type for the Disease. • For ResultDataType==N, it will be the percent permanent disablement (% PD) attributed to the disease. (In these cases, ResultCode will be the only valid value: PPD.) Generally, 0 % will be displayed as “NCD”. • For ResultDataType==R, it will be a copy of the NominalPPD for the relevant Compensation Submission Result Item, for interest only – it will not be used in statistical or other calculations at this stage of the system design.
**+
PersonNumber LI Internally-used identifier for person's records. **+
MineCode SI Mine Code used by Minerals Bureau. **+ SamOccupationID C6 SAMRASS Occupation code. ** DateFrom
D The date on which this period of employment started. DateTo
D The date on which this period of employment ended. See note below. EmployeeID C16 The employee’s company number, if available. Terminated L Whether employment terminated with this employer on DateTo. This is usually only of significance for the last record of a series, to show whether the employee was still in service after the date of diagnosis. Reliability TI Code for the perceived reliability of this record, on a scale of 1 to 5. See note below.
A- 23
• For the current employer (if any), DateTo must be ≥ EntryDate (i.e. date examined or diagnosed), and Terminated will be False. • Initially, it is intended to treat an Occupational History record as either Confirmed or Unconfirmed. Usually, data from the reporting centre’s own records will be “Confirmed”; this would typically be an employer’s own records of the employee’s service. Details of previous employment would be regarded as “Unconfirmed”, unless documentary evidence has been produced to the current employer. The Reliability code will be used for this, and its valid values are given in the following table:
Reliability Code Meaning Comment 3 Unconfirme d The data is as reported to the reporting centre, and has not been verified. (Default value.)
5 Confirmed The data has been verified. • At some future time, the Reliability code may be used for a more detailed indication of the reliability of the Occupational History data. The values of the Reliability code could then be as given in the following table: Reliability Code Meaning Comment 1 Very poor The data is considered very unreliable. 2 Poor The data is not very reliable. 3 Average The data is fairly reliable. (Default value.) 4 Good The data is probably correct. 5 Very good The data is almost certainly correct. A- 24
Key Field Name Fmt Description **+
MineCode SI Mine Code used by Minerals Bureau. ** YearNo
SI Number of year for records, eg 1998. NoOfWorkers LI Total number of workers on the mine for the year. See note, below. NoOfSfcWorkers LI Total number of surface workers on the mine for the year. NoOfUgWorkers LI Total number of underground workers on the mine for the year. NoOfOCWorkers LI Total number of open-cast workers on the mine for the year. NoOfSeaWorkers LI Total number of at-sea workers on the mine for the year. NoOfRiskWorkers LI Total number of health risk workers on the mine for the year. Health risk workers are those persons working on the mine who have periodic medical surveillance examinations, regardless of where they work.
• A reporting year (represented by YearNo) is a calendar year. • The NoOfWorkers (etc.) is regarded as the average of the monthly averages. This is calculated on the Mine. • Currently, SAMRASS gets the previous month’s (not year’s) figures on the Accident Report Form, and the DME does not have easy access to annual figures. • We intend to let the Mines submit these annual figures on their Disease Input Forms, and only raise a query if the figures are inconsistent with previously entered data. A- 25
M1 – DISEASE Key Field Name Fmt Description ** DiseaseCode C4 National code for disease 9 .
C40 Name of disease for display on screen. DiseaseDefinition VC255
More technical name of disease. GoverningAct VC255 Act of Parliament governing notification of this disease. OtherRegulations VC255 Other Acts or Regulations pertaining to notification of this disease. NotifyRules VC255 Free-form brief description of rules for notification of this disease. CompensRules VC255 Free-form brief description of rules for compensation applications for this disease. NotesOnDisease VC255 Further explanatory notes on this disease. DateMeaning C1 Whether the EntryDate for this disease means “Date Examined” (E), or “Date Diagnosed” (D). Default is D. + DiseaseGroupCode C4 The Disease Group controls which data entry form should be used. + ResultTypeCode C2 Code for type of result currently being used for this disease. Used as a default for a Personal Disease Record. Notes: • The initial records in the Disease table are shown in the following table. Not all fields are shown: some are left open for the DME’s use. The descriptions are taken from the COID and ODMW Acts.
9 Consideration was given to using ICD10 (a disease coding system of the International Classification of Diseases) as the DiseaseCode. Three descriptors which may be used for any disease occurrence are Disease Code, External Cause and Body Part. It was also found that several Disease Codes covered a single disease (as defined in the Occupational Diseases Database). These considerations led to the conclusion that the ICD10 coding system would over- complicate the database. A- 26
Disease Name Code Date Result Type NIHL
Noise Induced Hearing Loss NIHL
E PD PNEU Silicosis SLCS
E DG Coal Workers Pneumoconiosis CWPN
E DG Asbestosis ASBS E DG Hard Metal Pneumoconiosis HMPN
E DG Stannosis STAN E DG CRTB Cardiorespiratory Tuberculosis CRTB
D DT COAD Chronic Obstructive Airways Disease
COAD D DG HEAT Heat Exhaustion HEEX D
Heat Stroke HEST
D PD OTHR Silica-tuberculosis SITB
D DG Scleroderma SCLR D DG Platinosis PLAT
D DG Malignant mesothelioma MESO D DG Pleural plaques or thickening PLPL
D DG Lung cancer LCAN D DG Chronic manganese poisoning MNPO D
Bronchiolitis obliterans BROB
D PD Barotrauma ... in miners BARO D PD Any disease ... due to lead LEAD
D PD Any disease ... due to cadmium CADM
D PD Any disease ... due to chromium CHRO
D PD Any disease ... due to mercury MERC
D PD Any disease ... due to manganese or cyanide MNCY
D PD Hand-arm vibration syndrome HVIB D PD Asphyxiation due to carbon monoxide, etc. ASFX D
A- 27
Key Field Name Fmt Description ** DiseaseGroupCode C4 Code for group of diseases. See list below. DiseaseGroupName C60
Name of group of diseases. MaxPPD
SI Maximum % PD that is valid for this group. CanCauseDeath L Whether diseases in this group can (more or less directly) cause a patient’s death. Notes: • Each Disease Group will have its own data input screen. • Only the System Manager will be permitted to add or delete records in this table. • For any Disease Group that CanCauseDeath, MaxPPD must be 100. • The supplied records in the Disease Group table are listed in the following table. Also shown is the ResultTypeCode normally associated with Diseases in the Group.
Code Name MaxPPD Death Result Type NIHL
Noise Induced Hearing Loss 50 N PD PNEU
Pneumoconioses 100
Y DG CRTB Cardiorespiratory Tuberculosis 100
Y DT COAD Chronic Obstructive Airways Disease
100 Y DG HEAT Heat-related Illness 100 Y
OTHR Other Occupational Diseases 100 Y
DG 4.3.5 Code Lists, General C3 – COMPENSATION SUBMISSION RESULT TYPE Key Field Name Fmt Description ** ResultTypeCode C2 Code for type of result. ResultTypeName C20
Name of type of result. ResultDataType C1 Whether (N) numeric or (R) reference into a list. Notes: • The valid values of the ResultTypeCode, with the ResultDataType, are given in the following table: Code Name Data Type PD Percent PD N DG Degree (general) R DT Degree (TB) R A- 28 • The software will interpret the ResultDataType; if it is “N”, the Result Item will not be interpreted as a value (for severity of a disease); the % PD will be recorded in the Personal Disease Record table.
**+
ResultTypeCode C3 Code for type of result. ** ResultCode C2 Code for result of compensation submission. ResultName C40 Name of result. ResultStageCode C1 Code for stage of result. Valid values are: (P) Primary only; (S) Secondary only; (B) Both.
NominalPPD SI Nominal percentage permanent disablement for this result. UpperPPD
SI Upper percentage permanent disablement for this result.
• The PPD fields might be useful if a conversion has to be done from one Result Type to another. At this stage of system development, they are for interest only. • The ResultStageCode applies particularly to the CRTB Disease Group, where treatment is given upon diagnosis, and compensation is given for loss of earnings during treatment. After treatment, a re-submission is made, which may result in compensation for a permanent disability. Hence, in the following table, TBC is the only Item with Stage==P. • The valid values of the Result Items for the various Result Types are given in the following table. Result Type Result Code Name Stage Nom PPD Up PPD PD PPD % PD B 0 0 DG NCD NCD B 0 1DE First degree B 2DE
Second degree B DT NCD NCD
B 0 TBC TB Current P 0 1DE First degree B 2DE
Second degree B • If the development environment supports it, a display of “1º” or “2º” will be preferred, instead of “First degree” or “Second degree”. • NCD means No Compensable Disease. A- 29
Key Field Name Fmt Description ** RepCentreCode C4 Code for the centre which reported the disease to the database. See note, below. RepCentreName C80 Name of the centre which reported the disease. + RepCentreTypeCode C2 Code for type of reporting centre. Comment C80
Free-form comment on this reporting centre.
Notes: • If the Reporting Centre is a Mine (i.e. RepCentreTypeCode==MI), RepCentreCode will be the Mine Code from the Mines table, and will be a full 4-digit number (e.g. 0045), otherwise, RepCentreCode will start with an alphabetic character. Spaces should be discouraged. • The initial records in the table are the full Mines table, and those given below. Code Name Type CCLP
Compensation Commissioner, Dept of Labour, Pretoria CC CCHJ
Compensation Commissioner, Dept of Health, Johannesburg CC MBOD
Medical Bureau for Occupational Diseases CC RMAC Rand Mutual Assurance Co. AC • Other records may be added to the table. The software will allow automatic creation of Mine records in the table by selection from a picklist of records from the Mines table.
Yüklə 0,49 Mb. Dostları ilə paylaş:
|