Monthly Availability Fields

Monthly Availability records store data when changes are made to resource availability in PSA, before these changes are successfully pushed to Analytics.

The Monthly Availability object includes the following fields.

Monthly Availability Object Fields
Field Description
Availability Dataset A lookup to the dataset associated with monthly availability.
Day 1 Hours (plus equivalent fields for Days 2-31) Indicates the number of available hours for the resource on the first day of the month. The same rules apply to equivalent days of the month for all fields up to and including Day 31 Hours.
List of Hours A list of daily hours corresponding to the monthly availability record. This offers an insight into whether there are any differences between the monthly availability record and the Analytics dataset.
Month Number The month number of the year corresponding to the monthly availability record.
Potential Duplicate

Indicates a monthly availability record that is a potential duplicate of an existing record that is due to be deleted after the push to Analytics.

If the push to Analytics is unsuccessful, the potential duplicate record is merged with other records that hold the same resource, month number, and year and that were created while the initial record was in the process of being pushed to Analytics.

Record Key A system-generated identifier of the monthly availability record.
Resource The resource associated with the monthly availability record.
Year The year of the monthly availability record.