Index: src/main/java/com/napa/pulse/repository/SiteRepository.java
===================================================================
diff -u -r419bb8b3593f009c43a549eab13cf4dabeb56762 -r0f1db46d7670e6e448eb2d9df49a7bed051a1198
--- src/main/java/com/napa/pulse/repository/SiteRepository.java	(.../SiteRepository.java)	(revision 419bb8b3593f009c43a549eab13cf4dabeb56762)
+++ src/main/java/com/napa/pulse/repository/SiteRepository.java	(.../SiteRepository.java)	(revision 0f1db46d7670e6e448eb2d9df49a7bed051a1198)
@@ -18,4 +18,10 @@
     @Query("select site from Site site where activeFlag = 'N' order by siteName")
     Iterable<Site> findInactiveSites();
 
+    @Query("select s.siteId from Site s where s.idNumber = :macId")
+    int findSiteId(Integer macId);
+
+    @Query("select s.idNumber from Site s where s.siteId = :siteId")
+    String findMacId(Integer siteId);
+
 }
\ No newline at end of file