APHDR Data Sets

Army Public Health Data Repository (APHDR)

MEDPROS-PHA-USAPHC (24).xlsx

APHDR Data Sets

OMB:

Document [xlsx]
Download: xlsx | pdf

Overview

1.Cover Letter
2.MEDPROS_PHA-Old-USAPHC Atr
3.MEDPROS_PHA-New-USAPHC Atr

Sheet 1: 1.Cover Letter
This tab, 1.Cover Letter, describes the information in tabs 2 and 3.



Tab
Description
2.MEDPROS_PHA-Old-USAPHC Atr Report on the attributes available for selection from old from. Explaination of the report column heads appears below, titled Column Definitions.
3.MEDPROS_PHA-New-USAPHC Atr Report on the attributes available for selection from new form. Explaination of the report column heads appears below, titled Column Definitions.




Column Definitions



Column Name Description
A Source Name of Data Source
B SourceTabOrd Ordinal Position of Table in Data Dictionary received from Source System-used internally
C SourceTable Name of the Table from which the data element is extracted from Source System
D SourceFieldOrd Ordinal Position of the data element in a Table in the Source System Data Dictionary-used internally
E FieldName Name of the data element (please use the literal format as in the column)
F PII/HIPAA Sensitive Please note YES, NO or DI (De-Identification)for the element PII or HIPAA sensitivity. If the element is PII or HIPAA sensitive and it will be de-identified, enter DI. A blank enter will be considered the same as a NO.
G Army STARRS (or USAPHC(Prov)) Approval User has accepted this as a valid element for their use-drop down list-Yes or No
H Army STARRS (or USAPHC(Prov)) SP2Delta Date the data element requested in Spiral-2. This will help in revising your existing extract routines
I FieldType This is the data type.
J Nullability This is the Nullability condition
K Primary Key Indicator if data element is a primary key (PK) or foreign key (FK) in this table
L Title Data Element Name
M Desc Dictionary meaning of the data element and enumerated values if applicable
N Values Information on values the element may have
O Notes Notes concerning the element
P FDM Comments Please add any comments that will help us understand the output extract.
Q ADS Comment Please add any comments on authoritativeness
R Code Table Reference Reference to code table.

Sheet 2: 2.MEDPROS_PHA-Old-USAPHC Atr

Source Source Tab Ord SourceTable Source Field Ord FieldName PII/HIPAA Sensitive USAPHC (Prov) Approval USAPHC (Prov) SP2Delta FieldType Nullability Primary Key Title Desc Values Notes FDM Comments ADS Comment Code Table Reference
MEDPROS/PHA-OLD 14 Old-Demographics 1 AdditionalDataComments Yes Yes 7/29/2010 varchar(1000) y







MEDPROS/PHA-OLD 14 Old-Demographics 2 AdditionalEvaluation
Yes 7/29/2010 char(1) Yes



n/a


MEDPROS/PHA-OLD 14 Old-Demographics 3 BirthDate DI Yes 7/29/2010 datetime(8) Yes



Date of Birth


MEDPROS/PHA-OLD 14 Old-Demographics 10 FirstName Yes Yes 7/29/2010 varchar(30) n







MEDPROS/PHA-OLD 14 Old-Demographics 12 Gender
Yes 7/29/2010 char(1) No



Gender


MEDPROS/PHA-OLD 14 Old-Demographics 13 Height
Yes 7/29/2010 int(4) Yes



Height


MEDPROS/PHA-OLD 14 Old-Demographics 15 LastName Yes Yes 7/29/2010 varchar(50) n







MEDPROS/PHA-OLD 14 Old-Demographics 35 Pregnant
Yes 7/29/2010 char(1) No



Pregnant?


MEDPROS/PHA-OLD 14 Old-Demographics 36 PULHES
Yes 7/29/2010 char(6) Yes



PULHES Check boxes


MEDPROS/PHA-OLD 14 Old-Demographics 37 Rank DI Yes 7/29/2010 varchar(5) No



Rank


MEDPROS/PHA-OLD 14 Old-Demographics 39 SSN DI Yes 7/29/2010 char(9) No YES


SSN


MEDPROS/PHA-OLD 14 Old-Demographics 41 Status
Yes 7/29/2010 int(4) No







MEDPROS/PHA-OLD 14 Old-Demographics 44 UIC DI Yes 7/29/2010 char(6) No



n/a


MEDPROS/PHA-OLD 14 Old-Demographics 45 UICName Yes Yes 7/29/2010 nchar(200) y







MEDPROS/PHA-OLD 14 Old-Demographics 46 Weight
Yes 7/29/2010 int(4) Yes



weight


MEDPROS/PHA-OLD 16 Old-Overall Health 1 Anemia
Yes 7/29/2010 smallint(2) No







MEDPROS/PHA-OLD 16 Old-Overall Health 2 ArmyPhysicalFitnessTest
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 16 Old-Overall Health 3 ArmyPhysicalFitnessTestProviderComment Yes Yes 7/29/2010 varchar(500) y







