SUDS Data Dictionary
APEX_PUBLIC_USER
---
Sign Out
Home
Elements
Edits
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
Instruction & Research (IRD)
WORKLOAD_ACTIVITIES (WKA)
PERYRS_ACT_PORT
337
1625
28
Instruction & Research
1 - 1
Search
Allowed Values
Edit Values
Go
Actions
No Edit Values for Element 01526
Search
Prior Database Information:
Physical Description:
NUMBER(5,4)
Short Name:
ACTPERYR
Column Name:
ACT_PORT_PERSON_YR