JobHistoryReport

172632 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
JobHistory_Id int identity 4 √ null
VW_UltiPro_JobHistoryReport.JobHistory_Id Implied ConstraintR
PayGroup varchar 255 √ null
EJHSystemId varchar 255 null
OrgLevel3Code varchar 255 √ null
OrgLevel3 varchar 255 √ null
OrgLevel3Desc varchar 255 √ null
EmployeeName varchar 255 √ null
SSN_Unformatted varchar 10 √ null
OriginalHireDate datetime 16,3 √ null
LastHireDate datetime 16,3 √ null
EmployeeStatus varchar 255 √ null
Job varchar 255 √ null
EmployeeType varchar 100 √ null
EjhDateTimeCreated datetime 16,3 √ null
EffectiveDate datetime 16,3 √ null
HourlyPayRate varchar 255 √ null
JobChangeReason varchar 255 √ 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_JobHistory_Population_InformationR
Source_System_Id int 4 √ null
Source_System.Source_System_id FK_UltiPro_JobHistory_Source_SystemR

Indexes

Constraint Name Type Sort Column(s)
PK_JobHistory Primary key Asc JobHistory_Id

Relationships

Close relationships within degrees of separation