MEDPROS/PHA-OLD 16 Old-Overall Health 4 ArmyPhysicalFitnessTestSoldierComment Yes Yes 7/29/2010 varchar(300) y







MEDPROS/PHA-OLD 16 Old-Overall Health 5 AsthmaHayFever
Yes 7/29/2010 smallint(2) No







MEDPROS/PHA-OLD 16 Old-Overall Health 6 AuditRecord_OverallHealth
Yes 7/29/2010 char(1) No







MEDPROS/PHA-OLD 16 Old-Overall Health 7 BackPain
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 16 Old-Overall Health 8 BehavioralHealthProvider
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 16 Old-Overall Health 9 BehavioralHealthProviderProviderComment Yes Yes 7/29/2010 varchar(500) y







MEDPROS/PHA-OLD 16 Old-Overall Health 10 BehavioralHealthProviderSoldierComment Yes Yes 7/29/2010 varchar(300) y







MEDPROS/PHA-OLD 16 Old-Overall Health 11 BeingTreatedQuestion1Explanation Yes Yes 7/29/2010 varchar(100) y







MEDPROS/PHA-OLD 16 Old-Overall Health 12 BeingTreatedQuestion1YN
Yes 7/29/2010 char(1) y







MEDPROS/PHA-OLD 16 Old-Overall Health 13 BeingTreatedQuestion2Explanation Yes Yes 7/29/2010 varchar(100) y







MEDPROS/PHA-OLD 16 Old-Overall Health 14 BeingTreatedQuestion2YN
Yes 7/29/2010 char(1) y







MEDPROS/PHA-OLD 16 Old-Overall Health 15 BeingTreatedQuestion3Explanation Yes Yes 7/29/2010 varchar(100) y







MEDPROS/PHA-OLD 16 Old-Overall Health 16 BeingTreatedQuestion3YN
Yes 7/29/2010 char(1) y







MEDPROS/PHA-OLD 16 Old-Overall Health 17 BeingTreatedQuestion4Explanation Yes Yes 7/29/2010 varchar(100) y







MEDPROS/PHA-OLD 16 Old-Overall Health 18 BeingTreatedQuestion4YN
Yes 7/29/2010 char(1) y







MEDPROS/PHA-OLD 16 Old-Overall Health 19 BeingTreatedQuestion5Explanation Yes Yes 7/29/2010 varchar(100) y







MEDPROS/PHA-OLD 16 Old-Overall Health 20 BeingTreatedQuestion5YN
Yes 7/29/2010 char(1) y







MEDPROS/PHA-OLD 16 Old-Overall Health 21 BeingTreatedQuestion6Explanation Yes Yes 7/29/2010 varchar(100) y







MEDPROS/PHA-OLD 16 Old-Overall Health 22 BeingTreatedQuestion6YN
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 16 Old-Overall Health 23 Cancer
Yes 7/29/2010 smallint(2) No







MEDPROS/PHA-OLD 16 Old-Overall Health 24 ChronicPain
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 16 Old-Overall Health 25 Diabetes_OverallHealth
Yes 7/29/2010 smallint(2) No







MEDPROS/PHA-OLD 16 Old-Overall Health 26 Epilepsy
Yes 7/29/2010 smallint(2) No







MEDPROS/PHA-OLD 16 Old-Overall Health 28 FrequentHeadaches
Yes 7/29/2010 smallint(2) No







MEDPROS/PHA-OLD 16 Old-Overall Health 29 HeartMurmur
Yes 7/29/2010 smallint(2) No







MEDPROS/PHA-OLD 16 Old-Overall Health 30 HeartTroubleChestPain
Yes 7/29/2010 smallint(2) No







MEDPROS/PHA-OLD 16 Old-Overall Health 31 HighBloodPressure
Yes 7/29/2010 smallint(2) No







MEDPROS/PHA-OLD 16 Old-Overall Health 32 HIV
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 16 Old-Overall Health 34 Hospitalized
Yes 7/29/2010 char(1) No







MEDPROS/PHA-OLD 16 Old-Overall Health 35 HospitalizedProviderComment Yes Yes 7/29/2010 varchar(500) y







MEDPROS/PHA-OLD 16 Old-Overall Health 36 HospitalizedSoldierComment Yes Yes 7/29/2010 varchar(300) y







MEDPROS/PHA-OLD 16 Old-Overall Health 38 JointPain
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 16 Old-Overall Health 39 KidneyDisease
Yes 7/29/2010 smallint(2) No







MEDPROS/PHA-OLD 16 Old-Overall Health 40 LiverDisease
Yes 7/29/2010 smallint(2) No







MEDPROS/PHA-OLD 16 Old-Overall Health 41 MedicalOrDentalProblems
Yes 7/29/2010 char(1) No







MEDPROS/PHA-OLD 16 Old-Overall Health 42 MedicalOrDentalProblemsProviderComment Yes Yes 7/29/2010 varchar(500) y







MEDPROS/PHA-OLD 16 Old-Overall Health 43 MedicalOrDentalProblemsSinceLastExam
Yes 7/29/2010 char(1) n







