| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | GUID | Participant Master GUID | varbinary | 16 | 0 | | | | |
| 3 | PARTICIPANT_ID | Participant Master ID | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | LASTNAME | Survey Participant Last Name | nvarchar | 35 | 0 | | | | Allow NULL? |
| 5 | FIRSTNAME | Survey Participant First Name | nvarchar | 35 | 0 | | | | Allow NULL? |
| 6 | EMAIL | Survey Participant email address | nvarchar | 241 | 0 | | | | Allow NULL? |
| 7 | PREF_LANGUAGE | Survey Participant Language | char | 1 | 0 | | | | Allow NULL? |
| 8 | PHONE | Survey Participant telephone number | nvarchar | 30 | 0 | | | | Allow NULL? |
| 9 | PLANT | Survey Participant Plant/Location | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | ROLE | Survey Participant Role | nvarchar | 35 | 0 | | | | Allow NULL? |
| 11 | PTYPE | Type of a Participant of a SRM Survey | char | 1 | 0 | | | | Allow NULL? |
| 12 | SUPPLIER_ID | ID of an SRM Supplier | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | PAMAGR_GUID | Participant Master Group GUID | varbinary | 16 | 0 | | | | |
| 14 | EVAL_CATEGORY | Survey Evaluation Category | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | CREATED_BY | User that Created the Transaction | nvarchar | 12 | 0 | | | | Allow NULL? |
| 16 | CREATED_AT | Created At (Output in User Time Zone) | decimal | 15 | 0 | | | | |
| 17 | CHANGED_BY | Transaction Last Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 18 | CHANGED_AT | Changed At (Output in User Time Zone) | decimal | 15 | 0 | | | | |