Attachment_4_Data_Dictionary.pdf

ATTACHMENT 4

DATABASE DATA DICTIONARY

OPERATION, MAINTENANCE, AND MODIFICATION

OF HUMAN STUDIES FACILITY

HUMAN STUDIES DATABASE

DATA DICTIONARY

January 26, 2005 ii

TABLE OF CONTENTS

1.0 INTRODUCTION ..............................................................................................................................................1-1

2.0 TABLE DEFINITIONS .....................................................................................................................................2-1

3.0 ORACLE ACCOUNTS ......................................................................................................................................3-1

4.0 CODING DICTIONARY ...................................................................................................................................4-1

January 26, 2005 1−1

1.0 INTRODUCTION

The goal for an integrated database for Human Studies data is to provide centralized control of the acquisition and analysis data collected at the EPA human studies facilities. The advantages for maintaining centralized control and management include data shareability, standardization of data items, reduced data redundancy, data consistency, security, data integrity, and data independence.

To meet this goal, the ORACLE Relational Database Management System (RDBMS) was selected to manage the

Human Studies data. The ORACLE RDBMS utilities include monitoring tools, backup and recovery facilities, audit trail capabilities, user interface flexibility, and, most importantly, a data dictionary.

This document defines the current structure of the Human Studies data dictionary. Chapter Two describes the table definitions currently in use at the Human Studies Facility. Chapter Three defines the ORACLE accounts and the tables owned by those accounts. Chapter Four defines the coding dictionary.

This document does not attempt to describe the Human Studies Database design and the relationships between data elements. Please refer to the document, Specifications for the Human Studies Database (EMSI12102.110DBS) for further reading.

January 26, 2005 1−2

January 26, 2005 2−1

2.0 TABLE DEFINITIONS

This chapter defines the table definitions in use at the Human Studies Facility. Each table is described and the columns for the table are defined. The column attributes are:

• Column Name - Name of the column.

• Column Description - Textual description of the column.

• Codename - If the data element is coded, this field defines the codename that may be referenced in the code dictionary.

• Data Type - Type of data of the column.

• Data Length - Maximum data length of the column.

• Data Prec - Number of places to the right of the decimal point. If blank, and the data type of the column is a number, value is assumed to be integer.

• Data Units - Units specification for the column.

• Null? - Is this field allowed to be null; Y=yes, N=no.

All active tables are stored on magnetic disk and backed up on magnetic tape. When studies are completed, tables or parts thereof are exported and stored off-line on magneto-optical disk. All tables designated with the superscript contain Laboratory Information Management Systems (LIMS) Raw Data or LRD. These tables are subject to special handling as dictated by EPA's Good Automated Laboratory Practices (GALP) manual and TRC's Quality Assurance

Project Plan.

January 26, 2005 2−2

ACTIVITY SUBJECT ACTIVITIES

Column Column Data Data Data Data

Name Description Codename Type Length Prec Units Null?

STUDY PROTOCOL NAME CHAR 20 N

SUBJECT SUBJECT ID CHAR 6 N

ACQDATE ACQUISITION DATE DATE 7 N

ACQTIME ACQUISITION TIME CHAR 11 N

LOCNUM LOCATION LOCATION NUMBER 3 Y

OPERNUM OPERATOR OPERATOR NUMBER 3 Y

GRP GROUP OF PERIODS GROUP NUMBER 3 Y

PERIOD GROUPING OF EXPERIMENTAL EVENTS PERIOD NUMBER 3 Y

SESNUM EXPERIMENTAL SESSION ID CHAR 3 Y

EVENT BASIC EXPERIMENTAL EVENT EVENT CHAR 15 Y

TRIAL TRIAL NUMBER NUMBER 3 Y

FRADATE VECTOR COLLECTION DATE DATE 7 Y

FRATIME VECTOR COLLECTION TIME CHAR 11 Y

CMTTYPE COMMENT TYPE CMTTYPE NUMBER 1 Y

CMTTEXT COMMENT CHAR 240 Y

AERDAT1 AEROSOL DATA

MEADATE MEASUREMENT DATE AND TIME DATE 7 N

CRIS INVENTORY NUMBER CHAR 8 N

IVLNUM INTERVAL NUMBER NUMBER 3 N

BNDSIZ INTERVAL BOUNDARY SIZE NUMBER 7 5 MICRONS Y

MEAVAL MEASURED VALUE NUMBER 16 6 Y

STS DATA QUALITY STATUS AERSTS NUMBER 1 Y