MEDPROS/PHA-OLD 16 Old-Overall Health 44 MedicalOrDentalProblemsSinceLastExamProviderComment Yes Yes 7/29/2010 varchar(500) y







MEDPROS/PHA-OLD 16 Old-Overall Health 45 MedicalOrDentalProblemsSinceLastExamSoldierComment Yes Yes 7/29/2010 varchar(300) y







MEDPROS/PHA-OLD 16 Old-Overall Health 46 MedicalOrDentalProblemsSoldierComment Yes Yes 7/29/2010 varchar(300) y







MEDPROS/PHA-OLD 16 Old-Overall Health 47 MedicationOrPrescription
Yes 7/29/2010 char(1) y







MEDPROS/PHA-OLD 16 Old-Overall Health 48 MedicationOrPrescriptionProviderComment Yes Yes 7/29/2010 varchar(500) y







MEDPROS/PHA-OLD 16 Old-Overall Health 49 MedicationOrPrescriptionSoldierComment Yes Yes 7/29/2010 varchar(300) y







MEDPROS/PHA-OLD 16 Old-Overall Health 50 MedicationOrPrescriptionYes
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 16 Old-Overall Health 51 MentalHealthConcerns
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 16 Old-Overall Health 52 None_OverallHealth
Yes 7/29/2010 smallint(2) No







MEDPROS/PHA-OLD 16 Old-Overall Health 53 Other_OverallHealth
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 16 Old-Overall Health 54 OtherExplanation_OverallHealth Yes Yes 7/29/2010 varchar(100) y







MEDPROS/PHA-OLD 16 Old-Overall Health 55 OverallHealthProviderQuestion1 Yes Yes 7/29/2010 varchar(300) y







MEDPROS/PHA-OLD 16 Old-Overall Health 56 OverallHealthSoldierQuestion1 Yes Yes 7/29/2010 varchar(300) y







MEDPROS/PHA-OLD 16 Old-Overall Health 57 ProviderComments Yes Yes 7/29/2010 varchar(100) y







MEDPROS/PHA-OLD 16 Old-Overall Health 58 ReceivingVADisability
Yes 7/29/2010 char(1) No







MEDPROS/PHA-OLD 16 Old-Overall Health 59 ReceivingVADisabilityProviderComment Yes Yes 7/29/2010 varchar(500) y







MEDPROS/PHA-OLD 16 Old-Overall Health 60 ReceivingVADisabilitySoldierComment Yes Yes 7/29/2010 varchar(300) y







MEDPROS/PHA-OLD 16 Old-Overall Health 61 RheumaticFever
Yes 7/29/2010 smallint(2) No







MEDPROS/PHA-OLD 16 Old-Overall Health 62 SinusDisease
Yes 7/29/2010 smallint(2) No







MEDPROS/PHA-OLD 16 Old-Overall Health 64 STD
Yes 7/29/2010 smallint(2) No







MEDPROS/PHA-OLD 16 Old-Overall Health 65 Stroke
Yes 7/29/2010 smallint(2) No







MEDPROS/PHA-OLD 16 Old-Overall Health 66 ThyroidDisease
Yes 7/29/2010 smallint(2) No







MEDPROS/PHA-OLD 16 Old-Overall Health 67 TreatedByDentistOrPhysician
Yes 7/29/2010 char(1) No







MEDPROS/PHA-OLD 16 Old-Overall Health 68 TreatedByDentistOrPhysicianProviderComment Yes Yes 7/29/2010 varchar(500) y







MEDPROS/PHA-OLD 16 Old-Overall Health 69 TreatedByDentistOrPhysicianSoldierComment Yes Yes 7/29/2010 varchar(300) y







MEDPROS/PHA-OLD 16 Old-Overall Health 70 Tuberculosis
Yes 7/29/2010 smallint(2) No







MEDPROS/PHA-OLD 16 Old-Overall Health 71 Ulcers
Yes 7/29/2010 smallint(2) No







MEDPROS/PHA-OLD 17 Old-Preventative 1 alCantStopDrinking
Yes 7/29/2010 varchar(10) Yes







MEDPROS/PHA-OLD 17 Old-Preventative 2 alCantStopDrinkingCounseling
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 17 Old-Preventative 3 alCantStopDrinkingReferral
Yes 7/29/2010 int(4) Yes







MEDPROS/PHA-OLD 17 Old-Preventative 4 alConcerned
Yes 7/29/2010 varchar(10) Yes







MEDPROS/PHA-OLD 17 Old-Preventative 5 alConcernedCounseling
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 17 Old-Preventative 6 alConcernedReferral
Yes 7/29/2010 int(4) Yes







MEDPROS/PHA-OLD 17 Old-Preventative 7 alDrinkContaining
Yes 7/29/2010 varchar(10) Yes







MEDPROS/PHA-OLD 17 Old-Preventative 8 alDrinkContainingCounseling
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 17 Old-Preventative 9 alDrinkContainingReferral
Yes 7/29/2010 int(4) Yes







