| |
|
|
|
|
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 in MI_QUEUE and MI_PUB_INFO.
By referencing this key, it is possible to select and show all info pertaining to a specific topic.
|
|
PUB_ID
|
Varchar - 64
|
Contains the unique ID of every publication in the Master index
|
By referencing this key, it is possible to select and show all info pertaining to a specific publication.
|
|
FOLDER_ID
|
Varchar - 64
|
Contains the ID of the folder where the Source document was stored.
|
This value can be used to select documents stored in the same folder on the DMS.
|
|
PUB_CATEGORY
|
Varchar - 254
|
Contains the category for the publication
|
By sorting and selecting on this key, you will be able to sort and display publications in specific categories.
|
|
PUB_TITLE
|
Varchar - 254
|
Contains the title of the publication
|
Usually you would use this value to categorise your content in the Front-end navigation
|
|
DOCUMENT_TITLE
|
Varchar - 254
|
Contains the title of every topic created from a publication
|
This is typically the value you would display as heading for a topic - by making it an active link you can select and display the content of the topic.
|
|
DOC_TYPE
|
Varchar - 64
|
Contains the name of the document profile used for this publication
|
By sorting and selecting on this key, you will be able to all documents of a specific type.
|
|
VERSION
|
Bigint - 8
|
Contains the internal version number of the source document
|
This value is set by the internal Hyper.Net bookkeeping and should not be used for anything else.
|
|
DISPLAY_VERSION
|
Varchar - 32
|
Contains the DMS version number of the source document
|
This value is the version number carried over from the Document Manager.
|
|
FOLDER_PATH
|
Varchar - 384
|
Contains the folder path of the source file
|
...
|
|
[LANGUAGE]
|
Varchar - 128
|
Contains the language of the publications
|
Can be used to sort publications and topics by language across front-ends.
|
|
REQUEST_PRIORITY
|
Bit
|
Priority of the publication request
|
Set this value if you want a publication request to have higher or lower priority than other requests.
|
|
REQUEST_PUBLICATION_DATE
|
Datetime - 8
|
Contains the requested publication date and time
|
Select on this field to show publications on, prior to or after a certain date. Is used by the Knowledge Transformer to publish content on the correct dates.
|
|
REQUEST_EFFECTIVE_DATE
|
Datetime - 8
|
Contains the effective date of the publication if specified at check-in of source
|
Select on this field to show current or future effective publications. Is used by the Knowledge Transformer to move content from "Non-effective" status to "Effective" status
|
|
REQUEST_EXPIRATION_DATE
|
Datetime - 8
|
Contains the expiration date of the publication if specified
|
Select on this field to show expired publications. Is used by Knowledge Transformer to retract content automatically from the website when the date is reached.
|
|
EFFECTIVE_APP
|
Bit
|
Set if the publication is effective and published for approval
|
By selecting on this field, you can show all publications that are effective, but pending approval.
|
|
EFFECTIVE_PROD
|
Bit
|
Set if the publication is effective and published for production
|
By selecting on this field, you can show all publications that are effective and published for production.
|
|
STATUS_APP
|
Varchar - 64
|
Approval Status of the publication if published for approval
|
By selecting on this field, you can show all publications that are pending approval or have been approved
|
|
STATUS_PROD
|
Varchar - 64
|
Status of the publication if approved for publication to production
|
By selecting on this field, you can show all publications that are have been approved and published for production.
|
|
XML_SOURCE
|
Ntext - 16
|
Contains the source file transformed to XML
|
Use this field if you want to use your own XSLT stylesheet to create transformed content.
|
|
SOURCE_FILENAME
|
Varchar - 64
|
Contains the filename of the source file
|
...
|
|
SOURCE
|
Image - 16
|
Contains the source file if published
|
...
|
|
REFERENCE_DMS
|
Varchar - 254
|
Contains the URL linking to the source document in the document manager
|
Use this link text to establish links from the front-end to the source document in the document manager
|
|
PUB_DATABASE_PROD
|
Varchar - 254
|
Contains the name of the database where content has been published into production
|
Select all publications published into a specific database by using this value.
|
|
URL_TARGET_PROD
|
Varchar - 254
|
Contains the URL to the production publication database
|
Use this value to link directly to the various production publication databases
|
|
TRANSFORMED_FORMAT
|
Bit
|
Is set if Transformed content is desired for this publication
|
Can be used to select publications with transformed content
|
|
TRANSFORMED_OPTIONS
|
Varchar - 64
|
Contains the options selected for the transformed content
|
Can be used to select publications with transformed content and e.g. visible Revision markings
|
|
XSLT
|
Varchar - 64
|
Contains the XSLT used for transformation
|
...
|
|
XML_TRANSFORMED_FORMAT
|
Bit - 1
|
Is set if XML is used as basis for transformed content
|
Not yet in use - preparation for full support of XML as basis for content
|
|
XML_TRANSFORMED_OPTIONS
|
Varchar - 64
|
Contains the options selected for the XML-based transformed content
|
Not yet in use - preparation for full support of XML as basis for content
|
|
XML_XSLT
|
Varchar - 64
|
Contains the name of the XSLT used to transform the XML File
|
Not yet in use - preparation for full support of XML as basis for content
|
|
HTML_FORMAT
|
Bit
|
Is set if Native HTML content is desired for this publication
|
Can be used to select publications with native HTML content
|
|
HTML_OPTIONS
|
Varchar - 64
|
Contains the values of options selected for Native HTML Content
|
Can be used to select publications with HTML content and e.g. visible Revision markings
|
|
PDF_FORMAT
|
Bit
|
Is set if PDF content is desired for this publication
|
Can be used to select publications with PDF content
|
|
PDF_OPTIONS
|
Varchar - 64
|
Contains the values of options selected for PDF Content
|
Can be used to select publications with PDF content and e.g. visible Revision markings
|
|
SOURCE_FORMAT
|
Bit
|
Is set if publication of the source document is desired for this publication
|
Can be used to select publications with a published source file
|
|
SOURCE_OPTIONS
|
Varchar - 64
|
Contains the values of options selected for Source Content
|
Can be used to select publications where the source file has been published with e.g. visible Revision Markings
|
|
SCHEMA_NAME
|
Varchar - 64
|
Contains the name of the transformation scheme used
|
Use to select publications based on a certain scheme
|
|
NOTIFICATION_EMAIL_APP
|
Varchar - 254
|
Contains the email of the user who is set as the Approver of this publication
|
...
|
|
NOTIFICATION_EMAIL_PROD
|
Varchar - 254
|
Contains the email of the user to be notified when publication is published for production
|
...
|
|
LAST_MOD_DATE
|
Datetime - 8
|
Contains the date of the last modification of the source
|
Can be used to show when documents where last modified
|
|
LAST_MOD_BY
|
Varchar - 64
|
Contains the name of the last user to modify the source
|
Can be used to show who last modified documents
|
|
LAST_APPROVAL_DATE
|
Datetime - 8
|
Contains the latest approval date of the publication
|
Can be used to select publications approved on a specific date
|
|
LAST_APPROVER
|
Varchar - 64
|
Contains the Id of the last user to approve the publication
|
...
|
|
LAST_APPROVER
|
Varchar - 64
|
Contains the name of the last user to approve the publication
|
Can be used to select publications approved by a specific user
|
|
COMMENT
|
Ntext - 16
|
Contains the comment entered at check-in of source
|
Value is mapped from the document manager
|
|
SEARCH_DATA
|
Ntext - 16
|
Contains content specifically used for full-text search
|
An abstract created by Hyper.Net during publication. Is used for speeding up full-text indexing and searching.
|
|
PS
|
Image - 16
|
Contains the PS file used to generate PDF content
|
...
|
|
ADDITIONAL_FILE
|
Image - 16
|
Contains any additional files created e.g. by a custom transformer
|
...
|
|
DMS
|
Varchar - 50
|
Contains the name of the document manager where the publication came from
|
...
|