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 |