Moderator: Lisa Ennis
I am trying to find where in the Cameron Database would I find the "Type" as indicated in the code below from Enterprise?
From what I can tell, it does not exist.
from policyregister t3
left outer join search t1 on t1.firmfile = t3.firmfile
t3.firmfile in (select firmfile from #policiesissued) and
t3.type in ('L-OE', 'F-L1E', 'I-L2E', 'L-L3E')
The Title tables and their joins are complicated. The rptdoc.PolicyRegister stored procedure to help with those joins. Also, Policies, Endorsements and AdditionalTitleCharges have their own tables, so INNER JOINs to those tables may also get you what you need.