F Content Management APIs and Views

This appendix lists the supported Oracle Portal content management APIs and views. It contains the following sections:

F.1 Supported APIs

This section provides an overview of the APIs available to you for performing content management tasks.

More on OTN

For more information about the contents of the different packages, refer to the Oracle Portal PL/SQL API Reference on Portal Center:

http://portalcenter.oracle.com

In the Portal Focus Areas section, click Portlet Development, then in the APIs and References section, click PL/SQL API Reference.

F.1.1 The WWSBR_API Package

This package contains APIs for accessing and manipulating the contents in the portal schema of the MDS Repository. You can perform the following actions using these APIs:

  • Create, edit, and delete portal objects, such as pages, categories, and items.

  • Copy and move items and pages.

  • Check items in and out.

  • Approve or reject pending items.

F.1.2 The WWSRC_API Package

This package contains APIs for searching content in the MDS Repository. You can perform the following actions using these APIs:

  • Search for items, pages, categories, and perspectives.

  • Filter search results based on specific attribute values.

  • Return search results as an XML document.

F.1.3 The WWSEC_API Package

This package contains APIs for administering Oracle Portal security. You can perform the following actions using these APIs:

  • User maintenance (create user profile entries, activate portal access, update user properties, delete user profile entries, and other associated tasks).

  • Group maintenance (create, activate, update, delete groups, and other associated tasks).

  • Access control (grant, check, copy, update, remove user/group privileges, and other associated tasks).

F.1.4 The WWCTX_API Package

This package contains APIs for enabling access to a session context. These APIs provide the methods necessary to manage a session context for a specific user.

A session is established when a user accesses the portal. A public session is created upon initial access. It is converted to an authenticated session after the user logs in and exists until the user logs out. Old sessions are also periodically cleaned up by the portal.

F.1.5 The WWPRO_API_INVALIDATION Package

This package contains APIs for invalidating content cached in the Oracle Web Cache. Use these APIs when your code causes content to change to make sure that those changes are immediately visible to users. For example, you may need to call an API to invalidate the cache in code that adds an item to a page.

F.2 Secure Views

The views in wwsbr_api_views enable you to safely build custom queries against the portal schema of the MDS Repository, without having to worry about the definitions changing between releases. Table F-1 lists the currently supported views:

Table F-1 Secure Content Repository Views

View Description

WWSBR_ALL_CATEGORIES

Describes all categories.

WWSBR_ALL_CONTENT_AREAS

Describes all page groups.

WWSBR_ALL_FOLDER_REGIONS

Describes all page regions on pages that the current user is able to view.

WWSBR_ALL_FOLDERS

Describes pages on which the current user has View privileges or higher.

WWSBR_ALL_ITEMS

Describes the items that the current user is able to view.

WWSBR_ALL_NAVIGATION_BARS

Describes all navigation pages that the current user is able to view.

WWSBR_ALL_PERSPECTIVES

Describes all perspectives.

WWSBR_ALL_STYLES

Describes all styles.

WWSBR_APPROVER

Describes the approvers for every page group approval step.

WWSBR_ATTRIBUTES

Describes all attributes.

WWSBR_CONTENT_AREA_APPROVAL

Describes the approval definition for a page group.

WWSBR_CONTENT_AREA_ITEM_TYPES

Describes which item types are available to which page groups.

WWSBR_FOLDER_ATTRIBUTES

Describes the attributes associated with pages that the current user is able to view

WWSBR_FOLDER_PERSPECTIVES

Describes the perspectives associated with pages that the current user is able to view.

WWSBR_FOLDER_TYPE_ATTRIBUTES

Describes the attributes that are available within each page type.

WWSBR_FOLDER_TYPES

Describes all page types.

WWSBR_ITEM_APPROVAL

Describes item approval information for every item that goes through approval.

WWSBR_ITEM_ATTRIBUTES

Describes the attributes and attribute values associated with items that the current user is able to view.

WWSBR_ITEM_PERSPECTIVES

Describes the perspectives associated with items that the current user is able to view.

WWSBR_ITEM_TYPE_ATTRIBUTES

Describes the attributes that are available within each item type.

WWSBR_ITEM_TYPES

Describes all item types.

WWSBR_SUBSCRIPTION

Describes user subscription to portal pages and items.

WWSBR_USER_FOLDERS

Describes pages on which the current user has Manage privileges or higher.

WWSBR_USER_PAGES

Describes pages on which the current user has Manage privileges or higher.


Note:

In the following tables, an asterisk (*) indicates that the column is part of the view's primary key.

F.2.1 WWSBR_ALL_CATEGORIES

Table F-2 lists the columns in the WWSBR_ALL_CATEGORIES view, which describes all categories.

Table F-2 WWSBR_ALL_CATEGORIES

Column Null? Data Type Description Notes

ID*

NOT NULL

NUMBER

ID of the category.

 

CAID*

NOT NULL

NUMBER

Page group ID for the category.

Foreign key to WWSBR_ALL_CONTENT_AREAS.ID

PARENTID

 

NUMBER

ID of the parent category.

0 (zero) if the category has no parent.

LANGUAGE*

NOT NULL

VARCHAR2(30)

Language code.

 

NAME

 

VARCHAR2(60)

Internal name of the category. Unique within parent category.

 

DISPLAY_NAME

NOT NULL

VARCHAR2(240)

Display name, or title, of the category.

 

F.2.2 WWSBR_ALL_CONTENT_AREAS

Table F-3 lists the columns in the WWSBR_ALL_CONTENT_AREAS view, which describes all page groups. This view shows all page groups in the repository, regardless of the current user's privileges.

Note:

An alternative way of uniquely identifying a row in this view is to use the NAME and LANGUAGE columns.

Table F-3 WWSBR_ALL_CONTENT_AREAS

Column Null? Data Type Description Notes

ID*

NOT NULL

NUMBER

ID of the page group.

 

LANGUAGE*

NOT NULL

VARCHAR2(30)

Language code.

 

NAME

NOT NULL

VARCHAR2(60)

Internal name of the page group.

 

DISPLAY_NAME

 

VARCHAR2(256)

Display name, or title, of the page group.

 

DEFAULT_LANGUAGE

NOT NULL

VARCHAR2(30)

Language code for the default language of the page group.

 

F.2.3 WWSBR_ALL_FOLDER_REGIONS

Table F-4 lists the columns in the WWSBR_ALL_FOLDER_REGIONS view, which describes all page regions on pages viewable by the current user.

Table F-4 WWSBR_ALL_FOLDER_REGIONS

Column Null? Data Type Description Notes

ID*

 

NUMBER(38)

ID of the region.

 

DISPLAY_NAME*

 

VARCHAR2(4000)

Display name, or title, of the region.

 

LANGUAGE

 

VARCHAR(7)

Language code.

 

FOLDER_ID

 

NUMBER(38)

ID of the page containing the region.

Foreign key to:

  • WWSBR_ALL_FOLDERS.ID

  • WSBR_USER_FOLDERS.ID

FOLDER_CAID

 

NUMBER(38)

