SC_AC16_3a_JesusMojica_1.accdb
IfSuccessful_Status | GA_Status_Icon | SAM_Logo |
true | |
|
false | |
|
ID | FirstName | LastName | AssignmentGUID | UserID |
false | Jesus | Mojica | {2747B2D8-5B5E-4B77-AD2A-2C2EEFACB4CB} | {2747B2D8-5B5E-4B77-AD2A-2C2EEFACB4CB} |
ID | FirstName | LastName | ProjectName | SubmissionNum | MaxScore | Score | EngineVersion |
ID | StepNumber | Description | IfSuccessful | StepScore | StepMaxScore | ErrorText | ActionName | StepActionOrder |
AdRepNumber | LastName | FirstName | PhoneNumber | Address | City | State | PostalCode | Salary | DateHired | Insurance |
AM01 | Miller | Abraham | 503-555-6032 | 54 Quarry Ave. | Portland | OR | 97210 | ¤ 32,540.00 | 6/1/16 |
|
GZ01 | Zdalnza | Gregory | 603-555-8765 | 7 Moose Head Rd. | Boise | ID | 83720 | ¤ 29,675.00 | 9/14/16 |
|
KS02 | Stenhope | Kathryn | 503-555-0003 | 9 Shennadoah Ave. | Salem | OR | 97311 | ¤ 34,576.00 | 10/5/15 |
|
MR01 | Riley | Max | 781-555-2323 | 24 Spring Rd | Casper | WY | 83114 | ¤ 30,450.00 | 8/6/16 |
|
RH01 | Horton | Rowan | 207-555-9009 | 12 Heather Rd. | Portland | OR | 97211 | ¤ 35,275.00 | 7/13/15 |
|
SL01 | Lorens | Stephanie | 802-555-3339 | 15 River Rd. | Spokane | WA | 99202 | ¤ 37,350.00 | 4/5/15 |
|
UG01 | Grea-Mayers | Ursula | 207-555-8534 | 342 Pine St. | Seattle | WA | 98101 | ¤ 41,765.00 | 12/12/14 |
|
AdvertiserID | AdvertiserName | Address | City | State | PostalCode | Current Due | AdRepNumber |
BBF32 | Babbage CPA Firm | 464 Linnell Dr. | Seattle | WA | 98104 | ¤ 7,875.25 | UG01 |
BCC76 | Burns Community College | 867 Ridge Ave. | Burns | OR | 97720 | ¤ 5,452.30 | RH01 |
BMS53 | Boise Medical Services | 134 Main St. | Boise | ID | 83720 | ¤ 6,152.25 | GZ01 |
CDS29 | Carter Dental Services | 123 Second St. | Dallesport | WA | 98617 | ¤ 5,475.75 | SL01 |
CRR15 | Columbia River Rafters | 125 River Blvd. | Portland | OR | 97209 | ¤ 3,600.50 | RH01 |
CWW01 | Casper Western Wear | 10 Broadway St. | Casper | WY | 83114 | ¤ 4,125.50 | MR01 |
GAD74 | Grant Antique Dealers | 78 Catawba Dr. | Grants Pass | OR | 97526 | ¤ 1,200.00 | GZ01 |
GCF56 | Goldendale City Foundation | 65 Simpson Dr. | Goldendale | WA | 98620 | ¤ 2,400.00 | SL01 |
GPM12 | Grants Pass Motel | 235 Second Ave. | Grants Pass | OR | 97526 | ¤ 2,460.75 | AM01 |
GRI03 | Germann Inn | 345 Hartsel Ave. | Madras | OR | 97741 | ¤ 2,870.65 | AM01 |
HAR01 | Haydee's Restaurant | 234 Twiddy St. | Eugene | OR | 97402 | ¤ 2,500.00 | RH01 |
HCH10 | Hendley County Hospital | 216 Rivard Blvd. | Spokane | WA | 99201 | ¤ 7,234.60 | SL01 |
IOA23 | Idaho Outdoor Adventures | 12 Third St. | Twin Falls | ID | 83301 | ¤ 6,500.00 | KS02 |
KDS21 | KAL Design Studio | 116 Pine St. | Arden | WA | 99202 | ¤ 1,550.50 | UG01 |
KGS04 | Kyle General Store | 421 First St. | Cokeville | WY | 83114 | ¤ 2,875.50 | MR01 |
LCA42 | Lewis and Clark Adventures | 100 Main St. | Goldendale | WA | 98620 | ¤ 4,500.00 | SL01 |
LFS02 | Lewis Furniture Store | 267 Main St. | Payette | ID | 83661 | ¤ 2,890.70 | MR01 |
MBT14 | Mike's Bike Tours | 234 Gilham St. | Salem | OR | 97301 | ¤ 1,345.60 | KS02 |
PJG34 | Patricia Jean Greenhouses | 345 Magee Ave. | Seattle | WA | 98101 | ¤ 2,450.00 | UG01 |
RER23 | Rivers Edge Restaurant | 125 River Rd. | Kettle Falls | WA | 99141 | ¤ 1,375.00 | GZ01 |
SLA77 | Smarter Law Associates | 764 Main St. | Portland | OR | 97209 | ¤ 0.00 | AM01 |
TVS17 | Theon Veterinary Services | 346 Austin Ave. | Casper | WY | 83114 | ¤ 2,500.00 | MR01 |
WEC05 | Western Energy Company | 12 Polk St. | Kettle Falls | WA | 99141 | ¤ 0.00 | GZ01 |
WSC01 | Wood Sports Complex | 578 Central Ave. | Cave Junction | OR | 97523 | ¤ 3,590.80 | KS02 |
BillboardID | Location | City | State | Height | Width | Illuminated | DEC | Type | Facing |
LHAR04 | Hwy 395 | Arden | WA | 8.0 | 24.0 | Yes | 4395 | Digital | North/South |
LHBE01 | Hwy 97 | Beaver Marsh | OR | 8.0 | 24.0 | Yes | 3542 | Digital | North/South |
LHBU01 | Hwy 395 | Burns | OR | 10.5 | 48.0 | Yes | 1509 | Poster | North/South |
LHCA01 | Hwy 199 | Cave Junction | OR | 6.0 | 16.0 | No | 2024 | Junior Poster | North/South |
LHCA03 | Hwy 20-26 | Casper | WY | 10.0 | 32.0 | No | 1288 | Bulletin | West Only |
LHCH03 | Hwy 97 | Chemult | OR | 10.0 | 24.0 | Yes | 3411 | Digital | North/South |
LHCH05 | Hwy 93 | Challis | ID | 8.0 | 24.0 | No | 506 | Poster | North/South |
LHCO05 | Hwy 89 | Cokeville | WY | 10.0 | 20.0 | No | 506 | Poster | North/South |
LHDA03 | Hwy 197 | Dallesport | WA | 8.0 | 20.0 | No | 3700 | Junior Poster | North/South |
LHDC07 | Hwy 89 | Alpine | WY | 6.0 | 8.0 | No | 1964 | Junior Poster | North Only |
LHDD01 | Hwy 26 | Dubois | WY | 8.0 | 24.0 | Yes | 1016 | Poster | East/West |
LHGR01 | Hwy 18 | Grand Ronde | OR | 10.0 | 30.0 | Yes | 5182 | Bulletin | East/West |
LHGR02 | Hwy 99 | Grants Pass | OR | 10.0 | 25.0 | Yes | 5838 | Poster | North Only |
LHKE01 | Hwy 395 | Kettle Falls | WA | 6.0 | 10.0 | No | 7400 | Junior Poster | North/South |
LHKL01 | Hwy 97 | Klamath Falls | OR | 10.0 | 24.0 | Yes | 4461 | Digital | North/South |
LHMA01 | Hwy 97 | Madras | OR | 8.0 | 24.0 | Yes | 12070 | Digital | North/South |
LHMP01 | Hwy 97 | Modoc Point | OR | 8.0 | 24.0 | Yes | 5500 | Poster | North/South |
LHPA03 | Hwy 95 | Payette | ID | 12.0 | 24.0 | No | 3777 | Bulletin | North/South |
LHRI01 | Hwy 95 | Riggins | ID | 8.0 | 24.0 | Yes | 1524 | Digital | North/South |
LHRI02 | Hwy 20 | Rigby | ID | 14.0 | 48.0 | Yes | 13406 | Bulletin | North/South |
LHRO01 | Hwy 101 | Rockaway | OR | 5.0 | 8.0 | No | 1702 | Junior Poster | North/South |
LHSA01 | Hwy 114 | Salem | OR | 8.0 | 24.0 | Yes | 10224 | Poster | North/South |
LHSA03 | Liberty Road | Salem | OR | 9.0 | 27.0 | Yes | 11808 | Poster | North/South |
LHSA05 | Hwy 99 | Salem | OR | 8.0 | 24.0 | Yes | 10224 | Poster | North/South |
LHTW01 | Hwy 93 | Twin Falls | ID | 6.0 | 12.0 | No | 1564 | Junior Poster | North/South |
LHWE01 | Hwy 95 | Weiser | ID | 10.5 | 24.0 | No | 1748 | Poster | North/South |
LHWE04 | I-90 Exit 60 | Wallace | ID | 14.0 | 48.0 | Yes | 6888 | Bulletin | East/West |
LIBO01 | I-84 Exit 57 | Boise | ID | 21.0 | 47.0 | Yes | 14104 | Bulletin | East/West |
LIRO01 | I-5 Exit 120 | Roseburg | OR | 12.0 | 48.0 | Yes | 27618 | Bulletin | North/South |
LNPO01 | I-84 Exit 1 | Portland | OR | 14.0 | 48.0 | Yes | 110667 | Bulletin | East/West |
LSCO05 | Hwy 42 | Coquille | OR | 8.0 | 25.0 | Yes | 5642 | Digital | East/West |
LSEU01 | 6th Ave. | Eugene | OR | 10.0 | 24.0 | Yes | 19942 | Poster | East Only |
LSEU05 | Maxwell St. | Eugene | OR | 12.0 | 24.0 | Yes | 5707 | Poster | East/West |
LSEU07 | W. 11th St. | Eugene | OR | 10.0 | 24.0 | Yes | 21910 | Digital | East/West |
LSGO01 | Hwy 142 | Goldendale | WA | 8.0 | 16.0 | No | 1748 | Digital | East/West |
LSKL01 | S. 6th St. | Klamath Falls | OR | 8.0 | 24.0 | Yes | 11414 | Poster | East/West |
LSSP01 | Hwy 126 | Springfield | OR | 7.0 | 14.0 | Yes | 10037 | Junior Poster | East/West |
State | StateName |
CA | California |
NV | Nevada |
RentalID | BillboardID | Facing | Cost | Months | BeginDate | Discount | AdvertiserID |
1700200 | LHBU01 | North | 775.0 | 3.0 | 6/5/17 | | BCC76 |
1700201 | LNPO01 | East | 1600.0 | 4.0 | 5/2/17 | | CRR15 |
1700202 | LNPO01 | West | 1400.0 | 8.0 | 3/14/17 | | SLA77 |
1700204 | LHAR04 | North | 2500.0 | 1.0 | 9/4/17 | | KDS21 |
1700205 | LHSA03 | North | 800.0 | 2.0 | 7/1/17 | | MBT14 |
1700206 | LHSA03 | South | 800.0 | 2.0 | 7/1/17 | | MBT14 |
1700208 | LHGR02 | North | 790.0 | 2.0 | 9/12/17 | | GAD74 |
1700209 | LHTW01 | North | 350.0 | 5.0 | 4/11/17 | | IOA23 |
1700210 | LHDA03 | South | 300.0 | 6.0 | 6/5/17 | | CDS29 |
1700211 | LHCO05 | North | 875.0 | 4.0 | 5/12/17 | | KGS04 |
1700212 | LHWE01 | South | 900.0 | 1.0 | 9/12/17 | | BMS53 |
1700213 | LSGO01 | West | 2875.0 | 10.0 | 2/1/17 | | LCA42 |
1700215 | LHMA01 | South | 3000.0 | 3.0 | 6/5/17 | | GRI03 |
1700216 | LHCA03 | West | 2750.0 | 4.0 | 6/24/17 | | CWW01 |
1700217 | LHCA01 | North | 325.0 | 7.0 | 3/21/17 | | WSC01 |
1700219 | LHPA03 | South | 1625.0 | 3.0 | 8/13/17 | | LFS02 |
1700220 | LSEU01 | East | 775.0 | 2.0 | 7/1/17 | | HAR01 |
1700221 | LSEU05 | West | 775.0 | 2.0 | 7/1/17 | | HAR01 |
1700222 | LHDD01 | East | 825.0 | 1.0 | 9/14/17 | | KGS04 |
1700223 | LHKE01 | South | 365.0 | 3.0 | 8/25/17 | | HCH10 |
1700224 | LHAR04 | South | 3500.0 | 10.0 | 2/1/17 | | LCA42 |
1700225 | LHKE01 | North | 375.0 | 3.0 | 6/12/17 | | RER23 |
1700226 | LHCH05 | North | 700.0 | 4.0 | 5/25/17 | | IOA23 |
1700227 | LIBO01 | West | 1525.0 | 6.0 | 7/1/17 | | BMS53 |
State | StateName |
ID | Idaho |
OR | Oregon |
WA | Washington |
WY | Wyoming |
SELECT DISTINCTROW *
FROM Rentals;
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].EngineVersion
FROM _GradingReport, _GradingIcons INNER JOIN _GradingReportSteps ON [_GradingIcons].[IfSuccessful_Status] = [_GradingReportSteps].IfSuccessful;
SELECT AdRep.AdRepNumber, AdRep.FirstName, AdRep.LastName
FROM AdRep;