Summary Table
Categories |
Total Count |
PII |
0 |
URL |
0 |
DNS |
0 |
EKL |
0 |
IP |
0 |
PORT |
0 |
VsID |
0 |
CF |
0 |
AI |
0 |
VPD |
0 |
PL |
0 |
Other |
0 |
File Content
package gov.va.med.ars.dao.ars;
import java.util.List;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;
import gov.va.med.ars.model.PatientIdProvNpi;
import gov.va.med.domain.ars.Entityname;
@Repository
public interface EntityNameRepository extends JpaRepository<Entityname, Long> {
@Query(nativeQuery = true, value = "select en1.nm109 as patientid, en2.nm109 as providernpi from ARS_OWNER.entityname en1 join ARS_OWNER.entityname en2 on en1.attachment_id = en2.attachment_id where en1.nm101 = 'QC' and en2.nm101 = '1P' and en1.attachment_id = :attachmentId")
List<PatientIdProvNpi> getPatientIdProviderNpi(@Param("attachmentId") String attachmentId);
@Query(nativeQuery = true, value ="select en.nm109 as patientid from ARS_OWNER.entityname en where en.nm101 = 'QC' and en.LOOP_ID ='1000D' and en.ATTACHMENT_ID = :attachmentId")
String getPatientId(@Param("attachmentId") String attachmentId);
}