Docstoc

Fast Finance Auto Sales - DOC

Document Sample
Fast Finance Auto Sales - DOC Powered By Docstoc
					                  LOCAL SQR’S TO SUPPORT FINANCE

sloactrm.sqr - Kathy Anderson – 7/31/2001
    Project Name: SLO_FS_REIMB_ACT (Originally SLO_REIMB_ACT)
    Contact Person: Kathy Anderson
    Process: Reimbursed Activity Process
    Creates Transactions to BR, PS, Report and Invoices
    Date Last Updated: 06-13-2003

sloactye.sqr – Kathy Anderson – 6/13/2002
    Project Name: SLO_FS_REIMB_ACT (Originally SLO_REIMB_ACT)
    Contact Person: Kathy Anderson
    Process: Reimbursed Activity Process for Year End
    Create Transactions to BR, PS, Report and Invoices
    Date Last Updated: 06-13-2003

sloap019.sqr – Kathy Anderson – 3/12/2001
    Project Name: SLO_FS_CUSTOM_SQRS (Originally SLO_CUSTOM_SQRS)
    Contact Person: Kathy Anderson
    Process: Student Vendor Voucher
    Student Vendor/Voucher Feed from SIS (SLO version of CSUAP019)
    Date Last Updated: 01-07-2002

sloaudit.sqr – Kathy Anderson – 7/18/2002
    Project Name: SLO_FS_ADMIN_RPTS (Originally SLO_ADMIN_RPTS)
    Contact Person: Kathy Anderson
    Process: Data Integrity Audit
    This program validates the data between 1)Ledger-Journal 2)HR Acctg
    Lines/Journal 3) CSU Acctg Lines/Journal 4) Vchr Acctg Lines/Journal 5) PO
    Acctg Lines/Journal 6) Req Acctg Lines/Journal 7) Vchr Distrib/Vchr Acctg
    8) PO Distrib/PO Acctg 9) Req Distrib/Req Acctg.
    Date Last Updated: 07-23-2003

sloauto1.sqr – Kathy Anderson – 3/10/2001
    Project Name: SLO_FS_CUSTOM_SQRS (Originally SLO_CUSTOM_SQRS)
    Contact Person: Kathy Anderson
    Process: Auto Entry Series #1
    Auto Entry 9-To charge the administrative allowance of 6% of the monthly
    fees collected in the Alumni Placement Fee Account.
    Date Last Updated: 07-08-2002

sloauto2.sqr – Kathy Anderson – 3/11/2001
    Project Name: SLO_FS_CUSTOM_SQRS (Originally SLO_CUSTOM_SQRS)
    Contact Person: Kathy Anderson
    Process: Auto Entry Series #2
    Auto Entry 13-To charge the administrative expenses for current month
    activity in trust accounts for the Health Center
    Auto Entry 14-To charge the administrative expenses for current month
    activity in trust accounts for Mustang Daily
    Auto Entry 15-To charge the administrative expenses for current month
    activity in trust accounts for the Drama
    Auto Entry 19-To transfer the collections of sales tax on Health    Center
    Invoices to the General Fund sales tax liability account.
    Auto Entry 25-To transfer the payroll clearing amount in trust accounts to
    the cash account, then move to the Trust remittance fund
    Auto Entry 26-To transfer the FB Clearing-PFA account in trust accounts to
    the cash account, then move to the Trust remittance fund
    Parking Cash Sweep-To transfer cash balance from MU001,MV001 to MT001-
    operating fund account
    Date Last Updated: 05-28-2003
sloauto3.sqr – Kathy Anderson – 3/12/2001
    Project Name: SLO_FS_CUSTOM_SQRS (Originally SLO_CUSTOM_SQRS)
    Contact Person: Kathy Anderson
    Process: Auto Entry Series #3
    Auto Entry 10-To move trust fund positive cash balances to the associated
    investment fund and move investment fund amounts to replace negative trust
    fund cash balances
    Date Last Updated: 02-18-2003

sloautom.sqr – Kathy Anderson – 3/12/2001
    Project Name: SLO_FS_CUSTOM_SQRS (Originally SLO_CUSTOM_SQRS)
    Contact Person: Kathy Anderson
    Process: Auto Entry for Miscellaneous Course Fees
    MCF budget transfer for fees collected to fund CRXXX by depts
    Date Last Updated: 03-06-2003

