EMPLOYEE_POSITION - 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. |
|
NBRBJOB |
NBRBJOB_PIDM |
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_CONTRACT_TYPE |
INDICATES WHETHER THIS IS THE (P)RIMARY |
|
NBRBJOB |
NBRBJOB_CONTRACT_TYPE |
UNKNOWN |
CONTRACT_START_DATE |
START DATE OF THE CONTRACT. |
|
NBRBJOB |
NBRBJOB_CONTRACT_BEGIN_DATE |
UNKNOWN |
CONTRACT_END_DATE |
END DATE OF THE CONTRACT. |
|
NBRBJOB |
NBRBJOB_CONTRACT_END_DATE |
UNKNOWN |
POSITION |
NON-INSTRUCTIONAL POSITION NUMBER. |
|
NBRJOBS |
NBRJOBS_POSN |
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 |
|
NBRJOBS |
NBRJOBS_PERS_CHG_DATE |
UNKNOWN |
SUPERVISOR_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
NBRJOBS |
NBRJOBS_SUPERVISOR_PIDM |
UNKNOWN |
SUPERVISOR_POSITION |
POSITION NUMBER OF THE SUPERVISOR. |
|
NBRJOBS |
NBRJOBS_SUPERVISOR_POSN |
UNKNOWN |
SUPERVISOR_JOB_SUFFIX |
SUFFIX ASSOCIATED WITH THE SUPERVISOR'S POSITION. |
|
NBRJOBS |
NBRJOBS_SUPERVISOR_SUFF |
UNKNOWN |
EFFECTIVE_DATE |
DATE ON WHICH THE BARGAINING UNIT BECAME EFFECTIVE FOR THIS PERSON. |
|
NBRJOBS |
NBRJOBS_EFFECTIVE_DATE |
UNKNOWN |
EFFECTIVE_START_DATE |
BEGINNING DATE FOR EFFECTIVE DATE. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
EFFECTIVE_END_DATE |
DATE ON WHICH THE BARGAINING UNIT WAS NO LONGER ASSOCIATED WITH THIS PERSON. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
POSITION_CHANGE_REASON |
POSITION CHANGE REASON. |
|
NBRJOBS |
NBRJOBS_JCRE_CODE |
UNKNOWN |
POSITION_CHANGE_REASON_DESC |
POSITION CHANGE REASON DESCRIPTION. |
|
PTVJCRE |
PTVJCRE_DESC |
UNKNOWN |
ASSIGNMENT_TABLE |
SALARY TABLE. |
|
NBRJOBS |
NBRJOBS_SAL_TABLE |
UNKNOWN |
ASSIGNMENT_GRADE |
SALARY GRADE. |
|
NBRJOBS |
NBRJOBS_SAL_GRADE |
UNKNOWN |
ASSIGNMENT_STEP |
SALARY STEP. |
|
NBRJOBS |
NBRJOBS_SAL_STEP |
UNKNOWN |
ASSIGNMENT_SALARY_GROUP |
SALARY GROUP CODE. |
|
NBRJOBS |
NBRJOBS_SGRP_CODE |
UNKNOWN |
ASSIGNMENT_SALARY_GROUP_DESC |
SALARY GROUP DESCRIPTION. |
|
NTRSGRP |
NTRSGRP_DESC |
UNKNOWN |
FULL_TIME_EQUIVALEANCY_PCT |
FULL TIME EQUIVALENCY PERCENTAGE ASSIGNED TO THIS POSITION. |
|
NBRJOBS |
NBRJOBS_FTE |
UNKNOWN |
APPOINTMENT_PCT |
APPOINTMENT PERCENTAGE. |
|
NBRJOBS |
NBRJOBS_APPT_PCT |
UNKNOWN |
TIMESHEET_CHART_OF_ACCOUNTS |
|
|
NBRJOBS |
NBRJOBS_COAS_CODE_TS |
UNKNOWN |
TIMESHEET_ORGANIZATION |
ORGANIZATION TO WHICH THE TIME SHEET FOR THIS POSITION WILL BE SENT. |
|
NBRJOBS |
NBRJOBS_ORGN_CODE_TS |
UNKNOWN |
TIMESHEET_ORGANIZATION_DESC |
ORGANIZATION DESCRIPTION. |
|
FTVORGN / PTVORGN |
TITLE / DESC |
UNKNOWN |
CHART_OF_ACCOUNTS |
INSTITUTIONAL DEFINED VALUE FOR THE CHART OF ACCOUNTS. |
|
NBRBJOB |
NBRBJOB_COAS_CODE |
UNKNOWN |
STEP_INCREASE_MONTH |
MONTH IN WHICH AN AUTOMATIC STEP INCREASE IS TO TAKE PLACE. |
|
NBRBJOB |
NBRBJOB_STEP_INCR_MON |
UNKNOWN |
STEP_INCREASE_DAY |
DAY OF THE MONTH IN WHICH AN AUTOMATIC STEP INCREASE IS TO TAKE PLACE. |
|
NBRBJOB |
NBRBJOB_STEP_INCR_DAY |
UNKNOWN |
POSITION_LOW_SALARY |
LOW END OF THE RANGE FOR THE SALARY TABLE AND GRADE BEING DEFINED. |
|
NTRSALB |
NTRSALB_LOW |
UNKNOWN |
POSITION_MID_SALARY |
MIDDLE POINT OF THE RANGE FOR THE SALARY TABLE AND GRADE BEING DEFINED. |
|
NTRSALB |
NTRSALB_MIDPOINT |
UNKNOWN |
POSITION_HIGH_SALARY |
HIGH END OF THE RANGE FOR THE SALARY TABLE AND GRADE BEING DEFINED. |
|
NTRSALB |
NTRSALB_HIGH |
UNKNOWN |
BELOW_SALARY_RANGE_IND |
BELOW SALARY RANGE INDICATOR |
|
FUNCTION |
F_RANGE_IND |
UNKNOWN |
IN_SALARY_RANGE_IND |
IN SALARY RANGE INDICATOR. |
|
FUNCTION |
F_RANGE_IND |
UNKNOWN |
ABOVE_SALARY_RANGE_IND |
ABOVE SALARY RANGE INDICATOR. |
|
FUNCTION |
F_RANGE_IND |
UNKNOWN |
NEXT_AUTO_STEP_INCREASE |
SELECT THE NEXT AUTO STEP INCREASE BASED ON THE COMBINATION OF SALARY TABLE |
|
FUNCTION |
F_NEXT_AUTO_STEP |
UNKNOWN |
SALARY_IND |
INDICATES IF THE SALARIES/RATES BEING DEFINED ARE HOURLY RATES OR ANNUAL SALARIES. |
|
NTRSALB |
NTRSALB_IND |
UNKNOWN |
ANNUAL_SALARY |
ANNUAL SALARY FOR THE POSITION BASED ON THE CALENDAR YEAR. |
|
NBRJOBS |
NBRJOBS_ANN_SALARY |
UNKNOWN |
POSITION_ASSIGNMENT_PAY |
SALARY TO BE PAID EACH PAY PERIOD. |
|
NBRJOBS |
NBRJOBS_ASSGN_SALARY |
UNKNOWN |
PER_PAY_SALARY |
USED FOR DEFERRED PAY CALCULATIONS. |
|
NBRJOBS |
NBRJOBS_PER_PAY_SALARY |
UNKNOWN |
HOURLY_RATE |
REGULAR HOURLY RATE FOR THIS POSITION. |
|
NBRJOBS |
NBRJOBS_REG_RATE |
UNKNOWN |
ASSIGNMENT_PAY_ID |
PAY ID TO WHICH THIS POSITION BELONGS. |
|
NBRJOBS |
NBRJOBS_PICT_CODE |
UNKNOWN |
ASSIGNMENT_PAY_ID_DESC |
|
|
PTRPICT |
PTRPICT_DESC |
UNKNOWN |
JOB_LEAVE_CATEGORY |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
JOB_LEAVE_CATEGORY_DESC |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
ASSIGNMENT_FACTOR |
NUMBER OF PAYS PER CALENDAR YEAR. |
|
NBRJOBS |
NBRJOBS_FACTOR |
UNKNOWN |
POSITION_DEFERRED_PAY |
IDENTIFIES RULES GOVERNING DEFERRED PAY. |
|
NBRJOBS |
NBRJOBS_DFRP_CODE |
UNKNOWN |
POSITION_DEFERRED_PAY_DESC |
DEFERRED PAY DESCRIPTION. |
|
PTRDFRP |
PTRDFRP_DESC |
UNKNOWN |
NUMBER_OF_PAYS |
USED FOR DEFERRED PAY CALCULATIONS. |
|
NBRJOBS |
NBRJOBS_PAYS |
UNKNOWN |
DEFERRED_PAY_AMOUNT |
AMOUNT DEFERRED EACH PAY PERIOD FOR DEFERRED PAY CALCULATION. |
|
NBRJOBS |
NBRJOBS_PER_PAY_DEFER_AMT |
UNKNOWN |
DEFERRED_PAY_AMOUNT_ADJ |
AMOUNT OF DEFERRED PAY ACCUMULATED FOR THIS POSITION. |
|
NBRJOBS |
NBRBJOB_DEFER_BAL |
UNKNOWN |
ENCUMBRANCE_AMOUNT |
AMOUNT OF MONEY THAT THIS PERSON WILL BE PAID IN THIS POSITION DURING THE CURRENT FISCAL YEAR. |
|
NBRJOBS |
NBRBJOB_SALARY_ENCUMBRANCE |
UNKNOWN |
FTE_EFFECTIVE_DATE |
DATE THAT THE FTE CALCULATIONS RECORD BECOMES EFFECTIVE. |
|
NBRJFTE |
NBRJFTE_FTE_EFFECTIVE_DATE |
UNKNOWN |
FTE_START_DATE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
FTE_END_DATE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
POSITION_APPOINTMENT_PCT |
PERCENT EFFORT FOR THE POSITION. |
|
NBRJFTE |
NBRJFTE_APPT_PCT |
UNKNOWN |
ANNUALIZED_FTE |
PERIOD OF TIME A POSITION IS BASED UPON OR BUDGETED FOR. |
|
NBRJFTE |
NBRJFTE_ANN_FTE |
UNKNOWN |
FTE_BASE_SALARY |
FULL TIME EQUIVALENCY SALARY FOR A POSITION ANNUAL BASIS. |
|
NBRJFTE |
NBRJFTE_BASE_SALARY |
UNKNOWN |
PROBATION_UNITS |
IDENTIFIES THE NUMBER OF PROBATIONARY UNITS. |
|
NBRBJOB |
NBRBJOB_PROBATION_UNITS |
UNKNOWN |
PROBATION_BEGIN_DATE |
BEGIN DATE OF PROBATIONARY PERIOD. |
|
NBRBJOB |
NBRBJOB_PROBATION_BEGIN_DATE |
UNKNOWN |
PROBATION_END_DATE |
END DATE OF PROBATIONARY PERIOD. |
|
NBRBJOB |
NBRBJOB_PROBATION_END_DATE |
UNKNOWN |
FEDERAL_REPORT_IND |
IPEDS REPORT INDICATOR. |
|
NBRBJOB |
NBRBJOB_IPEDS_REPT_IND |
UNKNOWN |
PROFILE_DATE |
INFORMATION IN THIS MODEL WILL BE RETURNED 'AS OF' THE PROFILE DATE |
|
FUNCTION |
F_PROFILE_DATE |
UNKNOWN |
EMPLOYER_CODE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
EMPLOYER_DESC |
EMPLOYER DESCRIPTION. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
POSITION_LABOR_DIST_COUNT |
NUMBER OF THE LABOR DISTRIBUTIONS ASSOCIATED WITH THE APPROVED POSITION. |
|
FUNCTION |
? |
UNKNOWN |
LABOR_COST_DISTRIBUTION_COUNT |
NUMBER OF LABOR COST DISTRIBUTIONS ASSOCIATED WITH THE PERSON AS AN EMPLOYEE. |
|
FUNCTION |
? |
UNKNOWN |
PAY_CODE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
PAY_DESC |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |