Dicionário de Dados

ID
Course_ID
Tipo
int4
Descrição

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

ID
Location ID
Tipo
int4
Descrição

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

ID
Activity Title
Tipo
text
Descrição

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
Tipo
text
Descrição

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

ID
Days of The Week
Tipo
text
Descrição

Days of weeks the course is offered on

ID
From To
Tipo
text
Descrição

Date boundaries when the course is offered

ID
Start Hour
Tipo
int4
Descrição

Start hour (24 hours range)

ID
Start Min
Tipo
int4
Descrição

Start min

ID
End Hour
Tipo
int4
Descrição

End hour (24 hours range)

ID
End Min
Tipo
int4
Descrição

End min

ID
Activity URL
Tipo
text
Descrição

URL to the course's program details and registration

ID
Min Age
Tipo
text
Descrição

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

ID
Max Age
Tipo
text
Descrição

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

ID
Program Category
Tipo
text
Descrição

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
Tipo
text
Descrição

Start of registration.

ID
Status / Information
Tipo
text
Descrição

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.

Informações Adicionais

Campo Valor
Dados atualizados pela última vez 2 de julho de 2025
Metadados atualizados pela última vez 25 de junho de 2026
Criado 2 de julho de 2025
Formato XLSX
Licença Nenhuma Licença Fornecida
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 updatehá 5 dias
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 count14.906
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