diff --git a/Repositories/ADT/HarvestToADT.pl b/Repositories/ADT/HarvestToADT.pl
index c4c1098..4722c8e 100755
--- a/Repositories/ADT/HarvestToADT.pl
+++ b/Repositories/ADT/HarvestToADT.pl
@@ -29,7 +29,7 @@
 {
 	local ($ID, *args) = @_;
 	my $dbh = DBI->connect("DBI:mysql:$DB_NAME:$DB_HOST", $DB_USER, $DB_PASS);
-	my $query = $dbh->prepare("SELECT thesistype FROM archive WHERE eprintid ='$ID'");
+	my $query = $dbh->prepare("SELECT thesis_type FROM archive WHERE eprintid ='$ID'");
 	$query->execute;
 	my $numrows = $query->rows;
 
@@ -53,7 +53,7 @@
 {
 	local ($ID, *args) = @_;
 	my $dbh = DBI->connect("DBI:mysql:$DB_NAME:$DB_HOST", $DB_USER, $DB_PASS);
-	my $query = $dbh->prepare("SELECT year FROM archive WHERE eprintid ='$ID'");
+	my $query = $dbh->prepare("SELECT date_effective FROM archive WHERE eprintid ='$ID'");
 	$query->execute;
 	my $numrows = $query->rows;