Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Data Field from Original Excel

Field Value

Comments

1

Name

LAST, First

Resource’s name

2

Region

CTL, HQ, NEA, NWE, SEA, SWE, VIC

Region which corresponds to the resource’s work location.
Example: Emma lives in Kamloops, CTL (her current location) but works remotely. The headquarters for her job is located in Victoria (work location). Emma has applied to be part of the TEAMS program and she is assigned to be part of VIC (Vancouver Island Coastal) region's roster because her work location is Victoria.

3

Work Location - total 61 values for all 7 regions

  1. CTL: 8 values

    • Enderby

    • Kamloops

    • Kelowna

    • Merritt

    • Penticton

    • Salmon Arm

    • Sorrento

    • Vernon

  2. HQ: 7 values

    • Brentwood Bay

    • Langford

    • Esquimalt

    • Saanich

    • Saanichton

    • Sidney

    • Victoria

  3. NEA: 9 values

    • 100 Mile House

    • 150 Mile House

    • Dawson Creek

    • Fort Nelson

    • Fort St. John

    • Mackenzie

    • Prince George

    • Quesnel

    • Williams Lake

  4. NWE: 3 values

    • Burns Lake

    • Smithers

    • Terrace

  5. SEA: 7 values

    • Bonnington Falls

    • Castlegar

    • Cranbrrok

    • Elkford

    • Kimberley

    • Nelson

    • Revelstoke

  6. SWE: 15 values

    • Abbotsford

    • Bonnington Falls

    • Burnaby

    • Coquitlam

    • Langley

    • Lillooet

    • Maple Ridge

    • Mission

    • New Westminster

    • North Vancouver

    • Richmond

    • Surrey

    • Vancouver

    • Vernon

    • Whistler

  7. VIC: 12 values

    • Campbell River

    • Courtenay

    • Cumberland

    • Duncan

    • Mill Bay

    • Nanaimo

    • Parksville

    • Port Alberni

    • Port McNeil

    • Qualicum Beach

    • Sechelt

    • Ucluelet

Contact information section includes: Work Location, Ministry, Primary Phone #, Secondary Phone #, Other Phone #, Email : In the future, it would be ideal if most of this information could be pulled directly from PeopleSoft/CHIPS (HR system used by the public service). This would help prevent errors and would allow for employee changes to occur automatically. This is a feature that already exists with WildfireOne.

Specific fields would be:

  1. Name

  2. Ministry

  3. Email

  4. Supervisor (for their home position)

4

Ministry

  1. Agriculture and Food (AGRI)

  2. Attorney General (AG)

  3. Children and Family Development (MCF)

  4. Citizens' Services (CITZ)

  5. Education and Child Care (ECC)

  6. Emergency Management and Climate Readiness (EMCR)

  7. Energy, Mines and Low Carbon Innovation (EMLI)

  8. Environment and Climate Change Strategy (ENV)

  9. Finance (FIN)

  10. Forests (FOR)

  11. Health (HLTH)

  12. Housing (HOUS)

  13. Indigenous Relations & Reconciliation (IRR)

  14. Jobs, Economic Development and Innovation (JEDI)

  15. Labour (LBR)

  16. Mental Health and Addictions (MMHA)

  17. Municipal Affairs (MUNI)

  18. Post-Secondary Education and Future Skills (PSFS)

  19. Public Safety and Solicitor General (PSSG)

  20. Social Development and Poverty Reduction (SDPR)

  21. Tourism, Arts, Culture and Sport (TAC)

  22. Transportation and Infrastructure (MOTI)

  23. Water, Land and Resource Stewardship (WLRS)

Ministry - It is valuable to know which ministry a member is from, but ministries sometimes go through name changes. Some of these acronyms are out of date or not in the correct format.
For MVP - we are only using acronyms

5

Primary Phone #

Format ? 123-456-7890

6

Secondary Phone #

Format ?123-456-7890

7

Email

Valid government email address

Email - The only email address that should be on here is the member's government email.

8

Application Date

YYYY-MM-DD

9

YYYY Annual Commitment

check, blank

YYYY represents the current year

10

Deployed YYYY

check, blank

YYYY represents previous year

11

Operations

N, X, C, O, I

N = Do not deploy to this position
X = Experienced
C = Chief Experience
O = Experienced outside of PECC/PREOC
I = Interested

12

Emergency Support Services (ESS)

N, X, C, O, I

13

First Nations

N, X, C, O, I

14

Finance

N, X, C, O, I

15

Liaison

N, X, C, O, I

16

Logistics

N, X, C, O, I

17

Plans

N, X, C, O, I

18

Advanced Planning Unit

N, X, C, O, I

19

Recovery

N, X, C, O, I

20

Deputy Director

N, X, C, O, I

21

BCWS TEAMS

check, blank

22

GIS

check, blank

23

ICS Manual Sent

check, blank, red fill

check = training completed
blank = ?
red fill = ?

24

ICS 100

check, blank, red fill

25

EOC Essentials/Intro to EOC

check, blank, red fill

26

The CORE

check, blank, red fill

27

Intro to EM

check, blank, red fill

28

WebEOC

check, blank, red fill

29

Self Discovery & Awareness Workshop

check, blank, red fill

30

UN Declaration/TRC Group Discussion (Part 1 &2)

check, blank, red fill

31

Kairos Blanket Exercise

check, blank, red fill

32

Skills and Abilities of Note

text field

33

Supervisor’s Name

First Last

34

Notes

text field

Currently, on the Excel sheet this field value includes the resource’s job title and classification.

It would be better if these were two separate fields:

  1. The member's regular job position.

  2. Whether they are part of BCGEU or Excluded.

How much a person earns should not be a contributing factor to deployment opportunities, but knowing if they are part of the union or excluded will help us take into consideration that they may not qualify to receive overtime compensation.

35

Availability Date

A, U, H, LC, P, D, R

A: Available    
U: Unavailable    
H: Home Region Only  
LV: On Leave     
P: Possibly    
D: Deployed    
RO: Remote Only

I would love to see this look a lot different. For instance, it would be nice to see:
Caitlyn Loveday - Available until XXX

or

Caitlyn Loveday - Unavailable until XXX

If someone is deployed, a field to enter a resource request number would be nice. It wouldn't have to be a mandatory field (at this time):
Caitlyn Loveday - Deployed until XXX

Request #: XX-XXXX

36