SUDS Data Dictionary
APEX_PUBLIC_USER
---
Sign Out
Home
Elements
Edits
Elements
Element: Sequence - 01797
Page Name
Description:
For OPS Reporting on EMPLOYEE_DATA Only. Ordinal number representing the OPS engagement of the encumbant for the reporting university.
Coding Instructions:
Numbers and characters can be used providing up to 36 instances per person identification number.
Algorithm:
Usage Type:
ELEMENT
Begin Term:
200508
End Term:
Last Modified:
17-SEP-2008
Associated Submissions, Tables, and Columns
Go
Actions
Submission
Ascending
Table Name
Column name
Element ID
Tab column id
Table id
Submission name
Salary Category Detail (SCD)
EMPLOYEE_DATA (EDAT)
OPS_SEQ
476
1761
30
Salary Category Detail
University Employee/OPS (EMPL)
EMPLOYEE_DATA (EDAT)
OPS_SEQ
476
1761
30
University Employee/OPS
1 - 2
Search
Allowed Values
Edit Values
Go
Actions
Submission Code
Ascending
Table name
Diagnostic Code
Diagnostic Message
Error Level
Error Description
EMPL
EMPLOYEE_DATA
0601
On OPS records the OPS_SEQ must not equal '.'
9
Critical Error: may cause submission to be rejected
1 - 1
Search
Prior Database Information:
Physical Description:
VARCHAR2(1)
Short Name:
OPSSEQ
Column Name:
OPS_SEQ