PERSONLIST

From ICISWiki

Jump to: navigation, search

Back to TABLE CHANGES v5.6

New PERSONLIST Table Design (introduced in v5.6)

Field Name Description Data Type Field Size
OWNERID Owner of the list of PERSONS; Link to PROJECTID in PROJECT table Long
PERSON Person entry in the list; Link to PERSONID in PERSONS table Long 4
SORTORDER  Sort order for person in the list Integer 2
NAME Full Name of Person (convenience: composite of entries in PERSONS table) Text 64
LISTSTATUS Status of the list (valid values: 1=Active, 0=Folder, 9=Deleted) Integer 2

Notes

  • OWNERID can point to the PROJECT table (for Project Teams, Collecting Missions, Co-PI's, etc.)
  • If this PERSONLIST table is to be generalized to hold lists of PERSONS for other ICIS table types (e.g. PUBLICATIONS)?


Personal tools