MEDPROS/PHA-OLD 17 Old-Preventative 13 toDip
Yes 7/29/2010 varchar(10) Yes







MEDPROS/PHA-OLD 17 Old-Preventative 14 toDipCounseling
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 17 Old-Preventative 15 toDipReferral
Yes 7/29/2010 int(4) Yes







MEDPROS/PHA-OLD 17 Old-Preventative 16 toSmoke
Yes 7/29/2010 varchar(10) Yes







MEDPROS/PHA-OLD 17 Old-Preventative 17 toSmokeCounseling
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 17 Old-Preventative 18 toSmokeReferral
Yes 7/29/2010 int(4) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 2 BehavioralHealthProvider
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 3 ExperienceAvoidSituations
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 4 ExperienceNightmares
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 5 ExperienceNumb
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 6 ExperienceStartled
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 9 mhFeelingDown
Yes 7/29/2010 varchar(10) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 10 mhFeelingDownCounseling
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 11 mhFeelingDownReferral
Yes 7/29/2010 int(4) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 12 mhLittleInterest
Yes 7/29/2010 varchar(10) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 13 mhLittleInterestCounseling
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 14 mhLittleInterestReferral
Yes 7/29/2010 int(4) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 15 mhThoughts
Yes 7/29/2010 varchar(10) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 16 mhThoughtsCounseling
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 17 mhThoughtsReferral
Yes 7/29/2010 int(4) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 18 ProviderComments Yes Yes 7/29/2010 varchar(1000) y







MEDPROS/PHA-OLD 18 Old-Behavioral Health 19 Question1
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 20 Question2A
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 21 Question2B
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 22 Question2C
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 23 Question2D
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 24 Question2E
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 25 Question2F
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 26 Question2G
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 27 Question2H
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 28 Question3A
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 29 Question3B
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 30 Question3C
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 31 Question3D
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 32 Question3E
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 33 Question3F
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 34 Question3G
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 18 Old-Behavioral Health 35 Question3H
Yes 7/29/2010 char(1) Yes







MEDPROS/PHA-OLD 19 Old-Family History 34 ChemicalDependencyFather
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 35 ChemicalDependencyFatherType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-OLD 19 Old-Family History 36 ChemicalDependencyMaternalGrandFather
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 37 ChemicalDependencyMaternalGrandFatherType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-OLD 19 Old-Family History 38 ChemicalDependencyMaternalGrandMother
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 39 ChemicalDependencyMaternalGrandMotherType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-OLD 19 Old-Family History 40 ChemicalDependencyMother
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 41 ChemicalDependencyMotherType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-OLD 19 Old-Family History 42 ChemicalDependencyNone
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 43 ChemicalDependencyPaternalGrandFather
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 44 ChemicalDependencyPaternalGrandFatherType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-OLD 19 Old-Family History 45 ChemicalDependencyPaternalGrandMother
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 46 ChemicalDependencyPaternalGrandMotherType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-OLD 19 Old-Family History 47 ChemicalDependencySibling
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 48 ChemicalDependencySiblingType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-OLD 19 Old-Family History 49 ChemicalDependencyUnknown
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 50 ChemicalDependencyUnknownType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-OLD 19 Old-Family History 51 DiabetesFather
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 52 DiabetesFatherType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-OLD 19 Old-Family History 53 DiabetesMaternalGrandFather
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 54 DiabetesMaternalGrandFatherType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-OLD 19 Old-Family History 55 DiabetesMaternalGrandMother
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 56 DiabetesMaternalGrandMotherType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-OLD 19 Old-Family History 57 DiabetesMother
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 58 DiabetesMotherType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-OLD 19 Old-Family History 59 DiabetesNone
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 60 DiabetesPaternalGrandFather
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 61 DiabetesPaternalGrandFatherType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-OLD 19 Old-Family History 62 DiabetesPaternalGrandMother
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 63 DiabetesPaternalGrandMotherType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-OLD 19 Old-Family History 64 DiabetesSibling
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 65 DiabetesSiblingType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-OLD 19 Old-Family History 66 DiabetesUnknown
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 69 MentalHealthFather
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 70 MentalHealthFatherType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-OLD 19 Old-Family History 71 MentalHealthMaternalGrandFather
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 72 MentalHealthMaternalGrandFatherType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-OLD 19 Old-Family History 73 MentalHealthMaternalGrandMother
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 74 MentalHealthMaternalGrandMotherType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-OLD 19 Old-Family History 75 MentalHealthMother
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 76 MentalHealthMotherType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-OLD 19 Old-Family History 77 MentalHealthNone
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 78 MentalHealthPaternalGrandFather
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 79 MentalHealthPaternalGrandFatherType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-OLD 19 Old-Family History 80 MentalHealthPaternalGrandMother
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 81 MentalHealthPaternalGrandMotherType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-OLD 19 Old-Family History 82 MentalHealthSibling
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 19 Old-Family History 83 MentalHealthSiblingType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-OLD 19 Old-Family History 84 MentalHealthUnknown
Yes 7/29/2010 smallint(2) Yes







