Get documents about "CFS Campuses Mods XRef to CMS Mods
Shared by: HC120708063332
-
Stats
- views:
- 9
- posted:
- 7/8/2012
- language:
- English
- pages:
- 94
Document Sample
Campus # of Mods
San Francisco 125
Long Beach 115
San Bernardino 107
San Jose 82
San Luis Obispo 68
East Bay 65
Los Angeles 59
Fullerton 58
Northridge 55
Fresno 50
Humboldt 42
Sacramento 37
Chancellor's Office 31
Monterey Bay 31
San Marcos 30
Dominguez Hills 20
Pomona 17
Maritime 16
Bakersfield 15
Chico 14
Sonoma 13
Channel Islands 8
Stansilaus 7
Total 1065
Security Eliminate 3rd Party PS Data integrity Reporting Session IB Elim Not used Blanks Mods
GL 1 53 14 14 141 20 13 442
PO 1 5 7 1 61 0 3 166
AP
AM
AR
BI
Budget
Other
Security
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
1 Bakersfield AP AP Check Register AP Check Register Payment Listing AP09002 - AP Check Register
1 Bakersfield AP Student Financials input Student Financials input Process Student Financial info into AP for processing IB
1 Bakersfield GL Budget Comparison by Dept and Fund Budget Comparison by Dept and Fund Budget/Expense Report Reporting Session
1 Bakersfield GL Budget Comparison by Fund and Dept Budget Comparison by Fund and Dept Budget/Expense Report Reporting Session
Bakersfield Budget Comparison by Prog/Fund/Dept Budget Comparison by Prog/Fund/Dept Budget/Expense Report
1 GL Reporting Session
Bakersfield Budget Comparison by Project and Dept Budget Comparison by Project and Budget/Expense Report
1 GL Dept Reporting Session
1 Bakersfield GL Cashiering Cashiering CSUFS140 Third Party Interface Document
Bakersfield Detail Transaction Load Detail Transaction Load Populates custom table with subsystem and GL CMS modified the baseline version to increase the
1 GL transaction detail Third Party Interface Document array size.
1 Bakersfield GL GL GL Tuition, Fees, Pymnts, Fines… FS99001 - General Ledger Interface
1 Bakersfield GL Text file journal import Text file journal import Excel template used to create all journal entries Use PS Delivered Functionality
1 Bakersfield PO Missing PO Receipts Missing PO Receipts PO items not received Reporting Session
1 Bakersfield PO Open PO Report Open PO Report List of all open Purchase Orders Reporting Session
1 Bakersfield PO Outstanding Encumbrances Outstanding Encumbrances PO's with Outstanding Encumbrances Reporting Session
1 Bakersfield PO Outstanding Pre-Encumbrances Outstanding Pre-Encumbrances PO's with Outstanding Pre-Encumbrances Eliminated
1 Bakersfield PO PO Status PO Status Status of all PO's Reporting Session
we do not have ASSET MGMT
implemented - this helps our
ASSET person keep track of
1 Chancellor's Office AM SQR COOFA001 FA0001 CO Fixed Asset Report invoiced/encumbered assets AM09004 - Invoices Paid Report
Auto transmission of EFT file, and email notification to
1 Chancellor's Office AP ACH Payment Processing payees for reimbursement AP08001 - ACH Payment Processing
Creates a list of Payees with PU Payment Handling.
1 Chancellor's Office AP Crystal COOAP007 AP Check Pickup List Used for Signature AP09006 - Check Pickup List
List vouchers/checks created by vendor - the report is
AP Vendor Activity (Voucher YTD good - but would be MUCH MORE EFFECTIVE is
1 Chancellor's Office AP SQR COOAP009 Report) you could run it by dept id as well Reporting Session
1 Chancellor's Office AP Crystal COOAP0002 AP0002 - AP Check Format CO AP Check Format AP06001 - AP Check Format
we use this to load & pay our intl
program students - there are
hundreds of vouchers @ a
AP0003 - AP Voucher Upload from Allows AP (primarily COSTU) to load a large amount time…saved MANY MANY man AP99004 - AP Vendor/Voucher
1 Chancellor's Office AP SQR COOAP0003 Excel of vouchers from excel to PS to create vouchers hours of data entry Interface
This report will be used as a tool to identify all
1 Chancellor's Office AP SQR COOAP011 AP0011 - AP Voucher Status Listing vouchers that have not been posted. helpful in daily, monthly recons AP09003 - Voucher Status Listing
when check are picked up this
report is used to have checks
1 Chancellor's Office AP Crystal AP0014 - AP Check Register Report Check Register - list all Checks created in check run signed out AP09002 - AP Check Register
1 Chancellor's Office AP AP0017 - AP Voided Check Report List of Voided AP checks in one report Eliminated
this links to our LF system &
AP0021 - Imaging File - AP Laserfiche SQR process pulls AP voucher /check info into updates it w/voucher, payment,
1 Chancellor's Office AP SQR integration Laserfiche DB vendor info.. Third Party Interface Document
AP0024 - COINS Check Format and
1 Chancellor's Office AP Crystal COAP0024 Copy COINS Check Format and Copy our auxilliary check format AP06001 - AP Check Format
29adc070-b05f-449f-878a-517ba5a30fc2.xls 3 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
1 Chancellor's Office AP Crystal COOAP0024 AP0024 - FDN Check Format and Copy FDN Check Format and Copy our auxilliary check format AP06001 - AP Check Format
this sends an e-mail to all
Process ACH payments. Confomr to Wells Fargo employees telling them that they've
1 Chancellor's Office AP SQR COOAP0029 AP0029ACH E-mail std/sends e-mail notification received and ACH payment AP08001 - ACH Payment Processing
SAM99007A - Accounts Payable Open
1 Chancellor's Office AP SQR COAP0030 AP0030 SAM18A AP Open Liability Report Liabilities
Open Item Prompt in Voucher entry to equal the
1 Chancellor's Office AP View COO_VNDR_ITM_VE Vendor ID. AP09001 - Open Item Key Setup
this allows the Pro card info from
1 Chancellor's Office AP SQR COOPO21A P-Card Bank File Downloading bank file for AP payment AMEX to be loaded into PS PO09001 - Procard
SQR report that list reimbursed
1 Chancellor's Office GL SQR COOBD002 BD0003 Reimbursed Acitivities acitivity funds & activity Reporting Session
GL Ledger Dtl Act by SCO/CSU/PS List GL activity by SCO/CSU/PS fund/account/FY &
1 Chancellor's Office GL SQR COOGL023 Fund PD Reporting Session
Create a standard Journal Upload Process. The SQR this allows large journal entries to
reads a standard CSV file and includes be entered from an excel sheet,
comprehensive edit validation during the upload cutting down on entry time and
1 Chancellor's Office GL SQR COOGL001 GL0001 - Journal Upload Process process. errors. GL05001 - Journal Upload Process
this is used so that a the journal
entry can be created from an excel The AP Travel/Salary Adv. are being recorded with
GL0002 - Charge Back Entry Upload Loads CB into PS from formatted excel file spreadsheet. There are a number OI. Then an extract is run to get all the OI info and
5 digit Code Translate sets up 5 digit CB codes for depts of building charges that are spread send to CashNet so the cashier can apply the refund
1 Chancellor's Office GL SQR COOGL002 Charge Back Attribute set up default chartfield string for different CB out through the building GL09003 - Charge Back to the persons debt.
Loads tables w/TB data - table is too big w/o this
1 Chancellor's Office GL SQR COOGL009 GL0009 - Load Trial Balance Table process Reporting Session
Use this to verify that people who
have signed on an invoice/payment
are authorized to do so, this can be
updated on a daily basis depending
on how offten people are hire,
Add/Update delegates of exp. Auth. For requisitioning move departmens, or leave the CO
1 Chancellor's Office GL SQR COOGL0021 GL0021 - Delegation of Authority & invoicing office GL09001 - Delegation of Authority
Loads excel (& other files) to correct drive for loading this is used to load chargebacks &
1 Chancellor's Office GL SQR COOGL022 GL0022 - Load Flatfile into PS system journals GL09002 - FTP
the AR accountant usese this to
1 Chancellor's Office GL SQR COOGL010 GLS3000 - GL Open Item Listing Listing of all GL Open Items reconcile and verify any open items Reporting Session
Loads tables w/TB data - table is too big w/o this
1 Chancellor's Office GL SQR COO_GL0009_TBL Load Trial Balance Table process Reporting Session
1 Chancellor's Office GL nVision Financials and operation reports nVision Reporting
1 Chancellor's Office GL SQR coonvs002 NVS002 Dynamic nvision nVision Reporting
29adc070-b05f-449f-878a-517ba5a30fc2.xls 4 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
This report is needed monthly to
SAM99001 - SAM99 Reconciliation Mandatory reconciliation and reporting required by reconcile the SAM99 between SCO
1 Chancellor's Office GL SQR csugl010 Process the SCO. Accommodate SCO requirements and CO SAM99001 - SAM99 Reconciliation
1 Chancellor's Office Other Security IBBROKER Integration Broker Messaging All PeopleSoft delivered IB messaging IB
List all PO's w/remaining balances (open Po's) based
1 Chancellor's Office PO COOPO005 Open PO Report by Dept/Fund on criteria Reporting Session
PO0001 - PO Activity by Category
1 Chancellor's Office PO SQR coopo001 (NIGP) List po's based on category code Reporting Session
1 Chancellor's Office PO SQR coopo004 PO0004 - Vendor PO Activity report List of PO's by vendor/date Reporting Session
PO99011 - Purchase Order Print
1 Chancellor's Office PO SQR coopo0016 PO0016 - CO - Purchase Order Form Modifiy PO Format. Format
Set up default CF string based on P Card acct # &
card holder
Loads Procard data into PS
Interface for users to enter details descr info & modify
CF's if needed Will this go back to file based transfer, based on
1 Chancellor's Office PO coopo0021 PO0021 - Procard Modification Loads procard data into AP/vouchers PO09001 - Procard third-arty interface doc?
PO99011 - Purchase Order Print
1 Chancellor's Office PO SQR fdncopo0021 PO0023 - FDN - Purchase Order Form Modify PO Format. Format
GL Custom Views and Queries
COO_KK_AC_DRILL - KK Activity View
COO_KK_AP_AC_V1 - KK PO Activity View1
COO_KK_AP_AC_V2 - KK PO Activity View2
COO_KK_AP_AC_V3 - KK PO Activity View3
COO_KK_AP_AC_VW - KK AP Activity View
COO_KK_PO_AC_V1 - KK PO Activity View1
COO_KK_PO_AC_V2 - KK PO Activity View2
COO_KK_PO_AC_V3 - KK PO Activity View3
COO_KK_PO_AC_VW - KK PO Activity View
COO_KK_RQ_AC_V1 - KK REQ Activity View1
COO_KK_RQ_AC_V2 - KK REQ Activity View2
COO_KK_RQ_AC_VW - KK REQ Activity View
1 Chancellor's Offie GL SQR GL Custom Views/Queries Reporting Session
Process Student Financial info into AP for processing:
Voucher
Vendor
1 Channel Islands AP AP Accounting Lines IB
1 Channel Islands AP CI_FS_AP_001 CI Custom Check Print AP06001 - AP Check Format
1 Channel Islands GL CI_FS_NV_001 CI nVision Scope Maintenance nVision Reporting
1 Channel Islands GL CI_FS_NV_002 SQL View for nVision Layout nVision Reporting
29adc070-b05f-449f-878a-517ba5a30fc2.xls 5 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Chartfield data transfer to HCM for validations:
Account
Fund
Dept
Class
Program
1 Channel Islands GL GL/HCM Project IB
PO99011 - Purchase Order Print
1 Channel Islands PO CI_FS_PO_001 CI Custom PO Print Format
1 Channel Islands PO CI_FS_PO_002 GE Pro Card COA Extract - CIPO0003.SQR PO09001 - Procard CFS to review -- incorrect solution
1 Channel Islands PO CI_FS_PO_002 GE Pro Card Mapper Interface - CIPO0004.SQR PO09001 - Procard
Please see Chico Physical
1 Chico AM SQR ? CHIAMPI Load Physical Inventory into AM Inventory.doc Third Party Interface Document
Run for the property review board.
Tto check if property has been
1 Chico AM Page ? Print Asset Print Asset stolen. AM09003 - Property Survey Report
Please see Chico AM Mass
1 Chico AM SQR ? Retire Assets Retire Assets Change BGG.doc Third Party Interface Document
1 Chico AP SQR CHIAP19B Load student vouchers/vendors for refunding Import student vendor/voucher file FS99004 - Vendor/Voucher Interface
Create EFT file in required WFB
1 Chico AP SQR ? CHIEFT01 EFT process to Wells Fargo format AP08001 - ACH Payment Processing
1 Chico AP SQC CSUAP027 point to chieft01 instead of fineft01 CO mod points to fineft01 AP08001 - ACH Payment Processing
Prints a custom formatted CSU,
1 Chico AP Crystal ? CSUCH1 Check Print Chico check AP06001 - AP Check Format
1 Chico AR SQR AR Item Extract Extract AR Items to be loaded into Cashnet Third Party Interface Document
1 Chico BI CHI_BI_Print Print Chico BI Invoices BI09001 - Billing Invoice
Loads billing interfaceface file for
1 Chico BI SQR ? CHIBI001 Load chargeback interfaces into BI for chargebacks chargebacks GL09003 - Charge Back
Load chargeback interfaces into BI
1 Chico BI SQR ? CHIBI003 Load chargeback interfaces into BI for postage for postage GL09003 - Charge Back
Creates file MAIL_TRANS.TXT to
Creates file MAIL_TRANS.TXT to feed feed CSU_ACCTG_LINES into This is a DB link from HCM to Finance identifying
1 Chico BI SQR ? CHIFS003 CSU_ACCTG_LINES into PeopleSoft PeopleSoft GL09003 - Charge Back FIS secuirty Access Roles.
Creates file CAF_TRANS.TXT to load into Creates file CAF_TRANS.TXT to
1 Chico BI SQR ? CHIFS004 PeopleSoft. load into PeopleSoft. GL09003 - Charge Back
Creates file TELE_TRANS.TXT to load into Creates file TELE_TRANS.TXT to
1 Chico BI SQR ? CHIFS005 PeopleSoft load into PeopleSoft GL09003 - Charge Back
Also using this for their custom Signature of
Authority mod. The new mod GL09001 will replace
1 Chico BI SQR Load Billing Interface Load chargeback interfaces into BI GL09003 - Charge Back this mod.
1 Chico GL SQR Cashnet CF Download Extract Chartfields to be loaded into Cashnet Third Party Interface Document
1 Chico GL SQR ? CashNet Load Load CashNet file from CSUFS140 Load CashNet file from CSUFS140 FS99001 - General Ledger Interface
Create ChargeBack files to be loaded via CSUFS140, Load GL Interface file,
file used is MAIL_TRANS.TXT created from MAIL_TRANS.TXT created from
1 Chico GL SQR ? Charge Back Interface CHIFS003.SQR CHIFS003.SQR GL09003 - Charge Back
29adc070-b05f-449f-878a-517ba5a30fc2.xls 6 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Create ChargeBack files to be loaded via CSUFS140, Load GL Interface file,
file used is TELE_TRANS.TXT created from TELE_TRANS.TXT created from
1 Chico GL SQR ? Charge Back Interface CHIFS005 CHIFS005.SQR GL09003 - Charge Back
Create ChargeBack files to be loaded via CSUFS140, Load GL Interface file,
file used is CAF_TRANS.TXT created from CAF_TRANS.TXT created from
1 Chico GL SQR ? Charge Back Interface CHIFS004.sqr CHIFS004.sqr GL09003 - Charge Back
1 Chico GL SQR CHI_RUN_EOM_ROLL Roll accounting period on PO's Use PS Delivered Functionality
Prints a custom formatted CSU,
1 Chico GL Crystal ? GLC7501 Chico Journal Print Chico journal GL99001 - Journal Entry Detail Report
ease user login - reduce # pw user
1 Chico Other LDAP must remember Security Related
Prints a custom formatted CSU, PO99011 - Purchase Order Print
1 Chico PO SQR ? POPO005 Chico version on POPO005 Chico purchase order Format
1 Chico PO PROCARD Procurement Card Processing/setup PO09001 - Procard
1 Chico PO PROCARD ProCard Account CF Setup PO09001 - Procard
1 Chico PO PROCARD ProCard Account Setup PO09001 - Procard
1 Chico PO SQR PROCARD Load ProCard Extract File PO09001 - Procard
1 Chico PO SQR PROCARD ProCard AP Interface PO09001 - Procard
1 Chico PO PROCARD ProCard Adjustment PO09001 - Procard
1 Chico PO PROCARD ProCard Completed Inquiry PO09001 - Procard
List all surplus items to be reviewed by the Property PeopleSoft does not deliver a
1 Dominguez Hills AM Crystal Asset Management Survey Report Survey Board Property Survey Report AM09003 - Property Survey Report
Automates the ProCard Bank File
feed into PS Accounts Payable -
ProCard - Load monthly bank statements into AP for Previously this was manually
1 Dominguez Hills AP SQR AP processing uploaded by flat file into PeopleSoft PO09001 - Procard
1 Dominguez Hills AP AP Process Student Financials into AP FS99004 - Vendor/Voucher Interface
Ad delivered, IB uses PS standard
name formatting: Last Name, First
Name, Middle Initial. It's a campus
Updates Vendor Name Format coming from Student requirement to have the format
1 Dominguez Hills AP AE AP Admin to First Name Middle Name Last Name changed to First Middle Last Name FS99004 - Vendor/Voucher Interface
1 Dominguez Hills AR Crystal Dunning Letters Modififed the Dunning Letter Format and Logo Formatting and Logo were required AR09004 - Dunning Letter
PeopleSoft delivers a cumbersome
spreadsheet that doesn't provide
some of the necessary edits when
uploading a file and doesn't easily
indentify when there is an error in
1 Dominguez Hills BD SQR Budget Upload Uploads transactions into the Ledger Budg the file (i.e. incorrect CF value) GL05001 - Journal Upload Process
1 Dominguez Hills BI SQR Billing Invoice Modififed the Billing Invoice Format and Logo BI09001 - Billing Invoice
29adc070-b05f-449f-878a-517ba5a30fc2.xls 7 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
This updates the budget date on
reqs, po, and vouchers that are not
budget checked and have a closed
budget date to a current period.
Ensures that all accounting
transactions update the open
Rolls the tranactions accounting date to the next period and not a closed period in
1 Dominguez Hills GL SQR Accounting Date Roll period Ledger_KK Use PS Delivered Functionality
CSU campuses were not using
Controlled Budgets, so there was
no single page in PS that combines
Budget, Expense, Encumbrance
Provides real time Budget Balances by a single and Pre-Encumbraace to reflect
1 Dominguez Hills GL Page BBA Search chartfield string spending authority Reporting Session
Builds the reporting table that the Consolidated Detail
1 Dominguez Hills GL SQR Build Reporting Table Report uses to generate the detail data End user reporting Reporting Session
Report provides detail information by selected
1 Dominguez Hills GL SQR Consolidate Detail Report chartfields End user reporting Reporting Session
1 Dominguez Hills GL HR to GL Process transactions to the GL from HR IB
PeopleSoft delivers a cumbersome
spreadsheet that doesn't provide
some of the necessary edits when
uploading a file and doesn't easily
indentify when there is an error in
1 Dominguez Hills GL SQR Journal Upload Uploads transactions into the GL the file (i.e. incorrect CF value) GL05001 - Journal Upload Process
1 Dominguez Hills GL SQR SAM09A Fund Balance Report Reporting Session
1 Dominguez Hills GL SF to GL Process transactions to the GL from Student IB
Process transactions from ToucheNet (i.e.
1 Dominguez Hills GL TouchNet to GL Marketplace and Cashiering) to the GL FS99001 - General Ledger Interface
Allows end users more control to
run their processes (i.e. Journal
1 Dominguez Hills Other Page Load Flat File Uploads flat files to the Unix Server and Budget Upload and ProCard) GL09002 - FTP
Allows for better encumbrance
A departmental report that lists the PO's with open tracking and budget management
1 Dominguez Hills PO SQR Open Encumbrance Report encumbrance balances by departments. Reporting Session
The Verify Account validates the
bank file against the ProCard setup
and identifies any variances - this
Checks for variances between the Procard setup elimiates delays in processing the
1 Dominguez Hills PO SQR Procard Bank File Validation tables and the bank file transactions. PO09001 - Procard
29adc070-b05f-449f-878a-517ba5a30fc2.xls 8 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Allows end users an online page to
update their ProCard transactions
distributions (CF) prior to be loaded
Provides a way for tranactions from the bank (GE in to PS - automates the ProCard
Capital) to be loaded into PeopleSoft for edting and Bank File feed into PS Accounts
1 Dominguez Hills PO SQR Procard Modification Processing Payable PO09001 - Procard
EB-modified version of CMS-delivered Wells Need bank reconciliation EB-modified version of CMS-delivered Wells
1 East Bay AP SQR Bank Reconciliation - Auxiliaries Fargo Bank Recon SQR. specific to Bank of the West. Third Party Interface Document Fargo Bank Recon SQR.
1 East Bay AP HAYAP009 AP - Open Items Report AP05004 - AP Open Items Listing
1 East Bay AP HAYAP014 AP - Match Exceptions AP05003 - Match Exception Report
1 East Bay AP HAYAP100 AP - Vendors Exceeding $1500 AP09005 - 1099 Misc Report
AP06002 - Wells Fargo Positive
1 East Bay AP Positive Pay Payments issued from PS - submitted to Wells Fargo Payment File
EB-modified version of CMS-delivered Positive Need Positive Pay extract EB-modified version of CMS-delivered Positive
1 East Bay AP App Engine Positive Pay - Auxiliaries Pay App Engine. specific to Bank of the West. Third Party Interface Document Pay App Engine.
Student vendor / voucher data for student refunds AP99004 - AP Vendor/Voucher
1 East Bay AP SF to AP and financial aid Interface
1 East Bay AP auxck1.rpt Auxiliary Check AP06001 - AP Check Format
1 East Bay AP CHECK5.rpt renamed to CSUC1.rpt - checks AP06001 - AP Check Format
1 East Bay AP COPY5.rpt renamed to CSUC2.rpt - checks Eliminated
It updates the Payment Message in the
1 East Bay AP HAY_PY_MSG Set FinAid Payment Message - Application Engine Third Party Interface Document PS_PYMNT_VCHR_XREF - on the check stub.
AP09001 - Open Item Key Setup and
1 East Bay AP HAYFS029 Update Personal Data Security Related
Empl ID and name from HR personal data table to AP09001 - Open Item Key Setup and
1 East Bay AP HR personal data to FIS Finance Personal data table Security Related
Design Team eliminated the AR Statement from the
Campus Business Process. The Dunning Letters
1 East Bay AR HAYARSTM.rpt Accounts Receivable Statement Eliminated are sufficient.
1 East Bay BI HAYBILD Billing BI09002 - Billing Upload
1 East Bay BI HAYBIRMB Reimbursed Activity Process BI09003 - Automatic Invoicing
1 East Bay BI HAYINV0T.rpt csueb major crystal invoice BI09001 - Billing Invoice
Monthly transactions paid by university on behalf of
1 East Bay BI Reimbursed activity mod auxiliaries - data used to bill auxilairies BI09003 - Automatic Invoicing
1 East Bay BI setup page RA General Options BI09003 - Automatic Invoicing
1 East Bay BI setup page RA Surcharge Setup BI09003 - Automatic Invoicing
1 East Bay BI setup page RA Note Setup BI09003 - Automatic Invoicing
1 East Bay BI setup page RA Customer Setup BI09003 - Automatic Invoicing
1 East Bay BI setup page RA CF to Customer Map BI09003 - Automatic Invoicing
Excel CSV file with billing information uploaded to
1 East Bay BI Upload spreasheet to BI PS/BI BI09002 - Billing Upload
1 East Bay GL Cashnet to FIS Non student payments FS99001 - General Ledger Interface
1 East Bay GL FIRMS extract Monthly FIRMS extract file submitted to CO Eliminated - Not Used
1 East Bay GL FIS to Cashnet Chartfield extract - flatfile sent to Cashnet Third Party Interface Document
Configuration data passed to HRSA from Finance -
1 East Bay GL GL to HRSA ChartField information, Templates, Business Unit Third Party Interface Document
29adc070-b05f-449f-878a-517ba5a30fc2.xls 9 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
1 East Bay GL HAYFS002 Chart of Accounts Extract Third Party Interface Document
1 East Bay GL HAYFS004 Balance Sheet Reporting Session
1 East Bay GL HAYFS005 Profit Loss Statement Reporting Session
1 East Bay GL HAYFS006 Balance Sheet - All UU Funds Reporting Session
1 East Bay GL HAYFS009 Balance Sheet - All ASI Funds Reporting Session
1 East Bay GL HAYGL033 Due From Due To Other Funds Reporting Session
1 East Bay GL HAYGL100 Trust/Reimburse Prog Report Reporting Session
1 East Bay GL HAYGL108 Fdet Extract - Ledger Third Party Interface Document
1 East Bay GL HAYGL109 Fdet Extract - Journals Third Party Interface Document
1 East Bay GL HAYGL110 Fdet Extract - Vouchers Third Party Interface Document
1 East Bay GL HAYGL111 Fdet Extract - POs Third Party Interface Document
1 East Bay GL HAYGL115 Fdet Extract - Invoices Third Party Interface Document
1 East Bay GL HAYGL200 EOM Acctg Date Roll Use PS Delivered Functionality
1 East Bay GL HAYGL999 Ledger Comparison/Correction Reporting Session
1 East Bay GL HAYWBJ01 Load Budget Journal (Web Journals interface) FS99001 - General Ledger Interface
1 East Bay GL HAYWEJ01 Load Expense Journal (Web Journals interface) FS99001 - General Ledger Interface
1 East Bay GL Journal spreadsheet to GL Excel CSV file with journal data uploadecd to PS/GL GL05001 - Journal Upload Process
1 East Bay GL LCD HR to FIS LCD data from HRSA to PS/GL IB
Procurement Card feed from credit card company
into PS GL (East bay conversion program; this will Is App Engine not supported in third aprty interface
1 East Bay GL Payment Net 1 generate output to feed CSU delivered program) PO09001 - Procard methodology
Procurement Card feed from credit card company
into PS GL (CSU deleiverd program to read input
1 East Bay GL Payment Net 2 from EastBayconversion program output) PO09001 - Procard
1 East Bay GL SAM 99 Year End SAM99 file extracted and submitted to CO SAM99001 - SAM99 Reconciliation
1 East Bay GL SAM 99 Monthly SAM99 file from SCO to GL SAM05001 - SAM99 Tape Data
1 East Bay GL SF to GL Payments posted to student accounts - from SF to GL FS99001 - General Ledger Interface
Report developed to track income and expense
1 East Bay GL SQR Sponsored programs report accounts for sponsored programs Reporting Session Auxiliaries
EB-modified version of PS-delivered G/L
1 East Bay GL SQR Trial Balance Summary Balance. Reporting Session Auxiliaries
1 East Bay GL Web Budget Transfers Budget journals imported to PS from Web application FS99001 - General Ledger Interface
Expense journals imported to PS from Web
1 East Bay GL Web Expense Transfers application FS99001 - General Ledger Interface
1 East Bay GL Wells Fargo to GL bank reconciliation file of cleared checks GL06002 - Wells Fargo Bank Recon
1 East Bay Other HAYFS028 IM Extract - Operator ID Data Security Related
PS Operator IDs extracted and sent to campus IMS
1 East Bay Other OPRID extract to IMS database for LDAP Security Related
1 East Bay PO HAYPO100 PO Improvement Report Eliminated - Not Used
1 East Bay PO HAYPO112 PO Expedite Report by Dept Eliminated - Not Used
1 East Bay PO HAYPO113 PO Expedite Report by Buyer Eliminated - Not Used
1 East Bay PO HAYPO310 PaymentNet File Conversion Third Party Interface Document
29adc070-b05f-449f-878a-517ba5a30fc2.xls 10 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
1 East Bay PO HAYPO999 Find Non-BCM'd PO's PO07002 - PO Queries
PO99011 - Purchase Order Print
1 East Bay PO POPO005.SQR Purchase Order Format
The CMS approach to asset management was to use
the delivered system to create GL journals, but to not
post these journals (CMS recommends deleting
them). Instead CMS does a derivation of the AM
accounting data to create transactions for posting to
the GAP ledger. Journal generator creates many
journals during the process and so a program was
developed to delete AM journals programmatically AM09006 - AM DIST Line AP and FY
1 Fresno AM AM Journal Delete (those having source code AMS. Update
To facilitate the reconciliation of PO/Voucher data that
enters the asset management data base, creating
new assets, a program was written that lists the
asset, pertinent asset information and dollar amounts
from PO and from voucher. The vouchered amount
1 Fresno AM AM Reconciliation should reconcile to the asset cost amount. AM09004 - Invoices Paid Report
This report was written to show the purchase orders
that are asset related, look up the vouchered amount
for those POs, find the assets that were created from
those PO's and determine if the full amount of the
voucher is equal to sum of the asset costs. For audit
purposes, this must be true. The report can be run
showing all POs that are asset related or it can be run
to show the ones with differences only. To accomplish
the summing of the vouchered amounts, I needed a
table of vchr_acctg_line records that specifically had a
PO and asset profile in their record. Because this
look up is for each PO, and the table is so large, and
there is no alternate index for PO, I first select only
the records that are PO/asset related, and write them
to a temp table (FR_VCHR_AM_TMP). The process
then finds the PO/Asset related POs, computing their
merchandise cost, then sums the related voucher
cost, then sums the asset related costs and if their is
a difference between vouchered amount and asset
1 Fresno AM Asset Voucher Reconciliation amount, calculates the difference. Reporting Session
1 Fresno AP 1099 Extract Extract for IRS 1099 reporting Reporting Session
1 Fresno AP 1099-MISC Balances Report of 1099 balances used for reconciliation AP09005 - 1099 Misc Report
Report of AP vouchers with related PO information
1 Fresno AP AP Cntrl Grp - PO Info within an AP control group Eliminated - Not Used
29adc070-b05f-449f-878a-517ba5a30fc2.xls 11 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
This process was requested by Accounting Services
to handle checks for Athletics business unit in format
1 Fresno AP Athletics Positive Pay needed by Citibank. Third Party Interface Document
1 Fresno AP Check Reconciliation - Citibank Import of check journal Third Party Interface Document
1 Fresno AP Check Reconciliation - Wells Import of check journal GL06002 - Wells Fargo Bank Recon
To implement for AP travel and employee expense,
we acquired the Chancellors Office mod which was
done for them by CMS. We retained the CO prefix on
the custom pieces in anticipation of having to do
another install of the code when CMS releases it post
9.0 (patch 025). Delivered peoplesoft program
fin2025.SQR which is a component of pay cycle was
modified to call cooap027.sqc. cooap027.sqc calls
cooap028.sqc which is a modified fineft023.sqc.
cooap028.sqc was modified to output the ACH file in
Wells Fargo format, and to transmit the ACH file
directly from the server. Cooap029.SQR was also
provided to be able to recreate and re-transmit a
specified ACH file. The project also includes an app
eng program cooach_email run to send an e-mail to
1 Fresno AP CO ACH Transmit and E-mail ACH disbursement recipients. AP08001 - ACH Payment Processing SLO will move this mod to HR.
1 Fresno AP Control Group Register Report of vouchers in a control group AP99006 - Control Group Report
Report of duplicate bank account numbers for EFT Reporting Session (Auditor says not a
1 Fresno AP Duplicate Bank Account Number validation. requirement)
Process Employee Vendors into AP for processing
1 Fresno AP Employee Vendor Update (includes ACH Account Data mod) AP09004 - Vendor Synch
The departments requested a way to easily access
the combined information having to do with expense
vouchers and expense journals. To make this
information available in a query I added a table to
store the recently added voucher expense data
(FR_JRNL_VCHR_WK); then I added a table to store
all the expense journals with combined voucher
expense data if applicable (FR_EXPENSE_WRK).
FR_EXPENSE_WRK is then the table queried to
provide all journal expense transactions with Reporting Session (Auditor says not a
1 Fresno AP Jrnl-Vchr Build-update associated voucher information where applicable. requirement)
AP09009 - AP Voucher Interface or
1 Fresno AP Office Max to AP Upload monthly detailed statements into AP Third Party Interface Document
1 Fresno AP Positive Pay - Citibank Extract of Postive Pay file Third Party Interface Document
AP06002 - Wells Fargo Positive
1 Fresno AP Positive Pay - Wells Extract of Postive Pay file Payment File
1 Fresno AP Procard to AP Upload monthly detailed statements into AP PO09001 - Procard
29adc070-b05f-449f-878a-517ba5a30fc2.xls 12 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Create - Update ACH Routing Number Table from
1 Fresno AP Routing Table Maintenance FedWire website Third Party Interface Document
Added security to Vendor and Voucher records to
1 Fresno AP Security added for EFT/ACH hide banking information. AP08001 - ACH Payment Processing SLO will move this mod to HR.
1 Fresno AP SF Student Refunds Student Refund Vouchers to AP for Payment IB
Process Student Vendors into AP for processing
1 Fresno AP SF Vendor Update (includes ACH Account Data mod) IB
Printing VOUCHERS SELECTED FOR PAYMENT
1 Fresno AP Vouchers Selected for Payment Detail information based on Pay Cycle AP08002 - AP Trial Register
1 Fresno GL Cashnet Chart of Accounts Export of Chartfileds to Cashnet Third Party Interface Document
1 Fresno GL CashNet GL-COA Extract chartfields to load into Cashnet Third Party Interface Document
This interface uses a SQR to take the daily receipts
from the cashnet.com system and convert the
transactions to the accounting system. The process
writes application fee status rows to either the
Admissions Application Fee Table or International
Application Fee Table depending upon Application
Center. Fee status rows for international applications
with admissions application term greater than or equal
to fall 2007 (2077) will be written to the International
1 Fresno GL CashNet Interface Application Fee Table. FS99001 - General Ledger Interface
1 Fresno GL Cashnet Journal Load Import of journals from Cashnet FS99001 - General Ledger Interface
GL02002A - CDIP FIRMS Program
1 Fresno GL CDIP/FIRM Extracts Extracts for CO reporting Code Derivation
1 Fresno GL Chartfield Update Update of chartfield changes to HCM IB
1 Fresno GL Facilities Management CREATES A TABLE OF project activity for project rpt nVision Reporting
Reads budget, ledger, AP, PO and encumbrance data
based on entered list of funds. It summarizes the
selected data into a temporary reporting table
(fr_project_rpt) then prints the information to form a
report that facilities uses to reconcile a project (set of
1 Fresno GL Facilities Project Report funds). Reporting Session
1 Fresno GL HR Payroll Encumbrance Load of Payroll projects into reporting ledger Third Party Interface Document
1 Fresno GL Mailroom Chargebacks Import of journals from Mailroom GL09003 - Charge Back
29adc070-b05f-449f-878a-517ba5a30fc2.xls 13 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
The process was revised to include information which
will be added to the journal entry. This information
will be used to aid the Student Financial Accounting
Office in reconciling admissions application fee
transactions with admissions applications. The
process writes application fee status rows to either
the Admissions Application Fee Table or International
Application Fee Table depending upon Application
Center. Fee status rows for international applications
with admissions application term greater than or equal
to fall 2007 (2077) will be written to the International
1 Fresno GL Mentor Interface Application Fee Table. Third Party Interface Document See Chico's Physical Inventory Process document.
Update of Application Fees based on journals loaded
1 Fresno GL Mentor Update from Cashnet Third Party Interface Document
Reformat file from Mailroom to load chargeback
1 Fresno GL MRCB Interface journals Third Party Interface Document
Extract of permit data based on journals loaded from
1 Fresno GL Parking PermitUpdate Cashnet Third Party Interface Document
1 Fresno GL Payroll Journals Load of payroll accounitng lines IB
This process generates two files (account and
department) which are then sent to the Pinnacle
1 Fresno GL Pinnacle Acct/Dept File Create System. Third Party Interface Document
This job was created to send a transaction file to the
1 Fresno GL Pinnacle Interface Pinnacle Telephone System. Third Party Interface Document
1 Fresno GL Pinnacle Payments Extract of telephone bill payments from GL Third Party Interface Document
This job was created by CSUSB to replace the
SAM11 report. The program gets the YTD up to the
specified accounting period and sums it by SCO
FUND Code. It also gets the activity for the specified
accounting period and sums it by fund code and
1 Fresno GL Recon State Check Acct - Audit separates it by source Code Reporting Session
This job was created by CSUSB to replace the
SAM11 report. The program gets the YTD up to the
specified accounting period and sums it by SCO
FUND Code. It also gets the activity for the specified
accounting period and sums it by fund code and
1 Fresno GL Recon State Check Acct - Sumry separates it by source Code Reporting Session
Report of reimbursed activity from the General Ledger
used by AP to determine the paid AP expenses that
were to be reimbursed to the campus. It ran very
slow. A work table was introduced during 8.4 to
speed the process up by tabling all required data at
one time into a temp table rather than reading AR09001 - Reimbursed Activities Status
1 Fresno GL Reimb Activity YTD individual tables during processing. Report
29adc070-b05f-449f-878a-517ba5a30fc2.xls 14 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
This process was created by SLO after going live on
8.4. The reasoning was that with the new
encumbrance ledger (ledger_kk) it became necessary
to cleanly apply updates to ledger_kk for each
accounting period. This app engine is run at the
beginning of each period and sets the accounting date
on any open PO's or vouchers that might have activity
during that month to have an accounting date
1 Fresno GL Update Acctg Date equating to that current period. Use PS Delivered Functionality
VP of Administration has requested a periodic report
to display the budget, encumbrance, activity and
possible projections (finance and payroll) of finance
activity for a specified department. Being there were
so many tables involved, and some are actually in
HCM a program was created to bring all the reporting
data into one consolidated table FR_LEDGER.
Basically fr_ledger is in ledger format and all
individual ledgers within it are accessible using
nVision. Second part of the mod is an update page
where the user can input/update projections to the
1 Fresno GL VPA Ledger Update actuals ledger. nVision Reporting
In 8.4 it became necessary to have a report that
showed what was open for a PO. This report
accesses the individual tables (PO, receipt, and
voucher) to provide summarized information on the
original encumbrance and corresponding receipt and
1 Fresno PO Open PO Report voucher activity Reporting Session
This job was create a letter for vendor's with open
1 Fresno PO Outstanding Purchase Orders PO's over 90 days from the due date. Reporting Session
During 8.4 it became an issue to see just exactly what
had been processed against a PO, to include original
1 Fresno PO PO Detail Rpt PO, receipt and voucher detail activity PO09002 - Purchase Order Life Cycle
Report of Receiver Shipto Information for a particular
1 Fresno PO Receiver Shipto Detail Report Business Unit and the Receipt Dates Eliminated - Not Used
1 Fullerton AM SQR, Pages FUL_AM_CONVERSION FULAM001 AM Conversion and DIST_LN View AM conversion - Allocations Eliminated
1 Fullerton AP SQR, Pages FUL_AP_FULAP001 FULAP001 Student Vendor Voucher Interface Custom SVVI Third Party Interface Document
Outbound - send check # back thru
1 Fullerton AP SQR, Pages FUL_AP_FULAP001 FULAP001a BRS Check Number Feed interface Third Party Interface Document
1 Fullerton AP SQR, Pages FUL_AP_FULAP002 FULAP002 Housing/Parking Refund Vchr Upload Custom SVVI AP09009 - AP Voucher Interface
PO09001 - ProCard and
1 Fullerton AP SQR, Pages FUL_AP_FULAP003 FULAP003a Convert Vendor Invoice File and Interface Load Third Party Interface Document
PO09001 - ProCard and
1 Fullerton AP SQR, Pages FUL_AP_FULAP003 FULAP003b Create on-line invoice interface update Third Party Interface Document
PO09001 - ProCard and
1 Fullerton AP SQR, Pages FUL_AP_FULAP003 FULAP003c Create AP voucher build program Custom SVVI - spreadsheet upload Third Party Interface Document
1 Fullerton AP SQR, Pages FUL_AP_FULAP003 FULAP003d Interface into GL Recharge module GL09003 - Charge Back
29adc070-b05f-449f-878a-517ba5a30fc2.xls 15 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
PO09001 - ProCard and
1 Fullerton AP SQR, Pages FUL_AP_FULAP003 FULAP003e Create vendor cross walk process Third Party Interface Document
1 Fullerton AP Crystal FULCK5 FULAP004 Check Print Program Customize delivered check Program AP06001 - AP needs. Format
for Fullerton's Check
1 Fullerton AP FUL_GL_CASHNET_OUTBOUND FULAP005 1099 Conversion from FRS Eliminated - Not Used
1 Fullerton AR SQR, Pages FUL_GL_CASHNET_INBOUND FULAR001 Cash Net File Split Splits the inbound Cash Net file between GL transactions Document
Third Party Interface and AR transactions.
1 Fullerton AR SQR, Pages FUL_BI_REIMBURSED_ACTIVITY FULBI001 Reimbursed Activites Modification Similar to SLO Reimbursed ActivitiesBI09003 - Automatic Invoicing
Mod
1 Fullerton AR SQR, Pages FUL_BI_REIMBURSED_ACTIVITY FULBI002 Custom Billing Invoice program Similar to SLO Reimbursed ActivitiesBI09001 - Billing Invoice
Mod
Customer history report of all activity sorted by type
1 Fullerton AR SQR, Pages FULBI004 and status. Similar to SLO Reimbursed ActivitiesBI09003 - Automatic Invoicing
Mod
Files for Cashnet Customer,Customer Balances, and Similar to SLO Reimbursed
1 Fullerton AR SQR, Pages FULBI005 Chartfields Activities Mod BI09003 - Automatic Invoicing
1 Fullerton AR SQR, Pages FULBI006 Email of the Dunning Letter and modifications AR09004 - Dunning Letter
1 Fullerton BD SQR, Pages FUL_BD_BUDGET_XFER FULBD001 Budget Transfer - User Preference Setup Use PS Delivered Functionality
1 Fullerton BD SQR, Pages FUL_BD_BUDGET_XFER FULBD002 Budget Transfer - Data Entry Page Use PS Delivered Functionality
1 Fullerton BD SQR, Pages FUL_BD_BUDGET_XFER FULBD003 Budget Transfer - Division Approval Page Use PS Delivered Functionality
1 Fullerton BD SQR, Pages FUL_BD_BUDGET_XFER FULBD004 Budget Transfer - Inquiry Page Use PS Delivered Functionality
Fullerton custom budget transfer
Budget Transfer - Budget Approval & Journal page coupled with department
1 Fullerton BD SQR, Pages FUL_BD_BUDGET_XFER FULBD005 Sourcing security Use PS Delivered Functionality
Fullerton custom budget transfer
page coupled with department
1 Fullerton BD SQR, Pages FUL_BD_BUDGET_XFER FULBD006 Budget Transfer - Budget Transfer Print Program security Use PS Delivered Functionality
Fullerton custom budget transfer
page coupled with department
1 Fullerton BD SQR, Pages FUL_SEC_PREPARER_SECURITY FULBD007 Budget Transfer - Preparer Setup security Use PS Delivered Functionality
1 Fullerton BI SQR, Pages FUL_BI_FULBI002 FULBI002 Billing Invoice BI09001 - Billing Invoice
An invoice report of what has not been billed and is
1 Fullerton BI SQR, Pages FUL_BI_FULBI003 FULBI003 waiting in billing. Reporting Session
Distributed User Report: Expenditure Summary &
1 Fullerton GL SQR, Pages FUL_DR_FULDR004 FULDR004 Detail Report Campus reporting Reporting Session
1 Fullerton GL SQR, Pages FUL_GL_FULGL002 FULGL002 GL Detail Activity Report Reporting Session
Custom process to roll all
document dates to ensure no
problems will exist when the month
1 Fullerton GL SQR, Pages FUL_GL_FULGL004 FULGL004 Budget Date Roll is closed out. Use PS Delivered Functionality
1 Fullerton GL SQR, Pages FUL_GL_COA_FILES FULGL102 ChartField Extract Chartfield extract. Third Party Interface Document
29adc070-b05f-449f-878a-517ba5a30fc2.xls 16 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Recharge Setup
Used for the Following:
FAMIS Physical Plant W/O
Other Communications
Copier
Copier - Acad Affrs
Info. Tech. Center
Mail Sort
Parcel Service
Campus Police Ovrtm
Campus Police Cso
Campus Police
Reprographics
Stores
Titan Card Operation
Titan Communications
Telephone Usage
Utilities
OfficeMax
Postage
1 Fullerton GL SQR, Pages FUL_GL_RECHARGE_PROJECT FULRC001 Parking - Revenue Transfers GL09003 - Charge Back
1 Fullerton GL SQR, Pages FUL_GL_RECHARGE_PROJECT FULRC003 Load Batch Charges - Users GL09003 - Charge Back
1 Fullerton GL SQR, Pages FUL_GL_RECHARGE_PROJECT FULRC004 Recharge Data Entry GL09003 - Charge Back
1 Fullerton GL SQR, Pages FUL_GL_RECHARGE_PROJECT FULRC005 Recharge Inquiry GL09003 - Charge Back
Security for requisition entry,
budget transfer, and distributed
1 Fullerton Other SQR, Pages FUL_SEC_FULDS001A FULDS001c Distributed User Reports report
1 Fullerton Other SQR, Pages FUL_FN_DW_FILES FULDW001 Interface into FileNet - scanning Scanning Third Party Interface Document
1 Fullerton Other SQR, Pages FUL_FN_ROLE_EXTRACT FULFN001 Interface into FileNet - reports Third Party Interface Document
Implement LDAP security to make
the CMS FIS System integrate into
1 Fullerton Other SQR, Pages FUL_SEC_AUTH FULIT001 Portal to FIS Integration the Fullerton Portal. Third Party Interface Document
1 Fullerton Other SQR, Pages FUL_SEC_IT_PARAMETERS FULIT002 Create IT Parameters Third Party Interface Document
1 Fullerton Other Query FUL_QRY_MGR FULIT005 Query Manager My queries for campus users Reporting Session Sent to WH and used for imaging
1 Fullerton Other Query FUL_QRY_UPGRADE FULIT007 Query Retrofitt 9.0 project for query migration Reporting Session Sent to WH and used for imaging
1 Fullerton PO SQR, Pages FUL_DR_FULDR001 FULDR001 Distributed Requisition/PO Summary Report Campus user reporting Reporting Session
1 Fullerton PO SQR, Pages FUL_DR_FULDR001 FULDR002 Distributed Requisition/PO Detail Report Campus user reporting Reporting Session
Distributed User Report: Budget Transfer / Load
1 Fullerton PO SQR, Pages FUL_DR_FULDR005 FULDR005 Report Campus user reporting Use PS Delivered Functionality
1 Fullerton PO SQR, Pages FUL_DR_FULDR006 FULDR006 Open Commitment Report Campus user reporting Use PS Delivered Functionality
1 Fullerton PO SQR, Pages FUL_PO_COM_ENTRY FULPO001 Commitment Data Entry Page Use PS Delivered Functionality
Fullerton custom requisition Modified IB to handle ACH payments. No Pre Note
1 Fullerton PO SQR, Pages FUL_PO_REQ_ENTRY FULPO002 REQ Data Entry Page application Requisition Common Door are used.
Fullerton custom requisition
1 Fullerton PO SQR, Pages FUL_PO_REQ_ENTRY FULPO002a REQ Inquiry Page application Use PS Delivered Functionality
29adc070-b05f-449f-878a-517ba5a30fc2.xls 17 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Fullerton custom requisition
1 Fullerton PO SQR, Pages FUL_PO_REQ_ENTRY FULPO002b REQ Approval Page application Use PS Delivered Functionality
Fullerton custom requisition
1 Fullerton PO SQR, Pages FUL_PO_REQ_ENTRY FULPO002c REQ Buyer Assignment Page application Use PS Delivered Functionality
Fullerton custom requisition
1 Fullerton PO SQR, Pages FUL_PO_REQ_ENTRY FULPO002d REQ NIGP Assignment Page application Use PS Delivered Functionality
Fullerton custom requisition
1 Fullerton PO SQR, Pages FUL_PO_REQ_ENTRY FULPO002e REQ to PO Sourcing application Use PS Delivered Functionality
Fullerton custom requisition
1 Fullerton PO SQR, Pages FUL_PO_REQ_ENTRY FULPO002f REQ Print Program application PO09004 - Requisition Form
Fullerton custom PO print program PO99011 - Purchase Order Print
1 Fullerton PO SQR, Pages FUL_PO_PO_PRINT FULPO003 PO Print Program similar to POPO005.SQR Format
Role Level Security - Distributed User Report: Fullerton custom department
1 Fullerton Security SQR, Pages FUL_DR_FULDR007_FULDR008 FULDR007 Department Security Report security application GL09001 - Delegation of Authority
Role Level Security - Distributed User Report: Fullerton custom department
1 Fullerton Security SQR, Pages FUL_DR_FULDR007_FULDR008 FULDR008 Security Access Report security application GL09001 - Delegation of Authority
Fullerton custom department
1 Fullerton Security SQR, Pages FUL_SEC_FULDS001A FULDS001a Role Level Security - Department Security Build security application GL09001 - Delegation of Authority
Fullerton custom department
1 Fullerton Security SQR, Pages FUL_SEC_FULDS001B FULDS001b Role Level Security - Security Administrator Reports security application GL09001 - Delegation of Authority
This process is run after an Asset
Management activity journal is
Updates the Asset Management accounting entries
generated and deleted in order to
table (PS_DIST_LN), changing the
prevent the journal from being
GL_DISTRIB_STATUS flag from 'N' (not distributed) AM09006 - AM DIST Line AP and FY
posted to the General Ledger.
1 Humboldt AM SQR Process HUMAM002 to 'D' (distributed), for a specified journal ID. Update
Direct Payments Signature Authority Exceptions
1 Humboldt AP HUMAP023 Report GL09001 - Delegation of Authority
Direct Payments Signature Authority Exceptions
1 Humboldt AP HUMAP024 Report (no approver) GL09001 - Delegation of Authority
Signature Authority Exceptions Report (POs wityh
1 Humboldt AP HUMAP025 Different Fund or Department)( GL09001 - Delegation of Authority
Produces the Wells Fargo checks for printing on Custom formatting is required to
check stock. Custom formatting is required to display display the HSU logo, embedded
the HSU logo, embedded signature, and other signature, and other campus-
campus-specific information. specific information.
1 Humboldt AP Crystal Report CHECK5 AP06001 - AP Check Format
Custom formatting is required to
Produces the file copy of the Wells Fargo checks.
display the HSU logo, embedded
Custom formatting is required to display campus-
signature, and other campus-
specific information.
specific information.
1 Humboldt AP Crystal Report COPY5 Eliminated
29adc070-b05f-449f-878a-517ba5a30fc2.xls 18 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
This process was modified to
Banner vendor/voucher interface process. Loads a
update the vendor table if a student
Banner CSV interface file containing student refund
already exists, rather than creating
and financial aid transactions in order to produce
a new vendor each time.
vouchers and vendors in Accounts Payable.
1 Humboldt AP SQR Process HUMAP019 Originally cloned from CSUAP019. eliminated -- per Humboldt
Accounts Payable open liability
report.
Accounts Payable open liability report. Originally
cloned from the SLO report, SLONOFNL. Originally
cloned from the SLO report, SLONOFNL.
1 Humboldt AP SQR Report HUMAP020 Reporting Session
Needed a report listing the
A report listing the purchase orders received that purchase orders received that have
have not been invoiced. Originally cloned from the not been invoiced.
1 Humboldt AP SQR Report HUMAP021 SLO report, SLONOINV. PO09002 - Purchase Order Life Cycle
Needed a process to convert data
GE Procurement Card interface process. Converts file from a flat file obtained from GE
data file from a flat file obtained from GE into a file into a file that is then loaded into
that is then loaded into the EDI Manager for loading the EDI Manager for loading into
into PeopleSoft Voucher tables. Also produces a PeopleSoft Voucher tables.
report of the transactions obtained from the GE
database.
1 Humboldt AP SQR Process HUMAP022 PO09001 - Procard
Accounts Receivable aging report by fund and Needed an Accounts Receivable
account. Modified for use by Humboldt from the SLO aging report by fund and account.
report, SLOAR001. Also modified printer settings to
accommodate the wider output due to an additional
AR02001 - AR Aging by Fund and
aging category.
1 Humboldt AR SQR Report HUMAR001 Account Report
Needed an Accounts Receivable
Accounts Receivable aging report by
aging report by collector/customer.
collector/customer. Modified for use by Humboldt
from the SLO report, SLOAR002. Also modified
printer settings to accommodate the wider output due
to an additional aging category. AR09002 - AR Aging by Customer
1 Humboldt AR SQR Report HUMAR002 Report
Needed a Billing interface process
Billing interface process. Reads invoice information which reads invoice information
from a CSV file and loads into billing interface tables if from a CSV file and loads into
edits are passed. Modified for use by Humboldt from billing interface tables if edits are
the SLO process, SLOBILD. passed.
Technology Used: SQR Process
1 Humboldt BI SQR Process HUMBILD BI09002 - Billing Upload
29adc070-b05f-449f-878a-517ba5a30fc2.xls 19 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Billing/Accounts Receivable reimbursed activity Needed a Billing/Accounts
process. Modified for use by Humboldt from the SLO Receivable reimbursed activity
process, SLOBIRMB. process.
1 Humboldt BI SQR Process HUMBIRMB BI09003 - Automatic Invoicing
Crystal invoice report. Custom formatting is required Needed a Crystal invoice report.
to display the HSU logo and other campus-specific
information. Modified for use by Humboldt from the
SLO report, SLOINV01.
1 Humboldt BI Crystal Report HUMINV01 BI09001 - Billing Invoice
Creates the General Ledger balances report sorted by Needed to create the General
business unit, report group (balance sheet, income Ledger balances report sorted by
statement), account type (asset, liability, equity, business unit, report group
revenue, expense), account, and fund. Detail lines (balance sheet, income statement),
show fund totals in the ACTUALS ledger for period account type (asset, liability,
zero, prior period YTD, current period, and YTD. equity, revenue, expense),
account, and fund.
1 Humboldt GL SQR Report HUMGL003 Reporting Session
Creates the General Ledger balances report sorted by Needed to create the General
business unit, SCO fund, CSU fund, report group Ledger balances report sorted by
(balance sheet, income statement), account type business unit, SCO fund, CSU
(asset, liability, equity, revenue, expense), account, fund, report group (balance sheet,
and fund code. Detail lines show fund totals in the income statement), account type
ACTUALS ledger for period zero, prior period YTD, (asset, liability, equity, revenue,
current period, and YTD. expense), account, and fund code.
1 Humboldt GL SQR Report HUMGL004 Reporting Session
Creates the General Ledger budget and encumbrance Needed to Create the General
report sorted by business unit, account type (revenue, Ledger budget and encumbrance
expense), account, and fund. Detail lines show report sorted by business unit,
balances in the budget, actuals, and encumbrance account type (revenue, expense),
ledgers for each account/fund selected. Budget account, and fund. Detail lines
balances are derived from LEDGER_BUDG; period show balances in the budget,
zero balances are derived from LEDGER; actuals and actuals, and encumbrance ledgers
encumbrance balances are derived from for each account/fund selected.
LEDGER_KK. Actuals balances in LEDGER_KK are
separated into prior period YTD and current period
balances.
1 Humboldt GL SQR Report HUMGL005 Reporting Session
29adc070-b05f-449f-878a-517ba5a30fc2.xls 20 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Creates the General Ledger budget and encumbrance Needed to create the General
report sorted by business unit, account type (revenue, Ledger budget and encumbrance
expense), account, fund, and program. Detail lines report sorted by business unit,
show balances in the budget, actuals, and account type (revenue, expense),
encumbrance ledgers for each program. Budget account, fund, and program. Detail
balances are derived from LEDGER_BUDG; period lines show balances in the budget,
zero balances are derived from LEDGER; actuals and actuals, and encumbrance ledgers
encumbrance balances are derived from for each program.
LEDGER_KK. Actuals balances in LEDGER_KK are
separated into prior period YTD and current period
balances.
1 Humboldt GL SQR Report HUMGL008 Reporting Session
Needed to suppors the
Supports the Banner/General Ledger load interface. Banner/General Ledger load
Prints all or selected rows in the interface. Prints all or selected
PS_CSU_ACCTG_LINE table. Rows can be selected rows in the
by any combination of ACCOUNTING_DT, PS_CSU_ACCTG_LINE table.
CSU_BATCH_NBR, and GL_DISTRIB_STATUS. The
report is sorted by accounting date, batch number,
chartfield string, and HSU ID. Subtotals are printed for
each change in chartfield string, batch number, and
accounting date.
1 Humboldt GL SQR Report HUMGL009 Reporting Session
Needed to Print the beginning and
Prints the beginning and ending ledger balances by ending ledger balances by
chartfield (fund code and account number). This chartfield (fund code and account
report is sorted by fund code only. It lists detailed number). This report is sorted by
journal line activity posted/unposted against the fund code only.
ledger for the fiscal year and accounting periods
specified. Modified for use by Humboldt from the
1 Humboldt GL SQR Report HUMGL014 Chancellor's Office report, COOGL005. Reporting Session
Produces the general ledger departmental Needed to produces the general
transactions report for a selected accounting period. ledger departmental transactions
The JRNL_LN table is used as a starting point to report for a selected accounting
gather AP, Banner, budget, and miscellaneous period.
transactions. The KK_ACTIVITY_LOG table is used
as a starting point to gather encumbrance
transactions. Transaction queries are unioned
together in the main procedure to form the result set
upon which the report is based. Transactions are
sorted by business unit, department, fund code, and
account. After each department's transactions have
been printed, a summary page is produced listing
budget, actuals, and encumbrance totals for each
fund and account.
1 Humboldt GL SQR Report HUMGL015 Reporting Session
29adc070-b05f-449f-878a-517ba5a30fc2.xls 21 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Needed to create the Reimbursed
Creates the Reimbursed Activity Fund Balances Activity Fund Balances Report
Report sorted by business unit, program code, fund sorted by business unit, program
code, and account. Detail lines show balances in the code, fund code, and account.
budget, actuals, and encumbrance ledgers for each Detail lines show balances in the
account. Budget balances are derived from budget, actuals, and encumbrance
LEDGER_BUDG; period zero balances are derived ledgers for each account.
from LEDGER; actuals and encumbrance balances
are derived from LEDGER_KK.
AR09001 - Reimbursed Activities Status There Personal Data Table is being updated from
1 Humboldt GL SQR Report HUMGL017 Report HR.
Needed to load the TIE allocation
Loads the TIE allocation targets for a given business targets for a given business unit,
unit, fiscal year, and accounting period. Target fields fiscal year, and accounting period.
are first cleared in the PS_LEDGER_ADB_MTD table
for rows in the selected period. Then, each of the five
TIE allocation trees are processed to issue the
appropriate update commands on the
PS_LEDGER_ADB_MTD table (update statements
are issued for each leaf beneath a basis trust node). GL09009 - Interest Calculation &
1 Humboldt GL SQR Process HUMGL018 Distribution
Needed to produce the TIE
allocation basis analysis report.
Produces the TIE allocation basis analysis report.
This report lists the subfund, basis fund, targets,
period zero balance, period begin balance, period end
balance, and average daily balance for selected rows
in the LEDGER_ADB_MTD table. After all rows have
been reported, a summary page is printed showing GL09009 - Interest Calculation &
1 Humboldt GL SQR Report HUMGL019 the fund range and balances for each subfund. Distribution
Produces the TIE Allocation Target Analysis Report. Needed to produce the TIE
This report lists the subfund, target chartfield string, Allocation Target Analysis Report.
average daily balance, interest percent, and interest
amount for each allocation transaction posted. In
addition, the underlying basis lines are listed below
each target line. Totals are printed at the subfund,
process step, and business unit level. After each
process step has been reported, a subfund summary
page is printed showing the fund range, ADB amount,
interest percent, and interest amount for each
subfund. GL09009 - Interest Calculation &
1 Humboldt GL SQR Report HUMGL020 Distribution
29adc070-b05f-449f-878a-517ba5a30fc2.xls 22 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Rolls the period zero, cash account, basis trust fund Needed to roll the period zero,
balances in the PS_LEDGER_ADB table into their cash account, basis trust fund
corresponding period one balances, for a given balances in the PS_LEDGER_ADB
business unit and fiscal year. If a corresponding table into their corresponding
period one row is not found, one is inserted. If a period one balances, for a given
period one row is found, the posted total amount is business unit and fiscal year.
incremented by the period zero amount. The program
can be run in either update, or nonupdate mode
mode. In nonupdate mode, all insert and update
operations are rolled back before the program exits. A
transaction report is also produced listing each insert
and update operation. GL09009 - Interest Calculation &
1 Humboldt GL SQR Report HUMGL021 Distribution Workflow not in scope
Produces the general ledger departmental summary Replacement for AM090. Needed Has a system that tracks "Pre-Pre" Encumbrances.
report for a selected accounting period to create the GL departmental Ie: travel. Told them they could use a Req/PO/JE to
1 Humboldt GL SQR Report HUMGL022 summary report. Reporting Session facilitate this.
Produces the general ledger departmental detail Replacement for AM091. Needed
report for a selected accounting period to create the GL departmental
1 Humboldt GL SQR Report HUMGL023 detail report. Reporting Session
General Ledger Actuals Details by Department (All
1 Humboldt GL HUMGL023A Accounts) Reporting Session
General Ledger Encumbrance Details by Department
1 Humboldt GL HUMGL024 Reporting Session
Setup pages for requisition users Create framework for single page
1 Humboldt PO PeopleCode, Pages HUM_PREP_HDR2 requisition entry. Use PS Delivered Functionality
Requisition approval page Create framework for single page
1 Humboldt PO PeopleCode, Pages HUM_REQ_APPROVE requisition entry. Use PS Delivered Functionality
Assign buyer to requisition Create framework for single page PO99006 - Buyer Assignment
1 Humboldt PO PeopleCode, Pages HUM_REQ_BUY_ASSIGN requisition entry. Workbench
Buyer completion page Create framework for single page
1 Humboldt PO PeopleCode, Pages HUM_REQ_BUY_COMP requisition entry. Use PS Delivered Functionality
Requisition entry page Create framework for single page Requisition Common Door or
1 Humboldt PO PeopleCode, Pages HUM_REQ_DATA_ENTRY requisition entry. Third Party Interface Document
Requisition inquiry page Create framework for single page
1 Humboldt PO PeopleCode, Pages HUM_REQ_INQUIRY requisition entry. Use PS Delivered Functionality
Requisition inquiry page Create framework for single page
1 Humboldt PO PeopleCode, Pages HUM_REQ_INQUIRY2 requisition entry. Use PS Delivered Functionality
Requisition setup pages Create framework for single page
1 Humboldt PO PeopleCode, Pages HUM_REQ_SETUP requisition entry. Use PS Delivered Functionality
Signature authority entry/inquiry by department Track campus signature authority
permissions and define requisition
authorities for each user based on
1 Humboldt PO PeopleCode, Pages HUM_SIGN_AUTH org unit, fund, and dept. GL09001 - Delegation of Authority
Signature authority entry/inquiry by org unit Track campus signature authority
permissions and define requisition
authorities for each user based on
1 Humboldt PO PeopleCode, Pages HUM_SIGN_AUTHBYORG org unit, fund, and dept. GL09001 - Delegation of Authority
29adc070-b05f-449f-878a-517ba5a30fc2.xls 23 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Signature authority entry/inquiry by fund Track campus signature authority
permissions and define requisition
authorities for each user based on
1 Humboldt PO PeopleCode, Pages HUM_SIGN_BYFUND org unit, fund, and dept. GL09001 - Delegation of Authority
Signature authority entry/inquiry by user Track campus signature authority
permissions and define requisition
authorities for each user based on
1 Humboldt PO PeopleCode, Pages HUM_SIGN_BYUSER org unit, fund, and dept. GL09001 - Delegation of Authority
Produces a life-cycle report for documents related to Needed to produce a life-cycle
a specific purchase order. report for documents related to a
1 Humboldt PO SQR Report HUMPO002 specific purchase order. PO09002 - Purchase Order Life Cycle Use delivered
Load requisition inquiry tables Create framework for single page
1 Humboldt PO SQR Process HUMPO101 requisition entry. Use PS Delivered Functionality
Needed to produce purchase
orders for Procurement. Formatting
of PO adjusted to accommodate
Produces purchase orders for Procurement. windowed envelope. Name of
Formatting of PO adjusted to accommodate process must be POPO005 as it is
windowed envelope. Name of process must be called from standard PS
POPO005 as it is called from standard PS processes. processes. PO99011 - Purchase Order Print
1 Humboldt PO SQR Report POPO005 Format
Needed to create a request for
Quote containing custom
formatting and Humboldt logo.
Request for Quote containing custom formatting and Name of process must be
Humboldt logo. Name of process must be PORFQ01 PORFQ01 as it is called from
1 Humboldt PO SQR Report PORFQ01 as it is called from standard PS processes. standard PS processes. PO99013 - RFQ Bid Form
1 Humboldt HUM_LD_OPUNT Load Signature Authority User IDs GL09001 - Delegation of Authority
Generate Indirect Cost Entries for HSU Grants
1 Humboldt HUMICO01 Management and many components GL09004 - Grants Management
Allocation process for Asset Management requires a
temp table to be created to store the Asset
management data.
A record view is also required to be built for this
allocation process.
1 Long Beach AM Records LB9_AM_JOE LB9_AM_JOE Process Asset Management activity AM09007 - 501 Accounting Entries
Allocation process for Asset Management requires a
temp table to be created to store the Asset
management data.
A record view is also required to be built for this
allocation process. AM09006 - AM DIST Line AP and FY
1 Long Beach AM Records LB9_AM_JOE LB9_AM_JOE Process Asset Management activity Update
29adc070-b05f-449f-878a-517ba5a30fc2.xls 24 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
This program provides a report of
posted payments to be used by the
This program provides a report of posted payments to Accounts Payable department as a
be used by the Accounts Payable department as a reconciliation tool and to facilitate
Page, Record, reconciliation tool and to facilitate month end closing month end closing by ensuring all
1 Long Beach AP SQR LB8_AP_AP001 LBAP001 - AP Posted Payment Report by ensuring all payments have been posted. payments have been posted. AP09003 - Voucher Status Listing
This program provides a report of performance
Page, SQR, measures used by the Accounts Payable department
Record, to evaluate technician performance and respond to
Record LBAP005 - AP Technician Performance Best practice surveys.
1 Long Beach AP PeopleCode LB8_AP_AP005 Report Reporting measures
This program provides a report of performance Session used by the Accounts Payable department to evaluate technician performance and
Page, Query,
Record,
1 Long Beach AP Crystal LB8_AP_AP006 LBAP006 - AP Check Pickup List This program prints remit vendors, vendor names, check numbers, by end users when picking up checks ofPickup List
specified Check
Log signed and payment dates for aAP09006 -range payment dates
Page, Query,
Record,
1 Long Beach AP Crystal LB8_AP_AP007 LBAP007 - AP Check Register Report Print check register with the following information: bankUsed to identify method,handling of checks - AP Check Register payment handling code, and payment amount within a specified paymen
AP09002
code, payment special check number, payment date, vendor name,
Page, Crystal ,
Query, This program prints voucher open items including the
Record, following fields - Vendor ID, vendor name, voucher ID,
Record voucher distrib line number, and amount, accounting
1 Long Beach AP PeopleCode LB8_AP_AP009 LBAP009 - AP Open Items Report date NO Longer being used AP05004 - AP Open Items Listing
This program generates Accounts Payable Detail with
a
Department/Fund/Account/Journal Id sort and totals.
It will support the GL Journal Entry Detail by
Page, SQR, Department report.
1 Long Beach AP Record LB8_AP_AP015 LBAP015 - AP Detail Activity by Dept Used by end users to monitor activityReporting Session
This program provides a report to
This program provides a report to identify Vendors identify Vendors who have reached
who have reached $1500 for state withholding $1500 for state withholding
Page, Record, purposes.This report is used by the Accounts Payable purposes.This report is used by the
1 Long Beach AP SQR LB8_AP_AP016 LBAP016 - AP Voucher YTD Report department. Accounts Payable department. AP09005 - 1099 Misc Report
This program reports journal ID's for posted vouchers.
It also provides vendor information, payment due
dates, and voucher amounts. This report is needed as
a reconciliation tool for the Account Payable. It will
Page, Record, LBAP018 - AP Posted Voucher Rpt - help with the closing of Month End by ensuring all
1 Long Beach AP SQR LB8_AP_AP018 Journal ID for AP posted vouchers Vouchers have been posted in Accounts Payable. Used by A/P to monitor processing AP09003 - Voucher Status Listing
Page, SQR,
Record,
Record
1 Long Beach AP PeopleCode LB8_AP_AP102 Load to AP Load electronic invoices in CSULB AP09009 - AP Voucher Interface
LBAP102 - CSULB standard electronic invoice electronic invoices in CSULB standard electronic invoice format into AP vouchers. standard electronic invoice format into AP vouchers.
29adc070-b05f-449f-878a-517ba5a30fc2.xls 25 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Load speed types from a flat file into Speed Type
1 Long Beach AP Page, SQR LB8_AP_AP103 LBAP103 - Load Speed Types to AP table. Third Party Interface Document
Speed Types used by campus to identify chartfields for Office Max purchases
Convert weekly Office Max electronic invoices into AP09009 - AP Voucher Interface or
1 Long Beach AP LB8_AP_AP105
Page, Record, SQR LBAP105 - Office Max to AP CSULB standard invoice interface. Third Party Interface Document
Convert weekly Office Max electronic invoices into CSULB standard invoice interface.
Page, SQR, Load weekly CSULB Library electronic invoices into
1 Long Beach AP Record LB8_AP_AP108 LBAP108 - CSULB Library to AP AP vouchers. Third Party Interface Document
Load weekly CSULB Library electronic invoices into AP vouchers.
Page, SQR,
Record Convert monthly GE Procard electronic invoices into
1 Long Beach AP PeopleCode LB8_AP_AP109 LBAP109 - GE Procard to AP CSULB standard invoice interface. PO09001 ProCard
Convert monthly GE Procard electronic invoices into CSULB standard invoice interface.
LBAP111 - extract file for the Imaging This the program creates and ftp's an extract file for
1 Long Beach AP Page, SQR LB8_AP_AP111 AP 204 forms the Imaging AP 204 forms Data needed by imaging system to index imagesInterface Document
Third Party of 204 forms
This program produces CSULB check print Crystal
1 Long Beach AP LBCHK3 - Check print program Report - Wells Fargo Bank AP06001 - AP Check - Wells
This program produces CSULB check print Crystal Report Format Fargo Bank
This program reads a text file created by HRSA
LBSF0748.SQR
(CS_Link) and updates Student vendors' Populates information needed by
PS_VENDOR.OLD_VENDOR_ID with student Financial Aid disbursements office
campus IDs. A PS query is then used to report to respond to students requests
1 Long Beach AP Page, SQR LB8_GL_GL601 LBGL601 - Import Student Campus IDs student's refund information for Disbursements Office. about refunds IB
Split daily CashNet transaction file
into 2 interface files, one for A/R
Field, Page, Split daily CashNet transaction file into 2 interface lockbox and another for G/L Type
1 Long Beach AR SQR, Record LB8_AR_AR101 files, one for
LBAR101 - CashNet transaction file split to be fed into G/L and A/R. A/R lockbox and another for G/L Type B. B. Third Party Interface Document
This program produces a report
showing the A/R Aging along with
This program produces a report showing the A/R conversation notes (comments)
Aging along with conversation notes (comments) made by payroll technicians
Page, Page made by payroll technicians associated with the associated with the details of the
PeopleCode, details of the obligation. This report is used by Payroll obligation. This report is used by
1 Long Beach AR SQR, Record LB8_AR_AR006 LBAR200 - A/R Aging with Conversation Office. Payroll Office. AR09002 - AR Aging by Customer
This program produces a report
showing the A/R Item (actual
obligation detail) Activity along with
Page, Page This program produces a report showing the A/R Item conversation notes (comments)
PeopleCode, (actual obligation detail) Activity along with made by payroll technicians
SQR, Record, conversation notes (comments) made by payroll associated with these items
Record technicians associated with these items (obligations). (obligations). This report is used by
1 Long Beach AR PeopleCode LB8_AR_AR007 This
LBAR201 - A/R Item Activity with Conversation report is used by Payroll Office. Payroll Office. Reporting Session
This program produces CSULB
Process job, LBAR3301 - CSULB Level One Dunning This program produces CSULB Level One Dunning Level One Dunning Letter for A/R.
1 Long Beach AR Crystal, Query LB8_AR_DUNNING Letter Letter for A/R. This is used for A/R collections. This is used for A/R collections. AR09004 - Dunning Letter
29adc070-b05f-449f-878a-517ba5a30fc2.xls 26 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
This program produces CSULB
Process job, LBAR3302 - CSULB Level Two Dunning This program produces CSULB Level Two Dunning Level Two Dunning Letter for A/R.
1 Long Beach AR Crystal, Query LB8_AR_DUNNING Letter Letter for A/R. This is used for A/R collections. This is used for A/R collections. AR09004 - Dunning Letter
This program produces CSULB
Level Three Dunning Letter for
Process job, LBAR3303 - CSULB Level Three This program produces CSULB Level Three Dunning A/R. This is used for A/R
1 Long Beach AR Crystal, Query LB8_AR_DUNNING Dunning Letter Letter for A/R. This is used for A/R collections. collections. AR09004 - Dunning Letter
This program prints portrait-style consolidated
invoices. It shares many sqc members with the
1 Long Beach AR LBIVCPN - Print Portrait style invoices program for printing non-consolidated invoices. Invoices for customers BI09001 - Billing Invoice
Fields,
Records,
SQRs, Pages, This the program reads a CSV file and will load the
PeopleCode, billing interface tables based on the information in that Used to process A/R billing
1 Long Beach AR Query, SQL LB_FS_BI_REIMBURSED_ACTIVITY SLOBILD - Reimbursed Billing Upload file, if it passes edits. activities BI09002 - Billing Upload
Fields,
Records,
SQRs, Pages, They need this mod until all the old COA usage
PeopleCode, SLOBIRMB - Reimbursed Activity Used to process A/R billing (Project needs to change to Fund) is phased out to
1 Long Beach AR Query, SQL LB_FS_BI_REIMBURSED_ACTIVITY Interface SLO Billing/AR Reimbursed Activity Process activities BI09003 - Automatic Invoicing the new COA usage.
Field, Page,
SQR, Record, This program (LBBD002) reads the ledgers to create
Record a table that will be used by various local reports. It
PeopleCode, LB_BD_BD002 LBBD002 - Extract specified month's also pulls some data from the DEPTID and Used as the data source for end
1 Long Beach GL Tree LB8_BD_BD002 ledger data to a local reporting table ACCT_TREE trees. user reports Reporting Session
This report prints the budget and
expenditure status of Lottery
Page, SQR, LBBD003 - Lottery Revenue Funds Stat This report prints the budget and expenditure status Revenue Funds. Budget office use
1 Long Beach GL Record LB_BD_REF420 Rpt of Lottery Revenue Funds. to reconcile BBA Reporting Session
Page, SQR, This program generates the Original Budget
Record LB_BD_BD004 LBBD004 - Original Budget Allocation Allocation Report. This report is used by the Budget
1 Long Beach GL PeopleCode LB8_BD_BD004 Report department. No Longer being used Eliminated - Not Used
Page, SQR, This program creates an Excel spreadsheet (actually
Record, a CSV file) that contains the YTD FIRMS amounts
Record LBBD005 - YTD Firms Expenditures from the ACTUALS ledger for the FIRMS business
1 Long Beach GL PeopleCode LB8_BD_BD005 Report unit. NO Longer being used Eliminated - Not Used
Field, Page,
SQR, Record, Budget Office use this report to
Record LB_BD_REF447 LBBD006 - Budget PTD & PTDCMP This program prints the Fiscal Year End PTD & reconcile PTD and book carryover
1 Long Beach GL PeopleCode LB8_BD_BD006 Scenario Derivation Rpt PTDCMP Scenario Derivation Report. balance Reporting Session
29adc070-b05f-449f-878a-517ba5a30fc2.xls 27 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Page, SQR,
Record, Budget Office use this report to
Record LB_BD_REF449 LBBD007 - BBA Scenario Derivation This program prints the Fiscal Year End BBA reconcile BBA and book carryover
1 Long Beach GL PeopleCode LB8_BD_BD007 Rpt Scenario Derivation Report. balance Reporting Session
This report prints the beginning and ending ledger
balances by chartfield (dept, fund code, and program
number). This report is sorted by department only. It
Page, SQR, lists detailed journal line activity posted/unposted
Record LBBD008 - Budget Ledger Detail against the LEDGER_BUDG for the fiscal year and
1 Long Beach GL PeopleCode LB8_BD_BD008 Activity Report by Department accounting periods specified. NO Longer being used Reporting Session
This report prints the beginning and ending budget
ledger balances by chartfield (account number and
fund code). This report is sorted by account only. It
lists detailed journal line activity posted/unposted
LBBD009 - Budget Ledger Detail by against the LEDGER_BUDG for the fiscal year and
1 Long Beach GL NO LONGER USED
NO LONGER USED Acct accounting periods specified. Use CS-Link report instead Eliminated - Not Used
This report prints the beginning and ending budget
ledger balances by chartfield (fund code and account
number). This report is sorted by fund code only. It
lists detailed journal line activity posted/unposted
LBBD010 - Budget Ledger Detail by against the LEDGER_BUDG for the fiscal year and
1 Long Beach GL NO LONGER USED
NO LONGER USED Fund accounting periods specified. Use CS-Link report instead Eliminated - Not Used
Page, SQR,
Record,
Record LBBD012 - Sub-division by Selected Sub-division by Selected Funds Revenue and
1 Long Beach GL PeopleCode LB8_BD_BD012 Funds Summary Report Expenditure Summary Report NO Longer being used Eliminated - Not Used
Page, SQR,
Record,
Record LB8_BD_BD020 LBBD020 - Statement of Operations - This program Lists account totals by a specified fund. Used by End user for review of
1 Long Beach GL PeopleCode LB8_BD_BD020 Summary This is an end user report. Financial status Reporting Session
Page, SQR,
Record,
Record LB8_BD_BD020 LBBD021 - Statement of Operations - This program Lists account totals by a specified fund Used by End user for review of
1 Long Beach GL PeopleCode LB8_BD_BD020 Detail and by department. This is an end user report. Financial status Reporting Session
This the program creates 22 Excel spreadsheets
(actually CSV files) for End User Reporting.
This program will read the local table created by
LBBD002.SQR for it's financial ledger data. The
Page, SQR, following are some sample of the 22 reports: Divisiion Used by end users to review the
Record, by Fund Detail Report; Sub-division by Fund status of the funds at Division, sub
Record LBEU001 - Create End User CSV Files summary report; Department by Fund detail report; division, sub sub division ans
1 Long Beach GL PeopleCode LB8_EU_EU001 and reports etc. Department levels. Third Party Interface Document
Page, SQR, This program creates a financial summary report for
Record UCES. This program will read the Used by UCES to monitor financial
1 Long Beach GL PeopleCode LB8_EU_EU002 LBEU002 - UCES Financial Summary PS_LB_BD002_TBL for it's financial data. status. Reporting Session
29adc070-b05f-449f-878a-517ba5a30fc2.xls 28 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
This program creates an Excel spreadsheet (actually
LBEU008 - Parking - Revenue/Expense a CSV file) for End User Reporting. This program will Used by Parking to monitor
1 Long Beach GL Page, SQR, Record
LB8_EU_EU008 by Fund User Report read the PS_LB_BD002_TBL for it's financial data. Financial status Reporting Session
This program reads the PS_LB_DB002_TBL, extracts
balances for Parking Related Funds, and creates a
Field, Page, Balance Sheet for these funds as well as a summary Used by Parking to monitor
1 Long Beach GL SQR, Record LB8_EU_EU010 LBEU010 - Parking Balance Sheet report. Financial status Reporting Session
Component
record field
PeopleCode, This the program reads a CSV file and will compare
Page, Record, the housing fees from PS_SF_ACCTG_LN table. This Used by end users for
1 Long Beach GL SQR LB8_EU_EU020 LBEU020 - Housing Recon Report report is used by Housing for reconciliation purposes. reconciliation purposes. Reporting Session
This program picks up a specified
FIRMS Extract file from Unix
LBFTP05 - FTP FIRMS Exctract File to This program picks up a specified FIRMS Extract file server and ftp's it to our local
1 Long Beach GL Page, SQR LB8_FTP_FTP05 a CSULB local server from Unix server and ftp's it to our local server. server. GL09002 - FTP
This program compares ledger_kk
against kk_activity_log and reports
variances. Used by General
LBGL001 - LEDGER_KK Variance This program compares ledger_kk against Accounting to identify out of sync
1 Long Beach GL Page, SQR LB8_RUN_GL001 Report kk_activity_log and reports variances. items in a timely manner. Reporting Session
This report prints the beginning and ending ledger
balances by chartfield (dept, fund code, and program
number). This report is sorted by department only. It
lists detailed journal line activity posted/unposted
against the ledger for the fiscal year and accounting Used by end users for
1 Long Beach GL Page, Record, SQR
LB8_GL_GL004 LBGL004 - GL Detail Activity by Dept periods specified. reconciliation purposes. Reporting Session
This report prints the beginning and ending ledger
balances by chartfield (Fund_code, and Account
number). This report is sorted by Fund_code only. It
lists detailed journal line activity posted/unposted
against the ledger for the fiscal year and accounting Used by end users for
1 Long Beach GL LB8_GL_GL005
Page, Record, SQR LBGL005 - Gen Ledger Dtl Act by Fund periods specified. reconciliation purposes. Reporting Session
This the program creates 7 Excel spreadsheet
(actually
Page, SQR, a CSV file) that contains the following chart fields and
Record, descriptions: Fund, Account, DeptID, Program, Class, Files created of chartfield values
Record LB_GL_GL007 and Project. These files are posted to CSULB website posted to web for use by end
1 Long Beach GL PeopleCode LB8_GL_GL007 LBGL007 - GL PS COA Extract for end users. users. Third Party Interface Document
Page, SQR, This program reads a CSV file and will load a new
Record, Journal based on the information in that file, if it
Record passes edits. Upload journal entries instead of
1 Long Beach GL PeopleCode LB8_GL_GL008 LBGL008 - GL Journal Entry Upload keying them online GL05001 - Journal Upload Process
29adc070-b05f-449f-878a-517ba5a30fc2.xls 29 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Various departmental G/L type B transactions to be
fed into G/L.Copier program transactions; Postage
transactions; Telecom transactions; Print shop Upload charges for chargebacks
1 Long Beach GL Page, SQR LB8_GL_GL009 LBGL009 - Load CSU_ACCTG_LINE - transactions; etc. and self support operations GL09003 - Charge Back
Page, Crystal,
Query, This program prints credit amount, debit amount, and
Record, SQL LBGL010B - GL Balancing Rpt by PS net amount of a batch from CSU_ACCTG_LINE table Used by end users for
1 Long Beach GL definition LB8_GL_GL010 COA. by chartfield combination. reconciliation purposes. Reporting Session
This report prints the beginning and ending ledger
balances by chartfield (dept, fund code, class, and
program number). This report is sorted by
department only. It lists detailed journal line activity
LBGL011 - GL Detail Activity - by Dept, posted/unposted against the ledger for the fiscal year Used by end users for
1 Long Beach GL Page, SQR LB8_GL_GL011_GL012 Fund, Class, Program and accounting periods specified. reconciliation purposes. Reporting Session
This report prints the beginning and ending ledger
balances by chartfield (Fund, Class and Account
number). This report is sorted by Fund and Class. It
lists detailed journal line activity posted/unposted
LBGL012 - GL Detail Activity - by Fund, against the ledger for the fiscal year and accounting Used by end users for
1 Long Beach GL Page, SQR LB8_GL_GL011_GL012 Class periods specified. reconciliation purposes. Reporting Session
For a particular fund Code as of an accounting period
of a Fiscal Year this report lists balances of 305002
(Funs Balance – continuing approp.), 205090
(Operation Revenue collect in advance), and all
revenue accounts, sums up the balances of all of the
above as total sources of fund, then lists all
expenditure accounts balance ,subtracts the sum of
LBGL014 - Trust Fund Balance all expenditure accounts from the total sources of Used by end users to monitor
1 Long Beach GL Page, SQR LB8_GL_GL014 Available Report fund as balance available. financial activity Reporting Session
This program reads the accounting line tables, kk
Page, SQR, activity log, and journal line tables, etc. to populate a
Record, reporting table LB_ACCTG_LN_RPT that will be used
Record LBGL116 - Load Acctg Lines Reporting in various consolidated detail activity reports. Data needed to create end user
1 Long Beach GL PeopleCode LB8_GL_GL116, LB_FS_PACKET_HD19551 Table for Consolidated Detail Report reports Reporting Session
This program extracts G/L chartfields and their
descriptions for CashNet. The extract file is uploaded
to CashNet server by a local FTP program. This data Used to populate Cashnet to
is used to control the chartfields which can be used by control chartfields which could be
Field, Page, LB_GL_GL119_REF532 cashiers. used by Cashiers when posting
1 Long Beach GL Record, SQR LB8_GL_GL119 LBGL119 - GL Cashnet COA Extract cash receipts Third Party Interface Document
29adc070-b05f-449f-878a-517ba5a30fc2.xls 30 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
This report prints the project-to-date pre_enc, enc,
actuals, and budget amounts by project then by
Page, SQR, account, by fund, and by deptid. It uses reporting
Record, table PS_LB_ACCTG_LN_RPT to sum up detailed
Record LBGL122 - GL Consolidated Summary activity to summary level. PS_LB_ACCTG_LN_RPT End user report for reconciling
1 Long Beach GL PeopleCode LB8_GL_GL122 by Project is populated by LBGL116. This is an end user report. project activity Reporting Session
This report prints the beginning and ending ledger
balances by chartfield (project ID, fund code, program
code, and dept) for actuals as well as budgets. It uses
a reporting table PS_LB_ACCTG_LN_RPT for the
detailed activity. PS_LB_ACCTG_LN_RPT is
populated in a process called LBGL116. The detail
Page, SQR, will include Budget, Pre Encumbrance, Encumbrance
Record, and Expended amounts from the accounting lines
Record LBGL123 - GL Consolidated Project tables as well as journal entries. End user report for reconciling
1 Long Beach GL PeopleCode LB8_GL_GL123 Detail Report This is an end user report. project activity Reporting Session
This report prints the PTD budgets, and "actual"
revenue / expenses by "current month", "fiscal year"
and "project to date". It also includes "open
commitment, total commitment and the balance
Page, SQR, LBGL124 - GL Project Summary by available. The report is run for one fund at a time. End user report for reconciling
1 Long Beach GL Record LB8_GL_GL124 Fund Report This is an end user report. project activity Reporting Session
This report prints the PTD budgets, and "actual"
revenue / expenses by "current month", "fiscal year"
and "project to date". It also includes "open
commitment, total commitment and the balance
Page, SQR, available. The report is run for one department at a End user report for reconciling
1 Long Beach GL Record LB8_GL_GL125 LBGL125 - Project Summary by Deptid time. This is an end user report. project activity Reporting Session
This report prints the PTD budgets, and "actual"
revenue / expenses by "current month", "fiscal year"
and "project to date". It also includes "open
commitment, total commitment and the balance
Page, SQR, LBGL126 - Project Summary by available. The report is run for one department at a End user report for reconciling
1 Long Beach GL Record LB8_GL_GL126 Program time. This is an end user report. project activity Reporting Session
This report prints the beginning and ending ledger
balances by chartfield (dept, fund code, class, and
Page, SQR, program number) for actuals as well as budgets. It
Record, uses a reporting table PS_LB_ACCTG_LN_RPT for
Record LBGL130 - Generic GL Consolidated the detailed activity. This report is run daily for the End user reporting for reconciling
1 Long Beach GL PeopleCode LB8_GL_GL130 Detail Report end users. detail activity Reporting Session
29adc070-b05f-449f-878a-517ba5a30fc2.xls 31 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
This resets the budget dates and
accounting dates each month on
This resets the budget dates and accounting dates non-closed PO's, REQ's and
each month on non-closed PO's, REQ's and Vouchers. Specifically, it will modify
Vouchers. Specifically, it will modify these 2 fields to these 2 fields to the first day of the
Page, SQR, the first day of the new accounting period so there are new accounting period so there are
Record, no issues with continued processing of these no issues with continued
Record LBGL200 - Month-End Accounting Date documents. processing of these documents.
1 Long Beach GL PeopleCode LB8_GL_GL200 Roll Use PS Delivered Functionality
This reads the DEPTID tree and creates a flat file
containing division, sub-division, sub-sub-division,
department ID and their descriptions for use by the
Page, SQR, TelMaster System. The TelMaster System will use
Record, this file to compare against its' own hierarchy and as
Record LBGL500 - TelMaster DEPTID Tree necessary. Provides dept tree information for
1 Long Beach GL PeopleCode LB8_GL_GL500 Extract campus telecom billing system Third Party Interface Document
This program reports ratio of
Field, Page, This program reports ratio of Student A/R to Revenue Student A/R to Revenue for
SQR, Record, LBGL600 - Student A/R to Revenue for Student Financial balance scorecard Student Financial balance
1 Long Beach GL Translate LB8_GL_GL600 Ratio Report measurement. scorecard measurement. Reporting Session
Tables housing parameters used
1 Long Beach Other Page, Record LB8_TECHNICAL_PARAMETERS LB Technical Parameters Tables housing parameters used by LB reports by LB reports Eliminated
This program ftps files from Unix
Page, SQR, LBFTP01 - FTP Unix Files to CSULB This program ftps files from Unix server back to server back to various local
1 Long Beach Other Record LB8_FTP_FTP001 local servers various local servers. servers. Third Party Interface Document
This program retrieves the temp
tables from
PS_TEMP_TBL_ASGNM with an
Component in_use_sw flag of 'Y' and resets it
record field as well as the process instance.
PeopleCode, This program retrieves the temp tables from We run this monthly to clear temp
Component PS_TEMP_TBL_ASGNM with an in_use_sw flag of table in use switch to avoid
record 'Y' and resets it as well as the process instance. We potential future problems while
PeopleCode, run this monthly to clear temp table in use switch to running processes that access
Field, Page, avoid potential future problems while running these temp tables. SOSS provided
Record, SQL LBTMPMNT - LB Non-Shared Table processes that access these temp tables. SOSS instructions to us for writing this
1 Long Beach Other definition LB8_TMP_MNTNCE Maintenance provided instructions to us for writing this program. program. Data Integrity
29adc070-b05f-449f-878a-517ba5a30fc2.xls 32 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Cloned from the delivered PO_PO_EMAIL App
Engine programand modified to• Have the email from:
purch-dispatch@csulb.edu
• Format the Buyer’s name to “First Last”.
• Include the Buyer’s name on the email subject line.
• Include the Buyer’s email address in the email “copy
to”.
• Add a new message (31000, 16) in the message
catalog to :
o Have the message description assign variables to
include the PO# and Buyer’s name on the email
subject line.
o Have the message explanation (long description)
contain the email text with a variable for the PO#.
Process definition LB_PO9_EMAIL was created. This
process was added as a step to Job PODISPATCH. Used by Purchasing to send e-mail PO99011 - Purchase Order Print
1 Long Beach PO App Engine LB_PO9_EMAIL LB_PO9_EMAIL - App Engine program to end users Format
This program reports any PO's whose Buyer ID, Effective 6/30/09 we will no
Approved by OPRID, or Modified by OPRID is not the longer need this report as we
LBAU014 - LBTRV PO Buyer Activity same as Entered by OPRID during a specified period are no longer encumbering
1 Long Beach PO Page, SQR LB8_AU_AU014 Audit Report of time. Travel funds Eliminated - Not Used
This program checks all User
Profiles that have been assigned
This program checks all User Profiles that have been one of the LB_DEPT_BUYER_
assigned one of the LB_DEPT_BUYER_ roles and roles and reports any User Profile
LBEU009 - PO Department Buyer reports any User Profile that can approve its own that can approve its own Purchase
1 Long Beach PO LB8_EU_EU009
Page, Record, SQR Conflict of Interest Audit Purchase Orders. Orders. Security Related
Page, SQR,
Record,
Record This program provides a list of POs with some detail Used by Purchasing to monitor
1 Long Beach PO PeopleCode LB8_PO_PO008 LBPO008 - Vendor PO Activity Report activities, sorted by vendor and PO#. activity Reporting Session
Page, SQR,
Record, This program reports Purchase
Record LBPO009 - PO Activity by Category ID This program reports Purchase Order activities by Order activities by NIGP
1 Long Beach PO PeopleCode LB8_PO_PO009 Rpt NIGP (Commodity) Code. (Commodity) Code. Reporting Session
This report prints the supporting detail for the general
ledger pre-encumbrance balances. It lists requisition
Page, SQR, distribution accounting line activity for the user
Record, defined time period and is selected using the
Record accounting transaction date (not necessary the Used by end users to monitor
1 Long Beach PO PeopleCode LB8_PO_PO010 LBPO010 - REQ Detail Activity by Dept requisition date). activity Reporting Session
29adc070-b05f-449f-878a-517ba5a30fc2.xls 33 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
This report prints the supporting detail for the general
ledger pre-encumbrance balances. It lists requisition
Page, SQR, distribution accounting line activity for the user
Record, defined time period and is selected using the
Record accounting transaction date (not necessary the Used by end users to monitor
1 Long Beach PO PeopleCode LB8_PO_PO011 LBPO011 - PO Detail Activity by Dept requisition date). activity Reporting Session
This program creates a report for Purchasing to
LBPO014 - Req to GL Fund Balancing summarize requisition pre-encumbrance activity and
1 Long Beach PO Page, SQR LB_PO014_R539 Rpt compare it to General Ledger Activity. No Longer being used Eliminated - Not Used
This program creates a report for Purchasing to
LBPO015 - PO to GL Fund Balancing summarize purchase order encumbrance activity and
1 Long Beach PO Page, SQR LB_PO_REF164 Rpt compare it to General Ledger Activity. No Longer being used Eliminated - Not Used
This program extracts PO information to be used for PO information transferred to
LB_PO_PO018_REF483 LBPO018 - Extract PO Info for indexing documents scanned. Imaging server for indexing of
1 Long Beach PO Page, SQR LB8_PO_PO018 Scanning and Indexing images of Purchasing documents Third Party Interface Document
This program will identify any PO's that have open an
encumbrance balance. To identify this the program
will use the initial encumbrance, any encumbrance
Index, Page, reversals (from vouchers), and any encumbrance
SQR, Record, closures (liquidations from PO Post). The fields of this
Record report are different from the baseline report. Used by Purchasing and end users
1 Long Beach PO PeopleCode LB8_PO_PO100, LB_FS_PACKET_HD19551 LBPO100 - Open PO Report to manage their open PO's Reporting Session
This program will identify any REQ's that have open
an pre-encumbrance balance. To identify this the
program will determine the initial pre-encumbrance,
any pre-encumbrance reversals (from PO's), and any
pre-encumbrance closures (liquidations from REQ Used by Purchasing and end users
1 Long Beach PO LB8_PO_PO101, LB_FS_PACKET_HD19551
Page, SQR, Record LBPO101 - Open REQ Report Post). to manage their open requisitions Reporting Session
This program processes the inbound Planet Bids
Vendor Interface file containing vendor data from the
Page, SQR, external web vendor. This program will process
Record, "adds" and "updates" based on the information
Record LBPO102 - PO Vendor Plant Bids provided on the input file. Used to update vendor information
1 Long Beach PO PeopleCode LB8_PO_PO102 Interface in PS Finance Third Party Interface Document
This program produces a monthly summary report for
requisitions showing month-by-month counts and
totals for requisitions by status (statuses includes
open, approved, completed, canceled, deleted) for 18
months ending with the fiscal year and month
supplied in the run control. Optionally, detail info can Used by Purchasing to monitor
1 Long Beach PO Page, SQR LB8_PO_PO109 LBPO109 - Monthly Req Stats be printed also. activity Reporting Session
29adc070-b05f-449f-878a-517ba5a30fc2.xls 34 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
This program produces a monthly summary report for
purchase orders showing month-by-month counts and
totals for purchase orders by Buyer Name. It also Used by Purchasing to monitor
1 Long Beach PO Page, SQR LB8_PO_PO110 LBPO110 - Monthly POs By Buyer provides a grand total for each buyer. activity. Reporting Session
This program produces a monthly summary report for
purchase orders showing month-by-month totals for
purchase orders Gross Count, Cancelled Count, Net
Count, Gross Amt. Count/Amount for fiscal ytd. Used by Purchasing to monitor
1 Long Beach PO Page, SQR LB8_PO_PO111 LBPO111 - Monthly PO Stats Optionally, detail info can be printed also. activity Reporting Session
This report prints PO count and PO dollars for PO
amount <= $2,500, > $2,500, and All PO's by Used by Purchasing to monitor
1 Long Beach PO Page, SQR LB8_PO_PO112 LBPO112 - Low Dollar PO Report accounting period for a specified fiscal year. activity Reporting Session
This report prints PO count and PO dollars for the
LBPO114 - PO Master Enabling following categories: SYS Contracts, MEA's, Service Used by Purchasing to monitor
1 Long Beach PO Page, SQR, Record
LB8_PO_PO114 Agreement Report Orders, and Total Contracts. activity Reporting Session
This program produces three csv files of all active
vendors
1) PO File - contains multiple records for each
vendor (one for each NIGP code)
2) PO File - contains only one record per vendor (no
NIGP codes) Data file of information need in
3) AP File - one record per vendor, different case of disaster recovery when PS
address from PO files. This data is created for use Finance system may not be
1 Long Beach PO Page, SQR LB8_PO_PO115 LBPO115 - Create Vendor CSV Files during a disaster recovery. available Third Party Interface Document
Page, Page This the program creates a CSV file containing
PeopleCode, Requisitions and POs related information such as Used by Purchasing to monitor
1 Long Beach PO SQR LB8_PO_PO116 LBPO116 - REQs & POs by DEPTID date created and status by Department. activity Reporting Session
Component
record field This the program sends out emails to end users for
PeopleCode, Reqs open for more then 7 days, POs processed the Used by Purchasing to provide PO09005 - Req to Check End User
1 Long Beach PO Page, SQR LB8_PO_PO117 LBPO117 - PO Emails previous day & POs dispatched. status to end users Notification
Records, LBPO121 - Open PO report - PO STATUS/Open PO/MISSING RECEIPTS Used by Purchasing to manage
1 Long Beach PO Page, SQR LB_FN_PO_BAKP001 Bakersfield REPORT open PO's Reporting Session
Changed the delivered POPO005 to execute UNIX
commands to copy the PO PDF document to a
CSULB UNIX directory that was created for Creates file sent to Imaging server
documents that will be sent to the scanning device via for storage of Purchasing PO99011 - Purchase Order Print
1 Long Beach PO SQR POPO005 - PO Dispatch program XML. documents Format
This program provides a List of
This program provides a List of Users With Access To Users With Access To Modify
LBAU001 - Users With Access To Modify Chart of Accounts. This is used for PeopleSoft Chart of Accounts. This is used for
1 Long Beach Security Page, SQR LB8_AUDIT_REPORTS Modify Chart of Accounts Security review. PeopleSoft Security review. Security Related
29adc070-b05f-449f-878a-517ba5a30fc2.xls 35 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
This program provides a List of Available FIS Roles. Used to manage /monitor PS
1 Long Beach Security Page, SQR LB8_AUDIT_REPORTS LBAU002 - Available FIS roles This is used for PeopleSoft Security review. Finance security Security Related
This progrm provides a List of Users With Access to
LBAU003 - Users With Access To Modify GL Configurtaions. This is used for Used to manage /monitor PS
1 Long Beach Security Page, SQR LB8_AUDIT_REPORTS Modify GL Configurations PeopleSoft Security review. Finance security Security Related
This program provides a List of Users With Access To
LBAU004 - Users With Access To Modify Closing Rules. This is used for PeopleSoft Used to manage /monitor PS
1 Long Beach Security Page, SQR LB8_AUDIT_REPORTS Modify Closing Rules Security review. Finance security Security Related
This program provides a List of Users With Access To
LBAU005 - Users With Access To Modify Closing Periods. This is used for PeopleSoft Used to manage /monitor PS
1 Long Beach Security Page, SQR LB8_AUDIT_REPORTS Modify Chart of Closing Periods Security review Finance security Security Related
This program provides a List of Users With Access To
LBAU006 - Users With Access To Enter Enter Manual General Ledger Journal Entries. This is Used to manage /monitor PS
1 Long Beach Security Page, SQR LB8_AUDIT_REPORTS Manual General Ledger Journal Entries used for PeopleSoft Security review. Finance security Security Related
This program provides a List of Users With Access To
LBAU007 - Users With Access To Modify Open Items Within GL. This is used for Used to manage /monitor PS
1 Long Beach Security Page, SQR LB8_AUDIT_REPORTS Modify Open Items Within The GL PeopleSoft Security review. Finance security Security Related
This program provides a List of Users With Access To
LBAU008 - Users With Access To Create/Modify User Profiles. This is used for Used to manage /monitor PS
1 Long Beach Security Page, SQR LB8_AUDIT_REPORTS Create/Modify User Profiles PeopleSoft Security review. Finance security Security Related
This program provides a List of Users With Access To
LBAU009 - Users With Access To Approve Requisitions. This is used for PeopleSoft Used to manage /monitor PS
1 Long Beach Security Page, SQR LB8_AUDIT_REPORTS Approve Requisitions Security review. Finance security Security Related
This program provides a List of Users With Access To
LBAU010 - Users With Access To Approve Their Own Requisitions (CSU-LB.PUR.3.B). Used to manage /monitor PS
1 Long Beach Security Page, SQR LB8_AUDIT_REPORTS Approve Their Own Requisitions This is used for PeopleSoft Security review. Finance security Security Related
LBAU011 - Users With Access To This program provides a List of Users With Access To
Modify 2,3,4 Way Matching Modify 2,3,4 Way Matching Configurations. This is Used to manage /monitor PS
1 Long Beach Security Page, SQR LB8_AUDIT_REPORTS Configurations used for PeopleSoft Security review. Finance security Security Related
Report all POs created by anyone with the following
access
Access to create purchase orders
Page, SQR, Access to approve purchase orders
Record LBAU013 - All Pos created by anyone Access to create vouchers Used to manage /monitor PS
1 Long Beach Security PeopleCode LB8_AU_AU013 with some specified accesses Access to match vouchers Finance security Security Related
LBAU015 - Financial Management This program prints Financial Management Roles By
Roles By User By Financial User By Financial Management Manager. This is Used to manage /monitor PS
1 Long Beach Security Page, SQR LB8_AU_AU015 Management Manager used for PeopleSoft Security review. Finance security Security Related
This program prints PS Finance Security Verification
LBAU016 - FIS Security Verification Report By ASM. This is used for PeopleSoft Security Used to manage /monitor PS
1 Long Beach Security Page, SQR LB8_AU_AU016 Report By ASM review. Finance security Security Related
29adc070-b05f-449f-878a-517ba5a30fc2.xls 36 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Page, Page
PeopleCode,
SQR, Record,
Record
PeopleCode, LBAU017 - Creates Reports of Roles By This program prints Financial Management Security Used to manage /monitor PS
1 Long Beach Security SQL definition LB8_AU_AU017 User and Users By Role Roles. This is used for PeopleSoft Security review. Finance security Security Related
This program prints CS-Link Security Verification
Report By ASM. This is used for PeopleSoft Security
LBAU018 - FIS CS-Link Security review. Used to manage /monitor PS
1 Long Beach Security Page, SQR LB8_AU_AU018 Verification Finance security Security Related
This program prints Permission List Access
LBAU019 - Permission List Access Comparison Report. This is used for PeopleSoft Used to manage /monitor PS
1 Long Beach Security Page, SQR LB8_AU_AU019 Comparison Security review. Finance security Security Related
Field, Page,
Page
PeopleCode,
SQR, Record,
Record
PeopleCode. This program reads several csv files and inserts rows
1 Long Beach Security SQL definition LB8_CS_CSLINK LBCS001 - CS-Link Initial Table Load into the LB_CS_* security tables. No Longer being used Eliminated - Not Used
Field, Page,
Page
PeopleCode,
SQR, Record,
Record
PeopleCode. This program prints CS-Link Access by EmplID. This
1 Long Beach Security SQL definition LB8_CS_CSLINK LBCS002 - CS-Link Security by EmplID is used for Report Distribution Security review No Longer being used Eliminated - Not Used
Field, Page,
Page
PeopleCode,
SQR, Record,
Record
PeopleCode. This program prints CS-Link Access by Type of
1 Long Beach Security SQL definition LB8_CS_CSLINK LBCS003 - CS-Link Access by Type Access No Longer being used Eliminated - Not Used
Field, Page,
Page
PeopleCode,
SQR, Record,
Record
PeopleCode. CS-Link Security - This program prints PS IDs not in Used to manage security for report
1 Long Beach Security SQL definition LB8_CS_CSLINK LBCS004 - PS IDs Not In CS-Link CS-Link repository Reporting Session
29adc070-b05f-449f-878a-517ba5a30fc2.xls 37 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
LBEU003 - Create CS Link Security This program read PS Finance data and creates Used to manage security for report
1 Long Beach LB8_EU_EU003
Security Page, SQR, Record Files security files for CS Link. repository Third Party Interface Document
This program loads Roles, operator
preferences, buyer, and requestor
This program loads Roles, operator preferences, information into arrays to facilitate
buyer, and requestor information into arrays to printing. This form is used by end
LBEU004 - Finance Authority facilitate printing. This form is used by end users to users to request PS Finance
1 Long Beach Security LB8_EU_EU004
Page, SQR, Record Application request PS Finance security accesses. security accesses. Security Related
1 Los Angeles AM App. Engine N LA_AM_CONV1 LA_AM_CONV1 Eliminated
1 Los Angeles AM App. Engine N LA_AM_CONV2 LA_AM_CONV2 Eliminated
1 Los Angeles AM Crystal Y LA_AM100 Asset Listing for end users - by dept Reporting Session
1 Los Angeles AM SQR Report N LA_AMU10 PI Results - All Unders Eliminated - not used
1 Los Angeles AM SQR Process N LAAMDON LAAMDON - AM Mass Change Eliminated - not used
1 Los Angeles AP App. Engine Y LA_AP015 Voucher Update AP09009 - AP Voucher Interface
1 Los Angeles AP Crystal Y LA_CHKRG LA Payment Register AP09002 - AP Check Register
1 Los Angeles AP Crystal N LA_FS146 Point of Sale Audit (Fin Cashier Transaction Report) Reporting Session
Parking Audit Report (Fin Cashier Transaction
1 Los Angeles AP Crystal N LA_FS156 Report) Reporting Session
Payment handling code sync from
1 Los Angeles AP IB message Y LA_PYMNT_HNDL_FULLSYNC Payment Handling Code Sync FS TO HRSA
Ties HFRS Item Type with
Vendor and Voucher update with Payment Handling Payment Handling Code. Cross ref.
1 Los Angeles AP IB message Y LA_SF015_VCHR Code vendor_id and emplid FS99004 - Vendor/Voucher Interface
1 Los Angeles AP SQR Process N LAAP040 LAAP040 - SA Voucher Load IB
1 Los Angeles AP Crystal Y LAAP1090 Match Exception Report AP05003 - Match Exception Report
1 Los Angeles AP Crystal Y LAAPOUT Outstanding Check Listing Reporting Session
AR02001 - AR Aging by Fund and
1 Los Angeles AR Crystal Y LA_AR100 AR Aging Report Account Report
1 Los Angeles BI PROFORMA PROFORMA BI09001 - Billing Invoice
1 Los Angeles BI REPRINT_IVC REPRINT_IVC BI09001 - Billing Invoice
1 Los Angeles BI SNGL_ACTION SNGL_ACTION BI09001 - Billing Invoice
1 Los Angeles GL CSUFS150 CSU Bank Reformat EDI AP08001 - ACH Payment Processing
1 Los Angeles GL ECIN0001 Inbound EC Agent Third Party Interface Document
1 Los Angeles GL SQR Report N LA_9011 Load Acctg Entries SA 8/SF IB
1 Los Angeles GL Crystal Y LA_BDGT Budget Journal Detail Report GL99001 - Journal Entry Detail Report
1 Los Angeles GL App. Engine N LA_BNKREC1 (update) Bank Recon Update GL06002 Wells Fargo Bank Recon
1 Los Angeles GL App. Engine N LA_BNKREC2 (reset) Bank SetID Reset Eliminated - not used
1 Los Angeles GL SQR Report Y LA_DR84 (detail) Expenditure Detail Report Reporting Session
1 Los Angeles GL SQR Report Y LA_DR84F Expenditure Detail Report Reporting Session
GL02001 - Year End Encumbrance
1 Los Angeles GL SQR Report N LA_GL015 CSU Year End Obligations Report Accruals and Danglers
Revenue and Expense
1 Los Angeles GL Crystal Y LA_GL300 (UASLA_AA_JOURNAL_LINE) Eliminated - not used
1 Los Angeles GL Page N LA_GLMAP GL Crosswalk Eliminated - not used
1 Los Angeles GL App. Engine N LA_JRNL_IMP UASLA Flat File Journal Import GL05001 - Journal Upload Process
1 Los Angeles GL Page N LA_PAY_AGENCY Pay Agency Eliminated - not used
29adc070-b05f-449f-878a-517ba5a30fc2.xls 38 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
1 Los Angeles GL Page N LA_PAY_BENEFIT Pay Benefit Eliminated - not used
1 Los Angeles GL Page N LA_PAY_CLS_SER Pay Class Serial Eliminated - not used
1 Los Angeles GL App. Engine N LA_POS_UPDT POS Updates Eliminated - not used
1 Los Angeles GL SQR Report N LA_PYRL CSULA Payroll report IB
1 Los Angeles GL SQR Report Y LA_SR84 (summary) Expenditure Summary Report Reporting Session
1 Los Angeles GL SQR Report Y LA_SR84F Expenditure Detail Report Reporting Session
1 Los Angeles GL SQR Process N LAASI150 (for ASI) ASI Bank File Load Process Eliminated - not used
1 Los Angeles GL SQR Process Y LACSHNET Load Cashnet GL data FS99001 - General Ledger Interface
1 Los Angeles GL Crystal Y LAF3000- AutoRecon Input File Register Eliminated - not used
1 Los Angeles GL N LAGL020 UASLA Flt File Journal Import GL05001 - Journal Upload Process
1 Los Angeles GL SQR Process N LAGL020 LAGL020 - Payroll Load Eliminated - not used
1 Los Angeles GL SQR Process N LAUAS150 (for UAS) UAS Bank File Load Process Third Party Interface Document
1 Los Angeles GL SQR Process N LAUSU150 USU Bank File Load Process Third Party Interface Document
Provides departmental security for
1 Los Angeles Other IB message Y LA_H_DEPT_SEC_FULLSYNC Departmnet sync for payroll reports HRSA based on FS settings Third Party Interface Document
1 Los Angeles Other ?? LA_MOP_UAS_RX UASLA Processes Eliminated - not used
Passes EMPLID and Name from
1 Los Angeles Other IB message Y LA_PERSON_FULLSYNC Emplid Sync HRSA to PS; avoids extra info AP09001 - Open Item Key Setup
1 Los Angeles PO Crystal Y LA_PO100 Open Commitment Report Reporting Session
1 Los Angeles PO SQR Report Y LA_VCPN Print Portrait Invoices BI09001 - Billing Invoice
1 Los Angeles PO SQR Report Y LAPO001 LA - DVBE/SB/MB Report PO99007 - DVBE/SM/MB Report
The ID is used to populate the Dept ID and the
PO03001 - Business Ownership by Project Mgr on the CF. This is done for reporting.
1 Los Angeles PO SQR Report Y LAPO002 LA - Business Ownership Report Ethnicity, Race and Gender Report This is still an issue.
1 Los Angeles PO SQR Report Y LAPO003 LA - Recycled Products Report PO99009 - Recycled Products Report
Will not match up. Different fields. Report by
Department security. Will LA be able to keep since
this is Crystal and it was noted that customized
1 Los Angeles PO SQR Report Y LAPO004 LA - Contract Award Qtrly Rpt PO99010 - Contract Award Report reqporting stayed with campus
PO99011 - Purchase Order Print
1 Los Angeles PO SQR Report Y LAPO005 PO Dispatch/Print Format
1 Los Angeles PO SQR Report Y LAPO051 LA - Open PO Activity PO05001 - Open PO Activity Report
1 Los Angeles PO SQR Report Y LAPO052 LA - PO Activity Report PO05001 - Open PO Activity Report
PO99011 - Purchase Order Print
1 Los Angeles PO SQR Report PO_DISPATCH Dispatch Purchase Orders Format
PO99011 - Purchase Order Print
1 Los Angeles PO SQR Report PO_PRINT Purchase Orders Print Format
1 Los Angeles Security App. Engine Y LA_DEPT_SEC_SETUP Department Security Setup Third Party Interface Document
APY2021- (Crystal Reports)
1 Maritime AP Crystal MACHK1.rpt, MACPY1.rpt MA Custom AP Check Custom Check - Campus Specific AP06001 - AP Check Format
Req'd by Accounts Payable Dept.
to know the account distribution -
Req'd by the Accounts Payable
1 Maritime AP SQR MAAP001.SQR AP Invoice Distrib Report Manager Reporting Session
29adc070-b05f-449f-878a-517ba5a30fc2.xls 39 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
AP Check Register with Depts -
Req'd for Accounts Payable
1 Maritime AP SQR MAAP002.SQR AP Check Register with Depts Manager Reporting Session
MAIVCPN.SQR, mahdftp.sqc, Customized Customer Invoice -
masubp00.sqc, magetdb.sqc, Campus Specific - Campus Logo
1 Maritime AR SQR, PS Objects mafulp00.sqc, maprtp00.sqc AR Customer Invoice on it BI09001 - Billing Invoice
Change in Fund Balance - Req'd
1 Maritime GL SQR MAGL008.SQR Change in Fund Balance for budget officer Reporting Session
GL/SL Account by Fund (Detail) -
1 Maritime GL SQR MAGL011.SQR GL/SL Account by Fund (Detail) Req'd for budget officer Reporting Session
Sub-Ledger Rpt. (SCREEN 15) -
1 Maritime GL SQR MAGL020.SQR Sub-Ledger Rpt. (SCREEN 15) Req'd for budget officer Reporting Session
Detail Expenses by Dept. - Req'd
1 Maritime GL SQR MAGL021.SQR Detail Expenses by Department for budget officer Reporting Session
GL Actuals by Department Report
Req'd by Budget Officer and/or by
1 Maritime GL SQR MAGL026.SQR GL Actuals by Department individual departments Reporting Session
GL Budgets by Department Report
Req'd by Budget Officer and/or by
1 Maritime GL SQR MAGL027.SQR GL Budget Report individual departments Reporting Session
1 Maritime GL SQR MAGLCNI.SQR CASHNet GL Journal Interface file CashNet file upload to GL Journal FS99001 - General Ledger Interface
HR Accounting lines uploaded to
1 Maritime Other SQR LCD Process Export HR accounting lines GL IB
Month End Accounting Date
Update - Req'd by Accounts
1 Maritime Other App Engine MA_UPDACTDT - Application Engine Month End Accounting Date Update Manager Use PS Delivered Functionality
PO Detail Activity by Dept. - Req'd
1 Maritime PO SQR MAPO001.SQR PO Detail Activity By Dept for Purchasing Manager Reporting Session
1 Maritime PO SQR MAPO002.SQR Reports Open Encumbrances on Pos Open PO Encumbarance Report Reporting Session
Customized Purchase Order -
Campus Specific - with Campus PO99011 - Purchase Order Print
1 Maritime PO SQR POPO005.SQR MA Custom PO Format logo on it Format
This reports lists all Out of State vendors who have
reached a the threshold of $1500 YTD for state assists in reporting to Franchise
1 Monterey Bay AP SQR MBAP016 Accts. Payable Voucher YTD withholding purposes Tax Board Reporting Session
Used by the Account Payable
department as a listing of checks
Used by the Account Payable department as a listing produced with handlig code. This
of checks produced with handlig code. This report report facilitates the Bank
1 Monterey Bay AP Crystal MBAP007 AP Check Register Report facilitates the Bank reconciliation reconciliation AP09002 - AP Check Register
Provides Accounts Payable Detail
Provides Accounts Payable Detail with a with a Dept/Fund/Account/Journal
1 Monterey Bay AP SQR MBAP015 AP Detail Activity Dept/Fund/Account/Journal ID Sort and Total ID Sort and Total Reporting Session
1 Monterey Bay AP SQR MBAP027 AP Voided Payments List of Voided Checks Reporting Session
29adc070-b05f-449f-878a-517ba5a30fc2.xls 40 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
third party pro card vendor
interface to staging area to be
1 Monterey Bay AP MBPO21C
PS Pages and SQR Procard Interface Load Procard charges vouchered by A/P PO09001 - Procard
was used for Banner; now using
1 Monterey Bay AP NOT APPLICABLE Student Financials input Process Student Financial info into AP for processing delivered IB Eliminated - Not Used
assists in reporting to Franchise
1 Monterey Bay AP Crystal MBAP024 Vendor Use Tax Monthly listing of the Use Tax posted on the voucher Tax Board Reporting Session
created to load only certain fields
(name, EmplID) from the HR
PERSONAL_DATA table. Used to
populate DeptID & Project
Load Personnel Data from HR (may not Process to load Personnal Data from HR to Personal managers, as well as travel & AP09001 - Open Item Key Setup
1 Monterey Bay AP SQR MBINT002 need in 9.0) Data Table in Finance salary advance open item values Still an issue.
1 Monterey Bay AP NOT APPLICABLE Personnel Information Load Process to load Pesonal Data from HRSA not implemented w/ 9.0 Eliminated - Not Used
formats ADP file extract into
Process appends Header Record to ADP Payroll file delivered CSU baseline upload
1 Monterey Bay GL SQR MBINT001 Append Header Record (ADP) in line with CSU format for upload. formate Third Party Interface Document
1 Monterey Bay GL CSUGL025
SQR (CMS Baseline) Bank Recon Load Wells Fargo Bank recon File not a CSUMB mod GL06002 - Wells Fargo Bank Recon
1 Monterey Bay GL NOT APPLICABLE Budget Journal Entry Upload Upload Budget Journal Entry from Excel eliminated in 9.0 upgrade Eliminated - Not Used
Process used to upload non student deposits from
1 Monterey Bay GL CSUFS140
Delivered SQR(Load Interface) Cashnet Interface Cashnet systemt not a CSUMB mod FS99001 - General Ledger Interface
streamline the 'charging back' back
of centrally made charges, such as
postage. End users utilize a 7-digit
Mod with multiple processes; object defines a 7- code that translates to chart field
character code default CF values for charging back string, but the 7-digit code is static,
1 Monterey Bay GL MBCBGL02
PS Pages and SQR Chargeback Mod central transactions such as postage. only the translation is updated GL09003 - Charge Back
created to centrally capture
Pages to centralizes spending authority by DeptId, signature authority by DeptID;
includes field for capturing dollar limits & comments if includes dollar limit & comment
1 Monterey Bay GL MB_FISCAL_AUTH (Page)
PS Pages & Peoplecode Fiscal Authority Mod applicable. section per presidents directive GL09001 - Delegation of Authority
Process used to upload Payroll Transactions from
1 Monterey Bay GL CSUFS140
Delivered SQR(Load Interface)) Foundation Payroll Input ADP system for Foundation Businees Unit not a CSUMB mod Third Party Interface Document
This will be used for doing the bank
GL Bank Recon (GL Summary Check This will be used for doing the bank reconcilation to reconcilation to get list of
1 Monterey Bay GL Crystal MBGL006 Reconcile) get list of Outstanding checks. Outstanding checks. Reporting Session
Enable campus departments to
review the detail ledger activity and
helps departments to identify the
Enable campus departments to review the detail source of the accounting entries.
ledger activity and helps departments to identify the The report displays details such as
source of the accounting entries. The report displays requisition, PO and Voucher
details such as requisition, PO and Voucher numbers numbers along with the Journal ID
1 Monterey Bay GL SQR MBGL100 GL Deparment Activity along with the Journal ID information. information. Reporting Session
29adc070-b05f-449f-878a-517ba5a30fc2.xls 41 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Enable campus departments to
Enable campus departments to review the detail review the detail ledger activity for
1 Monterey Bay GL SQR MBGL101 GL Detail Activity ledger activity for balance sheet accounts. balance sheet accounts. Reporting Session
NOT They do Physical Inventory for Non Cap (under
1 Monterey Bay GL APPLICABLE GL Journal Entry Upload Upload GL Journal Entry from Excel eliminated in 9.0 upgrade Eliminated - Not Used $5000.00).
Two processes for creating nVision
scopes and report requests for
dynamically building layouts so end
users don't have to define scopes
Processes to create nVision Dynamic Two processes for creating nVision scopes and report & layouts. Process is run when
1 Monterey Bay GL SQR MBNVS01,MBNVS02 Layouts( RUN NVS/NVS2) requests for dynamically building layouts activity hits against a new chartfield Reporting Session
To Process Payroll transactions using LCD
1 Monterey Bay GL Integration Broker State Payroll Input functionality in HRSA and feeding to Finance GL not a CSUMB mod IB
To upload telecom charges using a CSU Journal
1 Monterey Bay GL Delivered SQR CSUGL001 Telecom File Upload process not a CSUMB mod GL09003 - Charge Back
To upload electronic market place transactions like
special events registration fees, Athletic Mechandise
1 Monterey Bay GL CSUFS140
Delivered SQR(Load Interface)) Touchnet Interface sale, etc.. not a CSUMB mod FS99001 - General Ledger Interface
To upload Student Financial Accouting Lines like
Student Fees, Student Registration, etc to GL in
1 Monterey Bay GL Integration Broker Student Financials input Finance. not a CSUMB mod IB
there is an operational need on our
campus to capture organization
structure in reporting. This process
was created to capture a flat
version of the DeptID
organizational tree. Differs from
Reporting Solution in that it retains
the effective date of the tree,
Process used to update custom MB_DEPT_ROLLUP allowing for historical reporting.
table for DeptID tree reporting structure; retains (We have the same process in
1 Monterey Bay Other SQR MBBD001 Load Dept Rollup Table effective date of tree CMS Finance & HR) nVision Reporting
Process to FTP files to production
1 Monterey Bay Other MB_LOAD_FILE (Page)
PS page & Peoplecode Load Flatfile Process to FTP files to production server server GL09002 - FTP
A modification has been made to
Peoplesoft delivered report to
A modification has been made to Peoplesoft delivered inlcude logos and Footer
report to inlcude logos and Footer Information for Information for each of three PO99011 - Purchase Order Print
1 Monterey Bay PO SQR POPO005 Dispatch Purchase Order each of three operational business units. operational business units. Format
29adc070-b05f-449f-878a-517ba5a30fc2.xls 42 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Lists all Open PO's. Is used by the
Purchasing/Accounts Payable
Lists all Open PO's. Is used by the departments as an audit tool for
Purchasing/Accounts Payable departments as an reconciling open PO's. Differs from
audit tool for reconciling open PO's. Differs from CSU- CSU-Open PO Activity report in
Open PO Activity report in that it subtotals at chart that it subtotals at chart field
field information, which is needed for reconciliation information, which is needed for
1 Monterey Bay PO SQR MBPO100 PO Open Commitment purposes. reconciliation purposes. Reporting Session
Multiple processes allowing views to end user to provide end users standard way of
reconcile monthly vendor statements; loads vendor reconciling pro card statements
1 Monterey Bay PO MBPO21A
PS pages and SQR ProCard Mod file & processes through AP as vouchers independent of vendor PO09001 - Procard
to capture logos and chartfield
distribution information on
A modification has been made to Peoplesoft delivered requisition report for manual
report to include chartfield distribution on the approval routing for each of three
1 Monterey Bay PO SQR PORQ010 Requisition Print Requisition Print report operational business units PO09004 - Requisition Form
AM delivered comes with workflow activated. This This mod prevents the error from
1 Northridge AM PeopleCode AM workflow inactivation campus does not utilize this functionality showing in workflow. Eliminated - CMS Supported
AM depreciation - Array size Eliminates errors when processing
1 Northridge AM SQR amdpstup.sqc increate size to 5000 and the array size is exceeded Should be fixed in current baseline.
Eliminates errors while processing
1 Northridge AM SQR Calendar Array ampi1000.SQR - Increase Calendar array to 5000 when the array size is exceeded Should be fixed in current baseline.
Receipt delivered crystal report, including requestor Provides Receiving with detail
name, phone number & dept needed to assist with shipping and PO09003 - Receipt Delivery Detail
1 Northridge AM CRYSTAL NR_3893411_WMH delivery of goods. Report
AM utilizes the Palm scanner to scan assets during
the physical inventory processing and upload the CSV
file from the scanner and insert a new effective dated
row in the Asset_Comments table with the comment
1 Northridge AM SQR NRAMSCAN.SQR that it's been inventoried and the inventory date. Third Party Interface Document
Procurement Budgetary Activity Report Ability to print PO due date &
1 Northridge AM SQR NRS8001 vendor name on report Reporting Session
Provides two books to be used.
One for capitalized and the other
for non-capitalized. Allows us the
ability to track both cap and non-
1 Northridge AM PeopleCode Physical Inventory Modification to change default Book cap assets for inventory purposes. Eliminated - Not Used
change book to "NONCAP" based on "NONCAP" Allows both types of assets, CAP &
Physical inventory SQR changes word in PI_NAME NONCAP to be pulled to Physical
1 Northridge AM SQR (ampi1000.SQR) Inventory. Eliminated - Not Used
29adc070-b05f-449f-878a-517ba5a30fc2.xls 43 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Needed to present CSUN logo and
boiler plate language on checks.
Also provides the bank specific
1 Northridge AP CRYSTAL AP Crystal Check Crystal template for AP checks check alignment AP06001 - AP Check Format
Provides CSUN logo on a file copy
1 Northridge AP CRYSTAL AP Crystal File Copy Form Crystal template for AP check file copy of check Eliminated
Provide electronic funds transfer
for all employee payments. Allow
for faster processing of employee
1 Northridge AP IB/SQR Electronic Employee Payments (ACH) Electronic processing of employee reimbursements payments. AP08001 - ACH Payment Processing
Provides ability to be able to group
vendors with foreign address so
1 Northridge AP APP ENGINE Foreign Address for Vendors A/E mod to update foreign address for vendors correct postage can be applied. Eliminated
1 Northridge AP SQR GE Capital to AP ProCard load Provides Procard file upload. PO09001 - Procard
Assign "FR" to PYMNT_GRP_CD with foreign Provides ability to be able to group
address student with foreign address so
1 Northridge AP APP ENGINE Identify Foreign address students correct postage can be applied. Eliminated
Records, Provides voucher creation for
Components, telephone invoice with expenses.
Pages, Issues payment to vendor and
PeopleCode, Upload monthly telephone charges to AP, distribute distributes expenses to campus
1 Northridge AP SQR Local telephone billing system to AP charges and generate payment to vendor. departments. AP09009 - AP Voucher Interface
Job
Definition/Proc To prevent jobs from running into
ess each other & provide the ability to
Scheduler/SQ Nightly AM & AP Job creation have these job run in the correct
1 Northridge AP R Nightly Job creation order Job Scheduling
Automate the charges from Boise
Boise charges to AP to AP for generating check to
1 Northridge AP SQR NRBOISE vendor AP09009 - AP Voucher Interface
Automate the charges from
Procard charges to AP Procard to AP for generating check
1 Northridge AP SQR NRPROCRD to vendor PO09001 - Procard
Automate the charges from Office
Max to AP for generating check to AP09009 - AP Voucher Interface or
1 Northridge AP SQR Office Max to AP Upload monthly detailed statements into AP vendor Third Party Interface Document
Ability to suppress the SSN data so
1 Northridge AP Record(View) PS_NR_VENDOR_1_VW Vendor security view the end-users could not query Security Related
1 Northridge AP IB HCM/LCD to GL LCD Acctng lines to GL Export HR Acctg lines to GL IB
Records,
Components,
Pages,
PeopleCode, Provide a low overhead for University Receivables & A simplified version of AR/BI to
1 Northridge AR SQR AR/BI Billing for our low volume activity only handle the low volume. BI09003 - Automatic Invoicing
29adc070-b05f-449f-878a-517ba5a30fc2.xls 44 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Allows Accounting Staff the ability
Configuration, to process journal entries real-time
1 Northridge GL PeopleCode Journal approval workflow Route journal entries for approval using workflow approval. Eliminated
Prevents encumbrance journals
from being re-budget checked &
Change journal status to posted posted multiple times to Ledger
1 Northridge GL SQR Journal status update for encumbrance KK. Data Integrity
Provide standard mechanism for
both small and large journal entries
from the Accounting Staff and end-
SQR, APP users on campus to be processed
1 Northridge GL ENGINE, IB Journal upload Journal upload template in the GL. GL05001 - Journal Upload Process
Ability to provide only 1 level of
approval, (Requestor & Mgr)
without using $ amt. Delivered is
Limit workflow to 1 level of approval based on $ amt & then two levels
1 Northridge GL PeopleCode Journal workflow of approval. Eliminated
Accounting Date Run Control Update A nightly process to validate dates
Process to keep all finance applications in sync until on transactions and update from a
1 Northridge GL SQR NRRCUPDT the current acctg period is closed closed period to an open period. Use PS Delivered Functionality
1 Northridge GL Record(View) PS_COMMENTS_TBL view Provide user access to long descr Shows the long description on GL. Reporting Session
Provides ability to split non-student
Process to bring non-student information to Finance related cash receipts from student
1 Northridge Other SQR Cashnet GL Interface GL and feed directly to GL. FS99001 - General Ledger Interface
a paperless way for end-users to
request campus services on-line
with up-front editing, limits
chartfields to only those that are
valid for this purpose, prompt
filtering, data validation, and
workflow approvals for both state
and auxiliary organization funding.
Provides automatic workflow to
Records, AR/BI for Auxiliary invoicing and
Components, processing to GL. This eliminates
Pages, duplicate entry by the requestors
PeopleCode, Provide secure & easy user interface for departments and Campus Service Providers and
1 Northridge Other SQR Chargebacks to request campus services and encumber funds. Auxiliary Organizations. GL09003 - Charge Back
29adc070-b05f-449f-878a-517ba5a30fc2.xls 45 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
a paperless way for end-users to
run management and payroll
reports on-demand with drill-down
capabilities. Report requests are
Components/P modified to prevent users' error
ages/PeopleC Customized web based nVision Provide a simple interface for end-users to request and avoid conflicts when utilizing
1 Northridge Other ode reporting and run on-demand financial reports the same report requests. Reporting Session
a single inquiry page that provides
the end-users with their budget, po,
req, revenues/expense information
along with their budget balance
available for any chartfield
combination, including tree roll-ups.
Provides sorting and drill-down
functionality and the ability to track
all activity against req's and po's.
Records, Also including check and voucher
Components, information. Along with the ability
Pages, GL & Purchasing reporting tables & to look at open and or closed
PeopleCode, inquiry pages populated with baseline Provide self service & inquiry access to department purchase orders by department or
1 Northridge Other SQR financial information end-users vendor. Reporting Session
a paperless way to provide the end-
users with both monthly detailed
payroll information and year-to-
date payroll information that reports
all retro activity to the correct pay
period. This data is stored in a
columnar format by pay period to
Ability to provide detail payroll reporting information to enable multi-year comparing of
1 Northridge Other Records, SQR HR payroll reporting table department end-users payroll expenses by month or year. Reporting Session
Updates assets that have been
inventoried from a flat file to add a
comment to the assets comment
field. The comment will then show
Provide ability to load inventory comments from excel the date the asset has been
1 Northridge Other SQR Load comments for inventory to assets files inventoried. Third Party Interface Document
Provide automatic way to maintain
Update Email Lists email distribution list to notify users
1 Northridge Other SQR NREMAIL1 Automate maintain notification email lists by various role associations. Third Party Interface Document
29adc070-b05f-449f-878a-517ba5a30fc2.xls 46 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Automatically creates and
maintains "private" report requests
nVision Report Request Sync based on master templates for on-
1 Northridge Other SQR NRNVSYNC Build & maintain report requests for end-users. demand end-user nVision reporting Reporting Session
Provides validation of Personal
Retrieve personal data from HR to populate Personal Data info across applications.
Data Table in Finance Expanded standard personal data
Retrieve personal data from HR to populate requestor sync to include requestor table for
1 Northridge Other SQR NRPERSYN name, phone #, dept name for the Oper ID creation. procurement. Security Related
PO Recon Incremental Refresh PO/AP/REQ data load to data
Provide ability for end-users to track status & activity warehouse that populates reporting PO09005 - Req to Check End User what will file format look like? Cashnet generates
1 Northridge Other SQR NRRECON2 against their reqs & po balances and inquiry tables. Notification file at the end of the day and they FTP.
GL Recon Incremental Refresh GL Data load to data warehouse
Ability to enable workflow without the need of that populates reporting and inquiry
1 Northridge Other SQR NRRECON3 workflow administrator tables. Third Party Interface Document
Interface between on-line
requisition module and baseline
1 Northridge Other APP ENGINE NRRQLOAD Requisition Load Finance. Requisition Common Door
Automate process to lock accounts
for those employee ID's that do not
have an active job record or
1 Northridge Other SQR NRSEC001 Operator sync terminated. Security Related
Provides approval levels in
functions like PO, REQ and
Chargebacks. Creates dynamic
workflow tables based on
departmental security trees.
Eliminates need for workflow
administration or additional
CSUN Workflow Synch workflow setup. Also provides for
Ability to enable workflow without the need of automatic approval delegation if
1 Northridge Other SQR NRWFSYNC workflow administrator primary approver is not available. Eliminated
a paperless way using a one page
on-line form for end-users with up-
front editing, limited to only
chartfields that are valid for this
Records, purpose, prompt filtering, data
Components, validation, and workflow approvals.
Pages, This eliminates duplicate entry by
PeopleCode, Provide secure & easy user interface for departments the requestors and the Budget GL05001 - Journal Upload Process or
1 Northridge Other SQR On-line Budget (OLB) to transfer budgets Office. Use PS Delivered Functionality
29adc070-b05f-449f-878a-517ba5a30fc2.xls 47 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
a paperless way using a one page
on-line form for end-users with up-
front editing, limits chartfields to
only those that are valid for this
purpose, prompt filtering, data
validation, and workflow approvals.
This eliminates duplicate entry by
the requestors and the Buyers.
Records, Enables the Buyers to use the build
Components, copy process to create po's from
Pages, Provide secure & easy interface for departments to user created req's. Also generates
PeopleCode, request and approve requisitions & electronically pre-encumbrance entries using
1 Northridge Other SQR On-line Requisition transmit to Purchasing delivered requisition logic. Third Party Interface Document
Ability to have current valid
chartfields in the procard system.
Provide accurate chartfield information to the Procard Chartfields are limited to only those
1 Northridge Other SQR Procard Chartfield Sync vendor valid for this purpose. PO09001 - Procard
Supports multiple AP & PO
business units and prevents users
Activate Row Level Security at BU and setid level from creating purchase orders and
Prevents users from creating vouchers in the wrong vouchers in the wrong business
1 Northridge Other Configuration Row Level Security BU unit. Security Related
Provide row-level security for
Foundational modification to provide row-level update access to Dept ID's for on-
Configuration, department security to all LAD modules and enable line req's, chargebacks, on-line
1 Northridge Other Records, SQR Row level security workflow budgets and some nVision reports. Security Related
Maps charges by phone number
and call types to Finance
chartfields from our campus VOIP
system. Generates voucher feed
to AP to issue payment to vendors
Components/P Map phone call data to finance chartfields and post and distribute expenses to
1 Northridge Other ages/SQR Telephone charge interface expenses to AP and create vendor payment departments. AP09009 - AP Voucher Interface
Provides requestor name, dept and
phone number which allows
Receiving the necessary PO09003 - Receipt Delivery Detail
1 Northridge PO CRYSTAL Receiver delivery report POY5030-.RPT - Custom Receiver delivery report information for delivery needs. Report
CSUN PO layout for printing Needed to present purchase order
Provide CSUN logos, layout & text on Purchase with CSUN logo and boiler plate PO99011 - Purchase Order Print
1 Northridge PO SQR POPO005.SQR Orders language. Format
Needed to present requisition with
CSUN Req layout for printing CSUN logo and boiler plate
1 Northridge PO SQR porq010.SQR Provide CSUN logos, layout & text on Requisitions language. PO09004 - Requisition Form
29adc070-b05f-449f-878a-517ba5a30fc2.xls 48 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Adds header to report to simplify
1 Northridge PO SQR Procurement Budgetary Activity Report nrs8001.SQR - selection criteria modification analyses. Reporting Session
View of PS_COMMENTS_TBL Ability to identify po lines that need
1 Northridge PUR Record(View) PS_COMMENTS_TBL View consolidation for assets Reporting Session
Prevents other areas (Student,
Library and NRCMP) from
accessing or processing
transactions outside of their own
1 Northridge Security Configuration Business Unit Security Secure user's access to business unit business unit. Security Related
Update User Profiles and Operator Preferences for
users in local
campus web requisition interface that are requestors Automatically maintains requestor
1 Northridge Security SQR NROPRSYN.SQR or approvers. and approver tables for workflow. Security Related
1 Pomona AM CPP AM Physical Inventory Reconciliation Report POMAM002 CPP AM Physical Inventory Reconciliation Report Third Party Interface Document
1 Pomona AM CPP Missing Property Report POMAM003 CPP Missing Property Report Third Party Interface Document
1 Pomona AM CPP Physical Inventory Report POMAM004 CPP Physical Inventory Report AM09001 - Physical Inventory Report
1 Pomona AM CPP Property Survey Report POMAM005 CPP Property Survey Report AM09003 - Property Survey Report
1 Pomona AP System Check with CPP Logo CHECK1 System Check with CPP Logo AP06001 - AP Check Format
1 Pomona AP System Check with CPP Logo CHECK5 System Check with CPP Logo AP06001 - AP Check Format
1 Pomona AP System Check File Copy with CPP Logo COPY1 System Check File Copy with CPP Logo Eliminated
1 Pomona AP System Check File Copy with CPP Logo COPY5 System Check File Copy with CPP Logo Eliminated
1 Pomona AP System Check with CPP Logo CSUCH1 System Check with CPP Logo AP06001 - AP Check Format
1 Pomona AP System Check File Copy with CPP Logo CSUCP1 System Check File Copy with CPP Logo Eliminated
1 Pomona AP CPP Check Register Report POMAPY01 CPP Check Register Report AP09002 - AP Check Register
Pomona CPP Library Invoice Process Step 1 POMAP001 CPP Library Invoice Process Step 1 AP09009 - AP Voucher Interface/Third
1 AP Party Interface Document
Pomona CPP Library Invoice Process Step 2 POMAP002 CPP Library Invoice Process Step 2 AP09009 - AP Voucher Interface/Third
1 AP Party Interface Document
1 Pomona PO Open Commitment Report POMPO002 Open Commitment Report Reporting Session
Pomona System PO with CPP Logo POPO005 System PO with CPP Logo PO99011 - Purchase Order Print
1 PO Format
Pomona This is a bolt on that allows none-core Finance users Finance Web Tools (FWT) This is a bolt on that allows none-core Finance users
to access and view financial data (eg. For their to access and view financial data (eg. For their
departments or divisions). departments or divisions).
1 Security Security Related
1 Pomona Security Password Last Update Account Lock POMFN501 Password Last Update Account Lock Security Related
Campus wanted a customized of
Campus Asset Inventory Report. The SQR name is version of the AM Inventory
1 Sacramento AM SQR, Pages SAC9_REPORTS AM Inventory Report SACAMPYI .SQR. Report. AM09001 - Physical Inventory Report
Export Miscelleneous Checks for use with
CheckScribe - this is used so Sacramento State can Create interface file that is used by
export checks to the CheckScribe software that we camus CheckScribe program to
1 Sacramento AP SQR, Pages SAC9_SACAP910 Export Misc Checks for CheckScribe use to print checks. SQR name is SACAP911. print Misc checks. Eliminated
29adc070-b05f-449f-878a-517ba5a30fc2.xls 49 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Export SA Checks from AP to Check Printing
Software - this is used so Sacramento State can Create interface file that is used by
export checks to the CheckScribe software that we camus CheckScribe program to
1 Sacramento AP SQR, Pages SAC9_SACAP910 Export SA Checks for CheckScribe use to print checks. SQR name is SACAP912. print SA checks. Eliminated
Export Vendor Checks from AP to Check Printing
Software - this is used so Sacramento State can Create interface file that is used by
export checks to the CheckScribe software that we camus CheckScribe program to
1 Sacramento AP SQR, Pages SAC9_SACAP910 Export Vendor Checks for CheckScribe use to print checks. SQR name is SACAP910. print Vendor checks. Eliminated
Since going live with 9.0 we are
Upload Monthly ProCard transactions into AP - this is now using same version as
a Custom Object we use for ProCard to AP interface. Chancellor's Office (worked with
1 Sacramento AP SAC9_PO_PROCARD
SQR, PeopleCode, Pages ProCard to AP The SQR name is SACPO21C.SQR. Elaine Kist on this). PO09001 - Procard
This process allows us to import
Process Student Financial Vendors into AP - import Student Vendor into the GL Vendor
all students into GL AP Vendor file. For use with table. We modified CSUAP019 to
manual refunds. The SQR name is SACAP101 use DBLINK rather than the text FS99004 - Vendor and Voucher
1 Sacramento AP SQR, Pages SAC9_SACAP100 Student Financials Vendors to AP .SQR. file. Interface
Campus has a process to extract Monthly
Reimbursed Activity GL Transactions and import This process was created to save
AR Extract Reimburse Acitity them into the AR Billing System via the Billing the AR Dept having to manually
SQL to extractd transactions from GL to import into Transacdtion and then Import into AR Interface option. This then automtically generate Bills created invoices for Reimbursed
1 Sacramento AR SQL AR Billing. Billing for Reimbursed Acitity. Activity bills. BI09003 - Automatic Invoicing
Campus custom AR Invoice Print - Sac State has
modified the printed AR Invoice with a customized
look preferred by our Accounts Receivable area. Campus AR dept wanted many
SQR/SQC names modificied are biivcpn.SQR, changes to baseline AR Invoice
baseline SQR mod - installed into campus SQR bifulp00.sqc, bihdftp.sqc, biprtp00.sqc, including changing to the campus
1 Sacramento AR SQR directory AR Invoice Print bisubp00.sqc, and bisubp01.sqc. logo JPG file. BI09001 - Billing Invoice
Campus AR Outstanding Invoice Report - we have
created a customized look preferred by our Accounts Campus wanted a customized of
Receivable area. The SQR namie is SACAR023 version of the AR Outstanding AR02001 - AR Aging by Fund and
1 Sacramento AR SQR, Pages SAC9_SACAR023 AR Outstanding Invoice Report .SQR invoices. Account Report
Extract info from AR/Billing to build CashNet
Customers and Balances - we extract daily balances This SQL is used to produce a file
SQL to extract AR/Billing outstanding balance into from AR/Billing and use this file to create an import of that is imported into CashNet so
1 Sacramento AR SQL text file AR/Billing to CashNet AR/Billing Balances into CashNet. AR Invoices can be receipted. Third Party Interface Document
Campus Reimbursed Activity Report -- this is actually
a process to extract data from GL to assist with Campus wanted a customized of
automatically creating AR Invoices. The SQR name version of the Reimbursed Acitity
1 Sacramento AR SQR, Pages SAC9_REPORTS Reimbursed Activity is SACGL007 .SQR. Report. BI09003 - Automatic Invoicing
29adc070-b05f-449f-878a-517ba5a30fc2.xls 50 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Used to create Monthly Campus Chargeback Campus developed this Cost
transaction journals --- bolt-on has both on-line and Recovery Sytem to handle various
SQR's. Sac State has developed an application to file format from a wide variety of
handle a wide variety of campus chargebacks. This chargebacks across the campus.
version of CCR is very adaptable to can easily accept This system allows file import file
a variety of files from campus charges due to a user field defintions from the various
definable input file format. The name of the SQR 's cost centers to be easily changed.
are SACGL30A.SQR, SACGL30B.SQR, System is designed to be run Campus will need to use combo edits or create
Campus Cost Recovery (CCR) Bolt-on SACGL30C.SQR, SACGL30D.SQR, monthly and produced Journals for additional Business Processes to address these
1 Sacramento GL SAC9_COST_RECOVERY
SQR, PeopleCode, Pages Application SACGL303.SQR. each cost center. GL09003 - Charge Back types of errors.
This process takes the daily
Process to Update and Load CashNet Daily Journal - CashNet receipts and consildates
Sac State has created a process to convert the daily them by ChartString and creates
receipts from CashNet into a Journal Header and offset entries. Also handles
Detail including the offset accounting entries that can creating special special entries for
be imported as a GL Journal. The SQR name is OneCard Payments and for Open
1 Sacramento GL SQR, Pages SAC9_CCC_JRNL Create CashNet Journals SACGL915 .SQR. Items. FS99001 - General Ledger Interface
Campus Federal Work Study Report - Campus has
developed a customized report that is used by Accounting Office uses this report
Accounting Services. The SQR name is to assist them with Federal Work
1 Sacramento GL SQR, Pages SAC9_FIN028_COMR Federal Work Study Report SACGL008.SQR. Study Reporting needs. Reporting Session
On-line access to FTP files - Allows campus Allows users to control when they
1 Sacramento GL SAC9_LOAD_FILE
Pages, PeopleCode File FTP accounting users to upload files to FTP server. FTP files to the FTP server. GL09002 - FTP
Extract info from GL Open Items to build CashNet
Customers and Balances - this extract builds a file of This SQL is used to produce a file
SQL to extract GL Open Item debt balances into text Open Item Balances tha can be imported into that is imported into CashNet so
1 Sacramento GL SQL file GL (Open Items) to CashNet CashNet. Open Item debts can be receipted. Third Party Interface Document
Update GL ChartFields in HR/SA - this process keeps
the chartfields between CMS Financials and CMS Need to keep ChartFields insysnc
1 Sacramento GL Integration Brkr n/a GL ChartFields to HR/SA HR/SA synchronized. between GL and HR/SA. IB
Extract GL information (ChartString and other
transactional data) for use with Campus Data Used to create campus GL data
1 Sacramento GL SQL n/a GL to Campus Data Warehouse Warehouse warehouse. Third Party Interface Document
Retrieve User Security Information from Finance (GL) Used to udpate campus custom
for use with Security Authorization Campus bolt-on in object for tracking Security
1 Sacramento GL Integration Brkr n/a GL to HR HR Authorization. Security Related
Update Journal ID on SF Accounting Line from GL -
this process allows the Journal ID from GL to be
passed back to the SF Accounting Line - this greatly
assists Accounting Service users with reconciliation Need to update SF Accounting
1 Sacramento GL Integration Brkr n/a GL to SF and troubleshooting issues. Lines with Journal ID from GL. IB
Must feed LCD Jounral from HR
1 Sacramento GL Integration Brkr n/a HR to GL HR LCD Journal Feed to GL into GL. IB
29adc070-b05f-449f-878a-517ba5a30fc2.xls 51 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Update Personel Data table from HR/SA to GL - this
process keeps the Personel Data table from HR/SA Must keep Personel data insync
1 Sacramento GL Integration Brkr n/a HR/SA Personel Data to GL synchroized with the Personel Data table in GL between HR/SA and GL. AP09001 - Open Item Key Setup
Campus customized Journal
Upload allowing entry of many
Journal fields such as Journal ID,
Process to Upload Journals which allow flexibility on Open Item Key, Scenario that are
Journal ID, runs some validation and combo editing. not avialable on the CSU Journal
1 Sacramento GL SQR, Pages SAC9FS_GE_UP Journal Upload with Edits The SQR name is SACGL031 .SQR. Upload process. GL05001 - Journal Upload Process
Allows for integration of campus
LDAP and CAS User Logins for Finance - this is used user logins with campus LDAP and
1 Sacramento GL SAC9_FIN021C_COMR
Business Interlink, PeopleCode LDAP and CAS for Finance to create single user signon process. CAS for single sign-on. Security Related
Process to Update accounting dates at Month End to Process is used to roll accounting
new month, so entries do NOT go back to closed dates to allow for proper
months – since go-live with 9.0 we are now using a processing of items in the new
1 Sacramento GL SAC9_FS_UPDATE_ACCTG_DATES
Pages, App Engine Monthly Date Roll version of this program proided by SLO. month. Use PS Delivered Functionality
Campus Open Item Aged Report – Campus has
developed a customized report that is used by
Accounting Services to reconcile outstanding travel
and salary advances. This report provides aging
information from date of check(salary) OR end date of Campus wanted a customized of
trip (travel).Services. The SQR name is SACAP921 version of the GL Open Items
1 Sacramento GL SQR, Pages SAC9_FIN022_COMR Open Item Aged Report .SQR. Report. AP05004 - AP Open Items Listing
Campus Procurement Card Bolt-On --- bolt-on has Since going live with 9.0 we are
both on-line and SQR's -- this is a Custom Object we now using same version as
use for ProCard to AP interface. The SQR names Chancellor's Office (worked with
1 Sacramento GL SAC9_PO_PROCARD
SQR, PeopleCode, Pages ProCard Campus Bolt-on are SACPO21A.SQR and SACPO21C.SQR. Elaine Kist on this). PO09001 - Procard
Campus Signature Authoritty Bolt-On --- bolt-on has Campus uses this bolt-on to track
both on-line pages that the campus has implemented who is authorized to sign
to track who is able to sign signnatures for documents signatures on qualifited documents
1 Sacramento GL SAC9_SIGN_AUTH
PeopleCode, Pages Signature Authority Bolt-On Application used on campus. for the campus. GL09001 - Delegation of Authority
SF Journal Feed to GL --- this is an IB process that Need to feed transcation from SF
1 Sacramento GL Integration Brkr n/a Student Financials to GL feeds the student financials journals to the GL. to GL. IB
29adc070-b05f-449f-878a-517ba5a30fc2.xls 52 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
SQR Process to Update Accounting Line data. The
SQR name is SACPO21C.SQR. - this process is
used to updated accounting line data for claims.
UPDATE PS_VCHR_ACCTG_LINE
SET DEPTID = ' ', PROGRAM_CODE = ' ',
CLASS_FLD = ' '
WHERE (ACCOUNT LIKE '1%' OR
ACCOUNT LIKE '2%' OR
ACCOUNT LIKE '3%' OR
ACCOUNT LIKE '4%' ) AND
JOURNAL_ID = ' ' AND
GL_DISTRIB_STATUS = 'N' AND This process ensures that fields on
APPL_JRNL_ID IN ('CLAIM', 'CLMRECON', the Voucher Accounting Line table
1 Sacramento GL SQR, Pages SAC9_SACAP900 Update Accounting Line - Claim 'CNCLCLM') have correct entries. AP99017 - Claims Schedule
Import CCR transaction files from varoius sources Campus developed this Cost
and feed to GL - Sac State has developed an Recovery Sytem to handle various
application to handle a wide variety of campus file format from a wide variety of
chargebacks. This version of CCR is very adaptable chargebacks across the campus.
Various Campus transactions files must to can easily accept a variety of files from campus This process allows file import file
be imported into the Campus Cost charges due to a user definable input file format. This field defintions from the various
1 Sacramento GL SQR, Pages SAC9_COST_RECOVERY Recoery (CCR) bolt-on SQR name is SACGL30A.SQR. cost centers to be easily changed. GL09003 - Charge Back
GL09003 - Charge Back
Campus Visistor Parking Permits Bolt-On --- bolt-on The chargeback part will work for this
has both on-line and SQR's --- Sac State has but the "meat" of this mod allows
developed an application to handle allow campus user departments to request on-line parking
to request Visition Parking permits and for the Parking permits and the parking office to
Offices to authorized and print these permits. It also Visitor Parking permits are used for authorize and print. This is for visitor
is integrated with the campus chargeback system a wide variety of parking needs on- parking-since we are now charging
(CCR) to handle charging money for certain permit campus where regular parking either the visitor or the department for
1 Sacramento GL SAC9_VISIITOR_PARKING, SAC9_VP_UDPATE3
SQR, PeopleCode, Pages Visitor Parking Bolt-On Application types. permits cannot be used. these.
Campus PO Detail Activity Report - Campus has
developed a customized report that is used to PO
detail activity. There are 2 SQR's used: Campus wanted a customized of
SACPO001.SQR (Open PO Activity Report) and version of the PO Detail Acitity
1 Sacramento PO SAC9_OPEN_PO_RUNCONTROL PO Detail Activity Report SACPO002.SQR (PO Activity Report). Report. PO05001 - Open PO Activity Report
Campus wanted a customized of
version of the PO Open
Campus PO Open Encumbrances Dept Report - Encumbrances by Dept Report
PO Open Encumbrance List by Dept Campus has developed a customized report that is (phasing out -- going to use
1 Sacramento PO SAC9_ENC_REPORT Report used to show po open encumbrances. campus data warehouse reporting). Reporting Session
29adc070-b05f-449f-878a-517ba5a30fc2.xls 53 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Used for payment handling code. Broni:
Campus PO dept wanted many proposed solution not adequate. Delivered
Campus custom PO Print - Sac State has modified changes to baseline PO print solution loads from a file into FIN. Our process
baseline SQR mod - installed into campus SQR the printed PO ith a customized look preferred by our including changing to the campus PO99011 - Purchase Order Print takes messages from HR that are loaded to a
1 Sacramento PO SQR directory PO Print Purchasing area. SQR name is POPO005.SQR. logo JPG file. Format temp table, then loads FIN.
Process to Update Req/PO to hold status for
PO/REQ with certain criteria - this process is used to
put a PO or REQ on hold when certain criteria is met, Campus needed to put certain
such as using the wrong the Business Unit for REQ. REQ's and PO's on hold when
Purchasing reviews this report daily and is able to cetain criteria is met, such as
then correct problems sooner rather than later. SQR incorrect Business Unit, missing
1 Sacramento PO SQR, Pages SAC9_FIN025_COMR Put REQ/PO on Hold name is SACPO930.SQR. Account, etc. Eliminated
Campus custom Requisition Print - Sac State has Campus PO dept wanted many
modified the printed REQ with a customized look changes to baseline REQ print
baseline SQR mod - installed into campus SQR preferred by our Purchasing area. SQR name is including changing to the campus
1 Sacramento PO SQR directory Requesition Print PORQ010.SQR. logo JPG file. PO09004 - Requisition Form
1 San Bernardino GL SBF9P3MARUPDTE Award Fund Types Track Grant Agency Types GL09004 - Grants Management
1 San Bernardino GL SBF9P3MARUPDTE Award Purpose Track Award Purpose GL09004 - Grants Management
1 San Bernardino GL SBF9P3MARUPDTE Award Report Type Track Grant Report Type GL09004 - Grants Management
1 San Bernardino GL SBF9P3MARUPDTE Award Type Track Grant Award Type GL09004 - Grants Management
1 San Bernardino GL SBF9P3MARUPDTE Awards Agency Track Grant Awards Agency GL09004 - Grants Management
1 San Bernardino GL SBF9P3MARUPDTE Billing Frequency Identify Grant Billing Frequency GL09004 - Grants Management
1 San Bernardino GL SBF9P3MARUPDTE Billing Method Identify Grant Billing Method GL09004 - Grants Management
1 San Bernardino GL SBF9P3MARUPDTE Campus Schools Used for Grant management GL09004 - Grants Management
1 San Bernardino GL SBF9P3MARUPDTE CFDA Codes Used for Grant management GL09004 - Grants Management
1 San Bernardino GL SBF9P3MARUPDTE Cost Share Type Used for Grant management GL09004 - Grants Management
1 San Bernardino GL SBF9P3MARUPDTE Grant Administration Contact Info Used for Grant Administration GL09004 - Grants Management
1 San Bernardino GL SBF9P3MARUPDTE Grant Administration: Alternate mailing Used for Grant Administration GL09004 - Grants Management
1 San Bernardino GL SBF9P3MARUPDTE Grant Administration: Attributes Used for Grant Administration GL09004 - Grants Management
1 San Bernardino GL SBF9P3MARUPDTE Grant Administration: Comments Used for Grant Administration GL09004 - Grants Management
1 San Bernardino GL SBF9P3MARUPDTE Grant Administration: Director Used for Grant Administration GL09004 - Grants Management
1 San Bernardino GL SBF9P3MARUPDTE Grant Administration: Funding Used for Grant Administration GL09004 - Grants Management
1 San Bernardino GL SBF9P3MARUPDTE Grant Administration: Indirect Costs Used for Grant Administration GL09004 - Grants Management
1 San Bernardino GL SBF9P3MARUPDTE Grant Administration: Reporting Used for Grant Administration GL09004 - Grants Management
1 San Bernardino GL SBF9P3MARUPDTE Grant Administration: Sub Recipients Used for Grant Administration GL09004 - Grants Management
1 San Bernardino GL SBF9P3MARUPDTE Grant management: Project Status Used for Grant Administration GL09004 - Grants Management Loads Inventory Tracking Info into AM
Compares POAM002 to the POAM004 and flags
1 San Bernardino GL SBF9P3MARUPDTE Reports Reports GL09004 - Grants Management differences.
1 San Bernardino GL SBF9P3MARUPDTE Research Administrator Research Administrator GL09004 - Grants Management
1 San Bernardino GL SQR SBF9P3MARUPDTE SBFDN003 Grant Indirect Costs GL09004A - Grants Management, F&A
1 San Bernardino GL Standard Accounts Grants Accounting template GL09004 - Grants Management
1 San Bernardino AM SBF9P3MARUPDTE PI Extract Extract Asset data for conducting physical inventory Eliminated - Not Used
1 San Bernardino AM Crystal SBF9P3MARUPDTE SB_AMPSR PSR - Property Survey Report AM09003 - Property Survey Report
29adc070-b05f-449f-878a-517ba5a30fc2.xls 54 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Foundation AM Year end report -
(Note: Both GAAP and FA Accountants need to be
1 San Bernardino AM SBF9P3MARUPDTE SB_FDN_AM_RPTS_GBL involved in this report discussion.) Reporting Session
1 San Bernardino AM SBF9P3MARUPDTE SBPI2000 PI Extract Conversion GL09004 - Grants Management
1 San Bernardino AP SQR SBF9P3MARUPDTE SBAP001 Recon Rpt. SAM11A (Summary) Eliminated - Not Used
1 San Bernardino AP SQR SBF9P3MARUPDTE SBAP002 Recon Rpt. SAM11B (Detail) Eliminated - Not Used
1 San Bernardino AP SQR SBF9P3MARUPDTE SBAP004 Cash Activity Rpt. (ADO17) Eliminated - Not Used
1 San Bernardino AP SQR SBF9P3MARUPDTE SBAP005 Detail Agency Report Eliminated - Not Used
1 San Bernardino AP SQR SBF9P3MARUPDTE SBAP006B A/P Disbursement Report Eliminated - Not Used
1 San Bernardino AP SQR SBF9P3MARUPDTE SBAP007 Open Item Report for an acct AP05004 - AP Open Items Listing
1 San Bernardino AP SQR SBF9P3MARUPDTE SBAP014 A/P Wells Fargo EFT Report AP08001 - ACH Payment Processing
1 San Bernardino AP SBF9P3MARUPDTE SBFDN009 AP Voucher Load Eliminated - Not Used
1 San Bernardino AP SBF9P3MARUPDTE SBGL170 SBFDN Bank Reformat EDI Third Party Interface Document
1 San Bernardino AR SBF9P3MARUPDTE SBAR3200 AR Statement Eliminated
1 San Bernardino AR SBF9P3MARUPDTE SBARDUN1 Dunning Letter AR09004 - Dunning Letter
1 San Bernardino AR SBF9P3MARUPDTE SBARDUN2 DL - Significant Past Due AR09004 - Dunning Letter
1 San Bernardino AR SBF9P3MARUPDTE SBARDUN3 DL - Assigned to outside collection AR09004 - Dunning Letter
1 San Bernardino AR SBF9P3MARUPDTE SBARDUN4 DL - Final Delinquent Notice AR09004 - Dunning Letter
1 San Bernardino AR SQR SBF9P3MARUPDTE SBGLS160 AR Open Item Extract Third Party Interface Document
Used to upload and create multiple invoices from a
1 San Bernardino BI SBF9P3MARUPDTE Billing Upload Process spreadsheet flatfile BI09002 - Billing Upload
1 San Bernardino BI SBF9P3MARUPDTE RA ChartField to Customer Map page Reimbursed Activity Mod BI09003 - Automatic Invoicing
1 San Bernardino BI SBF9P3MARUPDTE RA Customer Setup page Reimbursed Activity Mod BI09003 - Automatic Invoicing
1 San Bernardino BI SBF9P3MARUPDTE RA Fund Selection / Pairing page Reimbursed Activity Mod BI09003 - Automatic Invoicing
1 San Bernardino BI SBF9P3MARUPDTE RA General Setup page Reimbursed Activity Mod BI09003 - Automatic Invoicing
1 San Bernardino BI SBF9P3MARUPDTE RA Note Setup page Reimbursed Activity Mod BI09003 - Automatic Invoicing
1 San Bernardino BI SBF9P3MARUPDTE RA Surcharges page Reimbursed Activity Mod BI09003 - Automatic Invoicing Need ability to Fax PO.
PS transactional data extracted and used to create
1 San Bernardino BI SBF9P3MARUPDTE Reimbursed Billing Extract reimb activity invoices BI09003 - Automatic Invoicing
1 San Bernardino BI SBF9P3MARUPDTE SBBILD Billing Upload Process BI09002 - Billing Upload
1 San Bernardino BI SBF9P3MARUPDTE SBBIRMB Reimbursed Billing Extract BI09003 - Automatic Invoicing How will this be handled?
1 San Bernardino BI SBF9P3MARUPDTE SBFDNINV SB - Foundation Invoice BI09001 - Billing Invoice
1 San Bernardino BI SBF9P3MARUPDTE SBINV01 SB - Custom Invoice BI09001 - Billing Invoice
1 San Bernardino GL SBF9P3MARUPDTE Cashnet to GL Non student payments fed to GL FS99001 - General Ledger Interface
1 San Bernardino GL SBF9P3MARUPDTE Chartfields to HR Chartfields to HR IB
1 San Bernardino GL SBF9P3MARUPDTE FDN Payroll Payroll feed for FDN from 3rd party FS99001 - General Ledger Interface
GL02002H - FIRMS Extract Data
1 San Bernardino GL SBF9P3MARUPDTE FIRMS Reporting Submit FIRMS extract file to CO Record
1 San Bernardino GL SBF9P3MARUPDTE LCD LCD processing IB
SAM99001 - SAM99 Reconciliation
1 San Bernardino GL SBF9P3MARUPDTE SAM 99 Process file from/to SCO Process
1 San Bernardino GL AE SBF9P3MARUPDTE SB_MTHLY_UPD Monthly Date Update Use PS Delivered Functionality
1 San Bernardino GL AE SBF9P3MARUPDTE SB_UPD_AC_DT Update Run Control Date Use PS Delivered Functionality
1 San Bernardino GL AE SBF9P3MARUPDTE SB_UPD_JRNL Update journal header status Data Integrity
1 San Bernardino GL SQR SBF9P3MARUPDTE SBAP006A GL Disbursement Report Reporting Session
29adc070-b05f-449f-878a-517ba5a30fc2.xls 55 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Need the ability to change the Check Signature
1 San Bernardino GL SQR SBF9P3MARUPDTE SBAP008 Wells Fargo Bank Rec (Summary) Reporting Session when required.
1 San Bernardino GL SQR SBF9P3MARUPDTE SBAP009 Wells Fargo Bank Rec (detail) Reporting Session
Need to bring the Student ID into the Vendor Master
1 San Bernardino GL SQR SBF9P3MARUPDTE SBAP010 Daily Wells Fargo Cash Act Reporting Session Old Vendor ID Field.
1 San Bernardino GL SQR SBF9P3MARUPDTE SBAP011 Detail Wells Fargo Agency Rpt Reporting Session
1 San Bernardino GL SQR SBF9P3MARUPDTE SBAP012 Wells Fargo GL Disburst. Rpt Reporting Session
1 San Bernardino GL SQR SBF9P3MARUPDTE SBAP013 A/P Wells Fargo Disburst. Rpt Reporting Session
1 San Bernardino GL SQR SBF9P3MARUPDTE SBGLS010 Sum. Report in Whole Dollars Reporting Session
1 San Bernardino GL SQR SBF9P3MARUPDTE SBGLS011 Monthly Budget Report Reporting Session
1 San Bernardino GL SQR SBF9P3MARUPDTE SBGLS020 Cur.Status of Dept. Accounts Reporting Session
1 San Bernardino GL SQR SBF9P3MARUPDTE SBGLS025 SBGLS025 - Ben Exp by COA Reporting Session
1 San Bernardino GL SQR SBF9P3MARUPDTE SBGLS030 Final Budget Report 6b Reporting Session
1 San Bernardino GL SQR SBF9P3MARUPDTE SBGLS040 Statement of Financial Conditi Reporting Session
1 San Bernardino GL SQR SBF9P3MARUPDTE SBGLS050 Due From & Due To Report Reporting Session
AM02001 - Statement of General Fixed
1 San Bernardino GL SQR SBF9P3MARUPDTE SBGLS060 General Fixed Asset Acct Group Asset
AM02002 - Statement of Changes in
1 San Bernardino GL SQR SBF9P3MARUPDTE SBGLS070 Changes in Genl. Fixed Assets General Fixed Assets
1 San Bernardino GL SQR SBF9P3MARUPDTE SBGLS080 Analysis of Change in Fund Bal Reporting Session
AR09001 - Reimbursement Activities
1 San Bernardino GL SQR SBF9P3MARUPDTE SBGLS090 Reimbursed Activity Status Report
GL09009 - Interest Calculation &
1 San Bernardino GL SQR SBF9P3MARUPDTE SBGLS100 Average Daily Balance Distribution
1 San Bernardino GL SQR SBF9P3MARUPDTE SBGLS120 Create Cashnet Extract Third Party Interface Document
1 San Bernardino GL SQR SBF9P3MARUPDTE SBGLS170 FDN Bank Reconcilliation Process Third Party Interface Document
1 San Bernardino GL Crystal SBF9P3MARUPDTE SBGM010 Project Summary By Dept Reporting Session
1 San Bernardino GL Crystal SBF9P3MARUPDTE SBGM020 Project Release Time By Dept Reporting Session
1 San Bernardino GL SQR SBF9P3MARUPDTE SBLCD025 LCD Adjustment Recon Report Eliminated - Not Used
1 San Bernardino GL SQR SBF9P3MARUPDTE SBNVS02 nVision Dynamic Build Reporting Session
1 San Bernardino GL SBF9P3MARUPDTE Student Finance to GL Student payments fed to GL FS99001 - General Ledger Interface
1 San Bernardino GL SBF9P3MARUPDTE Telephone transaction feed Telephone charge feeds from 3rd party GL09003 - Charge Back
1 San Bernardino GL SBF9P3MARUPDTE Wells Fargo bank recon Receive WF bank recon file GL06002 - Wells Fargo Bank Recon
1 San Bernardino MULT SBF9P3MARUPDTE
Custom Views (KK) Custom KK Reporting Views 8.4 to 9.0 retrofit Reporting Session
1 San Bernardino Other SBF9P3MARUPDTE Custom page to upload files to server Load Flat File GL09002 - FTP
1 San Bernardino Other SBF9P3MARUPDTE Portal and IDMS for FS oprids Portal and IDMS Security Related
PO99011 - Purchase Order Print
1 San Bernardino PO SQR SBF9P3MARUPDTE POPO005 Purchase Order Format
1 San Bernardino PO SQR SBF9P3MARUPDTE PORFQ01 Bid Print PO99013 - RFQ Bid Form
Process deprecated -- LA uses delivered journal
1 San Bernardino PO SQR SBF9P3MARUPDTE PORQ010 Requisition Print PO09004 - Requisition Form import process
1 San Bernardino PO Crystal SBF9P3MARUPDTE SB_PO003 PO activity for a COA string PO05001 - PO Activity Report
1 San Bernardino PO SQR SBF9P3MARUPDTE SBPO006 Requisition Detail Report Reporting Session
AP09009 - AP Voucher Interface or
1 San Bernardino PO SQR SBF9P3MARUPDTE SBPO008 Office Max Vchr Load process Third Party Interface Document
29adc070-b05f-449f-878a-517ba5a30fc2.xls 56 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
1 San Bernardino PO SQR SBF9P3MARUPDTE SBPO009 GE Capital Vchr Load Process PO09001 - Procard
San Francisco Agency Type Screen for setup table used for SFSU Grant Module
1 GL Bolt-on GL09004 - Grants Management
San Francisco Award Agency Screen for setup table used for SFSU Grant Module
1 GL Bolt-on GL09004 - Grants Management
San Francisco Award Attributes Screen to store award attribute information for
1 GL projects in the SFSU Grant Module Bolt-on GL09004 - Grants Management
San Francisco Award Type Screen for setup table used for SFSU Grant Module
1 GL Bolt-on GL09004 - Grants Management
San Francisco Billing Attributes Screen to store billing information for projects in the
1 GL SFSU Grant Module Bolt-on GL09004 - Grants Management
San Francisco Billing Frequency Screen for setup table used for SFSU Grant Module
1 GL Bolt-on GL09004 - Grants Management
San Francisco Billing Method Screen for setup table used for SFSU Grant Module
1 GL Bolt-on GL09004 - Grants Management
San Francisco Budget Revision Screen for setup table used for SFSU Grant Module Does a lot of message and translating of the file that
Bolt-on comes from the Library's system. IE: has a vendor
1 GL GL09004 - Grants Management cross walk table and CF creation.
San Francisco Build SFO Project Security Process to build/udate SFSUs Project Security tables
1 GL used in Reporting and other online functions GL09004 - Grants Management
San Francisco Campus College Screen for setup table used for SFSU Grant Module
1 GL Bolt-on GL09004 - Grants Management
San Francisco Campus Department Screen for setup table used for SFSU Grant Module
1 GL Bolt-on GL09004 - Grants Management
San Francisco CFDA Codes Screen for setup table used for SFSU Grant Module
1 GL Bolt-on GL09004 - Grants Management
San Francisco Classification Screen for setup table used for SFSU Grant Module SQR process that takes info from the Identity mgmt
Bolt-on system and looks for last password change and then
generates emails to users to change their password,
1 GL GL09004 - Grants Management if they do not it locks the PS password.
San Francisco Comment Type Screen for setup table used for SFSU Grant Module
1 GL Bolt-on GL09004 - Grants Management
San Francisco Comments Screen to store Comment information for projects in
1 GL the SFSU Grant Module Bolt-on GL09004 - Grants Management
San Francisco Cost Share Type Screen for setup table used for SFSU Grant Module
1 GL Bolt-on GL09004 - Grants Management
San Francisco Funding Info Screen to store funding and pass thru information for
1 GL projects in the SFSU Grant Module Bolt-on GL09004 - Grants Management
San Francisco Indirect Cost Info Screen to store Indirect Cost (IDC) information for
projects in the SFSU Grant Module Bolt-on. Data
here is used for monthly processing of IDC for each
1 GL project. GL09004 - Grants Management
San Francisco Other Requirements Screen to store Other Requirement information for
1 GL projects in the SFSU Grant Module Bolt-on GL09004 - Grants Management
29adc070-b05f-449f-878a-517ba5a30fc2.xls 57 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
San Francisco Principal Investigatior Info Screen to store Principal Investigator (PI) and PI
Assistent information for projects in the SFSU Grant
Module Bolt-on. Also servers as point of security for
1 GL SFSU online PI Project Report online website. GL09004 - Grants Management
San Francisco Prior Approval Screen for setup table used for SFSU Grant Module
1 GL Bolt-on GL09004 - Grants Management
San Francisco Project Fund Translate Screen to store Fund and Program Code information Mod does not handle Prgm Code - need for those
for projects in the SFSU Grant Module Bolt-on. grants that are in "transition" from the SF mod to the
1 GL GL09004 - Grants Management CFS Mod.
San Francisco Project Status Screen for setup table used for SFSU Grant Module
1 GL Bolt-on GL09004 - Grants Management
San Francisco Report Type Screen for setup table used for SFSU Grant Module
1 GL Bolt-on GL09004 - Grants Management
San Francisco Reporting Info Screen to store Reporting information for projects in
1 GL the SFSU Grant Module Bolt-on GL09004 - Grants Management
San Francisco Sick and Vacation Info Screen to store Sick and Vacation (SNV) information
for projects in the SFSU Grant Module Bolt-on. Data IDC set up will not work. Need another set up
here is used for monthly processing of SNV for each screen. Please see worksheet labeled
1 GL project. GL09004 - Grants Management SicknVacation.
San Francisco Signiture Authority Info Screen to store Signature Authority information for
1 GL projects in the SFSU Grant Module Bolt-on GL09001 - Delegation of Authority
San Francisco Sub Recipient Info Screen to store Sub Recipient information for projects
1 GL in the SFSU Grant Module Bolt-on GL09004 - Grants Management
San Francisco Weekly Dept Sync Process to update Department table for SFSU Grant
1 GL Module Bolt-on GL09004 - Grants Management
San Francisco Physical Inventory Modified delivered inventory program for way SFSU
handles cap and non-cap assets. Used in the The AMPI1000 (Run Physical Inventory) was
EXTRACT and RESULTS process modified to include non-cap assets with values
< $5000 (SFOAMPI1). Need to retain this to
be in compliant withequipment reporting
requirements that apply because SFSU
maintains its grant and contract on the campus
1 AM AM09001 - Physical Inventory Report side, as opposed to through an auxilliary.
San Francisco ACH Web application for Students Feed file from external web application sent to FMS.
A process uses this file to update student bank
1 AP information Third Party Interface Document
San Francisco ACH Web application for Vendors Feed file from external web application sent to FMS.
A process uses this file to update vendor bank
1 AP information Third Party Interface Document
29adc070-b05f-449f-878a-517ba5a30fc2.xls 58 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
San Francisco AMEX Credit Card Feed file from A/P. A process validates and 1) Will we be able to manipulate the file once
interfaces the file with many lines into temporary we receive it, prior to loading? We now extract
tables that are used to create vouchers in FMS all of the AP p-card transactions from the load,
since when AP pays an invoice using P-card a
voucher is already created - thus we don't want
double postings on the AP paid invoices. 2) If
manipulating is not possible, we would need to
receive two files from the card issuer: one for
campus cards and one for AP cards. Thus the
AP file would be used for reconciliation
purposes, rather than loading the file to the
1 AP PO09001 - Procard CFS.
San Francisco AP Vendor Voucher Process to interface vendor voucher (CSV) files into Need to retain the ability to provide students
FMS, currently done for AMEX, GE, with the pertinent information regarding their
disbursement by printing that information on
the advice portion of the check. We need to
keep the student vendor voucher setup that we
1 AP FS99004 - Vendor/Voucher Interface now have.
San Francisco AP0025 Send ACH Email Process for sending detail information to vendors for For students ACH notification, campus needs
ACH payments 'read' access to the PAYMENTS record.
1 AP AP08001 - ACH Payment Processing
San Francisco Automated Transfer to Wells Fargo Automated transfer of student or vendor funds to The Board of Equalization requires a different
Wells Fargo for transfer to student or vendor bank format to be used when sending their
payments - campus created a special pay
cycle for this purpose and needs to retain the
1 AP AP08001 - ACH Payment Processing ability to use different ACH formats.
San Francisco Check Register Report Report for the Accounts Payable breaking down
1 AP payments by checks and eft. AP09002 - AP Check Register
San Francisco GE Credit Card Feed file from GE. A process validates and interfaces
the file into temporary tables that are used to create
1 AP vouchers in FMS PO09001 - Procard
San Francisco Plus Loans database Feed file from ARM to FMS FTP site. A process uses Third Party Interface Document - > This is a
this file to update student vendor information to carry FS99004 - Vendor/Voucher Interface Pre-pay cycle for Plus Loans. Custom SQR
1 AP the parent information for Plus Loans and Third Party Interface Document 'SFOAP023' must be retained.
San Francisco PLUS Voucher Update Process to direct Financial Aid recipient for Plus Campus needs to retain the ability to run our
Loans to be the Parent of the student custom pre-paycycle jobs for Financial Aid,
Student refunds, Short-Term Loans, Stipends,
Parent Loans, etc. Our custom mod is
necessary to substitute the parent
name/address for PLUS processing; for
flipping the eft payment method to chk for
Short-Term Loans, and for separating eft
payments from checks and billing statements
FS99004 - Vendor/Voucher Interface for the financial aid and refunds.(Kuhaupt)
1 AP and Third Party Interface Document Custom SQR SFOAP022
29adc070-b05f-449f-878a-517ba5a30fc2.xls 59 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
San Francisco Pre-Paycycle Process Process to ensure that Emergency Loans will not go Custom crystal check format and remittance
through ACH; and to set the payment handling codes advice. The remittance advice is printed out
when the disbursement amount is less than or
FS99004 - Vendor/Voucher Interface equal to the current amount owed to the
1 AP and Third Party Interface Document university.
San Francisco SFO SAM18A - AP Open Liabilities by SCO Fund SAM99007A - Accounts Payable Open
1 AP Liabilities
San Francisco SFOAP029 ACH Regeneration Process for recreating and retransmitting ACH files to
1 AP Wells Fargo AP08001 - ACH Payment Processing
San Francisco SIMS Student database Feed file from ARM to FMS FTP site. A process uses
this file to insert or update student information in the FS99004 - Vendor/Voucher Interface
1 AP vendor tables and Third Party Interface Document
San Francisco Stipend Prepaycycle Process Process to ensure student Stipend payments go out We need the custom App Engine Program
as checks and set the payment group code FS99004 - Vendor/Voucher Interface 'SFO_STPNDCHK' if no replacement is
1 AP appropriately and Third Party Interface Document provided.
San Francisco Student Disbursements Feed file from our Accounts Receiveble Module Third Party Interface Document - In addition to
(ARM) to FTP site. A process validates and the upload process, we need to retain custom
interfaces the file into temporary tables that are used FS99004 - Vendor/Voucher Interface SQR Student Vendor Voucher Interface.
1 AP to create vouchers in FMS. and Third Party Interface Document SFOAP019.
San Francisco Sync ACH Process to synchronize FMS Vendor tables with ACH
1 AP website for students Third Party Interface Document
San Francisco Sync PLUS Process to synchronize FMS Vendor tables for
1 AP students with Parent (Plus Loans) information Third Party Interface Document
San Francisco Sync Vendor ACH Process to synchronize FMS Vendor tables with ACH
1 AP website for vendors Third Party Interface Document
San Francisco HR Sync Program Process to update tables in Finance with information The custom AE programs for this
from HR synchronizes the Finance Personal Record
with HR Personal data record; and the Finance
Job Record with the HR Job record. Cw 1)
NOT a 3rd party interface. AE prgm,
SFO_PER_SYNC, updates
PERSONAL_DATA,
PERSONAL_PHONE,EMAIL_ADDRESSES,
PERS_NID Tables. 2) Another AE prgm,
SFO_EMP_SYNC, updates EMPLOYMENT,
1 AP Third Party Interface Document JOB Tables. glg
San Francisco Sync Emp Process to synchronize FMS Vendor tables with The custom SQR SFOSYNCE maintains and
Employee information from H/R. creates employee vendor under setid =
SFEMP from the Finance Personal Data
1 AP Third Party Interface Document record.
San Francisco Sync SIMS Process to synchronize FMS Vendor tables with Micr line may need to be adjusted to fit the
1 AP SIMS database for students Third Party Interface Document Auxillaries Check readers.
San Francisco Account Lock Automated process that intergrates with HRMS to NOT a 3rd party interface. A custom process
determine users employee status and locks the user's SFOACCLK that will lock accts and reset
1 GL account with appropriate Security Related navigation.
29adc070-b05f-449f-878a-517ba5a30fc2.xls 60 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
San Francisco Account Lock Automated process that intergrates with HRMS to
determine users employee status and locks the user's
1 GL account with appropriate Third Party Interface Document
San Francisco Accounting Service Fee Screen used to set up Account Chartfields to process Our campus applys a percentage of
the Accounting Service Fee for projects accounting service fee to a specific range of
revenue accounts among Projects IDs. The
current custom fuction automatically calculates
the accounting service fee based on any
Project activities incurred of the month. The
delivered function requires to setup the charge
code by individual Chartfield combination
1 GL GL09003 - Charge Back instead of account range.
San Francisco Auto Gen GL109 Report Automated process for running thousands of PI
Project Reports(SFOGL109). Send the report to a Adds a message to the AP Student Checks "Look at
central location to be downloaded and posted to Student Account for Details". This can be done in
1 GL SFSU website. Third Party Interface Document the AP PayCycle instead.
San Francisco Automated DW Ledger Load Automated process to load SFSUs Datawarehouse
tables for current and prior period for SFCMP and An extract is done and used for Identity
1 GL SFFDN business units. Third Party Interface Document Management.
San Francisco Automated Project Report Automated process of running PI Project reports for
1 GL Pis Eliminated - Not Used
San Francisco Automated Project2 Report Automated process for running thousands of PI
Project Reports(SFOGL100 & SFOGL104). Send the
report to a central location to be downloaded and An extract is done and used for Identity
1 GL posted to SFSU website. Third Party Interface Document Management.
San Francisco Billing Summary Rpt Report used by Auxiliary units in generating billing Ability to grap files from the UNIX server and bring
1 GL statements to various funding agencies Reporting Session into campus servers.
San Francisco Build Foundation Report Tables Reads Ledger Tables to create nVison reporting
1 GL tables for SFFDN. Reporting Session
San Francisco Cash Bal Int Disbursement Screen used for Cash Balance Interest Disbursement GL09009 - Interest Calculation &
1 GL by Fund Distribution
San Francisco Cash Receipts Feed file from our Accounts Receiveble Module
(ARM) to FTP site. Using CSU delivered process to
read file, do edits, and report. If pass edits, puts data
into Acctg Line table ready for Journal Generation.
Created custom interface definitions using CSU
delivered Interface Definition functionality
1 GL FS99001 - General Ledger Interface
San Francisco Compare Ledger Compare Ledgers (Act, Enc, pre-Enc). Can also
1 GL synchronize. Reporting Session
San Francisco Cost Allowed Rpt Report that the Accounting Office uses to view
balance available for Grants, Endowments, etc…
1 GL (used primarily by University Corporation) Reporting Session
San Francisco Current Balance Report to give Current Balance information. End User
department report based on SFSU implemented
1 GL Department Security. Reporting Session
29adc070-b05f-449f-878a-517ba5a30fc2.xls 61 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
San Francisco Current Balance (FABS) Report to give Current Balance based on given
criteria. Accountant level report, not subject to SFSU
1 GL implemented Department or Project Security Reporting Session
San Francisco Data Warehouse Ledger Process to load/update SFSU custom datawarehouse Third Party Interface Document NOT a 3rd
tables. party interface. A custom process,
SFOGL107, that updates a SFO custom DW
tables. Can this be eliminated with the new
CMS Reporting Solution/DW going live, Mar
1 GL Third Party Interface Document 2010 ?
San Francisco End User Reports FY Setting Table used to hold information on when Fiscal Year
started(or day when previous FY end process
completed). Used for various items, including
1 GL reporting. Reporting Session
San Francisco Exp/ Rev Analysis (FABS) Report to give summary of Expenses and Revenue
based on given criteria. Accountant level report, not
subject to SFSU implemented Department or Project
1 GL Security Reporting Session
San Francisco Exp/Rev Analysis by Dept/Acct Report to give summary of Expenses and Revenue
based on given criteria. End user department report
1 GL base on SFSU implemented Department Security Reporting Session
San Francisco Foundation Payroll Process external Payroll file for SFFND Business
Unit. Data is loaded into Acctg Line Table for Journal
1 GL Generation Third Party Interface Document
San Francisco Fund Account Balance cross-ref Table used by different programs and interacting with
Fund Tree (node level) to tell if Fund is Revenue,
Expense, or Balance forward. Divided by SFSUs 3
1 GL different business units Eliminated - Not Used
San Francisco GL Detail Activity Report to give detail activitly of accounting
information. End User department report based on
1 GL SFSU implemented Department Security. Reporting Session
San Francisco GL Detail Activity (FABS) Report to give detail activitly of accounting
information. Accountant level report, not subject to
SFSU implemented Department or Project Security.
1 GL Reporting Session
San Francisco GL Detail by Project Report to give detail activitly of accounting
information. End User project report based on SFSU
1 GL implemented Project Security. Reporting Session
San Francisco HR LCD Setups Data from LCD not complete when sent. Setups used
to completed missing data. Missing data is Dept. ID Data Integrity - It is a custom page created for
and various Fund Codes and/or projects. This screen the Accountants to maintain. This is use for
1 GL gives Accountant control. Data Integrity the LCD process.
San Francisco IDC Process - IDC Process to calculate Indirect Cost for projects in
SFSU Grant Module Bolt-on. This process creates
journal entries and enters them directly into Acctg
1 GL Line Table, ready for Journal Generation GL09004A - Grants Management F&A
29adc070-b05f-449f-878a-517ba5a30fc2.xls 62 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
San Francisco IDC Process - Sick and Vacation Process to calculate Sick and Vacation for projects in
SFSU Grant Module Bolt-on. This process creates Retain calculation program SQR SFOSNV01 if
journal entries and enters them directly into Acctg no replacement provided. GL090004 does not
1 GL Line Table, ready for Journal Generation GL09004A - Grants Management F&A fully address this process.
San Francisco IDC Process - SUI Process to calculate SUI for projects in SFSU Grant
Module Bolt-on. This process creates journal entries
and enters them directly into Acctg Line Table, ready Data Integrity - It is a custom page created for
1 GL for Journal Generation GL09004A - Grants Management F&A the Accountants to maintain.
San Francisco Invoices/Invoice Adjustments Feed file from our Accounts Receiveble Module
(ARM) to FTP site. Using CSU delivered process to
read file, do edits, and report. If pass edits, puts data
into Acctg Line table ready for Journal Generation.
Created custom interface definitions using CSU
delivered Interface Definition functionality
1 GL FS99001 - General Ledger Interface
San Francisco Labor Cost Distribution Recive LCD information from HRMS in Acctg Line
Table. Have to do a little pre-processing before
1 GL Journal Generation. Data Integrity
San Francisco LCD Update Process to update missing LCD data (LCD data
provided from HR via Integration Broker into Acctg Not sure what "Data Integrity" means.
Line Table). Uses the HR LCD Setups for processing Process 'HR LCD' and using LCS set up,
1 GL Data Integrity updates CFs with missing values'.
San Francisco Ledger DW Inquiry Custom built inquiry screen to query data from SFSU
1 GL custom datawarehouse tables. Third Party Interface Document
San Francisco Load Daily Activity Balances Process to load Daily Cash Balance into table to track
1 GL Eliminated - Not Used
San Francisco Month-End Accounting Date Roll Rolls forward to new accounting period of all purchase
orders, requisitions and vouchers which have not
1 GL been budget checked. Use PS Delivered Functionality
San Francisco ORSP CDIP Rule 4 Calculation CDIP -Rule 4 Calculation for Grants and Research GL02002A - CDIP FIRMS Program
1 GL Code Derivation
1 San Francisco GL Period Analysis Revenue and Expenditure Analysis by Period Reporting Session
San Francisco PI Project Report Report to give accounting information for projects.
Also include basic grant information for project. End
1 GL user report Reporting Session
San Francisco PI Project Report (FABS) Report to give accounting information for projects.
Also include basic grant information for project.
1 GL Accountant report with more criteria options Reporting Session
San Francisco Process Prorates - SFSU Acct Service Fee Posting create (and enter into Acctg Line Table)
Process to
accounting entries for Accounting Service Fee. Uses
Ledger data with data provided from Acct. Svr. Fee
1 GL Screen. GL09003 - Charge Back
San Francisco Process Prorates - SFSU ReimbursmentsProcess to create (and enter into Acctg Line Table)
accounting entries for Reimbursements. Uses Ledger
data with data provided from Reimbursements
1 GL Screen. BI09003 - Automatic Invoicing
29adc070-b05f-449f-878a-517ba5a30fc2.xls 63 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
San Francisco Process Prorates - SFSU SUI Process to create (and enter into Acctg Line Table)
accounting entries for State Unemployment Insurance
(SUI).Uses Ledger data with data provided from SUI ASUI charges will be similar to Sick Leave &
1 GL Screen. Third Party Interface Document Vacation
San Francisco Project Report (Non Grants) Report to give accounting information for projects.
Output different from PI Project report as this is for
1 GL Non-Grant projects. Reporting Session
San Francisco Recharge Definitions Screen to set up the DR/CR definition for Chargback.
1 GL Uses the CSU Interface Defintions GL09003 - Charge Back
San Francisco Recharge Departments Screen to set up the DR/CR for chargeback to a
1 GL department GL09003 - Charge Back
San Francisco Recharges Feed file created and moved to FTP site. Have
process to read file, do edits, and report. If pass
edits, puts data into Acctg Line table ready for Journal
Generation. Created custom interface definitions
using CSU delivered Interface Definition functionality
1 GL GL09003 - Charge Back
San Francisco Reimbursements Screen used to set up Account Chartfields to
1 GL reimburse projects and sub projects BI09003 - Automatic Invoicing
San Francisco Rev/Exp Analysis by Project Report to give summary of Expenses and Revenue
based on given criteria. End user project report base
1 GL on SFSU implemented Project Security Reporting Session
San Francisco Rev/Exp Summary Revenue and Expenditure Summary with additional
1 GL options to run any type of funds Reporting Session
San Francisco Run Cash Balance Disbursement Process to run Cash Balance Interest Allocation GL09009 - Interest Calculation &
1 GL Distribution Workflow not in scope
San Francisco Run Recharge Process to load recharge data, from external source,
1 GL into CSU Acctg Line table GL09003 - Charge Back
San Francisco SAM6 Detailed Report Report used by the Budget Office to view detail
expenditure transactions by Firms code. Written prior
to the CMS release of SAM6B Report with detail.
1 GL SAM02001 - SAM6 Final Budget
San Francisco SFOGL100 Cleanup Process to Clean up temp tables for SFOGL100
1 GL Report Eliminated - Not Used
San Francisco Submit SFOGL100 Jobs Process to run multiple GL Detail Activity Reports
1 GL based on Roles Eliminated - Not Used
1 San Francisco GL Trust Funds Available Balance Report for Trust Funds Reporting Session
San Francisco University Corp. Payroll ADP processes payroll for The University Corp.
Generate a file and load to FTP site. Have process to
1 GL load file into Acctg Line Table. Third Party Interface Document
San Francisco Update CDIP for ORSP Projects Assign appropriate program code for Grant projects GL02002A - CDIP FIRMS Program Add NACUBO Program code in the Associated
1 GL for CDIP reporting Code Derivation Project Tab
San Francisco Update jrnl_header table Update certain rows in Journal Header table for
1 GL certain account types Data Integrity
29adc070-b05f-449f-878a-517ba5a30fc2.xls 64 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
San Francisco Variables for Tree Views Screen to set the tree SFO_FUND_CUR_VW which
is used as the drop down list of funds in mosts of the
1 GL End User reports. Eliminated - Not Used
San Francisco Database Link University-side databases link into FMS database via Campus needs this DS account to maintain
database link using a DS account our database links in SFSU databases that
1 Other Security Related communicate with PS database.
San Francisco CSU - Disabled Veterans Report Customized Disabled Veterans Report using SFO
1 PO Category Codes PO99007 - DVBE/SM/MB Report
San Francisco CSU - Small/Microbusiness Report Customized Small/Microbusiness Report using SFO
1 PO Category Codes PO99007 - DVBE/SM/MB Report need to segregate what each group can see
1 San Francisco PO Identify Out of Balance PO's Identify any out of balance Pos and Reqs Reporting Session
San Francisco Open Commitment Report to give open commintments (Encumbrance &
Pre-Encumbrances) based on varying criteria. End
1 PO User level report. Reporting Session
San Francisco Open Commitment (FABS) Report to give open commintments (Encumbrance &
Pre-Encumbrances) based on varying criteria.
1 PO Accountant level report with more options Reporting Session
San Francisco PO Dispatch Process to dispatch PO's, customized to output PO99011 - Purchase Order Print
1 PO custom commands for Rightfax for faxing. Format
1 San Francisco PO PO Verification Stuff Fix all out of balance Pos and Reqs Data Integrity
San Francisco Right Fax Once approved, copy of the disptched Purchas
Orders are sent to our faxing application (RightFAX)
where they are automatically faxed/emailed to the POPO005 contains custom codes-fax
vendor, requestor, purchasing agent. The PO is also instructions for RightFax. See worksheet
PO99011 - Purchase Order Print
sent to our imaging system.
1 PO Format labeled RightFas to view the process flow.
San Francisco SFO SAM18A - PO Open Commitment by SCO Fund SAM99007B - Purchasing Open
1 PO Encumbrances
San Francisco Submit SFO POPO005 Jobs Process to dispatch PO's ready to be dispatched This c ustom job is used to submit separate
PO99011 - Purchase Order Print POPO005 for multiple purchase orders in a
1 PO Format batch.
San Francisco Build SFO Department Security Process to build/udate SFSUs Department Security The Program builds a Custom Table that
tables used in Reporting and other online functions SFSU Finance uses for reporting including
OBIEE. End-users are restricted to view
transactions based on assigned deptids and/or
1 Security Security Related projectid/s..
San Francisco Run Change Password AppEngine SFSU has process to change user password. This SFSU custom App Engine program that let
process is the server side process to change user SFSU users to change their Peoplesoft
password Finance ID using their SFSU ID and SFSU
1 Security Security Related Password
San Francisco SFO Security Reports Process to report on SFSU security setup by Programs that looks at SFO Department
1 Security Operator IDs, Departments, Projects, etc Security Related Security custom table.
GAAP Adjustments by Financial Report provdies the detail for the adjustments column
1 San Jose AM Statement Line Report in the GAAP Working Trial Balance. GL09015 - Journal Detail Report
1 San Jose AM GAAP Adjustments by Journal Report Log of all GAAP adjustig journals GL09015 - Journal Detail Report
Pre-Closing Trial Balance - GAAP
1 San Jose AM Adjustments GL09015 - Journal Detail Report
29adc070-b05f-449f-878a-517ba5a30fc2.xls 65 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Now, using The CSU Match
1 San Jose AP AP Match Exception Report No longer use the SJSU version Exception report AP05003 - Match Exception Report
SJGL506: Voucher Flat File Interface Upload from Eliminate paper processing and AP09009 - AP Voucher Interface or
1 San Jose AP Flat file - FTP External flat file to AP Library (BU SJ002) duplicate data entry. Third Party Interface Document
DB link to local SJWBVCHR: Direct Pay Voucher Upload from Local
campus Custom Interface (SJSU Finance Web Component) Eliminate paper processing and AP09009 - AP Voucher Interface or
1 San Jose AP database External load to AP into FSJPRD data entry Third Party Interface Document
DB link to local SJWBVCHR: Employee/Student Reimbursement
campus Voucher Upload from Local Custom Interface (SJSU Eliminate paper processing and AP09009 - AP Voucher Interface or
1 San Jose AP database External load to AP Finance Web Component) into FSJPRD data entry Third Party Interface Document
DB link to local Travel Reimbursement Voucher Upload from Local
campus Custom Interface (SJSU Finance Web Component) Eliminate paper processing and AP09009 - AP Voucher Interface or
1 San Jose AP database External load to AP into FSJPRD data entry Third Party Interface Document
SJSF021: Within BU SJ004 Vendor Build to build
DB link to local stdnt/empl vendors (new employees and students
campus getting through Student Administration) using Eliminate paper processing and AP09009 - AP Voucher Interface or
1 San Jose AP database HCM to AP Integration Broker data entry Third Party Interface Document
update ps_pymnt_vchr_xref p
set p.pymnt_hold = 'Y',
p.pymnt_hold_reason = 'DVP'
where p.business_unit = $t_business_unit To make sure payment will not go
and p.voucher_id = $t_voucher_id thru untill all the paperworks are
1 San Jose AP SQR Hold Web-Originated Vouchers and p.pymnt_cnt = #t_pymnt_cnt received and reviewed in AP. Eliminated - Not Used
1 San Jose AP SQR Hold/Unhold Claim Staging Rows toggle csu_clm_stg_tbl''s csu_clm_stg_sts flag value Eliminated - Not Used
1 San Jose AP Crystal SJSU Wells Fargo Check AP06001 - AP Check Format
1 San Jose AP Crystal SJSU Wells Fargo Check Copy Eliminated
SJ_SF_AP_ITF: Student Financials Refunds -
Financial Aid Refunds involving Integration Broker to have vouchers build in AP for
1 San Jose AP Integration Broker Student Financials to AP from Student Financials to Payables the pay cycle IB
1 San Jose AP Crystal Trial Register SJSU Version - different format AP08002 - AP Trial Register
1 San Jose AP Update Accounting Date at Month End Update Accounting Date at Month End No longer running this in 9.0 Use PS Delivered Functionality
Listing of all transactions that have
use tax for a specific period. AP
uses these informations and add
SJAP003-Crystal report for Use Tax in Detail with up the amount of "use tax" to send This is used for all LB's custom reports and if these
1 San Jose AP Crystal Use Tax Detail listing of PO no., voucher no. to State Board of Equalization. Reporting Session get replaced this will not be needed.
This report is by Fund. AP keeps
1 San Jose AP Crystal Use Tax Summary SJAP003S-Crystal report for Use Tax in Summary as a record Reporting Session
Less paperwork, each month, just
download bank statement to PS
Finance for end-user to reconcile it
online in PS Finance. Less data
1 San Jose AP SQR NEW - 9.0 ProCard Upload entry. PO09001 - Procard
29adc070-b05f-449f-878a-517ba5a30fc2.xls 66 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Positive Pay File - Check confirmation file to Wells AP06002 - Wells Fargo Positive
1 San Jose AP Fargo Payment File
The Aging Summary Report (by Business Unit) lists
aged open customer balances. If the posted date on
the item is on or before the 'as of' date for the report,
the item balance is retrieved from the PS_ITEM table.
If the posted date on the item is later than the as of
date for the report, the item balance is established by
looking at the item activity (PS_ITEM_ACTIVITY) up Allow users to run aging by BU, AR02001 - AR Aging by Fund and
1 San Jose AR SQR Aging Summary Report to the 'as of' date. collector. Account Report
AR09002 - AR Aging by Customer
1 San Jose AR SQR AR Aging by BU For HR-Payroll. See Aging Summary Report. See mod description Report
No longer used - delivered mod AR09002 - AR Aging by Customer
1 San Jose AR SQR AR Aging by Customer Name See Aging Summary Report CSUAR001 used instead. Report
No longer used - delivered AR3003 AR02001 - AR Aging by Fund and
1 San Jose AR SQR AR Aging by Fund, Account report used instead. Account Report
1 San Jose AR SQR AR Aging Detail by Project ID See Aging Summary Report Reporting Session
This mod runs in HCM. It pulls
payroll AR setup data from the
payroll file and exports it to
Finance. Then the data is loaded
1 San Jose AR HCM to AR SJBI006: Payroll AR Interface via SJBI001 (see below). Third Party Interface Document
Duplicate listing - see SJBI006
1 San Jose BI SQR Create AR Setup Invoices Create AR Setup Invoices from Paytape above. BI09003 - Automatic Invoicing
Create Reimbursed Activities
receivables based on reimbursable
1 San Jose BI SQR Create RA Receivables SJBI014 expenses. BI09003 - Automatic Invoicing
Add project ID ChartField to
1 San Jose BI SQR Invoice Register by Project Id See Invoice Register Report Invoice Register Report Reporting Session
Add BU and Customer ID
parameters to delivered Invoice
1 San Jose BI SQR Invoice Register Report Invoice Register Report Register Report Reporting Session
Allow customers (particularly
auxiliary organizations) to see their
1 San Jose BI SQR Invoices Invoice Run by BU, Customer ID for selected period invoices for a given period. BI09001 - Billing Invoice
Batch process to load selected customer from HR Create/modify selected employee
1 San Jose BI SQR Load Customer by ID employees tables. customer in AR based on HR data. Third Party Interface Document
Create/modify employee customers
1 San Jose BI SQR Load Customer Tables Load Customer tables from HR Employees in AR based on HR data. Third Party Interface Document
Load Reimbursed Activities
receivable transactions created by
1 San Jose BI SQR Load RA Receivable Transactions SJBI015 SJBI014 above. BI09003 - Automatic Invoicing
29adc070-b05f-449f-878a-517ba5a30fc2.xls 67 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Load payroll AR setup data from
HR (see SJBI006 above) into
1 San Jose BI SQR Payroll Accounts Receivable Upload payroll accounts receivable via flat file (.csv) Billing. Third Party Interface Document
1 San Jose BI Payroll AR with Reasons Not brought forward to 9.0 Eliminated - Not Used
STD995A Form - Payroll Accounts
1 San Jose BI Crystal Receivable Print SCO STD995A report. Eliminated - Not Used
Duplicate listing - see SJBI005
1 San Jose BI SQR SJWBI005: SJ_LOAD_CUSTOMERS for billing above. Third Party Interface Document
Selects Revenue, Transferred from Other
Fund/APNNS, and Other Accounts (Additions) and
Expenses, Transers to Other Fund/APPNS, and To provide a report linking
Other (Deductions) from the PS_LEDGER record beginning fund balance, curent-
(actuals) for the current year and specified funds. year-eactivity, and ending fund
Uses the tree: 'FUND_PRIMARY' to determine balance - for year-end internal
1 San Jose GL SQR Analysis of Change in Fund Bal legacy fund rollup. reporting. Reporting Session
This report provides a matrix of operating expenses
by program group and object category as required by Superseded by delivered mod
1 San Jose GL SQR Expense Matrix Report GASB 34. CSUFS166 . Eliminated - Not Used
SQR-DB link
to local SJWBBJ01: Budget Transfer (Journal) Upload from
campus Local Custom Interface (SJSU Finance Web Load budget transfers from custom
1 San Jose GL database External load to GL Component) into FSJPRD end user data entry front end. Third Party Interface Document
SQR-DB link
to local SJWBEJ01: Expense Transfer (Journal) Upload from Load expense transfers from
campus Local Custom Interface (SJSU Finance Web custom end user data entry front
1 San Jose GL database External load to GL Component) into FSJPRD end. Third Party Interface Document
SQR-DB link
to local SJWBETYE: Interdepartmental Expense Transfer Load interdepartmental expense
campus (Journal) Upload from Local Custom Interface (SJSU transfers from custom end user
1 San Jose GL database External load to GL Finance Web Component) into FSJPRD data entry front end. Third Party Interface Document
SQR-DB link
to local SJWBHJ01: Hospitality Payment Journals Upload Load hospitality payment transfers
campus from Local Custom Interface (SJSU Finance Web from custom end user data entry
1 San Jose GL database External load to GL Component) into FSJPRD front end. Third Party Interface Document
SJFS140 (CSUFS140): Journal Flat File Upload into Not used for journals - see
1 San Jose GL Flat File - FTP External load to GL FSJPRD SJGL008 below. GL05001 - Journal Upload Process
Load Touchnet file into
1 San Jose GL Flat file - FTP External load to GL SJFS140 (CSUFS140): TouchNet Flat File Upload CSU_ACCTG_LN table. FS99001 - General Ledger Interface
SJFS140 (CSUFS140): Upload Telecommunications Load Telecomm file into
1 San Jose GL Flat file - FTP External load to GL Flat File CSU_ACCTG_LN table. FS99001 - General Ledger Interface
Load file into CSU_ACCTG_LN
1 San Jose GL External load to GL SJFS140 (CSUFS140): Load GL Interface table. FS99001 - General Ledger Interface
SQR-DB link SJWBPRMT: Chartfield (SQL/Parm) download from
to local FSJPRD; Refreshes web prompt (preference) tables
campus utilized in the Local Custom Interface (SJSU Finance Update ChartField data in custom
1 San Jose GL database Financial data to Local Web Component) front end. Third Party Interface Document
29adc070-b05f-449f-878a-517ba5a30fc2.xls 68 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
CREATE_MV: CREATE_HIERARCHY_LEDGER:
Ledger, transactional and chartfield data from
FSJPRD to Local Cognos Financial Reporting System Download data into local data
1 San Jose GL Financial data to Local data warehouse (for campus reports) warehouse for internal reporting. Third Party Interface Document
This program generates the a Non-Zero Cash Journal
Entry Report. All non zero journal id's with source in
'AC', 'BUR', 'PFA' and Account # in '10100', '101002',
'101003', '101009' will be printed. The following
columns are included in the report: Journal ID, Identify manual journals that affect
Account, Source, Monetary Amount, Journal Ln Ref, cash balances (possible reconciling
1 San Jose GL SQR GL Bank Recon - Cash Description, Journal_date items). Reporting Session
Should be able to use the Payment Handling Code
1 San Jose GL Integration Broker HCM to GL LCD Processing Load payroll data into GL. IB to sort this for them?
1 San Jose GL SQR Ledger Balances Creates .csv file Not brought forward to 9.0 Eliminated - Not Used
Load data from library purchasing AP09009 - AP Voucher Interface or
1 San Jose GL SQR Library AP Interface Load flat file (from Innovative's Millenium system) system. Third Party Interface Document
Loads journal from flat file; add fields to
OPEN_ITEM_GL; remove edit on blank deptid when
1 San Jose GL SQR Load Journal from Flat File non revenue/expense account - SJGAP. See Mod Description. Third Party Interface Document
Add HR data to delivered Open
1 San Jose GL Open Salary Advances Detail Report Open Salary Advances Detail Report Item Listing report. Eliminated - Not Used
Control break logic and detail line order changed from Superseded by delivered mod SAM99007B - SAM18A Purchasing
1 San Jose GL SQR SAM18A - PO Open Encumbrances baseline version. CSUGL022. Open Encumbrances
SJSU Athletics Monthly Expenditures
1 San Jose GL SQR Report SJSU Athletics Monthly Expenditures Report Not being used. Eliminated - Not Used
1 San Jose GL Integration Broker Student Financials to GL EOP Student Financials data from HCM into FSJPRD Load student financial data into GL IB
This report summarizes the adjusted balances in the Superseded by delivered mod
1 San Jose GL SQR Summary Trial Balance Matrix Report GAAP Working Balance by Fund Type and FS Line CSUFS169. Eliminated - Not Used
Change the Journal Header Status on encumbrance
and pre-encumbrance journals from "V" to "P". These
journals are not posted to the LEDGER table, which is
what the "P" status means, but as long as they
Update journal status for encumbrance remain in "V" status they can be changed, which we
1 San Jose GL SQR and pre-encumbrance journals don't want. Not brought forward to 9.0. Eliminated - Not Used
Updates Personal Data in Finance
from HR for employees only (not
1 San Jose GL SQR Update Personal Data from HR Update Personal Data from HR students). AP09001 - Open Item Key Setup
Chartfield feed from FSJPRD to HCM utilizing
1 San Jose GL Integration Broker Integration Broker Update ChartField data in HCM. IB
Should be able to use the Payment Handling Code
1 San Jose GL Integaration Broker Student Financials Feed utilizing Integration Broker Load student financial data into GL IB to sort this for them?
MarketPlace - Journal Entry for items such as Parking Import cash receipts data from
1 San Jose GL Fees, Orientation Fees, etc Touchnet Marketplace product. FS99001 - General Ledger Interface
29adc070-b05f-449f-878a-517ba5a30fc2.xls 69 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Not brought forward to 9.0 -
1 San Jose GL Bank Reconciliation Flat File Upload customization no longer needed. Eliminated - Not Used
Take out fields that don't need, and replace them with To include fields that makes sense
1 San Jose PO Expediting Report by Due Date needed one. to end user Reporting Session
SJWBSYNC: Web Requisition Upload from Local
Custom Interface (SJSU Finance Web Component) A friendlier front-end for dept. end-
1 San Jose PO External load to PO into FSJPRD user to enter their requisitions. PO Common Door
1 San Jose PO FY Report for Requisitions Reports from Finance Web Component No longer in use. Eliminated - Not Used
1 San Jose PO SQR HR Requestor Load Load Requestor Info from HR
This SQR will determine all open PO's based on the
SLO PO Activity View (SLO_PO_ACT_VW) and
based on a set of dynamic values, report all the lines No longer in use. In 9.0, we have
1 San Jose PO Open PO Activity Report for each PO that meet the criteria CSUPO051 and it's the same PO05001 - Open PO Activity Report
Take out fields that don't need, and replace them with To include fields that makes sense
1 San Jose PO Order Status by Vendor needed one. to end user Eliminated - Not Used
No longer in use. In 9.0, we have
1 San Jose PO PO Activity Report In 9.0, we have CSUPO051 CSUPO051 and it's the same PO05001 - Open PO Activity Report
Take out fields that don't need, and replace them with To include fields that makes sense
1 San Jose PO Crystal PO Detail Listing by Buyer needed one. to end user Reporting Session
Lists encumbrance errors by comparing the balance
in the KK by chartfields/line/sched/distrib to the To do troubleshooting on
1 San Jose PO SQR PO Encumbrance Error List liquidation amount in the kk_liquidation table encumbrances Eliminated - Not Used
Listing of all detailed transactions that related to the To help end-users doing their PO
1 San Jose PO SQR PO Life Cycle Report PO reconciliation PO09002 - Purchase Order Life Cycle Use delivered
Take out fields that don't need, and replace them with To include fields that makes sense
1 San Jose PO Crystal PO Listing by PO Date needed one. to end user Reporting Session
Take out fields that don't need, and replace them with To include fields that makes sense
1 San Jose PO Crystal PO to Req Xref Report needed one. to end user Reporting Session
Take out fields that don't need, and replace them with To include fields that makes sense
1 San Jose PO Crystal Req to PO Xref Report needed one. to end user Reporting Session
Need to have our campus logo,
requisition no, dept. name,
delivery location, and makes PO PO99011 - Purchase Order Print
1 San Jose PO SQR SJSU Custom Purchase Order Custom Purchase Order no. appears bigger Format Query now
SJPO001b.SQR works similar to SJPO001.SQR. The
only difference is the input file of this report is the
1 San Jose PO SQR SJSU PO Open Activity by buyer output file of SJPO001.SQR Eliminated - Not Used
SJGL027: Load Employee data from HCM to
1 San Jose Security HCM to Financials Financials for Security confirmation (PSOPRDEFN) Security Related
29adc070-b05f-449f-878a-517ba5a30fc2.xls 70 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
The project contains the following
modifications to enable Cal Poly to
implement the asset management
module. There are 3 mods to
existing Peoplesoft objects with an
associated Business Justification
Form attached. #1-The default
value for CONVENTION in the
ADJUST_WRK record must be
changed from ‘AM’ to ‘HY’ to
enable depreciation to be correctly
calculated. #2 & #3-The prompt
table edit associated with
PROJECT_ID in AM_CF1_WRK
and AM_CF2_WRK records must
be changed from
SP_PROJFS_CLSVW to
PROJECT_VW since the delivered
view requires project security to be
set up from the project costing
1 San Luis Obispo AM SQR SLOFS009 Asset Management Processes Monthly Asset Management Journal Load module which we do not use. AM09007 - 501 Accounting Entries
The CSU has no delivered
program to create the 997 asset
management entries in the
ACTUALS ledger and update the
fiscal year/accounting
period/gl_distrib_status in the asset
management dist_ln table. In order
to facilitate the journal entry
creation, an SQR was written AM09006 - AM DIST Line AP and FY
1 San Luis Obispo AM SQR SLOFS009 Asset Management Processes Load AM Transactions (SLOAM997.SQR). Update
Before conversion to Peoplesoft,
the property office had a monthly
Property Accounting Status Report
that listed the inventory value along
with the adds/deletes for the
month. A report was designed to
mimic the old property report and
1 San Luis Obispo AM SQR SLOFS006 Asset Management Reports Property Accounting Status Report incorporate addition Reporting Session
29adc070-b05f-449f-878a-517ba5a30fc2.xls 71 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
The delivered Retirement
Information Reports(AMRT2000 &
AMRT2010) do not meet the needs
of the Cal Poly property office. The
report was modified to sort by Tag
Number and include PSR #, PSR
Date, Survey, Department and
Department Description. This new
crystal report will be available along
1 San Luis Obispo AM Crystal SLOFS006 Crystal Report Update Project Retirement Information/Activity Report with the delivered reports. AM09003 - Property Survey Report
The delivered Physical Inventory
List (AMDE4002) crystal report
does not adequately meet the
needs of the Cal Poly property
office. The crystal report was
modified to sort by Department and
include the tag number, location, AM09002 - Physical Inventory Tracking
1 San Luis Obispo AM Crystal SLOFS006 Crystal Report Update Project Physical Inventory Report (Working Copy) location description as well a Report
The delivered Physical Inventory
List (AMDE4002) crystal report
does not adequately meet the
needs of the Cal Poly property
office. The crystal report was
modified to sort by Department and
include the tag number, location,
1 San Luis Obispo AM Crystal SLOFS006 Crystal Report Update Project Physical Inventory Report (Final) location description as well a AM09001 - Physical Inventory Report
An external process to enter
electronically received AP Voucher
data into the AP system exists in
our current AP System. This
process was created so that we
would not lose functionality moving
to the Peoplesoft system In order
to accommodate the external AP
process and allow flexibility at the
Campus level for the use of
PeopleSoft ChartFields, a SLO
chartfield table will be used to
convert external values from our
1 San Luis Obispo AP SQR SLOFS007 Miscellaneous Vendors (ThermUp, AmEx) AP external vendors. AP09009 - AP Voucher Interface
29adc070-b05f-449f-878a-517ba5a30fc2.xls 72 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Before a check run, the vendors
need to be checked for automatic
withholding at the $1500 threshold.
This SQR checks vendors with a
FTB entity/RPT vendor category to
determine if the vendor has
reached the $1500 threshold for
automatic 7% withholding. The
payments for the current calendar
year will be summed and if the total
amount exceeds $1500, the
information will be printed on a
report and the RPT
vendor_category flag should be
changed to WTHD7. This will be
run nightly so the accounts payable
supervisor can create a voucher
prior to the check run to calculate
the additional state tax that needs
to be withheld. There is also a flag
to reset the flags from
FTB/WTHD7 and IRS/WTHD to
RPT on Jan 1 or the 1st working
1 San Luis Obispo AP SQR SLOFS003 AP 1099 FTB/IRS Status Process AP 1099 FTB/IRS Status Process day after Jan 1. AP09005 - 1099 Misc Report
An external process to enter
electronically received AP Voucher
data into the AP system exists in
our current AP System. This
process was created so that we
would not lose functionality moving
to the Peoplesoft system In order
to accommodate the external AP
process and allow flexibility at the
Campus level for the use of
PeopleSoft ChartFields, a SLO
chartfield table will be used to
convert external values from our
1 San Luis Obispo AP SQR SLOFS007 AP Interface Process AP Voucher Load Process AP external vendors. AP09009 - AP Voucher Interface
29adc070-b05f-449f-878a-517ba5a30fc2.xls 73 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
An external process to enter
electronically received AP Voucher
data into the AP system exists in
our current AP System. This
process was created so that we
would not lose functionality moving
to the Peoplesoft system In order
to accommodate the external AP
process and allow flexibility at the
Campus level for the use of
PeopleSoft ChartFields, a SLO
chartfield table will be used to
convert external values from our
1 San Luis Obispo AP SQR SLOFS007 AP Interface Process AP Voucher Interface Definition AP external vendors. AP09009 - AP Voucher Interface
The MICR field has changed for
ACH processing and has been They are not sure if this will work for their Business
1 San Luis Obispo AP Crystal Crystal Report Update Project State Check reflected in the State Check Eliminated Process.
The MICR field has changed for
ACH processing and has been They are not sure if this will work for their Business
1 San Luis Obispo AP Crystal Crystal Report Update Project Wells Fargo Check Copy reflected in the WELLS Check Eliminated Process.
Delivered trial report to minimize
1 San Luis Obispo AP Crystal Crystal Report Update Project AP Payment Trial Register the white spaces AP08002 - AP Trial Register
The MICR field has changed for
ACH processing and has been
1 San Luis Obispo AP Crystal SLOFS501 Crystal Report Update Project Wells Fargo Check reflected in the WELLS Check AP06001 - AP Check Format
An external process to enter
electronically received AP Voucher
data into the AP system exists in
our current AP System. This
process was created so that we
would not lose functionality moving
to the Peoplesoft system In order
to accommodate the external AP
process and allow flexibility at the
Campus level for the use of
PeopleSoft ChartFields, a SLO
chartfield table will be used to
convert external values from our
1 San Luis Obispo AP SQR SLOFS007 GE Mastercard AP external vendors. PO09001 - ProCard
29adc070-b05f-449f-878a-517ba5a30fc2.xls 74 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
An external process to enter
electronically received AP Voucher
data into the AP system exists in
our current AP System. This
process was created so that we
would not lose functionality moving
to the Peoplesoft system In order
to accommodate the external AP
process and allow flexibility at the
Campus level for the use of
PeopleSoft ChartFields, a SLO
chartfield table will be used to
convert external values from our AP99004 - AP Vendor/Voucher
1 San Luis Obispo AP SQR SLOFS007 Library AP external vendors. Interface
An external process to enter
electronically received AP Voucher
data into the AP system exists in
our current AP System. This
process was created so that we
would not lose functionality moving
to the Peoplesoft system In order
to accommodate the external AP
process and allow flexibility at the
Campus level for the use of
PeopleSoft ChartFields, a SLO
chartfield table will be used to
convert external values from our AP99004 - AP Vendor/Voucher
1 San Luis Obispo AP SQR SLOFS007 Pony Prints AP external vendors. Interface
An external process to enter
electronically received AP Voucher
data into the AP system exists in
our current AP System. This
process was created so that we
would not lose functionality moving
to the Peoplesoft system In order
to accommodate the external AP
process and allow flexibility at the
Campus level for the use of
PeopleSoft ChartFields, a SLO
chartfield table will be used to
convert external values from our AP09009 - AP Voucher Interface or
1 San Luis Obispo AP SQR SLOFS007 Office Max AP external vendors. Third Party Interface Document
29adc070-b05f-449f-878a-517ba5a30fc2.xls 75 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
The billing invoice module does not
extend to emailing invoices to a
select specific group(s) of people.
The Print Crystal Report process
has been extended to allow an
email to be sent to a specific
person according to the collector
set up for the customer. Invoices
can also be printed individually, by
collector or by a specific process
instance. The original invoicing
process was very limiting and by
using this process, we can
1 San Luis Obispo AR SQR SLOFS001 Billing Invoice Print Billing Invoices Email/Distribution streamline the invoicing process. Third Party Interface Document
Selected charges recorded within
the Reimbursed Activity Fund are
invoiced each month to external
parties. This mod established
setup tables that define the
customers to be billed and the
necessary information to
automatically generate these
invoices each month. Add an
additional AR Aging report by
collector/customer to aid in the
Reimbursed Activity process
1 San Luis Obispo AR SQR SLOFS011 Billing/Receivables Reimbursed Activity AR Customer Statement (especially useful for auxillaries). BI09003 - Automatic Invoicing
Selected charges recorded within
the Reimbursed Activity Fund are
invoiced each month to external
parties. This mod established
setup tables that define the
customers to be billed and the
necessary information to
automatically generate these
invoices each month. Add an
additional AR Aging report by
collector/customer to aid in the
Reimbursed Activity process
1 San Luis Obispo AR SQR SLOFS011 Billing/Receivables Reimbursed Activity AR Aging by Fund & Account (especially useful for auxillaries). BI09003 - Automatic Invoicing
29adc070-b05f-449f-878a-517ba5a30fc2.xls 76 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Selected charges recorded within
the Reimbursed Activity Fund are
invoiced each month to external
parties. This mod established
setup tables that define the
customers to be billed and the
necessary information to
automatically generate these
invoices each month. Add an
additional AR Aging report by
collector/customer to aid in the
Reimbursed Activity process
1 San Luis Obispo AR SQR SLOFS011 Billing/Receivables Reimbursed Activity AR Aging by Collector/Customer (especially useful for auxillaries). BI09003 - Automatic Invoicing
Selected charges recorded within
the Reimbursed Activity Fund are
invoiced each month to external
parties. This mod established
setup tables that define the
customers to be billed and the
necessary information to
automatically generate these
invoices each month. Add an
additional AR Aging report by
collector/customer to aid in the
Reimbursed Activity process
1 San Luis Obispo AR SQR SLOFS001 Billing/Receivables Reimbursed Activity SQC for billing upload & reimbursed activity process (especially useful for auxillaries). BI09003 - Automatic Invoicing
Selected charges recorded within
the Reimbursed Activity Fund are
invoiced each month to external
parties. This mod established
setup tables that define the
customers to be billed and the
necessary information to
automatically generate these
invoices each month. Add an
additional AR Aging report by
collector/customer to aid in the
Reimbursed Activity process
1 San Luis Obispo AR SQR SLOFS001 Billing/Receivables Reimbursed Activity Billing Reimbursed Activity Process (especially useful for auxillaries). BI09003 - Automatic Invoicing
29adc070-b05f-449f-878a-517ba5a30fc2.xls 77 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Selected charges recorded within
the Reimbursed Activity Fund are
invoiced each month to external
parties. This mod established
setup tables that define the
customers to be billed and the
necessary information to
automatically generate these
invoices each month. Add an
additional AR Aging report by
collector/customer to aid in the
Reimbursed Activity process
1 San Luis Obispo AR SQR SLOFS001 Billing/Receivables Reimbursed Activity Billing Upload Process (especially useful for auxillaries). BI09002 - Billing Upload
The billing invoice module does not
extend to emailing invoices to a
select specific group(s) of people.
The Print Crystal Report process
has been extended to allow an
email to be sent to a specific
person according to the collector
set up for the customer. Invoices
can also be printed individually, by
collector or by a specific process
instance. The original invoicing
process was very limiting and by
using this process, we can
1 San Luis Obispo AR SQR SLOFS001 Billing/Receivables Reimbursed Activity Long version Invoice streamline the invoicing process. BI09001 - Billing Invoice
The billing invoice module does not
extend to emailing invoices to a
select specific group(s) of people.
The Print Crystal Report process
has been extended to allow an
email to be sent to a specific
person according to the collector
set up for the customer. Invoices
can also be printed individually, by
collector or by a specific process
instance. The original invoicing
process was very limiting and by
using this process, we can
1 San Luis Obispo AR SQR SLOFS001 Billing/Receivables Reimbursed Activity Short version Invoice streamline the invoicing process. BI09001 - Billing Invoice
1 San Luis Obispo AR Crystal SLOFS001 Crystal Report Update Project Payment Predictor Detail Report See line 56 Reporting Session
1 San Luis Obispo AR Crystal SLOFS001 Crystal Report Update Project AR Customer Statement See line 56 BI09001 - Billing Invoice
1 San Luis Obispo AR Crystal SLOFS001 Crystal Report Update Project Long version Invoice See line 56 BI09001 - Billing Invoice
29adc070-b05f-449f-878a-517ba5a30fc2.xls 78 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
1 San Luis Obispo AR Crystal SLOFS001 Crystal Report Update Project Short version Invoice See line 56 BI09001 - Billing Invoice
Currently, the IOSTAT Report has
been a part of the FAS Accounting
System for years and has enabled
the accounts receivable
department to keep track of the
reimbursed activity accounts. A
similar process needs to be AR09001 - Reimbursed Activities Status
1 San Luis Obispo AR SQR SLOFS018 Financial Reports Reimbursed Activity Reconciliation developed in Peoplesoft. Report
To enable an allocation to create
the fund balancing record, the
allocation needs to be run to a
temporary allocation record. The
next step of the allocation would
read the temporary record and
create the corresponding fund
1 San Luis Obispo GL SQR SLOFS005 Allocation Record balancing record.
With the implementation of Student
Financials, the BR/Peoplesoft
Cashnet nightly balancing report
needs to be rewritten to combine
the Student Financial data with the
Peoplesoft GL Cashnet feed. This
is replacing the BR CBA140 Cobol
1 San Luis Obispo GL SQR SLOFS012 Cashnet Balancing Cashnet Balancing Report Report Reporting Session Done for disaster recorvery. What is CMS's plan?
Currently, chargeback FAS entries
are written in FOCUS to load FAS
with the summarized chargeback
entries by department. The
FOCUS program also creates a
report that displays the detail
entries by department by
chargeback type. Since Peoplesoft
has the ability to drill down from the
Actuals ledger to the
CSU_ACCTG_LINE file, the SQR
will create a file to load the
CSU_ACCTG_LINE file with the
detail chargeback entries. The
SQR (SLOCBACK) will also
produce a departmental report
similar to the one the departments
1 San Luis Obispo GL SQR SLOFS012 Chargebacks Chargeback import/load for billing upload receive now GL09003 - Charge Back
1 San Luis Obispo GL SQR SLOFS012 Chargebacks Telephone import/load for csu_acctg_line See line 99 GL09003 - Charge Back
1 San Luis Obispo GL SQR SLOFS012 Chargebacks SQC for defining chargeback layouts See line 72 GL09003 - Charge Back
29adc070-b05f-449f-878a-517ba5a30fc2.xls 79 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
1 San Luis Obispo GL SQR SLOFS012 Chargebacks SQC for month end display fields See line 72 GL09003 - Charge Back
To enable Cal Poly to approach
Year-End and fix problems, several
reports are needed to evaluate the
fiscal year entries before closing
the year. Several Year end reports
were developed and used prior to
8.4. With 8.4, modification needed
to be made to the existing
1 San Luis Obispo GL SQR SLOFS013 Chartfield Delta Reports Chartfield Delta Report programs Reporting Session
Have additional functionality that emails req's that
have been sitting out there for more than 7 days and
1 San Luis Obispo GL SQR SLOFS013 Chartfield Delta Reports Year End Negative Expenditures See line 76 Reporting Session have not been approved.
1 San Luis Obispo GL SQR SLOFS013 Chartfield Delta Reports Year End Variance See line 76 Reporting Session Need ability to email PO's.
A process is needed to validate the
combo edits instituted in finance
with the chartfields in the HR
before the Labor Distribution
1 San Luis Obispo GL SQR SLOFS015 Financial Custom Processes SQC for Financial Accounting System Hdr Process. GL09011 - Combo Edits in HCM
The delivered Peoplesoft Journal
Entry Load Process and the
Journal Entry-Standard Budget
Load Process is too complex for
the average departmental user.
Long Beach wrote a Journal Entry
Load process LBGL008.SQR with
the associated run control panels
which I based our load on. A
budget load process was added
within the same SQR and modified
the run control panel to add budget
specific fields which would then
meet the needs of our
1 San Luis Obispo GL SQR SLOFS015 Financial Custom Processes Journal Upload departmental users. GL05001 - Journal Upload Process
1 San Luis Obispo GL SQR SLOFS015 Financial Custom Processes SQC for combo edit routines See Line 79 GL05001 - Journal Upload Process
There are several Data
Maintenance processes that need
to be run on a weekly/daily basis.
There is no delivered process that
1 San Luis Obispo GL SQR SLOFS015 Financial Custom Processes Data Maintenance meets the needs of this campus. Data Integrity
29adc070-b05f-449f-878a-517ba5a30fc2.xls 80 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
An external process (Cashnet
System cashiering system) needs
a process developed to import the
valid chartfield values in order to
validate chartfield values. This
SQR was written to extract the
chartfields in a format as defined
by the cashnet system designers.
Needed in order to integrate the
1 San Luis Obispo GL SQR SLOFS016 Financial Custom SQRs SQC for Chartfield routines cashnet system to Peoplesoft. Third Party Interface Document
1 San Luis Obispo GL SQR SLOFS016 Financial Custom SQRs SQC for Error Processing See line 87 Third Party Interface Document
1 San Luis Obispo GL SQR SLOFS016 Financial Custom SQRs HR/SF/Speedchart Combo Edit Validation See line 82 GL09011 - Combo Edits They could eliminate the 1099 tables from users.
An external process (Cashnet
System cashiering system) needs
a process developed to import the
valid chartfield values in order to
validate chartfield values. This
SQR was written to extract the
chartfields in a format as defined
by the cashnet system designers.
Needed in order to integrate the
1 San Luis Obispo GL SQR SLOFS016 Financial Custom SQRs Cashnet Chartfield Load cashnet system to Peoplesoft. FS99001 - General Ledger Interface
Modify CSUGL012 SQR to add
summary option (CSV File creation
for all Business Units and all SCO
Funds). This will enable the
Accounts Payable department to
use the file as a reconciliation tool
1 San Luis Obispo GL SQR SLOFS016 Financial Custom SQRs Load CSU_ACCT_LN table on a monthly basis. Data Integrity
A series of SQR's need to be
written to transfer amounts
between funds at month end as
defined by our Fiscal Services
accountants in order to do
business per the State of
1 San Luis Obispo GL SQR SLOFS016 Financial Custom SQRs Miscellaneous Course Fee Auto Entry California. Data Integrity
1 San Luis Obispo GL SQR SLOFS016 Financial Custom SQRs SQC for CSU interface See line 83 Data Integrity
29adc070-b05f-449f-878a-517ba5a30fc2.xls 81 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
An SQR will be written to calculate
and load the interest distribution
amount for each investment Fund.
The process will calculate the daily
average balances for Funds with
the FUND_INT attribute and
distributes the interest to the
interest fund as defined in the
FUND_INT attribute value. A report
of the daily average balance for the
period is printed. The interest
information will be located in a CSV
file to be read so that the interest
for the period can be distributed. A
summary report of interest % is
then printed. Using the %, a CSV
file containing the journal
information is then created to post
the interest and reserve amounts
for each interest fund. A report is
also produced detailing the entries.
The SLOGL008 SQR process
(Journal Upload Process) will then GL09009 - Interest Calculation &
1 San Luis Obispo GL SQR SLOFS020 Interest Distribution Interest Distribution be used to load the journal. Distribution
29adc070-b05f-449f-878a-517ba5a30fc2.xls 82 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge
In order to validate the LCD setup Replaced By Comments after talking to campus
in HR, a monthly report to
departmental budget specialists will
be emailed for review. Since email
addresses are maintained in
Finance and for subsequent use of
the Deptid/Email Submission
process for other reports, it was
determined that the appropriate
Peoplesoft environment would be
Finance. An email/deptid setup
page/table was created for multiple
uses. A setid/departmental tree for
a userid/email account will be set
up, then referenced in the
Email/Deptid submission program.
The process (SQR) is also
referenced on the run control to
pass information from the
email/deptid submission program
to the appropriate process. The
process will use the
SLO_RUNCTL_GL run control and
the parameters will be set up using
the STRINGS_TBL for the
appropriate email text and default
tree. The email/deptid submission
process will be used for payroll
report distribution as well as
security validation. The
SLOPAY01.SQR will be updated to
conform to the email/deptid
process. A new report will be
written at a later date for security
1 San Luis Obispo GL SQR SLOFS021 LCD Audit Project Department Email Distribution Process validation and will use the Eliminated
1 San Luis Obispo GL SQR SLOFS021 LCD Audit Project SQC for Department Distribution Process See Line 92 Eliminated
1 San Luis Obispo GL SQR SLOFS021 LCD Audit Project LCD Audit Report See Line 92 Data Integrity
29adc070-b05f-449f-878a-517ba5a30fc2.xls 83 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Currently, the AM330 Report has
been a part of the FAS Accounting
System for years and has enabled
the departments to keep track of
their payroll. A similar process
needs to be developed in
Peoplesoft. The CSU Baseline
development team designed a
reporting table similar to the payroll
tape file that was received for FAS.
Using the HR SYSTEM reporting
table CSU_LABOR_DIST, a payroll
report will be run from finance and
may be used by the individual
1 San Luis Obispo GL SQR SLOFS022 Payroll Report Project Payroll Report departments. GL09007 - HR Labor Distribution
Currently, telephone FAS entries
are formatted from the Pinnacle
telephone system into FAS entries.
Since Peoplesoft has the ability to
drill down from the Actuals ledger
to the CSU_ACCTG_LINE file, the
SQR will create a file to load the
CSU_ACCTG_LINE file with the
detail telephone entries. The SQR
(SLOTELCH) will also produce a
1 San Luis Obispo GL SQR SLOFS014 Telephone Charges Telephone report to verify feed totals. GL09003 - Charge Back
With the implementation of the KK
Ledger with 8.4, a need became
obvious that the accounting dates
and budget dates in Reqs, Pos and
Vouchers needed to be in the
current accounting period or we
would have accounting entries
posting to closed periods. An
Application Engine program will be
written to update the accounting
dates and budget dates to the
1 San Luis Obispo GL SQR SLOFS027 Update Accounting Dates Update Accounting Dates current period for any open items. Use PS Delivered Functionality
1 San Luis Obispo GL SQR SLOFS027 Update Accounting Dates Update Accounting Dates See Line 97 Use PS Delivered Functionality
Delivered report with additional
1 San Luis Obispo PO Crystal Crystal Report Update Project Receiver Property Detail Report fields for asset management Reporting Session
29adc070-b05f-449f-878a-517ba5a30fc2.xls 84 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
A report is generated in
SLONOFNL.LIS file of the possible
PO’s that could be completed by
1 San Luis Obispo PO SQR SLOFS016 Financial Custom SQRs PO/Reqs Invoiced/Not Finalized finalizing the last voucher. Reporting Session
A report is generated in
SLONOINV.LIS file of the received
items on a PO that have not yet
1 San Luis Obispo PO SQR SLOFS016 Financial Custom SQRs PO/Reqs with no invoice been invoiced. Reporting Session
Delivered SQR that were modified PO99011 - Purchase Order Print
1 San Luis Obispo PO SQR SLOFS016 Financial Custom SQRs Dispatch Purchase Order to include our logo Format campus needs more info
Delivered SQR was modified to
1 San Luis Obispo PO SQR SLOFS016 Financial Custom SQRs Requisition Order add detail information PO09004 - Requisition Form
At the present time, we are not
using the Workflow functionality of
Peoplesoft but would like to be able
to notify requisition requestors of
the status of their requisitions
through the Req to PO, dispatch,
change order dispatch, receiving
and payment cycle. An SQR will
be written to send an email on a
daily basis to a requisition
requestor as to any change that
has occurred on their requisition as
it goes to a PO, change order, PO09005 - Req to Check End User
1 San Luis Obispo PO SQR SLOFS024 PO Processes Project SQC for PO Notification receiving and payment. Notification
PO09005 - Req to Check End User
1 San Luis Obispo PO SQR SLOFS024 PO Processes Project PO Notification Process See Line 107 Notification
29adc070-b05f-449f-878a-517ba5a30fc2.xls 85 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
There is no baseline delivered
report that meets current business
requirements. Users require a real
time report that contains all
significant information & activity
related to a Purchase Order (i.e.,
PO Life Cycle). Currently they
must utilize significant amounts of
time to navigate through multiple
panels to obtain this information.
Once the information is found, it
must be manually recorded. Users
frequently require information
related to cancelled lines,
schedules, and distributions that is
not available through online panels.
Significant information & activity
will consist of pre-defined Purchase
Order, Requisition, Receipt,
Voucher, and Payment information
where applicable. Facilitate End
User & Vendor Inquiries, Month
End Close, and Fiscal Year End
1 San Luis Obispo PO SQR SLOFS025 Purchase Order Life Cycle Purchase Order Life Cycle Report Close processes. PO09002 - Purchase Order Life Cycle
This view is used in an allocation
1 San Marcos AM App Designer AM001 AM Allocation View Custom view (SMO_DIST_LN_VW) that is needed for AM. AM09007 - 501 Accounting Entries
This report will be used by the
Asset Accountant to assist in
identifying those purchases that
meet the Capital Asset
Management requirement. From
this report, the Assets that are
identified will be manually entered
into the PS Asset Management
1 San Marcos AM SQR FA001 Fixed Asset Invoice Paid Report SQR report Module. AM09004 - Invoices Paid Report
Used for signatures and tracking of
all checks requiring special handing
such as the need for a person to
1 San Marcos AP Crystal AP009 Check Pickup List Crystal report Pick up a check instead of mailing. AP09006 - Check Pickup List
Lists all checks printed for a
specific check run or by range of
check dates. This report is used to
support bank statement information
1 San Marcos AP Crystal AP008 Check Register Crystal report and reconciliation. AP09002 - AP Check Register
29adc070-b05f-449f-878a-517ba5a30fc2.xls 86 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Needed for travel reimbursement
1 San Marcos AP App Designer AP011 Open Item View Custom View (SMO_VNDR_ITM_VW) processing AP09001 - Open Item Key Setup
ProCard Account Setup Used to load vouchers into PS and
ProCard Account CF Setup pay PROCARD . Allows end user
Load ProCard Extract File to make changes to chartfield
AP16A ProCard Adjustments strings prior to loading into AP
AP16D ProCard Interface to PS AP Setup pages & SQR process to load procard file into (including splitting of charges
1 San Marcos AP AP16C
App Designer / SQR Procard Inquiry PS Finance across multiple CF strings). PO09001 - Procard
Create SM custom check and file
copy format. Redesign Accounts
Payable Check and File Copy
format to include SMCMP &
SMASI logo with address and
phone number and to include
SMCMP and SMASI Check and File Custom check files using basic CMS format with second line for Payee on the
1 San Marcos AP Crystal AP010 Copy business specific changes check. AP06001 - AP Check Format
Used to load petty cash files.
Automate the process of loading
petty cash transactions into the
PeopleSoft Accounts Payable
System. This modification would
use a pre defined file format that
Voucher Load Office Depot (AP015)/ SQR process to load CSV file for petty cash could then be loaded into AP and
1 San Marcos AP SQR AP017 Petty Cash (AP017) replenishment vouchers processed as a voucher. AP09009 - AP Voucher Interface
Used by the Lead to identify any un-
posted invoices for all vouchers at
month end. This Report also
assists AP in verifying vouchers
1 San Marcos AP SQR AP007 Voucher Status Report SQR report needing to be paid will get paid. AP09003 - Voucher Status Listing
Add Cal State San Marcos logo to
delivered AR dunning letters
1 San Marcos AR Crystal AR003 AR Dunning Letter Crystal report (rename to SMO*) AR09004 - Dunning Letter
Map customer IDs to their
1 San Marcos AR App Designer AR001 RA Chartfield to Customer Map Page mod respective program codes. BI09003 - Automatic Invoicing
Used to create new customers for
setting up the surcharge process
(CSUSM does not currently use
1 San Marcos AR App Designer AR001 RA Customer Setup Page mod this feature). BI09003 - Automatic Invoicing
1 San Marcos AR App Designer AR001 RA General Setup Page mod Base setup for RA process. BI09003 - Automatic Invoicing
Employee/student vendor load. This will not answer
the problem. We create permanent vendor records
Invoice setup, used to pick up data for reimbursement to employees and students, using
elements for invoices being build EMPLID as vendor ID. We don't use temp vendor
1 San Marcos AR App Designer AR001 RA Note Setup Page mod thru RA process. BI09003 - Automatic Invoicing IDs.
29adc070-b05f-449f-878a-517ba5a30fc2.xls 87 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
RA setup, CSUSM does not
currently use this feature (no
surcharges charged), but this page
has been retrofitted in case this
1 San Marcos AR App Designer AR001 RA Surcharge Setup Page mod changes in the future. BI09003 - Automatic Invoicing
This feature is to process the
1 San Marcos AR SQR AR001 Reimbursed Activity Process SQR process monthly activity for RA. BI09003 - Automatic Invoicing
Used to upload spreadsheet bills
(CSV files) from campus
1 San Marcos BI SQR AR001 Billing Upload SQR process community into PS Billing module BI09002 - Billing Upload
Print Invoices for both campus &
1 San Marcos BI SQR AR002 Print Portrait Invoices SQR report ASI business units BI09001 - Billing Invoice
Mod for setting up Chargeback
attributes (department receiving the
"payment") and Chargeback codes
Chargeback Attributes (department "paying" for the
Chargeback Code Setup pages & SQR process to load CB files into PS chargeback), custom process for
1 San Marcos GL GL002
App Designer / SQR Chargeback Load Process Finance loading data to GL. GL09003 - Charge Back
Fiscal Authority Lookup. Due to
audit recommendations there
exists a need for monitoring fiscal
authorizations by Department.
Therefore, a Fiscal Authority
lookup by Dept Code chartfield is
required. This table will be used for
Fiscal Operations (General
Accounting, Accounts Payable, and
Purchasing) to verify the person
signing the document has the
1 San Marcos GL App Designer GL005 Fiscal Authority Lookup Bolt on Page / Record authority to sign. GL09001 - Delegation of Authority
CSV file upload for journals,
1 San Marcos GL SQR GL003 GL Journal Upload SQR process, takes CSV file & loads journal data includes combo edit processing GL05001 - Journal Upload Process
Automated way of creating report
1 San Marcos GL SQR NVS01 nVision Maintenance SQR process requests / scope values Reporting Session
Due to audit recommendations
there exists a need for monitoring
fiscal authorizations by Trust Fund.
Therefore, an additional Fiscal
Authority lookup by Fund Code
chartfield is required. This table will
be used for Fiscal Operations
(General Accounting, Accounts
Payable, and Purchasing) to verify
the person signing the document
has the authority to sign for Trust
1 San Marcos GL App Designer GL010 Trust Fund Authority Lookup Bolt on Page / Record Funds. GL09001 - Delegation of Authority
29adc070-b05f-449f-878a-517ba5a30fc2.xls 88 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
FTP dropbox for loading files onto
1 San Marcos Other App Designer GL008 FTP File Page mod UNIX GL09002 - FTP
1 San Marcos PO SQR PO003 Open PO Report SQR report Report of open purchase orders. Reporting Session
Report of open reqs. This is used
1 San Marcos PO SQR PO002 Open Req Report SQR report by end users to track open reqs. Reporting Session
Used for various reporting
requirements including recycling.
This report will be used for State
and Legal reporting requirements
as well as provide a detail analysis
of what is being brought from what
vendor. It will also be used to
identify all PO Activity by Category
1 San Marcos PO SQR PO001 PO Activity by Category Code Report SQR report (NIGP) code. Reporting Session
Management tool to track
1 San Marcos PO SQR PO007 PO Detail Listing by Buyer SQR report purchasing activity by buyer. Reporting Session
1 San Marcos PO SQR PO006 Print Requisition Form SQR report Gives end user ability to print req PO09004 - Requisition Form
Modified baseline popo005 SQR done for business Baseline modified for CSUSM PO99011 - Purchase Order Print
1 San Marcos PO SQR PO005 Purchase order print form needs business needs Format need more info on how this will work for LA
Required to customize for SSU
1 Sonoma AP Crystal Check Crystals Check formats for auxiliaries and CMP CMP and Auxiliaries AP06001 - AP Check Format
Easier to read report for Receiving PO09003 - Receipt Delivery Detail
1 Sonoma AP SON_5030.RPT Receipt Delivery Reports for receiving office Office Report
Ap Technician Report shows detail breakdown by Shows Perfromance and timing of
1 Sonoma AP SQR sonap005.SQR = AP Tech Report technician workload by employee Reporting Session
Breaks down checks printed with a
AP Check Register, breakdown report for checks variety of report prompts for use by
1 Sonoma AP Crystal sonap007 printed all business units AP09002 - AP Check Register
for reporting to the EDD
withholding vendors that earn $600
or more per year. Used to meet
1 Sonoma AP SQR sonap021.SQR CAEDD Vendor Import for state reporting Auxiliary reporting Reporting Session
Clear breakdown of PO Activity
1 Sonoma AP Crystal SONPO008.rpt AP/PO Summary Report for AP with tax breakdown Reporting Session
The delivered CSU report has
hardcoded attributes that needed
to be removed in this report to fully AR02001 - AR Aging by Fund and
1 Sonoma AR SQR sonar001.SQR AR Aging by Fund/Account access all information Account Report
Changed the display of the billing
Customized AR Detailed Billing Invoice - Header & invoice to accommodate
1 Sonoma BI Crystal SONINV03.rpt Line notes & summary requirements of vendors BI09001 - Billing Invoice
Changed the display of the billing
Customized AR Detailed Billing Invoice - 1 Line invoice to accommodate
1 Sonoma BI Crystal SONINV05.rpt Rollup, Line Note only requirements of vendors BI09001 - Billing Invoice
29adc070-b05f-449f-878a-517ba5a30fc2.xls 89 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
Changed the display of the billing
Customized AR Detailed Billing Invoice - IDL NDI invoice to accommodate
1 Sonoma BI Crystal SONINV06.rpt Invoice. Multiple Cred requirements of vendors BI09001 - Billing Invoice
View built into PS to allow for
single sign-on (LDAP
1 Sonoma Other son_ldap_dept_v local view developed to allow for LDAP authentication Authentication) Security Related
Customize the delivered PO Form PO99011 - Purchase Order Print brings handling code over. How will CFS solution do
1 Sonoma PO SQR popo005.SQR = POrder Form Purchase Order Form to make it SSU specific Format this?
Customized report to show
additional detail as required by
1 Sonoma PO SQR SONAP502 AP/PO Summary Report for PO Procurement Office Reporting Session
1 Stanislaus AP Crystal CHECK Modified delivered form to be campus specific To make check campus specific AP06001 - AP Check Format
To facilitate processing student
financial aid checks and ACH
1 Stanislaus AP SQR Load Refund File from SF (STAAP19B) Load student refund file from SF through AP FS99004 - Vendor/Voucher Interface
Electronic load of OfficeMax AP09009 - AP Voucher Interface or
1 Stanislaus AP Using PeopleSoft EDI processing Office Max to AP Upload monthly OfficeMax Statement into AP invoice to save data entry time Third Party Interface Document
1 Stanislaus AR Crystal BIPRNT00 Modified delivered form to be campus specific To make invoice campus specific BI09001 - Billing Invoice
To assure that budget checking
posts to correct accounting period
if changes are made and to assist
Transactions are not posting to proper period. This data entry for changes (user
process rolls the accounting date at the end of each doesn't need to remember to
1 Stanislaus GL SQR AP/PO EOM Roll (STAAP001) period. change accounting date(s)) Use PS Delivered Functionality
Data Warehouse Extract (STAGL002 &
1 Stanislaus GL SQR STAGL005) Extract data file for campus Data Warehouse To facilitate easier local reporting Third Party Interface Document
Campus built views to use with Data Warehouse To build data warehouse referred
1 Stanislaus Other Stanislaus Views - DW feeds Extract process (SQL) above Third Party Interface Document
29adc070-b05f-449f-878a-517ba5a30fc2.xls 90 of 94
Campus Modification Log Cross Reference to CFS Modifications
Technology
Campus Name Module Used Mod Project # Modification Name Modification Description Business Challenge Replaced By Comments after talking to campus
29adc070-b05f-449f-878a-517ba5a30fc2.xls 91 of 94
CFS Implementation Project - Campus Modifications
Column Definitions
Campus Name - Select your campus name
Module - Select the PS Module your modification applies to
Technology Used - Specify. Ie: SQR, Crystal, nVision, PeopleCode, Pages
Mod Project # - The Project # your modification is under at CMS
Modification Name - The name of your modification
Modification Description - What the modification does
Business Challenge - Why this modification was done. Ie: What is it used for? What Business Process does it support? Etc.
Real Time Req'd - Select Yes or No
Process Frequency - Select the frequency of how often the modification is used
Type - Select the Type of the modification
Classification - Select the Classification of the modification.
Please Provide the following supporting documentation:
Print screen of the custom page
Report sample
Print screen of the Run Control Criteria
Any other document such as user guides, mod instructions that would assist the team in understanding the mod
return to: gforman@calstate.edu
cc: chris.xanthos@csun.edu
Allocation process for Asset Management requires a temp
table to be created to store the Asset management data. The
record view is also required to be built for this allocation Process Asset Management
Long Beach AM Records LB9_AM_JOE LB9_AM_JOE process. activity Yes Monthly Other Other
This program provides a report
of posted payments to be used
by the Accounts Payable
This program provides a report of posted payments to be used department as a reconciliation
LBAP001 - AP by the Accounts Payable department as a reconciliation tool tool and to facilitate month end
Page, Record, Posted and to facilitate month end closing by ensuring all payments closing by ensuring all payments
Long Beach AP SQR LB8_AP_AP001 Payment Report have been posted. have been posted. Yes Monthly Report - Recon Reporting
This program provides a report
of performance measures used
by the Accounts Payable
department to evaluate
Page, SQR, LBAP005 - AP This program provides a report of performance measures used technician performance and
Record, Technician by the Accounts Payable department to evaluate technician respond to Best practice
Record Performance performance and respond to Best practice surveys. surveys. Report -
Long Beach AP PeopleCode LB8_AP_AP005 Report No Ad Hoc Operations Reporting
LBAP006 - AP This program prints remit vendors, vendor names, check
Page, Query, Check Pickup numbers, and payment dates for a specified range of payment Log signed by end users when Report - AP06001 - AP
Long Beach AP Record, Crystal LB8_AP_AP006 List dates picking up checks Yes Daily Operations AP Checks Check Format
Print check register with the following information: bank code,
LBAP007 - AP payment method, check number, payment date, vendor name,
Page, Query, Check Register payment handling code, and payment amount within a Used to identify special handling Report - AP06001 - AP
Long Beach AP Record, Crystal LB8_AP_AP007 Report specified payment date range. of checks Yes Daily Operations AP Checks Check Format
Page, Crystal ,
Query, Record, LBAP009 - AP This program prints voucher open items including the following AP05004 - AP
Record Open Items fields - Vendor ID, vendor name, voucher ID, voucher distrib Report - Open Items
Long Beach AP PeopleCode LB8_AP_AP009 Report line number, and amount, accounting date NO Longer being used Yes Ad Hoc Operations Other Listing
This program generates Accounts Payable Detail with a
Department/Fund/Account/Journal Id sort and totals.
LBAP015 - AP It will support the GL Journal Entry Detail by Department
Page, SQR, Detail Activity report. Used by end users to monitor Report - End
Long Beach AP Record LB8_AP_AP015 by Dept activity Yes Ad Hoc User Reporting
This program provides a report
to identify Vendors who have
reached $1500 for state
LBAP016 - AP This program provides a report to identify Vendors who have withholding purposes.This report
Page, Record, Voucher YTD reached $1500 for state withholding purposes.This report is is used by the Accounts Payable Report -
Long Beach AP SQR LB8_AP_AP016 Report used by the Accounts Payable department. department. No Ad Hoc Operations Other AP09003
LBAP018 - AP This program reports journal ID's for posted vouchers. It also
Posted Voucher provides vendor information, payment due dates, and voucher
Rpt - Journal ID amounts. This report is needed as a reconciliation tool for the
Page, Record, for AP posted Account Payable. It will help with the closing of Month End by Used by A/P to monitor Report -
Long Beach AP SQR LB8_AP_AP018 vouchers ensuring all Vouchers have been posted in Accounts Payable. processing Yes Monthly Operations Other
LBAP102 -
Page, SQR, CSULB
Record, standard Load electronic invoices in
Record electronic Load electronic invoices in CSULB standard electronic invoice CSULB standard electronic AP06001 - AP
Long Beach AP PeopleCode LB8_AP_AP102 invoice to AP format into AP vouchers. invoice format into AP vouchers. Yes Ad Hoc Interface - In AP Checks Check Format
LBAP103 - Speed Types used by campus to Third Party
Load Speed identify chartfields for Office Max Interface
Long Beach AP Page, SQR LB8_AP_AP103 Types to AP Load speed types from a flat file into Speed Type table. purchases Yes Ad Hoc Interface - In Other Document
LBAP105 - Convert weekly Office Max AP09009 - AP
Page, Record, Office Max to Convert weekly Office Max electronic invoices into CSULB electronic invoices into CSULB Voucher
Long Beach AP SQR LB8_AP_AP105 AP standard invoice interface. standard invoice interface. Yes Weekly Interface - In AP Checks Interface
LBAP108 - Load weekly CSULB Library Third Party
Page, SQR, CSULB Library Load weekly CSULB Library electronic invoices into AP electronic invoices into AP Interface
Long Beach AP Record LB8_AP_AP108 to AP vouchers. vouchers. Yes Weekly Interface - In AP Checks Document
Page, SQR, Convert monthly GE Procard
Record LBAP109 - GE Convert monthly GE Procard electronic invoices into CSULB electronic invoices into CSULB PO09001
Long Beach AP PeopleCode LB8_AP_AP109 Procard to AP standard invoice interface. standard invoice interface. Yes Monthly Interface - In ProCard ProCard
LBCHK3 - This program produces CSULB
Check print This program produces CSULB check print Crystal Report - check print Crystal Report - Report - AP06001 - AP
Long Beach AP program Wells Fargo Bank Wells Fargo Bank Yes Daily Operations AP Checks Check Format
LBAP111 -
extract file for
the Imaging AP This the program creates and ftp's an extract file for the Data needed by imaging system
Long Beach AP Page, SQR LB8_AP_AP111 204 forms Imaging AP 204 forms to index images of 204 forms No Ad Hoc Other Imaging
This program reads a text file created by HRSA
LBSF0748.SQR
(CS_Link) and updates Student vendors' Populates information needed
LBGL601 - PS_VENDOR.OLD_VENDOR_ID with student campus IDs. A by Financial Aid disbursements
Import Student PS query is then used to report office to respond to students
Long Beach AP Page, SQR LB8_GL_GL601 Campus IDs student's refund information for Disbursements Office. requests about refunds Yes Daily Interface - In Student IB
Related docs
Other docs by HC120708063332
