gia - Business Logic Overview

User Interfaces

Forms

Add and Edit Metrics

Purpose: Metric List Data Source: SELECT [Metric ID], [Metric], [Metric Description], [Default Metric], [Sort Order] FROM Metrics;

Input Fields: - Tahoma - Tahoma - Tahoma - StrCriteria1

Actions: - Tahoma - ClearFilters - CloseForm

Add and Edit Purple Panel Extra Notification Users

Purpose: Add and Edit Purple Panel Extra Notification Users Data Source: Purple Panel Extra Notification Usernames

Input Fields: - Username → Username - RecNum → =GetXofY(Forms![Frm Add and Edit Purple Panel Extra Notification Users])

Actions: - MS Sans Serif - DeleteRec - CloseForm - NewRecord

Add and Edit Purple Panels

Purpose: Add and Edit Purple Panelists Data Source: Purple Panels

Input Fields: - Purple Panel ID → Purple Panel ID - Entrepreneur Company ID → Entrepreneur Company ID - Purple Panel Date → Purple Panel Date - Average Score → Average Score - CompanyText → =[Entrepreneur Company ID].Column - Rubric ID → Rubric ID - Purple Panel Time → Purple Panel Time - Purple Panel Status ID → Purple Panel Status ID - Total Score Percentage → =IIf([Possible Score]=0,0,[Average Score]/[Possible Score]) - Possible Score → Possible Score - ... and 2 more

Actions: - MS Sans Serif - CloseForm

Add and Edit Rubrics

Purpose: Metric List Data Source: Rubrics

Input Fields: - Tahoma - Tahoma - Tahoma - Rubric → Rubric - Rubric ID → Rubric ID

Actions: - Tahoma - CloseForm

Adjust Purple Panel Score

Purpose: Adjust Purple Panel Score Data Source: Unbound

Input Fields: - Current Average Score - Total Score Percentage → =IIf([Possible Score]=0,0,[Current Average Score]/[Possible Score]) - Possible Score - Revised Average Score - Revised Total Score Percentage → =IIf([Possible Score]=0,0,[Revised Average Score]/[Possible Score]) - Reason for Score Adjustment

Actions: - MS Sans Serif - DecreaseBy5 - IncreaseBy5 - CloseForm - SaveAndExit

Change Password

Purpose: Password Dialog Data Source: Unbound

Input Fields: - CurrentPassword - Username - NewPassword - ConfirmPassword

Actions: - MS Sans Serif - CancelButton - OKButton

Change Rubric

Purpose: Change Rubric Data Source: Unbound

Input Fields: - Current Rubric ID - New Rubric ID - Purple Panel ID

Actions: - MS Sans Serif - CloseForm - SaveAndExit

Company List

Purpose: Purple Panel Data Source: Unbound

Input Fields: - Calibri - Calibri - Calibri - CriteriaCombo1 - StrCriteria1 - CompanyList - Filter1 - PurplePanelistList - CompanyStatus - Purple Panel ID → =[Forms]![Frm Company List]![CompanyList].Column

Actions: - Calibri - ClearFilters - MaintenanceFunction - SchedulePurplePanel - EnterPurplePanelResults - SummarisePurplePanelResults - PrintReport - CloseForm

Display Confidentiality Statement

Purpose: Display Confidentiality Statement Data Source: Unbound

Actions: - MS Sans Serif - CloseForm

Edit Purple Panel Convener Summary

Purpose: Frm Edit Purple Panel Convener Summary Data Source: Purple Panels

