Field Name

Type

Description

Acquired From

Text 50 (lookup)

Use this field to specify where you bought the album or who you got it from.

Album Credits

Text 100 (lookup)

Album credits like Artwork or Cover Design.

Album ID

Numeric

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

Appraiser

Text 50 (lookup)

The name of the appraiser (this could be a person, a catalog, etc.).

Artist

Text 100 (lookup)

The artist(s) that released the album.

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

Artist Relation

Text 100 (lookup)

This field includes all related artists.

Award

Text 100 (lookup)

Here you can specify awards. You can also specify the year the award was given and any additional details.

Bar Code No

Text 50

The bar code number.

Bootleg

Boolean

Select this field if the album is a bootleg.

Borrower

Text 50 (lookup)

If the album is currently loaned out, this field contains the name of the borrower.

Borrower Category

Text 50 (lookup)

If the album is currently loaned out, this field contains the category of the borrower.

Catalog No

Text 25

The label catalog number.

CDDB2 - Download

Boolean

This field indicates whether the album was downloaded from CDDB2.

CDDB2 - Submit

Boolean

This field indicates whether the album has been submitted to CDDB2.

Change in Value

Numeric

The difference between price and value.

Change in Value %

Numeric

The difference between price and value in percent.

Company

Text 50 (lookup)

The record company that released the album. In addition to the Label field you can use this field to specify the labels parent company.

Compilation

Boolean

Select this field if the album is a compilation.

A compilation is an album with tracks by different artists, such as soundtracks or samplers. Do not check the Compilation box if all tracks are by the same artist.

Condition Cover

Text 50 (lookup)

Use this field to specify the condition of the cover.

Condition Record

Text 50 (lookup)

Use this field to specify the condition of the record itself.

Country

Text 50 (lookup)

The country where the album was manufactured.

Cover

Binary

This field contains the image if it is stored in the database.

Cover - Comments

Memo

Comments about the image.

Cover - Compressed

Boolean

Specifies whether the image is compressed or not (only applies to BMP images).

Cover - External

Boolean

Specifies whether the image is stored externally (that is, only a link to the image is stored in the database) or not.

Cover - File Name

Text 255

If this is an external image, this field contains the file name.

Cover - Thumbnail

Binary

This field contains a thumbnail of the image. The thumbnail is automatically created when you add a new image.

Cover - Type

Numeric

The type of image: 0 - bmp, 1 - gif, 2 - jpeg, 3 - png, or 99 - other.

Current Value

Numeric

The current value of the album.

Custom 01

Text 150

This is a standard text field.

To rename the field to suit your needs, choose Field Definitions from the Tools menu, click the Fields tab, locate the field in the list and type the new field name in the Name column.

Custom 02

Text 150

This is a standard text field.

Custom 03

Text 150

This is a standard text field.

Custom 04

Text 150

This is a standard text field.

Custom 05

Text 100 (lookup)

This is a text field linked to a lookup table.

Custom 06

Text 100 (lookup)

This is a text field linked to a lookup table.

Custom 07

Text 100 (lookup)

This is a text field linked to a lookup table.

Custom 08

Text 100 (lookup)

This is a text field linked to a lookup table.

Custom 09

Numeric

This is a numeric field.

Custom 10

Numeric

This is a numeric field.

Custom 11

Numeric

This is a numeric field.

Custom 12

Boolean

This is boolean field (checkbox) that can contain one of two possible values: checked (selected, yes, on, true) or not unchecked (selected, no, off, false).

Custom 13

Boolean

This is boolean field (checkbox) that can contain one of two possible values: checked (selected, yes, on, true) or not unchecked (selected, no, off, false).

Custom 14

Boolean

This is boolean field (checkbox) that can contain one of two possible values: checked (selected, yes, on, true) or not unchecked (selected, no, off, false).

Custom 15

Boolean

This is boolean field (checkbox) that can contain one of two possible values: checked (selected, yes, on, true) or not unchecked (selected, no, off, false).

Custom 16

Boolean

This is boolean field (checkbox) that can contain one of two possible values: checked (selected, yes, on, true) or not unchecked (selected, no, off, false).

Custom 17

Boolean

This is boolean field (checkbox) that can contain one of two possible values: checked (selected, yes, on, true) or not unchecked (selected, no, off, false).

Custom 18

Text 150

This is a standard text field.

Custom 19

Text 150

This is a standard text field.

Custom 20

Text 100 (lookup)

This is a text field linked to a lookup table.

Custom 21

Text 100 (lookup)

This is a text field linked to a lookup table.

Custom 22

Date

This is date field.

Custom 23

Date

This is date field.

Custom 24

Boolean

This is boolean field (checkbox) that can contain one of two possible values: checked (selected, yes, on, true) or not unchecked (selected, no, off, false).

