Album table: Standard fields

Previous pageReturn to chapter overviewNext page

The Album table contains information about all albums in the database. Information from lookup tables (for example Artist or Format) is not stored in the Album 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 albums where the item is used.

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.

Barcode (Text 50)

The bar code number.

Bootleg (Checkbox)

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.

Box Set (Text)

You can link an album to a box set.

Catalog No (Text 25)

The label catalog number.

CDDB2 - Download (Yes/No)

This field indicates whether the album was downloaded from CDDB2.

CDDB2 - Submit (Yes/No)

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 (Checkbox)

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 (Yes/No)

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

Cover - External (Yes/No)

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.

Date Acquired (Date)

The date you acquired the album. If you don't 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 Count (Numeric)

This field contains the number of discs 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.

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 (Checkbox)

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).

Gatefold Cover (Checkbox)

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 102 - lookup)

A genre consists of a Main Genre and a Sub-Genre (Main 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.

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 genre(s) as the album field.

HDCD (Checkbox)

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.

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.

Last Modified (Date)

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

Live (Checkbox)

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 (Yes/No)

This field indicates whether the album 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.

New Album (Yes/No)

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 Tools=>Options=>Data Entry, 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 updated by CATraxx.

On Loan (Yes/No)

This field indicates whether the album is currently on loan.

Original Pressing (Checkbox)

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:

Blisterpack - a plastic cover over the CD that allows the discs to displayed on a hook instead of in a bin.
Digipack - a card CD case with a bit of plastic to support/hold the CD.
Jewelcase - a plastic case that holds the CD (the standard CD packaging).
Longbox - a paperboard box that holds the CD.

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 (Checkbox)

Select this field if the record is a picture disc.

Playing Time (Numeric)

The total playing time. CATraxx automatically calculates the total playing time after you have registered the tracks on the album.

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

Primary Genre (Text 50)

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

Promo (Checkbox)

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. Today's date is used automatically, but you can change it if you want.

Reissue (Checkbox)

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 (Checkbox)

Select this field if you have a remastered copy.

Reviews (Memo)

This field is for excerpts of reviews.

Reserved (Yes/No)

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 (Checkbox)

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 don't own it, but want to include it in the database).

Sub-Genre (Text 50)

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

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 (Yes/No)

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 (Yes/No)

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.




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