|
| | | Forum Guru
 
Group: Forum Members
Last Login: 9/8/2008 5:20:14 PM
Posts: 51, Visits: 183 |
| | We're looking to move to PDS, but before we do, I'd like to know the actual Table Structure so that I can begin setting up queries for it. |
| |
| | | 
www.ehuna.org
Group: Administrators
Last Login: 12/17/2008 10:36:11 PM
Posts: 258, Visits: 13,336 |
| | Calyx does not officially support direct data access on the PDS database. From our perspective, the SQL database is simply an internal way of storing our data to increase performance for Point users. That said, let me talk with the PDS team and see if I get the ok to document and publish information on the PDS database, including its schema. If I get the green light, I will include the following in this documentation: 1) An overview of the PDS tables: how they are related, which data is stored where, etc...
2) For each table, an exact description of each field. Is there anything else you are looking for?
Disclaimer: this post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.
|
| |
| | | Forum Guru
Group: Forum Members
Last Login: 9/8/2008 5:20:14 PM
Posts: 51, Visits: 183 |
| Let's start with that. Basically we're trying to develop a "Dashboard" for each LO/Manager so that they can just goto a web page and see their pipeline, YTD info, etc. without having to run reports or do any type of searching.
At present we don't plan on writing anything out to the Point Tables. |
| |
| | |
www.ehuna.org
Group: Administrators
Last Login: 12/17/2008 10:36:11 PM
Posts: 258, Visits: 13,336 |
| | iSupport, I talked it over with my boss and he understood your request. Right now we don't have any documentation ready, but this will be examined as a possible feature for future versions of PDS. Sorry, but currently I can't give you any more info.
Disclaimer: this post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.
|
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 4/4/2006 8:20:15 AM
Posts: 8, Visits: 17 |
| Will this be available in the 5.2 release? |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 1/5/2006 2:18:10 PM
Posts: 1, Visits: 2 |
| | Does Calyyx provide SQL data structures for version 5.2? I need to write a utility for my client and I need to know the table structure. Thanks, Justin Ericsson
-Justin Ericsson
justin.ericsson@essemble.com |
| |
| | | 
Forum Guru
Group: Forum Members
Last Login: 6/26/2008 6:48:15 AM
Posts: 70, Visits: 237 |
| | I am trying to use Crystal to write reports from Point PDS 5.4. By simply looking at individual tables, I have been able to create a report. We are using a ODBC (DSN) connection. The trouble is a Data Schema is badly needed to setup the proper links. For example, I cannot find the proper table linking to produce the Loan Officer Name. I tried the field "f19" but it does not contain the same data as the POINT Field 19. What I need is a true Data Schema showing the links. If you could find one for us, it would help a great deal. 
Thanks for your help, 
John Hoopes 
|
| |
| | | 
Sepal
Group: Moderators
Last Login: Today @ 6:19:09 AM
Posts: 1,183, Visits: 9,259 |
| I'm not sure what your seeing. f18 should be processor and f19 should be loan rep, just like in the file.
Disclaimer: This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.  |
| |
| | |
Forum Guru
Group: Forum Members
Last Login: 6/26/2008 6:48:15 AM
Posts: 70, Visits: 237 |
| | Okay, Some times just adjusting the SQL links fixes an issue. That is what happened with F18 & F19. Now my issue is with Loan Status. In FieldID.xls, loan status is variously called 6022, 6024, 9794, and 3296. Which doesn't matter because 6024 only displays non-standard status words (i.e. "2processing") instead of standard statuses (like Closed, Denied,or Withdrawn). Agh! Just a bit frustrated. The only way to get this far was to select every single table via the ODBC connection. Nothing you can do, beyond coming up with a Data Schema.
Thanks for your help,
John Hoopes |
| |
| | |
|