| |
|
|
|
|
Column
|
Datatype
|
Purpose
|
Comments
|
|
PUB_UNID
|
Varchar - 64
|
Contains the unique Id of every publication
|
Is unique key in the table
|
|
DOC_ID
|
Varchar - 64
|
Contains the unique ID of the document that this publication is created from
|
...
|
|
EFFECTIVE
|
Bit
|
Is set if the publication is the effective version
|
Can be used to select only effective or non-effective publications
|
|
AUDIENCE
|
Varchar - 32
|
Contains the intended audience for this publication
|
Can be used to select publications for specific audiences
|
|
PUB_ID
|
Varchar - 64
|
Contains an internal ID for this publication.
|
This value is set and controlled by the internal Hyper.Net bookkeeping.
|
|
PUB_CATEGORY
|
Varchar - 254
|
Contains the category for this publication
|
Either specified in the Document Type Profile (See HNMI_MAIN Table) or through fieldmapping from the source file document profile.
Can be used to select publications in specific categories.
|
|
PUB_TITLE
|
Varchar - 254
|
Holds the title of this publication
|
Can be set manually, through fieldmapping or automatically by Hyper.Net
|
|
DOCUMENT_TITLE
|
Varchar - 254
|
Contains the Document Title of this publication
|
Can be set manually, through fieldmapping or automatically by Hyper.Net
|
|
VERSION
|
Bigint - 8
|
Contains the internal version number of this publication
|
This contains the internal version number of the publication. This version number is set by the internal Hyper.Net bookkeeping.
|
|
FOLDER_PATH
|
Varchar - 254
|
Contains the path of the folder where the source document for this publication was stored
|
...
|
|
[LANGUAGE]
|
Varchar - 128
|
Contains any Language code
|
Can be used to set language for each publication and sort publications on the front-end.
|
|
COMMENT
|
Ntext - 16
|
Contains any comment supplied by the author at check-in time of the source document
|
Can be shown on the front-end if it contains valuable information about this specific publication
|
|
LAST_MOD_DATE
|
Datetime - 8
|
Shows the last modification date of the source of this publication
|
Can be used to order publications by date, or only show publications older or younger than a specific date
|
|
LAST_MOD_BY
|
Varchar - 64
|
Shows who last modified the source of this publication
|
Can be used to view publications by author
|
|
LAST_APPROVAL_DATE
|
Datetime - 8
|
Shows the date the latest version of the publication was approved for publication (if approval workflows are used)
|
Can be used to select publications only approved before or after a certain date
|
|
LAST_APPROVER
|
Varchar - 64
|
Shows the latest approver of the publication
|
Can be used to show publications by approver
|
|
URL_MASTERINDEX
|
Varchar - 254
|
Contains the URL of the master index
|
Is used in computing links for administrators from the front-end to the master index
|
|
URL_DMS
|
Varchar - 254
|
Contains the URL of the DMS
|
Is used in computing links for administrators from the master index or front-end to the DMS
|
|
PUBLICATION_DATE
|
Datetime - 8
|
Contains the date of publication for this source file
|
Can be used to sort publications by date - show publications younger than or older than a specific date etc.
|
|
EFFECTIVE_DATE
|
Datetime - 8
|
Contains the date this version becomes effective (if effective version management is used)
|
Can be used to select publications with an effective date younger than today's date, thus showing "coming versions" of documents.
|
|
EXPIRATION_DATE
|
Datetime - 8
|
Contains the expiration date of this publication
|
Is used by Hyper.Net to retract publications from websites - value can be set by e.g. metadata fieldmapping from check-in of source file
|
|
DOC_TYPE
|
Varchar - 64
|
Contains name of the document type used to create this publication
|
...
|
|
DISPLAY_VERSION
|
Varchar - 32
|
Contains the DMS version number
|
This value is the version number carried over from the document manager. This value should be used to show the actual version number of a source document.
|
|
FOLDER_ID
|
Varchar - 64
|
Contains the ID of the folder where the source document was stored in the document manager.
|
You can use this value to select and show documents that were stored in the same folder in the document manager.
|
|
NOTIFICATION_EMAIL_APP
|
Varchar - 254
|
Contains the email of the user to be notified when this publication publishes for approval
|
Can be used to personalize views for e.g. webmasters who have the task of approving the look-and-feel of the publication
|
|
NOTIFICATION_EMAIL_PROD
|
Varchar - 254
|
Contains the email of the user to be notified when this publication publishes for production
|
...
|
|
THPS_FORMAT
|
Varchar - 32
|
Contains the types of content created for this publication
|
Is usually Transformed; HTML; PDF. Can be used to select document where only a specific kind of content has been created.
|
|
PUB_APPROVED
|
Bit
|
Is set if this publication has been through the approval cycle in Hyper.Net
|
Can be used to create views of documents that have been through the approval cycle
|