Stores AIFF content
| Column Name | Column Datatype | Column Null Option | Column Comment |
| uedbid | integer | not null | ID identifying this row |
| 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 |
| ueporinstanceid | varchar(255) | with null | Portal instance id which this row belongs to |
| uepubstage | integer | with null | Left over from legacy code |
| uepubtime | date | with null | Left over from legacy code |
| ueaiff_author | nvarchar(255) | with null | Author information extracted from documen |
| ueaiff_description | nvarchar(1000) | with null | Description information extracted from document |
| ueaiff_keywords | nvarchar(255) | with null | Keyword information extracted from document |
| ueaiff_title | nvarchar(255) | with null | Title information extracted from document |
| ueauthor | nvarchar(255) | with null | Author - entered by end user |
| uebyte_count | integer | with null | Byte count of resource |
| uechannel_mode | nvarchar(255) | with null | Extracted property |
| uecompression_type | nvarchar(255) | with null | Extracted property |
| uecopyrighted | nvarchar(255) | with null | Extracted property |
| uecreated_by | nvarchar(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 | nvarchar(1000) | with null | Description entered by end user |
| uekeywords | nvarchar(255) | with null | Keywords - entered by end user |
| uelast_modified_by | nvarchar(255) | with null | User who last modified the resource |
| uelength | float | with null | Extracted property |
| uemajor_type | nvarchar(255) | with null | Major type |
| ueminor_type | nvarchar(255) | with null | Minor type |
| uename | nvarchar(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 | nvarchar(255) | with null | Subject - entered by end user |
| uetitle | nvarchar(255) | with null | Title - entered by end user |
| uevercomment | nvarchar(1000) | with null | Comment entered when this version of the resource was created |
| uewfproc_id | varchar(255) | with null | ID of workflow process |
| ueworkflow_id | varchar(255) | with null | ID of the workflow process associated with this resource |
Product Name: Portal r12 Content Management
Table Type: Table