Available Binding Values in Content Manager

Value

Type

Searchable?

Description

Special Columns

hiMedium.Format

String

Displays whether a video is SD or HD in a column. Mainly useful for Roughcut editing. Often used with FormatToSdHdConverter.

CalculatedDuration

Integer

Displays calculated duration of an entry whose value depends on the configured display mode. The configuration is defined per table, see /wiki/spaces/LDPECM/pages/11568546.

General Columns

Album

String

Name of the album or collection

Amplification

String

Amplification in dB

AmplificationIn

String

Volume value at the beginning of the entry’s audio (used by CFM and OTM)

AmplificationOut

String

Volume value at the end of the entry’s audio (used by CFM and OTM)

Archived

Integer (0, 1)

Flag: Entry is archived

ArchiveDate

Date

Date of archiving. Use with DateToStringConverter.

AudioFormat

String

Elasticsearch only

Format of an audio file

AudioMode

String

Audio mode (Mono, Stereo, etc)

Author

String

Author of the entry or of the music text

AvailDate

Date

Date of availability. Use with DateToStringConverter.

Bitrate

Integer

Audio bitrate in Kbit/s

BriefDesc

String

Short description

Broadcast

String

Name of the broadcast show

BroadcastDate

Date

Date of the broadcast. Use with DateToStringConverter.

Broadcastings

Integer

Shows how often this medium has been broadcasted.

CartPriority

Integer

The priority of the cart, reserved for a use by the CartWall only! Number 1-10)

Category*

String

Category of the entry, especially used by the CartWall, e.g. Jingle, Drop-In, Stringer, Trailer

ChangeDate

DateTime

Date of the last change(s) in the entry. Use with DateToStringConverter.

ChangeUser

String

Username of the user who has made the last modification.

Class

String

Shows the class of an entry (e.g. Music, Project, etc.)

Use with ClassCellTemplate. Also seeAvailable CellTemplates Values

Composer

String

Composer

Correspondent

String

For news entries: Correspondent who created the entry.

For music entries: Short form of the performer (artist) name.

CostCenter

String

Cost center

Creator

String

Username of the creator.

CreateDate

DateTime

Date of the creation. This column is automatically filled when a new entry is created. Use with DateToStringConverter.

Customer*                

String

Customer as index to the definition table. Used for commercials. The same for Product, ProductGroup

DeleteDate

Date

Date from which the entry can be deleted. Use with DateToStringConverter.

Distribution

String

List of stations which will receive a copy via Replication

Donut

Integer

Duration of the donut in seconds. Reserved for use by the CartWall only.

Duration

Integer

Duration of media file. Use with MsToDurationConverter

Editor

String

Editor of the entry

Endcode*

String

End code (fade-out specification)

Era*

String

Music era (period)

ExtDevice*

String

Reserved for future use.

FadeIn

Integer

Audio fade-in time in milliseconds

FadeOut

Integer

Audio fade-out time in milliseconds.

Fading*

String

Fade-in specification

Filename

String

Filename of the main medium file.

Filepart

String

Variable part of filename, which is defined with %u in column NamingRule in medium table.

FileSize

Integer64

File length in bytes. Use with FileSizeConverter.

FirstUseDate

Date

Date of the first possible broadcasting. Use with DateToStringConverter.

FirstWords

String

Field to enter introducing words

ForArchive

Integer (0, 1)

Flag: Entry requested to be archived

ForeignMotive

String

An identifier for commercials. In contrary to the column "Motive" this one is assigned by the sending agency.

GemaId

String

Identifier for the German GEMA for music titles (ISRC)

Generation

Integer

For audio entries: the number of editing processes since creation of the sound file.

GenericTitle

String

Main title, work title, original title, short title or for free use.

Group

Integer

Clearly identify groups through a group icon. See Story.

Use with GroupCellTemplate. Also see Available CellTemplates Values

GroupId

Integer

Internally assigned number for entries in entry groups (not user relevant)

Growing

Integer (0, 1)

Flag: Entry with a medium file currently recording or incoming (not actively in use)

Header

String

Elasticsearch only

Header

Identifier

Integer

Unique identifier for different purposes, especially for non-DAVID programs.

Indexed

