About the awards:
For Titanic (
http://www.allmovie.com/work/titanic-158894/awards) the awards in my DB look like this:
AWARDS:
Best Actress (nom) - Kate Winslet - 1997 - Academy
Best Art Direction (win) - Peter Lamont - 1997 - Academy
Best Art Direction (win) - Michael Ford - 1997 - Academy
Best Cinematography (win) - Russell Carpenter - 1997 - Academy
Best Costume Design (win) - Deborah L. Scott - 1997 - Academy
Best Director (win) - James Cameron - 1997 - Academy
Best Dramatic Score (win) - James Horner - 1997 - Academy
Best Editing (win) - James Cameron - 1997 - Academy
Best Editing (win) - Conrad Buff - 1997 - Academy
Best Editing (win) - Richard A. Harris - 1997 - Academy
Best Makeup (nom) - Greg Cannom - 1997 - Academy
Best Makeup (nom) - Tina Earnshaw - 1997 - Academy
Best Makeup (nom) - Simon Thompson - 1997 - Academy
Best Picture (win) - James Cameron - 1997 - Academy
Best Picture (win) - Jon Landau - 1997 - Academy
Best Song (win) - James Horner - 1997 - Academy
Best Song (win) - Will Jennings - 1997 - Academy
Best Sound Effects Editing (win) - Christopher Boyes - 1997 - Academy
Best Sound Effects Editing (win) - Tom Bellfort - 1997 - Academy
Best Sound (win) - Gary Rydstrom - 1997 - Academy
Best Sound (win) - Tom Johnson - 1997 - Academy
Best Sound (win) - Mark Ulano - 1997 - Academy
Best Sound (win) - Gary Summers - 1997 - Academy
Best Supporting Actress (nom) - Gloria Stuart - 1997 - Academy
Best Visual Effects (win) - Thomas Fisher - 1997 - Academy
Best Visual Effects (win) - Rob Legato - 1997 - Academy
Best Visual Effects (win) - Mark Lasoff - 1997 - Academy
Best Visual Effects (win) - Michael D. Kanfer - 1997 - Academy
Best Cinematography (win) - Russell Carpenter - 1997 - American Society of Cinematographers
Best Director (win) - James Cameron - 1997 - Broadcast Film Critics Association
Best Cinematography (win) - Russell Carpenter - 1997 - Chicago Film Critics Association
Best Original Score (win) - James Horner - 1997 - Chicago Film Critics Association
Best Director (win) - James Cameron - 1997 - Directors Guild of America
Best Actor in a Dramatic Picture (nom) - Leonardo DiCaprio - 1997 - Golden Globe
Best Actress in a Dramatic Picture (nom) - Kate Winslet - 1997 - Golden Globe
Best Director (win) - James Cameron - 1997 - Golden Globe
Best Dramatic Picture (win) - - 1997 - Golden Globe
Best Original Score (win) - James Horner - 1997 - Golden Globe
Best Original Song (win) - James Horner - 1997 - Golden Globe
Best Original Song (win) - Will Jennings - 1997 - Golden Globe
Best Screenplay (nom) - James Cameron - 1997 - Golden Globe
Best Supporting Actress (nom) - Gloria Stuart - 1997 - Golden Globe
Best Production Design (win) - Peter Lamont - 1997 - L.A. Film Critics Association
Best Picture (nom) - - 1997 - National Board of Review
Best Actress (nom) - Kate Winslet - 1997 - Screen Actors Guild
Best Ensemble Acting (nom) - - 1997 - Screen Actors Guild
Best Supporting Actress (win) - Gloria Stuart - 1997 - Screen Actors Guild
Best Director [Runner-up] (win) - James Cameron - 1997 - Toronto Film Critics Association
Best Foreign Language Film (nom) - - 1998 - French Academy of Cinema
About the category field:
Similarily, for Titanic I have
Epic, Romance, Romantic Epic, Disaster Film, Period Film, Sea Adventure
which IS indeed Genres + Types, but I have no real idea whether these were a single category in the previous version of AMG or already separated.
If that helps, an older version of the AMG script I used about 2-3 years ago already used this combination and even had additional stuff there.
(for Shrek
http://www.allmovie.com/work/shrek-242627 I have
Fantasy, Comedy, Children's/Family, Fantasy Comedy, Fairy Tale, Children's Fantasy
while the latest version of the AMG script has
Children's/Family, Fantasy Comedy, Fairy Tales & Legends, Children's Fantasy
so I guess it's Genres + Types now.
About Moods... well,
In my Producer field actually never got anything else than what's listed at ProducerOptions 0, the field "Produced by" -- never got anything about themes or tones them. Frankly, I couldn't find so far any movie having a Mood field, so I wonder whether that field isn't now part of "Tones", as tones and moods are somewhat similar.
I hope this might help you a bit -- I'm basing my catalog mostly on AMG, with info from IMDB and TV.com manually rechecked/added, also, movie poster image oftenly made from multiple posters/DVD covers of the same movie.