| 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 GUID | varbinary | 16 | 0 | | | | |
| 3 | OBJECT_ID | ID of an SRM Survey Participant | 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 | EVAL_CATEGORY | Survey Evaluation Category | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | PHONE | Survey Participant telephone number | nvarchar | 30 | 0 | | | | Allow NULL? |
| 10 | PLANT | Survey Participant Plant/Location | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | ROLE | Survey Participant Role | nvarchar | 35 | 0 | | | | Allow NULL? |
| 12 | PTYPE | Type of a Participant of a SRM Survey | char | 1 | 0 | | | | Allow NULL? |
| 13 | SUPPLIER_ID | ID of an SRM Supplier | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | SURVEY_GUID | Survey Guid | varbinary | 16 | 0 | | | | |
| 15 | PARMAS_GUID | Survey Participant Master Guid | varbinary | 16 | 0 | | | | |
| 16 | UWS_REC_ID | GUID | nvarchar | 32 | 0 | | | | Allow NULL? |
| 17 | CREATED_AT | Created At (Output in User Time Zone) | decimal | 15 | 0 | | | | |
| 18 | CREATED_BY | User that Created the Transaction | nvarchar | 12 | 0 | | | | Allow NULL? |
| 19 | CHANGED_AT | Changed At (Output in User Time Zone) | decimal | 15 | 0 | | | | |
| 20 | CHANGED_BY | Transaction Last Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |