Lifetime recognition programs are now included in the View
Recognitionyear is set to 0 for lifetime programs
| Column | Comments |
|---|---|
| RECOGNITIONPROGRAMDIMID | |
| RECOGNITIONPROGRAM | |
| RECOGNITIONPROGRAMDESCRIPTION | |
| RECOGNITIONPROGRAMTYPE | |
| RECOGNITIONPROGRAMISACTIVE | |
| RECOGNITIONLEVEL | |
| RECOGNITIONLEVELDESCRIPTION | |
| RECOGNITIONLEVELTIER | |
| RECOGNITIONLEVELISACTIVE | |
| CONSTITUENTDIMID | |
| JOINDATE | |
| EXPIRATIONDATE | |
| STATUSCODE | |
| STATUS | |
| ISANONYMOUS | |
| TOTALAMOUNT | |
| TOTALPLANNEDGIFTAMOUNT | |
| RECOGNITIONYEAR | |
| RECENCYRANK | |
| MINIMUMRECOGNITIONAMOUNT | use to sort levels appropriately, this is the min amount for each recognition level |
| RECOGNTITIONPROGRAMSYSTEMID | use to link to other rec program tables instead of the rec program dim id |