AERHDR ELPI AEROSOL DATA RECORD HEADER

HDRDATE HEADER DATE AND TIME DATE 7 N

LOCNUM LOCATION LOCATION NUMBER 3 Y

OPERNUM OPERATOR OPERATOR NUMBER 3 Y

January 26, 2005 2−3

AMBLIM LIMITS FOR PARAMETERS MEASURING AMBIENT CONDITIONS

PRMNAME PARAMETER NAME CHAR 25 N

RECDATE RECORD DATE DATE 7 N

LOWLIM LOW LIMIT NUMBER 12 6 N

HIGLIM HIGH LIMIT NUMBER 12 6 N

AMBTEMP1 AMBIENT TEMPERATURE ENVIRONMENTAL DATA

LOCNUM LOCATION LOCATION NUMBER 3 N

CRIS INVENTORY NUMBER CHAR 8 N

MEAVAL MEASURED VALUE NUMBER 12 6 Y

DESVAL DESIRED VALUE NUMBER 12 6 Y

DATAQUAL DATA QUALITY FLAG DATAQUAL NUMBER 2 Y

STSFLG ENVIRONMENTAL PARAMETER STATUS FLAG ENVSTS NUMBER 1 Y

ANAXCP EXCEPTIONS TO ANALOG DATA

XCPDATE EXCEPTION DATE/TIME DATE 7 N

CHNNAME CHANNEL NAME CHAR 9 N

ANAVLU MEASURED ANALOG VALUE NUMBER 14 6 Y

HIGLIM HIGH LIMIT NUMBER 14 6 Y

LOWLIM LOW LIMIT NUMBER 14 6 Y

XCPSTS EXCEPTION STATUS XCPSTS NUMBER 1 Y

BARPRES1 BAROMETRIC PRESSURE ENVIRONMENTAL DATA

CRIS INVENTORY NUMBER CHAR 8 N

MEAVAL MEASURED VALUE NUMBER 12 6 Y

January 26, 2005 2−4

CALDAT DEVICE CALIBRATION HISTORY

CALDATE CALIBRATION DATE DATE 7 N

CHNNAME CHANNEL NAME CHAR 9 N

CHNRANG CHANNEL RANGE LOHI NUMBER 1 N

OPERNUM OPERATOR OPERATOR NUMBER 3 Y

ADJFLAG CALIBRATION ADJUSTMENT ADJFLAG NUMBER 1 Y

CALMTD CALIBRATION METHOD CHAR 6 Y

CALLIM CALIBRATION LIMITS

CHNNAME CHANNEL NAME CHAR 9 N

CHNRANG CHANNEL RANGE LOHI NUMBER 1 N

STADATE START DATE/TIME DATE 7 N

BHIGLIM REGRESSION COEFF B HIGH LIMIT NUMBER 12 6 Y

BLOWLIM REGRESSION COEFF B LOW LIMIT NUMBER 12 6 Y

BDIFLIM REGRESSION COEFF B DIFFERENCE LIMIT NUMBER 12 6 Y

CHIGLIM REGRESSION COEFF C HIGH LIMIT NUMBER 12 6 Y

CLOWLIM REGRESSION COEFF C LOW LIMIT NUMBER 12 6 Y

CDIFLIM REGRESSION COEFF C DIFFERENCE LIMIT NUMBER 12 6 Y

DHIGLIM REGRESSION COEFF D HIGH LIMIT NUMBER 12 6 Y

DLOWLIM REGRESSION COEFF D LOW LIMIT NUMBER 12 6 Y

DDIFLIM REGRESSION COEFF D DIFFERENCE LIMIT NUMBER 12 6 Y

RGRLOW REGRESSION LOW LIMIT NUMBER 12 6 Y

CALRLT1 CALIBRATION RESULTS

CHNRANG CHANNEL RANGE LOHI NUMBER 1 N

CALDATE CALIBRATION DATE DATE 7 N

RGRID REGRESSION ID CHAR 12 N

RGRCOFA CUBIC COEFFICIENT NUMBER 12 6 Y

RGRCOFB QUADRATIC COEFFICIENT NUMBER 12 6 Y

RGRCOFC LINEAR COEFFICIENT NUMBER 12 6 Y

RGRCOFD OFFSET NUMBER 12 6 Y

RGRCORR CORRELATION COEFFICIENT NUMBER 12 6 Y

RGRERR STANDARD ERROR NUMBER 12 6 Y

January 26, 2005 2−5

COHASN COHORT-TO-SUBJECT ASSIGNMENTS

