| Data element |
Definition |
AFFILIATE_FLAG
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Indicates whether the person is an Academic Affiliate. |
ALIEN_AUTH_TO_WORK_EXP
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The date of expiration of employment authorization, if any is provided, from the worker's Form i-9. |
BIRTH_DATE
Format DATE
Indexed? No
May be Null? Yes |
The person's date of birth.
Values in this column will only be displayed to individuals with access to the person's Primary Supervisory Organization (for Workers) or Primary Academic Unit (for Affiliates); all other users will retrieve nulls in this column. |
CALCULATED_TOTAL_FTE
Format NUMBER
Indexed? No
May be Null? Yes |
The total FTE_Percent of all the current positions for the worker. This number may exceed 100. |
CONTINGENT_WORKER_TYPE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
For Contingent Workers, indicates the type assigned to the person. A Contingent Worker is any worker with a position who is unpaid and does not receive benefits. (This is distinct from Academic Affiliates, who do not have positions.) |
CPUP_JOB_INDICATOR
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Indicates whether the worker has a current position with Job Family = CPUP. In Workday, this will only apply to Academic workers (i.e. Faculty). |
CURRENT_APPOINTMENTS_FLAG
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Indicates whether (1) or not (0) the person has any current academic appointments. |
CURRENT_JOB_INDICATOR
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Indicates whether the worker has a current position in Workday. |
CURRENTLY_EMPLOYED
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
Indicates whether the worker is currently employed by the University. Records for currently employed individuals will show a value of 'Y' in this column, as indicated by an Employee_Status value of 1. 'N' indicates that the employee is no longer employed by the University. This column will be null for Academic Affiliates. |
DATE_OF_DEATH
Format DATE
Indexed? No
May be Null? Yes |
For deceased workers, the date of death, if known by Penn.
Values in this column will only be displayed to individuals with access to the person's Primary Supervisory Organization; all other users will retrieve nulls in this column. |
DECEASED_FLAG
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Indicates that the person is deceased 'Y' or is not deceased 'N'. (This value is dependent upon Penn having been informed that the person is deceased; the University is not always updated in these situations.) |
DISABLED_FLAG
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Indicates that the person is identified as having disabled status (1) or is not identified as disabled (0). Values in this column will only be displayed to individuals with access to military/disability data; all other users will retrieve nulls in this column. |
EMERGENCY_CONTACT
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The full name of the individual to be contacted if there is an emergency involving the person. |
EMPLOYEE_STATUS
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Indicates whether (1) or not (0) the person is an active employee of Penn. |
EMPLOYEE_TYPE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The type assigned to employees during hiring (e.g. academic, staff, student). This column will be null for Academic Affiliates. |
EMPLOYMENT_STATUS
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
A 1-character code identifying the employee's current employment relationship with the University of Pennsylvania. The value will be 'T' for workers with Terminated column value of 1, 'L' when the On_Leave value is 1, and 'A' when the Employee_Status = 1. (The legacy value of 'P' for paid leave will not be populated for individuals in Workday.) This column will be null for Academic Affiliates. |
EMPLOYMENT_STATUS_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date the employee's employment status went into effect. For terminated workers, this field is populated with the Termination_Date; for workers on leave, the field is populated with the First_Day_of_Leave; for active workers, the Hire_Date is used to populate the Employment_Status_Date. |
EST_LAST_DAY_OF_LEAVE
Format DATE
Indexed? No
May be Null? Yes |
For workers on leave, the estimated date that their leave will end. If the individual has multiple current types of leave (as indicated in HCM_PERSON_LEAVE_OF_ABSENCE), the value will be the latest of the Est_Last_Day_of_Leave values for all active leave types. Values in this column will only be displayed to individuals with access to the person's Primary Supervisory Organization; all other users will retrieve nulls in this column. |
EXEMPT_NONEXEMPT
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Indicates whether the individual is an exempt or non-exempt employee. Under Federal law, employees are either exempt or nonexempt from the Fair Labor Standards Act (FLSA) wage and hour regulations. Monthly-paid staff are exempt, and weekly-paid staff are non-exempt. Values will be 'N' for workers whose primary position Pay_Group value is 'Weekly' and 'E' for those with a primary position Pay_Group value of 'Monthly' or 'Academic'. |
FIRST_DAY_OF_LEAVE
Format DATE
Indexed? No
May be Null? Yes |
For workers on leave, the date that their leave began. If the individual has multiple current types of leave (as indicated in HCM_PERSON_LEAVE_OF_ABSENCE), the value will be the earliest of the First_Day_of_Leave values for all active leave types.
Values in this column will only be displayed to individuals with access to the person's Primary Supervisory Organization; all other users will retrieve nulls in this column. |
FULL_PART_TIME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
A 1-character code indicating the time status of the worker. For retirees (where the Retiree_Flag = 1), the value will be 'R'; for individuals on long-term disability (based on leave type), the value will be 'L'; for individuals on workers compensation leave (based on leave type), the value will be 'W'; for Postdocs (based on Employee_Type), the value will be 'S'; for Temporary employees (based on Employee_Type), the value will be 'T'. For individuals not falling in to the prior categories, and having a Calculated_Total_FTE >= 0.875, the value will be 'F'; individuals with a Calculated_Total_FTE less than 0.875 will have a value of 'P'. This column will be null for Academic Affiliates. |
GENDER
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The person's gender.
Values in this column will only be displayed to individuals with access to the person's Primary Supervisory Organization (for Workers) or Primary Academic Unit (for Affiliates); all other users will retrieve nulls in this column. |
HIRE_DATE
Format DATE
Indexed? No
May be Null? Yes |
The employee's most recent date of hire. |
HISPANIC_LATINO
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
Indicates that the person is identified (1) or not (0) as Hispanic or Latino and denotes an individual of Cuban, Mexican, Puerto Rican, South or Central American, or other Spanish culture or origin, regardless of race. Values in this column will only be displayed to individuals with access to race/ethnicity data; all other users will retrieve nulls in this column. |
LAST_DAY_OF_LEAVE
Format DATE
Indexed? No
May be Null? Yes |
For workers on leave, the actual date that their leave ends. If the individual has multiple current types of leave (as indicated in HCM_PERSON_LEAVE_OF_ABSENCE), the value will be the latest of the Act_Last_Day_of_Leave values for all active leave types. Values in this column will only be displayed to individuals with access to the person's Primary Supervisory Organization; all other users will retrieve nulls in this column. |
LAST_EXTRACT_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date on which the record was extracted from Workday and loaded to the Data Warehouse. |
LAST_PAYMENT_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date the worker last received pay. |
LEGAL_FIRST_NAME
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The person's legal first name, in mixed case. |
LEGAL_LAST_NAME
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The person's legal last name, in mixed case. |
LEGAL_MIDDLE_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The person's legal middle name, in mixed case. |
LEGAL_NAME
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The person's full legal name, in uppercase, in the format: LASTNAME,FIRSTNAME MIDDLEINITIAL (Note that only a comma separates the last name from the first name. Blank space is not used in the separator.) This is the name used for Federal W-2 forms, for example. |
LEGAL_NAME_FLIPPED
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The person's full legal name, in uppercase, in the format: FIRSTNAME MIDDLEINITIAL LASTNAME. This is the name used for Federal W-2 forms, for example. |
LEGAL_NAME_SUFFIX
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The modifier (if any) at the end of the person's legal name. |
LEGAL_NAME_TITLE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The optional title, in mixed case, used before the person's legal name. |
MARITAL_STATUS
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The person's marital status. (This may differ from the marital status the employee declares on the W-4 form for computation of withholding tax for which widowed, divorced, and legally separated persons are considered single.)
Values in this column will only be displayed to individuals with access to the person's Primary Supervisory Organization; all other users will retrieve nulls in this column. |
ON_FMLA_LEAVE_FLAG
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Indicates whether (1) or not (0) the worker is on Family Medical (FMLA) leave from Penn. Values in this column will only be displayed to individuals with access to the person's Primary Supervisory Organization; all other users will retrieve nulls in this column. |
ON_LEAVE_FLAG
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Indicates whether (1) or not (0) the worker is on leave from Penn. |
ORIGINAL_HIRE_DATE
Format DATE
Indexed? No
May be Null? Yes |
The employee's first date of hire with the University of Pennsylvania. This date can be the same as, or earlier than, the Hire_Date. |
PAID_THRU_DATE
Format DATE
Indexed? No
May be Null? Yes |
The end date of the pay period through which the worker was last paid. |
PAY_STATUS
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
A 1-character code indicating pay status ('H' for hourly or 'S' for salaried) for the worker, based on the Pay_Rate_Type of the worker's primary position.
|
PENN_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The 8-digit identification number assigned to an individual by Penn Community system. For example: 77777777. No two persons have the same Penn ID. Note that Penn IDs created in and assigned by Penn Community begin at 10000000. Within the Data Warehouse, the numeric range from 00000000-00999999 is used for individuals who do not yet have a Penn ID in Penn Community, to allow for reliable joins between tables using the PENN_ID column. When a Penn ID appears for the individual appear in Penn Community, it will replace the assigned value throughout the Data Warehouse. |
PENNKEY
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The employee's PennKey, the username required to authenticate an individual's identity to many of Penn's networked systems. For more information on PennKeys, refer to http://www.upenn.edu/computing/pennkey. |
PREFERRED_FIRST_NAME
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The person's preferred first name, in mixed case. |
PREFERRED_LAST_NAME
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The person's preferred last name, in mixed case. |
PREFERRED_MIDDLE_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The person's preferred middle name, in mixed case. |
PREFERRED_NAME
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The person's full preferred name, in uppercase, in the format: LASTNAME,FIRSTNAME MIDDLEINITIAL (Note that only a comma separates the last name from the first name. Blank space is not used in the separator.) |
PREFERRED_NAME_FLIPPED
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The person's full legal name, in uppercase, in the format: FIRSTNAME MIDDLEINITIAL LASTNAME. This is the name used for Federal W-2 forms, for example. |
PREFERRED_NAME_SUFFIX
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The modifier (if any) at the end of the person's preferred name. |
PREFERRED_NAME_TITLE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The optional title, in mixed case, used before the person's legal name. |
PRI_ACAD_APPT_ACAD_REVIEW_DATE
Format DATE
Indexed? No
May be Null? Yes |
The latest date by which a faculty member shall be reviewed for purposes of a timely tenure decision. |
PRI_ACAD_APPT_ACADEMIC_RANK
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The academic Rank of the person's primary academic appointment. (This field applies to workers and academic affiliates.) |
PRI_ACAD_APPT_ACADEMIC_RANK_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The system identifier representing the academic Rank of the person's primary academic appointment. (This field applies to workers and academic affiliates.) |
PRI_ACAD_APPT_BEGIN_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date of the beginning of the person's primary academic appointment. (This field applies to workers and academic affiliates.) |
PRI_ACAD_APPT_END_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date of the end of the person's primary academic appointment. Note: If there is no definite end date, Pri_Acad_Appt_End_Date will default to the latest available date in the Warehouse, which is 12/31/9999. (This field applies to workers and academic affiliates.) |
PRI_ACAD_APPT_JOB_CLASS
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The Job_Profile_ID of the person's primary academic appointment. This field is only populated for workers with a position linked to the appointment. The value will be null for academic affiliates or for workers whose appointment is not associated with a position. |
PRI_ACAD_APPT_TEN_STATUS
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The tenure status pertaining to the person in the primary academic appointment. |
PRI_ACAD_APPT_TEN_STATUS_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date on which tenure was awarded, for the primary academic appointment. |
PRI_ACAD_APPT_TEN_TRK_STRT_DT
Format DATE
Indexed? No
May be Null? Yes |
The date in which the person started in the academic track, pertaining to the primary academic appointment. |
PRI_ACAD_APPT_TITLE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The title of the person's primary academic appointment. (This field applies to workers and academic affiliates.) |
PRI_ACADEMIC_UNIT_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The system name representing the Academic Unit of the person's primary appointment. This field is only populated for academic workers or affiliates with a current appointment. |
PRI_ACADEMIC_UNIT_NAME
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The descriptive name representing the Academic Unit of the person's primary appointment. This field is only populated for academic workers or affiliates with a current appointment. |
PRI_EMER_CONTACT_EMAIL
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The email address at which the person's emergency contact can be reached. |
PRI_EMER_CONTACT_FIRST_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The first name of the individual to be contacted if there is an emergency involving the person. |
PRI_EMER_CONTACT_LAST_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The last name of the individual to be contacted if there is an emergency involving the person. |
PRI_EMER_CONTACT_MIDDLE_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The middle name of the individual to be contacted if there is an emergency involving the person. |
PRI_EMER_CONTACT_PHONE_NO
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The telephone number at which the person's emergency contact can be reached. |
PRI_EMER_CONTACT_RELATIONSHIP
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The relationship of the emergency contact to the person. |
PRI_PENN_AU_COST_CENTER
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The 4-digit number for the Penn Cost Center associated with the Academic Unit of the person's primary appointment. This field is only populated for academic workers or affiliates with a current appointment. |
PRI_PENN_COST_CENTER
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The 4-digit number for the Penn Cost Center associated with the primary position. This field is only populated for workers with a current position. |
PRI_PENN_SCH_CTR
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The 2-digit number used to identify the school or center for the Penn Cost Center associated with the primary position. This field is only populated for workers with a current position. |
PRI_SUPERVISORY_ORG_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The system name representing the Supervisory Organization for the person's primary position. This field is only populated for workers |
PRI_SUPERVISORY_ORG_NAME
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The descriptive name representing the Supervisory Organization for the person's primary position. This field is only populated for workers with a current position. |
PRIMARY_APPT_BEGIN_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date of the beginning of the worker's appointment to the primary position. |
PRIMARY_APPT_END_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date of the end of the worker's appointment to the primary position. Note: If there is no definite end date, Primary_Appt_End_Date will default to the latest available date in the Warehouse, which is 12/31/9999. |
PRIMARY_APPT_JOB_CLASS
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The Job_Profile_ID of the worker's primary position. |
PRIMARY_APPT_SALARY
Format NUMBER
Indexed? No
May be Null? Yes |
The estimated annual amount that the employee will be paid for the primary job appointment.
Following the implementation of Workday in July 2019, this column is updated to support longitudinal and cross collection reporting as follows: For individuals whose primary position Pay_Rate_Type = 'Salary', the Total_Base_Amount of the worker's primary position is used. For Hourly workers (Pay_Rate_Type of the primary positon = 'Hourly'), the Primary Appt Salary = Hourly_Rate * Default_Weekly_Hours * 52. For terminated employees, rows will remain in the table, and will no longer be updated. |
PRIMARY_BUSINESS_TITLE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The business title entered in Workday for the worker's primary position. If no alternate business title has been entered, this will be the same as the Primary_Position_Name |
PRIMARY_DEPT_ORG
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The 4-digit number for the Penn Cost Center associated with the worker's primary position |
PRIMARY_EMAIL_ADDRESS_HOME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The individual's primary personal email address. |
PRIMARY_EMAIL_ADDRESS_WORK
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The individual's primary work email address. |
PRIMARY_JOB_PROFILE_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The system identifier of the job profile for the worker's primary position. For job profiles converted from legacy systems to Workday, this is the same number as the Job_Class code. |
PRIMARY_JOB_PROFILE_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The name of the job profile for the worker's primary position. |
PRIMARY_PERCENT_EFFORT
Format NUMBER
Indexed? No
May be Null? Yes |
The FTE_Percent of the worker's primary position. |
PRIMARY_POSITION_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The unique system identifier of the worker's primary position. |
PRIMARY_POSITION_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The system name of the worker's primary position. This is generally the same as the Primary_Business_Title, if an alternate business title has not been entered in Workday. |
PRIMARY_SCHOOL_CENTER
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The 2-digit number used to identify the school or center for the Penn Cost Center associated with the worker's primary position. |
PROTECTED_VETERAN_FLAG
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Indicates that the person is identified (1) or not (0) as having protected veteran status. Values in this column will only be displayed to individuals with access to military/disability data; all other users will retrieve nulls in this column. |
REG_OR_TEMP
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The 1-character code that indicates whether a worker is employed on a regular or temporary basis. The value will be 'T' for workers with an Employee_Type of 'Temporary' and 'R' for other workers. This column will be null for Academic Affiliates. |
RETIREE_FLAG
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Indicates whether the person is retired (1) or not (0) from Penn. Values in this column will only be displayed to individuals with access to the person's Primary Supervisory Organization; all other users will retrieve nulls in this column. |
RETIREMENT_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date on which the person retired from Penn.
Values in this column will only be displayed to individuals with access to the person's Primary Supervisory Organization; all other users will retrieve nulls in this column. |
SSN
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The 9-digit Social Security Number of the individual. A Social Security Number is a unique number assigned to an individual by the federal Social Security Administration.
Values in this column will only be displayed to individuals with access to employee SSN data; all other users will retrieve nulls in this column. |
SSN4
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The last four digits of the 9-digit Social Security Number of the individual. |
TERMINATED
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Indicates whether (1) or not (0) the worker's employment has been terminated. |
TERMINATION_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date on which the worker's employment relationship with Penn ends. This can be a date in the future. |
TERMINATION_REASON
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
For terminated workers, the reason for one's termination of employment at Penn.
Values in this column will only be displayed to individuals with access to the person's Primary Supervisory Organization; all other users will retrieve nulls in this column. |
US_CITIZEN_FLAG
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Indicates whether (1) or not (0) the person is a citizen of the United States. Values in this column will only be displayed to individuals with access to the person's Primary Supervisory Organization (for Workers); all other users will retrieve nulls in this column. |
US_EMPLOY_VERI_STATUS
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Indicates whether the person has been authorized for employment. |
VETERAN_SEPARATION_DATE
Format DATE
Indexed? No
May be Null? Yes |
For Workers who are veterans, the date on which the individual separated from the military.
Values in this column will only be displayed to individuals with access to military/disability data; all other users will retrieve nulls in this column. |
WORKDAY_FILE_EFFECTIVE_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date the record was extracted from Workday. |
WORKDAY_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
The unique ID for a worker or affiliate in Workday. Although 8 digits long, it is distinct from and should not be confused with the Penn ID. |
WORKER_LOCATION
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The descriptive name of the location on campus linked to the person's work address. There is no connection between this information and the Space@Penn building codes or the legacy campus mail codes. |
WORKER_LOCATION_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The system name of the location on campus linked to the person's work address. There is no connection between this information and the Space@Penn building codes or the legacy campus mail codes. |
WORKER_TYPE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Indicates the Worker Type (Employee or Contingent Worker) for the person. This column will be null for Academic Affiliates. |
