Condition Occurrence types are determined for Condition Eras, based on a 30-day persistence window, as follows: Condition Occurrence Type Condition Occurrence Type Description 65 Condition Era, 30 day persistence window The sample CONDITION_ERA table is constructed from the condition data based on a 30-day persistence window, indicated by a CONDITION_OCCURRENCE_TYPE of “Era, 30-Day Persistence.” The sample representation of the above data in the CONDITION_ERA table follows. Condition Condition Person Confidence Condition Condition Condition Condition Era ID Start Date ID End Date Concept ID Occurrence Occurrence Type Count 4197598 121107 4197598 63 1 31967 29-JUL-2003 127260 4197598 63 2 CONDITION_OCCURRENCE_REF The Condition Occurrence Reference reflects the indicator(s) from which the Condition Occurrence was drawn or inferred, and indicates whether a condition (diagnosis) was primary or secondary and the relative positioning within a condition record. Person’s A detailed listing of the Condition Occurrence Types is included in . Field Data Type Required Description and Notes VARCHAR(3) YES The code indicating the type of Condition Occurrence. Condition Occurrence Type is used to define the source data indicators from which the Condition was identified, the level of standardization, and the type of occurrence. Conditions Types are defined as Primary/Secondary Diagnosis, Problem Report, and Person Status (including Mortality when available in the source data). A detailed listing of Condition Occurrence Types is recorded in VARCHAR(120) YES A detailed description of the Condition Occurrence Type. Valid values include Diagnosis from Inpatient Claims, Diagnosis from Outpatient visits, Diagnosis from ER visits, etc.
Condition Occurrence types are determined for Condition Eras, based on a 30-day persistence window, as follows: Condition Occurrence Type Condition Occurrence Type Description 65 Condition Era, 30 day persistence window The sample CONDITION_ERA table is constructed from the condition data based on a 30-day persistence window, indicated by a CONDITION_OCCURRENCE_TYPE of “Era, 30-Day Persistence.” The sample representation of the above data in the CONDITION_ERA table follows. Condition Era ID Condition Start Date Person ID Confidence Condition End Date Condition Concept ID Condition Occurrence Type Condition Occurrence Count 4197598 121107 4197598 63 1 31967 29-JUL-2003 127260 4197598 63 2 CONDITION_OCCURRENCE_REF The Condition Occurrence Reference reflects the indicator(s) from which the Condition Occurrence was drawn or inferred, and indicates whether a condition (diagnosis) was primary or secondary and the relative positioning within a Person’s condition record. A detailed listing of the Condition Occurrence Types is included in . Field Data Type Required Description and Notes VARCHAR(3) YES The code indicating the type of Condition Occurrence. Condition Occurrence Type is used to define the source data indicators from which the Condition was identified, the level of standardization, and the type of occurrence. Conditions Types are defined as Primary/Secondary Diagnosis, Problem Report, and Person Status (including Mortality when available in the source data). A detailed listing of Condition Occurrence Types is recorded in VARCHAR(120) YES A detailed description of the Condition Occurrence Type. Valid values include Diagnosis from Inpatient Claims, Diagnosis from Outpatient visits, Diagnosis from ER visits, etc.
4ab62b8893541e0adf6592bc0b362f26a7355e9d.docx