Description: A formally or informally recognized grouping of people or organizations formed for the purpose of achieving some form of collective action
| Column Name |
Ordinal Position |
|
| Column Name |
Ordinal Position |
Referenced Table |
|
| PARTOFORGANIZATIONID |
7 |
ORGANIZATION
|
|
|
Name |
Type |
|
| 1 |
ORGANIZATIONID |
INT |
|
|
Description: The unique Id for the Organization table
|
|
Name |
Type |
|
| 2 |
UUID |
UNIQUEIDENTIFIER |
|
|
Description: The unique identifier of the organization
|
|
Name |
Type |
|
| 3 |
ORGANIZATIONNAME |
NVARCHAR |
|
|
Description: The organization name
|
|
Name |
Type |
|
| 4 |
CODE |
NVARCHAR |
|
|
Description: The organization code
|
|
Name |
Type |
|
| 5 |
DESCRIPTION |
NVARCHAR |
|
|
Description: Detailed Description
|
|
Name |
Type |
|
| 6 |
SHORTDESCRIPTION |
NVARCHAR |
|
|
Description: Short description
|
|
Name |
Type |
|
| 7 |
PARTOFORGANIZATIONID |
INT |
|
|
Description: PartOfOrganizationId is a foreign key to the Organization table
|
|
Name |
Type |
|
| 8 |
AUTHENTICATORID |
INT |
|
|
Description: The authenticator's id
|
|
Name |
Type |
|
| 9 |
LEGALAUTHENTICATORID |
INT |
|
|
Description: The legal authenticators id
|
|
Name |
Type |
|
| 10 |
ISINTERNAL |
BIT |
|
|
Description: Flag indicating an internal organization
|
|
Name |
Type |
|
| 11 |
STARTDATE |
DATE |
|
|
Description: The start date
|
|
Name |
Type |
|
| 12 |
ENDDATE |
DATE |
|
|
Description: The end date
|
|
Name |
Type |
|
| 14 |
CREATED |
DATETIME2 |
|
|
Description: Record created time
|
|
Name |
Type |
|
| 16 |
LASTMODIFIED |
DATETIME2 |
|
|
Description: Record Last Modified time
|