Sequence number used to determine the order that the list of values will display in the application drop down list.

EFFECTIVE_DT

Indexed - no
Format - date
May be null? yes

The effective start date of the lookup table value.

Indexed - no
Format - date
May be null? yes

The effective end date of the lookup table value.

Indexed - yes (primary key)
Format - number(12)
May be null? no

Indexed - no
Format - varchar2(200)
May be null? yes

Indexed - no
Format - varchar2(100)
May be null? yes

Indexed - no
Format - date
May be null? no

Indexed - no
Format - varchar2(12)
May be null? no

Valid values:
Action approved - post meeting; action was 
      approved by PSC/PSCS)
Action declined - post meeting; action was 
      declined by PSC/PSCS
Action deferred - post meeting; decision on 
      the action has been deferred
Scheduled for meeting - assigned to a 
      specific meeting
Approved for PSC/PSCS submission - action has 
      passed audit and is ready to be scheduled for 
      a meeting
Returned to school for action - returned to 
      school due to missing or inaccurate 
      information
Under audit review - under review by the 
      Provost's Office for accuarcy and 
      completeness
Draft - not yet submitted to the Provost's Office

Examples: Appointment, Chair Designation, Leave of Absence

Note: NAME_FRIENDLY_PLURAL contains the plural version of the value in the NAME_FRIENDLY column.

Valid values:
Local
Office
Permanent

Valid values:
Full
Partial
Without

Valid values:
Primary
Secondary
Joint (administering)
Joint (non-administering)
PIK (administering)
PIK (non-adminstering)
Not applicable

The Payroll system employee type for the employee, for the job. This code can be used to distinguish whether the individual is a monthy, weekly, full-time, paid professional, support staff or student employee.

Note: An employee with more than one job (for example, a faculty member who also has an administrative job) may have more than one value for Appt_Employee_Type.

Examples: Exempt Salaried - Professional, administrative, and faculty (monthly paid); Exempt Salaried Student (monthly paid)

Valid values:
Full
Partial
Without

The appointment track associated with the proposed action, as used in the text minutes.

Valid values:
Standing Faculty
Standing Faculty C-E
Associated Faculty
Academic Support Staff

Emeritus

Valid values:
Department
Endowed
Endowed Term
Term
Endowed-PIK

FIS_ACTION.CORRECTION

(Referred to in the Business Objects universe as Correction Reason)

Valid values:
Change in previously approved minute
Change in the effective date
Change in the period of appointment
Correction

Indicates the type of commitment made.

Examples: Computer, Equipment, Lab Space

The name of the discipline associated with an action, used only in conjunction with select departments.

The description of the education level associated with a degree type.

Examples: No academic credentials, Bachelor's Degree, Doctor of Philosophy (Ph.D.)

Valid values:
Primary
Alternate

The description of the ethnicity associated with a faculty member.

Valid values:
Asian
Black/African American
Declined to Identify
Hispanic/Latino
Native American
Other
Pacific Islander
White/Caucasian

Valid values:
Male

Female
Unknown

FIS_ACTION. JOB_CLASS_TITLE; FIS_ACTION.
PROPOSED_JOB_CODE

Maps the job class for the action to the title as used in the text minutes.

Examples: Professor C-E, Wistar Institute Associate Professor

FIS_HOSP_AFFIL_ACTION.
HOSPITAL_AFFIL_ID

The full name of a hospital that may be affiliated with an action.

Examples: the Children's Hospital of Philadelphia, the Veteran's Administration Medical Center

Valid values:
Appropriate - Commensurate with 
     LOA salary level %
Full
None
Paid by 3rd Party
Paid by employee

Valid values:
Automatic Accrual
Automatic Accrual - RID
LOA Action Debit
Accrual Eligible
Manual Adjustment

Valid values:

Full
None
Partial

Valid values:
Department
Grants
Leave Budget
Other

Valid values:
Current
Future
Historic
Pending

Valid values:
Medical
Scholarly
Compressed Scholarly
Employment Elsewhere
Administrative
Faculty Master

Valid values:
Divorced
Married
Single
Unknown
Widow or widower

Valid values:
Not Reviewable
Reviewable
Closed to Review
Done
Cancelled

Valid values:
PSC
PSCS
Trustees

Valid values:
US Navy
US Marine Corps
US Marine Corps Reserve
Naval Reserve Officers Training Corps

Valid values:
Office
Cell
Local
Permanent
Fax

Valid values:
Administrative
Permanent Residency
PhD
Visa

Valid values:
serious illness or injury
child care
elder care
faculty anticipating a move to 
    emeritus status

Valid values:
Yes
Discuss - have some questions
Maybe - unsure / leaning towards no

Valid values:
Childbirth
Caring for family member
Personal illness
Reduction in duties 
Trustees Resolution of 6/17/2005

Valid values:
1 Granted
2 Restricted
3 Under final consideration
4 Denied
5 Accruing
6 Research or clin prob
7 Not in prob status
8 Snr clin - no more prob
9 Snr research - no more prob

Valid values:
Position Discontinued
Lack of Funding
Completion of Contract
End of Appointment
Not Qualified
Excessive Unexcused Absence
       or Tardiness
Unsatisfactory Performance
Misconduct or Violation of Rules
Other
Normal Retirement
Early Retirement
Accepted New Job (Academic)
Accepted New Job (Non-Academic)
Marriage or Domestic Obligations
Dissatisfied with Pay
Personal Reasons
Quit without Notice
Relocation
Returned to School
Dissatisfied with Working
       Conditions
Student Job Ended
Medical Necessity
Death

Valid values:
Non-Voting
Partial Voting rights
Full Voting rights