| Data element |
Definition |
AA_APT_TYPE
Indexed - no
Format - number (12)
May be null - yes |
The type of appointment.
Values:
Appointment
Promotion
Termination
|
|
AA_DATA_APPROVED_DATE
Indexed - no
Format - date
May be null? yes
|
The date that Affirmative Action information pertaining to this action was approved.
|
| AA_DATA_RECEIPT_DATE
Indexed - no
Format - date
May be null? yes
|
The date that Affirmative Action information pertaining to this action was received in the Provost Office.
|
| ABD
Indexed - no
Format - varchar2(18)
May be null? yes |
All But Dissertation flag. Indicates a prospective assistant professor in the final stages of completion of the doctorate appointed as Lecturer C. |
| ACTION_ID Indexed - yes (primary key)
Format - number
May be null? no |
The unique identifier on each action. This value is assigned by the FIS system and is not visible from the application interface. It is intended solely for the internal use in the system. |
| ACTION_NOTES
Indexed - no
Format - varchar2(250)
May be null? yes |
Any miscellaneous notes associated with an action. |
| ACTION_SALARY_LEVEL
Indexed - no
Format - number(12)
May be null? no |
A numeric code indicating the salary level for the action, as stated in the minute.Use this to join to the FIS_APPT_SALARY_LEVEL_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the associated description (e.g., Full, Partial, or Without). |
| ACTION_TEMPLATE Indexed - no
Format - varchar2(60)
May be null? yes |
Indicates which language key template is used by this action. The templates are used to produce the text minutes which are used for the Trustees Meetings. |
| ACTION_TYPE
Indexed - no
Format - number(12)
May be null? no |
A numeric code indicating the type of action. This is part of what determines which type of language key will be used to build the text minutes.Use this to join to the FIS_ACTION_TYPE_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the associated description. |
| APPT_ACTUAL_END_DATE
Indexed - no
Format - date
May be null? yes |
The actual end date of the appointment. |
| APPT_APPROVED_END_DATE
Indexed - no
Format - date
May be null? yes |
The appointment end date proposed in the PSC minute. |
| APPT_BENEFIT_LEVEL
Indexed - no
Format - number(12)
May be null? no |
A numeric code indicating the benefits level granted this action as stated in the minute.Use this to join to the FIS_APPT_BENEFIT_LEVEL_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the associated description (e.g., Full, Partial, or Without). |
| APPT_BENEFIT_LEVEL_DESCRIPTION
Indexed - no
Format - varchar2(150)
May be null? yes |
Additional information pertaining to the appointment benefits level. |
| APPT_CLASSIFICATION
Indexed - no
Format - number(12)
May be null? yes |
A numeric code indicating whether an appointment is a primary appointment, secondary appointment, joint (lead), or a joint (non-lead) appointment. Use this to join to the FIS_APPT_CLASSIFICATION_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the associated description (e.g., Primary,
Secondary,
Joint (administering),
Joint (non-administering),
PIK (administering),
PIK (non-adminstering),
Not applicable). |
| APPT_DEPT
Indexed - no
Format - varchar2(200)
May be null? yes |
The discipline of the action. This may be the same as the department description initiating the action. In certain cases the discipline will include the subspecialty (e.g., Psycholgy in Psychiatry). |
| APPT_FUNDING_DEPARTMENT
Indexed - no
Format - varchar2(20)
May be null? yes |
Indicates a department which is providing the funding for an appointment, if that department is different from the appointing department. |
| APPT_RANK Indexed - no
Format - varchar2(20)
May be null? no |
A numeric code indicating the rank as used in the text minutes. Use this to join to the FIS_APPT_RANK_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the job class code description. |
| APPT_RESIGNATION_DATE
Indexed - no
Format - date
May be null? yes |
This field is not in use. |
| APPT_SALARY_LEVEL_DESCRIPTION
Indexed - no
Format - varchar2(150)
May be null? yes
|
This field is not in use. |
| APPT_START_DATE
Indexed - no
Format - date
May be null? yes |
The appointment start date proposed in the PSC minute. |
| APPT_TERM Indexed - no
Format - number
May be null? no |
The length of time of the action given in months. |
| APPT_TERM_NOTES
Indexed - no
Format - varchar2(200)
May be null? yes |
Additional information pertaining to the appointment term. |
| APPT_TRACK Indexed - no
Format - number(12)
May be null? yes |
A numeric code indicating the appointment track associated with the proposed action, as used in the text minutes.Use this to join to the FIS_APPT_TRACK_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the track description (e.g., Associated Faculty, Standing Faculty, and Standing Faculty C-E).
|
| CHAIR_NOTES
Indexed - no
Format - varchar2(200)
May be null? yes |
Additional information pertaining to the Chair designations. |
| CHAIR_TITLE
Indexed - no
Format - varchar2(100)
May be null? yes |
The title of the Chair designation. |
| CHAIR_TYPE_CODE
Indexed - no
Format - number(12)
May be null? no |
A numeric code indicating the type of Chair.Use this to join to the FIS_CHAIR_TYPE_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the track description (e.g., Department,
Endowed,
Endowed Term,
Term,
Endowed-PIK). |
| COMPLETION_DT
Indexed - no
Format - date
May be null? no |
Used to denote the date on which a contingent action has all of its contingencies satisfied. |
| CONFERENCE_ID
Indexed - no
Format - number
May be null? yes |
Numeric key used to join the action to the meeting ID. |
| CONVERT_TO_TENURE_DATE
Indexed - no
Format - date
May be null? yes |
The date of the conversion to tenure. |
| CORRECTION
Indexed - no
Format - number
May be null? yes |
A numeric code indicating the reason for a correction to the actionr.Use this to join to the FIS_CHANGE_REASON_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the reason for the change (e.g., Change in previously approved minute,
Change in the effective date,
Change in the period of appointment,
Correction).
|
| CREATE_DATE
Indexed - no
Format - date
May be null? no |
The creation date of the record. |
| CREATE_ID
Indexed - no
Format - varchar2(12)
May be null? no |
The Penn ID of the person who created the record. |
| DEPARTMENT_CODE
Indexed - no
Format - varchar2(12)
May be null? no |
The department that initiated the action. The 4-character code that represents the organization.
Examples: 0702 (Wharton Finance); 0705 (Wharton Legal Studies) |
| DISCIPLINE_CD
Indexed - no
Format - number(12)
May be null? yes
|
A numeric code indicating the appointment discipline (used only in conjunction with certain departments).Use this to join to the FIS_DISCIPLINE_LIST table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the discipline name.
|
| DISCRIMINATOR
Indexed - no
Format - char(2)
May be null? no |
|
| EMERITUS_MODIFIER
Indexed - no
Format - char(1)
May be null? yes |
A Yes/No field used to indicate if this emeritus faculty member will use the emeritus job title. Applicable only to 'Emeritus' action type. |
| EXTERNAL_ID
Indexed - no
Format - number
May be null? yes |
Used to reference actions in external systems sharing data with FIS. |
| FASDA_ID
Indexed - no
Format - number
May be null? no |
A unique system identifier assigned to each unique faculty member in the FIS_FACULTY table. This number is not used in other data collections, and should not be used for reporting. |
| FUNDING_DEPENDENT
Indexed - no
Format - varchar2(1)
May be null? yes |
A Yes/No field used to indicate if the appointment is dependent on funding. |
| JOB_CLASS_TITLE
Indexed - no
Format - varchar2(18)
May be null? yes |
The 6-digit Payroll Job Class code for the action. Refer to associated Job_Title column in DWADMIN.JOB_CLASS to find the title which currently corresponds to the Job_Class. |
| JOINT_PIK_ADMIN_BEN_PCT
Indexed - no
Format - number
May be null? yes |
The Joint/PIK appointment administering school benefits percentage. The pecentage of the benefits to be paid by the administering school. |
| JOINT_PIK_ADMIN_SAL_PCT
Indexed - no
Format - number
May be null? yes |
The Joint/PIK appointment administering school salary percentage. The pecentage of the salary to be paid by the administering school. |
| JOINT_PIK_APPT_RANK
Indexed - no
Format - varchar2(20)
May be null? yes |
The Joint/PIK appointment rank in the non-administering school.Use this to join to the FIS_APPT_RANK_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the job class code description. |
| JOINT_PIK_DEPARTMENT_CD
Indexed - no
Format - varchar2(12)
May be null? yes |
The Joint/PIK appointment department code in the non-administering school. |
| JOINT_PIK_DISCIPLINE
Indexed - no
Format - varchar2(200)
May be null? yes |
The Joint/PIK appointment discipline in the non-administering school. |
| JOINT_PIK_NONADMIN_BEN_PCT
Indexed - no
Format - number
May be null? yes |
The Joint/PIK appointment non-administering school benefits percentage. The pecentage of the benefits to be paid by the non-administering school. |
| JOINT_PIK_NONADMIN_SAL_PCT
Indexed - no
Format - number
May be null? yes |
The Joint/PIK appointment non-administering school salary percentage. The pecentage of the salary to be paid by the non-administering school. |
| JOINT_PIK_SCHOOL_CD
Indexed - no
Format - varchar2(12)
May be null? yes |
The Joint/PIK appointment school name of the non-administering school. |
| JOINT_PIK_UNIV_BEN_PCT
Indexed - no
Format - number
May be null? yes |
The Joint/PIK appointment University benefits percentage. The pecentage of the benefits to be paid by the University. |
| JOINT_PIK_UNIV_SAL_PCT
Indexed - no
Format - number
May be null? yes |
The Joint/PIK appointment University salary percentage. The pecentage of the salary to be paid by the University. |
| LAST_UPD
Indexed - no
Format - timestamp(6)
May be null? no |
The date/time when the action was last updated. |
| LOA_APPT_INSTITUTION
Indexed - no
Format - varchar2(250)
May be null? yes |
The name of the institution where leave of absence is being taken.
Example: Brookings, NYU, Harvard, Chicago |
| LOA_CREDITS_ACCRUED Indexed - no
Format - number
May be null? no |
The faculty member's balance of leave credits at the time that the action was proposed. This field does not update the LOA table used to calculate balances for reporting purposes. |
| LOA_CREDITS_BORROWED
Indexed - no
Format - number
May be null? no |
The number of credits borrowed for this LOA action, as stated in the text minutes. |
| LOA_CREDITS_USED
Indexed - no
Format - number
May be null? no |
The number of credits used for this LOA action, as stated in the text minutes. |
| LOA_END_DATE
Indexed - no
Format - date
May be null? yes |
This field is not in use; refer instead to the end date of the appointment itself. |
| LOA_NOTES
Indexed - no
Format - varchar2(250)
May be null? yes |
Additional information pertaining to the leave of absence. |
| LOA_START_DATE
Indexed - no
Format - date
May be null? yes |
This field is not in use; refer instead to the start date of the appointment itself. |
| LOA_STATUS
Indexed - no
Format - number(12)
May be null? yes |
A numeric code indicating the status of the leave of absence.Use this to join to the FIS_LOA_STATUS_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the status description (e.g., Current,
Future,
Historic,
Pending). |
| LOA_TYPE
Indexed - no
Format - number(12)
May be null? no |
A numeric code indicating the type of the leave of absence.Use this to join to the FIS_LOA_TYPE_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the status description (e.g., Medical,
Scholarly,
Compressed Scholarly,
Employment, Elsewhere,
Administrative). |
| MANDATORY_REVIEW_DATE
Indexed - no
Format - date
May be null? yes |
The latest date by which such faculty member shall be reviewed for purposes of a timely tenure decision. |
| MEET_DT
Indexed - no
Format - date
May be null? yes |
The requested meeting date for an action. |
| MILITARY_BRANCH_CD
Indexed - no
Format - number(12)
May be null? yes |
A numeric code indicating the military branch associated with ROTC actions.Use this to join to the FIS_MILITARY_BRANCH_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the military branch description (e.g., US Navy,
US Marine Corps,
US Marine Corps Reserve,
Naval Reserve Officers Training Corps). |
| MINUTES_TXT Indexed - no
Format - varchar2(3000)
May be null? yes |
The text format of minutes as presented to Board of Trustees. Text minutes were formerly used in agendas and minutes for PSC and PSCS prior to 9/2006.
Note: Minutes may included HTML markup used for display in the only FIS application. For a plain text version of the minute, refer to DWFAC.FIS_PLAIN_MINUTE_V.PLAIN_MINUTE. |
| NAME_FIRST
Indexed - no
Format - varchar2(30)
May be null? no
|
The first name of the individual, as displayed for the particular action. |
| NAME_LAST
Indexed - no
Format - varchar2(30)
May be null? no
|
The last name of the individual, as displayed for the particular action. |
| NAME_MIDDLE
Indexed - no
Format - varchar2(30)
May be null? yes
|
The middle name of the individual, as displayed for the particular action. |
| NAME_PREFIX
Indexed - no
Format - varchar2(4)
May be null? yes
|
The name prefix (e.g., Mr., Mrs., Ms., Dr., Dean) of the individual, as displayed for the particular action. |
| NAME_SUFFIX
Indexed - no
Format - varchar2(25)
May be null? yes
|
The name suffix (e.g., Jr., Sr., III) of the individual, as displayed for the particular action. |
| OFFER_LETTER_ACCEPTANCE
Indexed - no
Format - varchar2(1)
May be null? yes |
A Yes/No field indicating acceptance of the offer letter related to a given action. |
| OFFER_LETTER_ACCEPTANCE_DATE
Indexed - no
Format - date
May be null? yes |
The date of acceptance of the offer letter related to a given action. |
| PROMOTION_DATE
Indexed - no
Format - date
May be null? yes |
The date of promotion. Applicable to all faculty and staff in the FIS database. |
| PSC_PSCS_APPROVAL_REQUIRED_FL
Indexed - no
Format - varchar2(1)
May be null? yes |
A Yes/No field used to indicate whether approval by PSC or PSCS is required. |
| REDUCTION_IN_DUTIES_CD
Indexed - no
Format - number(12)
May be null? yes |
A numeric code indicating the reducation in duties reason. Use this to join to the FIS_REDUCTION_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the code description (e.g., serious illness or injury, child care, elder care, faculty anticipating a move to emeritus status). |
| REDUCTION_IN_DUTIES_END_DATE Indexed - no
Format - date
May be null? yes |
This field is not in use; refer instead to the end date of the appointment itself. |
| REDUCTION_IN_DUTIES_PCT
Indexed - no
Format - number
May be null? yes |
The percentage reduction in duties.
Values are formatted as whole number (e.g., 50% reduction entered as 50). |
| REDUCTION_IN_START_DATE
Indexed - no
Format - date
May be null? yes |
This field is not in use; refer instead to the start date of the appointment itself. |
| REEMPLOYMENT_BEYOND_RETIREMENT
Indexed - no
Format - varchar2(20)
May be null? yes |
A Yes/No field to indicate if this appointment is reemployment beyond retirement. |
| REINSTATED_EMPLOYMENT
Indexed - no
Format - varchar2(1)
May be null? yes |
A Yes/No field to indicate if this appointment is a reinstatement. |
| RELATED_ACTION_ID
Indexed - no
Format - number
May be null? yes |
The Action_ID of the related action (if any). |
| SCHOOL_CD Indexed - no
Format - varchar2(12)
May be null? no |
The two character code that represents the specific school or center to which the Department_Code belongs.
Example: 40 (School of Medicine) |
| STATUS_CD
Indexed - no
Format - number(12)
May be null? yes |
A numeric code indicating the status of the action. Use this to join to the FIS_ACTION_STATUS_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the status description (e.g.,
Draft,
Under audit review,
Returned to school for action,
Approved for PSC/PSCS submission,
Scheduled for meeting,
Action deferred,
Action declined,
Action approved). |
| STATUS_LAST_UPDATE_DATE
Indexed - no
Format - date
May be null? yes |
The last update date of the action status. |
| TENURE_EXTENSION_CODE
Indexed - no
Format - number(12)
May be null? yes |
A numeric code indicating the reason for granting extension of the tenure probationary period. Use this to join to the FIS_TENURE_EXT_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the status description (e.g., Childbirth, Caring for family member, Personal illness, Reduction in duties, Trustees Resolution of 6/17/2005). |
| TENURE_EXT_RD_PCT
Indexed - no
Format - number
May be null? yes |
The percentage of reduction in duties in relation to the provision given for extension of the tenure probationary period. |
| TENURE_NOTES
Indexed - no
Format - varchar2(250)
May be null? yes |
Additional comments pertaining to tenure. |
| TENURE_PROBATION_EXTENSION_TYPE
Indexed - no
Format - number(12)
May be null? yes |
This field is not use. |
| TENURE_PROBATION_START_DATE Indexed - no
Format - date
May be null? yes |
The start date of the tenure probationary period |
| TENURE_PROB_EXTENSION_CODE
Indexed - no
Format - number(12)
May be null? yes |
This field is not use. |
| TENURE_PROB_EXTENSION_DATE
Indexed - no
Format - date
May be null? yes |
Date that the tenure probabtion was extended. |
| TENURE_PROB_EXT_RD_PCT
Indexed - no
Format - number
May be null? yes |
The percentage of reduction in duties in relation to the provision given for extension of the tenure probationary period. |
| TENURE_PROB_PERIOD_START_DATE
Indexed - no
Format - date
May be null? yes |
For faculty members, the date of the first of the month in which their tenure review period begins. |
| TENURE_REVIEW_YEAR
Indexed - no
Format - date
May be null? yes |
For faculty members, the year in which the tenure review must be completed. For Clinician-Educators, this information is used for tenure tracking. |
| TENURE_STATUS
Indexed - no
Format - number(12)
May be null? no |
A numeric code indicating the tenure status, as determined by PSC. Use this to join to the FIS_TENURE_STATUS_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the status description (e.g., Granted,
Restricted, Under final consideration,
Denied). |
| TENURE_STATUS_DATE
Indexed - no
Format - date
May be null? yes
|
For faculty members, the date when the Tenure_Status is expected or was attained. For Clinician-Educators, this information is used for tenure tracking. |
| TERMINAL_YEAR_APPOINTMENT
Indexed - no
Format - varchar2(1)
May be null? yes |
A Yes/No field used to indicate that the action is for a terminal year reappointment. |
| TERMINAL_YEAR_LETTER_RECEV_DT
Indexed - no
Format - date
May be null? yes |
The University is required to give a one year notice in the form of a letter. This field is to verify/document date of receipt of this letter by the recipient. |
| TERMINATION_REASON
Indexed - no
Format - number(12)
May be null? no |
A numeric code indicating the reason for termination. Use this to join to the FIS_TERMINAT_REASON_CD_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the status description (e.g., Position Discontinued, Lack of Funding, Completion of Contract, End of Appointment). |
| TRUSTEES_APPROVED
Indexed - no
Format - varchar2(1)
May be null? yes |
A Yes/No field used to indicate if the action has been approved by the Trustees. |
| TRUSTEES_ID
Indexed - no
Format - number
May be null? yes |
Unique identifier of the Trustees meeting to which the action was assigned. |
| UPD_DT
Indexed - no
Format - date
May be null? no |
The date the record was last updated. |
| UPD_ID
Indexed - no
Format - varchar2(12)
May be null? no |
The Penn ID of the person who last updated the record. |
| VOTING_RIGHTS_CODE
Indexed - no
Format - number(12)
May be null? yes |
A numeric code indicating if the appointment in the action is granted voting rights. Use this to join to the FIS_VOTING_RIGHTS_CODE_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the status description. |
