EVENTMEM
From ICISWiki
Contents |
EVENTMEM Table Design v5.6
| Field Name | Description | Data Type | Field Size |
| MEMID | Unique ID for the person in this team | Number | Long Integer |
| EVENTTAB | Table name to which the member relates (LISTNMS or STUDY) | Text | 50 |
| EVENTREC | Value of IDField to which the member relates | Number | Long Integer |
| MEMNO | Sequential number for the person within the team | Number | Long Integer |
| PERSONID | The ID of the Team member. Links to PersonID in Persons | Number | Long Integer |
| ADDRID | The ID of the address of the team member for the purposes of this event, Link to Address table | Number | Long Integer |
| MEMROLE | The role of the person within the team. Controlled vocab, by link to FLDTYPE in UDFLDS | Number | Long Integer |
UDFLDS Table Entries v5.6
| FLDNO | FTABLE | FTYPE | FCODE | FNAME | FDESC |
| 1800 | EVENTMEM | MEMROLE | Collector | Collector | A member of a collecting team |
| 1801 | EVENTMEM | MEMROLE | Donor | Donor | Donor of a batch of seed to IRRI |
| 1802 | EVENTMEM | MEMROLE | Requestor | Person requesting seed | Person who places a seed request |
| 1803 | EVENTMEM | MEMROLE | Recipient | Person receiving seed | Person who will be the final recipient of a shipment of seed |
| 1804 | EVENTMEM | MEMROLE | Supervisor | Supervisor of requestor | Person who supervises requestor |
| 1805 | EVENTMEM | MEMROLE | Authorizer | Authorizer of requestor | Person who authorizes a shipment and the institution\'s acceptance of the SMTA |
| 1806 | EVENTMEM | MEMROLE | Addressee | Addressee of shipment | Person to whom a shipment is addressed |
| 1807 | EVENTMEM | MEMROLE | EntryPort | Port of entry | Port of entry for a shipment into the country |
Legend:
| (gray cell) | Already existing field/entry |
| (yellow cell) | New field/entry to be added |
| (gold cell) | Replace existing entry with this new code/size |
Notes:
Table name TEAMMEM changed to EVENTMEM. EVENTMEM identifies a team of people associated with an event. Team members have roles and may have temporary addresses that are different from their normal addresses.
