Data Dictionary

Column Type Label Description
Course_ID int4

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

Location ID int4

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

Activity Title text

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

Course Title text

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

Activity Description text

Description of the activity

Days of The Week text

Days of weeks the course is offered on

From To text

Date boundaries when the course is offered

Start Hour int4

Start hour (24 hours range)

Start Min int4

Start min

End Hour int4

End hour (24 hours range)

End Min int4

End min

Start Date date

Date when the course starts

eFun URL text

URL to the course's program details and registration on eFUN website - PF&R Interface for registration to recreation programs.

Min Age text

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

Max Age text

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

Program Category text

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

Registration Date text

Start of registration.

Status / Information text

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.

Additional Information

Field Value
Data last updated January 23, 2023
Metadata last updated November 7, 2024
Created January 23, 2023
Format CSV
License License not specified
Datastore activeTrue
Datastore cache{'CSV': 'b3be58bd-936c-4094-bea6-8bdc695d35f5', 'XML': '673a39df-e390-446b-b5b3-6c93d9fa1da2', 'JSON': '3fbc3353-8ef2-4754-bddf-9b7a36e6f7a3'}
Datastore cache last update6 months ago
Extract jobAirflow - files_to_datastore.py - registered-programs-and-drop-in-courses-offering
Has viewsTrue
Idadfe6aef-c5c6-4946-a5bd-6efeb5b2b7b4
Is previewTrue
Mimetypeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Package idda46e4ac-d4ab-4b1c-b139-6362a0a43b3c
Package name or idregistered-programs-and-drop-in-courses-offering
Position3
Stateactive
Url typedatastore
Extract Job Airflow - files_to_datastore.py - 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