Data Elements Mapping

LAST, First

Resource’s name

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.

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)

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

Format 123-456-7890

Format 123-456-7890

Valid government email address

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

YYYY-MM-DD

check, blank

YYYY represents the current year

check, blank

YYYY represents previous year

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

N, X, C, O, I

N, X, C, O, I

N, X, C, O, I

N, X, C, O, I

N, X, C, O, I

N, X, C, O, I

N, X, C, O, I

N, X, C, O, I

N, X, C, O, I

check, blank

check, blank

check, blank, red fill

check = training completed
blank = ?
red fill = ?

check, blank, red fill

check, blank, red fill

check, blank, red fill

check, blank, red fill

check, blank, red fill

check, blank, red fill

check, blank, red fill

check, blank, red fill

text field

First Last

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.

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