Sanity Report using Ruleset Memes: Fri Jun 09 14:09:41 PDT 2000


This report is automatically produced by a Tcl script called RulesCheck.
Fri Jun 09 14:09:43 PDT 2000 Phase 1: Collect named datasets
Fri Jun 09 14:09:47 PDT 2000 Phase 2: Start rules check
Fri Jun 09 14:11:00 PDT 2000 Phase 3: Start recursive inclusion check


ERROR ============================================================= ERROR


Got 740 BundleMids, but there are 370 bundles in metabase.dbo.Mbundles


Rule002 ============================================================= Rule002


Every meme must have a syty. 

Exceptions:	NOST1            END                          
		Documentary      IP                           
		Documentary      ASCII                        
		Documentary      Video                        
		Documentary      ImageStatus                  
		Documentary      CCDctrl                      
		Documentary      DewarPower                   
		Documentary      ClockBias                    


Rule003 ============================================================= Rule003


Every meme must have a format id. 

Exceptions:	There are 602 exceptions to this rule (IDs below).  
		You have a serious problem.
		1121 1139 1144 1145 1154 1163 1238 1239 1257 1258 1260 1261 
		1276 1296 1297 1298 1299 1302 1324 1334 1352 1361 1397 1400 
		1401 1405 1407 1416 1427 1428 1451 1452 1477 1487 1488 1489 
		1497 1515 1576 1664 1665 1666 1667 1668 1669 1670 1671 1672 
		1673 1674 1675 1676 1677 1678 1679 1680 1681 1682 1683 1684 
		1712 1716 1718 1719 1720 1723 1724 1726 1730 1742 1745 1759 
		1760 1764 1769 1780 1782 1786 1787 1788 1789 1792 1793 2013 
		2014 2015 2016 2036 2066 2069 2075 2084 2100 2109 2117 2120 
		2127 2131 2133 2135 2136 2139 2140 2183 2185 2186 2194 2199 
		2208 2212 2213 2214 2215 2216 2217 2218 2220 2221 2222 2223 
		2224 2225 2226 2228 2229 2230 2231 2232 2256 2257 2258 2259 
		2260 2261 2262 2271 2272 2273 2274 2278 2280 2281 2282 2297 
		2298 2301 2302 2303 2304 2305 2307 2309 2311 2312 2313 2314 
		2315 2316 2317 2318 2319 2320 2321 2322 2323 2324 2325 2330 
		2331 2332 2333 2334 2335 2336 2337 2338 2339 2340 2342 2344 
		2345 2346 2348 2349 2350 2351 2354 2355 2356 2366 2367 2418 
		2420 2421 2422 2423 2424 2425 2426 2427 2428 2429 2430 2434 
		2435 2436 2437 2438 2439 2440 2441 2442 2443 2444 2445 2446 
		2447 2448 2449 2450 2451 2452 2453 2456 2457 2458 2459 2466 
		2467 2484 2485 2494 2495 2522 2523 2530 2533 2539 2540 2541 
		2560 2561 2562 2563 2564 2565 2566 2567 2568 2569 2574 2575 
		2578 2580 2746 2769 2793 2816 2839 2862 2885 2908 2931 2954 
		2977 3000 3023 3075 3098 3105 3106 3110 3114 3115 3116 3139 
		3162 3185 3208 3231 3254 3299 3310 3317 3324 3330 3336 3344 
		3352 3353 3354 3355 3356 3362 3363 3364 3370 3399 3401 3402 
		3403 3404 3405 3406 3443 3476 3499 3522 3548 3572 3607 3608 
		3609 3610 3611 3612 3613 3614 3615 3616 3617 3618 3619 3620 
		3621 3622 3623 3624 3625 3626 3627 3628 3629 3630 3631 3632 
		3633 3634 3635 3636 3637 3638 3639 3640 3641 3642 3643 3644 
		3645 3646 3647 3648 3649 3650 3651 3652 3653 3654 3655 3656 
		3657 3658 3659 3660 3661 3662 3663 3664 3665 3666 3667 3668 
		3669 3670 3671 3672 3673 3674 3675 3676 3677 3678 3679 3680 
		3681 3682 3683 3685 3686 3687 3694 3700 3702 3703 3705 3715 
		3772 4060 4193 4194 4195 4196 4212 4217 4218 4219 4220 4221 
		4225 4248 4249 4257 4259 4516 4517 4518 4519 4520 4521 4522 
		4523 4524 4525 4526 4528 4529 4530 4534 4563 4564 4565 4570 
		4571 4575 4576 4582 4590 4615 4629 4644 4645 4646 4647 4648 
		4670 4671 4672 4673 4674 4675 4679 4683 4684 4688 4693 4694 
		4695 4699 4703 4707 4716 4717 4721 4725 4729 4734 4739 4740 
		4763 4786 4792 4804 4808 4809 4811 4812 4813 4814 4815 4816 
		4817 4818 4819 4822 4823 4824 4825 4826 4827 4828 4829 4830 
		4831 4832 4833 4834 4845 4846 4857 4858 4859 4860 4861 4862 
		4863 4864 4874 4876 4877 4878 4885 4886 4901 4905 4939 4940 
		4941 4942 4992 4993 4994 4995 4996 4997 4998 4999 5000 5001 
		5002 5003 5004 5005 5006 5007 5008 5009 5010 5011 5013 5014 
		5015 5016 5017 5018 5019 5020 5021 5022 5023 5026 5027 5028 
		5029 5030 5031 5032 5033 5037 5041 5045 5049 5053 5054 5055 
		5056 5057 5058 5059 5060 5061 5062 5063 5064 5065 5066 5067 
		5068 5069 5070 5072 5073 5074 5076 5079 5085 5086 5087 5098 
		5109 5110 5133 5134 5135 5145 5146 5154 5155 5168 5173 5180 
		5183 5186 


