B0149 Positions by Funding Source

Purpose

The purpose of this Report Description is to display positions by funding source in the Integrated HR-Payroll System.

Report Description

The B0149 Positions by Funding Source report shows the position, funding information, funding source, fund, application of funds, cost center, employee salary, and total budget amt. This report also shows the position full-time equivalent (FTE) counts.

Report Location

OM: Position Budget Data

Report Uses

This report can be generated to view a list of positions with funding information for specified organizational units so it can be used for budget funding planning for positions.
The report can be used to compare the employees’ annual salaries with the budgeted salaries of the positions within the org unit specified.

How to Generate This Report

This report is generated after selecting values for the mandatory prompts. All mandatory prompts must have values selected before the Run Icon can be used to generate the report. Mandatory prompts can be identified as mandatory by the exclamation mark inside of the yellow-orange triangle, the square with the checkmark, or the display of (Mandatory). Detailed instructions for interaction with each prompt can be found on the Web Intelligence Prompt List on the OSC website.

The Mandatory prompts for this report are:

Organizational Unit
Calendar Month/Year
This prompt must be completed prior to other mandatory prompts

This report can also be further limited by utilizing the Optional prompts to further limiting the amount of data that retrieved into the body of the report. Optional prompts are indicated as option in parentheses beside the prompt.

The Optional prompts are:

Jobs
Positions
Cost Center(s)
Fund(s)
Application of Fund(s)

Exclusion prompts exclude specified data by default while allowing customers the flexibility of changing them when necessary. Exclusion prompts are identified by the term Exclude followed by the prompt.

The Exclusion prompts are:

Employee Subgroup (Contractor)

Initial Layout

The report is generated with a list of positions for the org unit entered as of the selected calendar month/year. This is a sample row from the report, which shows the columns available on the base report:

Continued...

Available Objects

This is a list of the available objects that can be added to the report, once in Design mode:

Dimensions

Addl Center Ref.
Address Line 1
Application of Fund
Budget Funding Source (OSBM)
Business area
Cal Mth/Yr
Controlling area
Cost Center
Cost Center Category
County
Employee
Employee Group
Employee Subgroup
Employee’s Name
FCTR Cat
FCTR Ref
Financial Key
FM area
Fund
Fund Type
Funding Source
Job
Job Branch
Job Country
Job ESG CAP
Job Family
Job Pay Area
Job Pay Group
Job Pay Level
Job Pay Type
Judicial Annv Date
NCAS Account
NCFS Account
NCFS Agency
NCFS Agency Program
NCFS AMU
NCFS Budget Code
NCFS Budge Fund
NCFS Funding Source
NCFS Interfund
Order
Org Unit
PMIS 15-Digit Positi
Pos City
Pos Country
Pos County
Pos ESG CAP
Pos Pay Area
Pos Pay Group
Pos Pay Level
Pos Pay Type
Pos Personnel Area
Position
Position End Date
Position Start Date
Reference SAP pos
SAP GL Account
SFCTR Ref
State
Statutory Exemption Type
Supervising Position
Vacancy Status
Valid From
Valid To

Measures

Budget Amt per Emp
Emp Salary per Fund
FT FTE Positions
Fund %
Number of Positions
Position FTE
PT FTE Positions

Variables

Prompt Response Application of Fund
Prompt Response Calendar Month/Year
Prompt Response Cost Center
Prompt Response Exclude Employee Subgroup
Prompt Response Fund
Prompt Response Job
Prompt Response Organizational Unit
Prompt Response Position
DOT NCFS AMU
DOT NCFS Budget Fund
Difference Budget Amt & Salary Amt

Special Report Considerations/Features

