Apologies if this is answered elsewhere (I could not find anything definitive), but are the middle eight characters of the programid (after the EP/SH/SP/MV) unique for unique series. That is, if there is an programid of the form EP00000001xxxx, which there ever be a MV000000010000, or SP000000010000 or SH000000010000 which is not directly related to the EPisode? Asked another way, are those substr(programid, 2, 8) values reused for other categories (for SHows and EPisodes they clearly are because those are related, but what about SPorts and MoVies)?
If those values are not unique, can the resourceid be used this way (and what is the definition of the resourceid)?