Parameters

Value

Description

Notes

@object_handle

integer = null,

The handle of the object.

@id

integer = null output,

The Digital Resource ID.

[DSM ONLY]

@name

varchar(64)

The file/folder name.

@location

varchar(255)

The file/folder location.

@server_name

varchar(255)

The server name.

[DSM ONLY]

@size

integer

The size of the file or -1 if it is a folder.

[VT/JM ONLY]

@size

bigint

The size of the file or -1 if it is a folder.

[DSM ONLY]

@type

varchar(255)

Document type of the DR.

@date_created

t_date_value

Date created.

@time_created

t_time_value

Time created.

@date_last_modified

t_date_value

Date last modified.

@time_last_modified

t_time_value

Time last modified.

@date_thumbnailed

t_date_value

Date thumbnailed.

@time_thumbnailed

t_time_value

Time thumbnailed.

@thumbnail_method

integer

Thumbnailing method.

1 - Get preview

2 - Sample

3 - Get icon

4 - Use standard icon

5 - Thumbnail pending

@mac_creator

varchar(4)

Mac creator.

@mac_type

varchar(4)

Mac type.

@keywords

text = null

Keywords, comma delimited

@keywords_info

t_string = null

A string that is a part of the select statement where the keywords are located. (i.e. 1 keyword from my_keyword where id = 1).

@thumbnail

image = null

Thumbnail.

@thumbnail_info

t_string = null

A string that is a part of the select statement where the thumbnail is located. (i.e. 1 thumbnail from my_thumbnails where id = 1).

@user_name

t_user_name = ‘Administrator’

The name of the user adding the DR (for history). By default, it is set to ‘Administrator’.

@extended_info

text = null

Extended info in XML format.

@extended_info_location

t_string = null

Extended info in XML format.

@ext_preview_format

varchar(255) = null

Extended info in XML format.

@last_event_type

varchar(255) = null

[VT/DSM ONLY]

@thumbnailing_hint

varchar(255) = null

[VT/DSM ONLY]

@thumbnailed_file_date

datetime = null

Date the thumbnail was last generated for the file.

[VT/DSM ONLY]

@thumbnailed_file_time

datetime = null

Time the thumbnail was last generated for the file.

[VT/DSM ONLY]

mds_status

varchar(50) = null

[VT/DSM ONLY]

mds_status_updated_date

datetime = null

[VT/DSM ONLY]

mds_status_updated_time

datetime = null

[VT/DSM ONLY]

@file_role

varchar(255) = null

File role (Job, Job File, etc...).

[DSM ONLY]

@archiving_status

varchar(32) = null

Archiving status of the file (Archive, Production).

[DSM ONLY]

@media-type

varchar(10) = null

R, RR.DISK or RR.TAPE.

[DSM ONLY]

@customer_code

varchar(16) = null

Customer Code.

[DSM ONLY]

@customer_name

varchar(40) = null

Customer Name.

[DSM ONLY]

@job_number

int = null

Job number.

[DSM ONLY]

@job_name

varchar(40) = null

Job Name.

[DSM ONLY]

@job_assigned_to

varchar(32) = null

User login name the Job is assigned to.

[DSM ONLY]

@archive-on

datetime = null

A date on which the resource is ready to be archived.

[DSM ONLY]

@notes

text = null

Any string longer than 8000 characters.

[DSM ONLY]

@notes_location

t_string = null

A string that is part of the select statement where the notes are located (i.e. 1 note from my_notes where id = 1)

[DSM ONLY]