Rule006 ============================================================= Rule006


Maxv cannot be less than minv. 

Exceptions:	NOST1            NAXISn           int         
		NOST1TABLE       NAXISn           int         
		cleanup          COLLTIP          real        
		cleanup          COLLTILT         real        


Rule008 ============================================================= Rule008


Nominal maxv cannot be greater than maxv. 

Exceptions:	cleanup          COLLTIP          real        
		cleanup          COLLTILT         real        


Rule009 ============================================================= Rule009


Nominal minv cannot be less than minv. 

Exceptions:	KECK1CCD         UTBM15V          real        
		esi              TVFILTRG         int         
		esi              TVFILVAL         real        
		cleanup          COLLTIP          real        
		cleanup          COLLTILT         real        
		esi              IMFLTRAW         int         
		esi              IMFLTVAL         real        
		esi              IMFLTTRG         int         
		esi              LDFLTRAW         int         
		esi              LDFLTVAL         real        
		esi              LDFLTTRG         int         


Rule010 ============================================================= Rule010


Any meme with a repeat mid must have a separator char. 

Exceptions:	There are 1010 exceptions to this rule (IDs below).  
		You have a serious problem.
		2749 2750 2758 2759 2760 2763 2764 2796 2805 2806 2807 2810 
		2811 2819 2828 2829 2830 2833 2834 2842 2851 2852 2853 2856 
		2857 2865 2874 2875 2876 2879 2880 2888 2897 2898 2899 2902 
		2903 2911 2920 2921 2922 2925 2926 2934 2943 2944 2945 2948 
		2949 2957 2966 2967 2968 2971 2972 2980 2989 2990 2991 2994 
		2995 3003 3012 3013 3014 3017 3018 3026 3035 3036 3037 3040 
		3041 3078 3087 3088 3089 3092 3093 3142 3143 3151 3152 3153 
		3156 3157 3165 3166 3174 3175 3176 3179 3180 3189 3197 3198 
		3199 3202 3203 3212 3220 3221 3222 3225 3226 3234 3235 3243 
		3244 3245 3248 3249 3258 3266 3267 3268 3271 3272 3301 3325 
		3331 3478 3486 3487 3489 3491 3495 3498 3501 3509 3510 3512 
		3514 3518 3521 3524 3532 3533 3535 3537 3541 3544 3550 3558 
		3559 3561 3563 3567 3574 3582 3583 3585 3587 3591 4581 4592 
		4600 4601 4603 4605 4609 4612 4625 4626 4627 4631 4632 4633 
		4634 4635 4636 4637 4638 4640 4685 4700 4704 4708 4713 4718 
		4722 4726 4730 4733 4735 4738 4750 4751 4753 4755 4759 4762 
		4773 4774 4776 4778 4782 4785 4791 4801 4802 4868 4870 4879 
		4880 4881 4882 4883 4884 4892 4902 4906 4907 4908 4909 4910 
		4911 4915 4927 4928 4929 4930 5038 5042 5046 5050 5094 5095 
		5105 5106 5118 5119 5122 5123 5124 5125 5126 5127 5147 5181 
		5184 5208 5213 5216 5235 5239 5247 5255 5265 5274 5275 5276 
		5279 5280 5287 5289 5292 5293 5294 5295 5296 5298 5300 5301 
		5302 5303 5306 5307 5308 5310 5311 5312 5314 5317 5322 5325 
		5331 5332 5333 5334 5350 5360 5362 5363 5373 5376 5377 5378 
		5379 5381 5382 5383 5384 5385 5387 5388 5389 5391 5393 5395 
		5396 5400 5420 5421 5422 5221 5358 5359 5361 2762 2766 2767 
		2809 2813 2814 2832 2836 2837 2855 2859 2860 2878 2882 2883 
		2901 2905 2906 2924 2928 2929 2947 2951 2952 2970 2974 2975 
		2993 2997 2998 3016 3020 3021 3039 3043 3044 3091 3095 3096 
		3155 3159 3160 3178 3182 3183 3201 3205 3206 3224 3228 3229 
		3247 3251 3252 3270 3274 3275 3490 3492 3493 3513 3515 3516 
		3536 3538 3539 3545 3546 3547 3562 3564 3565 3586 3588 3589 
		4604 4606 4607 4643 4686 4687 4701 4702 4705 4706 4709 4710 
		4714 4715 4719 4720 4723 4724 4727 4728 4731 4732 4736 4737 
		4754 4756 4757 4777 4779 4780 4903 4904 4931 4932 4933 4934 
		4935 4936 4937 4938 5039 5040 5043 5044 5047 5048 5051 5052 
		5182 5185 5278 5282 5283 5291 5324 5326 5375 5228 5344 5348 
		5349 5424 10 20 1373 2747 2748 2751 2752 2755 2756 2757 2761 
		2765 2794 2795 2797 2798 2799 2801 2802 2803 2804 2808 2812 
		2817 2818 2820 2821 2822 2824 2825 2826 2827 2831 2835 2840 
		2841 2843 2844 2845 2847 2848 2849 2850 2854 2858 2863 2864 
		2866 2867 2868 2870 2871 2872 2873 2877 2881 2886 2887 2889 
		2890 2891 2893 2894 2895 2896 2900 2904 2909 2910 2912 2913 
		2914 2916 2917 2918 2919 2923 2927 2932 2933 2935 2936 2937 
		2939 2940 2941 2942 2946 2950 2955 2956 2958 2959 2960 2962 
		2963 2964 2965 2969 2973 2978 2979 2981 2982 2983 2985 2986 
		2987 2988 2992 2996 3001 3002 3004 3005 3006 3008 3009 3010 
		3011 3015 3019 3024 3025 3027 3028 3029 3031 3032 3033 3034 
		3038 3042 3076 3077 3079 3080 3081 3083 3084 3085 3086 3090 
		3094 3140 3141 3144 3145 3148 3149 3150 3154 3158 3163 3164 
		3167 3168 3171 3172 3173 3177 3181 3186 3187 3190 3191 3193 
		3194 3195 3196 3200 3204 3209 3210 3213 3214 3217 3218 3219 
		3223 3227 3232 3233 3236 3237 3239 3240 3241 3242 3246 3250 
		3255 3256 3259 3260 3262 3263 3264 3265 3269 3273 3300 3303 
		3306 3308 3311 3312 3313 3314 3315 3316 3318 3319 3320 3321 
		3322 3323 3326 3327 3328 3329 3332 3333 3334 3335 3337 3338 
		3339 3340 3341 3342 3345 3346 3347 3348 3349 3350 3477 3479 
		3480 3482 3483 3484 3485 3488 3496 3497 3500 3502 3503 3505 
		3506 3507 3508 3511 3519 3520 3523 3525 3526 3528 3529 3530 
		3531 3534 3542 3543 3549 3551 3552 3554 3555 3556 3557 3560 
		3568 3569 3573 3575 3576 3578 3579 3580 3581 3584 3592 3593 
		3595 4577 4578 4579 4580 4583 4584 4585 4586 4587 4588 4591 
		4597 4598 4599 4602 4610 4611 4616 4617 4618 4628 4630 4639 
		4641 4642 4741 4742 4743 4744 4746 4747 4748 4749 4752 4760 
		4761 4764 4765 4766 4767 4769 4770 4771 4772 4775 4783 4784 
		4787 4788 4789 4790 4793 4794 4795 4796 4797 4798 4821 4836 
		4837 4838 4851 4852 4853 4854 4855 4856 4867 4869 4891 4893 
		4894 4895 4912 4914 4916 4917 4918 4953 5088 5089 5091 5092 
		5093 5096 5099 5100 5102 5103 5104 5107 5112 5113 5115 5116 
		5117 5120 5188 5207 5210 5211 5212 5217 5218 5222 5223 5224 
		5225 5226 5227 5230 5231 5232 5233 5238 5240 5241 5242 5243 
		5244 5246 5248 5249 5250 5251 5252 5254 5256 5257 5258 5259 
		5260 5262 5263 5264 5266 5267 5268 5270 5271 5272 5273 5277 
		5281 5285 5286 5290 5304 5305 5309 5316 5319 5320 5323 5328 
		5329 5330 5337 5338 5341 5342 5343 5346 5347 5351 5353 5386 
		5390 5392 5394 5399 5401 5414 5415 5429 5430 5426 2768 2815 
		2838 2861 2884 2907 2930 2953 2976 2999 3022 3045 3097 3161 
		3184 3207 3230 3253 3276 3309 3343 3351 3494 3517 3540 3566 
		3590 4589 4608 4619 4620 4621 4622 4623 4624 4758 4781 4799 
		4913 5097 5108 5121 5206 5214 5215 5219 5220 5284 5299 5313 
		5321 5327 5364 5369 5425 5335 5336 5234 5340 5366 5339 5352 
		5357 5365 2753 2800 2823 2846 2869 2892 2915 2938 2961 2984 
		3007 3030 3082 3146 3169 3192 3215 3238 3261 3302 3481 3504 
		3527 3553 3577 4595 4745 4768 5090 5101 5114 5209 5269 5297 
		5318 


