Course License Discrepancy Report Logic 2019-20

[Pages:3]Start

1.) Select all Course Instructor

records for appropriate School

Year and Report Period into memory

Course License Discrepancy Report Logic 2019-20

Yes (no discrepancy exists)

2.) Select first/next Course Instructor

record

(clear status variables; Skip Dummy Staff IDs

555555555, 777777777 & 888888888)

2A.) Does staff member have 94 Gifted, 93 or 93S (SLP), 95 or 95S (RSP as Caseload Teacher), 97 (General SPED), 101 (Corrections Facility Teacher), 104 (Home

School/Family School Teacher) or 106 (SPEDAlternative/Family School Teacher)

assignment code at same district & location as course instructor record (and for same reporting period)?

No

2B.) Does staff member

have S (long term sub) or T (short term sub) staff

Yes

qualification status?

2C.) Does staff member have have a current 503

license?

0 (no course cert rqmts) No

From Page 2

3.) Lookup Course certification

requirements in Course

Certification Requirement table

based on first 4 characters of

Course Code Long

4.) # of records returned from Course Certification

Requirement table?

1 or multiple

5.) Load certification requirement record(s) into

memory

8.) Insert record into course

discrepancy table with Staff ID, Course Code, School Year, Status of "No

License Found", etc.

0 (discrepancy Exists)

P 1 of 3

7.) # of certification records returned for

staff member?

1 or multiple

Go to Step 9 (page 2)

6.) Do a lookup to Staff Certifications

table based on Staff ID. Load all staff certification

record(s) into memory

Dummy Staff IDs are omitted: 555555555 Religious Studies 777777777 Dual Credit/Concurrent Enrollment 888888888 Distance Learning/Online

Computer Course

Note: When checking licenses check both "regular" licenses and the HOUSSE, etc.

endorsement equivalents

Course License Discrepancy Report Logic

From Page 1

9.) Select first/next certification

requirement record

10.) Does staff member have required License Type/Level?

11.) Set temp

No

status variable to

"No Valid License"

Yes

12.) Is License Type/Level current?

13.) Set temp

No

status variable to

"License Expired"

Yes

14.) Is License Type/ Level = Approved, Approved Waiver, Reinstated, Reprimand or Pending? ***

15.) Set temp

status variable to

No

certification status

(e.g., "License Revoked".***)

Yes

17.) Does staff

member have

16.) Is an

appropriate

Endorsement

Yes

endorsement attached

Required?

to License Type/

Level?

No

16.5) Go to "Check BEP" p3

Yes

19.) Is Course taught in Bilingual Ed Program?

(Fld60 CourseInstructSnap=BEP

and CrseCd Not 10621067)?

No (no discrepancy exists)

20.) Does staff member

have appropriate

BILINGUAL endorsed

Yes

teaching lic (endorsement code = 67)

for matching License

Type/Level? Exception:

Doesn't apply to 520 Lic.

22.) Go to Step 2 (page 1)

Yes (no discrepancy exists)

20.5) Clarification. 520 license will not be found in

Course License Requirement Table as a valid license for teaching many courses, such as 3rd hour of Social

20) Clarification. Since the 520 Native Language and Culture Certificate is NEVER issued with a 67 Bilingual Endorsement, it skips this requirement.

Studies (core course) in Bilingual Ed Program. As long as they have the appropriate teaching license to teach the course, then the 67 Bilingual endorsement is not required and the 520 Native Language and Culture Certificate will suffice in lieu of the 67 Bilingual Endorsement on their teaching license. In other words,

the course may be taught in their native language (520

implies) and does not have to be taught in Spanish,

which is what the 67 Bilingual endorsement implies.

Yes

23.) Do more certification requirement records exist?

24.) Determine actual status. Hierarchy is:

No (license Discrepancy exists)

1. Lacks Bilingual Endorsement 2. Lacks Endorsement 3. License Revoked, etc. 4. License Expired 5. No Valid License

25.) Exit loop, insert record into

course discrepancy table

with Staff ID, Course Code, School Year, Enrollment Period Num and status

variable

18.) Set temp

status variable to

No

"Lacks

Endorsement"

21.) Set temp

No

20.5) Has 520 Lic?

No

status variable to "Lacks Bilingual

Endorsement"

P 2 of 3

Go to Step A (page 1)

***Full list of Statuses: Results in license discrepancy: - License Revoked - License Cancelled - License Suspended - License Denied - License Inactive - License Pending - Disapproved Waiver - License Voluntary Surrender - License Forced Surrender

OK status won't result in license discrepancy: -Approved Waiver -Conditional -Reprimand -Reinstated -Ethics Case -License Case -Prosecution Pending -Open Investigation -Warning

Last Revision: 9/18/2019

*This page only applies to state-funded Bilingual Education Programs

(defined as BEP in Course Instructor) for courses 1062

& 1063.

Instead of creating separate Course Codes for ESL & ELD In BEP and

Not In BEP, separate logic is handled here for determining licensure for IN BEP. Not in Bilingual Education Program (Not BEP) are defined in Course License

Requirement Table.

Set temp status

variable to N "No Valid License"

SecondaryLic? 300/308,350,500/

505?

Set temp

status variable to "Lacks

N

Endorsement"

Y

Has TESOL (27) endorsement?

Y

*Check BEP (Bilingual Education Program) for special licensure requirements

Is field #60 (Course Special Pgm Cd) in Course Instructor Snapshot=BEP?

N

Return back to p2 to continue processing.

Y

Is 4-digit

Course

Code =

N

1062 ESL/

ELD?

Y

ElemLic requires Bilingual or TESOL endorsement; SecondaryLic requires

TESOL.

N

Is 4-digit Course Code = 1063-1067 EngLangArts ELD?

Y

Lic requires TESOL AND LangArts endorsements; 200/208 Elem K-8 requires TESOL endorsement only.

ElemLic?

N

200/208,250/

252,400/

408?

Set temp

ElemLic 200/ 208?

N

Lic 300/ 308,350,500/

505?

status N variable to

"No Valid

License"

Y

Y

TESOL(27)?

Y TESOL(27) AND

N

LangArts(20)

N

Has Bilingual (67) or

endorsements?

TESOL (27) endorsement?

N Set temp status variable

to "Lacks

Endorsement"

Y

No errors found for BEP check. Return back to p2

Y Y

Set temp status variable

to "Lacks Endorsement"

P 3 of 3

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download