Information for the GroupHistorical
Columns
Id
(datatype: int) Required Primary Key
GroupId
(datatype: int) Required Primary Key
GroupName
(datatype: nvarchar(100)) Required Primary Key
GroupTypeId
(datatype: int) Required Primary Key
GroupTypeName
(datatype: nvarchar(100)) Required Primary Key
CampusId
(datatype: int) Required Primary Key
ParentGroupId
(datatype: int) Required Primary Key
Description
(datatype: nvarchar(max)) Required Primary Key
ScheduleId
(datatype: int) Required Primary Key
ScheduleName
(datatype: nvarchar(max)) Required Primary Key
ScheduleModifiedDateTime
(datatype: datetime) Required Primary Key
IsArchived
(datatype: bit) Required Primary Key
ArchivedDateTime
(datatype: datetime) Required Primary Key
ArchivedByPersonAliasId
(datatype: int) Required Primary Key
IsActive
(datatype: bit) Required Primary Key
InactiveDateTime
(datatype: datetime) Required Primary Key
EffectiveDateTime
(datatype: datetime) Required Primary Key
ExpireDateTime
(datatype: datetime) Required Primary Key
CurrentRowIndicator
(datatype: bit) Required Primary Key
CreatedDateTime
(datatype: datetime) Required Primary Key
ModifiedDateTime
(datatype: datetime) Required Primary Key
CreatedByPersonAliasId
(datatype: int) Required Primary Key
ModifiedByPersonAliasId
(datatype: int) Required Primary Key
Guid
(datatype: uniqueidentifier) Required Primary Key
ForeignId
(datatype: int) Required Primary Key
ForeignGuid
(datatype: uniqueidentifier) Required Primary Key
ForeignKey
(datatype: nvarchar(100)) Required Primary Key
StatusValueId
(datatype: int) Required Primary Key