Track table: Standard fields

Previous pageReturn to chapter overviewNext page

The Track table contains information about all tracks in the database. Information from lookup tables (for example Artist or Songwriter) is not stored in the Track table, CATraxx only saves a link to the relevant item in the lookup table. This means that any changes you make to a lookup item, for example fixing a typing error, is reflected in all tracks where the item is used.

Album ID (Numeric)

This is the album's unique ID number.

Artist (Text 100 - lookup)

The artist(s) that recorded the track.

The default artist roles are: Featuring, Vs. and With.

Artist 2 (Text 100 - lookup)

This field contains the track artist if it is different from the album artist. If the track artist and the album artist are equal, this field is empty.

Artist Relation (Text 100 - lookup)

This includes all related artists.

Audio Filename (Text 255)

The full path to the audio file.

Audio Type (Numeric)

The type of audio file: 1 - mp3, 2 - wav, 3 - wma, 4 - aac, 5 - ape, 6 - flac, 7 - mp4/m4a, 8 - ogg, 9 -shn, 10 -m4b, 11 - mpc, 12 - wavpack, or 99 - other.

Author/Publisher (Text 100 - lookup)

The authors of the song.

The default Author/Publisher roles are: Author, Composer, Copyright, Librettist, Lyricist, Publisher, Score, and Songwriter.

Band Member (Text 100 - lookup)

The band members and the instruments they play.

Blank (Checkbox)

Select this field if the track is "blank" track (an empty one second track).

By default, blank tracks are excluded from all reports, the Track View, searches, and the CD Player, but will be displayed in the track list in the Album Edit window. If you also want to exclude blank tracks from the track list, choose Tools->Options->Miscellaneous, and select Hide blank tracks / Always.

Bonus (Checkbox)

If the track is a bonus track, select this field.

BPM (Numeric)

The number of beats per minute. This is occasionally entered by, and useful for, disc jockeys for DJ synching of tracks.

Conductor/Arranger (Text 100 - lookup)

The conductor/arranger credits.

The default conductor/arranger roles are: Arranger, Conductor, Director, and Orchestrator.

Counter Start (Numeric)

Use this field to specify the tape counter start position.

If you have specified both the counter start and stop positions, CATraxx will automatically calculate the length of the track if the counter time format is set to Time.

If you haven't specified the counter stop position for the previous track, CATraxx will automatically fill it in when you save the current track. For example, if the start counter for the current track is 0:12:00, CATraxx will fill in the same counter in the counter stop field for the previous track.

Counter Start-Stop (Numeric)

This field includes the counter start and stop positions (for example 0:12:00-0:15:30).

Counter Stop (Numeric)

Use this field to specify the tape counter stop position.

If you have specified both the counter start and stop positions, CATraxx will automatically calculate the length of the track if the counter time format is set to Time.

Days Since Played

Numeric

The number of days since you last played the track.

Demo (Checkbox)

If the track is a demo recording, select this field.

Disc (Numeric)

This field contains the disc the track is located on, and is automatically maintained by CATraxx. If the track is located on disc 2 of a double CD, the disc number is 2.

File Links (Text)

Here you can add links to files.

Full Title (Text)

This field combines Title, Version, Live, Demo, Instrumental, Bonus, Hidden and Blank into one field. For example, if the track is a live recording of Losing My Religion, the field value is "Losing My Religion [Live]".

Genre (Text 102 - lookup)

A genre consists of a Main Genre and a Sub-Genre (Genre: Sub-genre), for example:

Classical: Opera
Electronic: Jungle
Jazz: Fusion
Rock: Classic Rock
World: Celtic

You can add as many genres as you like. To open the popup menu to select a genre, click the arrow button, or press Ctrl+Arrow Right. You can rearrange the genres in the list with drag-and-drop.

Guest Musician (Text 100 - lookup)

The guest musicians and the instruments they play.

Hidden (Checkbox)

Select this field if the track is "hidden" (not included in the track list on the cover).

Index (Numeric)

This field contains the track index, and is automatically maintained by CATraxx. For example, if the track is number 3 on side B, the index is 3.

Instrument (Text 50 - lookup)

This field includes all instruments that are registered for the track.

Instrumental (Checkbox)

Select this field if the track is an instrumental.

Keywords (Text 50 - lookup)