Custom 25

Boolean

This is boolean field (checkbox) that can contain one of two possible values: checked (selected, yes, on, true) or not unchecked (selected, no, off, false).

Custom 26

Boolean

This is boolean field (checkbox) that can contain one of two possible values: checked (selected, yes, on, true) or not unchecked (selected, no, off, false).

Custom 27

Boolean

This is boolean field (checkbox) that can contain one of two possible values: checked (selected, yes, on, true) or not unchecked (selected, no, off, false).

Custom 28

Boolean

This is boolean field (checkbox) that can contain one of two possible values: checked (selected, yes, on, true) or not unchecked (selected, no, off, false).

Custom 29

Boolean

This is boolean field (checkbox) that can contain one of two possible values: checked (selected, yes, on, true) or not unchecked (selected, no, off, false).

Custom 30

Boolean

This is boolean field (checkbox) that can contain one of two possible values: checked (selected, yes, on, true) or not unchecked (selected, no, off, false).

Custom 31

Boolean

This is boolean field (checkbox) that can contain one of two possible values: checked (selected, yes, on, true) or not unchecked (selected, no, off, false).

Custom 32

Boolean

This is boolean field (checkbox) that can contain one of two possible values: checked (selected, yes, on, true) or not unchecked (selected, no, off, false).

Custom 33

Boolean

This is boolean field (checkbox) that can contain one of two possible values: checked (selected, yes, on, true) or not unchecked (selected, no, off, false).

Date Acquired

Date

The date you acquired the album. If you dont remember the day and month, just specify the year. To bring up a calendar where you can select the date, click the button to the right of the text box.

Date Borrowed

Date

If the album is currently loaned out, this field contains the date it was borrowed.

Date Due

Date

If the album is currently loaned out, this field contains the date it is due to be returned.

Days Since Played

Numeric

The number of days since you last played the album.

Disc Label

Text 32

The disc label is read from the CD when you use the Audio/Scan Folder function to scan a CD for audio files.

Distributor

Text 50 (lookup)

The company that distributes the albums.

Enhanced CD

Boolean

Select this field if the CD is an enhanced CD.

An enhanced compact disc (ECD) is an audio CD with multimedia content.

File Links

Text

Here you can add links to files.

Format

Text 50 (lookup)

Use this field to specify the album format, for example LP, CD, DVD, Cassette, etc.

Format Group

Text 50 (lookup)

Indicates what format group the album format is linked to. Format groups are useful when creating reports and for statistical summaries.

A vinyl album and a CD album should be specified as two different formats (for example LP and CD), but can be linked to the same format group (for example Album).

Full Genre

Text (lookup)

This field combines Genre and Sub-genre into one field (Genre: Sub-genre), for example:

Classical: Opera

Electronic: Jungle

Jazz: Fusion

Rock: Classic Rock

World: Celtic

Gatefold Cover

Boolean

If the album has a gatefold cover, select this field.

The cover of an album with a gatefold cover opens like the front cover of a book.

Genre

Text 50 (lookup)

Use this field to assign the album to a music genre, for example Classical, Folk, Jazz or Rock. Simply select the desired genre from the drop-down list. Press Ctrl + W to add a new genre to the list.

The Sub-genre list is linked to the Genre list. When you select a genre, only the sub-genres of the genre are available in the Sub-genre list. For example, if you select the Classical genre, only classical sub-genres (like Baroque, Chamber Music, Opera, and Renaissance Era) will be displayed.

Note: You can right-click the Genre field and choose Update Tracks from the popup menu to update the Genre field for all tracks on the album with the same value as the album field.

HDCD

Boolean

Select this field if the CD is HDCD encoded.

High Definition Compatible Digital, or HDCD, is a patented process for delivering on CD the full richness and detail of the original microphone feed. When listening to HDCD recordings, you hear more dynamic range, a focused 3-D soundstage, and extremely natural vocal and musical timbre.

Insurance

Text 50 (lookup)

Use this field to link the album to an insurance policy.

Items

Numeric

This field contains the number of items the album consists of (1 for ordinary albums, 2 for double albums, and so on). The value of this field is automatically maintained by CATraxx.

Keywords

Text 50

(lookup)

This field is for listing keywords that describe the album.

Label

Text 50 (lookup)

Use this field to specify the recording label.

Live

Boolean

Select this field if this is a live album.

Note: You can right-click the Live field and choose Update Tracks from the popup menu to update the Live field for all tracks on the album with the same value as the album field.

Location

Text 50 (lookup)

Use this field to specify where the album is located.

Marked

Boolean

This field indicates whether the album is marked or not.

New Album

Boolean

