Search found 84 matches

by Lisa Ennis
Tue Apr 19, 2016 12:05 pm
Forum: Crystal Report Development
Topic: requirements and exceptions in the db
Replies: 1
Views: 2265

Re: requirements and exceptions in the db

They are in the pfm.Phrase table. That table inherits from pfm.TitleProduct table. Zref tables are zref.RequirementExceptionNumberingType, zref.RequirementExceptionType, zref.RequirementExceptionNumberingType, and zref.RequirementExceptionType.

Hope this information helps!
by Lisa Ennis
Tue Apr 12, 2016 5:03 pm
Forum: Integration Development
Topic: Disbursing on Issued Policies
Replies: 5
Views: 945

Re: Disbursing on Issued Policies

Since you are trying to tie this back to disbursements in ProTrust, you may want to use the pt.RevenueDetail table instead. The pt.TitleCharge table joins to the pt.RevenueDetail table (RD.GUID=TC.TransactionID) and has some of the information related to title charges stored in XML that you can extr...
by Lisa Ennis
Tue Mar 29, 2016 10:44 am
Forum: General
Topic: CDF Fees
Replies: 4
Views: 1257

Re: CDF Fees

The joins for your SQL query to get the recording fees collected on the CDF are below. Please let us know if you have any additional questions. SELECT * FROM pfm.[Order] AS O INNER JOIN pfm.CDF AS CDF ON O.RootId#=CDF.RootId# AND CDF.Id# BETWEEN O.Id# AND O.LastId# INNER JOIN pfm.CDFLine AS L ON CDF...
by Lisa Ennis
Wed Feb 17, 2016 4:46 pm
Forum: General
Topic: Settlement Agent/SellingAgentBrokers
Replies: 3
Views: 1062

Re: Settlement Agent/SellingAgentBrokers

The field RootId# that exists in most of the pfm schema tables is the order id. As you traverse down through the tables, you also need the between joins of Id# and LastId# from the table above it in hierarchy.
by Lisa Ennis
Wed Feb 17, 2016 11:57 am
Forum: General
Topic: Settlement Agent/SellingAgentBrokers
Replies: 3
Views: 1062

Re: Settlement Agent/SellingAgentBrokers

This gets the data based on the contact types. SELECT Name, C.Address#Address1 AS Address1, C.Address#Address2 AS Address2, C.Address#City AS City, C.Address#StateID, zS.Code AS [State], C.Address#Zip, C.LicenseNumber, P.FirstName AS MainPersonFirstName, P.LastName AS MainPersonLastName, P.LicenseNu...
by Lisa Ennis
Tue Nov 03, 2015 5:26 pm
Forum: Crystal Report Development
Topic: TaxAndGovernmentDetailChargeFee
Replies: 3
Views: 2541

Re: TaxAndGovernmentDetailChargeFee

Email me directly at lisa.ennis@softprocorp.com and I will get it to you.
by Lisa Ennis
Tue Nov 03, 2015 10:51 am
Forum: Crystal Report Development
Topic: TaxAndGovernmentDetailChargeFee
Replies: 3
Views: 2541

Re: TaxAndGovernmentDetailChargeFee

You do not need the join to the pfm.TaxAndGovernmentDetailSection table. The code below is the correct join. SELECT TAGDCF.* FROM pf.[Order] AS O INNER JOIN pfm.[Order] AS ORD ON ORD.RootId# = O.RootID INNER JOIN pfm.CDF AS C ON C.RootId# = ORD.RootId# AND C.Id# BETWEEN ORD.Id# AND ORD.LastId# INNER...
by Lisa Ennis
Thu Sep 24, 2015 5:37 pm
Forum: Crystal Report Development
Topic: Invalid analyzer handle
Replies: 3
Views: 1360

Re: Invalid analyzer handle

That specific stored procedure had been troublesome on a customer's site due to how a join was being handled by SQL and rendered unexpected results, causing it to break the document. We split the sub report that was returning both buyers and sellers side by side into separate sub reports. The new su...
by Lisa Ennis
Thu Sep 24, 2015 9:22 am
Forum: Crystal Report Development
Topic: Invalid analyzer handle
Replies: 3
Views: 1360

Re: Invalid analyzer handle

The first step I would do in troubleshooting this issue would be to open the report in Crystal Reports and verify the database. This can assist with identifying issues with fields being returned by your query. Also, if your report is using a stored procedure, does the stored procedure execute on the...
by Lisa Ennis
Thu Jul 30, 2015 11:39 am
Forum: Crystal Report Development
Topic: Different Date in Database As Compared to Application
Replies: 1
Views: 945

Re: Different Date in Database As Compared to Application

Any dates in the database that have the time indicated (not 00:00:00.000) are stored as UTC. When you view those dates in the program they are being converted to the time zone of the client machine. You can use the function dbo.ConvertTimeFromUTC in your queries to convert the UTC datetime stored in...