NEON:Media

From AMACWiki

The NEON media table contains information about the alternative media formats available for a book. Media records are created and maintained by AMAC Production. Alternative Media fulfills an order.

Alternative Media is physically produced by a vendor. If the media source is outsourced, then the vendor is an external vendor (i.e. codeMantra). If the media source is in-house, then the vendor is an internal vendor (i.e. a member of AMAC Production staff).

Disability Service Providers have read-only access to this table and cannot view production cost data associated with media.

Back to NEON Tables

Contents 1 Production Process 1.1 Scenario A 1.2 Scenario B 2 Production Cost 3 Fields

Production Process

The production of Alternative Media can be summarized as follows:

Scenario A

1. Book is purchased.
2. Book is received.
3. Spine is cut off the book and book is scanned.
4. OCR is performed on scanned image file along to produce electronic text file.
5. Electronic text file is formatted.

Scenario A would produce 1 media record for the formatted electronic text file (created from the scan of the book).

Scenario B

1. Publisher file is requested
2. Publisher file is received
3. Publisher file is reviewed and formatted if required

Scenario B would produce 1 media record for the formatted electronic text file (received from the publisher).

Production Cost

Source	Formula
Braille	# of Pages * Production Rate
Outsourced	# of Pages * Vendor Rate
In-House	(Component Hours + Production Hours) * Production Rate

Fields

The fields of the media table are:

Field	Description
Date Created	Date record was created.
Date Modified	Date record was last updated.
Media ID#	Unique ID# of the record.
Record Owner	User who owns the record.
Last Modified By	User who last modified the record.
Book ID#	The book the media record is related to.
Media Type	Type of media: Text, Audio, Braille, etc.
Source	Who produced the media: Publisher, Outsourced, In-House (AMAC).
Format	The format of the media file: .DOC, .PDF, etc.
Status	The production status of the media record: New, Assigned, In Production, Dispatched, Complete, Tagging, To Be Standardized.
Priority	Priority level assigned to the media record ("1" being the highest priority).
Standardized	A checkbox if the media is in the standardized format.
Tagged	A checkbox if the media is in a tagged format.
Vendor ID#	The vendor the media record is related to.
Source Folder	The folder the source files for the media are contained in.
Target Folder	The folder the converted files for the media are contained in.
Partial	A checkbox if the media is only for a portion of the book.
Notes	Any notes related to the media record.
Assigned Date	The date AMAC assigned the media record to a vendor.
Received Date	The date the vendor received the media record from AMAC.
Projected Dispatch Date	The date the vendor expects to complete the media record.
Dispatch Date	The date the vendor returns the media record to AMAC.
Completed Date	The date the media record completed production.
Component Hours	The number of hours it took to complete all components of the media.
Production Hours	The number of hours it took to complete production of the media.
# of Pages	The number of pages produced for the media record.
Production Rate	The production rate in dollars.
Media Cost	The total cost to produce the media in dollars.