Page Name

Description:

The date the employee began working for this university. If and employee leaves and later returns to the same university, the most recent hire date should be reported.

Coding Instructions:

Load programs on the EMPLOYEE_DATA table will NULL values for OPS employees (PAY_PLAN_NUMBER < 10).

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_DEMO (EDEM)	AGENCY_HIRE_DT	24	1667	29	Salary Category Detail
University Employee/OPS (EMPL)	EMPLOYEE_DEMO (EDEM)	AGENCY_HIRE_DT	24	1667	29	University Employee/OPS

1 - 2

Submission CodeAscending	Table name	Diagnostic Code	Diagnostic Message	Error Level	Error Description
EMPL	EMPLOYEE_DEMO	0576	Missing or date is in future	9	Critical Error: may cause submission to be rejected
EMPL	EMPLOYEE_DEMO	6190	AGENCY_HIRE_DT is nulled if AGENCY_HIRE_DT < 01/01/1901	1	Generated or Modified during SUDS Edit Process
SCD	EMPLOYEE_DEMO	0576	Missing or date is in future	9	Critical Error: may cause submission to be rejected
SCD	EMPLOYEE_DEMO	6190	AGENCY_HIRE_DT is nulled if AGENCY_HIRE_DT < 01/01/1901	1	Generated or Modified during SUDS Edit Process

1 - 4

Physical Description:

DATE

Short Name:

INSTDT

Column Name:

AGENCY_HIRE_DATE

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information:

Element: University Hire Date - 01019

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information: