California State University, San Bernardino
PeopleSoft Query List
|
Category
|
|
Query Name
|
|
Descr
|
|
Required
Parameters |
|
Expected Results
|
| ChartField Desc | * | SB_ACCOUNT_VALUES_DESC | PS Account values w/ Description |
None
|
Returns current PS Account values with descriptions | |||
| * | SB_FUND_VALUES_DESC | PS Fund values w/ Description |
None
|
Returns current PS Fund values with descriptions | ||||
| * | SB_DEPTID_VALUES_DESC | PS DeptID values w/ Description |
None
|
Returns current PS DeptID values with descriptions | ||||
| SB_PROGRAM_VALUES_DESC | PS Program values w/ Description |
None
|
Returns current PS Program values with descriptions | |||||
| SB_CLASS_VALUES_DESC | PS Class values w/ Description |
None
|
Returns current PS Class values with descriptions | |||||
| SB_PROJECTID_VALUES_DESC | PS Proj ID values w/ description |
None
|
Returns current PS Project/Grant values with descriptions | |||||
| Translations | SB_ACCOUNT_TRANSLATION | Translate FRS Sub-Code/Control Code to PS Account, FIRMS, State GL |
None
|
Returns FRS Sub-Codes/Control Codes (4-digit) to PeopleSoft Account values and corresponding FIRMS Object Cd, State GL Acct w/Description. Not complete list of PeopleSoft Accounts. | ||||
| * | SB_ACCOUNT_TRANSLAT_SIMPLE | FRS subcode to PeopleSoft Acct w eff date |
None
|
Returns FRS to PeopleSoft Account translation w/ Eff. Date. Not complete list of PeopleSoft Accounts. | ||||
| * | SB_CNVR_TBL_W_DESC_BY_FRS_ACCT | Translate FRS to PeopleSoft w/ Description sorted by FRS Accounts |
FRS Account
|
Returns PeopleSoft ChartField combination w/ description for the specified FRS account code (6-digit) | ||||
| * | SB_CNVR_TBL_W_DESCR_ALL | Translate FRS to PeopleSoft w/ Description |
Business Unit
|
Returns ALL PeopleSoft ChartField combinations (w/ descriptions) that are mapped to an FRS 6-digit account currently active in the PeopleSoft system. | ||||
| * | SB_PSFT_CF_TO_FRS_ACCT | Translate PeopleSoft ChartFields values to FRS Accounts |
Business Unit,
Fund, Department Program, Class (optional), Project (optional) |
Returns an FRS account
code (6-digit) and the associated description, as well as the specified
ChartField combination and associated descriptions. The system will return only the rows that match 100% to the specified parameters (e.g., if Class is not specified, the only rows returned will be those with a blank Class) |
||||
| Ledger Balances | * | SB_BUDGET_ACTUALS_BBA_CALC | Budget Balance Available
(Summary by ChartField combination and by Accounting period) |
Business Unit,
Fiscal Year, Accounting Period (From-To range), Fund (From-To range), Department (From-To range) |
Returns the ledger balaces
listed below for the Fund and Department ranges entered - results are sorted by fiscal year and accounting period: Budget, Pre-encumbrances (Reqs), Encumbrances (POs), Actuals, and calculated Budge Balance Available NOTE: MS Excel functions must be used to sort and sub-total data. |
|||
| SB_BUDGETS_ACTUALS_JRNL_LNS | List Budgets/Actuals Journal Detail Lines |
Business Unit,
Fiscal Year, Accounting Period (From-To range), Fund (From-To range), Department (From-To range) |
Returns the (posted and
unposted) journal lines for the Fund and Department ranges entered - -
results are sorted by fiscal year and accounting period. Does not show vendor or PO #. NOTE: MS Excel functions must be used to sort and sub-total data. |
|||||
| * | SB_BDGTS_ACT_JRNL_LNS_SPEC_VAL | * | List Budgets/Actuals Journal Detail Lines by Account and Period. |
Business Unit,
Fiscal Year, Accounting Period (From-To range), Fund (Wild Card % avail.), Dept (Wild Card, %, avail.), Account (Wild Card ,%, avail.) |
Returns the (posted and
unposted) journal lines for the Fund and Department and Account ranges
entered - - results are sorted by fiscal year and accounting period. Does not show Vendor or PO #. NOTE: MS Excel functions must be used to sort and sub-total data. Hide/delete unwanted columns. |
|||
| SB_REQ_JRNL_BY_JRNL_ID | Requisitions that are included
in GL Ledger Balance NOTE: Used when online drill-down screen totals do not match Ledger Balance |
Business Unit,
Account, Fund, Department, Program, Journal ID |
Returns ALL detail lines that are included
in the specified Requisition Journal ID. NOTE: MS Excel functions must be used to sort and sub-total data. |
|||||
| * | SB_BBA_REIMB_ACT_DEPT_LVL_2000 | * | Budget Balance Available
Budget, Encumb, Expense summary by ChartField combination and Account for Reimbursed Activity using DeptID and Class chartfield. SBCMP Business Unit only. |
Fiscal Year Accounting
Period (From-To range) Department (range)
Class (range) |
Returns Reimbursed Activity chartfield combo BBA calcuclation for given Department and Class. Funds are hard coded in query by Fund year group, i.e., 2000 = BD200, BF200, CR200. 2001 = BD201, BF201, CR201. NOTE: Minimal MS Excel functions: Subtotal at each change in Class. | |||
| * | SB_020_BBA_CALC_SPECIFIC_CFLDS | Similar to the SBGLS020 report run to BRIO Portal. Can be used in place of that report to view specific chartfield string Accounts and BBA calculation. Much quicker and more specific than the 020 report. Run to Excel. |
Business unit, Fiscal Year, Accounting Period, Fund,
Department, Program, Class, Project
|
Returns Account summary for chartfield string requested. Includes Budget, Actuals, Pre Encumbrance, Encumbrance, and Budget Balance Available (BBA) calculation. NOTE: Minimal column totaling in Excel. | ||||
| * | SB_BBA_REIMB_ACT_DEPT_LVL_2001 | * | Budget Balance Available
Budget, Encumb, Expense summary by ChartField combination and Account for Reimbursed Activity using DeptID and Class chartfield. SBCMP Business Unit only. |
Fiscal Year Accounting
Period (From-To range) Department (range)
Class (range) |
Returns Reimbursed Activity chartfield combo BBA calcuclation for given Department and Class. Funds are hard coded in query by Fund year group, i.e., 2000 = BD200, BF200, CR200. 2001 = BD201, BF201, CR201. NOTE: Minimal MS Excel functions: Subtotal at each change in Class. | |||
| Payment Inquiry | * | SB_PAY_DETAIL | Detail Payment Information |
Business Unit
From Payment Date To Payment Date |
Returns ALL payment information by Voucher
ID NOTE: MS Excel functions must be used to sort and sub-total data. |
|||
| Program Specific | SB_BBA_EXT_LEARNING | * | Program summary by Fund and Account for Continuing Education Revenue Fund (CERF) |
Fiscal Year, Period range
|
Summary BBA calculation by Fund and Account for CERF Funds. NOTE: Minimal MS Excel data sort. Subtotal at each change in Fund. | |||
| SB_BBA_EXT_LRNING_BY_TRST_FUND | * | Program summary by Trust Fund and Account for College of Extended Learning (CEL) |
Fiscal Year, Period range
|
Summary BBA calculation by Trust Fund and Account for CEL. NOTE: Minimal MS Excel data sort. Subtotal at each change in Fund. | ||||
| SB_BBA_HOUSING_OPER_BY_FUND | Program summary by Fund and Account for Housing Program |
Fiscal Year, Period range
|
Summary BBA calculation by Fund and Account for Housing Funds. NOTE: Minimal MS Excel data sort. Subtotal at each change in Fund. | |||||
| SB_BBA_PARKING_BY_FUND | Program summary by Fund and Account for Parking Program |
Fiscal Year, Period range
|
Summary BBA calculation by Fund and Account for Parking Funds. NOTE: Minimal MS Excel data sort. Subtotal at each change in Fund. | |||||
| SB_BBA_PARKING_FINES_BY_FUND | Program summary by Fund and Account for Parking Fines Program |
Fiscal Year, Period range
|
Summary BBA calculation by Fund and Account for Fines Funds. NOTE: Minimal MS Excel data sort. Subtotal at each change in Fund. | |||||
| SB_BBA_PARKING_OPER_BY_FUND | Program summary by Fund and Account for Parking Ops only Program |
Fiscal Year, Period range
|
Summary BBA calculation by Fund and Account for Parking Ops Funds. NOTE: Minimal MS Excel data sort. Subtotal at each change in Fund. | |||||
| PO Information | SB_PO_ACTIVITY_FOR_A_COA | Detail of Accounting lines that make up current, open encumbrances for a given chartfield string. No history. |
Enter specific chartfields and Account.
|
Total of Accounting lines that result in the Encumbrance balance on the 020 report. NOTE:Moderate MS Excel data sort and manipulation. | ||||
| SB_PO_ACT_HIST_FOR_A_COA | 2 | Detail of Accounting lines by period for all POs in current or given FY. |
Enter specific chartfields and account.
|
Run to Excel: Sort data by PO,Accounting Date. Then subtotal on each change in PO. If subtotal is zero, PO has been Paid (or canceled?). Any PO balances should add up to the Encumbered amount seen on Inquiry panels and the SB_020 query. Does not include Pre-Encumbrances (Requisitions) or AP payment entries. | ||||
| SB_REQ_ACCT_LINE | Specific Requisiton lines from POS system |
Enter Chartfield string
|
Run to Excel. Sort by Account, delete unwanted Account lines. Sort by Requisition and Period. Subtotal at each change in Requisition. Zero bal=cleared Req. | |||||
| SB_PO_ACCT_LINE | Specific PO lines from POS system |
Enter Chartfield string.
|
Run to Excel. Sort by Account, delete unwanted Account lines. Sort by PO. Subtotal at each change in PO. Zero bal=cleared PO. | |||||
Top of Page
Budget
Office
Financial
Operations