Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
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 Local Source Local Target
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

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

NBBPOSN

NBBPOSN_BARG_CODE

NO

NO
BARGAINING_UNIT_DESC Bargaining unit code description. VARCHAR2(255)

PTVBARG

PTVBARG_DESC

NO

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

NBBPOSN

NBBPOSN_ROLL_IND

NO

NO
BUDGET_ROLL_IND_DESC Budget roll indicator description. VARCHAR2(255)

CALCULATION

CASE NBBPOSN_ROLL_IND

NO

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

NBBPOSN

NBBPOSN_BUDGET_TYPE

NO

NO
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

NO

NO
CHANGE_DATE_TIME Date and time this record was changed. DATE

NBBPOSN

NBBPOSN_CHANGE_DATE_TIME

NO

NO
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

NO

NO
EEO_CATEGORY_DESC EEO category code description. VARCHAR2(255)

PTVESKL

PTVESKL_DESC

NO

NO
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

NO

NO
EEO_FUNCTION_DESC EEO function description. VARCHAR2(255)

PTVEFUN

PTVEFUN_DESC

NO

NO
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

NO

NO
EEO_SKILL_DESC EEO skill description. VARCHAR2(255)

PTVESKL

PTVESKL_DESC

NO

NO
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

NO

NO
EMPLOYMENT_CATEGORY_DESC Employment category description VARCHAR2(255)

PTVECIP

PTVECIP_DESC

NO

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

NA

NA

NO

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

NA

NA

NO

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

NBBPOSN

NBBPOSN_DOTT_CODE

NO

NO
OCCUPATIONAL_TITLE_DESC Occupational title description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
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

NO

NO
OCCUPATION_CLASSIFICATION_DESC Occupation classification description. VARCHAR2(255)

NTVPFOC

NTVPFOC_DESC

NO

NO
POSITION Position number. VARCHAR2(63)

NBBPOSN

NBBPOSN_POSN

NO

NO
POSITION_APPOINTMENT_PCT Percentage for the appointed position. NUMBER

NBBPOSN

NBBPOSN_APPT_PCT

NO

NO
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

NO

NO
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

NO

NO
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

NO

NO
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

NO

NO
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

NO

NO
POSITION_EMPLOYEE_CLASS_DESC Employee class description. VARCHAR2(255)

PTRECLS

PTRECLS_LONG_DESC

NO

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

PTRECLS

PTRECLS_EGRP_CODE

NO

NO
POSITION_EMPLOYEE_GROUP_DESC Position employee group description. VARCHAR2(255)

PTVEGRP

PTVEGRP_DESC

NO

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

NBBPOSN

NBBPOSN_END_DATE

NO

NO
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

NO

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

NBBPOSN

NBBPOSN_PGRP_CODE

NO

NO
POSITION_GROUP_DESC Position group description. VARCHAR2(255)

PTRPGRP

PTRPGRP_DESC

NO

NO
POSITION_LOCATION Position location code. VARCHAR2(63)

NBBPOSN

NBBPOSN_JBLN_CODE

NO

NO
POSITION_LOCATION_DESC Position location description. VARCHAR2(255)

PTRJBLN

PTRJBLN_DESC

NO

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

NBBPOSN

NBBPOSN_JOBP_CODE

NO

NO
POSITION_PROGRESSION_DESC Position progression description. VARCHAR2(255)

NTVJOBP

NTVJOBP_DESC

NO

NO
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)

NO

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

FUNCTION

MPKFUNC.F_GET_POSITION_REPORTS

NO

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

NBBPOSN

NBBPOSN_STATUS

NO

NO
POSITION_STATUS_DESC Position status description. VARCHAR2(255)

CALCULATION

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

NO

NO
POSITION_TITLE Position title. VARCHAR2(63)

NBBPOSN

NBBPOSN_TITLE

NO

NO
POSITION_TYPE Single or pooled position. VARCHAR2(1)

NBBPOSN

NBBPOSN_TYPE

NO

NO
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

NO

NO
PREMIUM_EARNINGS_ROLL_IND_DESC Premium earning roll indicator description. VARCHAR2(255)

CALCULATION

CASE NBBPOSN_PREMIUM_ROLL_IND

NO

NO
PROBATION_UNITS Number of probationary units. NUMBER

NBBPOSN

NBBPOSN_PROBATION_UNITS

NO

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

NA

NA

NO

NO
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

NO

NO
PROGRAM_CLASSIFICATION_DESC Program classification description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

NTRPCLS

NTRPCLS_GRADE

NO

NO
SALARY_GROUP Salary group code. VARCHAR2(63)

CALCULATION

NTRPCLS

NVL(NBBPOSN_SGRP_CODE, NTRPCLS_SGRP_CODE)

NTRPCLS_SGRP_CODE

NO

NO

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

NTRPCLS

NTRPCLS_STEP

NO

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

NTRPCLS

NTRPCLS_TABLE

NO

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

CALCULATION

NVL(NBBPOSN_ACCRUE_SENIORITY_IND,NTRPCLS_ACCRUE_SENIORITY_IND)

NO

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

NBBPOSN

NBBPOSN_ESOC_CODE

NO

NO
STANDARD_OCCUPATIONAL_CAT_DESC Occupational category description. VARCHAR2(255)

PTRESOC

PTRESOC_DESC

NO

NO
WORK_SCHEDULE Default work schedule. VARCHAR2(63)

NBBPOSN

NBBPOSN_WKSH_CODE

NO

NO
WORK_SCHEDULE_DESC Work schedule description. VARCHAR2(255)

NTVWKSH

NTVWKSH_DESC

NO

NO


Ver: 9.2