cmswindowsmediadata

Stores Windows Media 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
uebitrate float with null Extracted property
uebroadcast integer1 with null Extracted property
uebyte_count integer with null Byte count
uecopyrighted nvarchar(255) 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
uecurrent_bitrate float with null Extracted property
uedate_expires date with null Left over from legacy code
uedescription nvarchar(1000) with null Description entered by end user
uehas_audio integer1 with null Extracted property
uehas_event integer1 with null Extracted property
uehas_image integer1 with null Extracted property
uehas_video integer1 with null Extracted property
ueis_protected integer1 with null Extracted property
ueis_trusted integer1 with null Extracted property
uekeywords nvarchar(255) with null Keywords - entered by end user
uelast_modified_by nvarchar(255) with null User who last modified the object
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 asset
ueoptimal_bitrate float with null Extracted property
ueparentid integer with null DBID of the parent object
uerating nvarchar(255) with null Extracted property
ueseekable integer1 with null Extracted property
uesignature_name nvarchar(255) with null Extracted property
uestridable integer1 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
uewm_author nvarchar(255) with null Extracted property
uewm_description nvarchar(1000) with null Extracted property
uewm_title nvarchar(255) with null Extracted property
ueworkflow_id varchar(255) with null ID of the workflow process associated with this resource

Product Name: Portal r12 Content Management

Table Type: Table


Copyright © 2006 CA. All rights reserved.