Data Dictionary

ID
Course_ID
Type
int4
Description

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

ID
Location ID
Type
int4
Description

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

ID
Activity Title
Type
text
Description

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
Type
text
Description

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

ID
Days of The Week
Type
text
Description

Days of weeks the course is offered on

ID
From To
Type
text
Description

Date boundaries when the course is offered

ID
Start Hour
Type
int4
Description

Start hour (24 hours range)

ID
Start Min
Type
int4
Description

Start min

ID
End Hour
Type
int4
Description

End hour (24 hours range)

ID
End Min
Type
int4
Description

End min

ID
Activity URL
Type
text
Description

URL to the course's program details and registration

ID
Min Age
Type
text
Description

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

ID
Max Age
Type
text
Description

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

ID
Program Category
Type
text
Description

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
Type
text
Description

Start of registration.

ID
Status / Information
Type
text
Description

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 Hulyo 2, 2025
Metadata last updated Abril 2, 2026
Created Hulyo 2, 2025
Format XLSX
License No License Provided
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 update5 araw ang nakalipas
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 count19,097
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