HR PERSON EMPLOYEE Table
View exposing employee master data including names, demographic attributes, hire dates, employment status, and core workforce identifiers used for workforce reporting and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADJUSTED_SERVICE_DATE |
Column ADJUSTED_SERVICE_DATE. |
DATE |
|
ADMIN_DEPARTMENT_OVERRIDE |
Column ADMIN_DEPARTMENT_OVERRIDE. |
VARCHAR2 |
8 |
ADMIN_EMPLOYEE_TYPE |
Column ADMIN_EMPLOYEE_TYPE. |
VARCHAR2 |
40 |
ADMIN_JOB_ID |
Column ADMIN_JOB_ID. |
VARCHAR2 |
8 |
ADMIN_JOB_TITLE |
Column ADMIN_JOB_TITLE. |
VARCHAR2 |
40 |
ADMIN_ORG_UNIT_ID |
Column ADMIN_ORG_UNIT_ID. |
VARCHAR2 |
8 |
ADMIN_ORG_UNIT_TITLE |
Column ADMIN_ORG_UNIT_TITLE. |
VARCHAR2 |
75 |
ADMIN_POSITION_ID |
Column ADMIN_POSITION_ID. |
VARCHAR2 |
8 |
ADMIN_POSITION_TITLE |
Column ADMIN_POSITION_TITLE. |
VARCHAR2 |
50 |
AGE |
Column AGE. |
NUMBER |
|
AGE_BY_FISCAL_YEAR |
Column AGE_BY_FISCAL_YEAR. |
NUMBER |
|
ALT_INTEROFFICE_MAIL_FLAG |
Column ALT_INTEROFFICE_MAIL_FLAG. |
VARCHAR2 |
1 |
ALT_OFFICE_ADDRESS |
Column ALT_OFFICE_ADDRESS. |
VARCHAR2 |
40 |
ALT_OFFICE_ADDR_BUILDING |
Column ALT_OFFICE_ADDR_BUILDING. |
VARCHAR2 |
15 |
ALT_OFFICE_ADDR_ROOM |
Column ALT_OFFICE_ADDR_ROOM. |
VARCHAR2 |
20 |
ALT_OFFICE_ADDR_SITE |
Column ALT_OFFICE_ADDR_SITE. |
VARCHAR2 |
2 |
ALT_OFFICE_PHONE |
Column ALT_OFFICE_PHONE. |
VARCHAR2 |
15 |
APPOINTMENT_END_DATE |
Column APPOINTMENT_END_DATE. |
DATE |
|
CASE_VERIFICATION_NUMBER |
Column CASE_VERIFICATION_NUMBER. |
VARCHAR2 |
20 |
CELL_PHONE |
Column CELL_PHONE. |
VARCHAR2 |
15 |
CONTRACT_CODE |
Column CONTRACT_CODE. |
VARCHAR2 |
2 |
CONTRACT_DESCRIPTION |
Column CONTRACT_DESCRIPTION. |
VARCHAR2 |
20 |
COUNTRY_OF_CITIZENSHIP |
Column COUNTRY_OF_CITIZENSHIP. |
VARCHAR2 |
15 |
COUNTRY_OF_CITIZENSHIP_2 |
Column COUNTRY_OF_CITIZENSHIP_2. |
VARCHAR2 |
15 |
COUNTRY_OF_CITIZENSHIP_3 |
Column COUNTRY_OF_CITIZENSHIP_3. |
VARCHAR2 |
15 |
COUNTRY_OF_CITIZENSHIP_CODE |
Column COUNTRY_OF_CITIZENSHIP_CODE. |
VARCHAR2 |
3 |
COUNTRY_OF_CITIZENSHIP_CODE_2 |
Column COUNTRY_OF_CITIZENSHIP_CODE_2. |
VARCHAR2 |
3 |
COUNTRY_OF_CITIZENSHIP_CODE_3 |
Column COUNTRY_OF_CITIZENSHIP_CODE_3. |
VARCHAR2 |
3 |
CURRENT_EMPLOYMENT_DATE |
Column CURRENT_EMPLOYMENT_DATE. |
DATE |
|
DATE_OF_APPOINTMENT |
Column DATE_OF_APPOINTMENT. |
DATE |
|
DATE_OF_BIRTH |
Column DATE_OF_BIRTH. |
DATE |
|
DATE_OF_DEATH |
Column DATE_OF_DEATH. |
DATE |
|
DATE_TENURE_RELINQUISHED |
Column DATE_TENURE_RELINQUISHED. |
DATE |
|
DATE_TO_FACULTY |
Column DATE_TO_FACULTY. |
DATE |
|
DATE_TO_STAFF |
Column DATE_TO_STAFF. |
DATE |
|
DIRECTORY_FULL_NAME |
Column DIRECTORY_FULL_NAME. |
VARCHAR2 |
85 |
DIRECTORY_ORG_UNIT_ID |
Column DIRECTORY_ORG_UNIT_ID. |
VARCHAR2 |
8 |
DIRECTORY_ORG_UNIT_TITLE |
Column DIRECTORY_ORG_UNIT_TITLE. |
VARCHAR2 |
75 |
DIRECTORY_SUPPRESS_FLAG |
Column DIRECTORY_SUPPRESS_FLAG. |
VARCHAR2 |
1 |
DIRECTORY_TITLE |
Column DIRECTORY_TITLE. |
VARCHAR2 |
50 |
DIR_LAST_NAME_SUFFIX |
Column DIR_LAST_NAME_SUFFIX. |
VARCHAR2 |
40 |
DISABILITY_STATUS |
Column DISABILITY_STATUS. |
VARCHAR2 |
50 |
ELIG_PROGRAM_GROUP_1 |
Column ELIG_PROGRAM_GROUP_1. |
VARCHAR2 |
30 |
ELIG_PROGRAM_GROUP_2 |
Column ELIG_PROGRAM_GROUP_2. |
VARCHAR2 |
30 |
EMAIL_ADDRESS |
Column EMAIL_ADDRESS. |
VARCHAR2 |
100 |
EMERGENCY_ADDR_CITY |
Column EMERGENCY_ADDR_CITY. |
VARCHAR2 |
40 |
EMERGENCY_ADDR_COUNTRY |
Column EMERGENCY_ADDR_COUNTRY. |
VARCHAR2 |
20 |
EMERGENCY_ADDR_STATE |
Column EMERGENCY_ADDR_STATE. |
VARCHAR2 |
10 |
EMERGENCY_ADDR_STREET1 |
Column EMERGENCY_ADDR_STREET1. |
VARCHAR2 |
60 |
EMERGENCY_ADDR_STREET2 |
Column EMERGENCY_ADDR_STREET2. |
VARCHAR2 |
55 |
EMERGENCY_ADDR_ZIP |
Column EMERGENCY_ADDR_ZIP. |
VARCHAR2 |
10 |
EMERGENCY_CELL_PHONE |
Column EMERGENCY_CELL_PHONE. |
VARCHAR2 |
20 |
EMERGENCY_CONTACT_EMAIL |
Column EMERGENCY_CONTACT_EMAIL. |
VARCHAR2 |
70 |
EMERGENCY_CONTACT_NAME |
Column EMERGENCY_CONTACT_NAME. |
VARCHAR2 |
50 |
EMERGENCY_CONTACT_RELATION |
Column EMERGENCY_CONTACT_RELATION. |
VARCHAR2 |
20 |
EMERGENCY_HOME_PHONE |
Column EMERGENCY_HOME_PHONE. |
VARCHAR2 |
30 |
EMERGENCY_WORK_PHONE |
Column EMERGENCY_WORK_PHONE. |
VARCHAR2 |
20 |
EMPLOYEE_GROUP |
Column EMPLOYEE_GROUP. |
VARCHAR2 |
40 |
EMPLOYEE_GROUP_CODE |
Column EMPLOYEE_GROUP_CODE. |
VARCHAR2 |
1 |
EMPLOYEE_SUBGROUP |
Column EMPLOYEE_SUBGROUP. |
VARCHAR2 |
40 |
EMPLOYEE_SUBGROUP_CODE |
Column EMPLOYEE_SUBGROUP_CODE. |
VARCHAR2 |
2 |
EMPLOYEE_TYPE |
Column EMPLOYEE_TYPE. |
VARCHAR2 |
40 |
EMPLOYMENT_STATUS |
Column EMPLOYMENT_STATUS. |
VARCHAR2 |
40 |
ETHNICITY_DESCRIPTION |
Column ETHNICITY_DESCRIPTION. |
VARCHAR2 |
100 |
ETHNIC_ORIGIN |
Column ETHNIC_ORIGIN. |
VARCHAR2 |
100 |
ETHNIC_ORIGIN_INTERNAL |
Column ETHNIC_ORIGIN_INTERNAL. |
VARCHAR2 |
100 |
ETHNIC_ORIGIN_INTERNAL_CODE |
Column ETHNIC_ORIGIN_INTERNAL_CODE. |
VARCHAR2 |
2 |
FAX_NUMBER |
Column FAX_NUMBER. |
VARCHAR2 |
20 |
FIRST_NAME |
Column FIRST_NAME. |
VARCHAR2 |
40 |
FIRST_NAME_UPPER |
Column FIRST_NAME_UPPER. |
VARCHAR2 |
40 |
FORM_OF_ADDRESS_LONG |
Column FORM_OF_ADDRESS_LONG. |
VARCHAR2 |
100 |
FORM_OF_ADDRESS_SHORT |
Column FORM_OF_ADDRESS_SHORT. |
VARCHAR2 |
5 |
FULL_NAME |
Column FULL_NAME. |
VARCHAR2 |
100 |
FULL_NAME_UPPERCASE |
Column FULL_NAME_UPPERCASE. |
VARCHAR2 |
100 |
FULL_RACE_DESCRIPTION |
Column FULL_RACE_DESCRIPTION. |
VARCHAR2 |
300 |
GENDER |
Column GENDER. |
VARCHAR2 |
15 |
HAS_ADDL_APPOINTMENT |
Column HAS_ADDL_APPOINTMENT. |
VARCHAR2 |
1 |
HAS_CYBORG_HISTORY |
Column HAS_CYBORG_HISTORY. |
VARCHAR2 |
1 |
HAS_DUAL_APPOINTMENT |
Column HAS_DUAL_APPOINTMENT. |
VARCHAR2 |
1 |
HAS_FUTURE_APPT |
Column HAS_FUTURE_APPT. |
VARCHAR2 |
1 |
HAS_MULTIPLE_APPTS |
Column HAS_MULTIPLE_APPTS. |
VARCHAR2 |
1 |
HAS_NO_POSITION_SUPPLEMENTS |
Column HAS_NO_POSITION_SUPPLEMENTS. |
VARCHAR2 |
1 |
HIGHEST_DEGREE_TYPE |
Column HIGHEST_DEGREE_TYPE. |
VARCHAR2 |
20 |
HIGHEST_DEGREE_TYPE_CODE |
Column HIGHEST_DEGREE_TYPE_CODE. |
VARCHAR2 |
2 |
HIGHEST_DEGREE_YEAR |
Column HIGHEST_DEGREE_YEAR. |
VARCHAR2 |
4 |
HOME_ADDR_CARE_OF |
Column HOME_ADDR_CARE_OF. |
VARCHAR2 |
40 |
HOME_ADDR_CITY |
Column HOME_ADDR_CITY. |
VARCHAR2 |
40 |
HOME_ADDR_COUNTRY |
Column HOME_ADDR_COUNTRY. |
VARCHAR2 |
20 |
HOME_ADDR_STATE |
Column HOME_ADDR_STATE. |
VARCHAR2 |
10 |
HOME_ADDR_STREET1 |
Column HOME_ADDR_STREET1. |
VARCHAR2 |
60 |
HOME_ADDR_STREET2 |
Column HOME_ADDR_STREET2. |
VARCHAR2 |
40 |
HOME_ADDR_ZIP |
Column HOME_ADDR_ZIP. |
VARCHAR2 |
10 |
HOME_PHONE |
Column HOME_PHONE. |
VARCHAR2 |
15 |
HR_ORG_UNIT_ID |
Column HR_ORG_UNIT_ID. |
VARCHAR2 |
8 |
HR_ORG_UNIT_TITLE |
Column HR_ORG_UNIT_TITLE. |
VARCHAR2 |
75 |
HR_REMARKS |
Column HR_REMARKS. |
VARCHAR2 |
30 |
I9_FORM_EXPIRATION_DATE |
Column I9_FORM_EXPIRATION_DATE. |
DATE |
|
I9_FORM_LOCATION |
Column I9_FORM_LOCATION. |
VARCHAR2 |
50 |
I9_FORM_LOCATION_CODE |
Column I9_FORM_LOCATION_CODE. |
VARCHAR2 |
1 |
INCLUDE_HOME_ADDR_IN_DIR |
Column INCLUDE_HOME_ADDR_IN_DIR. |
VARCHAR2 |
1 |
INTEROFFICE_MAIL_FLAG |
Column INTEROFFICE_MAIL_FLAG. |
VARCHAR2 |
1 |
IS_ACTIVE_WAR_CAMPGN_BADGE_VET |
Column IS_ACTIVE_WAR_CAMPGN_BADGE_VET. |
VARCHAR2 |
1 |
IS_ALT_OFFICE_PHONE_TTY |
Column IS_ALT_OFFICE_PHONE_TTY. |
VARCHAR2 |
1 |
IS_AMERICAN_INDIAN_ALASKA_NATV |
Column IS_AMERICAN_INDIAN_ALASKA_NATV. |
VARCHAR2 |
1 |
IS_ASIAN |
Column IS_ASIAN. |
VARCHAR2 |
1 |
IS_A_F_SERVICE_MEDAL_VETERAN |
Column IS_A_F_SERVICE_MEDAL_VETERAN. |
VARCHAR2 |
1 |
IS_BLACK_OR_AFRICAN_AMERICAN |
Column IS_BLACK_OR_AFRICAN_AMERICAN. |
VARCHAR2 |
1 |
IS_CURRENTLY_PAID_EMPLOYEE |
Column IS_CURRENTLY_PAID_EMPLOYEE. |
VARCHAR2 |
1 |
IS_DISABLED |
Column IS_DISABLED. |
VARCHAR2 |
1 |
IS_DISABLED_VETERAN |
Column IS_DISABLED_VETERAN. |
VARCHAR2 |
1 |
IS_FORMER_EMP_CURRENT_STU |
Column IS_FORMER_EMP_CURRENT_STU. |
VARCHAR2 |
1 |
IS_HISPANIC_OR_LATINO |
Column IS_HISPANIC_OR_LATINO. |
VARCHAR2 |
1 |
IS_MORE_THAN_ONE_RACE_REPORTED |
Column IS_MORE_THAN_ONE_RACE_REPORTED. |
VARCHAR2 |
1 |
IS_NATIVE_HAWAIIAN_PACIFIC_ISL |
Column IS_NATIVE_HAWAIIAN_PACIFIC_ISL. |
VARCHAR2 |
1 |
IS_NEWLY_SEPARATED_VETERAN |
Column IS_NEWLY_SEPARATED_VETERAN. |
VARCHAR2 |
1 |
IS_NOT_A_VETERAN |
Column IS_NOT_A_VETERAN. |
VARCHAR2 |
1 |
IS_NO_ETHNICITY_ON_RECORD |
Column IS_NO_ETHNICITY_ON_RECORD. |
VARCHAR2 |
1 |
IS_NO_RACE_ON_RECORD |
Column IS_NO_RACE_ON_RECORD. |
VARCHAR2 |
1 |
IS_NO_VETERAN_STATUS_ON_RECORD |
Column IS_NO_VETERAN_STATUS_ON_RECORD. |
VARCHAR2 |
1 |
IS_OFFICE_PHONE_TTY |
Column IS_OFFICE_PHONE_TTY. |
VARCHAR2 |
1 |
IS_OFF_CAMPUS_WORK_PHONE_TTY |
Column IS_OFF_CAMPUS_WORK_PHONE_TTY. |
VARCHAR2 |
1 |
IS_OTHER |
Column IS_OTHER. |
VARCHAR2 |
1 |
IS_PROTECTED_VETERAN |
Column IS_PROTECTED_VETERAN. |
VARCHAR2 |
1 |
IS_PROTECTED_VET_NO_CATEGORY |
Column IS_PROTECTED_VET_NO_CATEGORY. |
VARCHAR2 |
1 |
IS_RECENTLY_SEPARATED_VETERAN |
Column IS_RECENTLY_SEPARATED_VETERAN. |
VARCHAR2 |
1 |
IS_SIGNED_UP_FOR_MIT_ALERT |
Column IS_SIGNED_UP_FOR_MIT_ALERT. |
CHAR |
|
IS_SPECIAL_DISABLED_VETERAN |
Column IS_SPECIAL_DISABLED_VETERAN. |
VARCHAR2 |
1 |
IS_VETERAN_BUT_NOT_PROTECTED |
Column IS_VETERAN_BUT_NOT_PROTECTED. |
VARCHAR2 |
1 |
IS_VIETNAM_VETERAN |
Column IS_VIETNAM_VETERAN. |
VARCHAR2 |
1 |
IS_WHITE |
Column IS_WHITE. |
VARCHAR2 |
1 |
JOB_ID |
Column JOB_ID. |
VARCHAR2 |
8 |
JOB_TITLE |
Column JOB_TITLE. |
VARCHAR2 |
40 |
KRB_NAME_UPPERCASE |
Column KRB_NAME_UPPERCASE. |
VARCHAR2 |
30 |
LAST_ESS_ACCESS_DATE |
Column LAST_ESS_ACCESS_DATE. |
DATE |
|
LAST_NAME |
Column LAST_NAME. |
VARCHAR2 |
40 |
LAST_NAME_UPPER |
Column LAST_NAME_UPPER. |
VARCHAR2 |
40 |
LAST_TERM_DATE |
Column LAST_TERM_DATE. |
DATE |
|
LAST_YEAR_TENURE_ELIGIBLE |
Column LAST_YEAR_TENURE_ELIGIBLE. |
VARCHAR2 |
4 |
LINCOLN_PERSONNEL_KEY |
Column LINCOLN_PERSONNEL_KEY. |
VARCHAR2 |
8 |
LOA_RETURN_DATE |
Column LOA_RETURN_DATE. |
DATE |
|
LOA_START_DATE |
Column LOA_START_DATE. |
DATE |
|
MIDDLE_INITIAL |
Column MIDDLE_INITIAL. |
VARCHAR2 |
10 |
MIDDLE_NAME |
Column MIDDLE_NAME. |
VARCHAR2 |
40 |
MILITARY_STATUS |
Column MILITARY_STATUS. |
VARCHAR2 |
30 |
MILITARY_STATUS_CODE |
Column MILITARY_STATUS_CODE. |
VARCHAR2 |
2 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
NAME_KNOWN_BY |
Column NAME_KNOWN_BY. |
VARCHAR2 |
40 |
NAME_PREFIX |
Column NAME_PREFIX. |
VARCHAR2 |
15 |
NAME_SUFFIX |
Column NAME_SUFFIX. |
VARCHAR2 |
15 |
OFFICE_ADDRESS |
Column OFFICE_ADDRESS. |
VARCHAR2 |
40 |
OFFICE_ADDR_BUILDING |
Column OFFICE_ADDR_BUILDING. |
VARCHAR2 |
15 |
OFFICE_ADDR_ROOM |
Column OFFICE_ADDR_ROOM. |
VARCHAR2 |
15 |
OFFICE_ADDR_SITE |
Column OFFICE_ADDR_SITE. |
VARCHAR2 |
2 |
OFFICE_PHONE |
Column OFFICE_PHONE. |
VARCHAR2 |
15 |
OFF_CAMPUS_WORK_ADDR_CARE_OF |
Column OFF_CAMPUS_WORK_ADDR_CARE_OF. |
VARCHAR2 |
40 |
OFF_CAMPUS_WORK_ADDR_CITY |
Column OFF_CAMPUS_WORK_ADDR_CITY. |
VARCHAR2 |
40 |
OFF_CAMPUS_WORK_ADDR_COUNTRY |
Column OFF_CAMPUS_WORK_ADDR_COUNTRY. |
VARCHAR2 |
20 |
OFF_CAMPUS_WORK_ADDR_STATE |
Column OFF_CAMPUS_WORK_ADDR_STATE. |
VARCHAR2 |
3 |
OFF_CAMPUS_WORK_ADDR_STREET1 |
Column OFF_CAMPUS_WORK_ADDR_STREET1. |
VARCHAR2 |
60 |
OFF_CAMPUS_WORK_ADDR_STREET2 |
Column OFF_CAMPUS_WORK_ADDR_STREET2. |
VARCHAR2 |
40 |
OFF_CAMPUS_WORK_ADDR_ZIP |
Column OFF_CAMPUS_WORK_ADDR_ZIP. |
VARCHAR2 |
10 |
OFF_CAMPUS_WORK_PHONE |
Column OFF_CAMPUS_WORK_PHONE. |
VARCHAR2 |
15 |
ORIGINAL_HIRE_DATE |
Column ORIGINAL_HIRE_DATE. |
DATE |
|
PAGER_NUMBER |
Column PAGER_NUMBER. |
VARCHAR2 |
20 |
PERSONAL_EMAIL_ADDR |
Column PERSONAL_EMAIL_ADDR. |
VARCHAR2 |
100 |
PERSONAL_URL |
Column PERSONAL_URL. |
VARCHAR2 |
150 |
PERSONNEL_AREA |
Column PERSONNEL_AREA. |
VARCHAR2 |
40 |
PERSONNEL_AREA_CODE |
Column PERSONNEL_AREA_CODE. |
VARCHAR2 |
4 |
PERSONNEL_KEY |
Column PERSONNEL_KEY. |
VARCHAR2 |
8 |
PERSONNEL_SUBAREA |
Column PERSONNEL_SUBAREA. |
VARCHAR2 |
40 |
PERSONNEL_SUBAREA_CODE |
Column PERSONNEL_SUBAREA_CODE. |
VARCHAR2 |
4 |
POSITION_ID |
Column POSITION_ID. |
VARCHAR2 |
8 |
POSITION_TITLE |
Column POSITION_TITLE. |
VARCHAR2 |
50 |
PREFERRED_FIRST_NAME_UPPER |
Column PREFERRED_FIRST_NAME_UPPER. |
VARCHAR2 |
40 |
PREFERRED_LAST_NAME_UPPER |
Column PREFERRED_LAST_NAME_UPPER. |
VARCHAR2 |
40 |
PREFERRED_MIDDLE_NAME_UPPER |
Column PREFERRED_MIDDLE_NAME_UPPER. |
VARCHAR2 |
40 |
PRIOR_LAST_NAME |
Column PRIOR_LAST_NAME. |
VARCHAR2 |
40 |
RECORD_COUNTER |
Column RECORD_COUNTER. |
NUMBER |
|
RESIDENCY_STATUS |
Column RESIDENCY_STATUS. |
VARCHAR2 |
30 |
RESIDENCY_STATUS_CODE |
Column RESIDENCY_STATUS_CODE. |
VARCHAR2 |
1 |
RETIREMENT_DATE |
Column RETIREMENT_DATE. |
DATE |
|
SALUTATION |
Column SALUTATION. |
VARCHAR2 |
1 |
SAP_STATUS |
Column SAP_STATUS. |
VARCHAR2 |
40 |
SEIU |
Column SEIU. |
VARCHAR2 |
100 |
SIGNATURE_NAME |
Column SIGNATURE_NAME. |
VARCHAR2 |
80 |
SOCIAL_SECURITY_NUMBER |
Column SOCIAL_SECURITY_NUMBER. |
VARCHAR2 |
9 |
TENURE_COMMENTS |
Column TENURE_COMMENTS. |
VARCHAR2 |
50 |
TENURE_DATE |
Column TENURE_DATE. |
DATE |
|
UNION_SENIORITY_DATE |
Column UNION_SENIORITY_DATE. |
DATE |
|
VACATION_ELIG_DATE |
Column VACATION_ELIG_DATE. |
DATE |
|
VETERAN_DATE_OF_DISCHARGE |
Column VETERAN_DATE_OF_DISCHARGE. |
DATE |
|
VISA_EXPIRATION_DATE |
Column VISA_EXPIRATION_DATE. |
DATE |
|
VISA_ISSUE_DATE |
Column VISA_ISSUE_DATE. |
DATE |
|
VISA_TYPE |
Column VISA_TYPE. |
VARCHAR2 |
40 |
VISA_TYPE_CODE |
Column VISA_TYPE_CODE. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
Column WAREHOUSE_LOAD_DATE. |
DATE |
|
WI_GENOME_HIRE_DATE |
Column WI_GENOME_HIRE_DATE. |
DATE |
|
YEAR_8_OF_FACULTY_SERVICE |
Column YEAR_8_OF_FACULTY_SERVICE. |
VARCHAR2 |
4 |
YEAR_OF_APPOINTMENT |
Column YEAR_OF_APPOINTMENT. |
VARCHAR2 |
4 |
YEAR_TURNING_35 |
Column YEAR_TURNING_35. |
VARCHAR2 |
4 |
YRS_OF_SERVICE |
Column YRS_OF_SERVICE. |
NUMBER |
|
YRS_OF_SERVICE_FROM_LAST_HIRE |
Column YRS_OF_SERVICE_FROM_LAST_HIRE. |
NUMBER |