SUDS Data Dictionary
APEX_PUBLIC_USER
Elements
Element: Activity Portion of Person Years - 01526
Page Name
Description:
This is the activity portion of the employee's term person years expended in performing this activity during the term.
Coding Instructions:
Algorithm:
Activity Portion of Person Years is program generated using the following formula:
(FTE_ACT_PORTION 01512) / (INSTRCT_RESRCH_FTE 01501) on WORKLOAD_PERSON_FUNDING table * (PERYRS_TERM 01503) = PERYRS_ACT_PORT 01526)
Usage Type:
DERIVED
Begin Term:
192001
End Term:
Last Modified:
19-OCT-2012
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
Instruction & Research (IRD)
WORKLOAD_ACTIVITIES (WKA)
PERYRS_ACT_PORT
337
1625
28
Instruction & Research
1 - 1
Allowed Values
Edit Values
Go
Actions
No Edit Values for Element 01526
Prior Database Information:
Physical Description:
NUMBER(5,4)
Short Name:
ACTPERYR
Column Name:
ACT_PORT_PERSON_YR
---
Sign Out
Search
Search