EXPDATE EXPOSURE DATE DATE 7 N

LOCNUM LOCATION LOCATION NUMBER 3 N

COHNUM COHORT NUMBER NUMBER 3 N

CNTCNC1 ELPI COUNTS CONCENTRATION

MEADATE MEASUREMENT DATE AND TIME DATE 7 N

IVLNUM INTERVAL NUMBER NUMBER 3 N

MEAVAL MEASURED VALUE NUMBER 13 6 Y

CNDDAT PARAMETER PROFILE CONDITIONS

CNDNAME ENVIRONMENTAL CONDITION CHAR 24 N

DEFDATE DEFINITION DATE DATE 7 N

CNDTYPE CONDITION TYPE ENVCND NUMBER 1 N

PRMNAME PARAMETER NAME CHAR 25 N

FNCTYPE FUNCTION TYPE FNCTYPE NUMBER 1 Y

FNCSHAM SHAM FLAG FNCSHAM NUMBER 1 Y

FNCMAX FUNCTION MAXIMUM NUMBER 14 6 Y

FNCMIN FUNCTION MINIMUM NUMBER 14 6 Y

FNCOFF FUNCTION OFFSET/PHASE LAG NUMBER 4 Y

FNCPER FUNCTION PERIOD NUMBER 4 Y

DATDEF DATA ITEM DEFINITIONS

DATANAME VARIABLE NAME CHAR 8 Y

CODENAME CODE NAME CHAR 8 Y

DATADESC VARIABLE DESCRIPTION CHAR 180 Y

January 26, 2005 2−6

DATATYPE DATA TYPE CHAR 6 Y

DATALEN MAXIMUM LENGTH NUMBER 3 Y

DATAPREC DATA PRECISION CHAR 15 Y

DATAUNI UNITS OF MEASURE CHAR 12 Y

DATALO RANGE-LOW NUMBER 20 8 Y

DATAHI RANGE-HIGH NUMBER 20 8 Y

CMTTEXT COMMENT TEXT CHAR 240 Y

DATREF DATA ITEM CROSS REFERENCES

DATANAME VARIABLE NAME CHAR 8 Y

TABNAME TABLE NAME CHAR 8 Y

OWNER DATABASE ACCOUNT OWNER CHAR 30 Y

DEMOG DEMOGRAPHIC SUBJECT CHARACTERISTICS

CHARTNUM SUBJECTS' MEDICAL CHART NUMBER 6 N

RECDATE RECORD DATE DATE 7 Y

RECTIME RECORD TIME CHAR 11 Y

RACE RACE RACE NUMBER 1 Y

GENDER GENDER GENDER NUMBER 1 Y

BRTHDATE BIRTHDATE DATE 7 Y

DIGXCP EXCEPTIONS TO DIGITAL DATA

XCPDATE EXCEPTION DATE/TIME DATE 7 N

DEVNAME DEVICE NAME CHAR 9 N

DIGVLU MEASURED DIGITAL VALUE CHAR 4 Y

XPCVLU EXPECTED VALUE CHAR 4 Y

ENAPFL ENABLED PROFILES

ENADATE POLLUTANT ENABLED DATE/TIME DATE 7 N

ENVCND ENVIRONMENTAL CONDITION NAME CHAR 24 N

PLNCND POLLUTANT CONDITION NAME CHAR 24 N

January 26, 2005 2−7

EXPDEF EXPOSURE DEFINITIONS

EXPNUM EXPOSURE NUMBER NUMBER 3 Y

POLLCND POLLUTANT CONDITION CHAR 9 N

ENVCND ENVIRONMENTAL CONDITION NAME CHAR 9 N

EXPDUR EXPOSURE DURATION NUMBER 4 MINUTES Y

FLDREC FIELD RECORD DEFINITIONS

SYSREC UNIQUE RECORD ID CHAR 8 N

SEQNUM INPUT FIELD ORDER OR SEQUENCE NUMBER NUMBER 3 N

INPNAM INPUT FIELD NAME CHAR 30 Y

ACCNAME DATABASE ACCOUNT NAME CHAR 30 Y

TABNAME TABLE NAME CHAR 8 N

DATANAME VARIABLE NAME CHAR 8 Y

INPTYPE INPUT DATA TYPE NUMBER 3 Y

INPLEN INPUT FIELD LENGTH NUMBER 3 Y

CODENAME CODE NAME CHAR 8 Y

INPDLM INPUT FIELD DELIMITER CHAR 1 Y