MEDPROS/PHA-OLD 20 Old-Medication 3 MedicineName
Yes 7/29/2010 varchar(300) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 2 BloodPressureDate
Yes 7/29/2010 datetime(8) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 3 BloodPressureDiastolic
Yes 7/29/2010 char(3) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 4 BloodPressureDiscussion
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 5 BloodPressureReferral
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 6 BloodPressureSystolic
Yes 7/29/2010 char(3) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 7 BloodStoolTestDate
Yes 7/29/2010 datetime(8) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 8 BloodStoolTestDiscussion
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 9 BloodStoolTestReferral
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 10 BloodSugar
Yes 7/29/2010 datetime(8) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 11 ChlamydiaDate
Yes 7/29/2010 datetime(8) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 12 ChlamydiaDiscussion
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 13 ChlamydiaReferral
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 14 Cholesterol
Yes 7/29/2010 int(4) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 15 CholesterolDate
Yes 7/29/2010 datetime(8) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 16 CholesterolDiscussion
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 17 CholesterolReferral
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 18 ColonoscopyDate
Yes 7/29/2010 datetime(8) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 19 ColonoscopyDiscussion
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 20 ColonoscopyReferral
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 22 EKGDate
Yes 7/29/2010 datetime(8) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 23 EKGDiscussion
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 24 EKGReferral
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 30 GonorrheaDate
Yes 7/29/2010 datetime(8) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 31 GonorrheaDiscussion
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 32 GonorrheaReferral
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 33 HDLCholesterol
Yes 7/29/2010 int(4) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 36 MammogramDate
Yes 7/29/2010 datetime(8) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 37 MammogramDiscussion
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 38 MammogramReferral
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 39 PapSmearDate
Yes 7/29/2010 datetime(8) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 40 PapSmearDiscussion
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 41 PapSmearReferral
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 42 SigmoidoscopyDate
Yes 7/29/2010 datetime(8) Yes







MEDPROS/PHA-OLD 21 Old-Evaluation 43 SigmoidoscopyDiscussion
Yes 7/29/2010 varchar(5) Yes







MEDPROS/PHA-OLD 22 Old-Framingham 3 BloodPressure
Yes 7/29/2010 char(7) Yes



PHA Form Element-blood pressure


MEDPROS/PHA-OLD 22 Old-Framingham 4 BloodPressureTreated
Yes 7/29/2010 varchar(10) Yes



PHA Form Element-untreated/treated boxes


MEDPROS/PHA-OLD 22 Old-Framingham 5 Diabetes_FraminghamCoronaryRisk
Yes 7/29/2010 char(1) Yes



PHA Form Element-n/a


MEDPROS/PHA-OLD 22 Old-Framingham 6 fkFormID_FraminghamCoronaryRisk
Yes 7/29/2010 bigint(8) No



PHA Form Element-n/a


MEDPROS/PHA-OLD 22 Old-Framingham 7 FraminghamCalculatedRisk
Yes 7/29/2010 char(7) Yes



PHA Form Element-framingham calculated risks


MEDPROS/PHA-OLD 22 Old-Framingham 8 FraminghamReferral
Yes 7/29/2010 int(4) Yes



PHA Form Element-n/a


MEDPROS/PHA-OLD 22 Old-Framingham 9 HDLCholesterol
Yes 7/29/2010 char(10) Yes



PHA Form Element-n/a


MEDPROS/PHA-OLD 22 Old-Framingham 10 ID_FraminghamCoronaryRisk
Yes 7/29/2010 bigint(8) No



PHA Form Element-n/a


MEDPROS/PHA-OLD 22 Old-Framingham 11 LDLCholesterol
Yes 7/29/2010 varchar(10) Yes



PHA Form Element-n/a


MEDPROS/PHA-OLD 22 Old-Framingham 12 Pregnant
Yes 7/29/2010 char(1) Yes



PHA Form Element-n/a


MEDPROS/PHA-OLD 22 Old-Framingham 13 Smoker
Yes 7/29/2010 char(1) Yes



PHA Form Element-n/a


MEDPROS/PHA-OLD 22 Old-Framingham 14 TotalCholesterol
Yes 7/29/2010 char(10) Yes



PHA Form Element-n/a


MEDPROS/PHA-OLD 23 Old-Counseling 1 alCantStopDrinking
Yes 7/29/2010 varchar(10) No







MEDPROS/PHA-OLD 23 Old-Counseling 2 alCantStopDrinkingCounseling
Yes 7/29/2010 varchar(5) No







MEDPROS/PHA-OLD 23 Old-Counseling 3 alCantStopDrinkingReferral
Yes 7/29/2010 int(4) No







MEDPROS/PHA-OLD 23 Old-Counseling 4 alConcerned
Yes 7/29/2010 varchar(10) No







MEDPROS/PHA-OLD 23 Old-Counseling 5 alConcernedCounseling
Yes 7/29/2010 varchar(5) No







MEDPROS/PHA-OLD 23 Old-Counseling 6 alConcernedReferral
Yes 7/29/2010 int(4) No