Integer (0, 1)

Flag: This entry has been indexed (a full-text index of this entry has been created by DigaSQL.dll)

Informat

String

In Germany information about entries from the "ARD-Sternpunkt", otherwise this field is free useable.

Instrumentation*

String

The instrumentation or the gender of the music

Intensity*

String

The intensity of the music

Intro

Integer

Intro time in milliseconds

Intro2

Integer

Intro2 time in milliseconds (internally Intro2 is mapped to database field Outro)

Invalid

Integer (0, 1)

Flag: Entry is invalid

Invisible

Integer (0, 1)

Flag: Entry is invisible

KeyFrameExists

Integer (0, 1)

Flag: Entry has keyframes

Keywords

String

Entry description, keywords for the full text index

Label**

String

Elasticsearch only

Label

LabelCode**

String

Elasticsearch only

LabelCode

Language*

String

The language of the entry

LastSendDate

Date

Field exists starting from database version 5. Not used at the moment. Use with DateToStringConverter.

LastUseDate

Date

The date of the last possible broadcasting. Use with DateToStringConverter.

LastWords

String

Field to enter words closing the entry topic

LinkIn

Integer

Link-In time in milliseconds (since database 5)

LinkOut

Integer

Link-Out time in milliseconds (since database 5)

Location

String

Not used anymore: Information where to find the corresponding data file if it is evacuated. Reserved for the archive module and the Replicator.

Loop

Integer (0, 1)

Flag: Loop

LowResExists

Integer (0, 1)

Flag: Existing low res file in entry

MarkIn

Integer

Mark-in time in milliseconds

MarkOut

Integer

Mark-out time in milliseconds

Media

Array of Medium

List of media attached to entry.

MediumCode

Integer

Not used anymore: The number of the medium, combined with a side specification: MediumCode = 2*number+(side-'A')

MediumName

String

The inscription/label of the medium/ CD-ID

MediumType*

String

Sort of medium (CD, DVD, etc.)

MemberGroupId

Integer

Internally assigned number for entries in entry groups (not user relevant)         

MemberIds

Array Of Integer

Internally assigned number for entries in entry groups (not user relevant)

This field is an “Array of Integer”: This means, this columns will list up several integer values, namely the reference numbers of all entries being member of this group.

MixerSource

String

Field exists starting from database version 5. Not used at the moment.

Mood*

String

The mood of a music entry

MusicFormat*

String

The format of the music

MusicId

String

Identifier for music automation (Selector, etc.)

Publisher

String

Publisher name of the audio/video/text

Motive

String

Identifier for commercials

New

Integer (0, 1)

Flag: New entry (not actively in use)

NoDelete

Integer (0, 1)

Flag: Delete protection

Number

Integer

Identical to RefNr: Reference number, identical to the main table.

Orderer

String

List of stations which want to receive a copy

Generator

String

Identifier for the program which has created the entry. This is especially important for the class "Project" or "Unknown" to find out which program is capable to handle this entry.

Outro

Integer

Outro time in milliseconds (internally Outro is mapped to database field SpotLength).

Outro2

Integer

Outro2 time in milliseconds. Field exists starting from database version 5.

Owner

String

Originator, owner of the copyrights

Perfect

Integer (0, 1)

Flag: Perfect entry

Performer

String

Performer/Artist information for music entries

Personal

String

If the entry is personal, this column contains the system user name of the owner. If the owner is a group, the group ID with a preceding '#' is printed instead of the group name (because the length of the group name is not limited). If the field is empty the entry is free.

PersonalRadio

Integer (0, 1)

Flag: Personal radio

PlayOutGain

String

PlayOutGain value in dB.

Fields exists starting from database version 5. In database version 4 of fewer PlayOutGain value stored in RESERVE1 field.

PlayTime*

String

The preferred playtime for broadcasting

Presenter*

String

Presenter information

Pool

String

System pool identifier, currently not used.

Priority

String

Priority: e.g. flash, urgent, important, normal, unimportant.

Producer

String

Producer information

Product*

String

The product as index to the definition table. Used for commercials.

ProductGroup*

String

The product group as index to the definition table. Used for commercials.

Production*

String

The production for which the entry has been produced

Program*

String

Program for which the entry is intended

Project*

String

This column is reserved for CartWall projects!

Ramp

Integer

Duration of the ramp in seconds. Reserved for use by the CartWall only.

Ready

Integer (0, 1)

Flag: Broadcast entries that are “ready to send”

RecordDate

Date

Date of the audio recording (not CreationDate). Use with DateToStringConverter.

RecordPlace

String

The record location or the studio

Registration

String

Unique identifier for different purposes, especially: production number, archive number

Remark

String

Comment field

ReplFlags

Integer

Bit-field which represents flags for the Replicator

ReplIdent

String

Unique identifier, reserved for the Replicator only!

RequestDearchive

Integer (0, 1)

Flag: Request to de-archive the entry

Ressort

String

Ressort (department) for entry indexing

Royalties

Integer (0, 1)

Flag: For entries with content liable to pay costs

Samplerate

Integer

Audio sampling frequency in Hz: 16000, 32000, 44100 or 48000

Seasonal*

String

Preferred season for broadcasting

SendRights

String

Despite its name this column is used to store the average speech time of the corresponding text file.

SharedAudio

Integer (0, 1)

Flag: This entry’s media file is referenced in other entries (this is a not recommended settings in DigAlign)

SoftDeleted

Integer (0, 1)

Flag for soft-deleted entries: 1 = soft-deleted, 0 = normal.

Sort

String

Used for collection elements

SoundProcessing

String

Field exists starting from database version 5. Not used at the moment.

Source

String

Origin/source of the audio/video

Speaker*

String

Name of the speaker

SpotLength

Integer

Outro time in milliseconds. In database and in DigaSQL structures it’s still called Spotlength due to historical reasons but the actual meaning is Outro. In section string and in XML format this field is mapped into 2 fields: OUTRO in “HH:MM:SS” format and SPOTLENGTH as number of milliseconds. Field SPOTLENGTH in section strings and XML format is provided only for compatibility with old versions and should not be used anymore.

Use with MsToDurationConverter.

State

String

State describes the status of the media file corresponding to the entry: 0 = None: Unknown state; 1 = Virtual: Announcement that no corresponding media file exists but will be created soon; 2 = Recording: Data file is just coming in; 3 = Existing: Data file is accessible; 4 = Evacuated: Data file has been evacuated (e.g. into the archive medium); 5 = External: Data file exists on a foreign medium (e.g. a DVD); 6 = Requested: Data file has been requested (ordered) via DigaReplicator

Stinger

String

Description type of stinger

Story

Integer

If an entry is a group this column contains the type of the group. The following values are defined:

• 0 = standard entry (not a group),

• 1 = group is a classical work with multiple parts,

• 2 = group is a story with a sequence of media entries (standard group entry),

• 3 = group is a story used in a (broadcast) schedule, containing a sequence of media entries that need to contain a text element,

• 4 = group is a container for any type of members, the sorting does not matter,

• 8 = stack = group is a sequence of audio elements to be played in the predefined order,

• 16 = collection = group of elements from different tables.

• 32 = group is a endpoint story

Also see Available CellTemplates Values

Style*

String

Style of the music

SubRessort

String

Sub-Ressort (sub-department) for entry indexing

Singer

String

Name of the singer

Table

String

Name of the table

Tag

Integer

Duration of the tag in seconds. Reserved for use by the CartWall only.

Target*

String

Target group

Tempo*

String

Tempo of the music

TextDuration

Integer

Text length

Title

String

Title of the entry

Trailer

String

Elasticsearch only

Trailer

Transmitted

Integer (0, 1)

Flag: Confirmation of successful transmission

Type*

String

Type of the music

UseRestricitons

String

Field exists starting from database version 5. Not used at the moment.

Vsat

Integer (0, 1)

Flag: Vsat

Weekday

Integer

Bitfield for the weekday encoding of the CartWall only! (Mo: Bit0...Su: Bit6)

WithTextFile

Integer (0, 1)

Flag: Attached text file(s) in the entry

Special custom fields

LOUDNESS / ?

See Loudness Manual, delivered as PDF together with DPE Loudness Processor

DAVID / DISTRIBUTIONENDPOINTS