Rule011 ============================================================= Rule011


All memes are supposed to have full semantic descriptions. 

Exceptions:	There are 732 exceptions to this rule (IDs below).  
		You have a serious problem.
		6 8 9 15 16 17 18 19 21 22 23 24 25 26 27 28 29 30 31 32 33 
		34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 
		55 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 
		76 77 78 79 80 81 82 83 84 86 87 88 91 92 93 94 95 96 97 98 
		99 100 101 102 103 104 105 109 114 115 116 117 118 119 120 121 
		122 123 124 125 126 127 128 131 132 133 138 141 142 143 144 
		145 146 147 148 149 150 151 152 154 155 156 157 158 159 160 
		161 162 163 164 165 168 169 170 171 172 173 175 176 177 178 
		179 180 181 182 184 185 186 187 188 189 190 191 192 193 194 
		195 196 197 198 199 200 201 202 203 204 206 207 208 209 210 
		211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 
		226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 
		241 242 258 261 262 263 264 265 271 275 276 277 278 279 280 
		281 282 283 284 285 286 287 288 289 291 298 299 300 301 302 
		303 304 305 306 307 308 309 310 311 312 313 318 319 320 321 
		322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 
		337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 
		352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 
		367 368 369 370 371 372 373 374 379 380 381 382 406 407 408 
		409 415 416 417 418 419 420 421 422 423 424 425 427 428 429 
		432 433 434 495 497 526 527 529 530 531 532 533 534 535 538 
		540 541 542 543 544 545 546 548 549 552 553 554 555 556 557 
		558 559 565 566 567 568 569 570 571 572 573 574 575 576 577 
		578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 
		593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 
		608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 
		623 624 625 626 627 628 629 630 631 632 633 635 636 637 639 
		640 641 642 643 644 645 647 648 649 650 651 652 653 654 655 
		656 657 658 1406 1407 3368 3369 3371 3372 3373 3374 3375 3376 
		3377 3378 3379 3380 3381 3382 3383 3384 3385 3386 3387 3388 
		3389 3390 3392 3393 3394 3395 3396 3397 3398 3400 4261 4262 
		4263 4264 4265 4266 4267 4268 4269 4270 4271 4272 4273 4274 
		4275 4276 4277 4278 4279 4280 4281 4282 4283 4284 4285 4286 
		4287 4288 4289 4290 4291 4292 4293 4294 4295 4296 4297 4298 
		4299 4300 4301 4302 4303 4304 4305 4306 4307 4308 4309 4310 
		4311 4312 4313 4314 4315 4316 4317 4318 4319 4320 4321 4322 
		4323 4324 4325 4326 4327 4328 4329 4330 4331 4332 4333 4334 
		4335 4336 4337 4338 4339 4340 4341 4342 4343 4344 4345 4346 
		4347 4348 4349 4350 4351 4352 4353 4354 4355 4356 4357 4358 
		4359 4360 4361 4362 4363 4364 4365 4366 4367 4368 4369 4370 
		4371 4372 4373 4374 4375 4376 4377 4378 4379 4380 4381 4382 
		4383 4384 4385 4386 4387 4388 4389 4390 4391 4392 4393 4394 
		4395 4396 4397 4398 4399 4400 4401 4402 4403 4404 4405 4406 
		4407 4408 4409 4410 4411 4412 4413 4414 4415 4416 4417 4418 
		4419 4420 4421 4422 4423 4424 4425 4426 4427 4428 4429 4430 
		4431 4432 4433 4434 4435 4436 4437 4438 4439 4440 4441 4442 
		4443 4444 4445 4446 4447 4448 4449 4450 4451 4452 4453 4454 
		4455 4456 4457 4458 4459 4460 4461 4462 4463 4464 4465 4466 
		4467 4468 4469 4470 4471 4472 4473 4474 4475 4476 4477 4478 
		4479 4480 4481 4482 4483 4484 4485 4486 4487 4488 4489 4490 
		4491 4492 4493 4494 4495 4496 4497 4498 4499 4500 4501 4502 
		4503 4504 4505 4506 4507 4508 4509 4510 4511 4512 4513 4514 
		4515 


