| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | POLICY_VER_ID | Policy ID | nvarchar | 32 | 0 | | | | Allow NULL? |
| 3 | POLICY_ID | Policy ID | nvarchar | 32 | 0 | | | | Allow NULL? |
| 4 | VALID_FROM | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | VALID_TO | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | POLICY_NAME | Title/Short Name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 7 | POLICY_DESC_G | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | | | Allow NULL? |
| 8 | POLICY_PURPOSE_G | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | | | Allow NULL? |
| 9 | VERSION_NUM | Policy Version Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | NOTES_G | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | | | Allow NULL? |
| 11 | EXCLUSION_G | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | | | Allow NULL? |
| 12 | CREATED_BY | User Name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 13 | CREATED_TIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 14 | CHANGED_BY | User Name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 15 | CHANGED_TIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 16 | REV_DUEDATE | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | APPRO_DUEDATE | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | PUBLISH_DATE | Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | REVSION_DATE | Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | POLICY_CATEG | Policy Category | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | SURV_TEMPL | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | | | Allow NULL? |
| 22 | QUIZ_TEMPL | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | | | Allow NULL? |
| 23 | ACKN_TEMPL | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | | | Allow NULL? |
| 24 | SURV_AVAIL | Indicator | char | 1 | 0 | | | | Allow NULL? |
| 25 | QUIZ_AVAIL | Indicator | char | 1 | 0 | | | | Allow NULL? |
| 26 | ACKN_AVAIL | Indicator | char | 1 | 0 | | | | Allow NULL? |
| 27 | STAT_OBJNR | GUID of a CRM Order Object | varbinary | 16 | 0 | | | | |
| 28 | STATUS | System status | nvarchar | 5 | 0 | | | | Allow NULL? |
| 29 | STATUS_TXT | Object status | nvarchar | 30 | 0 | | | | Allow NULL? |
| 30 | CURRENT_PERIOD | Sequence | nvarchar | 3 | 0 | | | | Allow NULL? |
| 31 | REV_NTFY_DATE | Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | MASTER_OBJECT | Object ID | nvarchar | 50 | 0 | | | | Allow NULL? |
| 33 | APP_SURVEY_ID | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | | | Allow NULL? |
| 34 | WF_STARTED | Indicator | char | 1 | 0 | | | | Allow NULL? |
| 35 | SCOPE_VIEW | Organization View ID | nvarchar | 3 | 0 | | | | Allow NULL? |
| 36 | DIST_LANGU | Distribution language | char | 1 | 0 | | | | Allow NULL? |