From a 500-row sample across 6 columns.
| exam_title | exam_number | application_period_start | application_period_end_date | open_competitive_promotion |
|---|---|---|---|---|
| Special Officer | 300 | 2019-06-27T00:00:00.000 | 2019-07-31T00:00:00.000 | Open Competitive |
| Special Officer (NYC H+H) | 301 | 2019-06-27T00:00:00.000 | 2019-07-31T00:00:00.000 | Open Competitive |
| Traffic Enforcement Agent | 302 | 2019-06-27T00:00:00.000 | 2019-07-31T00:00:00.000 | Open Competitive |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
title_code | integer | The code representing specific civil service job titles. | 87% | 702107165160817 |
exam_title | text | Civil Service title of the exam being offered | 0% | Police OfficerMARINE ENGINEER (UNIFORM…Traffic Enforcement Agen… |
exam_number | integer | Four-digit number assigned to each exam offered by DCAS in each Fiscal Year. Exam numbers are recycled every 10 years. | 0% | 452040574523 |
application_period_start | datetime | The date on which candidates can begin to submit applications to take an exam. Applications are only accepted when an application period has begun. | 9% |
GET /api/datasets/4ptz-hmtc GET /api/datasets/4ptz-hmtc/quality GET /api/datasets/4ptz-hmtc/related GET /api/columns?dataset=4ptz-hmtc
| Associate Urban Park Ranger (Prom) | 500 | 2019-07-03T00:00:00.000 | 2019-07-23T00:00:00.000 | Promotion |
| Congregate Care Specialist | 100 | 2019-07-03T00:00:00.000 | 2019-07-23T00:00:00.000 | Open Competitive |
| Congregate Care Specialist (Prom) | 501 | 2019-07-03T00:00:00.000 | 2019-07-23T00:00:00.000 | Promotion |
| Elevator Mechanic | 102 | 2019-07-03T00:00:00.000 | 2019-07-23T00:00:00.000 | Open Competitive |
| Elevator Mechanic (Prom) | 503 | 2019-07-03T00:00:00.000 | 2019-07-23T00:00:00.000 | Promotion |
| Health Services Manager | 104 | 2019-07-03T00:00:00.000 | 2019-07-23T00:00:00.000 | Open Competitive |
| Machinist | 106 | 2019-07-03T00:00:00.000 | 2019-07-23T00:00:00.000 | Open Competitive |
2023-12-07T00:00:00.0002024-03-06T00:00:00.0002024-02-07T00:00:00.000 |
application_period_end_date | datetime | The date on which the application period for an exam will end. Applications for exams are not accepted after the Application Period End Date | 9% | 2023-09-26T00:00:00.0002024-03-26T00:00:00.0002024-02-27T00:00:00.000 |
open_competitive_promotion | categorical | Open Competitive exams are open to any person who meets the minimum qualifications listed in the Notice of Examination. Promotion exams are only open to current permanent and 55-a employees in an eligible title and who meet minimum qualification requirements listed in the Notice of Examination. Qualified Incumbent Exams are open only to employees serving in the exam title and meet the eligibility requirements for the exam listed in the Notice of Examination | 0% | Open CompetitivePromotionCanceledof 8 |
data_current_as_of | datetime | This date the data are current as of | 15% | 2024-06-30T00:00:00.0002024-03-06T00:00:00.0002023-09-30T00:00:00.000of 10 |