| Entity | SubSector |
| Key property | SubSectorID |
| Property starting with C | |||||||||
| Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| CreatedDate | Date | CreatedDate | |||||||
| Creator | Number | Creator | |||||||
| Property starting with D | |||||||||
| Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| Description | Description | Description | String |
|
Description | ||||
| Property starting with I | |||||||||
| Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| ID | Number | ID | |||||||
| Property starting with M | |||||||||
| Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| ModifiedDate | Date | ModifiedDate | |||||||
| Modifier | Number | Modifier | |||||||
| Property starting with P | |||||||||
| Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| PolicyDocumentCreatedBy | PolicyDocCreatedBy | PolicyDocCreatedBy | String | PolicyDocumentCreatedBy | |||||
| PolicyDocumentID | Document | Document | GUID | PolicyDocumentID | |||||
| PolicyDocumentSubject | PolicyDocSubject | PolicyDocSubject | String | PolicyDocumentSubject | |||||
| Property starting with S | |||||||||
| Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| SectorDescription | Description | Description | String | SectorDescription | |||||
| SectorID | Sector | Sector | Number |
|
SectorID | ||||
| SubSectorID | SubSectorID | SubSectorID | String |
|
SubSectorID | ||||
| Property starting with C | |||||||||||||||||
| Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values |
| CreatedDate | Created | Date | 0 | 0 | NOW | ||||||||||||
| Creator | CreatedBy | Number | 10 | 0 | HUMRESID |
|
|||||||||||
| Property starting with D | |||||||||||||||||
| Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values |
| Description | Description | String |
|
60 | 0 | ||||||||||||
| Property starting with I | |||||||||||||||||
| Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values |
| ID | IDCol | Number | 10 | 0 |
|
||||||||||||
| Property starting with M | |||||||||||||||||
| Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values |
| ModifiedDate | Modified | Date | 0 | 0 | NOW | ||||||||||||
| Modifier | ModifiedBy | Number | 10 | 0 | HUMRESID |
|
|||||||||||
| Property starting with P | |||||||||||||||||
| Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values |
| PolicyDocumentCreatedBy | PolicyDocCreatedBy | String | 64 | 0 | |||||||||||||
| PolicyDocumentID | PolicyDocId | GUID | 16 | 0 | |||||||||||||
| PolicyDocumentSubject | PolicyDocSubject | String | 255 | 0 | |||||||||||||
| Property starting with S | |||||||||||||||||
| Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values |
| SectorDescription | SectorDescription | String | 60 | 0 | |||||||||||||
| SectorID | SectorID | Number |
|
10 | 0 | SELECT TOP 1 ID FROM cisect ORDER BY ID | |||||||||||
| SubSectorID | SubSectorID | String |
|
10 | 0 | ||||||||||||