The modPubObjects Table

See Also

An important team solution feature is the ability to take a solution offline. This process is based on publications and subscriptions. Publications are defined by the solution developer and are stored in the modPublications and modPubObjects tables. This information is used to create SQL publications.

The modPubObjects table stores all the objects associated with each publication. The Pub_id column points to the ID column in the modPublications table.

Caution   It is recommended you do not manually alter the modPubObjects table. Use the Access Workflow Designer and the Team Solutions Manager to make changes to this table. Schema integrity is not guaranteed if you make manual changes to any solutions system tables.

The modPubObjects database table contains a number of columns used by the team solutions. The following table lists those columns and their data types and provides a brief description of each.

Column Data type Description
po_ID identity (int) Object ID for the database object in sysObjects.
po_Name nvarchar(256) Name of the publication object.
po_Type int Type of replication: merge, snapshot, none.
po_ObjectID int Maps the publication object with the sysObjects table.

Note   Do not modify this column.
po_PubID int Publication ID of the publication that includes this object.
po_Version int Current version of the database object.

Note   Do not modify this column.
po_VersionDate datetime Maps the date the publication object was last modified with the date in the system tables.

Note   Do not modify this column.
po_ReplType int Specifies the replication type for the object: 
0   Not replicated
1   Schema only - no data
2   Cannot modify
4   UserList view
16 Insert only
32 Update only
48 Insert and update only
64 Delete only
80 Insert and delete only
96 Update and delete only
114 Full merge
272 Workflow insert only *
288 Workflow update only *
304 Workflow insert and update only *
320 Workflow delete only *
336 Workflow insert and delete only *
352 Workflow update and delete only *
370 Workflow full merge *

Note   Those types marked with an asterisk (*) can be specified only by the Access Workflow Designer. Do not manually select these types.
po_HorizFilter nvarchar(256) Horizontal filter to apply for the shared publication.
po_VertFilter nvarchar(256) Vertical filter to apply for the publication.
po_JoinArticle nvarchar(256) Stores the name of the table to which the filter is joined.
po_JoinFilter nvarchar(256) Contains the filter clause used for join filters. (See "Join Filters" following this table.)

Join Filters

SQL Server supports join filters in merge replication. Join filters make it possible for you to extend the filtering of rows in one table to the filtering of rows in related tables.

When you filter a table horizontally for publication, you set criteria that include certain rows and exclude other rows. If you include other tables in your publication that contain data related to the data in the base table, you may not want the publication to include all the data in the related tables. Join filters make it possible for you to include only those rows in the related table you define as being relevant for the publication.

For more information about filtering offline publications, see Filtering Offline Data for a Publication.