Setting Options for Publishing Tables in the Online Directory
On the Options for Publishing Tables form, you set your institutional choices regarding the publication of data on a table by table basis.You will also set your institutional preference as to whether you will allow a constituent to Update his or her own data by using the Online Constituent Directory. The tables that are available for the Online Constituent Directory are shown in the form's Table Name column.
Publication and Update are System options!
Publication
Set the Publication options for each data table that is available for the Online Constituent Directory by choosing the option from the boxes in the form's Publication column. There are four possible Publication options.
Not Published
The directory will not publish any data from the corresponding table, even if the constituent specifically grants permission to do so through his or her Constituent Global Publish Options.
Published
The directory will publish data from the corresponding table, even if the constituent requests that they do not through his or her Constituent Global Publish Options.
Each constituent can control the publication of his or her own data, as described in the Constituent Options section of the topic (below). This means that the data from the corresponding table will be published IF and ONLY IF the constituent has indicated a willingness to allow you to do so through their Constituent Global Publish Options and if the constituent sets the Publish flag on each data row to Publish.
Constituent Only
The directory will publish data from the corresponding table for the Constituent Only. The directory will not publish any of the data in the corresponding table to any other constituent, even if the constituent specifically granted permission to do so through his or her Constituent Global Publish Options.
Options for Publishing Tables Hierarchy
It is important to note the hierarchy of the Options for Publishing Tables and how it relates to what the constituent has control over when they log in to the Online Constituent Directory; the Options for Publishing Tables of 'Not Published', 'Published', or 'Constituent Only' take precedence over any Constituent Global Publish Options that the constituent sets.
Each data table that is a part of the Online Constituent Directory has its own Publish flag field. A new data row will have its Publish flag set in accordance with the value of the Basic Data Publish field that corresponds with the data table. If the value of the Basic Data Publish field is set to 'Y', then the new data row's Publish flag will be set to 'Y'. But if the Basic Data Publish field is set to 'N', then the new data row's Publish flag will be set to 'N' as well. For example, if the Options for Publishing Tables for the Attribute table is set to 'Publish', then the corepub03 field is set to 'Y', and the attrpubfl for a constituent's new attribute row will likewise be set to 'Y'.
New Millennium constituents will have their Basic Data Publish fields (corepubXX) populated Y or N in accordance with these System Options for Publishing Tables settings. If the Options for Publishing Tables for a data table is set to 'Do Not Publish', 'Publish by Consent', or 'Constituent Only', then the Basic Data Publish field (corepubXX) for that table will initially by set to 'N' when a new constituent is created. If the Options for Publishing Tables for a data table is set to 'Publish', then the Basic Data Publish field (corepubXX) for that table will initially be set to 'Y' when a new constituent is created. For example, if the System Options for Publishing Tables for Names is set to Publish but for Basic Data is set to Do Not Publish, the field for those new constituent's Name (corepub01) will be 'Y' and the field for Basic Data (corepub00) will be 'N'.
When the constituent logs on to the Online Constituent Directory, he or she will see the Publish flag on his or her individual data records only if the System Options for Publishing Tables is set to 'Publish by Consent'.
More...
The Options for Publishing Tables settings are stored in the sysinfo system table. There is a field for each of the data tables that are a part of the Online Constituent Directory; for example, the field that corresponds to the Basic Data table is named ecomm_pub_00.
The following table names the publish flag fields for each table that is part of the Online Constituent Directory.
|
Table |
Publish Flag |
|---|---|
|
Basic Data |
corepublsh |
|
Name |
namepubfl |
|
Address |
addrpubfl |
|
Attribute |
attrpubfl |
|
Relation |
relpubfl |
|
Jobs |
jobspubfl |
|
Education |
schlpubfl |
|
Phone |
phnpubfl |
|
Comments |
commpubfl |
|
Internet Address |
intpubfl |
|
Custom Bio |
cbiopubfl |
Update
Set the Update option for each data table that is available for the Online Constituent Directory by choosing the option from the boxes in the Update column on the Options for Publishing Tables form. Determine for what tables your organization will allow a constituent to Update his or her own data through the Online Constituent Directory. If your organization will allow a constituent to edit his or her data, select Y (Yes), If you do not want to allow edits, select N (No) instead.
More...
If data updates are permitted, then, when the constituent submits updates, insertions, or deletions via the directory, a data row will be inserted in the pending table that corresponds to that data table. Each data row that already exists in a Millennium data table will have one (and only one) corresponding row in the pending table; this pending table data row will contain edits to the existing data row, or a flag to tell the system to delete that existing data row. However, the pending table may contain rows that will generate the insertion of new data rows for the constituent, or that will flag a data row for deletion.
The Update settings are stored in the sysinfo system table. There is a field for each of the data tables that are a part of the Online Constituent Directory; for example, the field that corresponds to the Basic Data table is named ecomm_upd_00.
Publication and Update Options for Giving
The Options for Publishing Tables for constituent gift information is restricted to the Not Published and Constituent Only settings. And, existing constituent gift information can not be updated nor deleted via the Online Constituent Directory.