Page group ID for the page containing the region.

Foreign key to:

  • WWSBR_ALL_FOLDERS.CAID

  • WWSBR_USER_FOLDERS.CAID

PARENT_ID

 

NUMBER(38)

ID of the parent region, if the region is nested.

 

TYPE

 

VARCHAR2(30)

The region type.

Valid values:

  • NONE - undefined

  • TAB - tab region

  • SUBPAGE - sub page region

  • ITEM - item region

  • PORTLET - portlet region

SEQ

 

NUMBER

Sequence of a region within the parent region.

 

ALLOW_CONTENT

 

NUMBER

Indicates if the region allows content to be added.

Valid values:

  • 0 - does not allow content to be added

  • 1 - allows content to be added


F.2.4 WWSBR_ALL_FOLDERS

Table F-5 lists the columns in the WWSBR_ALL_FOLDERS view, which describes the pages on which the current user has View privileges or higher.

Table F-5 WWSBR_ALL_FOLDERS

Column Null? Data Type Description Notes

ID*

NOT NULL

NUMBER

Unique identifier of the page within the page group.

 

CAID*

NOT NULL

NUMBER

ID of the page group.

Foreign key to WWSBR_ALL_CONTENT_AREAS.ID

LANGUAGE*

NOT NULL

VARCHAR2(30)

Language code.

 

PARENT_ID

 

NUMBER

ID of the parent page.

0 (zero) if root page of the page group.

NAME

NOT NULL

VARCHAR2(60)

Internal name of the page.

Must be unique within the parent page.

DISPLAY_NAME

NOT NULL

VARCHAR2(256)

Display name, or title, of the page.

 

CATEGORY_ID

 

NUMBER

ID of the category assigned to the page.

Foreign key to WWSBR_ALL_CATEGORIES.ID

CATEGORY_SITEID

 

NUMBER

Page group ID for the category assigned to the page.

Foreign key to WWSBR_ALL_CATEGORIES.CAID

DESCRIPTION

 

VARCHAR2(2000)

Description of the page.

 

TYPE_ID

NOT NULL

NUMBER

ID of the page type.

Foreign key to WWSBR_FOLDER_TYPES.ID

TYPE_SITEID

NOT NULL

NUMBER

Page group ID for the page type.

Foreign key to WWSBR_FOLDER_TYPES.CAID

BASE_TYPE_ID

NOT NULL

NUMBER

The ID of the page base type

Foreign key to WWSBR_FOLDER_TYPES.ID where WWSBR_FOLDER_TYPES.IS_BASE_FOLDER_TYPE=1

IS_PORTLET

NOT NULL

NUMBER(1)

Indicates if the page is published as a portlet.

Valid values:

  • 0 - not a portlet

  • 1 - is a portlet

IS_CACHING_ON

 

VARCHAR2

DEPRECATED. This column is retained for backward compatibility only.

 

CACHE_MODE

 

NUMBER(1)

The caching mode for the page.

Valid values:

  • 2 - no caching

  • 1 - cache page definition only

  • 0 - cache page definition and content for x minutes

  • 4 - cache page definition only at system level

  • 3 - cache page definition and content at system level for x minutes

SUB_FOLDER_SEQUENCE

 

NUMBER

The sequence (order) of the page in its parent page's sub-page region.

 

DISPLAY_IN_PARENT_FOLDER

NOT NULL

NUMBER(1)

Indicates if the page is displayed in its parent page's sub page region.

 

ITEMVERSIONING

 

VARCHAR2(30)

Determines the level of item versioning for the page.

Valid values:

  • versionnone - no versioning

  • versionsimple - simple versioning

  • versionaudit - audit versioning.

STYLE_ID

NOT NULL

NUMBER

ID for the style used by the page.

Foreign key to WWSBR_ALL_STYLES.ID

STYLE_CAID

NOT NULL

NUMBER

Page group ID for the style used by the page.

Foreign key to WWSBR_ALL_STYLES.CAID

URL_VALUE

 

VARCHAR2(4000)

URL value for a URL type page.

 

SEARCH_VALUE

 

VARCHAR2(2000)

DEPRECATED. This column is retained for backward compatibility only.

 

PLSQL_VALUE

 

VARCHAR2(2000)

PL/SQL value for a PL/SQL page.

 

IMAGE

 

VARCHAR2(350)

Unique name of the image associated with the page.

Matches the NAME column in the document table.

TITLE_IMAGE_NAME

 

VARCHAR2

DEPRECATED. This column is retained for backward compatibility only.

 

ROLLOVER_IMAGE_NAME

 

VARCHAR2(350)

The unique name of the rollover image associated with the page.

Matches the NAME column in the document table.

BANNER_IMAGE_NAME

 

VARCHAR2

DEPRECATED. This column is retained for backward compatibility only.

 

NAVIGATION_BAR_ID

 

VARCHAR2

DEPRECATED. This column is retained for backward compatibility only.

 

NAVIGATION_BAR_CAID

 

VARCHAR2

DEPRECATED. This column is retained for backward compatibility only.

 

IS_PUBLIC

NOT NULL

NUMBER(1)

Indicates that the page is viewable by public users.

Valid values:

  • 0 - not public

  • 1 - is public

ITEM_LEVEL_SECURITY

NOT NULL

NUMBER(1)

Indicates that item level security is enabled for the page.

Valid values:

  • 0 - ILS disabled

  • 1 - ILS enabled

DISPLAY_FULL_SCREEN

 

VARCHAR2

DEPRECATED. This column is retained for backward compatibility only.

 

PLSQL_FOLDER_EXECUTOR

 

VARCHAR2(30)

For PL/SQL type pages, the database schema used to execute the PL/SQL code.

 

CREATEDATE

 

DATE

Date the page was created.

 

CREATOR

 

VARCHAR2(256)

User name of the person who created the page.

 

UPDATEDATE

 

DATE

Date the page was last updated.

 

UPDATOR

 

VARCHAR2(256)

User name of the person who last updated the page.

 

F.2.5 WWSBR_ALL_ITEMS

Table F-6 lists the columns in the WWSBR_ALL_ITEMS view, which describes the items viewable by the current user.

For an example of how to use this view, refer to Section 10.3.4, "Finding an Item ID".

Table F-6 WWSBR_ALL_ITEMS

Column Null? Data Type Description Notes

MASTERID

NOT NULL

NUMBER

Master ID of the item.

All versions and translations of an item have the same master ID.

ID*

NOT NULL

NUMBER

ID of the item.

Each version of an item receives a new ID. If translations and approvals are enabled, multiple rows may exist for the same ID.

CAID*

NOT NULL

NUMBER

Page group ID for the item.

Foreign key to:

  • WWSBR_ALL_FOLDERS.CAID

  • WWSBR_USER_FOLDERS.CAID

  • WWSBR_ALL_CONTENT_AREAS.ID

LANGUAGE*

NOT NULL

VARCHAR2(30)

Language code.

 

IS_CURRENT_VERSION*

NOT NULL

NUMBER(1)

Indicates that the item is the current version.

