dbo.GO_CompanyPositions View

GreenshadesOnline Integration Help

dbo.GO_CompanyPositions View

Collapse All

SQL Objects Database > dbo Schema : dbo.GO_CompanyPositions View

Description

This Table is required for Paystub only integration.

Properties

Creation Date	7/17/2015 10:23 AM
Is Schema Bound
Encrypted
Ansi Nulls

Columns

	Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
	Position	Position ID	char	7
	Description	Description of Position	char	31
	EEOClass	1 - First/Mid-Level Officials and Managers 2 - Professionals 3 - Technicians 4 - Sales Workers 5 - Administrative Support Workers 6 - Craft Workers 7 - Operatives 8 - Laborers and Helpers 9 - Service Workers 10 - Executive / Senior Level Officials and Managers	smallint	2
	FLSAStatus	1 - Exempt 2 - Non Exempt - Salary 3 - Non Exempt - Hourly	smallint	2
	ReportsToPositionCode		char	7
	ReviewSetupCode		char	31
	SkillSetNumber		int	4

See Also

Related Objects

dbo Schema
SQL Objects Database

© 2015 All Rights Reserved.

Send comments on this topic.