Hi
1) Is there a database document that shows the purpose of each table names in powerchurch? I export the database to MS Access and wants to create some queries in Access. But, I want to know the definition of each table and how they are related.
2) When I look at the COPLED table and run a query, it shows me tot_pled, amt_rcvd, amt_rem for each fund and each year until 2013. However, it shows nothing after 2013. I am not sure if there is something that was supposed to be done each year to populate this table. I know there are pledges created every year in 2014, 2015, 2016 and 2017 for each envelop and we collect moey from members each year and post it, but I do not know why this table does not show tot_pled, amt_rcvd, amt_rem .
Yaregal
Power church tables and contribution balance
Moderators: Moderators, Tech Support
Re: Power church tables and contribution balance
I'm assuming you're using v11.55, if not you can do a Knowledgebase search from the main Powerchurch support page for 'Data Files" to get the version list you need. Here's the list for v11.55, but as far as the relationship, you'll have to trace the data item names from table to table.yaregal wrote:Hi
1) Is there a database document that shows the purpose of each table names in powerchurch? I export the database to MS Access and wants to create some queries in Access. But, I want to know the definition of each table and how they are related.
https://www.powerchurch.com/support/396 ... data-files
Are you sure you're looking at the latest copy of the database ?? Does it show pledges for those years? Are the pledges for the Contribution Fund people are giving toward? I just checked my system, and it shows all that information right up to the current year. Although I do notice that under the 2017 pledge, while the program itself shows in the pledge detail how much was given to date along with the amount remaining, the record in the DB does not.2) When I look at the COPLED table and run a query, it shows me tot_pled, amt_rcvd, amt_rem for each fund and each year until 2013. However, it shows nothing after 2013. I am not sure if there is something that was supposed to be done each year to populate this table. I know there are pledges created every year in 2014, 2015, 2016 and 2017 for each envelop and we collect moey from members each year and post it, but I do not know why this table does not show tot_pled, amt_rcvd, amt_rem .
Yaregal
That said, all the other year's have that data listed.
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.
Re: Power church tables and contribution balance
Neal:
Yes. I have the latest copy of the DB and it shows the pledge amount up to 2017. Those are pledges that church members contribute towards. When I run any report that shows pledge to actual from powerchurch, I see the transactions. It is just the DB copy (access that do not have it) and I don not know why.
Yaregal
Yes. I have the latest copy of the DB and it shows the pledge amount up to 2017. Those are pledges that church members contribute towards. When I run any report that shows pledge to actual from powerchurch, I see the transactions. It is just the DB copy (access that do not have it) and I don not know why.
Yaregal
Re: Power church tables and contribution balance
It may be generated from the actual contribution table, rather than being stored on the pledge record until the end of the year. I'm not sure but I suspect someone may stop by on Monday to say somethingyaregal wrote:Neal:
Yes. I have the latest copy of the DB and it shows the pledge amount up to 2017. Those are pledges that church members contribute towards. When I run any report that shows pledge to actual from powerchurch, I see the transactions. It is just the DB copy (access that do not have it) and I don not know why.
Yaregal
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.