Valid values:

  • 0 - not current version

  • 1 - is current version

FOLDER_ID

NOT NULL

NUMBER

ID of the page containing the item.

Foreign key to:

  • WWSBR_ALL_FOLDERS.ID

  • WWSBR_USER_FOLDERS.ID

  • WWSBR_ALL_FOLDER_REGIONS.FOLDER_ID

FOLDER_REGION_ID

NOT NULL

NUMBER

ID of the region containing the item.

Foreign key to WWSBR_ALL_FOLDER_REGIONS.ID

NAME

NOT NULL

VARCHAR2(256)

Internal name of the item.

The name is a system generated GUID value that can be used as an alternate ID. The name is also used in path based URLs.

DISPLAY_NAME

 

VARCHAR2(256)

Display name, or title, of the item.

 

ITEMTYPE

NOT NULL

VARCHAR2(30)

The base item type, for example, BASEFILE, BASETEXT, BASEURL, and so on.

 

SUBTYPE

 

VARCHAR2(40)

ID of the item type.

Foreign key to WWSBR_ITEM_TYPES.ID

SUBTYPE_CAID

 

NUMBER

Page group ID of the item type.

Foreign key to WWSBR_ITEM_TYPES.CAID

PARENT_ITEM_ID

 

NUMBER

ID of the parent item, if the item is a sub item.

0 (zero) if the item is not a sub item.

CATEGORY_ID

 

NUMBER

ID for the category assigned to the item.

Foreign key to WWSBR_ALL_CATEGORIES.ID

CATEGORY_CAID

 

NUMBER

page group ID for the category assigned to the item.

Foreign key to WWSBR_ALL_CATEGORIES.CAID

AUTHOR

 

VARCHAR2(50)

Author of the item.

 

DESCRIPTION

 

VARCHAR2(2000)

Description of the item.

 

PUBLISH_DATE

NOT NULL

DATE

Date the item will be published.

 

EXPIREMODE

 

VARCHAR2(90)

Expiration mode for the item.

Valid values:

  • 'PERMANENT' - item never expires

  • 'NUMBER' - item expires in EXPIRENUMBER days from CREATEDATE

  • 'DATE' - item expires on EXPIREDATE

EXPIRENUMBER

 

NUMBER

Number of days after CREATEDATE when item will expire.

Only valid when EXPIREMODE = 'NUMBER'.

EXPIREDATE

 

DATE

Date when item will expire.

Only valid when EXPIREMODE = 'DATE'.

IMAGE

 

VARCHAR2(350)

Image associated with the item.

This value may be a reference (for example, a path to an image stored on the file system or in the content repository) or a unique document name that matches the NAME column in the document table.

KEYWORDS

 

VARCHAR2(2000)

Keywords for the item.

 

URL

 

VARCHAR2(4000)

URL for a URL type item.

 

FILENAME

 

VARCHAR2(350)

Unique name of the file associated with a file type item.

Matches the NAME column in the document table.

TEXT

 

CLOB

Text for a text type item.

 

FOLDER_LINK_ID

 

NUMBER

Page ID for a page link type item

Foreign key to:

  • WWSBR_ALL_FOLDERS.ID

  • WWSBR_USER_FOLDERS.ID

FOLDER_LINK_CAID

 

NUMBER

Page group ID for a page link type item.

Foreign key to:

  • WWSBR_ALL_FOLDERS.CAID

  • WWSBR_USER_FOLDERS.CAID

ACTIVE*

NOT NULL

NUMBER(1)

Indicates the active status of the item.

Valid values:

  • 1 - active

  • 2 - pending approval as new and current version

  • 3 - pending approval as new but not current version

  • 0 - pending approval

  • -1 - deleted

  • -7 - rejected

  • -9 - reject deleted

CAN_BE_CHECKEDOUT

 

NUMBER(1)

Indicates if the item can be checked out.

Valid values:

  • 0 - cannot be checked out

  • 1 - can be checked out

IS_ITEM_CHECKEDOUT

 

NUMBER(1)

Indicates if the item is checked out.

Valid values:

  • 0 - item is not checked out

  • 1 - item is checked out

CHECKER_USERNAME

 

VARCHAR2(256)

User name of the user who checked out the item.

 

CHECKOUT_DATE

 

DATE

Date the item was checked out.

 

FULLSCREEN

NOT NULL

NUMBER(1)

Indicates the rendering behavior for an item shown as a link.

Valid values:

  • 0 - clicking the link displays the item in a new browser window

  • 1 - clicking the link displays the item in the same browser window

INPLACE

NOT NULL

NUMBER(1)

Indicates the rendering behavior for a text or PL/SQL item.

Valid values:

  • 0 - a link to the item is displayed; the rendering behavior of the link depends on the value of the FULLSCREEN column

  • 1 - the item is rendered in-place in the region

CREATEDATE

NOT NULL

DATE

Date the item was created.

 

CREATOR

NOT NULL

VARCHAR2(256)

User name of the person who created the item.

 

UPDATEDATE

 

DATE

Date the item was last updated.

 

UPDATOR

 

VARCHAR2(256)

User name of the person who last updated the item.

 

SECURITY

 

VARCHAR2(25)

Indicates whether security has been set for the item.

Valid values:

  • item - ILS is enabled on the page and security is set at the item level

  • folder - security is set at the page level

VISIBLE

NOT NULL

NUMBER(1)

Indicates whether the item is hidden.

Valid values:

  • 0 - item is hidden

  • 1 - item is shown

SEQUENCE

NOT NULL

NUMBER

Regular sequence of the item if there is no grouping.

 

CATEGORY_SEQUENCE

NOT NULL

NUMBER

Sequence of the item when items are grouped by category.

 

AUTHOR_SEQUENCE

NOT NULL

NUMBER

Sequence of the item when items are grouped by author.

 

CREATE_DATE_SEQUENCE

NOT NULL

NUMBER

Sequence of the item when items are grouped by create date.

 

ITEMTYPE_SEQUENCE

NOT NULL

NUMBER

Sequence of the item when items are grouped by item type.

 

F.2.6 WWSBR_ALL_NAVIGATION_BARS

Table F-7 lists the columns in the WWSBR_ALL_NAVIGATION_BARS view, which describes all navigation pages viewable by the current user.

Note:

An alternative way of uniquely identifying a row in this view is to use the NAME, CAID, and LANGUAGE columns.

Table F-7 WWSBR_ALL_NAVIGATION_BARS

Column Null? Data Type Description Notes

ID*

NOT NULL

NUMBER

ID of the navigation page.

 

CAID*

NOT NULL

NUMBER

Page group ID for the navigation page.

Foreign key to WWSBR_ALL_CONTENT_AREAS.ID

LANGUAGE*

NOT NULL

VARCHAR2(30)

Language code.

 

NAME

NOT NULL

VARCHAR2(60)

Internal name of the navigation page.

Unique within page group.

DISPLAY_NAME

NOT NULL

VARCHAR2(256)

Display name, or title, of the navigation page.

 

STYLE_ID

NOT NULL

NUMBER

ID for the style used by the navigation page.

