The Kerux database is filled with numbers, more than you may think necessary.  Believe it or not, they each serve a distinct purpose.  Here is a description of each:

P#        The full name is Personal Number.  (In the underlying data table it is named ResourceID.)  This number is manageable in size and will increment for each new record you add to the database.   Ten different users may have the same sermon illustration in their database but each could have a different Personal Number for this record.  All records will have a Personal Number.  If you update your database by downloading a new mega-database, the Personal Number of any of your own records that you transfer will be changed.  Only the UniqueID (=ReplicationID) is unchangeable.

H#        The full name is HolwickID.  In the original database, all new illustrations or sermons had to be funnelled through Rev. David Holwick so they could have this unique ID number attached.  While a record's Personal Number would differ from user to user, the HolwickID (also known as a KeruxID) would stay the same.  This number was required for supplements to work.  With this new version that is no longer the case.  If a record has this number, it means it originated in Pastor Holwick's database; other records will be blank in this field.  In the original version, HolwickID was used in illustrations and Holw-serm-ID was used for sermons.  The new version consolidates those under HolwickID.  When you add records, do not manually put a number in this field or future updates from David Holwick may overwrite your material.

Unique ID        This number is a new addition to the database and a very important one.  You will find it on the front page of the Resources form and also on the Details page (it can be turned off on the Details page).  It doesn't look like a number because it has alphabet letters as well, so that it looks like this:  {ABD200DE-D3C3-4A10-9BC6-AA916B673707}.  The Unique ID, called the ReplicationID in the underlying data table, is the one number that will be universally attached to this record, forever.  It will never change.  The beauty of it is that if a million pastors enter a million records a day for a million years, each record will have a unique number here.  Because of this number (also known as a GUID) any pastor can share a supplement of records with other pastors, and future updates will correctly find them; in the past, all changes had to go through the editor David Holwick to keep consistency.  Now they do not.  The disadvantage of a Replication number is that it is unwieldy so you may want to use the Personal Number when you notate illustrations in your sermons.

SermonID        Older versions of the database had a number that represented the sermons that a particular preacher had in the database.  It was not consistently applied.  The first sermon would always be "1" and it would increase to the final sermon number.  This number is called OldID in the underlying data table.

You may notice gaps in the ID numbers even if you download all the sermon and illustration sets.  This is normal - some material is not distributed because of heresy or copyright concerns.  On occasion one of David Holwick's sermons will reference one of these "forbidden" illustrations or sermons.  At the end of most years he creates a CSV table that lists the creation and modification dates for all the existing records in his original database; it can be found on the supplement set download page at the website.

Copyright 2011 by Rev. David Holwick

Created with the Freeware Edition of HelpNDoc: Create HTML Help, DOC, PDF and print manuals from 1 single source