table_name |
field_name |
field_description |
data_type |
length |
tblAUBUPart |
PartID |
DEC assigned Participant ID |
Long |
4 |
tblAUBUPart |
Status |
Enrollment status: Active, LTF, Not Clinically indicated, may need to add a couple more... |
Text |
255 |
tblAUBUPart |
dTeEnroll |
Date of enrollment, must match with DEC website |
Date |
8 |
tblAUBUPart |
dTeBaseline |
Date of baseline survey, must match with DEC and RedCap |
Date |
8 |
tblAUBUPart |
dTeFU6 |
Date of 6 month follow up survey, must match with DEC BUT, this and all following dates may be blank because they were not actually done (patient lost to followup, died, pulled out of study, many reasons) |
Date |
8 |
tblAUBUPart |
dTeCA6 |
Date of 6 month Chart Abstraction, must match with DEC |
Date |
8 |
tblAUBUPart |
dTeFU12 |
Date of 12 month followup survey, must match with DEC |
Date |
8 |
tblAUBUPart |
dTeCA12 |
Date of 12 month Chart Abstraction, must match with DEC |
Date |
8 |
tblAUBUPart |
dTeFU18 |
Date of 18 month follow up survey, must match DEC |
Date |
8 |
tblAUBUPart |
dTECA18 |
Date of 18 month Chart Abstraction, must match DEC |
Date |
8 |
tblBloodTests |
BloodID |
|
Long |
4 |
tblBloodTests |
dTeSamp |
|
Date |
8 |
tblBloodTests |
MRN |
|
Long |
4 |
tblBloodTests |
CD4 |
Has to be a number |
Long |
4 |
tblBloodTests |
PerCD4 |
% but not a calculation, it's a direct entry from medical records |
Long |
4 |
tblBloodTests |
VL |
can be a number or it could be a Not detected (ND) or a QNS (quantity not sufficient, also noted <20), which is usually the case. |
Text |
255 |
tblContactAttempts |
ContactID |
|
Long |
4 |
tblContactAttempts |
dTeContact |
do I care about time? |
Date |
8 |
tblContactAttempts |
MRN |
|
Long |
4 |
tblContactAttempts |
Provider/Staff |
who tried or did contact patient |
Text |
255 |
tblContactAttempts |
Type |
Phone, in person, ? |
Text |
255 |
tblContactAttempts |
Result/Notes |
How it turned out, free entry here |
Memo |
0 |
tblDUR |
Substance Report ID |
|
Long |
4 |
tblDUR |
MRN |
|
Long |
4 |
tblDUR |
dTeReport |
|
Date |
8 |
tblDUR |
AMP |
|
Boolean |
1 |
tblDUR |
METH |
|
Boolean |
1 |
tblDUR |
BZO |
|
Boolean |
1 |
tblDUR |
THC |
|
Boolean |
1 |
tblDUR |
COC |
|
Boolean |
1 |
tblDUR |
OPI |
|
Boolean |
1 |
tblDUR |
OXY |
|
Boolean |
1 |
tblDUR |
MTD |
|
Boolean |
1 |
tblDUR |
BUP |
|
Boolean |
1 |
tblMedLog |
MedID |
|
Long |
4 |
tblMedLog |
Prescriber Last Name |
|
Text |
255 |
tblMedLog |
Medication Prescribed |
|
Text |
255 |
tblMedLog |
Dose |
|
Text |
255 |
tblMedLog |
Patient |
|
Text |
255 |
tblMedLog |
Date Prescribed |
|
Date |
8 |
tblMedLog |
TypePrescription |
|
Text |
255 |
tblMedLog |
Refills |
|
Long |
4 |
tblPAs |
PAID |
|
Long |
4 |
tblPAs |
Insurance |
|
Text |
255 |
tblPAs |
Prescriber |
|
Text |
255 |
tblPAs |
MRN |
|
Long |
4 |
tblPAs |
Medication |
|
Text |
255 |
tblPAs |
stPA |
|
Date |
8 |
tblPAs |
expPA |
|
Date |
8 |
tblPatients |
MRN |
Will later be actual MRN, which are typically 8 digits, I think? Maybe 10. |
Long |
4 |
tblPatients |
frtName |
First name of patient |
Text |
255 |
tblPatients |
lstName |
Last name of patient, or for muppets, color |
Text |
255 |
tblPatients |
vsched |
How often they visit. I'd like a list of options but I don't know how (weekly, biweekly, monthly, three times per week, twice per week, probably still need room to add more potentially) |
Text |
255 |
tblPatients |
PartIDFK |
Their participant ID for study enrollment for the AUBU study |
Long |
4 |
tblPatients |
phone |
Phone number for contact (should I put in a secondary?) |
Text |
255 |
tblPatients |
Address |
Current address |
Text |
255 |
tblPatients |
City |
related to current address |
Text |
255 |
tblPatients |
Zip |
related to current address |
Text |
255 |
tblRanPC |
PillCountID |
|
Long |
4 |
tblRanPC |
dTePC |
|
Date |
8 |
tblRanPC |
MRN |
|
Long |
4 |
tblRanPC |
Medication |
|
Text |
255 |
tblRanPC |
ResultPC |
Appropriate or Not Appropriate are the possible answers |
Text |
255 |
tblReferrals |
Referral ID |
|
Long |
4 |
tblReferrals |
MRN |
|
Long |
4 |
tblReferrals |
dTeReferral |
|
Date |
8 |
tblReferrals |
byWho |
|
Text |
255 |
tblUDS |
UDS ID |
|
Long |
4 |
tblUDS |
dTeUDS |
|
Date |
8 |
tblUDS |
MRN |
|
Long |
4 |
tblUDS |
THC |
|
Boolean |
1 |
tblUDS |
COC |
|
Boolean |
1 |
tblUDS |
OPI |
|
Boolean |
1 |
tblUDS |
METH |
|
Boolean |
1 |
tblUDS |
AMP |
|
Boolean |
1 |
tblUDS |
BZO |
|
Boolean |
1 |
tblUDS |
MTD |
|
Boolean |
1 |
tblUDS |
BUP |
|
Boolean |
1 |
tblUDS |
OXY |
|
Boolean |
1 |