PAHMA Groups data mapping

This page contains information about PAHMA's data migration of Groups and related info.
See parent page on PAHMA data migration ETL work.

Groups extract

field mapping

TMS table name	TMS field name	CSpace field name	notes
ObjectPackages	name	title
ObjectPackages	notes	scopeNote
ObjectPackages	owner	owner	FK to Users; reference to Person Authority

sql query

view: cs_groups

SELECT
 p.objectPackageID groupID,
 p.name title,
 p.notes scopeNote,
 (CASE WHEN u.MTB_ConstituentID = -1 THEN NULL ELSE u.MTB_ConstituentID END) owner
FROM
 ObjectPackages p
 LEFT OUTER JOIN Users u ON p.owner = u.login
;

notes

"global" field does not need to be imported, per Michael (1/12/12)

Object-Group Relationship extract

field mapping

TMS table name	TMS field name	CSpace field name	notes
ObjPkgList	ObjectID	reference to Object
ObjPkgList	ObjectPackageID	reference to Group

sql query

view: cs_objectgrouprelationships

SELECT
 CAST(o.objectID AS VARCHAR) objectID,
 o.objectPackageID groupID
FROM
 objPkgList o
;

notes

TODO: handle ObjPkgList.Notes field; we need a place to put this info, either in Groups or Objects schema