APHDR Data Sets

Army Public Health Data Repository (APHDR)

MEDPROS-USAPHC (25).xlsx

APHDR Data Sets

OMB:

Document [xlsx]
Download: xlsx | pdf

Overview

1.Cover Letter
2.MEDPROS-CHPPM Atr
3.Provider Data Schema

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



Tab
Description
2. MEDPROS-CHPPM Atr Report on the attributes the CHPPM selected. Explaination of the report column heads appears below, titled Column Definitions.
3.Provider Data Schema Mapping of data elements from the Data Dictionary, tab 2.MEDPROS-CHPPM Atr, to the 3 tables that will be provided; IMR, Immunization, and PULHES.




Column Definitions



Column Name Description
A Source Name of Data Source
B TabOrd 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 FieldOrd 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 CHPPM (or NIMH) Approval User has accepted this as a valid element for their use-drop down list-Yes or No
G CHPPM (or NIMH) SP2Delta Date the data element requested in Spiral-2. This will help in revising your existing extract routines
H FieldType This is the data type .
I Nullability This is the Nullability condition.
J Primary Key Indicator if data element is a primary key (PK) or foreign key (FK) in this table
K Title Data Element Name
L Desc Dictionary meaning of the data element and enumerated values if applicable
M FDM Comments Please add any comments that will help us understand the output extract.
N PII/HIPPA Sensitive Please note YES or NO if the element is PII or HIPPA sensitive for de-identification
O ADS Comment Please add any comments on authoritativeness
P Code Table Reference Reference to code table.

Sheet 2: 2.MEDPROS-CHPPM Atr
Source Source Tab Ord SourceTable Source Field Ord FieldName CHPPM Approval CHPPM SP2Delta FieldType Nullability Primary Key Title Desc FDM Comments PII/HIPPA Sensitive ADS Comment Code Table Reference
MEDPROS 1 MEDPROS 1 SSN(3) Yes 10/21/2009 char(9) No PK Social Security Number, no dashes xxxxxxxxx-For PULHES Table Key Data element - all numbers 0-9
Yes

MEDPROS 1 MEDPROS 1 SSN(2) Yes 10/21/2009 char(9) No PK Social Security Number, no dashes xxxxxxxxx-For Immunization Table Key Data element - all numbers 0-9
Yes

MEDPROS 1 MEDPROS 1 SSN Yes 8/17/2009 char(9) No PK Social Security Number, no dashes xxxxxxxxx-For IMR Table Key Data element - all numbers 0-9 SSN only PII/HIPAA Sensitive Data elements; all other data elements are not PII/HIPAA sensitive UNLESS they are put together with the SSN. Yes

MEDPROS 1 MEDPROS 3 DENTAL CLASS Yes 8/17/2009 char(1) Yes No A code that indicates individual dental classification 1 – no current dental needs,
2 – minimal dental needs, low priority
3 – immediate dental needs
4 – no current exam on file

Ref: Para 7-7a of Army G1 Personnel Policy Guidance (PPG)
No

MEDPROS 1 MEDPROS 4 DENTAL DATE Yes 8/17/2009 char(8) Yes No Date of last dental exam YYYYMMDD; no future dates
No

