| |
|
|
|
|
Column
|
Datatype
|
Purpose
|
Comments
|
|
DOC_ID
|
Varchar - 64
|
Contains the unique document id of every topic created in the publication process.
|
Unique key and foreign key from MI_MAIN and in MI_PUB_INFO.
|
|
PRIORITY
|
Bit
|
Shows if the publication request has priority or not
|
Can be used to sort publication requests on priority
|
|
PUB_DATE
|
Datetime - 8
|
Shows the date for the publication action
|
Can be used to select or sort requests by date
|
|
PUB_ACTION
|
Varchar - 32
|
Shows which action to be taken on this publication - delete or publish
|
Can be used to show only e.g. deletion requests
|
|
AUDIENCE
|
Varchar - 32
|
Contains information about the intended audience of a publication
|
Can be used to select requests for specific audiences
|
|
EFFECTIVE
|
Varchar - 32
|
Set if the request is for an effective version of a document
|
...
|
|
STATUS
|
Varchar - 64
|
Shows the actual status of the publication request - either "Pending" - "In progress" or "Publication Error"
|
Can be used to sort/select publication requests based on status
|
|
KT_SERVER
|
Varchar - 64
|
Contains the name of the Content Automation Server currently processing this request
|
Used in a Fail-Over/Load-Balancing setup
|
|
RETRY_FAILED
|
Smallint - 3
|
Contains the number of retries for publication of this request
|
Used in fail-over setup
|