Posts

Showing posts from February 21, 2019

SQL Continuous Date Ranges Previously Grouped Data

Image
0 I'm working with a data extract that represents claims data for a population. The ultimate goal is to be able to associate specific claims to unique encounters. The way we'd define an encounter is a string of claims that are continuous, or within the same range; meaning the claim-to date is followed up by a claim-from date immediately after, or has an identical to & from date as another claim. However, because there is no key that actually indicates that a group of claims represent a specific encounter, we have to implement logic that does this for us. For the sake of this example, we've already grouped the data by Patient & Facility. CREATE TABLE #BillingData ( ClaimID VARCHAR(MAX) ,Patient VARCHAR(MAX) ,Facility VARCHAR(MAX) ,ClaimFromDate DATE ,ClaimToDate DATE ,GroupID VARCHAR(MA

Secondary education in the United States

Image
Winnebago Lutheran Academy, a private, Lutheran high school of the Wisconsin Evangelical Lutheran Synod (WELS) A high-school senior (twelfth grade) classroom in Calhan, Colorado Education in the United States By state and in insular areas By subject area History of Issues: Finance – Law – Literacy – Reform Levels: Pre-kindergarten – Primary – Secondary – Higher Organizations Education portal United States portal v t e In most jurisdictions, secondary education in the United States refers to the last four years of statutory formal education (grade 9 (age 14–15) through grade 12 (age 17–18)) either at high school or split between a final year of 'junior high school' and three in high school. [1] [2] [3] [4] Contents 1 History 2 Curriculum 2.1 Electives 3 Levels of education 3.1 Middle school / Junior high school 3.2 High school 4 Types of schools 4.1 Public schools 4.2 Private schools 4.3