データディクショナリ

ID
Course_ID
タイプ
int4
説明

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

ID
Location ID
タイプ
int4
説明

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

ID
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).

ID
Course Title
タイプ
text
説明

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

ID
Days of The Week
タイプ
text
説明

Days of weeks the course is offered on

ID
From To
タイプ
text
説明

Date boundaries when the course is offered

ID
Start Hour
タイプ
int4
説明

Start hour (24 hours range)

ID
Start Min
タイプ
int4
説明

Start min

ID
End Hour
タイプ
int4
説明

End hour (24 hours range)

ID
End Min
タイプ
int4
説明

End min

ID
Activity URL
タイプ
text
説明

URL to the course's program details and registration

ID
Min Age
タイプ
text
説明

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

ID
Max Age
タイプ
text
説明

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

ID
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

ID
Registration Date
タイプ
text
説明

Start of registration.

ID
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.

追加情報

フィールド
最終更新日 2025年7月2日
メタデータ最終更新日時 2026年6月25日
作成日 2025年7月2日
データ形式 XLSX
ライセンス ライセンスが提示されていません
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 update6 日前
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