Content Comparison

Foster

animalos__Foster__c

Picklist

Values:

• Foster

• Do Not Foster

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

• This groups animals that are fostered together as a single instance.

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)

Adoption Date

animalos__Adoption_Date__c

DateRollup 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)

Declared No Adopter By

animalos__Declared_No_Adopter_By__c

Lookup(User)

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:

• POI subject of existing or ongoing investigation

• Prohibition Order

• Concerns for welfare of animals in their care

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

No Adopt

animalos__No_Adopt__c

CheckboxRollup LAST Scheduled Date/Time on Adoption Referrals