MEDPROS/PHA-OLD 23 Old-Counseling 7 alDrinkContaining
Yes 7/29/2010 varchar(10) No







MEDPROS/PHA-OLD 23 Old-Counseling 8 alDrinkContainingCounseling
Yes 7/29/2010 varchar(5) No







MEDPROS/PHA-OLD 23 Old-Counseling 9 alDrinkContainingReferral
Yes 7/29/2010 int(4) No







MEDPROS/PHA-OLD 23 Old-Counseling 13 mhFeelingDown
Yes 7/29/2010 varchar(10) No







MEDPROS/PHA-OLD 23 Old-Counseling 14 mhFeelingDownCounseling
Yes 7/29/2010 varchar(5) No







MEDPROS/PHA-OLD 23 Old-Counseling 15 mhFeelingDownReferral
Yes 7/29/2010 int(4) No







MEDPROS/PHA-OLD 23 Old-Counseling 16 mhLittleInterest
Yes 7/29/2010 varchar(10) No







MEDPROS/PHA-OLD 23 Old-Counseling 17 mhLittleInterestCounseling
Yes 7/29/2010 varchar(5) No







MEDPROS/PHA-OLD 23 Old-Counseling 18 mhLittleInterestReferral
Yes 7/29/2010 int(4) No







MEDPROS/PHA-OLD 23 Old-Counseling 19 mhThoughts
Yes 7/29/2010 varchar(10) No







MEDPROS/PHA-OLD 23 Old-Counseling 20 mhThoughtsCounseling
Yes 7/29/2010 varchar(5) No







MEDPROS/PHA-OLD 23 Old-Counseling 21 mhThoughtsReferral
Yes 7/29/2010 int(4) No







MEDPROS/PHA-OLD 23 Old-Counseling 22 toDip
Yes 7/29/2010 varchar(10) No







MEDPROS/PHA-OLD 23 Old-Counseling 23 toDipCounseling
Yes 7/29/2010 varchar(5) No







MEDPROS/PHA-OLD 23 Old-Counseling 24 toDipReferral
Yes 7/29/2010 int(4) No







MEDPROS/PHA-OLD 23 Old-Counseling 25 toSmoke
Yes 7/29/2010 varchar(10) No







MEDPROS/PHA-OLD 23 Old-Counseling 26 toSmokeCounseling
Yes 7/29/2010 varchar(5) No







MEDPROS/PHA-OLD 23 Old-Counseling 27 toSmokeReferral
Yes 7/29/2010 int(4) No







Sheet 3: 3.MEDPROS_PHA-New-USAPHC Atr
Source Source Tab Ord SourceTable Source Field Ord FieldName PII/HIPAA Sensitive USAPHC (Prov) Approval USAPHC (Prov) SP2Delta FieldType Nullability Primary Key Title Desc Values Notes FDM Comments ADS Comment Code Table Reference
MEDPROS/PHA-New 3 BehavioralHealth 3 FeelingBad
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 3 BehavioralHealth 4 SeenProvider
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 3 BehavioralHealth 5 Nightmares
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 3 BehavioralHealth 6 Avoidance
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 3 BehavioralHealth 7 OnGuard
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 3 BehavioralHealth 8 Numb
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 3 BehavioralHealth 9 LittleInterest Yes Yes 7/29/2010 varchar(50) Yes







MEDPROS/PHA-New 3 BehavioralHealth 10 LittleInterest_2
Yes 7/29/2010 varchar(25) Yes







MEDPROS/PHA-New 3 BehavioralHealth 11 PoorSleep
Yes 7/29/2010 varchar(25) Yes







MEDPROS/PHA-New 3 BehavioralHealth 12 Tired
Yes 7/29/2010 varchar(25) Yes







MEDPROS/PHA-New 3 BehavioralHealth 13 PoorAppetite
Yes 7/29/2010 varchar(25) Yes







MEDPROS/PHA-New 3 BehavioralHealth 14 FeelingBad_2
Yes 7/29/2010 varchar(25) Yes







MEDPROS/PHA-New 3 BehavioralHealth 15 FeelAFailure
Yes 7/29/2010 varchar(25) Yes







MEDPROS/PHA-New 3 BehavioralHealth 16 TroubleConcentrating
Yes 7/29/2010 varchar(25) Yes







MEDPROS/PHA-New 3 BehavioralHealth 17 SlowOrRestless
Yes 7/29/2010 varchar(25) Yes







MEDPROS/PHA-New 3 BehavioralHealth 18 HurtingSelf
Yes 7/29/2010 varchar(25) Yes







MEDPROS/PHA-New 3 BehavioralHealth 19 HowDifficult
Yes 7/29/2010 varchar(25) Yes







MEDPROS/PHA-New 3 BehavioralHealth 20 BehavHealthEd
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 3 BehavioralHealth 21 BehavHealthReferral Yes Yes 7/29/2010 varchar(50) Yes







MEDPROS/PHA-New 3 BehavioralHealth 22 AdditionalComments Yes Yes 7/29/2010 varchar(1000) Yes