PRCCOD PROCESSING CODE NUMBER 3 Y

FLDNUM FIELD NUMBER NUMBER 2 Y

ARRLEN ARRAY LENGTH NUMBER 3 Y

FLTDAT AEROSOL FILTER DATA

FILTER FILTER ID CHAR 8 N

LOCNUM MEASUREMENT LOCATION LOCATION NUMBER 3 N

BEGDATE MEASUREMENT START DATE AND TIME DATE 7 N

ENDDATE MEASUREMENT END DATE AND TIME DATE 7 N

MASS MASS CONCENTRATION NUMBER 12 6 _g/m3 Y

GNAERHDR GENERAL AEROSOL DATA RECORD HEADER

January 26, 2005 2−8

CRIS INVENTORY NUMBER CHAR 8 N

LOCNUM LOCATION LOCATION NUMBER 3 Y

PYUNTNUM UNIT NUMBER PHYUNT NUMBER 3 Y

OPERNUM OPERATOR OPERATOR NUMBER 3 Y

INPDAT INPUT DATA DEFINITIONS

SUBNAME SUBSYSTEM NAME CHAR 6 N

RECLEN LENGTH OF RECORD TYPE NUMBER 3 Y

FDLLEN LENGTH OF PAD BEFORE RECORD TYPE NUMBER 2 BYTES Y

INPREC INPUT RECORD DEFINITIONS

SUBNAME SUBSYSTEM NAME CHAR 6 N

SYSREC UNIQUE RECORD ID CHAR 8 N

INPREC INPUT RECORD NAME CHAR 30 N

DBRAW DERIVED OR RAW DATA NUMBER 1 Y

HDRFLAG HEADER RECORD FLAG YN NUMBER 1 Y

LODCLS LOAD CLASSIFICATION NUMBER 1 Y

INVCO CO-INVESTIGATORS BY STUDY

INVNUM INVESTIGATOR NUMBER 4 N

INVENTRY DEVICE INVENTORY

DEVDATE DEVICE INVENTORY DATE/TIME DATE 7 N

DEVNAME DEVICE NAME CHAR 20 Y

INVMFG MANUFACTURER CHAR 30 Y

January 26, 2005 2−9

INVMOD MODEL NUMBER CHAR 20 Y

INVSER SERIAL NUMBER CHAR 20 Y

DEVDESC DEVICE DESCRIPTION CHAR 180 Y

LOCNUM LOCATION LOCATION NUMBER 3 Y

INVEST INVESTIGATOR INFORMATION

INVNUM INVESTIGATOR NUMBER 4 Y

INVFIRST INVESTIGATOR FIRST NAME CHAR 30 Y

INVLAST INVESTIGATOR LAST NAME CHAR 30 Y

INVDEGRE INVESTIGATOR ACADEMIC DEGREES CHAR 15 Y

INVPRI PRIMARY INVESTIGATORS BY STUDY

INVNUM INVESTIGATOR NUMBER 4 N

IVLBND ELPI INTERVAL BOUNDARY

IVLBDNUM INTERVAL BOUNDARY NUMBER NUMBER 3 N

IVLBDVLU CUTPOINT VALUE NUMBER 5 3 Y

MONTBL MONITORING ANALYZERS

Name Description Codename ype Length Prec Units Null?

PRMNAME PARAMETER NAME CHAR 25 N

January 26, 2005 2−10

PCP1 PRECIPITATION DATA

CRIS INVENTORY NUMBER CHAR 8 N

PLNDAT1 POLLUTANT DATA

CRIS INVENTORY NUMBER CHAR 8 N

PRMNAME PARAMETER NAME CHAR 25 N

DESVAL DESIRED VALUE NUMBER 14 6 Y

MEAVAL MEASURED VALUE NUMBER 14 6 Y

PNTDAT CALIBRATION POINTS

CHNRANG CHANNEL RANGE LOHI NUMBER 1 N

CALDATE CALIBRATION DATE DATE 7 N

PNTID SEQUENCE NUMBER W/IN CALIBRATION NUMBER 3 Y

PNTMEAS CALIBRATION POINT MEASURED VALUE NUMBER 12 6 Y

PNTREF CALIBRATION POINT REFERENCE VALUE NUMBER 12 6 Y

PNTINC CALIBRATION POINTS INCLUDED IN REGRESSION

CHNRANG CHANNEL RANGE LOHI NUMBER 1 N

CALDATE CALIBRATION DATE DATE 7 N

RGRID REGRESSION ID CHAR 12 N

