Field
Number |
Field Name
|
Description |
1 |
barcode:
8 digit numeric |
|
2 |
clock
position: numeric 1 to 12 as in hours in a clock. |
|
3 |
EEM
#: numeric sequence of EEMs measured per patient |
|
4 |
EEM
date: 8 digit numeric, representing date EEM was measured |
|
5 |
box
id: numeric, indicates box number |
|
6 |
probe
id: numeric, the probe used |
|
7 |
provider:
numeric, indicates provider |
|
8 |
tissue
type: numeric, indicates tissue type |
|
9 |
worst
dx, numeric: indicates worst dx for this measurement |
|
10 |
age:
numeric, indicates age of patient in years |
|
11 |
race,
num: numeric, indicates race |
|
12 |
clinical
menopausal status, num: indicates menopausal status as supplied by patient. |
|
13 |
biological
menopausal status, num: indicates menopausal status based on FSH level. |
|
14 |
FSH:
numeric, indicates hormonal levels test results |
|
15 |
ever
smoked: numeric |
|
16 |
never
gave birth: numeric |
|
17 |
#
vaginal deliveries: numeric, indicates how many vaginal deliveries as
supplied by patient. |
|
18 |
current
hormones: numeric, indicates if patient is taking hormone replacement therapy |
|
19 |
age
at menarche: numeric, indicates age on years at first menstruation. |
|
20 |
HPV
high risk |
|
21 |
HPV
low risk |
|
22 |
HPV
negative |
|
23 |
referral PAP dx: numeric diagnosis from referral Pap |
|
24 |
clinic: numeric, indicates clinic number |
|
25 |
operator ok: numeric, indicates if operator ok'd measurement or rejected it. |
|
............................Added at DC Build |
|
|
499 |
CIN worst DX per patient |
|
500 |
Infrared Leakage was detected at 380 excitation and corrected on Oct 01 2002. All measurements prior to this date required x380 to be calculated by averaging x370 and x390 spectra. |
|
501 |
NIMI Dx this measurement |
|
502 |
NIMI DX worst patient: patient's worst diagnosis |
barcode:
8 digit numeric |
|
|
|
AAABCCCC |
|
|
|
e.g.
24510011 |
|
|
|
AAA: |
indicates
study number, e.g.:245 |
|
|
B: |
indicates
clinic number, e.g.:1 for MDA, 2 for LBJ, 5 for BCCA |
||
CCCC: |
indicates
patient number, e.g. 0011 |
|
|
clock
position: numeric 1 to 12 as in hours in a clock. |
||
e.g.
12 |
|
|
NOTE:
clock position 0 (zero) was added to indicate ecc or endo cervical canal. |
EEM
#: numeric sequence of EEMs measured per patient |
e.g.
1 |
EEM
date: 8 digit numeric, representing date EEM was measured in MMDDYYYY format. |
e.g.
12242000 |
box
id: numeric, indicates box number, e.g.: 3 for 714319 |
|
id |
code |
1 |
1 |
3 |
2 |
4 |
3 |
714319 |
4 |
71419 |
5 |
|
-999 |
probe
id: numeric, the probe used, e.g. 4 for probe pp001 |
|
id |
code |
1 |
1 |
2 |
2 |
3 |
3 |
5 |
4 |
6 |
5 |
PP001 |
6 |
PP001 |
7 |
|
-999 |
provider:
numeric, indicates provider, e.g. 6 for provider lb |
|
prov |
code |
mf |
1 |
AS |
2 |
js |
3 |
as |
2 |
kr |
5 |
as. |
2 |
am |
7 |
kb |
8 |
vh |
9 |
lb |
10 |
mb |
11 |
mb |
11 |
te |
13 |
dm |
14 |
lb |
10 |
ls |
16 |
|
-999 |
tissue
type: numeric, indicates tissue type, e.g. 2 for columnar |
|
squamous |
1 |
columnar |
2 |
transitional |
3 |
|
-999 |
worst
dx, numeric: indicates worst dx for this measurement, e.g. 10 for mild dysplasia. |
|
ACIS |
6 |
Sqcis
(CIN III) |
7 |
Severe
dysplasia (CIN III) |
8 |
Moderate
dysplasia (CIN II) |
9 |
Mild
dysplasia (CIN I) |
10 |
HPV
associated changes |
11 |
Squamous
atypia, suggestive of dysplasia |
12 |
negative
for dysplasia |
30 |
No
diagnosis possible |
99 |
age:
numeric, indicates age of patient in years. e.g. 24 |
race,
num: numeric, indicates race, e.g. 3 for hispanic. |
|
White |
1 |
Black |
2 |
Hispanic |
3 |
Native
American |
4 |
Asian |
5 |
Other |
6 |
clinical
menopausal status, num: indicates menopausal status as supplied by patient. |
|
pre |
1 |
post |
2 |
peri |
3 |
|
-999 |
biological
menopausal status, num: indicates menopausal status based on FSH level. |
|
pre |
1 |
post |
2 |
peri |
3 |
N/A |
4 |
|
-999 |
FSH:
numeric, indicates hormonal levels test results |
NOTE:
for FSH levels less than 0.1, the datacube reflects 0.1. |
ever
smoked: numeric |
|
Yes |
1 |
No |
2 |
|
-999 |
never
gave birth: numeric |
|
Yes |
1 |
No |
0 |
|
-999 |
#
vaginal deliveries: numeric, indicates how many vaginal deliveries as
supplied by patient. |
e.g.
3 for 3 births |
current
hormones: numeric, indicates if patient is taking hormone replacement therapy |
|
Yes |
1 |
No |
0 |
|
-999 |
age
at menarche: numeric, indicates age on years at first menstruation. |
e.g.
12 |
HPV
high risk |
|
Yes |
1 |
No |
0 |
|
-999 |
HPV
low risk |
|
Yes |
1 |
No |
0 |
|
-999 |
HPV
negative |
|
Yes |
1 |
No |
0 |
|
-999 |
referral
PAP dx: numeric diagnosis from referral Pap |
|
0 |
Negative |
1 |
AGUS |
2 |
ASCUS |
3 |
Koilocytosis |
4 |
CIN
I |
5 |
CIN
II |
6 |
CIN
III |
7 |
CIS |
8 |
Microinvasion |
9 |
ICC |
99 |
No
Dx/Unspecified |
clinic:
numeric, indicates clinic number, e.g.:1 for MDA, 2 for LBJ, 5 for BCCA. |
operator
ok: numeric, indicates if operator ok'd measurement or rejected it. |
|
Yes |
1 |
No |
0 |
|
-999 |
................................Following
Fields are not in database but were added at datacube build |
IR
leakage Flag |
||
Infrared
Leakage was detected at 380 excitation and corrected on Oct 01 2002. All measurements |
||
prior
to this date required x380 to be calculated by averaging x370 and x390
spectra. |
||
Yes |
1 |
|
No |
0 |
|
NIMI
Dx this measurement |
|
-1 |
Not
available |
1 |
SQN |
2 |
CON |
3 |
METP |
4 |
INFL |
5 |
LGSIL |
6 |
HGSIL |
7 |
ACIS |
8 |
TRN:
transitional (ecc for endo cervical canal) normal |
NIMI
DX worst patient: patient's worst diagnosis |
|
-1 |
Not
available |
1 |
SQN |
2 |
CON |
3 |
METP |
4 |
INFL |
5 |
LGSIL |
6 |
HGSIL |
7 |
ACIS |
8 |
TRN:
transitional (ecc for endo cervical canal) normal |