Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
(Banner EDW Source Report)
Human Resources Reporting View Reports

Banner Operational Data Store
Reporting View Target: POSITION_DEFINITION

Description Contains detailed information concerning available positions.
Key & Frequency One row per position.
Recommended Search Columns POSITION

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

BARGAINING_UNIT Default bargaining unit code associated with this position. VARCHAR2(63)

NBBPOSN

NBBPOSN_BARG_CODE

BARGAINING_UNIT_DESC Bargaining unit code description. VARCHAR2(255)

PTVBARG

PTVBARG_DESC

BUDGET_ROLL_IND Budget roll indicator. Identifies the budget amount to be rolled into a new fiscal year. VARCHAR2(1)

NBBPOSN

NBBPOSN_ROLL_IND

BUDGET_ROLL_IND_DESC Budget roll indicator description. VARCHAR2(255)

CALCULATION

CASE NBBPOSN_ROLL_IND

BUDGET_TYPE Budget type is the expected funding status for the position. VARCHAR2(63)

NBBPOSN

NBBPOSN_BUDGET_TYPE

BUDGET_TYPE_DESC Budget type description. VARCHAR2(255)

MGT_VALIDATION

SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'BUDGET_TYPE' AND VALUE = BUDGET_TYPE

CHANGE_DATE_TIME Date and time this record was changed. DATE

NBBPOSN

NBBPOSN_CHANGE_DATE_TIME

EEO_CATEGORY Used by institutions of higher education for Equal Employment Opportunity reporting as defined by the federal government. VARCHAR2(63)

NTRPCLS

NTRPCLS_ESKL_CODE

EEO_CATEGORY_DESC EEO category code description. VARCHAR2(255)

PTVESKL

PTVESKL_DESC

EEO_FUNCTION For government agencies only. Equal employment opportunity (EEO) function type as defined by a federal government, for use with EEO reporting. VARCHAR2(63)

NTRPCLS

NTRPCLS_EFUN_CODE

EEO_FUNCTION_DESC EEO function description. VARCHAR2(255)

PTVEFUN

PTVEFUN_DESC

EEO_SKILL Used by institutions of higher education for Equal Employment Opportunity skills reporting as defined by the federal government. VARCHAR2(63)

NTRPCLS

NTRPCLS_ESKL_CODE

EEO_SKILL_DESC EEO skill description. VARCHAR2(255)

PTVESKL

PTVESKL_DESC

EMPLOYMENT_CATEGORY Federal employment reporting categories that identify either the number of month or whether the employment length is full time or part time. VARCHAR2(63)

NBBPOSN

NBBPOSN_ECIP_CODE

EMPLOYMENT_CATEGORY_DESC Employment category description VARCHAR2(255)

PTVECIP

PTVECIP_DESC

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

OCCUPATIONAL_TITLE Occupational title classification from the dictionary of occupational titles. VARCHAR2(63)

NBBPOSN

NBBPOSN_DOTT_CODE

OCCUPATIONAL_TITLE_DESC Occupational title description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

OCCUPATION_CLASSIFICATION General occupation classification in which a title is included for government reporting purposes. Provides a standardized framework for organizing occupations into a manageable, understandable and coherent system. VARCHAR2(63)

NBBPOSN

NBBPOSN_PFOC_CODE

OCCUPATION_CLASSIFICATION_DESC Occupation classification description. VARCHAR2(255)

NTVPFOC

NTVPFOC_DESC

POSITION Position number. VARCHAR2(63)

NBBPOSN

NBBPOSN_POSN

POSITION_APPOINTMENT_PCT Percentage for the appointed position. NUMBER

NBBPOSN

NBBPOSN_APPT_PCT

POSITION_BEGIN_DATE First date the position is funded to begin. The Begin Date must be within a defined fiscal year and must be before the End Date. DATE

NBBPOSN

NBBPOSN_BEGIN_DATE

POSITION_CLASS Organizes the job classifications for the institution and holds attributes that control title, employee class, eel code and wage and salary data. Also, the primary organizer for the design and maintenance of the position definition. These attributes are inherited when the employee is assigned to the position. VARCHAR2(63)

NBBPOSN

NBBPOSN_PCLS_CODE

POSITION_CLASS_DESC Position class description or title. Organizes the job classifications for the institution and holds attributes that control title, employee class, eel code and wage and salary data. Also, the primary organizer for the design and maintenance of the position definition. These attributes are inherited when the employee is assigned to the position. VARCHAR2(255)

NTRPCLS

NTRPCLS_DESC

POSITION_CLASS_EXEMPTION_IND Indicates if employees assigned to positions in this position class are exempt or non-exempt from federal overtime rules. VARCHAR2(1)

NTRPCLS

NTRPCLS_EXEMPT_IND

POSITION_EMPLOYEE_CLASS Employee class code. Organizes position information consistent with employee groupings. At the employee level, used to help determine controls for benefits, leave, payroll and self-service rules. VARCHAR2(63)

NBBPOSN

NBBPOSN_ECLS_CODE

POSITION_EMPLOYEE_CLASS_DESC Employee class description. VARCHAR2(255)

PTRECLS