Rule016 ============================================================= Rule016


Memes with a map_mid but no mmaps must be a format conversion, 
so isa_mid cannot be null. 

Exceptions:	HIRES1           CAFDITH          varchar(68) 
		HIRES1           COFDITH          varchar(68) 
		HIRES1           DECKDITH         varchar(68) 
		HIRES1           ECHDITH          varchar(68) 
		HIRES1           FIL1DITH         varchar(68) 
		HIRES1           FIL2DITH         varchar(68) 
		HIRES1           LFILDITH         varchar(68) 
		HIRES1           LSELDITH         varchar(68) 
		HIRES1           SHUTSTAT         int         
		HIRES1           SLITDITH         varchar(68) 
		HIRES1           TVADITH          varchar(68) 
		HIRES1           TVFDITH          varchar(68) 
		HIRES1           TVF1DITH         varchar(68) 
		HIRES1           TVF2DITH         varchar(68) 
		HIRES1           XDDITH           varchar(68) 
		template         manual.SEL       varchar(68) 
		KECKDCS2         POTOTAL          varchar(68) 
		template         pulse.stage.TRG  varchar(68) 
		expo             PMTTEST          varchar(68) 
		expo             PMTMODE          varchar(68) 
		expo             PMTCOL           char(5)     
		expo             PMTSTART         char(5)     
		expo             PMTDMP           char(5)     
		expo             PMTPOWER         char(5)     
		expo             PMTOVL           char(5)     
		expo             PMTRESET         char(5)     
		expo             EXMCAL           char(5)     
		KeckCCD.ESI      DWRMANF          varchar(68) 
		deimos3          G1TLTVEL         real        
		expo             PROP0VEL         real        
		KeckCCD.deimos   PANEn            varchar(68) 
		template         expometer.STA    varchar(68) 
		template         HC_135.MOD       char(8)     
		template         prop.MOD         char(8)     
		template         prop.STA         char(14)    


