Stores avi content
| Column Name | Column Datatype | Column Null Option | Column Comment |
| uedbid | integer | not null | |
| uecheckedout | integer | with null | CPCM id of the user that has this resource checked out |
| uecheckedouttime | date | with null | Time the item was checked out |
| uemodtime | date | with null | Time the asset was last checked in |
| uenumemptyrequired | integer | with null | Left over from legacy code |
| uepubstage | integer | with null | Left over from legacy code |
| uepubtime | date | with null | Left over from legacy code |
| ueaudio_codec | varchar(255) | with null | Extracted property |
| ueauthor | varchar(255) | with null | Author - entered by end user |
| ueavi_author | varchar(255) | with null | Extracted property |
| ueavi_create_date | date | with null | Extracted property |
| ueavi_description | varchar(1000) | with null | Extracted property |
| ueavi_keywords | varchar(255) | with null | Extracted property |
| ueavi_subject | varchar(255) | with null | Extracted property |
| ueavi_title | varchar(255) | with null | Extracted property |
| uebitrate | float | with null | Extracted property |
| uebyte_count | integer | with null | Byte count |
| uechannel_mode | varchar(255) | with null | Extracted property |
| uecolor_depth | integer | with null | Extracted property |
| uecommissioned | varchar(255) | with null | Extracted property |
| uecopyrighted | varchar(255) | with null | Extracted property |
| uecreated_by | varchar(255) | with null | Name of the user that created the asset |
| uecreation_date | date | with null | Date the resource was added to the system |
| uecropped | varchar(255) | with null | Extracted property |
| uedate_expires | date | with null | Time the asset was last checked in |
| uedescription | varchar(1000) | with null | Description - entered by end user |
| uedimensions | integer | with null | Extracted property |
| uedots_per_inch | varchar(255) | with null | Extracted property |
| ueengineer | varchar(255) | with null | Extracted property |
| ueframe_number | integer | with null | Extracted property |
| ueframe_rate | integer | with null | Extracted property |
| uegenre | varchar(255) | with null | Extracted property |
| ueheight | integer | with null | Extracted property |
| uekeywords | varchar(255) | with null | Keywords - entered by end user |
| uelast_modified_by | varchar(255) | with null | Name of last user to modify the asset |
| uelength | float | with null | Extracted property |
| uelightness | varchar(255) | with null | Extracted property |
| uemajor_type | varchar(255) | with null | Major type |
| uemedium | varchar(255) | with null | Extracted property |
| ueminor_type | varchar(255) | with null | Minor type |
| uename | varchar(255) | with null | Filename |
| uename_of_subject | varchar(255) | with null | Extracted property |
| uepalette | varchar(255) | with null | Extracted property |
| ueparentid | integer | with null | DBID of parent object |
| ueproduct | varchar(255) | with null | Extracted property |
| uesample_rate | float | with null | Extracted property |
| uesample_size | integer | with null | Extracted property |
| uesharpness | varchar(255) | with null | Extracted property |
| uesoftware | varchar(255) | with null | Extracted property |
| uesource | varchar(255) | with null | Extracted property |
| uesubject | varchar(255) | with null | Subject - entered by end user |
| uetechnician | varchar(255) | with null | Extracted property |
| uetitle | varchar(255) | with null | Title of the asset - entered by end user |
| uevercomment | varchar(1000) | with null | Comment entered when this version of the resource was created |
| uevideo_codec | varchar(255) | with null | Extracted property |
| uewidth | integer | with null | Extracted property |
| ueworkflow_id | integer | with null | ID of the workflow process associated with this resource |
Product Name: Portal Content Management
Table Type: Table