Vacant positions are identified by having no employee assigned to the position as of Calendar Month/Year. Calendar Month/Year for previous months is represented as the last day of the month (i.e., Jan 2014 equals Jan 31, 2014). If the current month/year was selected, then the actual date is current date minus one day.
FTE calculations for positions are based on the employee subgroups.
The position is considered a full-time position if it belongs to one of the following employee subgroups:
- FT N-FLSAOT Perm Dir
- FT N-FLSAOTTL Dir
- FT N-FLSAOT Temp Dir
- FT N-FLSAOT Perm JB1
- FT N-FLSAOT TL JG1
- FT N-FLSAOT Temp JB1
- FT N-FLSAOT Perm JB2
- FT N-FLSAOT TL JB2
- FT N-FLSAOT Temp JB2
- FT N-FLSAOT Perm JB3
- FT N-FLSAOT TM JB3
- FT N-FLSAOT Perm DA
- FT N-FLSAOT Tl DA
- FT N-FLSAOT Temp DA
- FT N-FLSAOT Perm ADA
- FT N-FLSAOT TL ADA
- FT N-FLSAOT Temp ADA
- FT N-FLSAOT Perm MAG
- FT N-FLSAOT TL MAG
- FT N-FLSAOT Temp MAG
- FT S-FLSAOT Perm CR
- FT S-FLSAOT TL CR
- FT S-FLSAOT Temp CR
- FT S-FLSAOT Perm CSC
- FT S-FLSAOT TL CSC
- FT S-FLSAOT Temp CSC
- FT S-FLSAOT Perm
- FT S-FLSAOT Prob TL
- FT S-FLSAOT TL Prob
- FT S-FLSAOT Student
- FT S-FLSAOT Intermit
- FT S-FLSAOT Perm
- FT N-FLSAOT Prob
- FT N-FLSAOT TL
- FT N-FLSAOT TL Prob
- FT N-FLSAOT Student
- FT N-FLSAOT Intermit
- FT N-FLSAOT Perm
- FT N-FLSAOT Prob
- FT N-FLSAOT TL
- FT N-FLSAOT TL Prob
- FT N-FLSAOT Student
- FT N-FLSAOT Intermit
- FT N-FLSAOT Time
- FT N-FLSAOT Fld Tme
- FT N-FLSAOT Perm 12C
- FT N-FLSAOT Prob 2C
- FT N-FLSAOT TL 12C
- FT N-FLSAOT TL Prob 12C
- FT N-FLSAOT Perm 12C
- FT N-FLSAOT Prob 12C
- FT N-FLSAOT TL 12C
- FT N-FLSAOT TL Prob 12C
- FT S-FLSAOT Perm 12C
- FT S-FLSAOT Prob 12C
- FT S-FLSAOT TL 12C
- FT S-FLSAOT TL Prob 12C
- FT S-FLSAOT Perm 11C
- FT S-FLSAOT Prob 11C
- FT S-FLSAOT TL 11C
- FT S-FLSAOT TL Prob 11C
- N/A EPA ConstitutOff
- N/A EPA Sal BD&Com
- N/A EPA Sal GA
- N/A EPA SalGA RecGov
- N/A EPA Lt Gov Staff
- N/A EPA Gov’s Staff
- N/A EPA SalGov&ABC
- N/A EPA Pol-MkingGov
- N/A EPA StatutoryPos
- N/A EPA Pos Gov
- N/A EPA PM Conf Asst
- N/A EPA PM Conf Sec
- N/A EPA Chief Deputy
- N/A EPA StatGAAprAct
- N/A EPA MiscStat Pos
- N/A EPA ExManagerial Contractor
- Pick-up Firefighter
- National Guard
- Federal
- Temp FT N-FLSAOT
- Temp FT S-FLSAOT
- Temp Sol FT N-FLSAOT
- Temp Sol FT S-FLSAOT
- FT N-FLOSA Perm 10C
- FT N-FLOSA Prob 10C
- FT N-FLOSA TL 10C
- FT N-FLOSA TL Prob 10C
- FT S-FLOSA Perm 10C
- FT S-FLOSA Prob 10C
- FT S-FLOSA TL 10C
- FT S-FLOSA TL Prob 10C
- FT EPA
- FT N-FLSA Perm 115C
- FT N-FLSA Prob 115C
- FT N-FLSA TL 115C
- FT N-FLSA TL Prob 115C
- FT S-FLSA Perm 115C
- FT S-FLSA Prob 115C
- FT S-FLSA TL115C
- FT S-FLSALT Prob 115C
- FT N-FLSAOT Perm SC
- FT N-FLSAOT TL SC
- FT N-FLSAOT Temp SC
- FT N-FLSAOT Perm CJP
- FT N-FLSAOT TL CJP
- FT N-FLSAOT Temp CJP
- FT N-FLSAOT Perm ACJP
- FT N-FLSAOT TL ACJP
- FT N-FLSAOT Temp ACJP
- FT S-FLSAOT Perm ACJP
- FT S-FLSAOT TL ACJP
- FT N-FLSAOT Perm AD
- FT N-FLSAOT TL AD
- FT N-FLSAOT Temp AD
- FT N-FLSAOT Perm JBS
- FT N-FLSAOT TL JBS
- FT N-FLSAOT Temp JBS
- FT S-FLSAOT Perm JBS
- FT S-FLSAOT TL JBS
- FT S-FLSAOT Temp JBS
- N/A EPA ConsitutOff
- N/A EPA Sal Bd & Com
- N/A EPA Sal GA
- N/A EPA Sal GARecGov
- N/A EPA Lt Gov Staff
- N/A EPA Gov’s Staff
- N/A EPA Sal Gov&ABC
- N/A EPA Pol-MkingGov
- N/A EPA StatutoryPos
- N/A EPA Pos Gov
- N/A EPA PM Conf Asst
- N/A EPA PM Conf Sec
- N/A EPA Chief Deputy
- N/A EPA StatGAAprAct
- N/A EPA MiscStat Pos
- N/A EPA ExManagerial
The position is considered part-time if it belongs to one of the following employee subgroups:
- PT S-FLSAOT Perm MAG
- PT S-FLSAOT TL MAG
- PT S-FLSAOT Temp MAG
- PT N-FLSAOT Perm Dir
- PT N-FLSAOT TL Dir
- PT N-FLSAOT Temp Dir
- PT N-FLSAOT Perm JB1
- PT N-FLSAOT TL JB1
- PT N-FLSAOT Temp JB1
- PT N-FLSAOT Perm JB2
- PT N-FLSAOT TL JB2
- PT N-FLSAOT Temp JB2
- PT N-FLSAOT Perm JB3
- PT N-FLSAOT TL JB3
- PT N-FLSAOT Temp JB3
- PT N-FLSAOT Perm DA
- PT N-FLSAOT TL DA
- PT N-FLSAOT Temp DA
- PT N-FLSAOT Perm ADA
- PT N-FLSAOT TL ADA
- PT N-FLSAOT Temp ADA
- PT N-FLSAOT Perm MAG
- PT N-FLSAOT TL MAG
- PT N-FLSAOT Temp MAG
- PT S-FLSAOT Perm CR
- PT S-FLSAOT TL CR
- PT S-FLSAOT Temp CR
- PT N-FLSAOT Perm CSC
- PT N-FLSAOT TL CSC
- PT N-FLSAOT Temp CSC
- PT N-FLSAOT Perm 11C
- PT N-FLSAOT Prob 11C
- PT N-FLSAOT TL 11C
- PT N-FLSAOT TLProb 11C
- PT S-FLSAOT Perm 11C
- PT S-FLSAOT Prob 11C
- PT S-FLSAOT TL 11C
- PT S-FLSAOT TLProb 11C
- Volunteer
- Board Member
- Temp PT N-FLSAOT
- Temp PT S-FLSAOT
- Temp Sol PT N-FLSAOT
- Temp Sol PT S-FLSAOT
- PT N-FLSA Perm 10C
- PT N-FLSA Prob 10C
- PT N-FLSA TL 10C
- PT N-FLSA TLProb 10C
- PT S-FLSA Perm 10C
- PT S-FLSA Prob 10 TL 10C
- PT S-FLSA TLProb 10C
- PT EPA
- PT N-FLSAOT Perm SC
- PT N-FLSAOT TL SC
- PT N-FLSAOT Temp SC
- PT N-FLSA Perm 12C
- PT N-FLSA Prob 12C
- PT N-FLSA TL 12C
- PT N-FLSA TLProb 12C
- PT S-FLSA Perm 12C
- PT S-FLSA Prob 12C
- PT S-FLSA TL 12C
- PT S-FLSA TLProb 12
- PT N-FLSAOT Perm CJP
- PT N-FLSAOT TL CJP
- PT N-FLSAOT Temp CJP
- PT N-FLSAOT Perm ACJP
- PT N-FLSAOT TL ACJP
- PT N-FLSAOT Temp ACJP
- PT S-FLSAOT Perm ACJP
- PT S-FLSAOTTL ACJP
- PT S-FLSAOTTL ACJP
- PT S-FLSAOT Temp ACJP
- PT N-FLSAOT Perm AD
- PT N-FLSAOT Temp AD
- PT N-FLSAOT TL AD
- PT N-FLSAOTTemp AD
- PT N-FLSAOT Perm JBS
- PT N-FLSAOT TL JBS
- PT S-FLSAOT Temp JBS
- PT N-FLSAOT Perm
- PT N-FLSAOTProb
- PT N-FLSAOT TL
- PT N-FLSAOT TL Prob
- PT N-FLSAOT Student
- PT N-FLSAOT Intermit
- PT N-FLSAOT Perm 115C
- PT N-FLSAOT Prob 115C
- PT N-FLSAOT TL 115C
- PT S-FLSAOT Perm 115C
- PT S-FLSAOT Prob 115C
- PT S-FLSAOT TL 115C
- PT S-FLSAOT Prob 115C
- PT S-FLSAOT Perm
- PT S-FLSAOT Prob
- PT S-FLSAOT TL
- PT S-FLSAOT TL Prob
- PT S-FLSAOT Student
- PT S-FLSAOT Intermit
- PT S-FLSAOT Time
- PT S-FLSAOT RD Time
Position and Job abbreviated titles (Short Text) are available from the Position or Job attributes (expanded list) in Available objects.
Employee Subgroup G1 – Contractors are excluded from the report.
To include Contractors in the report, select Exclude Employee Subgroup (Contractors) from the Prompt box.

