EMPLOYEE - Report
Data Element |
Business Definition |
Data Type |
Source Name |
Source Data Element |
Form Name |
PERSON_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
PEBEMPL |
PEBEMPL_PIDM |
UNKNOWN |
PROFILE_DATE |
INFORMATION IN THIS MODEL WILL BE RETURNED 'AS OF' THE PROFILE DATE |
|
FUNCTION |
F_PROFILE_DATE |
UNKNOWN |
PROFILE_YEAR |
EMPLOYMENT YEAR ASSOCIATED WITH THIS RECORD. |
|
FUNCTION |
? |
UNKNOWN |
EMPLOYEE_STATUS |
STATUS OF THE EMPLOYEE. |
|
PEBEMPL |
PEBEMPL_EMPL_STATUS |
UNKNOWN |
EMPLOYEE_STATUS_DESC |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
EMPLOYEE_CLASS |
EMPLOYEE CLASS CODE |
|
PEBEMPL |
PEBEMPL_ECLS_CODE |
UNKNOWN |
EMPLOYEE_CLASS_SHORT_DESC |
EMPLOYEE CLASS SHORT DESCRIPTION. |
|
PTRECLS |
PTRECLS_SHORT_DESC |
UNKNOWN |
EMPLOYEE_CLASS_LONG_DESC |
EMPLOYEE CLASS LONG DESCRIPTION. |
|
PTRECLS |
PTRECLS_LONG_DESC |
UNKNOWN |
LEAVE_CATEGORY |
LEAVE CATEGORY TO WHICH THE EMPLOYEE BELONGS. |
|
PEBEMPL |
PEBEMPL_LCAT_CODE |
UNKNOWN |
LEAVE_CATEGORY_DESC |
LEAVE CATEGORY DESCRIPTION. |
|
PTVLCAT |
PTVLCAT_DESC |
UNKNOWN |
BENEFIT_CATEGORY |
BENEFIT CATEGORY TO WHICH THE EMPLOYEE BELONGS. |
|
PEBEMPL |
PEBEMPL_BCAT_CODE |
UNKNOWN |
BENEFIT_CATEGORY_DESC |
BENEFITS CATEGORY DESCRIPTION. |
|
PTRBCAT |
PTRBCAT_DESC |
UNKNOWN |
HOME_ORGANIZATION_CHART |
HOME CHART OF ACCOUNTS CODE FOR THE EMPLOYEE. |
|
PEBEMPL |
PEBEMPL_COAS_CODE_HOME |
UNKNOWN |
HOME_ORGANIZATION |
HOME ORGANIZATION CODE OF THE EMPLOYEE. |
|
PEBEMPL |
PEBEMPL_ORGN_CODE_HOME |
UNKNOWN |
HOME_ORGANIZATION_DESC |
HOME ORGANIZATION DESCRIPTION. |
|
FTVORGN / PTVORGN |
TITLE / DESC |
UNKNOWN |
TIME_SHEET_CHART |
USED ONLY IF BANNER FINANCE IS INSTALLED. |
|
NBRJOBS |
NBRJOBS_COAS_CODE_TS |
UNKNOWN |
TIME_SHEET_ORGANIZATION |
ORGANIZATION TO WHICH THE TIME SHEET FOR THIS JOB WILL BE SENT. |
|
NBRJOBS |
NBRJOBS_ORGN_CODE_TS |
UNKNOWN |
TIME_SHEET_ORGANIZATION_DESC |
ORGANIZATION DESCRIPTION. |
|
FTVORGN / PTVORGN |
TITLE / DESC |
UNKNOWN |
FULL_OR_PART_TIME_IND |
INTERNAL PART TIME/FULL TIME INDICATOR |
|
PEBEMPL |
PEBEMPL_INTERNAL_FT_PT_IND |
UNKNOWN |
ORIGINAL_HIRE_DATE |
DATE THE EMPLOYEE WAS FIRST HIRED. |
|
PEBEMPL |
PEBEMPL_FIRST_HIRE_DATE |
UNKNOWN |
CURRENT_HIRE_DATE |
MOST RECENT DATE OF HIRE. |
|
PEBEMPL |
PEBEMPL_CURRENT_HIRE_DATE |
UNKNOWN |
ADJUSTED_SERVICE_DATE |
DATE USED TO DETERMINE YEARS OF SERVICE FOR LEAVE ACCRUAL IF THE FIRST HIRE DATE AND CURRENT HIRE DATE ARE NOT EQUAL. |
|
PEBEMPL |
PEBEMPL_ADJ_SERVICE_DATE |
UNKNOWN |
SENIORITY_DATE |
CURRENTLY NOT USED BY SYSTEM. RESERVED FOR FUTURE USE. |
|
PEBEMPL |
PEBEMPL_SENIORITY_DATE |
UNKNOWN |
IMMIGRATION_STATUS |
INDICATES WHETHER OR NOT IMMIGRATION INFORMATION HAS BEEN RECEIVED. U.S. CLIENTS |
|
PEBENPL |
PEBEMPL_I9_FORM_IND |
UNKNOWN |
IMMIGRATION_STATUS_DESC |
CURRENT IMMIGRATION STATUS FOR THIS PERSON AND TRACKED IN THE INTERNATIONAL INFORMATION RECORD. |
|
GOBINTL |
NOT AVAILABLE |
UNKNOWN |
IMMIGRATION_DATE |
DATE IMMIGRATION INFORMATION WAS RECEIVED. FOR U.S. CLIENTS |
|
PEBEMPL |
PEBEMPL_I9_DATE |
UNKNOWN |
IMMIGRATION_EXPIRATION_DATE |
DATE THE IMMIGRATION INFORMATION EXPIRES. FOR U.S. CLIENTS |
|
PEBEMPL |
PEBEMPL_I9_EXPIRE_DATE |
UNKNOWN |
FOREIGN_INCOME_RECIPIENT_TYPE |
FOR U.S. CLIENTS |
|
PEBEMPL |
PEBEMPL_1042_RECIPIENT_CODE |
UNKNOWN |
FOREIGN_INCOME_RECIPIENT_DESC |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
NONRESIDENT_DAYS_IN_COUNTRY |
PRIMARILY USED FOR CANADA T4A-NR REPORTING. SPECIFICALLY |
|
PEBEMPL |
PEBEMPL_DAYS_IN_CANADA |
UNKNOWN |
EMPLOYEE_GROUPING |
STATISTICS CANADA GROUPING CODE USED FOR STATISTICS CANADA REPORTING FOR GOVERNMENT INSTALLATIONS. |
|
PEBEMPL |
PEBEMPL_STGR_CODE |
UNKNOWN |
EMPLOYEE_GROUPING_DESC |
STATISTICS CANADA GROUPING DESCRIPTION. |
|
PTVSTGR |
PTVSTGR_DESC |
UNKNOWN |
POSITION_CONTRACT_TYPE |
INDICATES WHETHER THIS IS THE (P)RIMARY |
|
NBRBJOB |
NBRBJOB_CONTRACT_TYPE |
UNKNOWN |
POSITION_BEGIN_DATE |
BEGIN DATE OF THE POSITION. |
|
NBRBJOB |
NBRBJOB_BEGIN_DATE |
UNKNOWN |
POSITION_END_DATE |
END DATE OF THE POSITION. IF NULL |
|
NBRBJOB |
NBRBJOB_END_DATE |
UNKNOWN |
POSITION |
NON-INSTRUCTIONAL POSITION NUMBER. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
JOB_SUFFIX |
NON-INSTRUCTIONAL POSITION NUMBER SUFFIX. |
|
NBRJOBS |
NBRJOBS_SUFF |
UNKNOWN |
POSITION_TITLE |
NAME OF THE POSITION. DEFAULTS FROM THE POSITION TITLE IF LEFT BLANK. |
|
NBRJOBS |
NBRJOBS_DESC |
UNKNOWN |
POSITION_STATUS |
POSITION STATUS. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
POSITION_STATUS_DESC |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
POSITION_PERSONNEL_DATE |
DATE THE CHANGE BECAME EFFECTIVE |
|
NA |
NOT AVAILABLE |
UNKNOWN |
CURRENT_REVIEW_TYPE |
CODE IDENTIFYING THE TYPE OF REVIEW. |
|
PERREVW |
PERREVW_REVT_CODE |
UNKNOWN |
CURRENT_REVIEW_TYPE_DESC |
REVIEW TYPE DESCRIPTION. |
|
PTVREVT |
PTVREVT_DESC |
UNKNOWN |
CURRENT_REVIEW_DATE |
DATE THIS REVIEW TYPE IS DUE FOR COMPLETION. |
|
PERREVW |
PERREVW_REVT_DATE |
UNKNOWN |
CURRENT_REVIEW_TYPE_COMP_IND |
CODE USED TO IDENTIFY IF THIS REVIEW TYPE HAS BEEN COMPLETED. |
|
PERREVW |
PERREVW_REVT_COMPLETE |
UNKNOWN |
CURRENT_REVIEW_RATING |
A USER DEFINED RATING SYSTEM FOR COMPLETED REVIEW TYPES. |
|
PERREVW |
PERREVW_REVT_RATING |
UNKNOWN |
TERMINATION_REASON |
CODE USED TO IDENTIFY THE REASON FOR THE TERMINATION. |
|
PEBEMPL |
PEBEMPL_TREA_CODE |
UNKNOWN |
TERMINATION_REASON_DESC |
TERMINATION REASON DESCRIPTION. |
|
PTRTREA |
PTRTREA_DESC |
UNKNOWN |
TERMINATION_DATE |
TERMINATION DATE OF THE EMPLOYEE. |
|
PEBEMPL |
PEBEMPL_TERM_DATE |
UNKNOWN |
LEAVE_OF_ABSENCE_REASON |
CODE IDENTIFYING THE REASON OF THE LEAVE OF ABSENCE FOR THE EMPLOYEE. |
|
PEBEMPL |
PEBEMPL_LREA_CODE |
UNKNOWN |
LEAVE_OF_ABSENCE_REASON_DESC |
LEAVE OF ABSENCE DESCRIPTION. |
|
PTRLREA |
PTRLREA_DESC |
UNKNOWN |
LEAVE_OF_ABSENCE_BEGIN_DATE |
BEGIN DATE OF A LEAVE OF ABSENCE FOR THE EMPLOYEE. |
|
PEBEMPL |
PEBEMPL_LOA_BEG_DATE |
UNKNOWN |
LEAVE_OF_ABSENCE_END_DATE |
END DATE FOR AN EMPLOYEES LEAVE OF ABSENCE. |
|
PEBEMPL |
PEBEMPL_LOA_END_DATE |
UNKNOWN |
EXEMPTION_IND_OVERRIDE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
EEO_SKILL |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
EEO_SKILL_DESC |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
EEO_CATEGORY |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
EEO_CATEGORY_DESC |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
CONTRACT_TYPE |
CONTRACT TYPE ASSOCIATED WITH THE INSTRUCTIONAL ASSIGNMENT. |
|
NBRBJOB |
NBRBJOB_CONTRACT_TYPE |
UNKNOWN |
CONTRACT_TYPE_DESC |
(P)RIMARY, (S)ECONDARY, OR (O)VERLOAD JOB. |
|
MANUAL |
PROGRAMATICALLY SET. |
UNKNOWN |
BARGAINING_UNIT_COUNT |
NUMBER OF BARGAINING UNITS ASSOCIATED WITH THE PERSON. |
|
MPKFUNC |
F_COUNT_BARG_UNIT |
UNKNOWN |
LEAVE_COUNT |
NUMBER OF THE OFFICIAL LEAVES ASSOCIATED WITH THE PERSON AS AN EMPLOYEE. |
|
FUNCTION |
? |
UNKNOWN |
REVIEW_COUNT |
NUMBER OF REVIEWS FOR THE EMPLOYEE ASSOCIATED WITH THE PERSON. |
|
FUNCTION |
? |
UNKNOWN |
EMPLOYEE_EARNING_COUNT |
NUMBER OF EMPLOYEE EARNING RECORDS ASSOCIATED WITH AN EMPLOYEE. |
|
FUNCTION |
? |
UNKNOWN |