Rule021 ============================================================= Rule021


If mmaps but no map_mid, then it's a list of legit values. In 
which case par_mid must be null. 

Exceptions:	DataBase         einkey           char(2)     


Rule022 ============================================================= Rule022


If mmaps but no map_mid, then it's a list of legit values. In 
which case par_val must be null. 

Exceptions:	There are 59 exceptions to this rule (IDs below).  
		You have a serious problem.
		2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 
		2029 2030 2031 2032 2034 2035 2039 2283 2284 2290 2496 2497 
		2524 3358 3360 3361 3596 4227 4228 4229 4230 4231 4232 4233 
		4234 4235 4236 4237 4238 4239 4240 4241 4243 4244 4245 4246 
		4247 4258 4527 4531 4532 4694 4820 4844 4848 5036 5128 


Rule023 ============================================================= Rule023


If you have a map_mid and maps with non-null res_vals, then 
you must be a table lookup. So you must have an ISA. 

Exceptions:	HIRES1           AIRALARM         char(7)     
		HIRES1           COLL             char(4)     
		HIRES1           COLLRED          char(7)     
		HIRES1           COLLBLUE         char(8)     
		KECK1CCD         DWRMANF          varchar(68) 
		HIRES1           RACKDOWN         varchar(68) 
		HIRES1           UPSDOWN          varchar(68) 
		HIRES1           UPSLOW           varchar(68) 
		HIRES1           UPSBYPAS         varchar(68) 
		NOST1            BITPIX           tinyint     
		KECK1ACS         ACSSTAT          varchar(68) 
		KECK1DCS         AUTSTAT          varchar(68) 
		KECK1DCS         DCSSTAT          varchar(68) 
		KECK1DCS         DOMESTAT         varchar(68) 
		KECK1CCDlickserv IMTYPE           varchar(68) 
		KECK1DCS         FOCALSTN         varchar(68) 
		KECK1DCS         AXESTAT          varchar(68) 
		KECK1DCS         ROTMODE          varchar(68) 
		DEIMOS2          MANU0SEL         varchar(68) 
		DEIMOS2          MANU1SEL         varchar(68) 
		DEIMOS2          MANU2SEL         varchar(68) 
		DEIMOS2          N2DWRFIL         char(1)     
		NOST1+Y2K        TIMESYS          varchar(68) 
		DEIMOS2          DOORELEC         varchar(68) 
		deimos2          DOORS            char(1)     
		LICK.MOS         PO_ARMS          varchar(68) 
		LICK.MOS         XFERPATH         varchar(68) 
		template         pulse.stage.POS  varchar(68) 
		esi              COLLMODE         varchar(68) 
		KECKDCS2         COPRESET         varchar(68) 
		KECKDCS2         DOMEDSEL         varchar(68) 
		KECKDCS2         NODSET           varchar(68) 
		KECKDCS2         NODTEL           varchar(68) 
		KECKDCS2         POOFF            varchar(68) 
		KECKDCS2         PRESROT          varchar(68) 
		KECKDCS2         ROTSEL           varchar(68) 
		KECKDCS2         ROTSTAT          varchar(68) 
		KECKDCS2         SECSTAT          varchar(68) 
		KECKDCS2         TERTDEST         varchar(68) 
		KECKDCS2         TERTPOSN         varchar(68) 
		KECKDCS2         TERTSTAT         varchar(68) 
		KeckCCD.ESI      SHUTSTAT         varchar(68) 
		KeckCCD.ESI      CCDSPEED         char(6)     
		esi              COLLSTAT         varchar(68) 
		esi              COLLVRB          varchar(68) 
		IRCAL            READMODE         char(7)     
		IRCAL            DATAFORM         char(7)     
		SharedMemeMap    line_pixel       char(5)     
		SharedMemeMap    unit_of_time     char(8)     
		SharedMemeMap    slow_fast        char(4)     


