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