Skip Headers

Oracle® Application Server Portal Developer's Guide 10g Release 3 (10.1.3) B25601-01 |
| Home | Solution Area | Contents | Index

Previous | Next |

# F Content Management APIs and Views

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

- Supported APIs

- Secure Views

## F.1 Supported APIs

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

For more information about the contents of the different packages, refer to the Oracle Application Server 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 OracleAS Metadata Repository. Use these APIs to:

- 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 OracleAS Metadata Repository. Use these APIs to:

- 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 OracleAS Portal security. Use these APIs for:

- 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 Application Server 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 OracleAS Metadata 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.

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.

If the WWSBR_USER_PAGES view does not exist in your portal schema, refer to the instructions on how to create it in Section 11.1.1, "Creating the WWSBR_USER_PAGES 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. |