seed_type

This is how we categorize between sound recording earnings and composition earnings.

type_code

EPAY or MPAY

This column is another way to tell whether a particular line is for sound recording or mechanical royalties. EPAY is for sound recording earnings, and MPAY is for mechanicals.

ingest year/month

This is a timestamp of when we processed the royalty report from the DSPs. This may be different from the “report_year” or “report_month”, since that is the timestamp of when the royalty activity (view, stream or download) actually happened.

payee_id

This is Stem’s unique identifier for your account.

resource_id

This is Stem’s unique identifier for each deliverable piece of content.