SUDS Data Dictionary
APEX_PUBLIC_USER
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
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
Allowed Values
Edit Values
Go
Actions
Submission Code
Ascending
Table name
Diagnostic Code
Diagnostic Message
Error Level
Error Description
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
Prior Database Information:
Physical Description:
DATE
Short Name:
DTRANK
Column Name:
DATE_OF_RANK_FAC
---
Sign Out
Search
Search