IL_AC19_5a_TamikaWilliams_1.accdb

IfSuccessful_StatusGA_Status_IconSAM_Logo
true
false
IDFirstNameLastNameAssignmentGUIDUserID
falseTamikaWilliams{D4534485-EA05-40C1-8AD5-F5988D1667A4}{D4534485-EA05-40C1-8AD5-F5988D1667A4}
IDFirstNameLastNameProjectNameSubmissionNumMaxScoreScoreEngineVersion
IDStepNumberDescriptionIfSuccessfulStepScoreStepMaxScoreErrorTextActionNameStepActionOrder
ClientIDClientNameEmployeesContractSignedProjectStartConsultantID
1Biolane Products50007/8/219/1/21110345
2Perosis Medical Supplies25007/8/219/1/21110347
3Dynava Industries15007/9/219/1/21110467
4Locenda Clothing45007/12/2110/1/21110468
5Scizu Manufacturing40007/15/2110/1/21110479
6Bellismova Corporation20007/16/2110/1/21110481
7Skante Corporation25007/23/2110/1/21110345
8Oyomm Company30007/30/2111/1/21111222
9Pyrolira Testing Services15508/3/2111/1/21110481
10Sucoid Corporation25008/5/2111/1/21111767
11Isoxo Industries30009/1/2111/1/21111244
12Protolane Energy10009/1/2111/1/21111289
13Divagen Chemicals16009/2/211/1/22111292
14Trumba Automotive18009/2/211/1/22114234
15Ainyx Steel22009/3/211/1/22111222
ComponentIDClientIDSoftwareCode
11HRIS
22HRIS
33HRIS
44HRIS
55HRIS
66HRIS
77HRIS
88HRIS
99HRIS
1010HRIS
111EMPR
121HRAN
131ICOM
141ONBD
152PMGT
162RECR
172SCRE
182TALM
192EMPR
203EMPR
213HRAN
223ICOM
234ONBD
244RECR
255ONBD
265RECR
276EMPR
286HRAN
306ICOM
316ONBD
326PMGT
336RECR
346SCRE
356TALM
367ONBD
378RECR
388SCRE
398ONBD
409TALM
419HRAN
4210SCRE
ConsultantIDFirstNameLastNameResideSalary
110345JenetteMastersonUSA65000.0
110347VictorinaHoggCAN70000.0
110349MargueriteHathcockUSA62000.0
110351SidneyOrtizUSA60000.0
110352GlennTestaniFRA54000.0
110453BertHobaughUSA72000.0
110467MelodieTrujilloESP73500.0
110468DomingoBriskerUSA68345.0
110479SueHeywoodUSA49950.0
110481TennilleSteinmetzCAN52750.0
111222RustyHorrocksISL58750.0
111244VeolaCalderUSA59650.0
111267NorrisHuddlestonGBR84500.0
111289TeresaAshalintubbiPOL76550.0
111292YuonneKeleherISL73500.0
111301NormanMccainUSA68750.0
111456DustinNussUSA79000.0
111478JeanneGuardiolaESP75000.0
111499DebbieCoyleUSA66550.0
111767TalithaPriesDEU68000.0
112111LoreanHuieUSA59000.0
112139RozannePettitUSA51000.0
112368GeorgiannMcgraneGBR54000.0
112456BrendaGillUSA72000.0
112567ElfriedaOrtezESP85000.0
112589KeciaTalamantesPOL55000.0
112741LaineCalifanoFRA58000.0
112987TaishaStolleUSA71000.0
113123HettieChoFRA71000.0
113345OzellMouldenUSA75000.0
113456SharilynSipesUSA65000.0
113567DaniloCostCAN80000.0
113678MathildaBonnerUSA54000.0
113789RollandSwinsonUSA60000.0
113890KimikoFeltenEST70000.0
114123LaticiaLewellenUSA73000.0
114234LexieRinerUSA67000.0
114345ElizabethLavalleUSA62500.0
114567JudyfulMeiningerUSA50000.0
CountryCodeCountryName
BGRBulgaria
BLRBelarus
CANCanada
DEUGermany
ESPSpain
ESTEstonia
FRAFrance
GBRUnited Kingdom
ISLIceland
POLPoland
ROURomania
SRBSerbia
USAUnited States
SoftwareCodeComponentNameInstallationFeeMonthlyfee
EMPREmployee Relations¤ 2,500.00¤ 50.00
HRANHR Analytics¤ 8,000.00¤ 50.00
HRISHR Information Software¤ 50,000.00¤ 1,000.00
ICOMTime and Attendance¤ 10,000.00¤ 200.00
ONBDOnboarding¤ 1,000.00¤ 50.00
PMGTPerformance Management¤ 4,000.00¤ 50.00
RECRRecruiting¤ 4,000.00¤ 50.00
SCREScreening¤ 3,000.00¤ 50.00
TALMTalent Management¤ 2,000.00¤ 50.00
SELECT DISTINCTROW *FROM Client;
SELECT DISTINCTROW *FROM Consultant;
SELECT DISTINCTROW *FROM Consultant;
SELECT DISTINCTROW *FROM Country;
SELECT DISTINCTROW *FROM Consultant;
SELECT DISTINCTROW *FROM Country;
SELECT SoftwareComponent.ComponentName, Client.ClientName, SoftwareComponent.InstallationFee, SoftwareComponent.MonthlyfeeFROM SoftwareComponent INNER JOIN (Client INNER JOIN ClientSoftware ON Client.ClientID = ClientSoftware.ClientID) ON SoftwareComponent.SoftwareCode = ClientSoftware.SoftwareCode;
SELECT [FirstName] & " " & [LastName] AS StudentName, [_GradingReport].ProjectName, "Submission #" & [SubmissionNum] AS SubmissionCt, [_GradingReport].Score, [_GradingReport].MaxScore, "Score is: " & [Score] & " out of " & [MaxScore] AS Grade, [_GradingReportSteps].[StepNumber] & ". " & [Description] AS Step, [_GradingReportSteps].[StepScore] & "/" & [_GradingReportSteps].[StepMaxScore] AS StepGrade, [_GradingReportSteps].ActionName, IIf([ifsuccessful]=True,Null,[ErrorText]) AS Feedback, [_GradingReportSteps].IfSuccessful, [_GradingIcons].GA_Status_Icon, [_GradingReportSteps].StepNumber, [_GradingReportSteps].StepActionOrder, [_GradingReportSteps].ID, [_GradingIcons].SAM_Logo, [_GradingReportSteps].Description, [_GradingReport].EngineVersionFROM _GradingReport, _GradingIcons INNER JOIN _GradingReportSteps ON [_GradingIcons].[IfSuccessful_Status] = [_GradingReportSteps].IfSuccessful;