MEDPROS/PHA-New 3 BehavioralHealth 23 PHQScore
Yes 7/29/2010 int(4) Yes







MEDPROS/PHA-New 4 CurrentHealth 3 Symptom
Yes 7/29/2010 varchar(75) No







MEDPROS/PHA-New 4 CurrentHealth 5 SoldierHas
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 4 CurrentHealth 7 SoldierCurrentlyTreated
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 4 CurrentHealth 9 SoldierComment Yes Yes 7/29/2010 varchar(200) Yes







MEDPROS/PHA-New 4 CurrentHealth 11 ProviderComment Yes Yes 7/29/2010 varchar(200) Yes







MEDPROS/PHA-New 5 Evaluation 3 Cholesterol
Yes 7/29/2010 int(4) Yes







MEDPROS/PHA-New 5 Evaluation 4 CholesterolDate
Yes 7/29/2010 datetime(8) Yes







MEDPROS/PHA-New 5 Evaluation 5 CholesterolDiscussion
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 5 Evaluation 6 CholesterolReferral Yes Yes 7/29/2010 varchar(50) Yes







MEDPROS/PHA-New 5 Evaluation 7 HDLCholesterol
Yes 7/29/2010 int(4) Yes







MEDPROS/PHA-New 5 Evaluation 8 HDLDiscussion Yes Yes 7/29/2010 varchar(50) Yes







MEDPROS/PHA-New 5 Evaluation 9 HDLReferral Yes Yes 7/29/2010 varchar(50) Yes







MEDPROS/PHA-New 5 Evaluation 10 MammogramDate
Yes 7/29/2010 datetime(8) Yes







MEDPROS/PHA-New 5 Evaluation 11 MammogramDiscussion
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 5 Evaluation 12 MammogramReferral Yes Yes 7/29/2010 varchar(50) Yes







MEDPROS/PHA-New 5 Evaluation 13 PapSmearDate
Yes 7/29/2010 datetime(8) Yes







MEDPROS/PHA-New 5 Evaluation 14 PapSmearDiscussion
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 5 Evaluation 15 PapReferral Yes Yes 7/29/2010 varchar(50) Yes







MEDPROS/PHA-New 5 Evaluation 16 ColorectalCancerDate
Yes 7/29/2010 datetime(8) Yes







MEDPROS/PHA-New 5 Evaluation 17 TestType
Yes 7/29/2010 varchar(30) Yes







MEDPROS/PHA-New 5 Evaluation 18 ColorectalCancerDiscussion
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 5 Evaluation 19 ColorectalCancerReferral Yes Yes 7/29/2010 varchar(50) Yes







MEDPROS/PHA-New 5 Evaluation 20 BloodPressureDate
Yes 7/29/2010 datetime(8) Yes







MEDPROS/PHA-New 5 Evaluation 21 BloodPressureDiscussion
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 5 Evaluation 22 BloodPressureReferral Yes Yes 7/29/2010 varchar(50) Yes







MEDPROS/PHA-New 5 Evaluation 23 BloodPressureDiastolic
Yes 7/29/2010 int(4) Yes







MEDPROS/PHA-New 5 Evaluation 24 BloodPressureSystolic
Yes 7/29/2010 int(4) Yes







MEDPROS/PHA-New 5 Evaluation 25 ReceivingBPTreatment
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 5 Evaluation 30 ChlamydiaDate
Yes 7/29/2010 datetime(8) Yes







MEDPROS/PHA-New 5 Evaluation 31 ChlamydiaDiscussion
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 5 Evaluation 32 ChlamydiaReferral Yes Yes 7/29/2010 varchar(50) Yes







MEDPROS/PHA-New 5 Evaluation 33 GonorrheaDate
Yes 7/29/2010 datetime(8) Yes







MEDPROS/PHA-New 5 Evaluation 34 GonorrheaDiscussion
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 5 Evaluation 35 GonorrheaReferral Yes Yes 7/29/2010 varchar(50) Yes







MEDPROS/PHA-New 5 Evaluation 39 FraminghamScore
Yes 7/29/2010 int(4) Yes







MEDPROS/PHA-New 6 FamilyHistory 3 FamilyMember Yes Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-New 6 FamilyHistory 5 CancerHistory
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 6 FamilyHistory 7 CancerType
Yes 7/29/2010 varchar(15) Yes







MEDPROS/PHA-New 6 FamilyHistory 9 CardioHistory
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 6 FamilyHistory 11 CardioType
Yes 7/29/2010 varchar(30) Yes







MEDPROS/PHA-New 6 FamilyHistory 13 DiabetesHistory
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 6 FamilyHistory 15 DiabetesType
Yes 7/29/2010 varchar(10) Yes







MEDPROS/PHA-New 6 FamilyHistory 17 MentalHlthHistory
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 6 FamilyHistory 19 MentalHlthType
Yes 7/29/2010 varchar(35) Yes