Foreign key to WWSBR_ALL_STYLES.ID

STYLE_CAID

NOT NULL

NUMBER

Page group ID for the style used by the navigation page.

Foreign key to WWSBR_ALL_STYLES.CAID

IS_PORTLET

NOT NULL

NUMBER(1)

Indicates if the page is published as a portlet.

Valid values:

  • 0 - not a portlet

  • 1 - is a portlet

ALIGNMENT

 

VARCHAR2

DEPRECATED. This column is retained for backward compatibility.

 

F.2.7 WWSBR_ALL_PERSPECTIVES

Table F-8 lists the columns in the WWSBR_ALL_PERSPECTIVES view, which describes all perspectives.

Table F-8 WWSBR_ALL_PERSPECTIVES

Column Null? Data Type Description Notes

ID*

NOT NULL

NUMBER

ID of the perspective.

 

CAID*

NOT NULL

NUMBER

Page group ID for the perspective.

Foreign key to WWSBR_ALL_CONTENT_AREAS.ID

PARENTID

 

NUMBER

ID of the parent perspective.

0 (zero) if the perspective has no parent

LANGUAGE*

NOT NULL

VARCHAR2(30)

Language code.

 

NAME

 

VARCHAR2(60)

Internal name of the perspective.

Unique within parent perspective.

DISPLAY_NAME

NOT NULL

VARCHAR2(240)

Display name, or title, of the perspective.

 

F.2.8 WWSBR_ALL_STYLES

Table F-9 lists the columns in the WWSBR_ALL_STYLES view, which describes all styles.

Note:

An alternative way of uniquely identifying a row in this view is to use the NAME, CAID, and LANGUAGE columns.

Table F-9 WWSBR_ALL_STYLES

Column Null? Data Type Description Notes

ID*

NOT NULL

NUMBER

ID of the style.

 

CAID*

NOT NULL

NUMBER

Page group ID for the style.

Foreign key to WWSBR_ALL_CONTENT_AREAS.ID

LANGUAGE*

NOT NULL

VARCHAR2(30)

Language code.

 

NAME

NOT NULL

VARCHAR2(65)

Internal name of the style.

Unique within the page group.

DISPLAY_NAME

 

VARCHAR2(350)

Display name, or title, of the style.

 

F.2.9 WWSBR_APPROVER

Table F-10 lists the columns in the WWSBR_APPROVER view, which describes the approvers for every page group approval step. The STEP_ID column corresponds to the STEP_ID column in the WWSBR_CONTENT_AREA_APPROVAL view. For every step, there could be one or more approvers. An approver can be a user or group and this information is stored in the APPROVER_TYPE column.

Table F-10 WWSBR_APPROVER

Column Null? Data Type Description Notes

ID

NOT NULL

NUMBER

Internal ID, unique to each row.

Foreign key to WWSBR_CONTENT_AREA_APPROVAL.ID

STEP_ID*

NOT NULL

NUMBER

Sequential step ID of an approval process.

 

APPROVER_ID*

NOT NULL

NUMBER

User ID of the approver.

 

APPROVER_TYPE*

NOT NULL

VARCHAR2(10)

The type of the approver.

Valid values:

  • USER - approver is a user

  • GROUP - approver is a group


F.2.10 WWSBR_ATTRIBUTES

Table F-11 lists the columns in the WWSBR_ATTRIBUTES view, which describes all attributes.

Note:

An alternative way of uniquely identifying a row in this view is to use the NAME, CAID, and LANGUAGE columns.

Table F-11 WWSBR_ATTRIBUTES

Column Null? Data Type Description Notes

ID*

NOT NULL

NUMBER

ID of the attribute.

 

CAID*

NOT NULL

NUMBER

Page group ID for the attribute.

Foreign key to WWSBR_ALL_CONTENT_AREAS.ID

LANGUAGE*

NOT NULL

VARCHAR2(30)

Language code.

 

NAME

NOT NULL

VARCHAR2(256)

Internal name of the attribute.

Functions as alternate key (unique within page group).

DISPLAY_NAME

 

VARCHAR2(256)

Display name, or title, of the attribute.

 

IS_BASE_ATTRIBUTE

NOT NULL

NUMBER(1)

Indicates that the attribute is a base attribute.

Valid values:

  • 0 - not a base attribute

  • 1 - is a base attribute

DATA_TYPE

NOT NULL

VARCHAR2(30)

Data type of the attribute.

 

LENGTH

 

NUMBER(5)

Length of the attribute.

 

IS_TRANSLATABLE

NOT NULL

NUBMER(1)

Indicates that the attribute is translatable, meaning that a different value can be stored for each translation. If the attribute is not translatable, the same value is stored for all translations.

Valid values:

  • 0 - not translatable

  • 1 - is translatable


F.2.11 WWSBR_CONTENT_AREA_APPROVAL

Table F-12 lists the columns in the WWSBR_CONTENT_AREA_APPROVAL view, which describes the approval definition for a page group or a page. For every approval definition there are x rows corresponding to the x steps defined in the approval process. To determine the approvers for each step, see the WWSBR_APPROVER view.

Table F-12 WWSBR_CONTENT_AREA_APPROVAL

Column Null? Data Type Description Notes

ID*

NOT NULL

NUMBER

ID of the approval process

 

STEP_ID

 

NUMBER

ID of the step in the approval process

 

CAID

NOT NULL

NUMBER

ID of the page group against which the approval process is defined.

 

FOLDER_ID

 

NUMBER

ID of the page against which the approval process is defined.

 

ALL_OR_ANY

 

VARCHAR2(10)

Indicates if all the approvers need to approve the item for it to be published, or just one.

Valid values:

  • ALL - all approvers must approve the item

  • ANY - only one approver needs to approve the item

PARALLEL_OR_SERIAL

 

VARCHAR2(10)

Indicates if all the approvers are notified at the same time, or one after the other.

Valid values:

  • P - all approvers are notified at the same time

  • S - approvers are notified one after the other


F.2.12 WWSBR_CONTENT_AREA_ITEM_TYPES

Table F-13 lists the columns in the WWSBR_CONTENT_AREA_ITEM_TYPES view, which describes which item types are available to which page groups. An item type cannot be assigned to an item unless the item type is available within the item's page group.

Table F-13 WWSBR_CONTENT_AREA_ITEM_TYPES

Column Null? Data Type Description Notes

CAID*

NOT NULL

NUMBER

ID of the page group.

Foreign key to WWSBR_ALL_CONTENT_AREAS.ID

ITEM_TYPE_ID*

NOT NULL

NUMBER

ID of the item type.

Foreign key to WWSBR_ITEM_TYPES.ID

ITEM_TYPE_CAID*

NOT NULL

NUMBER

Page group ID for the item type.

Foreign key to WWSBR_ITEM_TYPES.CAID


F.2.13 WWSBR_FOLDER_ATTRIBUTES

Table F-14 lists the columns in the WWSBR_FOLDER_ATTRIBUTES view, which describes the attributes associated with pages viewable by the current user.

