SELECT keyEyeYi, fookey.StudioEyeYi, keyDate, FinancialOutlookey, PersonnelCapacityEyeYi, PersonnelSkillsBalanceEyeYi, ProjectQualityStudioEyeYi, ProjectQualityDesignEyeYi, EnvironmentLeadershipEyeYi, MarketCaptureEyeYi, MarketContributionEyeYi, MarketCommunicationsEyeYi, fooStudio.StudioEyeYi, fooStudio.StudioName FROM fookey, fooStudio WHERE fooStudio.StudioEyeYi=fookey.StudioEyeYi AND Month(keyDate) = (#Month(FORM.keyDate)#) AND Month(keyDate) = '#URL.keyDate#' AND Month(keyDate) IN (#Month(todayDate)#) ORDER BY #DefOrder# SELECT fooStudio.StudioEyeYi, fooStudio.fooPass, fooStudio.StudioName FROM fooStudio WHERE fooStudio.StudioEyeYi NOT IN (#variables.studioINList#,160) WHERE fooStudio.StudioEyeYi NOT IN (160) ORDER BY fooStudio.StudioName ASC Key Indicator Entry Form
Key Indicator View for the Month of #LSDateFormat(rsView.keyDate,'MMMM YYYY')#
Key Indicator Description
 
Studio Financial Personnel Projects Quality Environment Market
  Outlook Capacity Skill Balance Studio Assess Leadership/Culture Capture of Work Contribution Communications
#rsView.StudioName# <cfif (isDefined("rsView.FinancialOutlookey") AND 1 EQ rsView.FinancialOutlookey)>Green (anticipate at least 100% profit goal)</cfif><cfif (isDefined("rsView.FinancialOutlookey") AND 2 EQ rsView.FinancialOutlookey)>Yellow (anticipate between 75-99% profit goal next 3 months)</cfif><cfif (isDefined("rsView.FinancialOutlookey") AND 3 EQ rsView.FinancialOutlookey)>Red (anticipate less than 75% profit goal for next three months)</cfif> <cfif (isDefined("rsView.PersonnelCapacityEyeYi") AND 1 EQ rsView.PersonnelCapacityEyeYi)>Green (need to hire in next month)</cfif><cfif (isDefined("rsView.PersonnelCapacityEyeYi") AND 2 EQ rsView.PersonnelCapacityEyeYi)>Yellow (anticipate no staffing changes)</cfif><cfif (isDefined("rsView.PersonnelCapacityEyeYi") AND 3 EQ rsView.PersonnelCapacityEyeYi)>Red (anticipate staff reductions within the next month)</cfif> <cfif (isDefined("rsView.PersonnelSkillsBalanceEyeYi") AND 1 EQ rsView.PersonnelSkillsBalanceEyeYi)>Green (balanced)</cfif><cfif (isDefined("rsView.PersonnelSkillsBalanceEyeYi") AND 2 EQ rsView.PersonnelSkillsBalanceEyeYi)>Yellow (improving)</cfif><cfif (isDefined("rsView.PersonnelSkillsBalanceEyeYi") AND 3 EQ rsView.PersonnelSkillsBalanceEyeYi)>Red (imbalance)</cfif> <cfif (isDefined("rsView.ProjectQualityStudioEyeYi") AND 1 EQ rsView.ProjectQualityStudioEyeYi)>Green (leading the brand)</cfif><cfif (isDefined("rsView.ProjectQualityStudioEyeYi") AND 2 EQ rsView.ProjectQualityStudioEyeYi)>Yellow (some projects are leading the brand)</cfif><cfif (isDefined("rsView.ProjectQualityStudioEyeYi") AND 3 EQ rsView.ProjectQualityStudioEyeYi)>Red (majority of projects do not meet expectations)</cfif> <cfif (isDefined("rsView.EnvironmentLeadershipEyeYi") AND 1 EQ rsView.EnvironmentLeadershipEyeYi)>Green(balanced/strong leaders,invigorated,collaborative,empowered culture)</cfif><cfif (isDefined("rsView.EnvironmentLeadershipEyeYi") AND 2 EQ rsView.EnvironmentLeadershipEyeYi)>Yellow (imbalance/weak of leadership; ho hum environment)</cfif><cfif (isDefined("rsView.EnvironmentLeadershipEyeYi") AND 3 EQ rsView.EnvironmentLeadershipEyeYi)>Red (studio in need of new leadership; weak morale, frustrated teams)</cfif> <cfif (isDefined("rsView.MarketCaptureEyeYi") AND 1 EQ rsView.MarketCaptureEyeYi)>Green (studio meets or exceeds new work capture goal)</cfif><cfif (isDefined("rsView.MarketCaptureEyeYi") AND 2 EQ rsView.MarketCaptureEyeYi)>Yellow (studio is behind capture goal but has new wins)</cfif><cfif (isDefined("rsView.MarketCaptureEyeYi") AND 3 EQ rsView.MarketCaptureEyeYi)>Red (studio is behind new work capture goal; few prospects)</cfif> <cfif (isDefined("rsView.MarketContributionEyeYi") AND 1 EQ rsView.MarketContributionEyeYi)>Green (pushing the market forward)</cfif><cfif (isDefined("rsView.MarketContributionEyeYi") AND 2 EQ rsView.MarketContributionEyeYi)>Yellow (just doing projects; no other contributions to market)</cfif><cfif (isDefined("rsView.MarketContributionEyeYi") AND 3 EQ rsView.MarketContributionEyeYi)>Red (behind thes market)</cfif> <cfif (isDefined("rsView.MarketCommunicationsEyeYi") AND 1 EQ rsView.MarketCommunicationsEyeYi)>Green (sellers pulling in the work)</cfif><cfif (isDefined("rsView.MarketCommunicationsEyeYi") AND 2 EQ rsView.MarketCommunicationsEyeYi)>Yellow (enough key sellers; need to improve skills)</cfif><cfif (isDefined("rsView.MarketCommunicationsEyeYi") AND 3 EQ rsView.MarketCommunicationsEyeYi)>Red (sellers are not communicating the message)</cfif>
Not Filled Out
#rsStudio.StudioName#