v_RetentionData

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
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
RetentionMonth varchar 10 √ null
Month int 4 √ null

View Definition

Possibly Referenced Tables/Views