Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Human Resources Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AN_POSITION_DEFINITION

Description Source composite view contains details associated with a position whether posted or filled.

Target Column Business Definition Database Data Type Source Name Source Column
BARGAINING_UNIT Default bargaining unit code associated with this position. VARCHAR2(2)

NBBPOSN

NBBPOSN_BARG_CODE

BARGAINING_UNIT_DESC Bargaining unit code description. VARCHAR2(30)

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

CHANGE_DATE_TIME Date and time this record was changed. DATE

NBRCLSH

NBRCLSH_CHANGE_DATE_TIME

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

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

NTRPCLS

NTRPCLS_ESKL_CODE

EEO_CATEGORY_DESC EEO category code description. VARCHAR2(30)

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(2)

NTRPCLS

NTRPCLS_EFUN_CODE

EEO_FUNCTION_DESC EEO function description. VARCHAR2(30)

PTVEFUN

PTVEFUN_DESC

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

NTRPCLS

NTRPCLS_ESKL_CODE

EEO_SKILL_DESC EEO skill description. VARCHAR2(30)

PTVESKL

PTVESKL_DESC

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

NA

NA

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

NA

NA

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

NBBPOSN

NBBPOSN_DOTT_CODE

OCCUPATIONAL_TITLE_DESC Occupational title description. VARCHAR2(60)

NTVDOTT

NTVDOTT_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(3)

NBBPOSN

NBBPOSN_PFOC_CODE

OCCUPATION_CLASSIFICATION_DESC Occupation classification description. VARCHAR2(60)

NTVPFOC

NTVPFOC_DESC

POSITION Position number. VARCHAR2(6)

NBBPOSN

NBBPOSN_POSN

POSITION_APPOINTMENT_PCT Establishes the percentage of full time appointment. The Low, Mid and High salary fields are adjusted by this percentage. NUMBER(5, 2)

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(5)

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(30)

NTRPCLS

NTRPCLS_DESC

POSITION_CLASS_EXEMPTION_IND Indicates if employees assigned to this position 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(2)

NBBPOSN

NBBPOSN_ECLS_CODE

POSITION_EMPLOYEE_CLASS_DESC Employee class description. VARCHAR2(30)

PTRECLS

PTRECLS_LONG_DESC

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

PTRECLS

PTRECLS_EGRP_CODE

POSITION_EMPLOYEE_GROUP_DESC Position employee group description. VARCHAR2(30)

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(4)

NBBPOSN

NBBPOSN_PGRP_CODE

POSITION_GROUP_DESC Position group description. VARCHAR2(30)

PTRPGRP

PTRPGRP_DESC

POSITION_LOCATION Position location code. VARCHAR2(6)

NBBPOSN

NBBPOSN_JBLN_CODE

POSITION_LOCATION_DESC Position location code description. VARCHAR2(30)

PTRJBLN

PTRJBLN_DESC

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

NBBPOSN

NBBPOSN_JOBP_CODE

POSITION_PROGRESSION_DESC Position progression description. VARCHAR2(30)

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(6)

NBBPOSN

NBBPOSN_POSN_REPORTS

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

FUNCTION

MPKFUNC.F_GET_POSITION_REPORTS

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

NBBPOSN

NBBPOSN_STATUS

POSITION_STATUS_DESC Position Status description. VARCHAR2(30)

CALCULATION

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

POSITION_TITLE Position title. VARCHAR2(30)

NBBPOSN

NBBPOSN_TITLE

POSITION_TYPE Single or pooled position. VARCHAR2(1)

NBBPOSN

NBBPOSN_TYPE

PREMIUM_EARNINGS_ROLL_IND Indicator that specifies how to roll budget for premium earnings. VARCHAR2(1)

NBBPOSN

NBBPOSN_PREMIUM_ROLL_IND

PROBATION_UNITS Number of probationary units. NUMBER(3)

NBBPOSN

NBBPOSN_PROBATION_UNITS

PROGRAM_CLASSIFICATION Program classification associated with the major subject area of study for this outcome. Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government. VARCHAR2(6)

NBBPOSN

NBBPOSN_CIPC_CODE

PROGRAM_CLASSIFICATION_DESC Program classification description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

CALCULATION

NVL(NBBPOSN_GRADE,NTRPCLS_GRADE)

SALARY_GROUP Salary group code. VARCHAR2(6)

NTRPCLS

NTRPCLS_SGRP_CODE

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

CALCULATION

NVL(NBBPOSN_STEP,NTRPCLS_STEP)

SALARY_TABLE Salary table that is associated with positions assigned to this position class. VARCHAR2(2)

CALCULATION

NVL(NBBPOSN_TABLE,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)

WORK_SCHEDULE Default work schedule. VARCHAR2(4)

NBBPOSN

NBBPOSN_WKSH_CODE

WORK_SCHEDULE_DESC Work schedule description. VARCHAR2(30)

NTVWKSH

NTVWKSH_DESC

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

NA

NA



Ver: 8.0