| | | |
|---|
Foster | animalos__Foster__c
| Picklist | Values: |
Foster Animal Count Last 5 Years | animalos__Foster_Animal_Count_Last_5_Years__c
| Number(18, 0) | Rollup COUNT from Foster Location > Movements WHERE Movement Start Date is LAST 5 Years |
Foster Animal Count Last Month | animalos__Foster_Animal_Count_Last_Month__c
| Number(18, 0) | Rollup COUNT from Foster Location > Movements WHERE Movement Start Date is LAST MONTH |
Foster Animal Count Last Year | animalos__Foster_Animal_Count_Last_Year__c
| Number(18, 0) | Rollup COUNT from Foster Location > Movements WHERE Movement Start Date is LAST YEAR |
Foster Animal Count This Month | animalos__Foster_Animal_Count_This_Month__c
| Number(18, 0) | Rollup COUNT from Foster Location > Movements WHERE Movement Start Date is THIS MONTH |
Foster Animal Count This Year | animalos__Foster_Animal_Count_This_Year__c
| Number(18, 0) | Rollup COUNT from Foster Location > Movements WHERE Movement Start Date is THIS YEAR |
Foster Animal Count Total | animalos__Foster_Animal_Count_Total__c
| Number(18, 0) | Rollup COUNT from Foster Location > Movements |
Foster Animal Special Needs Count | animalos__Foster_Animal_Special_Needs_Count__c
| Number(18, 0) | Rollup COUNT from Foster Location > Movements WHERE Animal Special Needs = TRUE |
Foster Days Last 5 Years | animalos__Foster_Days_Last_5_Years__c
| Number(18, 0) | Rollup SUM Days from Foster Location > Movements WHERE Movement Start Date is LAST 5 YEARS |
Foster Days Last Month | animalos__Foster_Days_Last_Month__c
| Number(18, 0) | Rollup SUM Days from Foster Location > Movements WHERE Movement Start Date is LAST MONTH |
Foster Days Last Year | animalos__Foster_Days_Last_Year__c
| Number(18, 0) | Rollup SUM Days from Foster Location > Movements WHERE Movement Start Date is LAST YEAR |
Foster Days Special Needs | animalos__Foster_Days_Special_Needs__c
| Number(18, 0) | Rollup SUM Days from Foster Location > Movements WHERE Animal Special Needs = TRUE |
Foster Days This Month | animalos__Foster_Days_This_Month__c
| Number(18, 0) | Rollup SUM Days from Foster Location > Movements WHERE Movement Start Date is THIS MONTH |
Foster Days This Year | animalos__Foster_Days_This_Year__c
| Number(18, 0) | Rollup SUM Days from Foster Location > Movements WHERE Movement Start Date is THIS YEAR |
Foster Days Total | animalos__Foster_Days_Total__c
| Number(18, 0) | Rollup SUM Days from Foster Location > Movements |
Foster Instances | animalos__Foster_Instances__c
| Number(18, 0) | Rollup COUNT from Foster Location > Movements WHERE Start Date is unique |
Foster Notes | animalos__Foster_Notes__c
| Long Text Area(32768) | |
Foster Preferences | animalos__Foster_Preferences__c
| Picklist (Multi-Select) | Values: Birds (aviary) Dogs - Large (over 20kg) - Behaviour Dogs - Large (over 20kg) - General Dogs - Large (over 20kg) - Medical Dogs - Medium (10kg - 20kg) - Behaviour Dogs - Medium (10kg - 20kg) - General Dogs - Medium (10kg - 20kg) - Medical Dogs - Mother with Puppies Dogs - Puppies - Behaviour Dogs - Puppies - Medical Dogs - Puppies - Neonatal/Bottle Feeding Dogs - Puppies - Youth/General Dogs - Small Dogs (under 10kg) - Behaviour Dogs - Small Dogs (under 10kg) - General Dogs - Small Dogs (under 10kg) - Medical Feline - Adult Cat - Behaviour Feline - Adult Cat - General Feline - Adult Cat - Medical (Flu/Calici) Feline - Adult Cat - Medical (Other) Feline - Kittens - Behaviour Feline - Kittens - Medical (Flu/Calici) Feline - Kittens - Medical (Other) Feline - Kittens - Neonatal/Bottle Feeding Feline - Kittens - Youth/General Feline - Mums with Kittens Fish Fowls Guinea Pigs Horses Livestock (goats, sheep, etc) Livestock - Neonatal/Bottle Feeding Rabbits Reptiles Rodent Community Programs Ferrets
|
Fostering Details | animalos__Fostering_Details__c
| Picklist (Multi-Select) | Values: New Foster Experienced Foster One Off Foster
|
Specialist Foster Areas | animalos__Specialist_Foster_Areas__c
| Picklist (Multi-Select) | Values: Canine Emergency Neonate Feline Behavioural Feline Flu Feline Ringworm Inspectorate Neonate Programs Foster Puppy Farm
|
Unable to Foster From | animalos__Unable_to_Foster_From__c
| Date | |
Unable to Foster To | animalos__Unable_to_Foster_To__c
| Date | |
Adopter Tags | animalos__Adopter_Tags__c
| Picklist (Multi-Select) | Values: Cannot be left for long periods Dietary Experienced Owner Medical No Animals of different species No Animals of same species No Children Rural Area Secure Garden Specialist Equipment
|
Adoption Count | animalos__Adoption_Count__c
| Number(18, 0) | Rollup COUNT Adoption Referrals WHERE Stage = Adopted |
Adoptions Last 10 Years | animalos__Adoptions_Last_10_Years__c
| Number(18, 0) | Rollup COUNT Adoption Referrals WHERE Stage = Adopted AND Scheduled Date/Time LAST 10 Years |
Adoptions Last 5 Years | animalos__Adoptions_Last_5_Years__c
| Number(18, 0) | Rollup COUNT Adoption Referrals WHERE Stage = Adopted AND Scheduled Date/Time LAST 5 Years |
Adoptions This Year | animalos__Adoptions_This_Year__c
| Number(18, 0) | Rollup COUNT Adoption Referrals WHERE Stage = Adopted AND Scheduled Date/Time THIS YEAR |
Do Not Adopt Reason | animalos__Do_Not_Adopt_Reason__c
| Picklist (Multi-Select) | Values: |
Do Not Allow Adoptions | animalos__Do_Not_Allow_Adoptions__c
| Checkbox | |
First Adoption Date | animalos__First_Adoption_Date__c
| Date | Rollup FIRST Scheduled Date/Time on Adoption Referrals |
Last Adoption Date | animalos__Last_Adoption_Date__c
| Date | Rollup LAST Scheduled Date/Time on Adoption Referrals |