- DATA VIEW NAME
- EMPLOYEE_DEGREE
- OVERVIEW
- EMPLOYEE_DEGREE displays a listing of degree(s), name of institution(s), location of the institutions and date of receipt of degree for a given person
- LOAD FREQUENCY
- The data will be refreshed weekly on Friday evening.
- 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 - None.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 02/2007 – New view created. C4j
10/2007 – Data Custodian change.
11/2011 – Data Custodian Change c4j. - 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 |
|---|---|---|
| *PERSON_ID | VARCHAR(8) | A unique number assigned to a person. It is always the same. |
| *SEQ_NBR | VARCHAR(2) | A sequential number by Person_Id used to determine a unique employee degree. |
| PERSON_NAME | VARCHAR(30) | A person’s full name in the format last name, first name, middle initial. |
| DEGREE_YEAR_MONTH | VARCHAR(6) | Date degree received Format: CCYYMM |
| DEGREE_TYPE | VARCHAR(3) | Kind of degree, i.e., BA, PHD, etc |
| SCHOOL_CODE | VARCHAR(4) | School or Country Code (originally found in ISIS table PS_EXT_ORG_TBL) |
| INSTITUTION_DESCRSHORT | VARCHAR(10) | Short description for institution (or country) name. |
| INSTITUTION_DESCRLONG | VARCHAR(50) | Name associated with 4-byte degree_school field (may be school or country name) |
| COUNTRY_CODE | VARCHAR(3) | Standard 3-byte country code |
| COUNTRY_DESCR | VARCHAR(30) | Full name associated with Country Code. |
| CIP_CODE | VARCHAR(13) | Field of degree code |
| CIP_DESCR | VARCHAR(30) | Field of degree description. |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |