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

Faculty 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.

FIS_ACTION
Table   Elements

FIS_ADDRESS
Table   Elements

FIS_COMMITMENTS
Table   Elements

FIS_COMMITTEE
Table   Elements

FIS_COMMITTEE_FACULTY
Table   Elements

FIS_CONTINGENCY
Table   Elements

FIS_DEGREE
Table   Elements

FIS_DEGREE_TYPE_LIST
Table   Elements

FIS_EMAIL
Table   Elements

FIS_FACULTY
Table   Elements

FIS_GRAD_GROUP
Table   Elements

FIS_GRAD_GROUP_DEPTS
Table   Elements

FIS_GRAD_GROUP_FACULTY
Table   Elements

FIS_HOSP_AFFIL_ACTION
Table   Elements

FIS_LOA_BENEFIT_FUNDING
Table   Elements

FIS_LOA_CREDIT
Table   Elements

FIS_LOA_SALARY_FUNDING
Table   Elements

FIS_MEETING
Table   Elements

FIS_PHONE
Table   Elements

FIS_REVIEW
Table   Elements

FIS lookup tables (used to decode elements in FIS tables):
FIS_ACTION_STATUS_LOOKUP FIS_LOA_EVENT_TYPE_LOOKUP
FIS_ACTION_TYPE_LOOKUP FIS_LOA_SALARY_LEVEL_LOOKUP
FIS_ADDRESS_TYPE_LOOKUP FIS_LOA_SAL_FUND_TYPE_LOOKUP
FIS_APPT_BENEFIT_LEVEL_LOOKUP FIS_LOA_STATUS_LOOKUP
FIS_APPT_CLASSIFICATION_LOOKUP FIS_LOA_TYPE_LOOKUP
FIS_APPT_EMPLOYEE_TYPE_LOOKUP FIS_MARITAL_STATUS_LOOKUP
FIS_APPT_SALARY_LEVEL_LOOKUP FIS_MEETING_STATUS_TYPE_LOOKUP
FIS_APPT_TRACK_LOOKUP FIS_MEETING_TYPE_LOOKUP
FIS_CHAIR_TYPE_CODE_LOOKUP FIS_MILITARY_BRANCH_LOOKUP
FIS_CHANGE_REASON_LOOKUP FIS_PHONE_TYPE_LOOKUP
FIS_COMMITMENT_TYPE_LOOKUP FIS_PIK_HOSP_AFFIL_ACTION
FIS_DISCIPLINE_LIST FIS_PSC_CONTINGEN_TYPE_LOOKUP
FIS_ED_LEVEL_LIST FIS_REDUCTION_LOOKUP
FIS_EMAIL_TYPE_LOOKUP FIS_REVIEW_LOOKUP
FIS_ETHNICITY_LOOKUP FIS_TENURE_EXT_CODE_LOOKUP
FIS_GENDER_LOOKUP FIS_TENURE_STATUS_LOOKUP
FIS_HOSPITAL_LOOKUP FIS_TERMINAT_REASON_CD_LOOKUP
FIS_JOB_CLASS FIS_VOTING_RIGHTS_CODE_LOOKUP
FIS_LOA_BENEFIT_LEVEL_LOOKUP  

Related Employee data included in the Faculty Information System universe:
COUNTRY_CODE
Table   Element
  EMPLOYEE
Table   Elements
EMPLOYEE_GENERAL
Table   Elements
JOB_CLASS_GENERAL
Table   Elements
  MAIL_CODE
Table   Elements
 


Related GL reference tables included in the Faculty Information SYstem universe:

ORG_CODES
Table   Element

 

  Collection Information:


top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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