Table F-14 WWSBR_FOLDER_ATTRIBUTES

Column Null? Data Type Description Notes

FOLDER_CAID*

NOT NULL

NUMBER

Page group ID of the page.

Foreign key to:

  • WWSBR_ALL_FOLDERS.CAID

  • WWSBR_USER_FOLDERS.CAID

FOLDER_ID*

NOT NULL

NUMBER

ID of the page.

Foreign key to:

  • WWSBR_ALL_FOLDERS.ID

  • WWSBR_USER_FOLDERS.ID

ATTRIBUTE_ID*

 

NUMBER

ID of the attribute.

Foreign key to WWSBR_ATTRIBUTES.ID

ATTRIBUTE_CAID*

 

NUMBER

Page group ID for the attribute.

Foreign key to WWSBR_ATTRIBUTES.CAID

LANGUAGE*

NOT NULL

VARCHAR2(30)

Language code.

Foreign key to:

  • WWSBR_ALL_FOLDERS.LANGUAGE

  • WWSBR_USER_FOLDERS.LANGUAGE

  • WWSBR_ATTRIBUTES.LANGUAGE

VALUETYPE

NOT NULL

VARCHAR2(30)

Data type of the attribute.

 

VALUE

 

VARCHAR2(2000)

Value of the attribute.

 

F.2.14 WWSBR_FOLDER_PERSPECTIVES

Table F-15 lists the columns in the WWSBR_FOLDER_PERSPECTIVES view, which describes the perspectives associated with pages viewable by the current user.

Table F-15 WWSBR_FOLDER_PERSPECTIVES

Column Null? Data Type Description Notes

FOLDER_CAID*

NOT NULL

NUMBER

ID of the page's page group.

Foreign key to:

  • WWSBR_ALL_FOLDERS.CAID

  • WWSBR_USER_FOLDERS.CAID

FOLDER_ID*

NOT NULL

NUMBER

Page group ID for the page.

Foreign key to:

  • WWSBR_ALL_FOLDERS.CAID

  • WWSBR_USER_FOLDERS.CAID

PERSPECTIVE_ID*

NOT NULL

NUMBER

ID of the perspective.

Foreign key to WWSBR_ALL_PERSPECTIVES.ID

PERSPECTIVE_CAID*

NOT NULL

NUMBER

Page group ID for the perspective.

Foreign key to WWSBR_ALL_PERSPECTIVES.CAID

PERSPECTIVE_NAME

 

VARCHAR2(60)

Internal name of the perspective.

Foreign key to WWSBR_ALL_PERSPECTIVES.NAME


F.2.15 WWSBR_FOLDER_TYPE_ATTRIBUTES

Table F-16 lists the columns in the WWSBR_FOLDER_TYPE_ATTRIBUTES view, which describes the attributes that are available within each page type.

Note:

An alternative way of uniquely identifying a row in this view is to use the FOLDER_TYPE_ID, FOLDER_TYPE_CAID, ATTRIBUTE_ID, and ATTRIBUTE_CAID columns.

Table F-16 WWSBR_FOLDER_TYPE_ATTRIBUTES

Column Null? Data Type Description Notes

ID*

NOT NULL

NUMBER

ID of the page type attribute row.

 

CAID*

NOT NULL

NUMBER

Page group ID.

Foreign key to WWSBR_ALL_CONTENT_AREAS.ID

LANGUAGE*

NOT NULL

VARCHAR2(30)

Language code.

 

FOLDER_TYPE_ID

NOT NULL

NUMBER

ID of the folder type.

Foreign key to WWSBR_FOLDER_TYPES.ID

FOLDER_TYPE_CAID

NOT NULL

NUMBER

Page group ID for the page type.

Foreign key to WWSBR_FOLDER_TYPES.CAID

ATTRIBUTE_ID

NOT NULL

NUMBER

ID of the attribute.

Foreign key to WWSBR_ATTRIBUTES.ID

ATTRIBUTE_CAID

NOT NULL

NUMBER

Page group ID for the attribute.

Foreign key to WWSBR_ATTRIBUTES.CAID

DEFAULT_VALUE

 

VARCHAR2(2000)

Default value of the attribute.

The default value is always stored as VARCHAR2, regardless of the attribute's base type.


F.2.16 WWSBR_FOLDER_TYPES

Table F-17 lists the columns in the WWSBR_FOLDER_TYPES view, which describes all page types.

Note:

An alternative way of uniquely identifying a row in this view is to use the NAME, CAID, and LANGUAGE columns.

Table F-17 WWSBR_FOLDER_TYPES

Column Null? Data Type Description Notes

ID*

NOT NULL

NUMBER

ID of the page type.

 

CAID*

NOT NULL

NUMBER

Page group ID for the page type.

Foreign key to WWSBR_ALL_CONTENT_AREAS.ID

LANGUAGE*

NOT NULL

VARCHAR2(30)

Language code.

 

NAME

 

VARCHAR2(30)

Internal name of the page type.

Functions as alternate key (unique within page group).

DISPLAY_NAME

 

VARCHAR2(256)

Display name, or title, of the page type.

 

DESCRIPTION

 

VARCHAR2(2000)

Description of the page type.

 

IS_BASE_FOLDER_TYPE

NOT NULL

NUMBER

Indicates that the item is a base page type.

Valid values:

  • 0 - not a base page type

  • 1 - is a base page type

BASE_FOLDER_TYPE_ID

 

NUMBER

ID of the base page type on which this page type is based.

 

F.2.17 WWSBR_ITEM_APPROVAL

Table F-18 lists the columns in the WWSBR_ITEM_APPROVAL view, which describes item approval information for every item that goes through approval. You can use this view to find information like:

  • Where is item x in the approval chain?

  • Who is currently reviewing item x?

  • Which approver rejected item x?

In addition to the information about pending items, you can also use this view to query details on approvals, including approval date, comments, approver, and so on.

Table F-18 WWSBR_ITEM_APPROVAL

Column Null? Data Type Description Notes

ID*

NOT NULL

NUMBER

Internal ID.

 

APPROVAL_INSTANCE_ID

NOT NULL

NUMBER

Internal ID.

 

ITEM_ID

NOT NULL

NUMBER

ID of the item pending approval.

 

CAID

NOT NULL

NUMBER

ID of the page group that contains the item pending approval.

 

LANGUAGE

NOT NULL

VARCHAR2(30)

Language code.

 

FOLDER_ID

 

NUMBER

ID of the page on which the item pending approval appears.

 

STEP_ID

 

NUMBER

ID of the step for which the item requires approval.

 

APPROVAL_ID

 

NUMBER

ID of the approval process for the item.

Foreign key to WWSBR_CONTENT_AREA_APPROVAL.ID

CURRENT_APPROVER_ID

NOT NULL

NUMBER

ID of the approver of the approval step.

For an ANY approval step this value will be the same for all rows of the approval step. For an ALL approval step this value will be the same as APPROVER_ID.

CURRENT_APPROVER_TYPE

 

VARCHAR2(10)

The type of the current approver.

Valid values:

  • USER - approver is a user

  • GROUP - approver is a group

