PA CURR ACT LVL

DATA VIEW NAME
PA_CURR_ACT_LVL
OVERVIEW
This is data view contains Planning Allocation information from the Planning Allocation Transaction and Reference databases. The data is for the current budget cycle.
NOTE: The data is by fiscal year, activity code, reference number, UDDS, and fund. This view contains only activities that have values. This view is filtered by UDDS. The means a person will see only the data for a particular campus(s) depending on their authorization is.
LOAD FREQUENCY
The view will be refreshed nightly during the budget cycle. Once the budget is ‘locked’ the data will not be refreshed until the next budget cycle.
DATA CUSTODIAN
UW-System Budget Planning Off
Contact: Sara Voigts
AUTHORIZATION
You must receive approval to access data from the data custodian. For information about how to get authorized for InfoAccess data views, connect to the InfoAccess Home Page
SPECIAL
CONSIDERATIONS
QUESTIONS
Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357)
LAST UPDATED
1/99 – New data view. (rzs)
12/05 – Added Init_Action field (c4j)
DATA FORMATS
The codes following the field names in this document define the field. The different types are:
Alphanumeric Data
A – Alphanumeric field. This indicates the field may contain Letters and/or numbers. The number following is the field length.
Example: a field defined as A5 could contain ‘E10LN’.
Numeric Data
N – Numeric data. This indicates the field may contain only numbers. The number following is the field length. If two digits with a decimal point in between are present the first indicates the number of positions before the decimal point and the second the number of digits after the decimal point.
Example: a field defined as N4.2 would be in the format 9999.99 whereas N6 would be in the format 999999.
Date
D – Date field — this means the field is stored a date. The format is described in the text description. The way this type of field will display in the result section of a query will be dependent upon what default the query tool you are using is set to. Some query tools default to a date/time mode which would show the data 1998-9-03 8:00 or some have a format DD-MMM-(YY)YY. Most query tools allow you to change this to a format you want but you must be aware of what the default is.
Column Name Format Description
FISCAL_YEAR A4 The budget fiscal year for which the allocations apply. This view contains only the new fiscal year budget planning allocation data. The data moves to the historical files UW_PA_HIST_ACT_LVL) and UW_PA_HIST_SUM_LVL) when the final budget year z.dot tapes are done.
LEVEL_IND A1 Indicates the level of the budget unit responsible for this record.
1 – System
2 – Campus
3 – Division
4 – Department
UDDS A7 The seven position UDDS code consisting of campus, division, department, and sub-department.

*******************Present in DDS ****************
Level Campus Division Department Sub-Dept
1 Always Blank Blank Blank
2 Always Always Blank Blank
3 Always Always Always Blank
4 Always Always Always Always

UNIT A1 The first position of the UDDS code.
DIVISION A2 The second and third positions of the UDDS code referring to division within the Campus.
DEPARTMENT A2 The fourth and fifth positions of the UDDS code referring to the department within the Campus.
FUND A4 Four character fund code. If blank, the record contains totals for all funds at this level and UDDS.
ACTIVITY_CODE A1 The activity for which dollars are allocated or the FTE type for which FTE is allocated.
0 – 9 and & — Activity
Y — Undistributed Dollars blank – FTE record for positions: Perm, Grads & Total FTEThe data elements: PERM/GRAD/TOTALS FTES must be selected on the REQUEST line in order to get the FTE amounts.(FTE data is stored in the same bucket as dollars with a blank activity. This is why FTE is added to the activity definition) NOTE: To eliminate the FTE line when not selecting Perm/Grad/Total FTE as an item on the REQUEST line the following limit should be used for the data element ACTIVITY CODE: NOT EQUIL TO ” “
PERM_FTES NS9.3 The number of FTE’s that are permanent positions. This field contains data only when the activity code – blank otherwise it is zero.
GRAD_FTES NS9.3 The number of FTE’s that are graduate assistant positions. This field contains data only when the activity code – blank, otherwise it is zero.
TOTAL_FTE NS9.3 The sum of the permanent and graduate assistant FTE’s This field contains data only when the activity code-blank, otherwise it is zero.
UDDS_NAME A30 This field contains the descriptive name for the UDDS.
DOLLAR_AMOUNT NS9.3 The dollar amount associated with activities. The DOLLAR AMOUNT is zero when the activity code-blank.
REFERENCE_NUMBER A10 A number assigned to every allocation. Each level has a specific number of digits. System Level is 3, Campus Level is 6, Division Level is 8 and Department Level is 10.

Level Reference Number of Digits
System 1 123
Campus 2 123456
Division 3 12345678
Department 4 1234567890

SUBTOTAL_INDICATOR A1 Indicates if a sub total is to be taken after this reference number.
Valid values are:
Y – Generate sub-total.
Blank – No sub-total.
CATEGORY A2 System groups reference numbers by category. Category titles are kept in the PA3024 table.
SUB_CATEGORY A1 A two-digit number that can be assigned to each reference number. Currently it is only used at System level.
DESCRIPTION_LINE_1 A58 The first line of the narrative description for each reference number. NOTE: Do NOT use {} in the description; BRIO Reports (DETAIL & PIVOT) cannot read this; “#? Don’t recognize function” will print instead of {}.
DESCRIPTION_LINE_2 A58 The second line of the narrative description for each reference number. NOTE: Do NOT use {} in the description; BRIO Reports (DETAIL & PIVOT) cannot read this; “#? Don’t recognize function” will print instead of {}.
INIT_ACTION A1 Indicates how the allocation should be copied from year to year.
Valid values are:
X – exclude from year to year copy
R – reverse entry and duplicate (renewable entry)
O – reverse entry (one time or last time for renewable entry)
Blank – default (same as X)
LOADDATE DATE The date and time these data were extracted.
Format: YYYYMMDD HH24:MI:SS
Skip to content