Determining Eligibility for School-Base Medi-Cal Administrative Activities (SMAA) https://www.dhcs.ca.gov/provgovpart/Pages/SMAA.aspx

The file must have the following fields:

• Last Name
• First Name
• Middle Initial (if available)
• Date of Birth (YYYYMMDD)
• Gender
• School Name (Optional)
• County Code (Optional)

Change the 20XX to the School year dates

Q1: 

• LIST LOC STU IDN ENR STU.LN STU.FN STU.MI (( CONVERT(VARCHAR(10), STU.BD, 112) )) STU.GN LOC.NM LOC.CC IF ENR.YR = 20XX AND ENR.SC = STU.SC AND ENR.SN = STU.SN AND ENR.ED >= 07/01/20XX AND ( ENR.LD <= 10/01/20XX OR ENR.LD = NULL ) 

Q2: 

• LIST LOC STU IDN ENR STU.LN STU.FN STU.MI (( CONVERT(VARCHAR(10), STU.BD, 112) )) STU.GN LOC.NM LOC.CC IF ENR.YR = 20XX AND ENR.SC = STU.SC AND ENR.SN = STU.SN AND ENR.ED <= 12/31/20XX AND ( ENR.LD >= 12/31/20XX OR ENR.LD = NULL ) 

Q3: 

• LIST LOC STU IDN ENR STU.LN STU.FN STU.MI (( CONVERT(VARCHAR(10), STU.BD, 112) )) STU.GN LOC.NM LOC.CC IF ENR.YR = 20XX AND ENR.SC = STU.SC AND ENR.SN = STU.SN AND ENR.ED <= 03/31/20XX AND ( ENR.LD >= 01/01/20XX OR ENR.LD = NULL )  

Q4: 

• LIST LOC STU IDN ENR STU.LN STU.FN STU.MI (( CONVERT(VARCHAR(10), STU.BD, 112) )) STU.GN LOC.NM LOC.CC IF ENR.YR = 20XX AND ENR.SC = STU.SC AND ENR.SN = STU.SN AND ENR.ED <= 06/30/20XX AND ( ENR.LD >= 04/01/20XX OR ENR.LD = NULL )