Holds common information for all assets and folders such as resource path and parentdbid.
| 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 | Column not used |
| uemodtime | date | with null | Last time the resource was last saved or updated |
| uenumemptyrequired | integer | with null | Left over from legacy code |
| ueporinstanceid | varchar(255) | with null | Portal instance id |
| uepubstage | integer | with null | Left over from legacy code |
| uepubtime | date | with null | Left over from legacy code |
| ueactivation | date | with null | The time which this asset is activated |
| ueccitemfieldname | varchar(255) | with null | Legacy field |
| ueccitemid | integer | with null | ID of the resource this row is referencing |
| ueccitemtablename | varchar(255) | with null | Name of the table that contains the item being referenced |
| ueexpiration | date | with null | The time which this asset should be expired |
| ueexpstatus | integer | with null | The expiration status of this asset |
| uelastexpnotificat | date | with null | |
| ueowner | nvarchar(255) | with null | Asset owner |
| ueparentpath | nvarchar(255) | with null | Path of the items parent |
| ueresourcename | nvarchar(255) | with null | Name of the resource |
| ueresourcenameup | nvarchar(255) | with null | Upper case of resource name |
| ueresourcetitle | nvarchar(255) | with null | Title of the resource |
| uelastexpnotification | date | with null | The time which last notification is sent |
| ueresourcetitleup | nvarchar(255) | with null | Upper case of title |
Product Name: Portal r12 Content Management
Table Type: Table