Operation Details
Description: Reads the court location (address and geo code) and details pertaining to the judge whose ID was specified. 
Sterotype: ns
SQL 
SELECT 
Address.addressData, 
Address.geoCode, 
Address.latitude, 
Address.longitude,
hearingConcernRole.concernRoleID, 
hearingConcernRole.concernRoleName, 
hearingConcernRole.concernRoleType, 
ExternalPartyOfficeMember.concernRoleID, 
judgeConcernRole.concernRoleName, 
judgeConcernRole.concernRoleType

INTO
:courtAddressData,
:geoCode,
:latitude,
:longitude,
:courtConcernRoleID,
:courtConcernRoleName,
:courtConcernRoleType,
:judgeConcernRoleID,
:judgeConcernRoleName,
:judgeConcernRoleType

FROM 
Address, 
LegalAction, 
ConcernRole hearingConcernRole, 
ConcernRole judgeConcernRole,
ExternalPartyOffice, 
ExternalPartyOfficeMember

WHERE  
LegalAction.caseID = :caseID AND 
LegalAction.locationID = ExternalPartyOffice.externalPartyOfficeID AND 
ExternalPartyOffice.concernRoleID =  hearingConcernRole.concernRoleID AND 
Address.addressID = ExternalPartyOffice.primaryAddressID AND 
ExternalPartyOfficeMember.officeMemberID = LegalAction.adjudicateID AND 
ExternalPartyOfficeMember.concernRoleID = judgeConcernRole.concernRoleID