Rule024 ============================================================= Rule024


If you are an mmaps record belonging to a meme with a map_mid 
and you have res_val, then you are a table lookup and you MUST 
have a par_val. 

Exceptions:	NOST1            BITPIX           tinyint     
		KECK1DCS         AUTSTAT          varchar(68) 
		pfcam            TVHRZORD         int         
		pfcam            TVFILORD         int         
		pfcam            DWFILORD         int         
		pfcam            DWFOCORD         int         
		NOST1+Y2K        TIMESYS          varchar(68) 
		DEMO             DEMOORD          int         
		template         dc.stage.ORD     int         
		IRCAL            APWHLORD         int         
		IRCAL            FLTR1ORD         int         
		IRCAL            FLTR2ORD         int         
		deimos3          G1TLTORD         int         
		SharedMemeMap    RADESYS          char(8)     


Rule025 ============================================================= Rule025


If you are an mmaps record belonging to a meme with a map_mid 
and you have res_val, then you are a table lookup and you should 
NOT have a par_mid. 

Exceptions:	There are 98 exceptions to this rule (IDs below).  
		You have a serious problem.
		2757 2758 2766 2804 2805 2813 2827 2828 2836 2850 2851 2859 
		2873 2874 2882 2896 2897 2905 2919 2920 2928 2942 2943 2951 
		2965 2966 2974 2988 2989 2997 3011 3012 3020 3034 3035 3043 
		3086 3087 3095 3150 3151 3159 3173 3174 3182 3196 3197 3205 
		3219 3220 3228 3242 3243 3251 3265 3266 3274 3485 3486 3492 
		3508 3509 3515 3531 3532 3538 3557 3558 3564 3581 3582 3588 
		4599 4600 4606 4749 4750 4756 4772 4773 4779 5093 5094 5104 
		5105 5117 5118 5221 5273 5274 5358 5359 5360 5361 5362 5363 
		5364 5430 


Rule027 ============================================================= Rule027


If you are the map of a meme and you have null res and you have 
parval and parmid, you are a functional map. If you are a functional 
map, you must have mbundles records. 

Exceptions:	MapUnits         mm               float       


Rule028 ============================================================= Rule028


If you are the par_mid of a functional map, you must also appear 
in the mbundle belonging to the map. check this in the aggregate, 
it's easier: all par_mids of this type must be emids of map-owned 
bundles. 

Exceptions:	
Exceptions:	Template         HomeOff          int         
		Template         HomeOff1         int         
		Template         HomeSpd1         int         
		Template         HomeAcc1         int         
		Template         HomeDec1         int         
		Template         HomeOff2         int         
		Template         HomeSpd2         int         
		Template         HomeAcc2         int         
		Template         HomeDec2         int         
		Template         HomeOff3         int         
		Template         HomeSpd3         int         
		Template         HomeAcc3         int         
		Template         HomeDec3         int         


Rule030 ============================================================= Rule030


All map_mids should be memes in the context MapTypes. 

Exceptions:	KECK1CCD         DWRN2LVM         varchar(68) 
		KECK1CCD         PWRBLOKM         varchar(68) 
		KECK1CCD         RESN2LVM         varchar(68) 
		KECK1CCD         TEMPDETM         varchar(68) 
		KECK1CCD         TEMPSETM         varchar(68) 
		KECK1CCD         UTBM15VM         varchar(68) 
		KECK1CCD         UTBP15VM         varchar(68) 
		KECK1CCD         UTBP30VM         varchar(68) 
		KECK1CCD         UTBP5VM          varchar(68) 
		KECK1CCD         UTBTEMPM         varchar(68) 
		KECK1CCD         UTBTMPSM         varchar(68) 
		Template         HomeParA         bundle      


Rule031 ============================================================= Rule031


All params to functional maps should be memes from the context 
MapParams. 

Exceptions:	


Rule032 ============================================================= Rule032


If you are a map, your syty should be map. 