January 26, 2005 2−11

PNTINC POINT INCLUDED YN NUMBER 1 Y

PNTIDT POINT IDENTIFICATION NUMBER 2 Y

PRTQUE PRINTER QUEUE DEFINITIONS

QUENAM PRINT/BATCH QUEUE NAME CHAR 15 N

PORTSYM PRINT PORTRAIT SYMBOL CHAR 10 N

LANDSYM PRINT LANDSCAPE SYMBOL CHAR 10 N

DEVTYPE DEVICE TYPE CHAR 20 N

DEVNAME DEVICE NAME CHAR 6 N

QUEDESC PRINT/BATCH QUEUE DESCRIPTION CHAR 30 Y

PRTCGY PRINTER CATEGORY CHAR 10 Y

RECAL RECALIBRATION INTERVALS

CHNRANG CHANNEL RANGE LOHI NUMBER 1 N

RECAL RECALIBRATION INTERVAL NUMBER 3 DAYS N

RELHUM1 RELATIVE HUMIDITY ENVIRONMENTAL DATA

CRIS INVENTORY NUMBER CHAR 8 N

MEAVAL MEASURED VALUE NUMBER 12 6 Y

DESVAL DESIRED VALUE NUMBER 12 6 Y

January 26, 2005 2−12

SECRLT1 SECONDARY CALIBRATION RESULTS

CHNRANG CHANNEL RANGE LOHI NUMBER 1 N

CALDATE CALIBRATION DATE DATE 7 N

RGRID REGRESSION ID CHAR 12 Y

RLTSEQ CALIBRATION SECONDARY RESULTS SEQUENCE NUMBER NUMBER 2 Y

RLTNAME CALIBRATION SECONDARY RESULTS NAME CHAR 20 Y

RLTVAL CALIBRATION SECONDARY RESULT VALUE NUMBER 12 6 Y

SETPNT EXPOSURE SET POINTS

CNDNAME ENVIRONMENTAL CONDITION CHAR 24 N

DEFDATE DEFINITION DATE DATE 7 N

PRMNAME PARAMETER NAME CHAR 25 N

CNDTYPE CONDITION TYPE ENVCND NUMBER 1 N

SEQNUM INPUT FIELD ORDER OR SEQUENCE NUMBER NUMBER 3 N

PNTVAL SET POINT VALUE NUMBER 14 6 Y

PNTDUR POINT DURATION NUMBER 2 MINUTES Y

STUACC PERSONS AUTHORIZED TO MODIFY STUDY DATA VIA DBVS

USERNAME VMS USER NAME CHAR 20 N

STUDY STUDY IDENTIFICATION

STUDYDES PROTOCOL DESCRIPTION CHAR 240 Y

STUBEGIN PROTOCOL START DATE DATE 7 Y

STUDATE PROTOCOL APPLICATION DATE DATE 7 Y

SUBNUM NUMBER OF SUBJECTS IN STUDY NUMBER 3 Y

STUDYXPR STUDY EXPIRATION DATES

January 26, 2005 2−13

XPRDATE PROTOCOL EXPIRATION DATE DATE 7 N

RECDATE RECORD DATE DATE 7 N

SUBINDX SUBJECT TO STUDY INDEX

CHARTNUM SUBJECTS' MEDICAL CHART NUMBER 6 N

SUBJCHAR SUBJECT CHARACTERISTIC GROUPING NUMBER 1 Y

SYSCMT SYSTEM COMMENTS

ACQDATE ACQUISITION DATE DATE 7 N

SYSNAME SUB SYSTEM NAME CHAR 9 N

SEQNUM INPUT FIELD ORDER OR SEQUENCE NUMBER NUMBER 3 N

SYSTEXT SYSTEM COMMENT CHAR 256 Y

TABDEF TABLE DEFINITIONS

TABNAME TABLE NAME CHAR 8 N

TABDESC TABLE DESCRIPTION CHAR 180 Y

TABREF TABLE CROSS REFERENCES

OWNER DATABASE ACCOUNT OWNER CHAR 30 Y

TABNAME TABLE NAME CHAR 8 Y

January 26, 2005 2−14

TEOMDAT1 TAPERED ELEMENT OSCILLATING MICROBALANCE DATA

CRIS INVENTORY NUMBER CHAR 8 N

PRMNAME PARAMETER NAME CHAR 25 N

AVG5MIN FIVE-MINUTE AVERAGE NUMBER 12 6 Y

AVG30MIN THIRTY-MINUTE AVERAGE NUMBER 12 6 Y