MEDPROS 1 MEDPROS 5 VISION READY CLASS Yes 8/17/2009 char(2) Yes No Indicates vision readiness classification. 1 - soldier deployable, best binocular vision 20/20 or better
2 - soldier deployable, best binocular vision between 20/25 and 20/40
3O - soldier missing one or more required optical devices (glasses, mask inserts, or mission required contact lens, non-deployable.
3V - soldiers worst vision acuity group, corrected (or uncorrected if no corrected VAG posted) is worse than 20/40 (group 3), non-deployable
4 - soldier's last vision screening date older than 1 year or any soldier's distance VAG not populated or for soldier's => 45 years, near VAG not populated (blank fields for distance VAG or near VAG), soldier nondeployable.
No

MEDPROS 1 MEDPROS 6 VISION SCREENING DATE Yes 8/17/2009 char(8) Yes No Indicates date of last vision screening test YYYYMMDD; no future dates
No

MEDPROS 1 MEDPROS 7 HEARING READINESS CLASS Yes 8/17/2009 char(2) Yes No Indicates hearing readiness classification 1 – Soldier’s unaided hearing is within H-1 standards for both ears. Based on latest DD Form 2216 or DD Form 2215. Test is less than 13 months old.
2 – Soldier has DD Form 2215 or 2216 within past 13 months. Soldiers that are H2 must have a Complete Audiological Evaluation and DA 3349 profile. Soldiers that are H-3 and have a Complete Audiological Evaluation, DA 3349 and MMRB, and are found deployable.
3A – Complete audiological evaluation not complete
3B – Profile (DA Form 3349) not complete
3C – MMRB not complete
3D – MMRB finds Soldiers does not meet deployment standards for hearing
3E – Soldier meets HRC 2 standards, but does not have required Hearing aid and 6 month supply of batteries on hand
4 – Hearing exam date greater than 12 months old.
NA - no hearing classification needed
No

MEDPROS 1 MEDPROS 8 LAST HEARING EXAM DATE Yes 8/17/2009 char(8) Yes No Indicates date of last hearing exam YYYYMMDD; no future dates
No

MEDPROS 1 MEDPROS 9 SICKLE CELL Yes 8/17/2009 char(2) Yes No Indicates if personnel requires / has a Sickle Cell screening Y – requires/has screening
N – requires/does not have screening
NA – not applicable, does not require screening		 Frequently left blank No

MEDPROS 1 MEDPROS 10 SICKLE DATE Yes 8/17/2009 char(8) Yes No Indicate the date the Sickle Cell screening was conducted YYYYMMDD; no future dates
No

MEDPROS 1 MEDPROS 11 G6PD DATE Yes 8/17/2009 char(8) Yes No Indicates the date the Army Glucose 6-Phosphate Dehydrogenase (G6PD) Deficiency Screening was administered YYYYMMDD; no future dates
No

MEDPROS 1 MEDPROS 12 G6PD RESULT Yes 8/17/2009 char(1) Yes No Indicates the result of the Army Glucose 6-Phosphate Dehydrogenase (G6PD) Deficiency Screening N - Normal
D - Deficient
Blank		 Results may not always be posted with date of G6PD test No

MEDPROS 1 MEDPROS 13 DNA Yes 8/17/2009 char(1) Yes No Indicates if personnel has DNA on file with Armed Forces Institute of Pathology (AFIP) or if sample has been drawn. D - Drawn
Y - On file with AFIP
blank - no DNA on file
No

MEDPROS 1 MEDPROS 14 DNA DATE Yes 8/17/2009 char(8) Yes No Indicates date the DNA specimen was drawn YYYYMMDD; no future dates
No

MEDPROS 1 MEDPROS 15 HIV Yes 8/17/2009 char(1) Yes No Indicates if personnel has HIV antibody test on file or if sample has been drawn. D - Drawn
Y - On file
Blank - no HIV on file
No

MEDPROS 1 MEDPROS 16 HIV DATE Yes 8/17/2009 char(6) Yes No Indicates date (year / month) HIV sample was drawn YYYYMM
No

MEDPROS 1 MEDPROS 17 PERSONAL MEDICATIONS Yes 8/17/2009 char(2) Yes No Indicates if personnel requires/has personal medications (vitamins, non prescription meds, etc.) Y – requires/has personal medications
N – requires/does not have personal medications
NA – not applicable, does not require personal medications		 Frequently left blank No

MEDPROS 1 MEDPROS 18 PREGNANCY STATUS Yes 8/17/2009 char(1) Yes No Indicates pregnancy status of women personnel Y – pregnant
N – not pregnant
Blank for all male personnel		 Defaults to N (NO) for all new Female Soldiers once Individual Medical Readiness Record is created. No

MEDPROS 1 MEDPROS 19 PREGNANCY DATE Yes 8/17/2009 char(8) Yes No Indicates date of last pregnancy test. YYYYMMDD; no future dates date of last pregnancy test may not accompany all Pregnancy status entries. For some "N" Pregnancy status entries, this date may also represent the delivery date of a child (at which time the Soldier is no longer pregnant, no test necessary) No

MEDPROS 1 MEDPROS 20 PAP SMEAR DATE Yes 8/17/2009 char(8) Yes No Indicates date of last PAP smear test for female personnel. YYYYMMDD; no future dates
No

MEDPROS 1 MEDPROS 21 MAMMOGRAM DATE Yes 8/17/2009 char(8) Yes No Indicates date of last mammogram test YYYYMMDD; no future dates
No

MEDPROS 1 MEDPROS 22 BLOOD TYPE Yes 8/17/2009 char(3) Yes No Indicates blood type of individual A+, A-, B+, B-, O+, O-, AB+, AB- Sometimes left blank No

MEDPROS 1 MEDPROS 23 SCRIPS 180 DAYS Yes 8/17/2009 char(2) Yes No Indicates if personnel requires/has 180 days supply of prescription medication. Y – requires/has prescriptions
N – requires/does not have prescriptions
NA – not applicable, does not require prescriptions		 Sometimes left blank No

MEDPROS 1 MEDPROS 24 MEDICAL WARNING TAGS Yes 8/17/2009 char(2) Yes No Indicates if personnel requires/has medical warning tags Y – requires/has medical warning tags
N – requires/does not have medical warning tags
NA – not applicable, does not require medical warning tags		 Sometimes left blank No

MEDPROS 1 MEDPROS 25 MEDICAL NONDEPLOYABLE PROFILE Yes 8/17/2009 char(1) Yes No Indicates if personnel has a medical non-deployable profile Y – personnel has MND profile
N – personnel does not have MND profile		 Defaults to "N" (No) for all new Soldiers once Individual Medical Readiness Record is created. No

MEDPROS 1 MEDPROS 26 PHYSICAL QUALIFICATION Yes 8/17/2009 char(1) Yes No Indicates the USAR individual’s physical qualification as a result of the last physical examination A – qualified
B – temporarily disqualified
C – permanently disqualified
D – status pending verification		 Not applicable to Active Component Soldiers. No

MEDPROS 1 MEDPROS 27 LIMITED DUTY PROFILE Yes 8/17/2009 char(1) Yes No Indicates if personnel has a deployment limiting condition other than a 3 or 4 in PULHES (temporary or permanent) Y – personnel has deployment limiting condition
N – personnel does not have a deployment limiting condition
No

MEDPROS 1 MEDPROS 28 EXCEPT FAMILY MEMBER Yes 8/17/2009 char(2) Yes No Indicates if personnel has been queried for existence of Exceptional Family Members (with special medical or educational needs), and has been referred for screening and enrollment if appropriate. Y – soldier requires EFMP, has been referred
N – soldier requires EFMP, has not been referred
NA – not applicable, soldier does not require EFMP		 Frequently left blank No

MEDPROS 1 MEDPROS 29 MED RECORDS REVIEW Yes 8/17/2009 char(2) Yes No Indicates if personnel requires/has medical records reviewed. Y – requires/has medical records reviewed
N – requires/does not have medical records reviewed
NA – not applicable, does not require medical records reviewed		 Frequently left blank No

MEDPROS 1 MEDPROS 30 DD2766 COMPLETED Yes 8/17/2009 char(2) Yes No Indicates if Soldier requires/has completed a DD Form 2766 (Adult Preventive and Chronic Care Flowsheet).

The DD 2766 is the deployment health record for the deploying individual.		 Y – requires/has completed DD Form 2766
N – requires/does not have completed DD Form 2766
NA – not applicable, does not require completion of DD Form 2766		 Frequently left blank No

MEDPROS 1 MEDPROS 31 FLIGHT STATUS Yes 8/17/2009 char(1) Yes No The indication of whether an individual is required to perform regular and frequent aerial flights in performance of assigned duties, and thereby collects flight pay. Y – Soldier is on flight status
N – Soldier is not on flight status		 Frequently left blank No

MEDPROS 1 MEDPROS 32 DIVER/SF/MFF Yes 8/17/2009 char(1) Yes No The indication the Soldier has a special skill such as diver, military free fall or special forces D = SF or 00B diver
M = military free fall		 Frequently left blank No

MEDPROS 1 MEDPROS 33 DATE OF IMMUNIZATION Yes 8/17/2009 char(8) No PK Reflects the date the immunization / vaccination was given YYYYMMDD; no future dates Immunization data fields provided in separate file - due to multiple records for each SSN No

MEDPROS 1 MEDPROS 34 CDC (SHOT TYPE) Yes 8/17/2009 char(3) No PK Represents the Center for Disease Control (CDC) vaccination number Ref CDC website for official list of codes
http://www.cdc.gov/nip/registry/st_terr/tech/stds/hl7-cvx.htm
Note – MODS stores values with leading zero		 Immunization data fields provided in separate file No

MEDPROS 1 MEDPROS 35 DOSE (smallpox only) Yes 8/17/2009 char(5) Yes No Indicates the dose of the immunization given 3, 6, 15, or UNK Immunization data fields provided in separate file No

MEDPROS 1 MEDPROS 37 PHYSICAL DATE (DTLPE) Yes 8/17/2009 char(8) No PK Reflects date of physical encounter YYYYMMDD; no future dates Physical Exam Data fields provided in separate file - due to multiple records for each SSN No

MEDPROS 1 MEDPROS 38 PROFILE CODE 1 Yes 8/17/2009 char(1) Yes No Reflects the primary physical profile code. See AR 40-501, Standards of Medical Fitness A - no limitations
B - assignment limitations to protect against further physical damage/injury
C - impairments that limit functions or assignments
D - limited physical activity
E - no combat rations
F - no isolated assignment
G - Kevlar/LBE limitations
H - no hazardous duty
J - hearing protection
L - no cold temperatures
M - no high temperatures
N - no combat boots
P - clothing restrictions
T – waiver granted
U - other limitations
V - deployment restrictions
W - MOS Medical Review Board (MMRB)
X - waiver granted for continued active duty
Y - fit for duty		 Physical Exam Data fields provided in separate file - due to multiple records for each SSN No

MEDPROS 1 MEDPROS 39 PROFILE CODE 2 Yes 8/17/2009 char(1) Yes No Reflects the secondary physical profile code. See AR 40-501, Standards of Me See Profile Code 1 Physical Exam Data fields provided in separate file - due to multiple records for each SSN No

MEDPROS 1 MEDPROS 40 PROFILE CODE 3 Yes 8/17/2009 char(1) Yes No Reflects the additional physical profile code. See AR 40-501, Standards of Me See Profile Code 1 Physical Exam Data fields provided in separate file - due to multiple records for each SSN No

MEDPROS 1 MEDPROS 41 SOURCE Yes 8/17/2009 char(1) Yes No A code indicating the type of physical encounter A – PHA
B – Board
P – Profile (DA 3349)
E – Routine Physical Exam
L – Long Form Flight Exam (aviator)
S – Short Form Flight Exam (aviator)
O - Other (Divers, General Officers, etc.)		 Physical Exam Data fields provided in separate file - due to multiple records for each SSN.

While all are referred to as Physical Exams (generically) this code pinpoint the actual type of encounter.		 No

MEDPROS 1 MEDPROS 42 PULHES Yes 8/17/2009 char(6) Yes No A system of classifying the functional capabilities of the various organs, systems and integral parts of the body for the purpose of ascertaining an individual’s ability to perform various types of duty. Contains: Physical capacity, Upper extremities, Lower extremities, Hearing and ears, Eyes, and Psychiatric (S). 1 – Indicates an individual is considered to possess a high level of medical fitness.
2 – Indicates that an individual possesses some medical condition or physical defect that may require some activity limitations.
3 – Indicates that the individual has one or more medical conditions or physical defects that may require significant limitations. For those applying for military service, this designation is usually a disqualification. For individuals already in the service, the individual should receive assignments commensurate with his or her physical capability for military duty (ie, limited duty/assignments)
4 – Indicates that the individual has one or more medical conditions or physical defects of such severity that performance of military duty must be drastically limited. Definitely a disqualifier for both entering the military, and for continued military service, if already in the military.		 Physical Exam Data fields provided in separate file - due to multiple records for each SSN No

MEDPROS 1 MEDPROS 43 HEIGHT Yes 8/17/2009 char(2) Yes No The actual height of soldier, in inches, as indicated during the most current weigh-in or medical examination. Must be between 48 and 96 inches Physical Exam Data fields provided in separate file - due to multiple records for each SSN No

MEDPROS 1 MEDPROS 44 WEIGHT Yes 8/17/2009 char(3) Yes No The actual weight of soldier, in pounds, as indicated during the most current weigh-in or medical examination. Must be between 66 and 399 pounds Physical Exam Data fields provided in separate file - due to multiple records for each SSN No

MEDPROS 1 MEDPROS 45 DTADD Yes 8/17/2009 char(8) Yes No Reflects the date the physical was added to MODS (not to be confused with the date of the Physical) YYYYMMDD; no future dates Physical Exam Data fields provided in separate file - due to multiple records for each SSN No

MEDPROS 1 MEDPROS 46 DATA SOURCE Yes 8/17/2009 char(10) Yes No The (original) source of the physical record - MODS = data input directly into the MEDPROS Module of MODS, others listed are feeder systems that send data to MEDPROS. AERO
AHLTA
ARIS
MEDBASE
MEDNET
MODS
PHA
TAPDB		 Physical Exam Data fields provided in separate file - due to multiple records for each SSN No

MEDPROS 1 MEDPROS 47 STATUS Yes 8/17/2009 char(1) Yes No Flag indicating the status of the record A - Active Record
H - Historical Record
D - Deleted Record		 Physical Exam Data fields provided in separate file - due to multiple records for each SSN No

MEDPROS 1 MEDPROS 48 DELETE DATE Yes 8/17/2009 char(8) Yes No Reflects when the record was deleted (will only be populated when STATUS is D (deleted) YYYYMMDD; no future dates Physical Exam Data fields provided in separate file - due to multiple records for each SSN No

















NOTE: SSN appears multiple times to account for their specific occurrences in a specific provider table.














Sheet 3: 3.Provider Data Schema

Suicide Mitigation Data Schema by Provider for CHPPM







10/28/2009

MEDPROS - Medical Protection System









Provider Table

Field Name Field Type Nullability Primary Key Source Field Title Source Ord Source Table











1 IMR










1
SSN char(9) No PK Social Security Number, no dashes xxxxxxxxx 1. 1 MEDPROS


2
DENTAL CLASS char(1) Yes No A code that indicates individual dental classification 1. 3 MEDPROS


3
DENTAL DATE char(8) Yes No Date of last dental exam 1. 4 MEDPROS


4
VISION READY CLASS char(2) Yes No Indicates vision readiness classification. 1. 5 MEDPROS


5
VISION SCREENING DATE char(8) Yes No Indicates date of last vision screening test 1. 6 MEDPROS


6
HEARING READINESS CLASS char(2) Yes No Indicates hearing readiness classification 1. 7 MEDPROS


7
LAST HEARING EXAM DATE char(8) Yes No Indicates date of last hearing exam 1. 8 MEDPROS


8
SICKLE CELL char(2) Yes No Indicates if perosnnel requires / has a Sickle Cell screening 1. 9 MEDPROS


9
SICKLE DATE char(8) Yes No Indicate the date the Sickle Cell screening was conducted 1. 10 MEDPROS


10
G6PD DATE char(8) Yes No Indicates the date the Army Glucose 6-Phosphate Dehydrogenase (G6PD) Deficiency Screening was administered 1. 11 MEDPROS


11
G6PD RESULT char(1) Yes No Indicates the result of the Army Glucose 6-Phosphate Dehydrogenase (G6PD) Deficiency Screening 1. 12 MEDPROS


12
DNA char(1) Yes No Indicates if personnel has DNA on file with Armed Forces Institute of Pathology (AFIP) or if sample has been drawn. 1. 13 MEDPROS


13
DNA DATE char(8) Yes No Indicates date the DNA specimen was drawn 1. 14 MEDPROS


14
HIV char(1) Yes No Indicates if personnel has HIV antibody test on file or if sample has been drawn. 1. 15 MEDPROS


15
HIV DATE char(6) Yes No Indicates date (year / month) HIV sample was drawn 1. 16 MEDPROS


16
PERSONAL MEDICATIONS char(2) Yes No Indicates if personnel requires/has personal medications (vitamins, non prescription meds, etc.) 1. 17 MEDPROS


17
PREGNANCY STATUS char(1) Yes No Indicates pregnancy status of women personnel 1. 18 MEDPROS


18
PREGNANCY DATE char(8) Yes No Indicates date of last pregnancy test. 1. 19 MEDPROS


19
PAP SMEAR DATE char(8) Yes No Indicates date of last PAP smear test for female personnel. 1. 20 MEDPROS


20
MAMMOGRAM DATE char(8) Yes No Indicates date of last mammogram test 1. 21 MEDPROS


21
BLOOD TYPE char(3) Yes No Indicates blood type of individual 1. 22 MEDPROS


22
SCRIPS 180 DAYS char(2) Yes No Indicates if personnel requires/has 180 days supply of prescription medication. 1. 23 MEDPROS


23
MEDICAL WARNING TAGS char(2) Yes No Indicates if personnel requires/has medical warning tags 1. 24 MEDPROS


24
MEDICAL NONDEPLOYABLE PROFILE char(1) Yes No Indicates if personnel has a medical non-deployable profile 1. 25 MEDPROS


25
PHYSICAL QUALIFICATION char(1) Yes No Indicates the usar individual’s physical qualification as a result of the last physical examination 1. 26 MEDPROS


26
LIMITED DUTY PROFILE char(1) Yes No Indicates if personnel has a deployment limiting condition other than a 3 or 4 in PULHES (temporary or permanent) 1. 27 MEDPROS


27
EXCEPT FAMILY MEMBER char(2) Yes No Indicates if personnel has been queried for existence of Exceptional Family Members (with special medical or educational needs), and has been referred for screening and enrollment if appropriate. 1. 28 MEDPROS


28
MED RECORDS REVIEW char(2) Yes No Indicates if personnel requires/has medical records reviewed. 1. 29 MEDPROS


29
DD2766 COMPLETED char(2) Yes No Indicates if indicate requires/has completed DD Form 2766 (Adult Preventive and Chronic Care Flowsheet).

The DD 2766 is the deployment health record for the deploying individual. 		1. 30 MEDPROS


30
FLIGHT STATUS char(1) Yes No The indication of whether an individual is required to perform regular and frequent aerial flights in performance of assigned duties, and thereby collects flight pay. 1. 31 MEDPROS


31
DIVER/SF/MFF char(1) Yes No The indication the Soldier has a special skill such as diver, military free fall or special forces 1. 32 MEDPROS
2 Immunization










1
SSN(2) char(9) No PK Social Security Number, no dashes xxxxxxxxx 1. 1 MEDPROS


2
DATE OF IMMUNIZATION char(8) No PK Reflects the date the immunization / vaccination was given 1. 33 MEDPROS


3
CDC (SHOT TYPE) char(3) No PK Represents the Center for Disease Control (CDC) vaccination number 1. 34 MEDPROS


4
DOSE (smallpox only) char(5) Yes No Indicates the dose of the immunization given 1. 35 MEDPROS
3 PULHES










1
SSN(3) char(9) No PK Social Security Number, no dashes xxxxxxxxx 1. 1 MEDPROS


2
PHYSICAL DATE (DTLPE) char(8) No PK Reflects date of physical encounter 1. 37 MEDPROS


3
PROFILE CODE 1 char(1) Yes No Reflects the primary physical profile code. See AR 40-501, Standands of Medical Fitness 1. 38 MEDPROS


4
PROFILE CODE 2 char(1) Yes No Reflects the secondary physical profile code. See AR 40-501, Standands of Me 1. 39 MEDPROS


5
PROFILE CODE 3 char(1) Yes No Reflects the additional physical profile code. See AR 40-501, Standands of Me 1. 40 MEDPROS


6
SOURCE char(1) Yes No A code indicating the type of physical encounter 1. 41 MEDPROS


7
PULHES char(6) Yes No A system of classifying the functional capabilities of the various organs, systems and integral parts of the body for the purpose of ascertaining an individual’s ability to perform various types of duty. Contains: Physical capacity, Upper extremities, Lo 1. 42 MEDPROS


8
HEIGHT char(2) Yes No The actual height of soldier, in inches, as indicated during the most current weigh-in or medical examination. 1. 43 MEDPROS


9
WEIGHT char(3) Yes No The actual weight of soldier, in pounds, as indicated during the most current weigh-in or medical examination. 1. 44 MEDPROS


10
DTADD char(8) Yes No Reflects the date the physical was added to MODS (not to be confused with the date of the Physical) 1. 45 MEDPROS


11
DATA SOURCE char(10) Yes No The (original) source of the physical record - MODS = data input directly into the MEDPROS Module of MODS, others listed are feeder systems that send data to MEDPROS. 1. 46 MEDPROS


12
STATUS char(1) Yes No Flag indicating the status of the record 1. 47 MEDPROS


13
DELETE DATE char(8) Yes No Reflects when the record was deleted (will only be populated when STATUS is D (deleted) 1. 48 MEDPROS















Total Number of Attributes 48





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