/* SHORT TITLE: Codebook for Medical Record Abstract - Patient */
********************************************************************************
* W E S T A T C O D E B O O K *
* ----------- --------------- *
* *
* STUDY OF HEALTH CARE COSTS *
* WESTAT PROVIDER SURVEY MEDICAL ABSTRACT FORM - PUBLIC USE *
* 30 JUNE 1994 *
********************************************************************************
********************************************************************************
* W E S T A T C O D E B O O K *
* ----------- --------------- *
* *
* STUDY OF HEALTH CARE COSTS *
* WESTAT PROVIDER SURVEY MEDICAL ABSTRACT FORM - PUBLIC USE *
* 30 JUNE 1994 *
********************************************************************************
(0)
27 Jun. 1994
Record 01
STUDY OF HEALTH CARE COSTS
WESTAT PROVIDER SURVEY MEDICAL ABSTRACT FORM - PUBLIC USE
30 JUNE 1994
Question Column
Name Number(s)
________ _________
UBAT01 001-005 ALWAYS BLANK
____________
+ = ALWAYS BLANK
UPID01 006-014 PATIENT NUMBER
______________
000000001-
999999999 = RANDOMLY ASSIGNED SEQUENTIAL NUMBER
UREC01 015-016 RECORD NUMBER
_____________
01 = RECORD NUMBER
USREC01 017-018 SUBRECORD NUMBER
________________
00 = NOT A REPEATING RECORD
UFIL101 019 FIRST FILLER ON RECORD 01
_________________________
+ = ALWAYS BLANK
THE MEDICAL ABSTRACT DATA FILES CONTAIN SELECTED CLINICAL INFORMATION ABSTRACTED FROM
STUDY SUBJECTS' MEDICAL RECORDS. THESE FILES ARE INTENDED TO PROVIDE THE USER WITH
INFORMATION ABOUT A SUBJECT'S CLINICAL HISTORY AND ARE NOT AN APPROPRIATE SOURCE FOR
OBTAINING PATIENT LEVEL UTILIZATION COUNTS. USERS INTERESTED IN SUCH ANALYSES SHOULD USE
THE PATIENT INTERVIEW OR PROVIDER BILLING FILES INSTEAD.
DURING THREE OF SIX PATIENT INTERVIEWS, SUBJECTS WERE ASKED TO INDICATE THEIR USUAL
SOURCE OF MEDICAL CARE. SUBJECTS WERE ASKED TO SIGN PERMISSION FORMS AUTHORIZING STUDY
PERSONNEL TO CONTACT THE NAMED PROVIDERS FOR PURPOSES OF OBTAINING ACCESS TO SUBJECTS'
MEDICAL RECORDS. IF A SUBJECT REPORTED HAVING MORE THAN ONE USUAL SOURCE OF CARE, AN
ATTEMPT WAS MADE TO OBTAIN MEDICAL RECORDS FROM ALL SOURCES. THE DATA CONTAINED IN THESE
FILES REFLECT INFORMATION ABSTRACTED FROM THE SUBJECTS' MEDICAL RECORDS AND MAY REPRESENT
DATA COLLECTED FROM MORE THAN ONE MEDICAL PROVIDER.
(1)
27 Jun. 1994
Record 01
Question Column
Name Number(s)
________ _________
URDATE (020-031) RECORD REVIEW PERIOD
THIS SET OF DATE VARIABLES ARE DERIVED FROM THE EARLIEST AND LATEST MEDICAL RECORD
REVIEWED FOR AN INDIVIDUAL ACROSS ALL MEDICAL ABSTRACTS. IT DOES NOT REFLECT GAPS IN
MEDICAL RECORD COVERAGE OCCURING BETWEEN THESE DATES. MEDICAL ABSTRACTORS WERE
INSTRUCTED TO COLLECT CLINICAL INFORMATION FOR HEALTH CARE SERVICES PROVIDED DURING THE
PERIOD BEGINNING JANUARY 1, 1990 AND ENDING AUGUST 31, 1992. THE REVIEW PERIOD FOR AN
INDIVIDUAL MAY SPAN AS WIDE A PERIOD AS 1/1/90 THROUGH 8/31/92 OR SOME PORTION OF THIS
PERIOD. FACTORS SUCH AS THE COMPLETENESS OF A SUBJECT'S MEDICAL RECORD, PROVIDER
RESPONSE RATE, AND STUDY SUBJECT SURVIVAL TIME AFFECT THE LENGTH OF THE REVIEW PERIOD.
URDTF (020-025) DATE OF EARLIEST RECORD REVIEWED
________________________________
URMOF 020-021 MONTH OF EARLIEST RECORD REVIEWED (DERIVED)
___________________________________________
01-12 = MONTH
99 = NOT ASCERTAINED
URDYF 022-023 DAY OF EARLIEST RECORD REVIEWED (DERIVED)
_________________________________________
01-31 = DAY
99 = NOT ASCERTAINED
URYRF 024-025 YEAR OF EARLIEST RECORD REVIEWED (DERIVED)
__________________________________________
90-92 = YEAR
99 = NOT ASCERTAINED
URDTL (026-031) DATE OF LAST RECORD REVIEWED
____________________________
(2)
27 Jun. 1994
Record 01
Question Column
Name Number(s)
________ _________
URMOL 026-027 MONTH OF LATEST RECORD REVIEWED (DERIVED)
_________________________________________
01-12 = MONTH
99 = NOT ASCERTAINED
URDYL 028-029 DAY OF LATEST RECORD REVIEWED (DERIVED)
_______________________________________
01-31 = DAY
99 = NOT ASCERTAINED
URYRL 030-031 YEAR OF LATEST RECORD REVIEWED (DERIVED)
________________________________________
90-92 = YEAR
99 = NOT ASCERTAINED
HIV POSITIVE DIAGNOSIS (UHIV) DIAGNOSIS (UHDIAG) AND REPORT DATES (UHIVRD):
THESE VARIABLES WERE DERIVED TO REPRESENT THE BEST INFORMATION AVAILABLE ACROSS ALL
MEDICAL ABSTRACT FORMS FOR AN INDIVIDUAL. A SUBJECT IS CODED AS HAVING A POSITIVE
DIAGNOSIS IF AT LEAST ONE MEDICAL ABSTRACT CONFIRMED A DIAGNOSIS. THE CORRESPONDING
DIAGNOSIS AND REPORT DATES FROM THAT ABSTRACT ARE CODED IN UHDIAG AND UHIVRD. IF
MULTIPLE ABSTRACTS INDICATED A POSITIVE SEROSTATUS, THE THE EARLIEST DIAGNOSIS AND REPORT
DATES ARE CODED. THE SUBJECT IS CODED AS NOT HAVING A POSITIVE HIV DIAGNOSIS IF NONE OF
THE MEDICAL ABSTRACTS FOR THAT PATIENT CONFIRMED A DIAGNOSIS. A SUBJECT'S SEROSTATUS IS
UNKNOWN IF ALL MEDICAL ABSTRACTS REPORTED AN UNKNOWN STATUS.
UHIV 032 HIV POSITIVE DIAGNOSIS (DERIVED)
________________________________
* 0 = NO
1 = YES
3 = INCONCLUSIVE
* 9 = UNKNOWN, RECORD DOES NOT STATE HIV+ OR HIV-
* SKIP UHDIAGMO - UHRDYR
UHDIAG (033-038) DATE OF HIV POSITIVE DIAGNOSIS
______________________________
(3)
27 Jun. 1994
Record 01
Question Column
Name Number(s)
________ _________
UHDIAGMO 033-034 DATE OF HIV DIAGNOSIS - MONTH (DERIVED)
_______________________________________
+ = INAPPLICABLE, CODED 0 OR 9 IN UHIV, COL 32, REC 01.
01-12 = MONTH
99 = NOT ASCERTAINED
UHDIAGDY 035-036 DATE OF HIV DIAGNOSIS - DAY (DERIVED)
_____________________________________
+ = INAPPLICABLE, CODED 0 OR 9 IN UHIV, COL 32, REC 01
01-31 = DAY
99 = NOT ASCERTAINED
UHDIAGYR 037-038 DATE OF HIV DIAGNOSIS - YEAR (DERIVED)
______________________________________
+ = INAPPLICABLE, CODED 0 OR 9 IN UHIV, COL 32, REC 01.
75-91 = YEAR
99 = NOT ASCERTAINED
UHIVRD (039-044) DATE HIV FIRST REPORTED IN RECORD
_________________________________
UHRDMO 039-040 DATE HIV FIRST REPORTED IN RECORD - MONTH (DERIVED)
___________________________________________________
+ = INAPPLICABLE, CODED 0 OR 9 IN UHIV, COL 32, REC 01
01-12 = MONTH
99 = NOT ASCERTAINED
UHRDDY 041-042 DATE HIV FIRST REPORTED IN RECORD - DAY (DERIVED)
_________________________________________________
+ = INAPPLICABLE, CODED 0 OR 9 IN UHIV, COL 32, REC 01
01-31 = DAY
99 = NOT ASCERTAINED
(4)
27 Jun. 1994
Record 01
Question Column
Name Number(s)
________ _________
UHRDYR 043-044 DATE HIV FIRST REPORTED IN RECORD - YEAR (DERIVED)
__________________________________________________
+ = INAPPLICABLE, CODED 0 OR 9 IN UHIV, COL 32, REC 01
83-92 = YEAR
99 = NOT ASCERTAINED
AIDS DIAGNOSIS (UAIDS), DIAGNOSIS (UADIAG) AND REPORT DATES (UAIDRD):
THESE DATA ITEMS FOLLOW THE SAME APPROACH AS THE HIV POSITIVE DIAGNOSIS AND REPORT DATE
VARIABLES. IF AT LEAST ONE MEDICAL ABSTRACT STATED THAT THE INDIVIDUAL WAS DIAGNOSED
WITH AIDS, THE SUBJECT IS CODED AS HAVING AN AIDS DIAGNOSIS. IF MULTIPLE ABSTRACTS
INDICATED AN AIDS DIAGNOSIS, THEN THE EARLIEST DIAGNOSIS AND REPORT DATES ARE CODED IN
UADIAG AND UAIDRD. A SUBJECT IS CODED AS NOT HAVING AN AIDS DIAGNOSIS IF NONE OF THE
MEDICAL ABSTRACTS CONFIRMED A DIAGNOSIS. IF ALL MEDICAL RECORDS STATED THAT IT WAS
UNKNOWN WHETHER THE SUBJECT HAD A DIAGNOSIS OF AIDS, UAIDS IS UNKNOWN.
UAIDS 045 AIDS DIAGNOSIS (DERIVED)
________________________
* 0 = NO, PATIENT DOES NOT HAVE AIDS
1 = YES, PATIENT HAS AIDS
* 9 = UNKNOWN, RECORD DOES NOT STATE WHETHER OR NOT PATIENT HAS AIDS.
* SKIP UADIAGMO - UAIDRDYR
UADIAG (046-051) DATE OF AIDS DIAGNOSIS
______________________
UADIAGMO 046-047 DATE OF AIDS DIAGNOSIS - MONTH (DERIVED)
________________________________________
+ = INAPPLICABLE, CODED O OR 9 IN UAIDS, COL 45, REC 01.
01-12 = MONTH
99 = NOT ASCERTAINED
UADIAGDY 048-049 DATE OF AIDS DIAGNOSIS - DAY (DERIVED)
______________________________________
+ = INAPPLICABLE, CODED 0 OR 9 IN UAIDS, COL 45, REC 01.
01-31 = DAY
99 = NOT ASCERTAINED
(5)
27 Jun. 1994
Record 01
Question Column
Name Number(s)
________ _________
UADIAGYR 050-051 DATE OF AIDS DIAGNOSIS - YEAR (DERIVED)
_______________________________________
+ = INAPPLICABLE, CODED 0 OR 9 IN UAIDS, COL 45, REC 01
76-91 = YEAR
99 = NOT ASCERTAINED
UAIDRD (052-057) DATE AIDS FIRST REPORTED IN RECORD
__________________________________
UAIDRDMO 052-053 DATE AIDS FIRST REPORTED IN RECORD - MONTH (DERIVED)
____________________________________________________
+ = INAPPLICABLE, CODED 0 OR 9 IN UAIDS, COL 45, REC 01
01-12 = MONTH
99 = NOT ASCERTAINED
UAIDRDDY 054-055 DATE AIDS FIRST REPORTED IN RECORD - DAY (DERIVED)
__________________________________________________
+ = INAPPLICABLE, CODED 0 OR 9 IN UAIDS, COL 45, REC 01
01-31 = DAY
99 = NOT ASCERTAINED
UAIDRDYR 056-057 DATE AIDS FIRST REPORTED IN RECORD - YEAR (DERIVED)
___________________________________________________
+ = INAPPLICABLE, CODED 0 OR 9 IN UAIDS, COL 45, REC 01
84-92 = YEAR
99 = NOT ASCERTAINED
(6)
27 Jun. 1994
Record 01
Question Column
Name Number(s)
________ _________
UFIL201 058-132 SECOND FILLER ON RECORD 01
__________________________
+ = ALWAYS BLANK
INFORMATION ON INPATIENT STAYS, OUTPATIENT/CLINIC CHECKLIST CONDITIONS AND LABORATORY
REPORTS OF T -CELL COUNTS EXIST IN THE FILES AS A SERIES OF REPEATING RECORDS. BECAUSE
DATA FOR A SUBJECT MAY HAVE BEEN COLLECTED FROM MORE THAN ONE MEDICAL PROVIDER, EACH
REPEATING RECORD HAS A PROVIDER IDENTIFICATION NUMBER THAT INDICATES THE SOURCE OF THE
INFORMATION. THIS ID IS CONTAINED IN THE FOLLOWING VARIABLES:
USID02 - INPATIENT STAY - INPATIENT.MEDICAL.RECORD.CODEBOOK
USID03 - OUTPATIENT CLINIC CHECKLIST CONDITIONS - CHKLST.RECORD.CODEBOOK
USID04 - T-CELL COUNTS - TCELL.MEDICAL.RECORD.CODEBOOK
SINCE THE MEDICAL DATA REPRESENT INFORMATION COLLECTED FROM MULTIPLE PROVIDERS THERE ARE
SITUATIONS WHERE DATA OVERLAP, ARE DUPLICATIVE, OR DISCREPANT ACROSS PROVIDERS. IN CASES
OF APPARENT OVERLAPS OR DISCREPANCIES, THE DATA HAVE BEEN EDITED FOR KEYING AND CODING
ERRORS ONLY.
(7)
27 Jun. 1994
Record 01
Question Column
Name Number(s)
________ _________
INDEX OF VARIABLES PAGE 001
Variable Name Column Numbers Record Number Codebook Page No.
------------- -------------- ------------- -----------------
===== U =====
UADIAG (046-051) Record 01 005
UADIAGDY 048-049 Record 01 005
UADIAGMO 046-047 Record 01 005
UADIAGYR 050-051 Record 01 006
UAIDRD (052-057) Record 01 006
UAIDRDDY 054-055 Record 01 006
UAIDRDMO 052-053 Record 01 006
UAIDRDYR 056-057 Record 01 006
UAIDS 045 Record 01 005
UBAT01 001-005 Record 01 001
UFIL101 019 Record 01 001
UFIL201 058-132 Record 01 007
UHDIAG (033-038) Record 01 003
UHDIAGDY 035-036 Record 01 004
UHDIAGMO 033-034 Record 01 004
UHDIAGYR 037-038 Record 01 004
UHIV 032 Record 01 003
UHIVRD (039-044) Record 01 004
UHRDDY 041-042 Record 01 004
UHRDMO 039-040 Record 01 004
UHRDYR 043-044 Record 01 005
UPID01 006-014 Record 01 001
URDATE (020-031) Record 01 002
URDTF (020-025) Record 01 002
URDTL (026-031) Record 01 002
URDYF 022-023 Record 01 002
URDYL 028-029 Record 01 003
UREC01 015-016 Record 01 001
URMOF 020-021 Record 01 002
URMOL 026-027 Record 01 003
URYRF 024-025 Record 01 002
URYRL 030-031 Record 01 003
USREC01 017-018 Record 01 001