Page Name

Description:

A code to indicate type and/or period of university submission.

Coding Instructions:

Algorithm:

Usage Type:

ELEMENT

Begin Term:

192001

End Term:

Last Modified:

08-JUL-2008

SubmissionAscending	Table Name	Column name	Element ID	Tab column id	Table id	Submission name
Salary Category Detail (SCD)	EMPLOYEE_DATA (EDAT)	SUB_TYP	377	1741	30	Salary Category Detail
Salary Category Detail (SCD)	EMPLOYEE_DEMO (EDEM)	SUB_TYP	377	1655	29	Salary Category Detail
Salary Category Detail (SCD)	EMPLOYEE_VACANTS (EVAC)	SUB_TYP	377	1845	31	Salary Category Detail
University Employee/OPS (EMPL)	EMPLOYEE_DATA (EDAT)	SUB_TYP	377	1741	30	University Employee/OPS
University Employee/OPS (EMPL)	EMPLOYEE_DEMO (EDEM)	SUB_TYP	377	1655	29	University Employee/OPS

Excel code	Code	Description	Grouping
'.	.	MISSING	-
'F	F	Fall Midterm
'J	J	JAN EOG (LAS/PBS)
'L	L	JUN EOG (LAS/PBS)
'O	O	Operating Budget
'R	R	Spring Midterm
'S	S	Special
'Z	Z	Other

1 - 8

Submission CodeAscending	Table name	Diagnostic Code	Diagnostic Message	Error Level	Error Description
SCD	EMPLOYEE_DATA	0582	Submission Type invalid for DEMO_TIME_FRAME	X	Fatal Error: must be resolved, an explanation is not acceptable
SCD	EMPLOYEE_DEMO	0582	Submission Type invalid for DEMO_TIME_FRAME	X	Fatal Error: must be resolved, an explanation is not acceptable
SCD	EMPLOYEE_VACANTS	0582	Submission Type invalid for DEMO_TIME_FRAME	X	Fatal Error: must be resolved, an explanation is not acceptable

Physical Description:

VARCHAR2(10)

Short Name:

SUBTYPE

Column Name:

SUB_TYPE

Associated Submissions, Tables, and Columns