PointInTime_YearStart_DELETE

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
EmployeeName varchar 150 √ null
EmployeeNumber varchar 20 null
EffectiveDate datetime 16,3 √ null
CompanyCode varchar 10 null
CompanyName varchar 150 √ null
EmploymentStatusCode varchar 50 √ null
Status varchar 50 √ null
JobCode varchar 50 √ null
JobDescription varchar 150 √ null
EmploymentTypeCode varchar 50 √ null
EmploymentType varchar 50 √ null
FullPartTimeCode varchar 20 √ null
FullPartTime varchar 20 √ null
HourlySalariedCode varchar 20 √ null
HourlySalaried varchar 20 √ null
ShiftCode varchar 20 √ null
Shift varchar 50 √ null
SeasonalWorker varchar 20 √ null
Annual float 8 √ null
OrgLevel1Code varchar 50 √ null
OrgLevel1 varchar 100 √ null
OrgLevel2Code varchar 50 √ null
OrgLevel2 varchar 100 √ null
OrgLevel3Code varchar 50 √ null
OrgLevel3 varchar 100 √ null
OrgLevel4Code varchar 50 √ null
OrgLevel4 varchar 100 √ null
PayGroupCode varchar 20 √ null
PayGroup varchar 100 √ null
ProjectCode varchar 100 √ null
Project varchar 100 √ null
HireSourceCode varchar 100 √ null
HireSource varchar 150 √ null
BirthDate datetime 16,3 √ null
OriginalHire datetime 16,3 √ null
LastHireDate datetime 16,3 √ null
GenderCode varchar 20 √ null
Gender varchar 20 √ null
AgeYears int 4 √ null
JobAlternate varchar 150 √ null
SupervisorName varchar 150 √ null
SupervisorEmployeeNumberHistory varchar 50 √ null
LocalUnionCode varchar 50 √ null
LocalUnion varchar 150 √ null
NationalUnionCode varchar 50 √ null
NationalUnion varchar 150 √ null
Ethnicity varchar 100 √ null
HeadcountDate datetime 16,3 √ null
TurnoverDate datetime 16,3 √ null
year int 4 (CONVERT([int],datepart(year,getdate())))
TermDate datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PK__PointInT__B7FCAE8EF64EA75F Primary key Asc/Asc/Asc EmployeeNumber + CompanyCode + year

Diagram producer might be missing

No diagrams were produced please see application output for any errors