E 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

E.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.

E.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.

E.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.

E.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).

E.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.

E.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.

E.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 E-1 lists the currently supported views:

Table E-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.

E.2.1 WWSBR_ALL_CATEGORIES

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

Table E-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.

E.2.2 WWSBR_ALL_CONTENT_AREAS

Table E-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 E-3 WWSBR_ALL_CONTENT_AREAS

Column	Null?	Data Type	Description
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.

E.2.3 WWSBR_ALL_FOLDER_REGIONS

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

Table E-4 WWSBR_ALL_FOLDER_REGIONS

Column	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

E.2.4 WWSBR_ALL_FOLDERS

Table E-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 E-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.

E.2.5 WWSBR_ALL_ITEMS

Table E-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 E-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.

E.2.6 WWSBR_ALL_NAVIGATION_BARS

Table E-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 E-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.

E.2.7 WWSBR_ALL_PERSPECTIVES

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

Table E-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.

E.2.8 WWSBR_ALL_STYLES

Table E-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 E-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.

E.2.9 WWSBR_APPROVER

Table E-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 E-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

E.2.10 WWSBR_ATTRIBUTES

Table E-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 E-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

E.2.11 WWSBR_CONTENT_AREA_APPROVAL

Table E-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 E-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

E.2.12 WWSBR_CONTENT_AREA_ITEM_TYPES

Table E-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 E-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

E.2.13 WWSBR_FOLDER_ATTRIBUTES

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

Table E-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.

E.2.14 WWSBR_FOLDER_PERSPECTIVES

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

Table E-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

E.2.15 WWSBR_FOLDER_TYPE_ATTRIBUTES

Table E-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 E-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.

E.2.16 WWSBR_FOLDER_TYPES

Table E-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 E-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.

E.2.17 WWSBR_ITEM_APPROVAL

Table E-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 E-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.

E.2.18 WWSBR_ITEM_ATTRIBUTES

Table E-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 E-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.

E.2.19 WWSBR_ITEM_PERSPECTIVES

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

Table E-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

E.2.20 WWSBR_ITEM_TYPE_ATTRIBUTES

Table E-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 E-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.

E.2.21 WWSBR_ITEM_TYPES

Table E-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 E-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.

E.2.22 WWSBR_SUBSCRIPTION

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

Table E-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.

E.2.23 WWSBR_USER_FOLDERS

Table E-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 E-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.

E.2.24 WWSBR_USER_PAGES

Table E-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 E-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.