Page 1 of 1

CDF Fees

Posted: Wed Mar 23, 2016 2:32 pm
by dlerickson
What's the proper way to programmatically navigate to the Fees collection for a particular CDF charge? There is no path in the Field Code Browser for it. The particular example I'm looking at is Section E/Recording Fees, and the Fee breakdown in the tabbed grid on the bottom of the Charge popup screen.

Also, where is this located in SQL? I see no path to it there, either.

Thanks.

Re: CDF Fees

Posted: Wed Mar 23, 2016 5:00 pm
by BobRichards
The field code browser is a starting point - but as you observed, not all Select objects are displayed. Fortunately, it generally gives a good place to start. The following code snippet provides a path to the Fee object collection:

Code: Select all

// Navigate to the individual Tax and Government charge.
dynamic order = {the order's IOrder object}
dynamic cdf = order.CDFs[0];
dynamic section = cdf.TaxesAndGovernmentFeesSection;
dynamic line = section.Lines[0];
dynamic charge = line.Charges[0];

// Now examine the fees from the Fees property.
dynamic fee = charge.Fees[0];
I'll look into the SQL soon.

Re: CDF Fees

Posted: Tue Mar 29, 2016 10:44 am
by Lisa Ennis
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.

Code: Select all

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.RootId#=L.RootId# AND L.Id# BETWEEN CDF.Id# AND CDF.LastId#
INNER JOIN pfm.CDFCharge AS C ON L.RootId#=C.RootId# AND C.Id# BETWEEN L.Id# AND L.LastId#
INNER JOIN pfm.TaxAndGovernmentDetailChargeFee AS T ON C.RootId#=T.RootId# AND T.Id# BETWEEN C.Id# AND C.LastId#
LEFT JOIN zref.FeeScheduleType AS zF ON T.FeeScheduleType=zF.ID
LEFT JOIN zref.DocumentType AS zD ON T.DocumentType=zD.ID

Re: CDF Fees

Posted: Thu May 05, 2016 9:29 am
by cgriffin
I have a similar question, how do I get this information for Section B/C and H. I need to get to the Payee Grid and see the Payee Name. As you aware, the Payee can be different on the CDF Line, compared with the Payee Grid. I can get the contact information on the main line, but not "behind" the line, the Payee Grid.

I've looked at several different tables, CDFDetailSection, Servicesborrower......etc, to no avail.

Re: CDF Fees

Posted: Mon May 09, 2016 11:11 am
by Lisa Ennis
With additional joins, you can get to the information you need. To get contact information, join to the pfm.Contact table using the field names ending with "$". (LEFT JOIN pfm.Contact AS CT ON PE.RootId#=CT.RootId# AND PE.ContactId$=CT.Id#).

Code: Select all

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.CDFSection AS S ON CDF.RootId#=S.RootId# AND S.Id# BETWEEN CDF.Id# AND CDF.LastId#
INNER JOIN zref.CDFSectionType AS zS ON S.[Type]=zS.ID
INNER JOIN pfm.CDFLine AS L ON CDF.RootId#=L.RootId# AND L.Id# BETWEEN CDF.Id# AND CDF.LastId#
INNER JOIN pfm.CDFCharge AS C ON L.RootId#=C.RootId# AND C.Id# BETWEEN L.Id# AND L.LastId#
LEFT JOIN pfm.CDFPayee AS PE ON C.RootId#=PE.RootId# AND PE.Id# BETWEEN C.Id# AND C.LastId#
LEFT JOIN pfm.CDFPayor AS PR ON C.RootId#=PR.RootId# AND PR.Id# BETWEEN C.Id# AND C.LastId#