This is the property template CleverPath Aion uses for all of its 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 | Identify the portal instance which this row belongs to |
| uepubstage | integer | with null | Left over from legacy code |
| uepubtime | date | with null | Left over from legacy code |
| ueauthor | nvarchar(255) | with null | Author - entered by end user |
| uebyte_count | integer | with null | Byte count |
| 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 |
| ueenddate | nvarchar(255) | with null | AION property |
| uekeywords | nvarchar(255) | with null | Keywords - entered by end user |
| uelast_modified_by | nvarchar(255) | with null | User who last modified the object |
| uemajor_type | nvarchar(255) | with null | Major type |
| ueminor_type | nvarchar(255) | with null | Minor type |
| uename | nvarchar(255) | with null | Name |
| ueparentid | integer | with null | DBID of the parent object |
| uepriority | nvarchar(255) | with null | AION property |
| uestartdate | nvarchar(255) | with null | AION property |
| uesubject | nvarchar(255) | with null | Subject - entered by end user |
| uetitle | nvarchar(255) | with null | Title - entered by end user |
| uetype | nvarchar(255) | with null | AION property |
| 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 id |
| ueworkflow_id | varchar(255) | with null | ID of the workflow process associated with this resource |
Product Name: Portal r12 Content Management
Table Type: Table