Page 1 of 1

2.6 to 3.0 Data (Endorsement) Conversion issue?

Posted: Tue Jul 07, 2015 6:27 pm
by cgriffin
Good afternoon,

In 2.6 in the GUI and database both reflect endorsement charges.

However, in 3.0 both reflect endorsement charges in the GUI, but not in the expected places in 3.0

File ‘X’ is reflecting endorsement charges in the 3.0 database, specifically:

Endorsement (XML) field data:
AdditionalTitleCharge Guid
Description
TransactionCode
ChargeAmount
PolicyID (GUID)
NewLiabilityAmount

However, file ‘Y’ is not reflecting any data whatsoever in the above XML field.

Do you know of any issues?

Should we be looking in another place?

Thank you,
Colin.

Re: 2.6 to 3.0 Data (Endorsement) Conversion issue?

Posted: Wed Jul 08, 2015 4:35 pm
by BobRichards
If I understand your question, you are saying that you are writing directly to the Select SQL tables: You are not allowed to write nor modify any SoftPro installed data table.

Much of the information is maintained in the order and tables may be used for reading only.

Re: 2.6 to 3.0 Data (Endorsement) Conversion issue?

Posted: Wed Jul 08, 2015 4:48 pm
by Lisa Ennis
I believe the data Colin is looking at data stored in the pt.TitleCharge. Data writes to this table when a transaction is initially posted. If that table does not have what you need, you may need to join back to the Title and Endorsement tables in the pfm schema using the ChargeSource in the pt.RevenueDetail table.