Page Name

Description:

Principal location of an employment resource

Coding Instructions:

Reserve records other than summer reserve do not require a value.

Load programs on EMPLOYEE_DATA table will NULL records coded ZZZZ.

Algorithm:

Usage Type:

ELEMENT

Begin Term:

192001

End Term:

Last Modified:

09-SEP-2008

SubmissionAscending	Table Name	Column name	Element ID	Tab column id	Table id	Submission name
Salary Category Detail (SCD)	EMPLOYEE_DATA (EDAT)	COUNTY_OF_EMP	21	1765	30	Salary Category Detail
Salary Category Detail (SCD)	EMPLOYEE_VACANTS (EVAC)	COUNTY_OF_EMP	21	1873	31	Salary Category Detail
University Employee/OPS (EMPL)	EMPLOYEE_DATA (EDAT)	COUNTY_OF_EMP	21	1765	30	University Employee/OPS

Excel code	Code	Description	Grouping
'.	.	MISSING	-
'0000	0000	Not Required
'ALAC	ALAC	Alachua
'BAKE	BAKE	Baker
'BAY	BAY	Bay
'BRAD	BRAD	Bradford
'BREV	BREV	Brevard
'BROW	BROW	Broward
'CALH	CALH	Calhoun
'CHAR	CHAR	Charlotte
'CITR	CITR	Citrus
'CLAY	CLAY	Clay
'COLL	COLL	Collier
'COLU	COLU	Columbia
'DADE	DADE	Dade
'DESO	DESO	Desoto
'DIXI	DIXI	Dixie
'DUVA	DUVA	Duval
'ESCA	ESCA	Escambia
'FLAG	FLAG	Flagler
'FRAN	FRAN	Franklin
'GADS	GADS	Gadsden
'GILC	GILC	Gilchrist
'GLAD	GLAD	Glades
'GULF	GULF	Gulf
'HAMI	HAMI	Hamilton
'HARD	HARD	Hardee
'HEND	HEND	Hendry
'HERN	HERN	Hernando
'HIGH	HIGH	Highlands

Select Pagination

Submission CodeAscending	Table name	Diagnostic Code	Diagnostic Message	Error Level	Error Description
EMPL	EMPLOYEE_DATA	0008	Missing or Invalid Value	9	Critical Error: may cause submission to be rejected
EMPL	EMPLOYEE_DATA	0581	When Employment Resource Code is equal to 'E' the County of Employment cannot equal 0000	9	Critical Error: may cause submission to be rejected
EMPL	EMPLOYEE_DATA	6029	COUNTY_OF_EMP is nulled if = 'ZZZZ'	1	Generated or Modified during SUDS Edit Process
SCD	EMPLOYEE_DATA	0008	Missing or Invalid Value	9	Critical Error: may cause submission to be rejected
SCD	EMPLOYEE_DATA	0581	When Employment Resource Code is equal to 'E' the County of Employment cannot equal 0000	9	Critical Error: may cause submission to be rejected
SCD	EMPLOYEE_DATA	6029	COUNTY_OF_EMP is nulled if = 'ZZZZ'	1	Generated or Modified during SUDS Edit Process
SCD	EMPLOYEE_VACANTS	0008	Missing or Invalid Value	9	Critical Error: may cause submission to be rejected
SCD	EMPLOYEE_VACANTS	0027	When Employment Resource Code = (A,V,E) the County of employment must not = 0000	9	Critical Error: may cause submission to be rejected

Physical Description:

VARCHAR2(4)

Short Name:

CNTYEMPL

Column Name:

COUNTY_OF_EMP

Associated Submissions, Tables, and Columns