Advertisements to the Public Service - Advertisements from the 2017-2018 fiscal year

Data Dictionary

1.

FISCAL_YEAR

text

2.

CAR_CHC_ID

numeric

3.

REFERENCE_NUMBER

text

4.

SELECTION_PROCESS_NUMBER

text

5.

CREATION_DATE

text

6.

OPEN_DATE

text

7.

CLOSE_DATE

text

8.

DAYS_TO_OPEN

text

9.

NUMBER_DAYS_OPEN

numeric

10.

INTERNAL_INDICATOR

numeric

11.

EXTERNAL_INDICATOR

numeric

12.

POSITION_TITLE_E

text

13.

POSITION_TITLE_F

text

14.

CLASSIFICATIONS

text

15.

CLASSIFICATION_COUNT

numeric

16.

PSC_ADMIN

numeric

17.

NATIONAL

numeric

18.

SCRNG_TOOL_OFFICIAL_LANGUAGE

numeric

19.

SCRNG_TOOL_SCREENING_QUESTIONS

numeric

20.

SCRNG_TOOL_TEXT_QUESTIONS

numeric

21.

SCRNG_TOOL_EXP_QUESTIONNAIRE

numeric

22.

SCRNG_TOOL_UIT

numeric

23.

SCRNG_TOOL_EDUCATION

numeric

24.

INDETERMINATE

numeric

25.

SPECIFIED_TERM

numeric

26.

ACTING

numeric

27.

ASSIGNMENT

numeric

28.

DEPLOYMENT

numeric

29.

SECONDMENT

numeric

30.

VARIOUS_WORK_LOCATION

numeric

31.

PROV_CNT

numeric

32.

CAF_SUBMITTED

numeric

33.

CAF_IN

numeric

34.

CAF_OUT

numeric

35.

NOC

numeric

36.

NAPA

numeric

37.

NAA

numeric

38.

EE_ORGANIZ_GENDER

numeric

39.

EE_ORGANIZ_VISMIN

numeric

40.

administrator_region_e

text

41.

administrator_region_f

text

42.

advertisement_type_e

text

43.

advertisement_type_f

text

44.

city_count

numeric

45.

city_name_e

text

46.

city_name_f

text

47.

organization_e

text

48.

organization_f

text

49.

organization_code

text

50.

advertisement_url_e

text

51.

advertisement_url_f

text

52.

recruitment_program_e

text

53.

recruitment_program_f

text

54.

province_name_e

text

55.

province_name_f

text

56.

psea_e

text

57.

psea_f

text

58.

source_system_e

text

59.

source_system_f

text

60.

status_e

text

61.

status_f

text

62.

ee_criterion_gender

numeric

63.

ee_criterion_indigenous

numeric

64.

ee_criterion_vismin

numeric

65.

ee_criterion_pwd

numeric

66.

ee_organiz_pwd

numeric

67.

ee_organiz_indigenous

numeric

68.

TOTAL_SUBMITTED_SUP

numeric

69.

TOTAL_IN_SUP

numeric

70.

TOTAL_OUT_SUP

numeric

71.

SCRNG_TOOL_OCC_CERT

numeric

72.

women_submitted_SUP

numeric

73.

vismin_submitted_SUP

numeric

74.

indigenous_submitted_SUP

numeric

75.

pwd_submitted_SUP

numeric

76.

french_submitted_SUP

numeric

77.

english_submitted_SUP

numeric

78.

citizen_submitted_SUP

numeric

79.

permanent_resident_submitted_SUP

numeric

80.

ee_submitted_SUP

numeric

Additional Information

Created	September 8, 2022
Format	CSV