APPROVAL_DATE

 

DATE

Date when the item was approved.

 

APPROVER_ID

 

NUMBER

ID of the approver.

Use wwsec_api.user_name to get the user name of the approver.

APPROVER_COMMENT

 

VARCHAR2(4000)

Comment specified at the time of approval or rejection.

 

STATUS

NOT NULL

NUMBER(1)

Status of the item.

Valid values:

  • 1 - active

  • 2 - pending approval as new and current version

  • 3 - pending approval as new but not current version

  • 9 - draft

  • 0 - pending approval

  • -1 - deleted

  • -7 - rejected

  • -9 - reject deleted

SUBMITTER

 

VARCHAR2(256)

ID of the user who submitted the item for approval.

 

VALUE1

 

VARCHAR2(256)

Not used.

 

F.2.18 WWSBR_ITEM_ATTRIBUTES

Table F-19 lists the columns in the WWSBR_ITEM_ATTRIBUTES view, which describes the attributes and attribute values associated with items viewable by the current user.

Table F-19 WWSBR_ITEM_ATTRIBUTES

Column Null? Data Type Description Notes

ITEM_CAID

NOT NULL

NUMBER

Page group ID for the item.

Foreign key to WWSBR_ALL_ITEMS.CAID

ITEM_MASTERID

NOT NULL

NUMBER

Master ID of the item.

Foreign key to WWSBR_ALL_ITEMS.MASTERID

ATTRIBUTE_ID

 

NUMBER

ID of the attribute.

Foreign key to WWSBR_ATTRIBUTES.ID

ATTRIBUTE_CAID

 

NUMBER

Page group ID for the attribute.

Foreign key to WWSBR_ATTRIBUTES.CAID

LANGUAGE

NOT NULL

VARCHAR2(30)

Language code.

Foreign key to WWSBR_ALL_ITEMS.LANGUAGE

VALUETYPE

NOT NULL

VARCHAR2(30)

Date type of the attribute.

 

VALUE

 

VARCHAR2(4000)

Value of the attribute.

 

F.2.19 WWSBR_ITEM_PERSPECTIVES

Table F-20 lists the columns in the WWSBR_ITEM_PERSPECTIVES view, which describes the perspectives associated with items viewable by the current user.

Table F-20 WWSBR_ITEM_PERSPECTIVES

Column Null? Data Type Description Notes

ITEM_CAID*

NOT NULL

NUMBER

Page group ID for the item.

Foreign key to WWSBR_ALL_ITEMS.CAID

ITEM_ID*

NOT NULL

NUMBER

ID of the item.

Foreign key to WWSBR_ALL_ITEMS.ID

ITEM_MASTERID*

 

NUMBER

Master ID of the item.

Foreign key to WWSBR_ALL_ITEMS.MASTERID

PERSPECTIVE_ID*

NOT NULL

NUMBER

ID of the perspective.

Foreign key to WWSBR_ALL_PERSPECTIVES.ID

PERSPECTIVE_CAID*

NOT NULL

NUMBER

Page group ID for the perspective.

Foreign key to WWSBR_ALL_PERSPECTIVES.CAID

PERSPECTIVE_NAME

 

VARCHAR2(60)

Internal name of the perspective.

Foreign key to WWSBR_ALL_PERSPECTIVES.NAME


F.2.20 WWSBR_ITEM_TYPE_ATTRIBUTES

Table F-21 lists the columns in the WWSBR_ITEM_TYPE_ATTRIBUTES view, which describes the attributes that are available within each item type.

Note:

An alternative way of uniquely identifying a row in this view is to use the ITEM_TYPE_ID, ITEM_TYPE_CAID, ATTRIBUTE_ID, and ATTRIBUTE_CAID columns.

Table F-21 WWSBR_ITEM_TYPE_ATTRIBUTES

Column Null? Data Type Description Notes

ID*

NOT NULL

NUMBER

ID of the item type attribute row.

 

CAID*

NOT NULL

NUMBER

Page group ID.

Foreign key to WWSBR_ALL_CONTENT_AREAS.ID

LANGUAGE*

NOT NULL

VARCHAR2(30)

Language code.

 

ITEM_TYPE_ID

NOT NULL

NUMBER

ID of the item type.

Foreign key to WWSBR_ITEM_TYPES.ID

ITEM_TYPE_CAID

NOT NULL

NUMBER

Page group ID for the item type.

Foreign key to WWSBR_ITEM_TYPES.CAID

ATTRIBUTE_ID

NOT NULL

NUMBER

ID of the attribute.

Foreign key to WWSBR_ATTRIBUTES.ID

ATTRIBUTE_CAID

NOT NULL

NUMBER

Page group ID for the attribute.

Foreign key to WWSBR_ATTRIBUTES.CAID

HIDDEN_ATTRIBUTE

NOT NULL

NUMBER(1)

Indicates if the attribute should be hidden.

This column is used for certain built-in item types and is not intended for customer use.

Value values:

  • 0 - is hidden

  • 1 - not hidden

DEFAULT_VALUE

 

VARCHAR2(2000)

Default value of the attribute.

The default value is always stored as VARCHAR2, regardless of the attribute's base type.


F.2.21 WWSBR_ITEM_TYPES

Table F-22 lists the columns in the WWSBR_ITEM_TYPES view, which describes all item types.

Note:

An alternative way of uniquely identifying a row in this view is to use the NAME, CAID, and LANGUAGE columns.

Table F-22 WWSBR_ITEM_TYPES

Column Null? Data Type Description Notes

ID*

NOT NULL

NUMBER

ID of the item type.

 

CAID*

NOT NULL

NUMBER

Page group ID for the item type.

Foreign key to WWSBR_ALL_CONTENT_AREAS.ID

LANGUAGE*

NOT NULL

VARCHAR2(30)

Language code.

 

NAME

 

VARCHAR2(30)

Internal name of the item type.

Functions as alternate key (unique within page group).

DISPLAY_NAME

 

VARCHAR2(256)

Display name, or title, of the item type.

 

DESCRIPTION

 

VARCHAR2(2000)

Description of the item type.

 

IS_BASE_ITEM_TYPE

NOT NULL

NUMBER

Indicates that the item is a base item type.

Only non-base item types can be assigned to items.

Valid values:

  • 0 - not a base item type

  • 1 - is a base item type

BASE_ITEM_TYPE_ID

 

NUMBER

ID of the base item type on which this item type is based.

 

F.2.22 WWSBR_SUBSCRIPTION

Table F-23 lists the columns in the WWSBR_SUBSCRIPTION view, which describes user subscription to portal pages and items.

Table F-23 WWSBR_SUBSCRIPTION

Column Null? Data Type Description Notes

ID*

NOT NULL

NUMBER

Internal ID.

 

OBJECT_CONTEXT_ID

NOT NULL

NUMBER

ID of the page group to which the subscribed object belongs.

 

FOLDER_ID

NOT NULL

NUMBER

ID of the page to which the subscribed object belongs.

 

OBJECT_ID

 

NUMBER

