Datenverzeichnis

ID
Course_ID
Typ
int4
Beschreibung

Unique identifier of a course. Course is an individual program instance offered by PF&R.

ID
Location ID
Typ
int4
Beschreibung

Unique identifier of the location where the facility is located. Refer to Locations spreadsheet

ID
Activity Title
Typ
text
Beschreibung

Title of activity. Activity is hierarchical level that categorizes a recreation program. Activity = Program. Multiple courses run for an activity (for a recreational program).

ID
Course Title
Typ
text
Beschreibung

Title of a course. Course is an individual program instance offered by PF&R.

ID
Days of The Week
Typ
text
Beschreibung

Days of weeks the course is offered on

ID
From To
Typ
text
Beschreibung

Date boundaries when the course is offered

ID
Start Hour
Typ
int4
Beschreibung

Start hour (24 hours range)

ID
Start Min
Typ
int4
Beschreibung

Start min

ID
End Hour
Typ
int4
Beschreibung

End hour (24 hours range)

ID
End Min
Typ
int4
Beschreibung

End min

ID
Activity URL
Typ
text
Beschreibung

URL to the course's program details and registration

ID
Min Age
Typ
text
Beschreibung

Minimum age required to register for the course - age in months

ID
Max Age
Typ
text
Beschreibung

Maximum age limit to register for the course - age in months

ID
Program Category
Typ
text
Beschreibung

Category of recreational program - top-level hierarchical level of programs classification. F.ex., 'General Interest Arts - Adult' and 'Hip Hop - Child' are activities/programs of

ID
Registration Date
Typ
text
Beschreibung

Start of registration.

ID
Status / Information
Typ
text
Beschreibung

Information regarding current status of the course. There are three scenarios which is based on start date and registration deadline date of program: 1. If Start Date is less than present date: This course has started 2. If Registration Date is less than present date: This course is open for registration 3. If Registration Date is greater than present date: This course is not presently available for Internet Registration.

Zusätzliche Informationen

Feld Wert
Daten wurden zuletzt aktualisiert 2. Juli 2025
Metadaten zuletzt aktualisiert 14. Mai 2026
Erstellt 2. Juli 2025
Format XLSX
Lizenz Keine Lizenz angegeben
Datastore activeTrue
Datastore cache{'CSV': 'eef9f05c-8488-429b-862c-0f2e2e0d92a4', 'XML': '929fa26a-e3ac-49fb-a1a1-f287875a1f31', 'JSON': 'b1007b0f-0fe6-43e4-a533-62accfe9a893'}
Datastore cache last updatevor 6 Tagen
Extract jobAirflow: Integration Pipeline registered-programs-and-drop-in-courses-offering
Has viewsTrue
Id3bdfdad5-b1d0-4b1b-b56d-c61c317da306
Is previewTrue
Mimetypeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Package id1a5be46a-4039-48cd-a2d2-8e702abf9516
Position3
Record count29.458
Stateactive
Url typedatastore
Extract Job Airflow: Integration Pipeline registered-programs-and-drop-in-courses-offering
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. XML
  3. JSON
Datastore Cache Last Updated
Datastore resource's ID