uemsofficedata

Stores MSOFFICE 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
ueapp_name varchar(255) with null Extracted property
ueauthor varchar(255) with null Author - entered by end user
uebyte_count integer with null Byte count
uecategory varchar(255) with null Extracted property
uechar_count integer with null Extracted property
uecompany 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 Left over from legacy code
uedescription varchar(1000) with null Description - entered by end user
ueedit_time varchar(255) with null Extracted property
uehidden_count integer with null Extracted property
uekeywords varchar(255) with null Keywords - entered by end user
uelast_editor varchar(255) with null Extracted property
uelast_modified_by varchar(255) with null User who was last to modify the object
uelast_print_time date with null Extracted property
uelast_saved_time date with null Extracted property
ueline_count integer with null Extracted property
uemajor_type varchar(255) with null Major type
uemanager varchar(255) with null Extracted property
ueminor_type varchar(255) with null Minor type
uemmclips integer with null Extracted property
uems_author varchar(255) with null Extracted property
uems_comments varchar(1000) with null Extracted property
uems_creation_date date with null Extracted property
uems_keywords varchar(255) with null Extracted property
uems_subject varchar(255) with null Extracted property
uems_title varchar(255) with null Extracted property
uename varchar(255) with null Filename of the asset
uenote_count integer with null Extracted property
uepage_count integer with null Extracted property
uepara_count integer with null Extracted property
ueparentid integer with null DBID of the parent object
uepres_format varchar(255) with null Extracted property
uerev_number varchar(255) with null Extracted property
uesecurity varchar(255) with null Extracted property
ueslide_count integer with null Extracted property
uesubject varchar(255) with null Subject - entered by end user
uetemplate_name varchar(255) with null Extracted property
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
ueword_count 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


Copyright © 2006 CA. All rights reserved.