Click the Checkmark 1 to display selected Exclusion prompt.

Click the X next to G1 to remove G1 from the selected prompt.

If you drag and drop the 'Cost Center - Medium Test' from Available Objects but remove the original Cost Center Key from the layout, #MULTIVALUE error may appear in the totaling row.

Add the Cost Center key back to the report layout to resolve the #MULTIVALUE error.

Position Personnel area was added to this report on August 17, 2017, and began being populated at that time. If the report is generated for a date prior to August 2017, then the position personnel area will not be populated and will display as “#” or as “not assigned.”
NCFS Accounting Segments - are available for reporting in this report as drag and drop from Available Objects.
- NCFS accounting segments here are specific to an NCFS internal order in SAP HR/Payroll ERP system. Transactions with no NCFS internal orders will not display values for the NCFS segments in the BI BOBJ report.
- NCFS Agency, NCFS Agency Program, NCFS AMU, NCFS Budget Code, NCFS Budget Fund, NCFS Funding Source, NCFS Interfund, NCFS Project, NCFS User Define 1, NCFS User Define 2, NCFS User Define 3
Agencies (like NCDOT, DES and DWS) that do not use NCFS Internal Orders will not see the values for the above NCFS segments in reports.
NCFS Account and Budget Funding Source (OSBM) are available for reporting. Values correspond to the crosswalk for SAP GL Account and Funding Source in SAP HR Payroll system.
Financial Key is representative of internal order from NCFS and old NCAS systems.
NCDOT (NC02) specific fields DOT NCFS AMU and DOT NCFS Budget Fund are listed as BOBJ Variables in this report and are derived from NCDOT cost centers and Person Responsible (Addl Center Ref) values from SAP HR Payroll ERP system.

First Published

Thu, 04/28/2016

Last Updated

Fri, 01/09/2026