WD – Room Standards Automation

Room Standards

Western Digital is currently applying the room standards based on their room type using an automation. These standards are based on existing ‘zones’ used by space planning (figure 1).

Figure 1

Automation

SQL Task: RM_STD

Scheduled: Daily (5 days) 0:00

Automation:

Room Category: Room Type

Room Standard

SQL

MEETING:CONF LG

CL-CONF-LG

update rm set rm_std = ‘CL-CONF-LG’ where rm_cat = ‘MEETING’ and rm_type = ‘CONF LG’

MEETING:CONF MD

CL-CONF-MD

update rm set rm_std = ‘CL-CONF-MD’ where rm_cat = ‘MEETING’ and rm_type = ‘CONF MD’

MEETING:CONF SM

CL-CONF-SM

update rm set rm_std = ‘CL-CONF-SM’ where rm_cat = ‘MEETING’ and rm_type = ‘CONF SM’

FLEX:FOCUS RM

CL-FOCUS

update rm set rm_std = ‘CL-FOCUS’ where rm_cat = ‘FLEX’ and rm_type = ‘FOCUS RM’

SUPPORT:FOCUS

CL-FOCUS

update rm set rm_std = ‘CL-FOCUS’ where rm_cat = ‘SUPPORT’ and rm_type = ‘FOCUS’

MEETING:HUDDLE

CL-HUDDLE

update rm set rm_std = ‘CL-HUDDLE’ where rm_cat = ‘MEETING’ and rm_type = ‘HUDDLE’

MEETING:TRAINING

CL-TRAIN

update rm set rm_std = ‘CL-TRAIN’ where rm_cat = ‘MEETING’ and rm_type = ‘TRAINING’

SUPPORT:COFFEE/BRE

CM-BREAK

update rm set rm_std = ‘CM-BREAK’ where rm_cat = ‘SUPPORT’ and rm_type = ‘COFFEE/BRE’

SERV:ELEC

I-ELEC

update rm set rm_std = ‘I-ELEC’ where rm_cat = ‘SERV’ and rm_type = ‘ELEC’

SERV:IDF

I-MDF-IDF

update rm set rm_std = ‘I-MDF-IDF’ where rm_cat = ‘SERV’ and rm_type IN (‘IDF’, ‘MDF’)

SERV:MDF

I-MDF-IDF

update rm set rm_std = ‘I-MDF-IDF’ where rm_cat = ‘SERV’ and rm_type IN (‘IDF’, ‘MDF’)

SERV:MEN

I-RSTRM

update rm set rm_std = ‘I-RSTRM’ where rm_cat = ‘SERV’ and rm_type IN (‘MEN’, ‘WOMEN’, ‘RESTROOMS’)

SERV:RESTROOMS

I-RSTRM

update rm set rm_std = ‘I-RSTRM’ where rm_cat = ‘SERV’ and rm_type IN (‘MEN’, ‘WOMEN’, ‘RESTROOMS’)

SERV:WOMEN

I-RSTRM

update rm set rm_std = ‘I-RSTRM’ where rm_cat = ‘SERV’ and rm_type IN (‘MEN’, ‘WOMEN’, ‘RESTROOMS’)

SERV:SHOWER RM

I-SHOWER

update rm set rm_std = ‘I-SHOWER’ where rm_cat = ‘SERV’ and rm_type = ‘SHOWER RM’

LAB:BENCH

Q-BENCH

update rm set rm_std = ‘Q-BENCH’ where rm_cat = ‘LAB’ and rm_type = ‘BENCH’

PERS:LABICLE

Q-LABICLE

update rm set rm_std = ‘Q-WKSTN’ where rm_cat = ‘PERS’ and rm_type = ‘LABICLE’

PERS:OFFICE

Q-OFFICE

update rm set rm_std = ‘Q-WKSTN’ where rm_cat = ‘PERS’ and rm_type = ‘OFFICE’

FLEX:TOUCHDOWN

Q-TOUCHDWN

update rm set rm_std = ‘Q-TOUCHDWN’ where rm_cat = ‘FLEX’ and rm_type = ‘TOUCHDOWN’

PERS:CUBE

Q-WKSTN

update rm set rm_std = ‘Q-WKSTN’ where rm_cat = ‘PERS’ and rm_type IN (‘CUBE’, ‘WRKSTATION’)

PERS:WRKSTATION

Q-WKSTN

update rm set rm_std = ‘Q-WKSTN’ where rm_cat = ‘PERS’ and rm_type IN (‘CUBE’, ‘WRKSTATION’)

SUPPORT:COPY

S-COPY

update rm set rm_std = ‘S-COPY’ where rm_cat = ‘SUPPORT’ and rm_type = ‘COPY’

SERV:LOBBY

S-LOBBY

update rm set rm_std = ‘S-LOBBY’ where rm_cat = ‘SERV’ and rm_type = ‘LOBBY’

SUPPORT:MAIL

S-MAIL

update rm set rm_std = ‘S-MAIL’ where rm_cat = ‘SUPPORT’ and rm_type = ‘MAIL’

SUPPORT:WELLNESS

S-WELLNESS

update rm set rm_std = ‘S-WELLNESS’ where rm_cat = ‘SUPPORT’ and rm_type = ‘WELLNESS’

LAB:DRY

T-DRY

update rm set rm_std = ‘T-DRY’ where rm_cat = ‘LAB’ and rm_type = ‘DRY’

LAB:CHAMBER

T-SPECIAL

update rm set rm_std = ‘T-SPECIAL’ where rm_cat = ‘LAB’ and rm_type IN (‘CHAMBER’, ‘SERVER’, ‘XRAY’, ‘RESEARCH’, ‘CLEAN’)

LAB:SERVER

T-SPECIAL

update rm set rm_std = ‘T-SPECIAL’ where rm_cat = ‘LAB’ and rm_type IN (‘CHAMBER’, ‘SERVER’, ‘XRAY’, ‘RESEARCH’, ‘CLEAN’)

LAB:XRAY

T-SPECIAL

update rm set rm_std = ‘T-SPECIAL’ where rm_cat = ‘LAB’ and rm_type IN (‘CHAMBER’, ‘SERVER’, ‘XRAY’, ‘RESEARCH’, ‘CLEAN’)

LAB:WET

T-WET

update rm set rm_std = ‘T-WET’ where rm_cat = ‘LAB’ and rm_type = ‘WET’

FLEX:COLLAB

CL-OPEN

update rm set rm_std = ‘CL-OPEN’ where rm_cat = ‘FLEX’ and rm_type = ‘COLLAB’

SUPPORT and type isn’t VACATE, LEASED, or S.CIRC

S-OTHER

update rm set rm_std = ‘S-OTHER’ where rm_cat = ‘SUPPORT’ and rm_type NOT IN (‘VACATE’, ‘LEASED’, ‘S.CIRC’) and rm_std IS NULL

SERV and type isn’t VACATE, LEASED, or PRIMCIRC

I-OTHER

update rm set rm_std = ‘I-OTHER’ where rm_cat = ‘SERV’ and rm_type NOT IN (‘VACATE’, ‘LEASED’, ‘PRIMCIRC’) and rm_std IS NULL

MEETING

CL-OTHER

update rm set rm_std = ‘CL-OTHER’ where rm_cat = ‘MEETING’ and rm_std IS NULL

Was this helpful?

0 / 0

Leave a Reply 0

Your email address will not be published. Required fields are marked *