Input Fields: - Calibri - Calibri - Rubric ID → Rubric ID - Purple Panel Status ID → Purple Panel Status ID - Average Score → Average Score - Total Score Percentage → =IIf([Possible Score]=0,0,Round(([Average Score]/[Possible Score])+0.000001,2)) - Panelist 1 Score Percentage → =IIf([Possible Score]=0,0,Round(([Panelist 1 Score]/[Possible Score])+0.000001,2 - Panelist 2 Score Percentage → =IIf([Possible Score]=0,0,Round(([Panelist 2 Score]/[Possible Score])+0.000001,2 - Panelist 3 Score Percentage → =IIf([Possible Score]=0,0,Round(([Panelist 3 Score]/[Possible Score])+0.000001,2 - Possible Score → Possible Score - ... and 17 more

Actions: - Calibri - AdjustScore - CloseForm - SubmitFinalPanel - CopyStrengthsDevAreas

Edit Purple Panelists Rubric Metric Scores

Purpose: Frm Edit Purple Panelists Rubric Metric Scores Data Source: Qry Edit Purple Panelists Main Form

Input Fields: - Calibri - Calibri - Calibri - Purple Panelist → Purple Panelist - Purple Panelist Total Score → Purple Panelist Total Score - Purple Panelist ID → Purple Panelist ID - Submitted → Submitted - Possible Total Score → Possible Total Score - PercentageScore → =IIf([Possible Total Score]=0,0,Round(([Purple Panelist Total Score]/[Possible T - Purple Panel Status ID → Purple Panel Status ID - ... and 6 more

Actions: - Calibri - ChangeRubric - CloseForm - Submitpanel - DisplayConfidentialityStatement

Edit Rubric Metric Weight

Purpose: Metric List Data Source: Rubric Metric Templates

Input Fields: - Tahoma - Tahoma - Tahoma - Rubric → =[Metric ID].Column - Rubric Metric Template ID → Rubric Metric Template ID - Metric ID → Metric ID - Metric Weight → Metric Weight

Actions: - Tahoma - CloseForm

Edit Rubric Metrics Template

Purpose: Edit Job Code Telephone Interview Questions Data Source: Unbound

Input Fields: - Tahoma - Tahoma - Tahoma - Label76 → =\

Actions: - Tahoma - CloseForm

Purpose: Maintenance Menu Data Source: Unbound

Actions: - MS Sans Serif - CloseForm - Metrics - Rubrics - NotificationUser

Opening Dialog

Purpose: Password Dialog Data Source: Unbound

Input Fields: - Password - Username - CurrentUser - LEVEL - Role - Delivery Location ID - Distribution Model ID - UserDeliveryLocation

Actions: - MS Sans Serif - CancelButton

Rubric List

Purpose: Job Code List Data Source: Unbound

Input Fields: - Tahoma - Tahoma - Tahoma - RubricList - MetricList

Actions: - Tahoma - AddRubric - EditMetrics - CloseForm

View Purple Panelists Rubric Metric Scores

Purpose: Frm View Rubric Metric Scores Data Source: Qry View Purple Panelists Rubric Metric Scores

Input Fields: - Calibri - Calibri - Calibri - Purple Panelist → Purple Panelist - Purple Panelist ID → Purple Panelist ID - Business Area → Business Area - Metric Description → Metric Description - Metric - RecNum → =GetXofY([Forms]![Frm View Purple Panelists Rubric Metric Scores])

Actions: - Calibri - CloseForm

SubFrm DatabaseUsers Module Permissions

Purpose: DatabaseUsers Module Permissions Data Source: DatabaseUsers Module Permissions

Input Fields: - Username → Username - Module Permission → Module Permission - Module Permission ID → Module Permission ID

Actions: - MS Sans Serif - DeleteRec

SubFrm Display Purple Panelist Score and Summary Panelist 1

Purpose: SubFrm Display Purple Panelist Score and Summary Panelist 1 Data Source: SELECT [Temp Purple Panelists Summary].[Panelist Number], [Temp Purple Panelists

Input Fields: - Calibri - Purple Panelist → Purple Panelist - Questions → Questions - Purple Panelist ID → Purple Panelist ID

Actions: - Calibri

SubFrm Display Purple Panelist Score and Summary Panelist 2

Purpose: SubFrm Display Purple Panelist Score and Summary Panelist 1 Data Source: SELECT [Temp Purple Panelists Summary].[Panelist Number], [Temp Purple Panelists

Input Fields: - Calibri - Purple Panelist → Purple Panelist - Questions → Questions - Purple Panelist ID → Purple Panelist ID

Actions: - Calibri

SubFrm Display Purple Panelist Score and Summary Panelist 3

Purpose: SubFrm Display Purple Panelist Score and Summary Panelist 1 Data Source: SELECT [Temp Purple Panelists Summary].[Panelist Number], [Temp Purple Panelists

Input Fields: - Calibri - Purple Panelist → Purple Panelist - Purple Panelist ID → Purple Panelist ID

Actions: - Calibri

SubFrm Metric Description

Purpose: SubFrm Metric Description Data Source: Metrics

Input Fields: - Calibri - Metric Description → Metric Description

SubFrm Metrics

Purpose: Metrics Data Source: SELECT Metrics.[Metric ID], Metrics.Metric, Metrics.[Metric Description], Metric

Input Fields: - Metric → Metric - Metric ID → Metric ID - Metric Description → Metric Description - Sort Order → Sort Order

Actions: - MS Sans Serif - DeleteRec

SubFrm Purple Panel Developmental Areas Summary

Purpose: Purple Panelists Data Source: Purple Panel Developmental Areas Summary

Input Fields: - Purple Panelist ID → Purple Panelist ID - Purple Panel Developmental Areas ID → Purple Panel Developmental Areas ID - Purple Panel Developmental Areas → Purple Panel Developmental Areas

Actions: - MS Sans Serif - DeleteRec

SubFrm Purple Panel Strengths Summary

Purpose: Purple Panelists Data Source: Purple Panel Strengths Summary

Input Fields: - Purple Panelist ID → Purple Panelist ID - Purple Panelist Strengths ID → Purple Panel Strengths ID - Purple Panel Strengths → Purple Panel Strengths

Actions: - MS Sans Serif - DeleteRec

SubFrm Purple Panelist Developmental Areas

Purpose: Purple Panelists Data Source: Purple Panelist Developmental Areas

Input Fields: - Purple Panelist ID → Purple Panelist ID - Purple Panelist Developmental Areas ID → Purple Panelist Developmental Areas ID - Purple Panelist Developmental Areas → Purple Panelist Developmental Areas

Actions: - MS Sans Serif - DeleteRec

SubFrm Purple Panelist Metric Scores

Purpose: Purple Panelists Data Source: Qry Edit Purple Panelists Rubric Metric Scores

Input Fields: - Metric ID → Metric ID - Purple Panelist Score ID → Purple Panelist Score ID - Purple Panelist ID → Purple Panelist ID - Metric → Metric - Purple Panelist Score → Purple Panelist Score

Actions: - MS Sans Serif

SubFrm Purple Panelist Score Evidence

Purpose: Evidence: Data Source: Unbound

Input Fields: - Calibri - Purple Panelist Score Evidence → Purple Panelist Score Evidence - Purple Panelist Score ID → Purple Panelist Score ID - Purple Panelist Evidence ID → Purple Panelist Evidence ID

Actions: - Calibri - DeleteRec

SubFrm Purple Panelist Strengths

Purpose: Purple Panelists Data Source: Purple Panelist Strengths

Input Fields: - Purple Panelist ID → Purple Panelist ID - Purple Panelist Strengths ID → Purple Panelist Strengths ID - Purple Panelist Strengths → Purple Panelist Strengths

Actions: - MS Sans Serif - DeleteRec

SubFrm Purple Panelists

Purpose: Purple Panelists Data Source: Purple Panelists

Input Fields: - Purple Panelist ID → Purple Panelist ID - Purple Panelist → Purple Panelist - Purple Panelist Total Score → Purple Panelist Total Score - Convener → Convener - Purple Panel ID → Purple Panel ID - Business Area → Business Area

Actions: - MS Sans Serif - DeleteRec

SubFrm Rubric Metrics NOT in List

Purpose: Telephone Interview Questions Data Source: Temp Rubric Metrics NOT in the List

Input Fields: - Metric → Metric - Metric Description → Metric Description - Metric ID → Metric ID - Add it → Add it - Metric Weight → Metric Weight

Actions: - MS Sans Serif

SubFrm Temp Purple Panelist Developmental Areas

Purpose: Purple Panelists Data Source: Temp Purple Panelist Developmental Areas

Input Fields: - Purple Panelist ID → Purple Panelist ID - Purple Panelist Developmental Areas ID → Purple Panelist Developmental Areas ID - Purple Panelist Developmental Areas → Purple Panelist Developmental Areas

Actions: - MS Sans Serif

SubFrm Temp Purple Panelist Strengths

Purpose: Purple Panelists Data Source: Temp Purple Panelist Strengths

Input Fields: - Purple Panelist ID → Purple Panelist ID - Purple Panelist Strengths ID → Purple Panelist Strengths ID - Purple Panelist Strengths → Purple Panelist Strengths

Actions: - MS Sans Serif

SubFrm View Purple Panelist Score Evidence

Purpose: Evidence: Data Source: Purple Panelists Evidence

Input Fields: - Calibri - Purple Panelist Score Evidence → Purple Panelist Score Evidence - Purple Panelist Score ID → Purple Panelist Score ID - Purple Panelist Evidence ID → Purple Panelist Evidence ID

Actions: - Calibri

ZZZ Save Frm Edit Purple Panel Convener Summary

Purpose: Frm Edit Purple Panel Convener Summary Data Source: Purple Panels

Input Fields: - Calibri - Calibri - Rubric ID → Rubric ID - Purple Panel Status ID → Purple Panel Status ID - Average Score → Average Score - Total Score Percentage → =IIf([Possible Score]=0,0,[Average Score]/[Possible Score]) - Panelist 1 Score Percentage → =IIf([Possible Score]=0,0,[Panelist 1 Score]/[Possible Score]) - Panelist 2 Score Percentage → =IIf([Possible Score]=0,0,[Panelist 2 Score]/[Possible Score]) - Panelist 3 Score Percentage → =IIf([Possible Score]=0,0,[Panelist 3 Score]/[Possible Score]) - Possible Score → Possible Score - ... and 8 more

Actions: - Calibri - AdjustScore - CloseForm - SubmitFinalPanel

ZZZ Save Frm Edit Purple Panelists Rubric Metric Scores

Purpose: Frm Edit Purple Panelists Rubric Metric Scores Data Source: Qry Edit Purple Panelists Main Form

Input Fields: - Calibri - Calibri - Calibri - Purple Panelist → Purple Panelist - Purple Panelist Total Score → Purple Panelist Total Score - Purple Panelist ID → Purple Panelist ID - Questions → Questions - Submitted → Submitted - Possible Total Score → Possible Total Score - Text73 → =IIf([Possible Total Score]=0,0,[Purple Panelist Total Score]/[Possible Total Sc - ... and 9 more

Actions: - Calibri - ChangeRubric - CloseForm - Submitpanel

ZZZ Save SubFrm Purple Panelist Metric Scores

Purpose: Purple Panelists Data Source: Qry Edit Purple Panelists Rubric Metric Scores

Input Fields: - Purple Panelist Score ID → Purple Panelist Score ID - Purple Panelist ID → Purple Panelist ID - Metric → Metric - Purple Panelist Score → Purple Panelist Score

Actions: - MS Sans Serif

Reports

Calibri: Purple Panel Feedback to COO (Source: Qry Report Purple Panel Feedback to COO)
Calibri: Purple Panel Succcessful (Source: Qry Report Purple Panel Results Successful)
Calibri: Purple Panel Unsucccessful (Source: Qry Report Purple Panel Results Unsuccessful)
Calibri: SubRpt Panelists (Source: Qry SubRpt Panelists)