|
InfoAccess |
|
|
DATA VIEW NAME |
EOAA_AD_STATUS_STOUT |
|
OVERVIEW |
Includes information on the recruitment process, including process tracking, applicant information, Survey of New Hires tracking, and notes |
|
LOAD FREQUENCY |
Data is refreshed daily. |
|
DATA CUSTODIAN |
Equal Opportunity/Affirmative Action - Donna Weber |
|
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 |
None |
|
QUESTIONS |
Contact: Division of Information Technology Help Desk |
|
LAST UPDATED |
02/04 – 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. |
|
Numeric Data |
NUMBER (N) (N) = length. Field contains only numbers. |
|
Date |
DATE - Date can be in various formats. Date functions available with
your query tool can be used to format the date. |
|
Column Name |
Format |
Description |
|
*SEQ_NO |
Number(15) |
Sequential number generated as a key. |
|
YEAR |
Varchar2(7) |
Year of the search |
|
PIN_LAST_DIGIT |
Number(3) |
Last 3 digits of the PIN number |
|
PIN |
Varchar2(14) |
Position identification number-unique number assigned to each search |
|
JOB_GROUP_NO |
Number(3) |
Job group number |
|
POSITION_DESC |
Varchar2(50) |
Whether the position is academic staff or faculty |
|
POSITION_TITLE |
Varchar2(100) |
Title of the position |
|
DEPARTMENT_DESC |
Varchar2(100) |
Department of the position |
|
CONTACT_NAME |
Varchar2(50) |
Contact name and phone number for the search |
|
PIN_DATE |
Date |
Date the PIN number was assigned |
|
PIN_DATE_DESC |
Varchar2(100) |
Notes on PIN_DATE if no date or not a valid date |
|
AD_GUIDE_SENT_DATE |
Date |
Date the Advertising Guide was sent to the Search Committee |
|
AD_GUIDE_SENT_DESC |
Varchar2(100) |
Notes on AD_GUIDE_SENT_DATE if no date or not a valid date |
|
ES1_RECEIVED_DATE |
Date |
Date the ES1 was received in the EO/AA office |
|
ES1_RECEIVED_DESC |
Varchar2(100) |
Notes on ES1_RECEIVED_DATE if no date or not valid date |
|
PD_AD_TO_STOUT_AAO_DATE |
Date |
Date that Sherri received the position description and advertisement |
|
PD_AD_TO_STOUT_AAO_DESC |
Varchar2(100) |
Notes on PD_AD_TO_STOUT_AAO_DATE if no date or not valid date |
|
AD_TO_OTHER_AAO_DATE |
Date |
Date that the advertisement went to the other Affirmative Action officers |
|
AD_TO_OTHER_AAO_DESC |
Varchar2(100) |
Notes on AD_TO_OTHER_AAO_DATE if no date or not valid date |
|
AD_TO_AJB_COM_DATE |
Date |
Date that the advertisement was placed on ajb.com |
|
AD_TO_AJB_COM_DESC |
Varchar2(100) |
Notes on AD_TO_AJB_COM_DATE if no date or not a valid date |
|
COMMUNITY_NEWS_DATE |
Date |
Date that the advertisement appeared in the Stout Community News |
|
COMMUNITY_NEWS_DESC |
Varchar2(100) |
Notes on COMMUNITY_ NEWS_DATE if no date or not a valid date |
|
HIGHER_ED_JOBS_COM_DATE |
Date |
Date that the advertisement appeared in Higheredjobs.com |
|
HIGHER_ED_JOBS_COM_DESC |
Date |
Notes on HIGHER_ED_JOBS_COM_DATE if no date or not a valid date |
|
SCREENING_DATE |
Date |
Date that screening begins |
|
SCREENING_DESC |
Varchar2(100) |
Notes on SCREENING_ DATE if no date or not a valid date |
|
TOOLS_RECEIVED_DATE |
Date |
Date that the tools were received for the position |
|
TOOLS_RECEIVED_DESC |
Varchar2(100) |
Notes on TOOLS_RECEIVED_DATE if no date or not a valid date |
|
APPLICANT_LIST_RECEIVED_ |
Date |
Date that the applicant list was received for the position |
|
APPLICANT_LIST_RECEIVED_ |
Varchar2(100) |
Notes on APPLICANT_LIST_RECEIVED_DATE if no date or not a valid date |
|
ES2_RECEIVED_DATE |
Date |
Date that the ES2 was received in the EO/AA office |
|
ES2_RECEIVED_DESC |
Varchar2(100) |
Notes on ES2_RECEIVED_DATE if no date or not a valid date |
|
ES3_RECEIVED_DATE |
Date |
Date that the ES3 was received in the EO/AA office |
|
ES3_RECEIVED_DESC |
Varchar2(100) |
Notes on ES3_RECEIVED_DATE if no date or not a valid date |
|
ES4_RECEIVED_DATE |
Date |
Date that the ES4 was received in the EO/AA office |
|
ES4_RECEIVED_DESC |
Varchar2(100) |
Notes on ES4_RECEIVED_DATE if no date or not a valid date |
|
ES5_RECEIVED_DATE |
Date |
Date that the ES5 was received in the EO/AA office |
|
ES5_RECEIVED_DESC |
Varchar2(100) |
Notes on ES5_RECEIVED_DATE if no date or not a valid date |
|
NAME_OF_HIRE |
Varchar2(100) |
Name of the person that was hired |
|
ETHNIC_GENDER |
Varchar2(50) |
Race/ethnicity of the person that was hired |
|
CONTRACT_HIRE_DATE |
Date |
Date that the contract begins |
|
CONTRACT_HIRE_DESC |
Varchar2(100) |
Notes on CONTRACT_HIRE_DATE if no date or not a valid date |
|
CAMPUS_PHONE |
Varchar2(50) |
Campus phone number of the person that was hired |
|
NEWHIRE_SURVEY_DATE |
Date |
Date that the Survey of New Hires was returned |
|
NEWHIRE_SURVEY_DESC |
Varchar2(500) |
Notes on NEWHIRE_SURVEY_DATE if no date or not a valid date |
|
NEWHIRE_SURVEY_ID_NO |
Varchar2(25) |
ID number of the Survey of New Hires |
|
NEWHIRE_FOLLOWUP_ |
Date |
Date that the follow-up letter was sent for the Survey of New Hires |
|
NEWHIRE_FOLLOWUP_ |
Varchar2(100) |
Notes on NEWHIRE_FOLLOWUP_LETTER_DATE if no date or not a valid date |
|
NEWHIRE_FOLLOWUP_ PH_CALL_DATE |
Date |
Date that a follow-up phone call was made for the Survey of New Hires |
|
NEWHIRE_FOLLOWUP_ PH_CALL_DESC |
Varchar2(100) |
Notes on NEWHIRE_FOLLOWUP_PH_CALL_DATE if no date or not a valid date |
|
PENDING_MISC_NOTES |
Varchar2(500) |
Miscellaneous notes related to the position |
|
LAST_UPDATE_DATE_TIME |
Date |
The date and time the data was last updated. |