- DATA VIEW NAME
- PVL_DEMO_TABLE
- OVERVIEW
- The PVL Demographic Information is the first of two data views that display all position vacancy listings since the 1982 creation of the online system through PVL #35000. This view has location of position, position title, contact person, salary, etc. and displays only one (the first) UDDS code and name of the hiring department. Wherever the UDDS name is not found the field is left blank. This view can provide PVL counts within certain date ranges (released, hired, etc.). NOTE: can be used in conjunction with UW-PVL_TEXT_TABLE.
- LOAD FREQUENCY
- The data in this view is STATIC. There is no refresh cycle. It is a frozen history file
- DATA CUSTODIAN
- Human Resources Office
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 - QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 11/2000 – New view created.
10/2007 – Data Custodian change.
11/2011 – Data Custodian Change c4j . - FIELD DEFINTIONS
- Key fields are identified with an asterisk(*) Field Formats describe the field type and length.
CHAR (N) – Alphanumeric field. (N) is the length of the field. Field contains letters and/or numbers.
Example: CHAR (5) could contain ‘ABC12’ or ‘12345’ or ‘ABCDEF’
NUM (N) – Numeric field. (N) is the length of the field. Field contains only numbers.
Numbers with decimal points are represented as NUM (X.Y)
X = number of digits before the decimal, Y = the number of decimals after the decimal
Examples: NUM (4.2) could contain 2500.12
NUM (6) could contain 000005 or 550000
DATE (XXXX) – Date field. (XXXX) is the format of the field. Date can be in various formats and date functions available based on your query tool can be used against the field.
Examples: DATE (YYMMDD); DATE (YYDDD); DATE (DD-MM-YY)
| Column Name | Format | Description |
|---|---|---|
| *PVL_DEMO_KEY | CHAR (9) | This field is the key field for the PVL system. It is made up of the Personnel Office Code and a Sequential number. |
| PVL_PERSONNEL_CODE | CHAR (3) | The code of the personnel office having administrative control for filling the position: example APO = academic personnel office. |
| PVL_NUMBER | CHAR (6) | The sequential number assigned to this position vacancy |
| PVL_STATUS | CHAR (1) | The latest status of a vacant position. |
| Valid Codes: A – Position filled on basis of spousal hire N – Position filled based on sole source D – Position typically is an underutilized area R – Released for recruitment by controlling personnel office H – On hold per the Dean’s office F – All positions represented by vacancy listing have been filled W – position filled – open recruitment waived C – Cancelled V – Revised and Reposted E – Entered |
||
| *PVL_TITLE_CODE | CHAR (5) | Title code associated with this vacancy (codes include both old title codes and the new title codes that were created under Hayes-Hill). |
| PVL_TITLE_NAME | CHAR (21) | The title code long name – could be blank for old title codes. |
| PVL_APPT_TYPE | CHAR (2) | The type of Appointment vacancy. Valid Codes: FA – Faculty AS – Academic Staff LI – Limited Appointment MX – Mixed |
| PVL_UDDS_CODE | CHAR (7) | The UDDS of the hiring department |
| PVL_UDDS_NAME | CHAR (40) | The combined Name of the UDDS |
| PVL_SALARY_MIN | NUM (6.3) | Minimum salary offered for this position (if there is one). If non-hourly, the salary will be displayed as (example 25000.00). If hourly, the salary will be displayed as (example 8.15). |
| PVL_SALARY_MAX | NUM (6.3) | Maximum salary offered for this position (if there is one). |
| PVL_PAY_BASIS | CHAR (1) | Pay basis for the appointment. Valid codes: C – Academic Year (9 month appointment) A – Annual Year (12 month appointment) H – Hourly S – Summer B – 10 month academic |
| PVL_FUND | CHAR (3) | Funding source paying for this position |
| PVL_PERCENT_LO | NUM (3.3) | Minimum percent time of appointment. 100.00 being full time. |
| PVL_PERCENT_HI | NUM (3.3) | Maximum percent time of appointment. |
| PVL_DATE_AVAIL | CHAR (8) | Date the applicant can begin work. |
| PVL_CONTACT_NAME | CHAR (30) | Name of primary contact person in the department for this position. |
| PVL_CONTACT_ADDR1 | CHAR (30) | First line of contact name’s address |
| PVL_CONTACT_ADDR2 | CHAR (30) | Second line of contact name’s address |
| PVL_CONTACT_ADDR3 | CHAR (30) | Third line of contact name’s address |
| PVL_CONTACT_ADDR4 | CHAR (30) | Fourth line of contact name’s address |
| PVL_CONTACT_PHONE | CHAR (10) | Telephone number of Contact person |
| PVL_POSITION_MIN | CHAR (1) | The minimum number of positions that may be hired under this PVL. |
| PVL_POSITION_MAX | CHAR (1) | The maximum number of positions that may be hired under this PVL. |
| PVL_NEW_REPLACE | CHAR (1) | Indicates if positions being filled are new and/or replacements. Valid Codes: N – New R – Replacement B – Both new and replacement C – Position changed from classified to unclassified. |
| PVL_SALARY_QUALIF | CHAR (1) | Used to determine salary information for a position announcement.
Valid Codes: Valid Codes: Valid Codes: Valid Codes: Valid Codes: Valid Codes: Valid Codes: |
| PVL_INITIAL_QUALIF | CHAR (1) | Indicates if the position is being renewed. Valid Codes: T – Terminal Appt will not be renewed R – with possibilities of renewal |
| PVL_DEADLINE_DATE | CHAR (8) | The latest date an applicant may apply for a position to insure consideration. |
| EXTRACT_DATE | CHAR (8) | The date the data was extracted. (System generated date.) Format: YYYYMMDD |