- DATA VIEW NAME
- PVL_UDDS
- OVERVIEW
- This view includes all position vacancy listings and all their associated hiring UDDS codes. At least one row exists for each PVL number and there can be up to five rows for each PVL based on the number of UDDS codes. This view can be used to provide PVL counts by UDDS. Be aware that a single PVL row may be counted under more than one UDDS.
- LOAD FREQUENCY
- Data is refreshed nightly (Monday through Saturday).
- DATA CUSTODIAN
- Office of Human Resources
Contact: Catharine Derubeis - 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 InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - This view should be used in conjunction with the view PVL to get all the departments associated with a PVL. Join on PVL_NUMBER only.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 07/2002 New view created.
10/2007 Data Custodian change.
11/2011 Data Custodian Change c4j . - DATA FORMAT
- 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 |
|---|---|---|
| *PVL_Number | Number (6) | A unique identifier for an individual PVL. |
| *Hiring_Dept_Code | Varchar2 (7) | A UDDS code for the hiring department on the PVL. |
| Dept_Name | Varchar2 (60) | The concatenation of the long name of the department and the abbreviated name of the division with a slash separating the two. |
| Major_Dept_Ind | Varchar2 (1) | Indicates if the hiring_dept_code is considered the ‘major’ department for the PVL. One, and only one department must be specified as the ‘major’ department on each PVL. Generally, the major department assumes responsibility for creating the PVL and its attachments. Values are: Y = Yes N = No |
| Extract_Date_Time | Date | The date and time these data were extracted from the source system |