http://dbshelp.devio.at/index.php?action=history&feed=atom&title=HumanResources.Departmenttable 2026-06-09T21:18:26Z Revision history for this page on the wiki MediaWiki 1.30.0 http://dbshelp.devio.at/index.php?title=HumanResources.Departmenttable&diff=2563&oldid=prev 2010-06-23T22:07:56Z

<p>New page: == wikibot == {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot; |- valign=&quot;top&quot; | &#039;&#039;&#039;Table | HumanResources.Department |- valign=&quot;top&quot; | &#039;&#039;&#039;Description | Look...</p> <p><b>New page</b></p><div>== wikibot ==<br /> <br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- valign=&quot;top&quot;<br /> | '''Table<br /> | HumanResources.Department<br /> |- valign=&quot;top&quot;<br /> | '''Description<br /> | Lookup table containing the departments within the Adventure Works Cycles company.<br /> |}<br /> <br /> === Columns ===<br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- style=&quot;background:silver&quot;<br /> | '''Column<br /> | '''Data Type<br /> | '''Nullable<br /> | '''Default<br /> | '''Description<br /> <br /> |- valign=&quot;top&quot;<br /> | DepartmentID<br /> | smallint<br /> | not null<br /> | <br /> | Primary key for Department records.<br /> |- valign=&quot;top&quot;<br /> | Name<br /> | dbo.Name<br /> | not null<br /> | <br /> | Name of the department.<br /> |- valign=&quot;top&quot;<br /> | GroupName<br /> | dbo.Name<br /> | not null<br /> | <br /> | Name of the group to which the department belongs.<br /> |- valign=&quot;top&quot;<br /> | ModifiedDate<br /> | datetime<br /> | not null<br /> | (getdate())<br /> | Date and time the record was last updated.<br /> |}<br /> <br /> === Primary Key ===<br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- style=&quot;background:silver&quot;<br /> | '''Primary Key<br /> | '''Columns<br /> |- valign=&quot;top&quot;<br /> | PK_Department_DepartmentID<br /> | DepartmentID<br /> |}<br /> <br /> === Indexes ===<br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- style=&quot;background:silver&quot;<br /> | '''Index<br /> | '''Type<br /> | '''Columns<br /> <br /> |- valign=&quot;top&quot;<br /> | AK_Department_Name<br /> | Unique<br /> | Name<br /> |}<br /> <br /> === Detail Tables ===<br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- style=&quot;background:silver&quot;<br /> | '''Detail Table<br /> | '''Column<br /> | '''Referencing Column<br /> <br /> |- valign=&quot;top&quot;<br /> | [[HumanResources.EmployeeDepartmentHistory_(table)|HumanResources.EmployeeDepartmentHistory]]<br /> | DepartmentID<br /> | DepartmentID<br /> |}<br /> <br /> === References ===<br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- style=&quot;background:silver&quot;<br /> | '''Dependency Type<br /> | '''Object Type<br /> | '''Referenced Object<br /> <br /> |- valign=&quot;top&quot;<br /> | Data Type<br /> | Type<br /> | [[dbo.Name_(type)|dbo.Name]]<br /> <br /> |- valign=&quot;top&quot;<br /> | Schema<br /> | Schema<br /> | [[HumanResources_(schema)|HumanResources]]<br /> <br /> |}<br /> <br /> === Dependencies ===<br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- style=&quot;background:silver&quot;<br /> | '''Reference Type<br /> | '''Object Type<br /> | '''Referencing Object<br /> <br /> |- valign=&quot;top&quot;<br /> | Select<br /> | View<br /> | [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]]<br /> <br /> |- valign=&quot;top&quot;<br /> | Select<br /> | View<br /> | [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]]<br /> <br /> |}</div>

Bot