ID of the subscribed item.

In the case of a page subscription, this value is NULL.

GROUP_ID

 

NUMBER

Not used.

 

RECIPIENT_ID

NOT NULL

NUMBER

ID of the user or group who has subscribed to the object.

 

RECIPIENT_TYPE

 

VARCHAR2(10)

Not used.

 

F.2.23 WWSBR_USER_FOLDERS

Table F-24 lists the columns in the WWSBR_USER_FOLDERS view, which describes the pages on which the current user has Manage privileges or higher.

Table F-24 WWSBR_USER_FOLDERS

Column Null? Data Type Description Notes

ID*

NOT NULL

NUMBER

Unique identifier of the page within the page group.

 

CAID*

NOT NULL

NUMBER

ID of the page group.

Foreign key to WWSBR_ALL_CONTENT_AREAS.ID

LANGUAGE*

NOT NULL

VARCHAR2(30)

Language code.

 

PARENT_ID

 

NUMBER

ID of the parent page.

0 (zero) if root page of the page group.

NAME

NOT NULL

VARCHAR2(60)

Internal name of the page.

Must be unique within parent page.

DISPLAY_NAME

NOT NULL

VARCHAR2(256)

Display name, or title, of the page.

 

CATEGORY_ID

 

NUMBER

ID of the category assigned to the page.

Foreign key to WWSBR_ALL_CATEGORIES.ID

CATEGORY_CAID

 

NUMBER

Page group ID for the category assigned to the page.

Foreign key to WWSBR_ALL_CATEGORIES.CAID

DESCRIPTION

 

VARCHAR2(2000)

Description of the page.

 

TYPE_ID

NOT NULL

NUMBER

ID of the page type.

Foreign key to WWSBR_FOLDER_TYPES.ID

TYPE_CAID

NOT NULL

NUMBER

Page group ID for the page type.

Foreign key to WWSBR_FOLDER_TYPES.CAID

BASE_TYPE_ID

NOT NULL

NUMBER

The ID of the page base type

Foreign key to WWSBR_FOLDER_TYPES.ID where WWSBR_FOLDER_TYPES.IS_BASE_FOLDER_TYPE=1

IS_PORTLET

NOT NULL

NUMBER(1)

Indicates if the page is published as a portlet.

Valid values:

  • 0 - not a portlet

  • 1- is a portlet

IS_CACHING_ON

 

VARCHAR2

DEPRECATED. This column is retained for backward compatibility only.

 

CACHE_MODE

 

NUMBER(1)

The caching mode for the page.

Valid values:

  • 2 - no caching

  • 1 - cache page definition only

  • 0 - cache page definition and content for x minutes

  • 4 - cache page definition only at system level

  • 3 - cache page definition and content at system level for x minutes

SUB_FOLDER_SEQUENCE

 

NUMBER

The sequence (order) of the page in its parent page's sub-page region.

 

DISPLAY_IN_PARENT_FOLDER

NOT NULL

NUMBER(1)

Indicates if the page is displayed in its parent page's sub page region.

 

ITEMVERSIONING

 

VARCHAR2(30)

Determines the level of item versioning for the page.

Valid values:

  • versionnone - no versioning

  • versionsimple - simple versioning

  • versionaudit - audit versioning.

STYLE_ID

NOT NULL

NUMBER

ID for the style used by the page.

Foreign key to WWSBR_ALL_STYLES.ID

STYLE_CAID

NOT NULL

NUMBER

Page group ID for the style used by the page.

Foreign key to WWSBR_ALL_STYLES.CAID

URL_VALUE

 

VARCHAR2(4000)

URL value for a URL type page.

 

SEARCH_VALUE

 

VARCHAR2(2000)

DEPRECATED. This column is retained for backward compatibility only.

 

PLSQL_VALUE

 

VARCHAR2(2000)

PL/SQL value for a PL/SQL page.

 

IMAGE

 

VARCHAR2(350)

Unique name of the image associated with the page.

Matches the NAME column in the document table.

TITLE_IMAGE_NAME

 

VARCHAR2

DEPRECATED. This column is retained for backward compatibility only.

 

ROLLOVER_IMAGE_NAME

 

VARCHAR2(350)

The unique name of the rollover image associated with the page.

Matches the NAME column in the document table.

BANNER_IMAGE_NAME

 

VARCHAR2

DEPRECATED. This column is retained for backward compatibility only.

.

NAVIGATION_BAR_ID

 

VARCHAR2

DEPRECATED. This column is retained for backward compatibility only.

 

NAVIGATION_BAR_CAID

 

VARCHAR2

DEPRECATED. This column is retained for backward compatibility only.

 

IS_PUBLIC

NOT NULL

NUMBER(1)

Indicates that the page is viewable by public users.

Valid values:

  • 0 - not public

  • 1 - is public

ITEM_LEVEL_SECURITY

NOT NULL

NUMBER(1)

Indicates that item level security is enabled for the page.

Valid values:

  • 0 - ILS disabled

  • 1 - ILS enabled

DISPLAY_FULL_SCREEN

 

VARCHAR2

DEPRECATED. This column is retained for backward compatibility only.

 

PLSQL_FOLDER_EXECUTOR

 

VARCHAR2(30)

For PL/SQL type pages, the database schema used to execute the PL/SQL code.

 

CREATEDATE

 

DATE

Date the page was created.

 

CREATOR

 

VARCHAR2(256)

User name of the person who created the page.

 

UPDATEDATE

 

DATE

Date the page was last updated.

 

UPDATOR

 

VARCHAR2(256)

User name of the person who last updated the page.

 

F.2.24 WWSBR_USER_PAGES

Table F-25 lists the columns in the WWSBR_USER_PAGES view, which describes the pages on which the current user has Manage privileges or higher. This view is for use with the wwsbr_api.modify folder API and contains more columns that the WWSBR_USER_FOLDERS view.

Table F-25 WWSBR_USER_PAGES

Column Null? Data Type Description Notes

GUID

NOT NULL

RAW(32)

Globally unique ID of the page.

 

ID

NOT NULL

NUMBER

ID of the page.

 

SITEID

NOT NULL

NUMBER

Page group ID of the page.

 

LANGUAGE

NOT NULL

VARCHAR2(30)

Language code.

 

PARENTID

 

NUMBER

ID of the parent page.

 

NAME

NOT NULL

VARCHAR2(60)

Name of the page.

This name is used in path based URLs.

TITLE

NOT NULL

VARCHAR(256)

Display name, or title, of the page.

 

SETTINGSSETID

NOT NULL

NUMBER

ID of the style used by the page.

 

SETTINGSSETSITEID

NOT NULL

NUMBER

Page group ID of the style used by the page.

 

ISPUBLIC

NOT NULL

NUMBER(1)

Indicates that the page is viewable by public users.

Valid values:

  • 0 - not public

  • 1 - is public

IMAGE

 

VARCHAR2(350)

Unique document name of the image associated with the page, for example 6001.JPG.

 

ROLLOVERIMAGE

 

VARCHAR2(350)

