Penn Computing

Penn Computing

Computing Menu Computing A-Z
Computing Home Information Systems & Computing Penn

  
  UPDATES
Current Load Status
Regular Availability
  
  INFORMATION
FAQs & Tips
Password Changer
Support services
Security
About the Data Warehouse
Data Administration
  
  DATA COLLECTIONS
Advancement
Assets
BRIM
Express Mail
Facilities
Faculty
GAR
General Ledger
Infrastructure
ISSS-iOffice
Learning Management
Position Inventory
Research-PennERA Proposals
Salary Management
Student
Travel Expense Management
Tuition Distribution
Cross-Collection

Career Tracker Collection Tables & Data Elements

Tables are listed in alphabetical order. Select Table to obtain the explantion, common uses, primary keys, indexed data elements, and related tables for a table. Select Elements to obtain the definition, list of values, formats, and not null values for each data element in the table. A description of table and data element terminology is in the document What the Warehouse Contains.

Career Tracker Data Tables

CT_ADDRESS
Table    Elements

CT_AFFILIATION
Table    Elements

CT_EMAIL
Table    Elements

CT_INSTITUTION
Table    Elements

CT_INSTITUTION_TAG
Table    Elements

CT_JOB_HISTORY
Table    Elements

CT_PHD_RECORD
Table    Elements

CT_PHONE
Table    Elements

CT_STUDENT
Table    Elements

CT_STUDENT_SUPERVISOR
Table    Elements


Tables not included:

CT_DEPT_STAFF
CT_INST_POSITION_TYPE
CT_FACULTY_MANUAL
CT_MAJOR_CONVERT
CT_STAFF
CT_TERM_DECODE
CT_TITLE_CHANGES

Lookup Tables

CT_ADDRESS_TYPES
Table    Elements

CT_AFFILIATION_CODE
Table    Elements

CT_CLASS_NAME
Table    Elements

CT_CLASS_TYPE
Table    Elements

CT_COUNTRY_CODE
Table    Elements

CT_DEPT
Table    Elements

CT_EMAIL_TYPES
Table    Elements

CT_EMPLOYMENT_SECTOR
Table    Elements

CT_FACULTY
Table    Elements

CT_INST_RANK
Table    Elements

CT_INST_TYPE
Table    Elements

CT_PHONE_TYPES
Table    Elements

CT_POSITION_TYPE
Table    Elements

CT_SCHOOL
Table    Elements

CT_STUDY
Table    Elements

CT_TIME_STATUS
Table    Elements

  Collection Information:
top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


Penn Computing University of Pennsylvania
Information Systems and Computing, University of Pennsylvania