Exceptions:	KECK1CCD         DWRN2LVM         varchar(68) 
		KECK1CCD         PWRBLOKM         varchar(68) 
		KECK1CCD         RESN2LVM         varchar(68) 
		KECK1CCD         TEMPDETM         varchar(68) 
		KECK1CCD         TEMPSETM         varchar(68) 
		KECK1CCD         UTBM15VM         varchar(68) 
		KECK1CCD         UTBP15VM         varchar(68) 
		KECK1CCD         UTBP30VM         varchar(68) 
		KECK1CCD         UTBP5VM          varchar(68) 
		KECK1CCD         UTBTEMPM         varchar(68) 
		KECK1CCD         UTBTMPSM         varchar(68) 
		MapTypes         KTLbitmask       int         
		MapUnits         mm               float       
		MapTypes         Unixtime         int         
		MapUnits         AngleAz          float       
		MapUnits         AngleDec         float       
		MapUnits         AngleHA          float       
		MapTypes         KTLenumerated    tinyint     
		MapTypes         KTLboolean       tinyint     
		MapTypes         KTLenumbitmask   int         
		Template         HomeParA         bundle      
		MapUnits         AngleRA          float       


Rule033 ============================================================= Rule033


No maps should ever own mbundle records. 

Exceptions:	MapFuncs         DemoMap          map         
		MapFuncs         Linear           map         
		Template         HomeParA         bundle      


Rule034 ============================================================= Rule034


No maps should ever be bundle elements. 

Exceptions:	KECK1CCD         DWRN2LVM         varchar(68) 
		KECK1CCD         PWRBLOKM         varchar(68) 
		KECK1CCD         RESN2LVM         varchar(68) 
		KECK1CCD         TEMPDETM         varchar(68) 
		KECK1CCD         TEMPSETM         varchar(68) 
		KECK1CCD         UTBM15VM         varchar(68) 
		KECK1CCD         UTBP15VM         varchar(68) 
		KECK1CCD         UTBP30VM         varchar(68) 
		KECK1CCD         UTBP5VM          varchar(68) 
		KECK1CCD         UTBTEMPM         varchar(68) 
		KECK1CCD         UTBTMPSM         varchar(68) 
		MapTypes         Unixtime         int         
		Template         HomeParA         bundle      


Rule035 ============================================================= Rule035


No map should ever have an ISA. 

Exceptions:	KECK1CCD         DWRN2LVM         varchar(68) 
		KECK1CCD         PWRBLOKM         varchar(68) 
		KECK1CCD         RESN2LVM         varchar(68) 
		KECK1CCD         TEMPDETM         varchar(68) 
		KECK1CCD         TEMPSETM         varchar(68) 
		KECK1CCD         UTBM15VM         varchar(68) 
		KECK1CCD         UTBP15VM         varchar(68) 
		KECK1CCD         UTBP30VM         varchar(68) 
		KECK1CCD         UTBP5VM          varchar(68) 
		KECK1CCD         UTBTEMPM         varchar(68) 
		KECK1CCD         UTBTMPSM         varchar(68) 


Rule037 ============================================================= Rule037


No param should have an ISA. 

Exceptions:	MapParams        SCALE.demo       float       


Rule040 ============================================================= Rule040


Syty is a restricted value field. It can only contain those 
values found in the legit values map for syty, q.v. 

Exceptions:	Sybase_Type
		app
		bundle
		dummy
		numeric
		{}


Rule042 ============================================================= Rule042


If you have an mmap with non-null par_mids then the par_vals 
have to be non_null also. 

Exceptions:	DataBase         einkey           char(2)     
		IRCAL            APWHLORD         int         
		IRCAL            FLTR1ORD         int         
		IRCAL            FLTR2ORD         int         
		deimos3          G1TLTORD         int         
		SharedMemeMap    RADESYS          char(8)     


Rule045 ============================================================= Rule045


Certain syty imply that you must have bundle elements. If you 
don't, you're in error. 

Exceptions:	There are 51 exceptions to this rule (IDs below).  
		You have a serious problem.
		1351 1373 1400 1718 1759 1764 1769 2214 2215 2216 2218 2220 
		2222 2223 2224 2226 2228 2232 2541 3310 3317 3352 3685 3686 
		4220 4221 4818 4886 4905 4993 4994 4995 4996 4997 4998 5041 
		5053 5054 5055 5056 5060 5061 5079 5152 5165 5166 5167 5203 
		5427 5428 5435 


Rule046 ============================================================= Rule046


A bundle of one item is nonsense. 

Exceptions:	MapTuples        ISOdate          tuple       
		Template         AnaInpDev        bundle      
		template         term.serv        bundle      
		template         dispatch         bundle      
		esi              LAMParray        bundle      
		KTL              lris             bundle      
		template         lantr.ets        bundle      
		template         lantr.port       bundle      
		esi              POW28S0          bundle      
		esi              POW28S1          bundle      
		esi              IonPumpdev       bundle      
		template         lan.ets          bundle      
		template         lan.ets.port     bundle      
		template         esi.coll         bundle      
		pfcam            IOports          bundle      
		KTL              gdt              bundle      
		esi              AIRPW            bundle      
		esi              IONCUR           bundle      