slocback.sqr – Kathy Anderson – 04/03/2001
    Project Name: SLO_FS_CHARGEBACKS (Originally SLO_CHARGEBACKS)
    Contact Person: Kathy Anderson
    Process: Chargeback Process
    This program imports the MAINFRAME.DBF (manipulated by VFP) and saved as a
    fixed format file. The file contains detail (backup) infomation for the
    different types of chargebacks which are: S-Storeroom Supplies;X-Fed X; U-
    UPS; R-Reprographics; P-Postage; T-Transportation; C-Copy Charges; D-Paper
    Reimbursement; F-Facilities; M-Media Services. The file will then be
    summarized by chartfield combination/chargeback type and a CSU_ACCTG_LINE
    import file will be created. A report will be created displaying the
    detail information by department/by chargeback type.
    Date Last Updated: 02-19-2003


slocfld.sqr – Kathy Anderson – 03/19/2002
    Project Name: SLO_FS_AP_INTERFACE
    Contact Person: Kathy Anderson
    Process: Loads BR Combo Data Lookup to PS
    This program loads the BR subcode/PS chartfield values to PS
    Date Last Updated: 03-18-2002

slocfdlt.sqr – Christina Case – 09/16/2001
    Project Name: SLO_FS_CFDLT
    Contact Person: Debbie Brothwell
    Process:
    A report to list the chartfield changes
    Date Last Updated: 05-27-2003

slocfver.sqr – Kathy Anderson – 07/25/2001
    Project Name: SLO_FS_ADMIN_RPTS (Originally SLO_ADMIN_RPTS)
    Contact Person: Debbie Brothwell
    Process:
    Report all undistributed/unposted chartfield values entered on the run
    control panel. This is used to check chartfields prior to inactivating the
    chartfield value
    Date Last Updated: 08-14-2001

slocshld.sqr – Kathy Anderson – 05/07/2001
    Project Name: SLO_FS_CUSTOM_SQRS (Originally SLO_CUSTOM_SQRS)
    Contact Person: Lee Whitmer
    Process: Cashiering
    Selects all valid chartfields and writes to ASCII flat file for subsequent
    processing into the Cashnet system.
    Date Last Updated: 02-26-2001
slodatam.sqr – Kathy Anderson – 08/22/2002
    Project Name: SLO_FS_CUSTOM_PROCESS (Originally SLO_CUSTOM_PROCESS)
    Contact Person: Debbie Brothwell
    Process: Data Maintenance
    Daily Maintenance (nVision table truncate, PO Recon Data Fix)
    Date Last Updated: 08-22-2002

slofs140.sqr – Kathy Anderson – 05/05/2000
    Project Name: SLO_FS_CUSTOM_SQRS (Originally SLO_CUSTOM_SQRS)
    Contact Person: Kathy Anderson
    Process: Interface
    This SQR will load GL interface data to the CSU Accounting Lines Record.
    (based on CSUFS140.SQR)
    Date Last Updated: 03-20-2003

slogl008.sqr – Kathy Anderson – 06/12/2001
    Project Name: SLO_FS_CUSTOM_PROCESS (Originally SLO_CUSTOM_PROCESS)
    Contact Person: Kathy Anderson
    Process: Interface
    This the program reads a CSV file and will load a new Journal based on the
    information in that file, if it passes edits.
    Date Last Updated: 06-13-2002

slohrcev.sqr – Kathy Anderson – 05/07/2001
    Project Name: SLO_FS_CUSTOM_SQRS (Originally SLO_CUSTOM_SQRS)
    Contact Person: Kathy Anderson
    Process: Validate HR Chartfields
    Loads data from HR PS_ACCT_CD_TBL into ps_slo_combo_test, then run combo
    edits against the data
    Date Last Updated: 04-07-2003

