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);


}