Rule049 ============================================================= Rule049


Numeric kw should have real limits. 

Exceptions:	There are 347 exceptions to this rule (IDs below).  
		You have a serious problem.
		12 35 37 38 39 40 45 46 47 48 49 50 51 52 53 67 69 70 71 72 
		100 102 103 104 105 124 126 127 128 148 150 151 152 161 163 
		164 165 172 173 180 181 185 200 202 203 204 219 221 222 223 
		224 240 241 242 258 271 284 286 287 288 289 300 301 306 307 
		308 309 310 311 312 313 325 327 328 329 339 341 342 343 353 
		355 356 357 366 368 369 370 408 409 425 427 428 429 473 474 
		487 514 517 518 519 527 529 531 533 534 535 537 540 548 549 
		553 554 555 556 562 563 567 568 571 572 575 576 578 579 580 
		581 584 585 586 587 588 589 590 591 592 593 594 595 596 597 
		598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 
		613 635 641 642 645 646 647 648 649 650 651 652 653 654 655 
		656 658 668 669 670 671 672 678 680 681 685 686 687 688 690 
		691 692 694 695 705 706 707 708 709 719 722 723 724 725 726 
		727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 
		742 743 746 809 811 818 819 820 821 823 1066 1120 1126 1127 
		1151 1167 1171 1172 1173 1174 1189 1192 1194 1195 1196 1197 
		1198 1199 1207 1213 1215 1220 1240 1279 1281 1294 1300 1381 
		1382 1383 1384 1385 1386 1387 1389 1390 1391 1392 1438 1439 
		1440 1450 1615 1761 1851 1860 1863 2246 2749 2750 2796 2810 
		2811 2819 2833 2834 2842 2856 2857 2865 2879 2880 2888 2902 
		2903 2911 2925 2926 2934 2948 2949 2957 2971 2972 2980 2994 
		2995 3003 3017 3018 3026 3040 3041 3078 3092 3093 3142 3143 
		3156 3165 3166 3179 3189 3212 3234 3235 3248 3249 3258 3301 
		3325 3331 3478 3501 3524 3550 3574 4581 4592 4791 4868 4870 
		4892 4915 5147 5208 5239 5247 5255 5287 5295 5317 


Rule050 ============================================================= Rule050


The memes which appear as tmids in Mbundles should be among 
those which are allowed to have bundles. 

Exceptions:	Applications     mbc              app         
		Applications     mbb              app         
		Applications     mbn              app         
		esi              TMPPRSMC         real        


Rule051 ============================================================= Rule051


The memes which appear as tmids in Mbundles should include all 
of those which are required to have bundles. 

Exceptions:	There are 51 exceptions to this rule (IDs below).  
		You have a serious problem.
		1351 1373 1400 1718 1759 1764 1769 2214 2215 2216 2218 2220 
		2222 2223 2224 2226 2228 2232 2541 3310 3317 3352 3685 3686 
		4220 4221 4818 4886 4905 4993 4994 4995 4996 4997 4998 5041 
		5053 5054 5055 5056 5060 5061 5079 5152 5165 5166 5167 5203 
		5427 5428 5435 


Rule052 ============================================================= Rule052


A tuple meme with no rpt_mid must have a bundle. 

Exceptions:	DEMO             KWHAT            tuple       
		DEMO             KWARRINtpl       tuple       


Rule054 ============================================================= Rule054


No map_mid can be a tuple element. 

Exceptions:	KECK1CCD         DWRN2LVM         varchar(68) 
		KECK1CCD         PWRBLOKM         varchar(68) 
		KECK1CCD         RESN2LVM         varchar(68) 
		KECK1CCD         TEMPDETM         varchar(68) 
		KECK1CCD         TEMPSETM         varchar(68) 
		KECK1CCD         UTBM15VM         varchar(68) 
		KECK1CCD         UTBP15VM         varchar(68) 
		KECK1CCD         UTBP30VM         varchar(68) 
		KECK1CCD         UTBP5VM          varchar(68) 
		KECK1CCD         UTBTEMPM         varchar(68) 
		KECK1CCD         UTBTMPSM         varchar(68) 
		MapTypes         Unixtime         int         
		Template         HomeParA         bundle      


Rule055 ============================================================= Rule055


No duplicate eordr values should appear within a bundle. 

Exceptions:	1672 23
		2429 63
		3703 1
		3703 2
		3703 3
		3703 81
		3703 82
		3703 91
		3703 92
		4526 9
		4575 3
		4575 4
		4575 5
		4576 106
		4834 0
		4834 1
		4834 2
		4834 3
		4834 4
		4834 5
		4834 6
		4834 29
		4834 100
		4834 101
		4834 102
		4834 103
		4834 202
		4834 204
		5205 1
		5205 2
		5205 3
		5205 4
		5205 5
		5205 6

Questions about this report? talk to de@ucolick.org