Good evening,
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
where
t3.firmfile in (select firmfile from #policiesissued) and
t3.type in ('L-OE', 'F-L1E', 'I-L2E', 'L-L3E')
Thank you,
Colin.
Enterprise to Cameron Report Conversion
Moderator: Lisa Ennis
-
- Posts: 84
- Joined: Thu Sep 11, 2008 1:57 pm
Re: Enterprise to Cameron Report Conversion
The codes indicate policy, endorsement, or additional title charges and for which policy they are applicable to. Those specifically are endorsement codes for the different policies. The closest field that you will find to this in Select is in the pfm.TitleProduct table. The Type field in that table indicates the title product type. The explanation of the codes is in the zref.TitleProductItemType table.
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.
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.
Lisa Ennis
Senior Report Developer
SoftPro
Senior Report Developer
SoftPro