slointdb.sqr – Kathy Anderson – 03/27/2002
    Project Name: SLO_FS_INTEREST_DISB (Originally SLO_INTEREST_DISB)
    Contact Person: Kathy Anderson
    Process: Interest Disbursement
    1) Calculate the daily interest for a particular 6th month period
    2) Print a report of the average balance of the Funds to get interest
    3) Import the interest amounts to be disbursed and some variables
    4) Calculate the interest percentage that will be disbursed and print a
    report
    5) Create the PS interest disbursement file to be uploaded to the journal
    6) Print a report of the interest disbursements
    Date Last Updated: 02-12-2003
slonofnl.sqr – Kathy Anderson – 10/15/2002
    Project Name: SLO_FS_CUSTOM_SQRS (Originally SLO_CUSTOM_SQRS)
    Contact Person: Carol Johnston
    Process: AP
    This report matches invoices with PO's and lists PO's/Vouchers that should
    be finalized and are not
    Date Last Updated: 10-15-2002

slonoinv.sqr – Kathy Anderson – 07/05/2002
    Project Name: SLO_FS_CUSTOM_SQRS (Originally SLO_CUSTOM_SQRS)
    Contact Person: Carol Johnston
    Process: PO Received/Not Invoiced Report
    This report matches 3-way match PO's that have been received with
    Vouchers to make sure that all received PO's have been invoiced
    Date Last Updated: 07-19-2002

sloopcls.sqr – Kathy Anderson – 02/27/2001
    Project Name: SLO_FS_CUSTOM_SQRS (Originally SLO_CUSTOM_SQRS)
    Contact Person: Laurie Borello
    Process: Operator/Class Listing
    Selects Operator ID's and their Associated Classes by Primary Class
    Date Last Updated: 02-27-2001

slopay01.sqr – Kathy Anderson – 05/01/2001
    Project Name: SLO_FS_PAYROLL (Originally SLO_PAYROLL)
    Contact Person: Kathy Anderson
    Process: Payroll Feed Transaction List
    This retrieves the payroll feed transactions from HR and sorts and
    displays the information according to the desired sort. The available
    sorts are: 1) Alpha within department 2) Account/Alpha within Department
    3) Workstudy Only for Account/Alpha within Department. The department sort
    uses the DEPTID unless a FUND is assigned to a specific department. Also
    Reimbursed Activity (i.e. FUND=BD%) is sorted by Program/Project with the
    Program description used instead of the department description.
    Date Last Updated: 04-07-2003

slopo100.sqr – Gary Murphy – 05/14/2002
    Project Name: SLO_FS_PO100 (Originally SLO_SLOPO100)
    Contact Person: Debbie Brothwell
    Process: Purchase Order Life Cycle Report
    This program creates a report for Purchasing to review a purchase order
    life cycle.
    Date Last Updated: 03-20-2003

sloponot.sqr – Kathy Anderson – 02/04/2002
    Project Name: SLO_FS_PO_PROCESS (Originally SLO_PO_PROCESS)
    Contact Person: Kathy Anderson
    Process: PO Activity Notification
    Selects the following Activity and sends an email to the requisition
    owner: 1) Req to PO; 2) PO Dispatched; 3) Items Received; 4) Payment
    Received
    Date Last Updated: 05-12-2003

slopyacc.sqr – Kathy Anderson – 06/10/2002
    Project Name: SLO_FS_CUSTOM_PROCESS (Originally SLO_CUSTOM_PROCESS)
    Contact Person: Donna Massicotte
    Process: Payroll Accruals
    This the program reads a CSV file and will create another CSV file to be
    loaded into a reversing Journal via the SLOGL008 Journal Upload Process.
    Date Last Updated: 04-07-2003
slorarcn.sqr – Kathy Anderson - 05/14/2001
    Project Name: SLO_FS_FIN_RPTS (Originally SLO_FIN_RPTS)
    Contact Person: Nancy Reynolds
    Process: Reconciliation of Reimbursed Activities
    This report replaces the FAS focus report IOSTAT. All BD & BF Funds
    associated with a reimbursed program in accounts 5XXXXX and 6XXXXX are
    summarized by Income (BF) and Expenditures (BD) by fund, program, project.
    Totals are displayed by invoice type (i.e. I-System Generated, N-No
    invoice generated and P-PFA Entries) with type as a header for each
    section. Grand totals are displayed by Fund (Fund year).
    Date Last Updated: 11-14-2001

