PointInTimeReport

13143 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PointInTimeReport_Id int identity 4 √ null
EmployeeName varchar 255 null
EmployeeNumber varchar 255 null
SSN_Unformatted varchar 14 null
EffectiveDate datetime 16,3 null
CompanyCode varchar 255 null
CompanyName varchar 255 null
EmploymentStatusCode varchar 255 null
Status varchar 255 null
JobCode varchar 255 null
JobDescription varchar 2147483647 null
EmploymentTypeCode varchar 50 null
EmploymentType varchar 2147483647 null
Full_PartTimeCode varchar 5 null
Full_PartTime varchar 255 null
Hourly_SalariedCode varchar 5 null
Hourly_Salaried varchar 255 null
OrgLevel1Code varchar 20 null
OrgLevel1 varchar 255 null
OrgLevel2Code varchar 20 null
OrgLevel2 varchar 255 null
OrgLevel3Code varchar 20 null
OrgLevel3 varchar 255 null
OrgLevel4Code varchar 20 null
OrgLevel4 varchar 255 null
PayGroupCode varchar 50 null
PayGroup varchar 255 null
ProjectCode varchar 50 null
Project varchar 255 null
HireSourceCode varchar 50 null
HireSource varchar 255 null
BirthDate datetime 16,3 null
OriginalHire datetime 16,3 null
LastHireDate datetime 16,3 null
GenderCode varchar 1 null
Gender varchar 6 null
Age_Years varchar 2 null
Job_Alternate varchar 255 null
SupervisorName_FirstMILastSuffix_History varchar 255 null
SupervisorEmployeeNumber_History varchar 255 null
LocalUnionCode varchar 50 null
LocalUnion varchar 255 null
NationalUnionCode varchar 50 null
NationalUnion varchar 255 null
Ethnicity varchar 255 null
HeadcountMonth datetime 16,3 null
TurnoverMonth datetime 16,3 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_PointInTimeReport_Population_InformationR
Source_System_Id int 4 √ null
Source_System.Source_System_id FK_UltiPro_PointInTimeReport_Source_SystemR

Indexes

Constraint Name Type Sort Column(s)
PK_PointInTimeReport Primary key Asc PointInTimeReport_Id

Relationships

Close relationships within degrees of separation