Defines the template library for portal management
| Column Name | Column Datatype | Column Null Option | Column Comment |
| portal_template_id | varchar(50) | not null | Portal Library Unique ID |
| portal_template_parent_id | varchar(50) | with null | Parent portal ID |
| name | nvarchar(64) | with null | Template name |
| description | nvarchar(128) | with null | Template description |
| is_system | integer | with null | Specifies if this is a system specific entity |
| content_type | integer | with null | Plugin method type |
| content_url | nvarchar(256) | with null | The url for the content display |
| embedded_content | long varchar | with null | Embedded content if it is used |
| criteria | varchar(256) | with null | The special criteria for the portal template |
| parse_content | integer | with null | Flag to indicate if parsing is required |
| tag_name | varchar(64) | with null | The tag name for displaying the content |
| xsl_url | varchar(256) | with null | The relative location for the XSL |
| guinode_id | varchar(128) | with null | guinode ID which is related to the template |
| params | varchar(64) | with null | Arguments which will be passed |
| embedded_xsl | long varchar | with null | Embedded xsl code |
| status | integer | with null | status of the template, Eg: 1 |
| expire_date | date | with null | Expiration date |
| created_date | date | not null | Creation date |
| modified_date | date | with null | Modified date |
| user_id | nvarchar(100) | with null | User who created the template |
| icon_used | varchar(256) | with null | Used icon name and location |
| keywords | nvarchar(64) | with null | Keywords for the portal template |
| tenant_id | varchar(50) | with null | Tenant ID is related to the template |
| parent_tenant_id | varchar(50) | with null | Parent tenant ID is related to the tenant |
| asset_id | varchar(50) | with null | Handle to the usm_asset |
| file_name | nvarchar(64) | with null | The file name for the portal template |
| authentication_url | varchar(256) | with null | The url for the external authentication |
| credentials | varchar(256) | with null | Any credentials/password that is required to display the contents |
| label | integer | with null | Label for the template |
| new_window | integer | with null | If a new window needs to be opened to show the contents |
| data1 | nvarchar(256) | with null | For integration |
| data2 | nvarchar(1024) | with null | For integration |
| data3 | nvarchar(1024) | with null | For integration |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| portal_template_id | usm_portal_content | portal_template_id |
| portal_template_id | usm_portal_template | portal_template_parent_id |