AVG1HR ONE-HOUR AVERAGE NUMBER 12 6 Y

WNDDRC1 WIND DIRECTION ENVIRONMENTAL DATA

CRIS INVENTORY NUMBER CHAR 8 N

WNDSPD1 WIND SPEED ENVIRONMENTAL DATA

CRIS INVENTORY NUMBER CHAR 8 N

January 26, 2005 3−1

3.0 ORACLE ACCOUNTS

This chapter defines the tables that are 'owned' by the ORACLE accounts which have been established in the Human

Studies Database. The account name is listed along with a description of the account. The account names generally reflect the category of information held within the account. For example, the CALIB account maintains all calibration data for the system. The tables owned by the account are then listed. The table definitions may be found in Chapter 2.

CALIB Calibration Information

Table Table

Name Description

CALDAT DEVICE CALIBRATION HISTORY

CALLIM CALIBRATION LIMITS

CALRLT CALIBRATION RESULTS

PNTDAT CALIBRATION DATA POINTS

PNTINC CALIBRATION POINT INCLUDED

SECRLT SECONDARY CALIBRATION RESULTS

CEL General Information

ACTIVITY ACTIVITY FOR SUBJECT IN A STUDY

EXPDEF EXPOSURE DEFINITIONS

INVCO CO-INVESTIGATORS BY STUDY

INVEST INVESTIGATOR DATA

INVPRI PRIMARY INVESTIGATORS BY STUDY

STUDY STUDY DESCRIPTION

STUDYXPR STUDY EXPIRATION DATES

SYSCMT OPERATOR SYSTEM COMMENTS

DBSVALIDATE Database Validation and Reporting System Production Information

PRTQUE PRINTER QUEUE DEFINITIONS

STUACC STUDY ACCESS AUTHORIZATION LIST

January 26, 2005 3−2

DEVDAT Device Data Information

ANAXCP ANALOG EXCEPTION

DIGXCP DIGITAL EXCEPTION

INVENTRY DEVICE INVENTORY

RECAL RECALIBRATION INTERVALS

ENVIRON Environmental Data

AERDAT AEROSOL DATA

AERHDR ELPI AEROSOL DATA HEADER

AMBTEMP AMBIENT TEMPERATURE ENVIRONMENTAL DATA

BARPRES BAROMETRIC PRESSURE ENVIRONMENTAL DATA

CNTCNC ELPI COUNTS CONCENTRATION

ENAPFL ENABLED PROFILE

FLTDAT AEROSOL FILTER DATA

GNAERHDR GENERAL AEROSOL DATA HEADER

IVLBND ELPI INTERVAL BOUNDRY

MONTBL MONITORING INSTRUMENTS

PCP PRECIPITATION ENVIRONMENTAL DATA

PLNDAT POLLUTANT MONITORING DATA

RELHUM RELATIVE HUMIDITY ENVIRONMENTAL DATA

TEOMDAT TAPERD ELEMENT OSCILLATING MICROBALANCE DATA

WNDDRC WIND DIRECTION ENVIRONMENTAL DATA

WNDSPD WIND SPEED ENVIRONMENTAL DATA

EXPOSURE Exposure Related Information

CNDDAT CONDITION DATA FOR EXPOSURE PARAMETERS

SETPNT SET POINTS FOR EXPOSURE PARAMETERS

PCS Pollutant Control System Related Information

January 26, 2005 3−3

STANDARD Owner of the Dictionary Information

CODEDEF TABLE OF CODES

DATDEF TABLE OF COLUMN NAMES

DATREF TABLE OF COLUMNS AND TABLES IN A STUDY

FLDREC FIELD RECORD FOR DATABASE LOAD

INPDAT INPUT DATA FOR DATABASE LOAD

INPREC INPUT RECORDS FOR DATABASE LOAD

TABDEF TABLE OF TABLE NAMES

TABREF TABLE REFERENCES

SUBJECT Subject Related Information

COHASN COHORT-TO-SUBJECT ASSIGNMENTS

DEMOG SUBJECT PROFILE

SUBINDX SUBJECT INDEX

January 26, 2005 4−1

4.0 CODING DICTIONARY

A coding dictionary is used to maintain lists of information that must be standardized across the system. This information may be found in the STANDARD.CODEDEF coding table. The following information is defined for the codes:

• Code name - The name of the code.

• Code value - Identifies the value stored in the data field.

• Code meaning - Textual description of this code.

• Code report - Value translated for output reports.

• Code input - Value translated from input sources.