UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Customer Service' AND  applied_to_express='Y') WHERE code='3512';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Customer Service' AND  applied_to_express='Y') WHERE code='4221';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Customer Service' AND  applied_to_express='Y') WHERE code='4222';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Customer Service' AND  applied_to_express='Y') WHERE code='4223';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Customer Service' AND  applied_to_express='Y') WHERE code='4224';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Customer Service' AND  applied_to_express='Y') WHERE code='4225';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Customer Service' AND  applied_to_express='Y') WHERE code='4226';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Customer Service' AND  applied_to_express='Y') WHERE code='4227';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Customer Service' AND  applied_to_express='Y') WHERE code='4229';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Customer Service' AND  applied_to_express='Y') WHERE code='5111';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Customer Service' AND  applied_to_express='Y') WHERE code='5112';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Customer Service' AND  applied_to_express='Y') WHERE code='5113';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Customer Service' AND  applied_to_express='Y') WHERE code='5131';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Customer Service' AND  applied_to_express='Y') WHERE code='5132';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Customer Service' AND  applied_to_express='Y') WHERE code='5141';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Customer Service' AND  applied_to_express='Y') WHERE code='5142';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Customer Service' AND  applied_to_express='Y') WHERE code='5230';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Customer Service' AND  applied_to_express='Y') WHERE code='5245';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Customer Service' AND  applied_to_express='Y') WHERE code='5246';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Customer Service' AND  applied_to_express='Y') WHERE code='5249';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Executive' AND  applied_to_express='N') WHERE code='1111';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Executive' AND  applied_to_express='N') WHERE code='1112';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Executive' AND  applied_to_express='N') WHERE code='1113';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Executive' AND  applied_to_express='N') WHERE code='1114';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Executive' AND  applied_to_express='N') WHERE code='1120';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2111';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2112';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2113';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2114';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2120';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2131';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2132';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2133';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2141';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2142';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2143';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2144';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2145';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2146';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2149';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2151';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2152';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2153';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2161';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2162';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2163';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2164';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2165';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2166';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2211';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2212';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2221';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2222';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2230';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2240';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2250';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2261';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2262';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2263';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2264';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2265';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2266';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2267';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2269';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2310';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2320';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2330';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2341';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2342';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2351';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2352';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2353';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2354';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2355';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2356';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2359';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2411';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2412';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2413';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2421';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2422';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2423';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2424';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2431';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2432';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2511';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2512';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2513';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2514';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2519';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2521';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2522';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2523';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2529';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2611';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2612';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2619';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2621';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2622';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2631';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2632';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2633';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2634';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2635';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2636';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2641';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2642';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2643';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2651';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2652';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2653';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2654';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2655';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2656';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='2659';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3111';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3112';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3113';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3114';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3115';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3116';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3117';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3118';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3119';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3151';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3152';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3153';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3154';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3155';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3211';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3212';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3213';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3214';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3221';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3222';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3230';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3240';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3251';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3252';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3253';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3254';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3255';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3256';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3257';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3258';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3259';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3311';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3312';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3313';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3314';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3315';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3331';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3332';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3333';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3342';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3343';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3344';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3351';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3352';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3353';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3354';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3355';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3359';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3411';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3412';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3413';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3421';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3422';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='General Purpose' AND  applied_to_express='N') WHERE code='3423';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='N') WHERE code='1211';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='N') WHERE code='1212';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='N') WHERE code='1213';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='N') WHERE code='1219';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='N') WHERE code='1221';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='N') WHERE code='1222';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='N') WHERE code='1223';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='N') WHERE code='1311';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='N') WHERE code='1312';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='N') WHERE code='1321';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='N') WHERE code='1322';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='N') WHERE code='1323';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='N') WHERE code='1324';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='N') WHERE code='1330';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='N') WHERE code='3121';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='N') WHERE code='3122';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='N') WHERE code='3123';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='N') WHERE code='3341';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='N') WHERE code='0110';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='Y') WHERE code='1341';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='Y') WHERE code='1342';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='Y') WHERE code='1343';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='Y') WHERE code='1344';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='Y') WHERE code='1345';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='Y') WHERE code='1346';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='Y') WHERE code='1349';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='Y') WHERE code='1411';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='Y') WHERE code='1412';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='Y') WHERE code='1420';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='Y') WHERE code='1431';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='Y') WHERE code='1439';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Management' AND  applied_to_express='Y') WHERE code='0210';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='3131';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='3132';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='3133';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='3134';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='3135';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='3139';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='3141';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='3142';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='3143';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='3431';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='3432';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='3433';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='3434';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='3435';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='3511';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='3513';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='3514';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='3521';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='3522';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='4110';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='4120';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='4131';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='4132';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='4211';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='4212';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='4213';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='4214';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='4311';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='4312';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='4313';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='4321';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='4322';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='4323';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='4411';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='4412';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='4413';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='4414';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='4415';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='4416';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='4419';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='5120';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='5151';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='5152';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='5153';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='5161';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='5162';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='5163';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='5164';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='5165';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='5169';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='5311';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='5312';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='5321';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='5322';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='5329';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='5411';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='5412';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='5413';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='5414';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='5419';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='6111';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='6112';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='6113';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='6114';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='6121';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='6122';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='6123';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='6129';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='6130';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='6210';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='6221';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='6222';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='6223';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='6224';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='6310';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='6320';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='6330';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='6340';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7111';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7112';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7113';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7114';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7115';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7119';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7121';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7122';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7123';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7124';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7125';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7126';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7127';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7131';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7132';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7133';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7211';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7212';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7213';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7214';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7215';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7221';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7222';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7223';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7224';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7231';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7232';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7233';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7234';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7311';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7312';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7313';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7314';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7315';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7316';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7317';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7318';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7319';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7321';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7322';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7323';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7411';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7412';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7413';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7421';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7422';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7511';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7512';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7513';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7514';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7515';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7516';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7521';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7522';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7523';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7531';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7532';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7533';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7534';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7535';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7536';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7541';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7542';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7543';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7544';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='7549';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8111';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8112';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8113';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8114';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8121';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8122';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8131';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8132';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8141';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8142';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8143';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8151';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8152';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8153';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8154';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8155';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8156';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8157';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8159';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8160';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8171';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8172';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8181';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8182';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8183';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8189';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8211';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8212';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8219';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8311';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8312';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8321';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8322';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8331';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8332';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8341';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8342';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8343';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8344';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='8350';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9111';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9112';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9121';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9122';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9123';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9129';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9211';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9212';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9213';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9214';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9215';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9216';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9311';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9312';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9313';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9321';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9329';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9331';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9332';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9333';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9334';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9411';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9412';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9510';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9520';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9611';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9612';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9613';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9621';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9622';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9623';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9624';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='9629';
UPDATE  tl_occupation SET assessment_type='EXPRESS', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Non-Managers' AND  applied_to_express='Y') WHERE code='0310';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Sales' AND  applied_to_express='N') WHERE code='2433';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Sales' AND  applied_to_express='N') WHERE code='2434';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Sales' AND  applied_to_express='N') WHERE code='3321';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Sales' AND  applied_to_express='N') WHERE code='3322';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Sales' AND  applied_to_express='N') WHERE code='3323';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Sales' AND  applied_to_express='N') WHERE code='3324';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Sales' AND  applied_to_express='N') WHERE code='3334';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Sales' AND  applied_to_express='N') WHERE code='3339';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Sales' AND  applied_to_express='N') WHERE code='5211';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Sales' AND  applied_to_express='N') WHERE code='5212';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Sales' AND  applied_to_express='N') WHERE code='5221';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Sales' AND  applied_to_express='N') WHERE code='5222';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Sales' AND  applied_to_express='N') WHERE code='5223';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Sales' AND  applied_to_express='N') WHERE code='5241';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Sales' AND  applied_to_express='N') WHERE code='5242';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Sales' AND  applied_to_express='N') WHERE code='5243';
UPDATE  tl_occupation SET assessment_type='COMPREHENSIVE', assessment_level_id = (SELECT object_id FROM tl_level WHERE level_desc='Sales' AND  applied_to_express='N') WHERE code='5244';