Unique document name of the rollover image associated with the page, or the inactive tab image for the tab, for example 6001.JPG.

 

TITLEIMAGE

 

VARCHAR2(350)

Unique document name of the active tab image for the tab, for example 6001.JPG.

 

LEADER

 

VARCHAR2(256)

E-mail address of the page contact.

 

DESCRIPTION

 

VARCHAR2(2000)

Description of the page.

 

PRODUCTION

 

NUMBER(1)

Not used.

 

CREATEDATE

 

DATE

Date the page was created.

 

CREATOR

 

VARCHAR2((256)

User name of the person who created the page.

 

UPDATEDATE

 

DATE

Date the page was last updated.

 

UPDATOR

 

VARCHAR2(256)

User name of the person who last updated the page.

 

PUBLISHDATE

 

DATE

Not used.

 

ICON

 

VARCHAR2(256)

Not used.

 

CTXTXT

 

VARCHAR2(1)

Used internally by search.

 

HAVEITEMSECURITY

NOT NULL

NUMBER(1)

Indicates that item level security is enabled for the page.

Valid values:

  • 0 - ILS disabled

  • 1 - ILS enabled

ITEMVERSIONING

 

VARCHAR2(30)

Indicates the level of item versioning for the page.

Valid values:

  • versionnone - no versioning

  • versionsimple - simple versioning

  • versionaudit - audit versioning

TOPICID

 

NUMBER

ID of the category assigned to the page.

 

TOPIC_SITEID

 

NUMBER

Page group ID of the category assigned to the page.

 

VALUE

 

VARCHAR2(2000)

For PL/SQL pages, the PL/SQL code.

For JSP pages, the JSP source document name. Do not change this value for JSP pages.

 

TYPE

NOT NULL

NUMBER

ID of the page type for the page.

 

TYPE_SITEID

NOT NULL

NUMBER

Page group ID of the page type for the page.

 

BASE_TYPE

NOT NULL

NUMBER

ID of the base page type.

 

IS_PORTLET

NOT NULL

NUMBER(1)

Indicates if the page is published as a portlet.

Valid values:

  • 0 - not a portlet

  • 1 - is a portlet

QUOTA

 

VARCHAR2(5)

Not used.

 

SYSPRIV_NAME

NOT NULL

VARCHAR2(200)

The root page from which the page inherits access settings.

 

PLSQL_EXECUTOR

 

VARCHAR2(30)

For PL/SQL type pages, the database schema used to execute the PL/SQL code.

Valid values:

  • $PUBLIC$

  • $CREATOR$

  • <database user name>

KEYWORDS

 

VARCHAR2(2000)

Keywords for the page.

 

IS_READY

 

NUMBER(1)

Indicates that page creation is complete.

Valid values:

  • 1 - page creation is complete

INHERIT_PRIV

 

VARCHAR2(200)

The page from which this page inherits its privileges.

Use the following format:

<page group id>/<page id>

CACHE_MODE

 

NUMBER(1)

Caching mode for the page.

Valid values:

  • 2 - no caching

  • 1 - cache page definition only

  • 0 - cache page definition and content for x minutes

  • 4 - cache page definition only at system level

  • 3 - cache page definition and content at system level for x minutes

CACHE_EXPIRES

 

NUMBER(38)

Cache period in minutes.

 

TEMPLATE_ID

 

NUMBER(38)

ID of the template on which the page is based.

 

TEMPLATE_SITEID

 

NUMBER(38)

Page group ID of the template on which the page is based.

 

ALLOW_PAGE_STYLE

 

NUMBER(1)

For templates, indicates if pages can use a different style.

Valid values

  • 1 - allow pages to use different style.

ALLOW_PAGE_ACL

 

NUMBER(!)

For templates, indicates if pages have different access settings.

Valid values:

  • 1 - allow pages to have different access settings

DAV_ID

NOT NULL

VARCHAR2(60)

   

DAV_LOCK_TOKEN

 

VARCHAR2(36)

   

IS_TEMPLATE

NOT NULL

NUMBER(1)

Indicates that the page is a template.

Valid values:

  • 1 - is template

INIT_JSPFILE

 

VARCHAR2(256)

For JSP pages, initial JSP file if the JSP source of the page is a JAR or WAR file.

 

UI_TEMPLATE_ID

 

NUMBER(38)

ID of HTML page skin.

 

TEMPLATE_ISPUBLIC

NOT NULL

NUMBER(1)

Indicates if the template is ready to use.

Valid values:

  • 1 - template is ready to use

CONTAINER_ID

NOT NULL

NUMBER

ID of the container page.

 

DEFAULT_ITEM_REGION_ID

 

NUMBER

ID of the default item region for the page.

 

DEFAULT_PORTLET_REGION_ID

 

NUMBER

ID of the default portlet region for the page.

 

ITEMTYPE_INHERIT_FLAGS

 

NUMBER(1)

For WebDAV, indicates if default item types are inherited from parent page.

Valid values:

  • 7 - inherit all item types from parent page

  • 0 - specify all types on this page

REGFILE_ITEMTYPE

 

RAW(32)

For WebDAV, GUID of default item type for regular files.

 

ZIPFILE_ITEMTYPE

 

RAW(32)

For WebDAV, GUID of default item type for zip files.

 

IMAGEFILE_ITEMTYPE

 

RAW(32)

For WebDAV, GUID of default item type for image files.

 

DISPLAYINPARENT

NOT NULL

NUMBER(1)

Indicates if the page is displayed in its parent page's sub page region.

Valid values:

  • 1 - display page in parent's sub page region

SEQ

 

NUMBER

The sequence (order) of the page in its parent page's sub page region.

 

ALPHABETICAL_SORT

NOT NULL

NUMBER(1)

Indicates that sub pages are displayed in alphabetical order.

Valid values:

  • 1 - display sub pages in alphabetical order

IS_ITEM_PAGE

 

NUMBER(1)

Indicates that the template is for items (with item placeholder item)

Valid values:

  • 1 - is item template

ITEM_PAGE_ID

 

NUMBER(38)

ID of the item template.

 

ITEM_PAGE_SITE_ID

 

NUMBER(28)

Page group ID of the item template.

 

ITEM_PAGE_TABSTRING

 

VARCHAR2(512)

Tab strings of the item template.

Use the following format:

<tab name>:<sub tab name>:...:<sub tab name>

INHERIT_ITEM_PAGE

 

NUMBER(1)

For item template only, indicates that items inherit the parent page's item template.

Valid values:

  • 1 - inherit parent page's item template

ALLOW_ITEM_PAGE_OVERRIDE

 

NUMBER(1)

For item template only, indicates that items can have their own item template.

Valid values:

  • 1 - allow items on the page to have their own item template

HAS_INPLACE_ITEM

NOT NULL

NUMBER(1)

Indicates if the page or tab has a placeholder item.

Valid values:

  • 1 - has a placeholder item

TIMEOUT

 

NUMBER

Limit time, in seconds, used to fetch portlets.

 

LAST_ITEM_TEMPLATE_ASSIGNMENT

 

DATE

Set by trigger.