slosam18.sqr – Kathy Anderson – 02/28/2002
    Project Name: SLO_FS_CUSTOM_SQRS (Originally SLO_CUSTOM_SQRS)
    Contact Person: Debbie Brothwell
    Process: Sam18 (AP Open Liability Report)
    This program will read all AP Open Liabilities for Posted and Unposted
    Vouchers and will include those with Posted Partial Payments. (SLO Version
    of CSUGL012.SQR)
    Date Last Updated: 06-05-2002

slotelch.sqr – Kathy Anderson – 05/29/2001
    Project Name: SLO_FS_CHARGEBACKS (Originally SLO_CHARGEBACKS)
    Contact Person: Nancy Reynolds
    Process: Telephone Charge Upload
    This program imports the Telephone Charges created by Pinnacle System as a
    fixed format file. The file will then be summarized by chartfield
    combination and a CSU_ACCTG_LINE import file will be created. A report
    will be created displaying the detail information to be loaded.
    Date Last Updated: 07-22-2003

slovchrs.sqr – Kathy Anderson – 11/15/2000
    Project Name: SLO_FS_AP_INTERFACE
    Contact Person: Kathy Anderson
    Process: AP Interface
    This program interfaces the Electronic invoice files with the PSFT AP
    system. The Interface reads a flat file, which contains Invoice
    information. This application begins by uploading all data on the flat
    file into temporary arrays and then validating the data in the arrays
    against PeopleSoft AP Business Rules. If Validation is successful, AP
    control groups are created and Invoice information is populated into EDT
    tables.
    Date Last Updated: 08-19-2003

sloyenge.sqr – Kathy Anderson – 06/17/2003
    Project Name: SLO_FS_CFDLT
    Contact Person: Debbie Brothwell
    Process: Year End Negative Expenditure Report
    Date Last Updated: 06-17-2003
sloyevar.sqr – Kathy Anderson – 06/19/2003
    Project Name: SLO_FS_CFDLT
    Contact Person: Debbie Brothwell
    Process: Year End Variance Report
    Date Last Updated: 06-23-2003

                  LOCAL SQC’S TO SUPPORT FINANCE

sloceinc.sqc
    Project Name: SLO_FS_CUSTOM_SQRS (Originally SLO_CUSTOM_SQRS)
    Contact Person: Kathy Anderson
    Process: Combo Edit Include File
    Used in slofs140.sqr, slohrcev.sqr and slogl008.sqr
    Date Last Updated: 08-10-2001

slochart.sqc
    Project Name: SLO_FS_CUSTOM_SQRS (Originally SLO_CUSTOM_SQRS)
    Contact Person: Kathy Anderson
    Process: Converts CSU_Account_nbr through the use of the
    SLO_Chartfield_tbl to the PeopleSoft Chartfields.
    Used in sloap019.sqr
    Date Last Updated: 01-09-2001

slodest.sqc
    Project Name: SLO_FS_CUSTOM_SQRS (Originally SLO_CUSTOM_SQRS)
    Contact Person: Kathy Anderson
    Process: This SQC is used by SQRs that will create multiple Files. The SQC
    will determine from the Parameter List of the Process Request the -f
    setting. This is the location where the file will be saved to.
    Used in sloactye.sqr, slosam18.sqr, slopyacc.sqr, sloactrm.sqr,
    slocback.sqr, slointdb.sqr, sloponot.sqr, slopay01.sqr
    Date Last Updated: 08-10-2001

sloedtin.sqc
    Project Name: SLO_FS_CUSTOM_SQRS (Originally SLO_CUSTOM_SQRS)
    Contact Person: Kathy Anderson
    Process: Load Invoice Data into PS EDT Tables
    Used in sloap019.sqr
    Date Last Updated: 01-07-2002

slofahdg.sqc
    Project Name: SLO_FS_CUSTOM_SQRS (Originally SLO_CUSTOM_SQRS)
    Contact Person: Kathy Anderson
    Process: Financial Heading
    Used in slopyacc.sqr, slogl008.sqr, slopo100.sqr
    Date Last Updated: 06-13-2001