This field indicates whether the album is new, and is based on the Date Acquired field. By default, if it's less than 60 days since you acquired the album, this field returns Yes. If not, it returns No.

Note: You can change the number of days used in this calculation by choosing Options from the Tools menu, and specifying the new value in the New Album period text box. Default value is 60 days.

Nomination

Text 100 (lookup)

Here you can specify award nominations. You can also specify the year the nomination was given and any additional details.

Notes

Memo

This field is for your own notes.

Number of Tracks

Numeric

This field contains the number of tracks on the album, and is automatically maintained by CATraxx.

On Loan

Boolean

This field indicates whether the album is currently on loan.

Original Pressing

Boolean

Select this field if the record is an original pressing.

Overdue

Date

If the album is loaned out, this field indicates whether it is overdue or not.

Owner

Text 50 (lookup)

Use this field to specify the owner of the album.

Packaging

Text 50 (lookup)

Use this field to specify information about the packaging.

The most common CD packaging types are:

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.

Picture Disc

Boolean

Select this field if the record is a picture disc.

Playing Time

Numeric

The total playing time in minutes and seconds. CATraxx automatically calculates the total playing time after you have registered the tracks on the album. If you need to modify the playing time manually, use the format mmmm:ss, where m is minutes and s is seconds, for example 0053:09.

Note: You can also calculate the total playing time by choosing Add Up Playing Time from the Album menu.

Promo

Boolean

Select this field if the album is a promotion release.

Purchase Price

Numeric

Use this field to specify what you paid for the album.

Reference No

Text 25

Use this field if you have your own system for identifying albums in your collection.

CATraxx will automatically generate the reference number. To configure this feature, choose Options from the Tools menu, click the Reference No tab and make your selections.

Registered

Date

This field contains the date the album was added to the database. Todays date is used automatically, but you can change it if you want.

Reissue

Boolean

Select this field if your copy of the album is a reissue.

Reissue Date

Date

If the album is a reissue, use this field to keep track of the reissue date/year.

Released

Date

Use this field to specify when the album was released.

Note: You can right-click the Released field and choose Update Tracks from the popup menu to update the Released field for all tracks on the album with the same value as the album field.

Remastered

Boolean

Select this field if you have a remastered copy.

Reviews

Memo

This field is for excerpts of reviews.

Reserved

Boolean

This field indicates whether the album is reserved or not.

Reserved Date

Date

If the album is reserved, this field contains the date the album was reserved.

Reserved To

Text 50 (lookup)

If the album is reserved, this field contains the name of the borrower the album is reserved to.

Selling Price

Numeric

Use this field to specify the selling price.

Sides

Numeric

This field contains the number of sides (for example 1 for CDs and 2 for LPs). The value of this field is automatically maintained by CATraxx.

Soundtrack

Boolean

Select this field if this is a soundtrack album.

SPARS

Text 50 (lookup)

The SPARS (Society of Professional Audio Recording Studios) code indicates whether different portions of the recording process were accomplished using either digital or analog recording methods, for example AAA, ADD or DDD. Press Ctrl + W to add a new entry to the list.

Status

Text 50 (lookup)

Use this field to specify the status of the album, for example Own (you own the album), Want (you have it on your want list), For sale (the album is for sale) or Reference (you dont own it, but want to include it in the database).

Sub Genre

Text 50 (lookup)

Use this field to assign the album to a music sub-genre, for example Classical: Opera, Jazz: Fusion or Rock: Classic Rock.

The Sub-genre list is linked to the Genre list. When you select a genre, only the sub-genres of the genre are available in the Sub-genre list. For example, if you select the Classical genre, only classical sub-genres (like Baroque, Chamber Music, Opera, and Renaissance Era) will be displayed.

Tape Type

Text 50 (lookup)

Use this field to specify the tape type, for example Normal, Chrome or Metal.

Title

Text 253

The album title.

Note: When you tab out of the Title field (or save the album), CATraxx will automatically fill in the Title Sort field if it is empty.

Title Sort

Text 255

This is the value that is used when sorting on the album title. When you tab out of the Title field (or save the album), 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 Joshua Tree in the Title field, CATraxx will add Joshua Tree, The to the Title Sort field. This means that the album is sorted under "J" and not "T".

Valid CDDB Toc

Boolean

This field indicates whether the album has a valid CDDB Toc. The Toc is fetched from the CD when you scan it. You can only submit, or update (download), CDs with a valid TOC.

Valid MS Disc ID

Boolean

This field indicates whether the album has a valid Microsoft Disc ID or not. Only albums with a valid MS Disc ID are exported to CDPLAYER.INI (Microsoft CD Player).

Vinyl Color

Text 50 (lookup)

Use this field to specify the vinyl color.

Web Links

Text

Here you can add links to web sites.