PTRECLS_LONG_DESC

POSITION_EMPLOYEE_GROUP Sub-category of the position employee class. VARCHAR2(63)

PTRECLS

PTRECLS_EGRP_CODE

POSITION_EMPLOYEE_GROUP_DESC Position employee group description. VARCHAR2(255)

PTVEGRP

PTVEGRP_DESC

POSITION_END_DATE End date of the position. If NA, the position is presumed to be a permanent position. DATE

NBBPOSN

NBBPOSN_END_DATE

POSITION_EXEMPTION_IND Indicates if employees assigned to this position are exempt or non-exempt from federal overtime rules. VARCHAR2(1)

NBBPOSN

NBBPOSN_EXEMPT_IND

POSITION_GROUP Groups like positions together for analysis of job succession and job family information. VARCHAR2(63)

NBBPOSN

NBBPOSN_PGRP_CODE

POSITION_GROUP_DESC Position group description. VARCHAR2(255)

PTRPGRP

PTRPGRP_DESC

POSITION_LOCATION Position location code. VARCHAR2(63)

NBBPOSN

NBBPOSN_JBLN_CODE

POSITION_LOCATION_DESC Position location description. VARCHAR2(255)

PTRJBLN

PTRJBLN_DESC

POSITION_PROGRESSION Position progression family code that groups like positions in sequence order. VARCHAR2(63)

NBBPOSN

NBBPOSN_JOBP_CODE

POSITION_PROGRESSION_DESC Position progression description. VARCHAR2(255)

NTVJOBP

NTVJOBP_DESC

POSITION_REPORTS Position to which this position reports. Identifies the next position in the organizational hierarchy. The reports to position must have a position definition and cannot report to itself. VARCHAR2(63)

CALCULATION

NVL(NBBPOSN_POSN_REPORTS, MPKFUNC.F_GET_POSITION_REPORTS)

POSITION_REPORTS_TITLE Title of the position to which this position reports. VARCHAR2(63)

FUNCTION

MPKFUNC.F_GET_POSITION_REPORTS

POSITION_STATUS Current status of the position (Active, Cancelled or Frozen). VARCHAR2(63)

NBBPOSN

NBBPOSN_STATUS

POSITION_STATUS_DESC Position status description. VARCHAR2(255)

CALCULATION

DECODE(NBBPOSN_STATUS,'A',ACTIVE,'C',CANCELLED,'F',FROZEN,'I',INACTIVE)

POSITION_TITLE Position title. VARCHAR2(63)

NBBPOSN

NBBPOSN_TITLE

POSITION_TYPE Single or pooled position. VARCHAR2(1)

NBBPOSN

NBBPOSN_TYPE

PREMIUM_EARNINGS_ROLL_IND Specifies how to roll budget for premium earnings from one year to the next. Values are (C)urrent Budget Amount, (A)ctual Expenditure for Current Year, (Z)ero, or (N)ot Applicable. VARCHAR2(1)

NBBPOSN

NBBPOSN_PREMIUM_ROLL_IND

PREMIUM_EARNINGS_ROLL_IND_DESC Premium earning roll indicator description. VARCHAR2(255)

CALCULATION

CASE NBBPOSN_PREMIUM_ROLL_IND

PROBATION_UNITS Number of probationary units. NUMBER

NBBPOSN

NBBPOSN_PROBATION_UNITS

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

PROGRAM_CLASSIFICATION Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting. VARCHAR2(63)

NBBPOSN

NBBPOSN_CIPC_CODE

PROGRAM_CLASSIFICATION_DESC Program classification description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SALARY_GRADE Salary grade that is associated with positions in this position class. VARCHAR2(63)

NTRPCLS

NTRPCLS_GRADE

SALARY_GROUP Salary group code. VARCHAR2(63)

CALCULATION

NTRPCLS

NVL(NBBPOSN_SGRP_CODE, NTRPCLS_SGRP_CODE)

NTRPCLS_SGRP_CODE

SALARY_STEP Salary step associated with the salary grade that is associated with positions assigned to this position class. NUMBER

NTRPCLS

NTRPCLS_STEP

SALARY_TABLE Salary table associated with positions assigned to this position class. VARCHAR2(63)

NTRPCLS

NTRPCLS_TABLE

SENIORITY_ACCRUED_IND Indicates if seniority hours are accrued against this position. VARCHAR2(1)

CALCULATION

NVL(NBBPOSN_ACCRUE_SENIORITY_IND,NTRPCLS_ACCRUE_SENIORITY_IND)

STANDARD_OCCUPATIONAL_CATEGORY Standard occupational categories defined by the government for federal reporting. VARCHAR2(63)

NBBPOSN

NBBPOSN_ESOC_CODE

STANDARD_OCCUPATIONAL_CAT_DESC Occupational category description. VARCHAR2(255)

PTRESOC

PTRESOC_DESC

WORK_SCHEDULE Default work schedule. VARCHAR2(63)

NBBPOSN

NBBPOSN_WKSH_CODE

WORK_SCHEDULE_DESC Work schedule description. VARCHAR2(255)

NTVWKSH

NTVWKSH_DESC



Ver: 9.1