This field is for listing keywords that describe the track.

Last Modified (Date)

The date/time the record was last modified. This field is automatically updated by CATraxx when you edit data.

Length

Numeric

The length of the track.

CATraxx automatically registers the track length when you download disc data from CDDB.

Live (Checkbox)

If the track is a live recording, select this field.

Lyrics (Memo)

Use this field to store the lyrics.

Marked (Yes/No)

This field indicates whether the track is marked or not.

Main Genre (Text 50)

The main genre (Main Genre: Sub-Genre).

Music Chart Info (Text 150 - lookup)

This field allows you to keep track of music chart data: Chart name, year, peak position, weeks in chart, and your own notes.

Musician (Text 50 - lookup)

This field includes both band members and guest musicians.

Notes (Memo)

This field is for your own notes.

Original by (Text 100 - lookup)

If the recording is a cover version, use this field to store the name of the artist that recorded the original version.

Personal Rating (Text with image)

Use this field to specify your own personal rating. The default setup will let you select a star rating between 0 and 5 stars.

In the data entry window, you can press the + or - button to select rating without having to open the list.

Position (Text)

This field contains the "track position". By track position we mean what disc and side the track is located on, and the index number.

For example:

track 3 on a CD: "3"
track 2 on side A on a LP: "A2"
track 5 on side B on disc 2 of a double CD: "2-B5".

Note: If the album has only one side, the side is not included. If the album consists of only one disc, the disc number is not included.

Primary Genre

Text 50

The primary genre is the first genre in the Genre field.

Production (Text 100 - lookup)

The production credits.

The default production roles are: Assistant Engineer, Associate Producer, Coproducer, Engineer, Executive Producer, Mastering, Mixing, Producer, Programming and Remixing.

Recording End (Date)

Use this field to specify when the recording process was completed. If you don’t know the day and month, just specify the year.

Recording Start (Date)

Use this field to specify when the recording process started. If you don’t know the day and month, just specify the year.

Released (Date)

The original release or publication date of the track.

Reviews (Memo)

This field is for excerpts of reviews.

Side (Text 1)

This field contains what side (A or B) the track is located on, and is automatically maintained by CATraxx.

Studio (Text 150 - lookup)

The studios where the song was recorded, mixed, and mastered.

The default studio roles are: Mastering Location, Mixing Location and Recording Location.

Sound (Text 50 - lookup)

Use this field to specify sound information, for example Mono or Stereo.

Sub-Genre (Text 50)

The sub-genre (Main Genre: Sub-Genre).

Sub-Titles (Text)

Use subtitles if the track consists of several parts and you want to give each part a title.

Tag Read (Date)

The last time data was read from the audio file tag.

Tag Write (Date)

The last time data was written to the audio file tag.

Title (Text 253)

The title of the track. Use the Title Sort field to specify the value that is used when sorting on the title.

Title Sort (Text 255)

This is the value that is used when sorting on the track title. When you tab out of the Title field (or save the track), CATraxx will automatically fill in the Title Sort field if it is empty. If the name begins with “A” or “The”, CATraxx will automatically update the Title Sort field to reflect this. For example, if you type “The Sidewinder Sleeps Tonite” in the Title field, CATraxx will add “Sidewinder Sleeps Tonite, The” to the Title Sort field. This means that the track is sorted under "S" and not "T".

Tour (Text 150 - lookup)

Use this field to specify the tour on which the track was recorded if it is a live recording.

Track ID (Numeric)

This is an unique ID number that is assigned to each entry in the table.

Venue (Text 150 - lookup)

Use this field to specify the venue where the track was recorded if it is a live recording.

Version (Text 150)

Use this field to specify information about the version of the track (for example Extended Mix, Club Mix, Cassette Demo, Acoustic Version, Studio Outtake or Live In Studio).

Video Filename (Text 255)

The full path to the video file.

Video Type (Numeric)

The type of video file: 1 - Video for Windows (avi), 2 - MPEG, 3 - Quick Time (mov), 4 - Flash Video (flv) or 99 - other.

Web Links (Text)

Here you can add links to web sites.

Year Copyright (Text 4)

Use this field to specify what year the song was copyrighted.

Year Written (Text 4)

Use this field to specify what year the song was written.




Do you have question? E-mail us at support@fnprg.com.