Stores AIFF 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 |
| ueaiff_author | varchar(255) | with null | Author information extracted from documen |
| ueaiff_description | varchar(1000) | with null | Description information extracted from document |
| ueaiff_keywords | varchar(255) | with null | Keyword information extracted from document |
| ueaiff_title | varchar(255) | with null | Title information extracted from document |
| ueauthor | varchar(255) | with null | Author - entered by end user |
| uebyte_count | integer | with null | Byte count of resource |
| uechannel_mode | varchar(255) | with null | Extracted property |
| uecompression_type | varchar(255) | with null | Extracted property |
| uecopyrighted | varchar(255) | with null | Extracted property |
| uecreated_by | varchar(255) | with null | Name of user that created the resource |
| uecreation_date | date | with null | Date the resource was added to the system |
| uedate_expires | date | with null | Not used |
| uedescription | varchar(1000) | with null | Description - entered by end user |
| uekeywords | varchar(255) | with null | Keywords - entered by end user |
| uelast_modified_by | varchar(255) | with null | User who last modified the resource |
| uelength | float | with null | Extracted property |
| uemajor_type | varchar(255) | with null | Major type |
| ueminor_type | varchar(255) | with null | Minor type |
| uename | varchar(255) | with null | Filename of the resource |
| ueparentid | integer | with null | DBID of the item's parent |
| uesample_frames | integer | with null | Extracted property |
| uesample_rate | float | with null | Extracted property |
| uesample_size | integer | with null | Extracted property |
| uesubject | varchar(255) | with null | Subject - entered by end user |
| uetitle | varchar(255) | with null | Title - entered by end user |
| uevercomment | varchar(1000) | with null | Comment entered when this version of the resource was created |
| ueworkflow_id | integer | with null | ID of the workflow process associated with this resource |
Product Name: Portal Content Management
Table Type: Table