Zhilong's database ERD and SQL Scripts for Treatment Exam Templates (TOSCE)

OSCE Treatment Exam Templates  <=modules level
Resisted Remedial Exercises   themodule level:   module_id(mdle00001)
Communication (Cognitive): <-item1level:  item_id(item00001), ‘(Cognitive):’ is defined as item_code)

	in layman’s terms, explains to the client the procedure of applying resisted exercises <-sitem1 
	significant impairment   <- sitem2 level: sitem_id(sitem0002)
	two significant outcomes <- sitem3
	questions and responds (check in) correctly and clearly  <-sitem4
	benefits and possible negative reactions to the exercises and  <- sitem5
	confirms with the client that they can stop if there is a strong negative reaction <-sitem6

E__ G__ F__ P__ I__

Biomechanics, & Coordination <-item2: item_id(item00002)

	therapist demonstrates with clarity and good biomechanical form  <-sitem1: sitem_id(sitem0001)

E__ G__ F__ P__ I__

Technical & Safety (Cognitive/Psychomotor): <-item3: item_id(item00003)

	sets, reps, holding and rest periods, number of times per day and per week <-sitem1 sitem_id(sitem0001) 
	correct or suitable resisted exercise for the presenting condition  <-sitem2  sitem_id(sitem0003)
	witnesses that the client can perform the exercise  <-sitem3  sitem_id(sitem0004)

	was the student safe with the procedure Yes___  No ___  <-sitem4, for this subitem should be shown different type of grade being Yes or No from usual type being E_G_F_P_I  this Question would ask client for clear how the subitem is given mark would be  E… or given Yes/No only

E__ G__ F__ P__ I__







Sustained & Autogenic/Reciprocal Stretching Techniques themodule level:   module_id(mdle00002)
Communication (Cognitive):

	indications & goals for the uses of autogenic & reciprocal inhibition stretching techniques 
	in layman’s terms, clearly and accurately explains the procedure to client ‘
	check in with the client
	don’t let me move you or meet my resistance
	confirms with the client that the soft tissue is lengthened within the client's pain tolerance.

E__ G__ F__ P__ I__
Tissue Challenge, Biomechanics, & Coordination (Psychomotor):
	uses stable hand and biomechanics 
	stretches the appropriate target muscle for at least 30 sec’s and verifies with the client that the stretch is comfortable before the technique 
	accurately positions the body part into a less stretched position to facilitate an isometric or concentric muscle contraction stretches appropriate target muscle for 30 sec’s at the end of the technique 

E__ G__ F__ P__ I__
Technical & Safety (Cognitive/Psychomotor):
	repeats the process 3x for 6 to 8 sec (contract for 6 to 8 sec’s relax 2 seconds repeat 3x times)
	confirms client’s comfort throughout stretching technique
	held without bouncing until there is a release in the tissue being stretched

	was the student safe with the procedure Yes___  No ___

E__ G__ F__ P__ I__