MEDPROS/PHA-New 6 FamilyHistory 21 ChemicalDepHistory
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 6 FamilyHistory 23 ChemicalDepType
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-New 7 Medications 2 OverallHealthID
Yes 7/29/2010 bigint(8) No



Internal ID generated by PHA database


MEDPROS/PHA-New 7 Medications 3 MedicationName
Yes 7/29/2010 varchar(250) Yes







MEDPROS/PHA-New 8 OverallHealth 3 QuestionIdentifier
Yes 7/29/2010 varchar(15) No







MEDPROS/PHA-New 8 OverallHealth 5 SoldierAnswer
Yes 7/29/2010 varchar(2) No







MEDPROS/PHA-New 8 OverallHealth 7 SoldierComment Yes Yes 7/29/2010 varchar(1000) Yes







MEDPROS/PHA-New 8 OverallHealth 9 ProviderComment Yes Yes 7/29/2010 varchar(1000) Yes







MEDPROS/PHA-New 10 PHAPerson 2 SSN DI Yes 7/29/2010 varchar(50) No Y






MEDPROS/PHA-New 10 PHAPerson 3 DOB DI Yes 7/29/2010 datetime(8) No







MEDPROS/PHA-New 10 PHAPerson 4 FirstName Yes Yes 7/29/2010 varchar(30) No







MEDPROS/PHA-New 10 PHAPerson 5 LastName y Yes 7/29/2010 varchar(50) No







MEDPROS/PHA-New 10 PHAPerson 6 Gender
Yes 7/29/2010 varchar(50) No







MEDPROS/PHA-New 10 PHAPerson 7 Compo Y Yes 7/29/2010 varchar(50) No







MEDPROS/PHA-New 10 PHAPerson 8 Rank DI Yes 7/29/2010 varchar(3) No







MEDPROS/PHA-New 10 PHAPerson 9 UnitCorrect Yes Yes 7/29/2010 varchar(50) Yes







MEDPROS/PHA-New 12 PreventativeHealth 3 IsSmoker
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 12 PreventativeHealth 4 FirstSmoke
Yes 7/29/2010 varchar(20) Yes







MEDPROS/PHA-New 12 PreventativeHealth 5 SmokeWhereForbidden
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 12 PreventativeHealth 6 SmokeGiveUp
Yes 7/29/2010 varchar(30) Yes







MEDPROS/PHA-New 12 PreventativeHealth 7 HowManySmokes
Yes 7/29/2010 varchar(15) Yes







MEDPROS/PHA-New 12 PreventativeHealth 8 SmokeMoreFrequently
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 12 PreventativeHealth 9 SmokeWhenIll
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 12 PreventativeHealth 10 SmokingScore
Yes 7/29/2010 int(4) Yes







MEDPROS/PHA-New 12 PreventativeHealth 11 SmokingReferral Yes Yes 7/29/2010 varchar(50) Yes







MEDPROS/PHA-New 12 PreventativeHealth 12 SmokingEd
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 12 PreventativeHealth 13 DoesChew
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 12 PreventativeHealth 14 FirstDip
Yes 7/29/2010 varchar(25) Yes







MEDPROS/PHA-New 12 PreventativeHealth 15 IntentionallySwallow
Yes 7/29/2010 varchar(15) Yes







MEDPROS/PHA-New 12 PreventativeHealth 16 DipGiveUp
Yes 7/29/2010 varchar(30) Yes







MEDPROS/PHA-New 12 PreventativeHealth 17 HowManyCans
Yes 7/29/2010 varchar(15) Yes







MEDPROS/PHA-New 12 PreventativeHealth 18 ChewMoreFrequently
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 12 PreventativeHealth 19 ChewWhenIll
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 12 PreventativeHealth 20 ChewingScore
Yes 7/29/2010 int(4) Yes







MEDPROS/PHA-New 12 PreventativeHealth 21 DipReferral Yes Yes 7/29/2010 varchar(50) Yes







MEDPROS/PHA-New 12 PreventativeHealth 22 DipEd
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 12 PreventativeHealth 23 AlcoholUse
Yes 7/29/2010 varchar(25) Yes







MEDPROS/PHA-New 12 PreventativeHealth 24 HowManyDrinks
Yes 7/29/2010 varchar(15) Yes







MEDPROS/PHA-New 12 PreventativeHealth 25 MoreThanSix
Yes 7/29/2010 varchar(30) Yes







MEDPROS/PHA-New 12 PreventativeHealth 26 UseMoreThanMean
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 12 PreventativeHealth 27 FeltShouldCutDown
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 12 PreventativeHealth 28 AlcoholReferral Yes Yes 7/29/2010 varchar(50) Yes







MEDPROS/PHA-New 12 PreventativeHealth 29 AlcoholEd
Yes 7/29/2010 varchar(1) Yes







MEDPROS/PHA-New 12 PreventativeHealth 30 AuditCScore
Yes 7/29/2010 int(4) Yes







MEDPROS/PHA-New 13 PULHES 15 Deployable
Yes 7/29/2010 varchar(1) Yes







File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00
© 2025 OMB.report | Privacy Policy