Page Name

Description:

The year in which the highest educational certificate or diploma was granted to an employee.

Coding Instructions:

This element is required on all employees except those with Degree - Highest Held (DEG_HIGHEST_HELD 01112) = 'N' or 'Z'. Code blanks or '.' for these.

Load programs on EMPLOYEE_DEMO for EMPL submission will NULL value when OPS (PAY_PLAN_NUMBER < 10) and incumbent has no degree or no degree is reported (DEG_HIGHEST_HELD = 'N','Z').

Algorithm:

Usage Type:

ELEMENT

Begin Term:

192001

End Term:

Last Modified:

11-SEP-2008

SubmissionAscending	Table Name	Column name	Element ID	Tab column id	Table id	Submission name
Salary Category Detail (SCD)	EMPLOYEE_DEMO (EDEM)	DEG_YR_OF_HIGHEST	128	1675	29	Salary Category Detail
University Employee/OPS (EMPL)	EMPLOYEE_DEMO (EDEM)	DEG_YR_OF_HIGHEST	128	1675	29	University Employee/OPS

1 - 2

Submission CodeAscending	Table name	Diagnostic Code	Diagnostic Message	Error Level	Error Description
EMPL	EMPLOYEE_DEMO	0012	Non-Numeric	8	Allowable Tolerance: a 9-level critical error will be generated if the error occurs at a rate above the allowable level
EMPL	EMPLOYEE_DEMO	0688	Year must be valid and not greater than current year	9	Critical Error: may cause submission to be rejected
SCD	EMPLOYEE_DEMO	0012	Non-Numeric	9	Critical Error: may cause submission to be rejected
SCD	EMPLOYEE_DEMO	0688	Year must be valid and not greater than current year	9	Critical Error: may cause submission to be rejected

1 - 4

Physical Description:

VARCHAR2(6)

Short Name:

DEGYRHI

Column Name:

DEG_YR_OF_HIGHEST

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information:

Element: Degree - Year of Highest - 01194

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information: