http://dbshelp.devio.at/index.php?action=history&feed=atom&title=HumanResources.EmployeePayHistorytable 2026-05-03T03:40:38Z Revision history for this page on the wiki MediaWiki 1.30.0 http://dbshelp.devio.at/index.php?title=HumanResources.EmployeePayHistorytable&diff=2567&oldid=prev 2010-06-23T22:08:02Z

<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.EmployeePayHistory |- valign=&quot;top&quot; | &#039;&#039;&#039;Descriptio...</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.EmployeePayHistory<br /> |- valign=&quot;top&quot;<br /> | '''Description<br /> | Employee pay history.<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 /> | EmployeeID<br /> | int<br /> | not null<br /> | <br /> | Employee identification number. Foreign key to Employee.EmployeeID.<br /> |- valign=&quot;top&quot;<br /> | RateChangeDate<br /> | datetime<br /> | not null<br /> | <br /> | Date the change in pay is effective<br /> |- valign=&quot;top&quot;<br /> | Rate<br /> | money<br /> | not null<br /> | <br /> | Salary hourly rate.<br /> |- valign=&quot;top&quot;<br /> | PayFrequency<br /> | tinyint<br /> | not null<br /> | <br /> | 1 = Salary received monthly, 2 = Salary received biweekly<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_EmployeePayHistory_EmployeeID_RateChangeDate<br /> | EmployeeID, RateChangeDate<br /> |}<br /> <br /> === Check Constraints ===<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 /> | '''Check Constraint<br /> | '''Expression<br /> | '''Description<br /> <br /> |- valign=&quot;top&quot;<br /> | CK_EmployeePayHistory_PayFrequency<br /> | ([PayFrequency]=(2) OR [PayFrequency]=(1))<br /> | Check constraint [PayFrequency]=(3) OR [PayFrequency]=(2) OR [PayFrequency]=(1)<br /> |- valign=&quot;top&quot;<br /> | CK_EmployeePayHistory_Rate<br /> | ([Rate]&gt;=(6.50) AND [Rate]&lt;=(200.00))<br /> | Check constraint [Rate] &gt;= (6.50) AND [Rate] &lt;= (200.00)<br /> |}<br /> <br /> === Foreign Keys ===<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 /> | '''Relation<br /> | '''Column<br /> | '''Referenced Column<br /> <br /> |- valign=&quot;top&quot;<br /> | [[HumanResources.Employee_(table)|HumanResources.Employee]]<br /> | EmployeeID<br /> | EmployeeID<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 /> | 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 /> | Insert<br /> | Procedure<br /> | [[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|HumanResources.uspUpdateEmployeeHireInfo]]<br /> <br /> |}</div>

Bot