ncsu
controller
Work Team
office financial services
meeting
home about contact forms links search staff
news

picture Memos and News Financial Reports

Questions and Answers

Procedures
Guidlelines and References
Processing
Performance
Training
Accounting System
Feedback
Steering Team
Business Officers
Monitoring Tools
System Upgrade

PeopleSoft Production Queries

* = Available only in Production

** = Available in both Production and Reporting

Query Name

JE_BY_ID *

JOURNAL_INFO**

PROJECT_ACTIVITY_BY_MONTH**

Criteria Needed

Fiscal Year

Operator ID

Fiscal Year

Accounting Period

Journal ID

Fiscal Year

Accounting Period

Project Number


Query Results

Ledger Group

Journal ID

Journal Date

SourceJournal

Header Status

Budget Header Status

Journal Process Request

Fiscal Year

Accounting Period

Operator Identification

Date and Time Stamp

Journal ID

Journal Date

Source

Journal Header Status

Journal Process Request

Program

Subclass

Amount

Fiscal Year

Accounting Period

Operator Identification

Journal Line Number

Project Number

Account Number

Organization

Line Description

Journal Reference

Journal ID

Journal Date

Source

Journal Header Status

Program

Subclass

Amount

Posted Date

Fiscal Year

Accounting Period

Operator Identification

Journal Line Number

Project Number

Account Number

Organization

Header & Line Description

Journal Reference