PSM_Asset (ver6.0.0)
This table provides a reference to a managed asset. In the context of custom pages an asset represents a page customized or created by the user. Examples include images, css, javascript or other web content. Assets are organized in a virtual folder hierarchy stored in PSM_AssetFolder.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
AssetFolder_ID | 6.0.0 | Number(19,0) | Internal number for the associated PSM_AssetFolder record. Required. |
Created_by | 6.0.0 | Varchar2(64) | PSM_Account.Username of the person creating the record. Required. |
Created_TS | 6.0.0 | Date | Date and time the record was created. Defaults to system date. Required. |
ID | 6.0.0 | Number(19,0) | Unique sequential number generated by the application. Required. |
Is_Binary | 6.0.0 | Number(1,0) | 1 Indicates the associated PSM_AssetContent and PSM_AssetContentArchive records are of type BLOB. Required. |
LastModified_By | 6.0.0 | Varchar2(64) | PSM_Account.Username of the person updating the record. Required. |
LastModified_TS | 6.0.0 | Date | Date and time the record was modified. Defaults to system date. Required. |
Mime_Type | 6.0.0 | Varchar2(50) | Currently not used. |
Name | 6.0.0 | Varchar2(25) | Name of the asset. If modifying a PowerSchool published custom page, the name remains the same. Required. |