SUDS Data Dictionary
APEX_PUBLIC_USER
---
Sign Out
Home
Elements
Edits
Elements
Element: Date of Rank, Faculty - 01182
Page Name
Description:
The beginning date of the employee's current Faculty Rank. This date should correspond to the date as noted in the official notification letter from the President or his/her designee. This shall also be coded for other employees who hold Faculty Rank.
Coding Instructions:
Required on salaried employees who have a class code 9001-9178. and RANK_FAC (01028) not equal to '99'.
Load programs on EMPLOYEE_DATA will NULL value if RANK_FAC is 99 (no rank) or if CLASS_CODE is not in 9001-9178 (not in the set of faculty classes).
Algorithm:
Usage Type:
ELEMENT
Begin Term:
192001
End Term:
Last Modified:
11-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_DEMO (EDEM)
RANK_FAC_DT
127
1671
29
Salary Category Detail
University Employee/OPS (EMPL)
EMPLOYEE_DEMO (EDEM)
RANK_FAC_DT
127
1671
29
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_DEMO
6191
RANK_FAC_DT is nulled if RANK_FAC_DT < 01/01/1901
1
Generated or Modified during SUDS Edit Process
SCD
EMPLOYEE_DEMO
6191
RANK_FAC_DT is nulled if RANK_FAC_DT < 01/01/1901
1
Generated or Modified during SUDS Edit Process
1 - 2
Search
Prior Database Information:
Physical Description:
DATE
Short Name:
DTRANK
Column Name:
DATE_OF_RANK_FAC