- DATA VIEW NAME
- PA_REFERENCE_NUMBER
- OVERVIEW
- This data view contains Planning Allocation Reference number information by fiscal year. Data is available starting with fiscal year 1997. This view can be used in conjunction with PA_ALLOCATION to select detailed information about the allocations for any given fiscal year.
- LOAD FREQUENCY
- The view will be refreshed nightly during the planning allocation/budget cycle.
- DATA CUSTODIAN
- UW-System Budget Planning Office.
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 - None
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 11/2007 – New view created.
- DATA FORMATS
- Primary Key Columns are identified with an asterisk(*)
- Alphanumeric Data
- VARCHAR2( N) (N) = maximum length. Field contains letters and/or numbers. Trailing blanks are eliminated.
Example: VARCHAR2 (5) could contain ‘ABC12’ or ‘ABC’ or ‘A’ - Numeric Data
- NUMBER (N) (N) = length. Field contains only numbers.
NUMBER (X,Y) = format for numbers with decimal positions.
X = total number of digits
Y = the number of digits after the decimal
Examples: NUMBER (6) represents 250012 NUMBER (6,2) represents 2500.12 - Date
- DATE – Date can be in various formats. Date functions available with your query tool can be used to format the date.
Examples: DATE (YYYYMMDD), DATE (YYDDD), DATE (DD-MM-YY)
| Column Name | Format | Description |
|---|---|---|
| FISCAL_YEAR* | VARCHAR2(2) | The budget fiscal year for which the applications apply |
| OWNER_ID | VARCHAR2(2) | Identifier for the owner associated with the reference number.
The owners identified so far are: |
| REF_NUM | VARCHAR2(12) | This is a unique identifier for the allocation for each fiscal year and owner.
It can consist of letters, numbers and special characters. It should not however contain any spaces, commas or semicolons since those characters are often used as delimiters when importing and exporting data. |
| REF_NUM_DESC | VARCHAR2(120) | Narrative description of the reference number. |
| INIT_ACTION | VARCHAR2(1) | A field to indicate whether the reference number and/or allocation data should be carried into the future when the PA system is initialized for the next fiscal year.
O = One-time only |
| INIT_ACTION_DESC | VARCHAR2(30) | Description of the initialization action. |
| CATEGORY | VARCHAR2(2) | Category to which this allocation belongs.
Used to group data on reports and select a subset of reference numbers |
| CATEGORY_DESC | VARCHAR2(30) | Description of the category |
| SUB_CATEGORY | VARCHAR2(2) | Subcategory to which this allocation belongs.
Used to group data on reports and select a subset of reference numbers |
| SUB_CATEGORY_DESC | VARCHAR2(30) | Description of the sub-category |
| PARENT_REF_NUM | VARCHAR2(12) | If Owner ID is not 01, this field can be used to indicate the ‘System’ level allocation associated with allocation. |
| ROW_ENTRY_DTG | DATE | Date/time the reference number data was last updated in the Planning Allocation system |
| ROW_ENTRY_LOGONID | VARCHAR2(8) | Sign-on of person who was the last one to update the reference number data. |
| DATE_LOADED | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |