Understanding Fields in Schedules

Name of the activity

Used in almost all reports

Filter down (Attendance) only to create attendance reports

Estimated minutes the activity estimated will take

The sequence number of the activity in the room

Type of activity (comes from Dictionary)

Group or filter by activity type for more specific reports, e.g. QC Check reports can filter on Activity Type = QC Check

The assignment priority of the assigned staff for any activities in a room

Cage Type of the rack (only applies to activities tied to a rack

Staff capacity minutes will be tracked as positive while Activity minutes will be tracked as negative

Use this as the Value for reports that calculate staff allocation or staff needs

Staff capacity minutes for attendance records, e.g. 480

Day in month with format: Day number/Day of week name

Duration Per option, e.g. the “cage” in 20 seconds per cage

Show this in a Flat form layout report to see all activity duration calculations in one place to find outliers or data entry mistakes

Duration Unit, e.g. the “seconds” in 20 seconds per cage

Show this in a Flat form layout report to see all activity duration calculations in one place to find outliers or data entry mistakes

Duration used in activity minutes calculation (this is the duration for 1 unit, not the total, e.g. the “20” in 20 seconds per cage)

Show this in a Flat form layout report to see all activity duration calculations in one place to find outliers or data entry mistakes

Whether the activity uses Metrics or Activity Default

Show this in a Flat form layout report to see all activity duration calculations in one place to find outliers or data entry mistakes

Equipment linked to an Equipment Type activity, e.g. Hood

Facility/Area the activity is in

The quantity per set for Preparation Type activities, e.g. the “18” in 2 minutes per 18 cages

Show this in a Flat form layout report to see all activity duration calculations in one place to find outliers or data entry mistakes

The percentage value for Cage Type activities with quantities calculated as a percentage of the total in the room, e.g. Spot Change Cages

Total quantity for the activity, e.g. 150 (cages)

Use this as the Value for reports that calculate total quantity of cage changes over periods of time

Rack ID for activities listed under racks

Rack Item name for activities that rely on rack item counts

Use this field as a Row or Column on reports where you can too look at totals by rack item, e.g. total bottle changes by the day

Cage Type of the rack (only applies to activities tied to a rack

Recurrence Pattern for the activity, e.g. Daily, Weekly, Monthly

Filter on recurrence pattern not equal to Daily to produce reports on non-daily activities

Entire Recurrence Summary for the activity

Show this only on Flat form layout reports as it is not useful for pivots

Room Status for the room

Room Type for the room

Shift End Time on an attendance record

Use this in attendance reports

Shift Start Time on an attendance record

Use this in attendance reports

Icon for the activity

Show this in Flat form layout reports for added visuals

Name of the assigned staff

How many times per day the activity is done (affects activity minutes)

Show this in a Flat form layout report to see all activity duration calculations in one place to find outliers or data entry mistakes

Unit the activity is in

Week in month (Week 1 - 4)