| Entity | SubSector |
| Key property | SubSectorID |
| Property starting with C | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| CreatedDate | Date | |||||||
| Creator | Number | |||||||
| Property starting with D | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| Description | Description | Description | String |
|
||||
| Property starting with I | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| ID | Number | |||||||
| Property starting with M | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| ModifiedDate | Date | |||||||
| Modifier | Number | |||||||
| Property starting with P | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| PolicyDocumentCreatedBy | PolicyDocCreatedBy | PolicyDocCreatedBy | String | |||||
| PolicyDocumentID | Document | Document | GUID | |||||
| PolicyDocumentSubject | PolicyDocSubject | PolicyDocSubject | String | |||||
| Property starting with S | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| SectorDescription | Description | Description | String | |||||
| SectorID | Sector | Sector | Number |
|
||||
| SubSectorID | SubSectorID | SubSectorID | String |
|
||||
| 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 | ||||||||||||