PayHistoryByJobTitleReport

2483564 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PayHistoryByJobTitleReport_Id int identity 4 √ null
Pay_Group varchar 100 √ null
OrgLevel3 varchar 255 null
Employee_Name varchar 255 √ null
Pay_Date datetime 16,3 null
Job_Title varchar 255 √ null
Employee_Number varchar 255 null
SSN varchar 25 null
Employee_Type varchar 255 null
Salary_Type varchar 255 null
Current_Hours decimal 11,4 null
Earnings_Stub varchar 255 null
Current_Amount decimal 17,2 null
Ref_Value varchar 200 √ null
Insert_Date datetime 16,3 √ null
Insert_User varchar 20 √ null
Last_Update_Date datetime 16,3 √ null
Last_Update_User varchar 20 √ null
Delete_Ind bit 1 √ null
Population_Information_Id int 4 null
Population_Information.Population_Information_id FK_UltiPro_PayHistoryByJobTitle_Population_InformationR
Source_System_Id int 4 √ null
Source_System.Source_System_id FK_UltiPro_PayHistoryByJobTitle_Source_SystemR

Indexes

Constraint Name Type Sort Column(s)
PK_PayHistoryByJobTitle Primary key Asc PayHistoryByJobTitleReport_Id

Relationships

Close relationships within degrees of separation