slointfc.sqc
    Project Name: SLO_FS_CUSTOM_SQRS (Originally SLO_CUSTOM_SQRS)
    Contact Person: Kathy Anderson
    Process: Validate chartfields
    Used in slofs140.sqr
    Date Last Updated: 04-05-2001
slomoend.sqc
    Project Name: SLO_FS_CHARGEBACKS (Originally SLO_CHARGEBACKS)
    Contact Person: Kathy Anderson
    Process: Formats the Month Ending Date as the prior month end as
    $MonthEndingDate, $AccountingDate as the month end date in the format
    used in the CSU_ACCTG_LINE, #FY as the Fiscal Year to be used in the
    CSU_ACCTG_LINE load, $MonthName to be used as $Ref1 if wanted, $fycode as
    the 3 digit fiscal year code for funds that change by year.
    Used in slonofnl.sqr, slonoinv.sqr, sloaudit.sqr, slocback.sqr,
    slomgtrp.sqr, slorarcn.sqr, slosam6c.sqr, slopay01.sqr, sloactrm.sqr
    Date Last Updated: 01-09-2002

slovchrs.sqc
    Project Name: SLO_FS_AP_INTERFACE
    Contact Person: Kathy Anderson
    Process: Include file for various Voucher Origins Formats and defaults
    used in SLOVCHRS.SQR
    Date Last Updated: 08-19-2003

slovndr.sqc
    Project Name: SLO_FS_CUSTOM_SQRS (Originally SLO_CUSTOM_SQRS)
    Contact Person: Kathy Anderson
    Process: This SQC will load vendor data into PS Vendor Tables.
    Used in sloap019.sqr
    Date Last Updated: 04-16-2002
                  LOCAL SQR’S TO SUPPORT FINANCE

                  (7.5 Version--No Longer Needed)
slofs130.sqr - Kathy Anderson – 5/29/2001
    Project Name: SLO_CUSTOM_SQRS
    Contact Person: Kathy Anderson
    Process: Finance conversion
    SLO mods
    Needs: Remove

Slogl001.sqr – Christina Case – 05/17/2001
    Project Name: SLO_20001115
    Contact Person: Christina Case
    Process: FIRMS
    Firms Derivation
    Needs: Remove in 8.4

Slogl901.sqr – Kathy – 06/24/2001
    Project Name:
    Contact Person: Kelly Carruthers
    Process: HR to Finance
    Temporary for HR 8.0 to FS 7.5
    Needs: Remove in 8.4

slofvndr.sqc
    Project Name: SLO_FS_CUSTOM_SQRS (Originally SLO_CUSTOM_SQRS)
    Contact Person: Kathy Anderson
    Process:Load vendor conversion data
    Used in slofs130.sqr
    Date Last Updated: 01-09-2001
    Needs: Remove in 8.4

slomgtrp.sqr – Kathy Anderson – 11/16/2001
    Project Name: SLO_FIN_RPTS (Not Needed in 8.4)
    Contact Person: Debbie Brothwell
    Process: Departmental SAM6C Report
    This report is based on the FAS SAM06C report, but sorts by Funds
    (selected by the YES node of the DEPT_NVISION tree), then department in
    the department tree. The user will be prompted for the Business Unit,
    Budget Ledger, Fiscal Year, Accounting Period and department node. The
    program produces a report of Account, Budget, Actuals Encumbrace for
    Current Period; Budget, Actuals Encumbrace, and Balance for YTD. The
    report includes Revenue and Expenditures as defined on the ACCOUNT_ROLLUP
    tree.
    Date Last Updated: 02-12-2002
    Needs: Remove in 8.4

slosam6c.sqr – Kathy Anderson – 10/26/2001
    Project Name: SLO_FIN_RPTS
    Contact Person: Debbie Brothwell
    Process: Final Budget Report
    This report replaces the FAS SAM06C report. The user will be prompted for
    the Business Unit, Ledger, Fiscal Year and Accounting Period. The program
    produces a report of Account, Budget, Period to date, YTD, Encumbrance and
    BBA by SCO Fund, CSU Sub Fund, Appropriation info.
    Date Last Updated: 02-14-2002
    Needs: Remove in 8.4

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:7
posted:11/14/2010
language:English
pages:8
Description: Fast Finance Auto Sales document sample