Search
Controller's Division
 
OUS Logo

Banner Data Standards Information


OWAG Only

(Click on any column heading to resort)
Object Name Object Title Version  
No.
Module  
Code
Date of Last OUS  
Modification
Type Function  
Category
ALTER_GWBMODS ALTER GWBMODS TABLE SQL SCRIPT 6.0.A MISC 12-MAY-04 SQL DB OBJECTS
BMS_TO_OUS_DAILY PEBB-TO-OUS DAILY FEED 8.3.A PAYROLL COM HR PROC
BS_CLOSE CLOSE BANK SUMMARY PERIOD 8.7.A CHKREC 12-JAN-13 SQL
CHKLOAD LOAD STALE CHECKS TO 5TH SITE INSTITUTIONS 8.7.A CHKREC 12-JAN-13 SHL
CK_RECON 2.1.11.A ACCTS PAY CTL DB OBJECTS
CREATE_FWBBSDP CREATES TABLE FWBBSDP 3.1 BANKSUM SQL DB OBJECTS
CREATE_FWBBSDP_INDEXES 2.1.11.A ACCTS PAY SQL DB OBJECTS
CREATE_FWBBSST CREATES BANK SUMMARY FWBBSST TABLE 3.1 BANKSUM SQL DB OBJECTS
CREATE_FWBCKRC_INDEXES 2.1.11.A ACCTS PAY SQL DB OBJECTS
CREATE_GWBRELS CREATES TABLE GWBRELS 6.0.A MISC 12-MAY-04 SQL DB OBJECTS
CREATE_GWVSTAT CREATES TABLE GWVSTAT 6.0.A MISC 12-MAY-04 SQL DB OBJECTS
CREATE_PWVEBIO CREATES A VIEW OF PWBEBIO TABLE 7.2.A AGGREGATE SQL DB OBJECTS
FIS_AGGR_IMPORT AGGREGATE IMPORT 4.2.A AGGREGATE 04-APR-01 COM UTILITY
FIS_AGGR_PRE_IMPORT AGGREGATE PRE-IMPORT 4.2.C AGGREGATE 20-JUL-01 COM UTILITY
FWAFEDH OWAG II JV FEED HISTORY 8.9.A AGGREGATE FMB
FWAGRNT SPECIAL GRANT MAINTENANCE FORM FOR OWAG 8.0.A AGGREGATE 08-MAY-10 FMB
FWAMODU OUS Mods University Update Form 2.1.11 MISC 18-JUN-98 FMB
FWAMODU OUS Mods University Update Form 3.1.A MISC 17-DEC-98 FMB
FWATEXT IIT Text Entry 8.3.A IIT 08-MAY-10 FMB FIS FORMS
FWIAFAH AGGREGATE FLATTENED ACCT HIERARCHY QUERY 8.3.A AGGREGATE 08-MAY-10 FMB
FWIAFFH AGGREGATE FLATTENED FUND HIERARCHY QUERY 8.3.A AGGREGATE 08-MAY-10 FMB
FWIAFPH AGGREGATE FLATTENED PROG HIERARCHY QUERY 8.3.A AGGREGATE 08-MAY-10 FMB
FWIDEPH BUILDING DEPRECIATION HISTORY FORM 5.2.B FIXEDASSET FMB
FWIIIDQ IIT Document List of Value Query 8.3.A IIT 08-MAY-10 FMB
FWIIITD Inter-institutional JV History Query 8.3.A IIT 08-MAY-10 FMB FIS FORMS
FWIMODS 2.0.5.A MISC INP
FWIMSUM 2.0.5.A MISC INP
FWITBSR TRIAL BALANCE SUMMARY BY PERIOD 8.0.0.1.A GEN ACCTG 08-MAY-10 FMB
FWMATHC Aggregate Flattened Acct Hierarchy Update 8.3.A AGGREGATE 08-MAY-10 FMB
FWMBSAD BANK SUMMARY -- C.O. ADD DEPOSITS 8.3.A ACCTS REC FMB
FWMBSDP BANK SUMMARY INSTITUTIONAL DEPOSIT ENTRY(FOR OWAG USE ONLY) 8.3.A ACCTS REC 08-MAY-10 FMB FIS FORMS
FWMBSIA BANK SUMMARY -- C.O. INSTITUTIONAL ADJUSTMENTS 8.3.A ACCTS REC 08-MAY-10 FMB
FWMBSMT Bank Summary Maintenance (CO Only) 8.3.A ACCTS REC 08-MAY-10 FMB
FWMBSSA BANK SUMMARY -- C.O. STATE TREASURY ADJUSTMENTS 8.3.A ACCTS REC 08-MAY-10 FMB
FWMCHKR Check Reconciliation Maintenance (CO Only) 8.3.A CHKREC FMB
FWMFDHC Aggregate Flattened Fund Hierarchy Update 8.3.A AGGREGATE 08-MAY-10 FMB
FWMORHC Aggregate Flattened Orgn Hierarchy Update 8.3.A AGGREGATE 08-MAY-10 FMB
FWMPGHC Aggregate Flattened Prog Hierarchy Update 8.3.A AGGREGATE 08-MAY-10 FMB
FWPAGGE AGGREGATE EXPORT FROM INSTITUTIONS 8.7.A AGGREGATE 12-JAN-13 SHL
FWPAGGI AGGREGATE IMPORT TO OWAG 8.7.A AGGREGATE 12-JAN-13 SHL
FWPAGMP AGGREGATE IMPORT PRE-PROCESSOR 4.2.A AGGREGATE 04-APR-01 COM UTILITY
FWPFDHK SWEEP IIJV TRANSACTIONS TO INSTITUTION GURFEED TABLE 5.4.A IIT SQL DB OBJECTS
FWPTRED TREASURY DEPOSITS LOAD 8.7.A CHKREC 12-JAN-13 SHL
FWPTREK TREASURY CHECKS LOAD 8.7.A CHKREC 12-JAN-13 SHL
FWRAGBU Aggregate Budget Extract 8.0.A AGGREGATE 08-MAY-10 PC
FWRAGMP AGGREGATE IMPORT 8.0.A AGGREGATE PC FIS FEEDS
FWRAGOR OPAL LEDGER DOWNLOAD FROM OWAG 8.0.A AGGREGATE 08-MAY-10 PC
FWRBDLM BUILDING PROJECTS BY LIMITATION 8.0.A GEN ACCTG 08-MAY-10 PC
FWRBDLR BUILDING PROJECTS LIMITATIONS RESERVE REPORT. 8.0.A GRANTS 08-MAY-10 PC
FWRBDLW BUILDING PROJECTS NEGATIVE CASH BALANCE REPORT 8.0.A FIXEDASSET 08-MAY-10 PC
FWRBSAD BANK SUMMARY -- C.O. ADD DEPOSITS 3.1.B BANKSUM PC
FWRBSADJ State Treas/Inst. Adjustments 8.0.A BANKSUM 08-MAY-10 PC
FWRBSCCD Computation Of Cash Deposits 8.0.A BANKSUM 08-MAY-10 PC
FWRBSDL Create Deposits Download File 8.0.B BANKSUM 16-SEP-10 PC
FWRBSDP BANK SUMMARY INSTITUTIONAL DEPOSIT REPORT 8.0.A BANKSUM 08-MAY-10 PC
FWRBSIA BANK SUMMARY -- C.O. INSTITUTIONAL ADJUSTMENTS 3.1.B BANKSUM 12-APR-99 PC
FWRBSIUA Unmatched Institution Deposits 8.0.A BANKSUM 08-MAY-10 PC
FWRBSMIA Matched Individual Amounts 8.0.A BANKSUM 08-MAY-10 PC
FWRBSSA BANK SUMMARY -- C.O. STATE ADJUSTMENTS 3.1.B BANKSUM 12-APR-99 PC
FWRBSSAB Daily State Suspense Acct Bal 8.4.A BANKSUM 06-MAY-11 PC
FWRBSSMD Matched State Treasury Deposit 8.0.A BANKSUM 08-MAY-10 PC
FWRBSSUA Unmatched State Deposits - Amt 8.0.A BANKSUM 08-MAY-10 PC
FWRBSTBD TOTAL STATE/INST. BANK DEPOSIT 8.0.A BANKSUM 08-MAY-10 PC
FWRBSUD Unmatched Deposits Report 8.0.A BANKSUM 08-MAY-10 PC
FWRBSUDE Unmatched Deposit Errors 8.0.A BANKSUM 08-MAY-10 PC
FWRCKCC QUESTIONABLE CHECKS REPORT 8.5.A CHKREC 24-OCT-11 PC
FWRCKRR Check Reconciliation Release 8.0.A CHKREC 08-MAY-10 PC
FWRCSHPA Aggreg. Cash Position Monthly 8.0.A GEN ACCTG 08-MAY-10 PC
FWRFEDR FEDERAL REVENUE/EXPENDITURE REPORT BY CFDA, FTYP=31 8.4.A GRANTS 10-JUN-10 COM
FWRIIJV PRINT IIT JV WITH/WITHOUT TEXT 8.0.A IIT 08-MAY-10 PC FIS RPTS
FWRLIST 5TH SITE SPOOL LIST 8.7.A GEN ACCTG SHL GEN PROC
FWRNEXC NON-EXCHANGE REVENUE DOWNLOAD 8.0.A GRANTS PC
FWROUSC OUS FINANCIAL COGNOS DOWNLOAD 8.9.B AGGREGATE SHL
FWROUSF OUS FINANCIAL DOWNLOAD 8.9.A GEN ACCTG 14-NOV-13 PC
GWAMODS SOFTWARE MODIFICATIONS FORM 8.2.A MISC 08-MAY-10 FMB GEN FORMS
GWARELS BANNER RELEASE NUMBER INFORMATION FORM 8.2.A MISC 08-MAY-10 FMB GEN FORMS
GWAUACS USER ACCESS FORM FOR GWAMODS 8.2.A MISC 08-MAY-10 FMB GEN FORMS
GWF_CENTER_STRING STORED FUNCTION TO CENTER STRING IN A FIELD 3.1.A PAYROLL 26-AUG-99 SQL DB OBJECTS
GWIMODH MODIFICATION HISTORY INFORMATION FORM 8.3.A MISC 01-JUN-10 FMB GEN FORMS
GWKVPDB0 VPD PACKAGE HEADER 6.0.A PAYROLL 03-MAY-04 SQL DB OBJECTS
GWP_PAGE_HEADER STORED PROCEDURE TO GENERATE REPORT HEADERS 3.1.A PAYROLL 26-AUG-99 SQL DB OBJECTS
GWRMODL OUS MODIFICATION OBJECT DESCR/CHECKLIST 8.1.A MISC 08-MAY-10 PC OTHER RPTS
GWRMODS MODULE MAINTENANCE/CHANGE MANAGEMENT REPORT 8.1.A GENERAL 08-MAY-10 PC
GWUOLIB ITS GENERIC SUBROUTINES LIBRARY 5.3.A GENERAL 10-OCT-02 C
GWVFCAT Functional Category Code Validation Table 8.2.A MISC 08-MAY-10 FMB GEN FORMS
GWVINST Institution Type Code Validation Form 8.2.A MISC 08-MAY-10 FMB GEN FORMS
GWVMODL Module Type Code Validation Form 8.2.A MISC 08-MAY-10 FMB GEN FORMS
GWVOTYP OBJECT TYPE CODE VALIDATION FORM 8.2.A MISC 08-MAY-10 FMB GEN FORMS
GWVPRDT Product Type Code Validation Form 8.2.A MISC 08-MAY-10 FMB GEN FORMS
GWVSTAT PROD/DEV STATUS CODE VALIDATION FORM 8.2.A MISC 08-MAY-10 FMB GEN FORMS
IITFEED INTER-INSTITUTIONAL JV PRE-AUDIT 8.9.A GEN ACCTG PC
LOAD_RECON 2.1.11.A ACCTS PAY SQL DB OBJECTS
OSSHELIB GENERIC ROUTINES FOR PRO-C PROGRAMS 5.2.A PAYROLL 11-JUN-02 PC PR RPTS
OUS_TO_BMS_MONTHLY MONTHLY EXTRACT TO BMS 7.3.A PAYROLL 17-MAR-08 COM HR PROC
PEBB_DEFINES PEBB LOGICALS DEFINED 8.3.A PAYROLL 08-MAY-10 COM UTILITY
PROD_UPD_GWBMODS_GWRMODS UPDATE GWBMODS & GWRMODS TABLE 6.0.A MISC 12-MAY-04 SQL DB OBJECTS
PWAACHA ACH AGGREGATION FORM 8.2.A PAYROLL 08-MAY-10 FMB HR FORMS
PWAADDR PWBEBIO ADDRESS CHANGE FORM 8.9.A PAYROLL 31-JAN-14 FMB HR FORMS
PWAVEND VENDOR TABLES MAINTENANCE FORM 8.2.A AGGREGATE 08-MAY-10 FMB
PWF_MASTER_M_PIDM GENERATES MASTER PIDM IN OWAG 2.1.11.A AGGREGATE SQL DB OBJECTS
PWF_PROCESS_MASTER_PIDM PROCESSMASTER PIDM 2.1.11.A AGGREGATE SQL DB OBJECTS
PWIBMSN VIEW NIGHTLY BIO DATA TO P.B. 8.2.A PAYROLL 08-MAY-10 FMB HR FORMS
PWPACHA AGGREGATION OF PHPDIRD FILES FROM ALL INSTITUTIONS.ACH 3.2.B PAYROLL 13-MAR-00 COM UTILITY
PWPACHR ACH AGGREGATION AND REPORT PROCESS 8.2.E PAYROLL 04-OCT-10 PC PR PROC
PWPARCH OWAG PAYROLL TABLES ARCHIVE 8.1.B PAYROLL 08-MAY-10 PC
PWPATOO AGGREGATION PROCESS 8.7.B PAYROLL 05-FEB-13 SHL UTILITY
PWPATOO_ERRORS AGGREGATION PROCESS ERROR CHECKING 7.2.A PERSONNEL 01-APR-08 COM UTILITY
PWPBMSD UPDATE DEPENDENT INFORMATION IN HRDS 8.7.A PAYROLL 26-FEB-13 SHL
PWPBMSO PEBB OPEN ENROLLMENT FILTER 8.9.B PAYROLL PC UTILITY
PWPDEDN UPDATE REFERENCE NUMBERS IN SELECTED PWRDEDN RECORDS 6.0.A PAYROLL 12-AUG-04 PC HR RPTS
PWPGRAB PAYROLL TRANSFER TO OWAG PROCESS 8.5.C PAYROLL 25-MAY-12 PC PR PROC
PWPOSBA RULE AND VALIDATION TABLE LOAD FROM OSBA TO OWAG 8.2.A PAYROLL 12-MAY-10 PC HR PROC
PWPREAD CHECK SECURITY DIGIT 8.3.A PAYROLL 23-FEB-11 PC PR PROC
PWPRVSL ACH REVERSAL PROCESS 8.2.A PAYROLL 12-MAY-10 PC PR PROC
PWPUPRV RULE AND VALIDATION LOAD FROM OSBA TO OWAG 5.2.A PAYROLL 14-MAR-02 COM UTILITY
PWRBMSE BMS-TO-OUS UPDATE 8.7.A PAYROLL 26-FEB-13 SHL
PWRBMSE MONTHLY BMS EXTRACT 8.3.A PAYROLL 17-AUG-11 PC HR PROC
PWRCLAR PERS CLARETY COMPARISON REPORT 8.1.B PAYROLL 08-MAY-10 PC
PWRCTAX CUMMULATIVE TAX REPORT 8.3.A PAYROLL 03-MAR-11 PC
PWRDCHK STANDARDS COMPARISON SQL SCRIPT 5.2.B AGGREGATE 14-DEC-01 SQL HR PROC
PWRDEDN_UPDATE TRIPLE DEDUCTION SPLIT PROCESS 6.1.A PAYROLL 06-JUN-05 SQL
PWREDIV EMPLOYMENT DIVISION STATISTICS REPORT 8.1.B PAYROLL 08-MAY-10 PC HR RPTS
PWRHCFF HCFA REPORT PROCESS 2 OF 2 7.2.C PAYROLL 30-OCT-09 PC PR PROC
PWRHIRE NEW HIRE EXTRACT FOR DEPT OF JUSTICE 8.1.B PAYROLL 08-MAY-10 PC PR PROC
PWRJCRE JOB CHANGE REASON 8.2.A PERSONNEL 12-MAY-10 PC HR RPTS
PWRLEAV BANNER LEAVE REPORT 8.1.B PAYROLL 12-MAY-10 PC
PWRMSDT PERS SUMMARY DATA FOR SALARY BREAKDOWN REPORT 8.3.A PAYROLL 03-DEC-10 PC PR RPTS
PWRMTAX MONTHLY TAX REPORT 8.3.A PAYROLL 03-MAR-11 PC
PWRMULT EMPLOYEES SET UP IN MULTIPLE INSTITUTIONS 7.2.B PERSONNEL 11-NOV-07 COM UTILITY
PWRMULT EMPLOYEES SET UP IN MULTIPLE INSTITUTIONS 7.2.A PERSONNEL 03-JAN-08 SQL HR RPTS
PWROELF CREATES OPEN ENROLLMENT LIFE INSURANCE DATA FORM DATA FILE 8.3.A AGGREGATE 18-AUG-11 PC HR PROC
PWRORCN OWAG RECONCILIATION 8.7.A PAYROLL SHL PR RPTS
PWRORCN OWAG RECONCILIATION 8.5.A PAYROLL 27-SEP-11 PC PR RPTS
PWRORPC OPTIONAL RETIRE PREM CORRECTN 8.3.B PERSONNEL 07-SEP-11 PC HR RPTS
PWROSTA OUT OF STATE AUDIT FILE 8.1.B PAYROLL 08-MAY-10 PC PR PROC
PWRPBIO PERS BIOGRAPHIC FILE LOAD 8.2.B PAYROLL 08-MAY-10 PC
PWRPBYR PEBB BENEFIT YEAR REPORT (2001) 8.1.B AGGREGATE 12-MAY-10 PC HR RPTS
PWRPDMC PWBEBIO ERRORS LOG 8.1.B AGGREGATE 08-MAY-10 PC HR RPTS
PWRPERS PERS FILE FORMAT STARTING JANUARY 2004 8.7.A AGGREGATE 11-JUL-13 SHL
PWRPERS PERS FILE FORMAT STARTING JANUARY 2004 8.7.C AGGREGATE 05-FEB-13 PC
PWRQTAX QUARTERLY TAX REPORT 8.3.A PAYROLL 04-MAR-11 PC
PWRVA01 UNION ASSOCIATE MEMBERSHIP REPORT 8.1.B HRDS AGG 08-MAY-10 PC HR RPTS
PWRVAPP APPLICABLE GROSS COMPARISON REPORT 8.1.B PAYROLL 08-MAY-10 PC PR RPTS
PWRVD01 VENDOR DEMOGRAPHICS & CONTRIBUTION REPORTS 8.7.A PAYROLL 22-JUN-12 PC HR RPTS
PWRVE01 EMPLOYMENT DEPT VENDOR FILE 8.1.B PAYROLL 08-MAY-10 PC HR RPTS
PWRVE02 COPY PWRVE01 FILES TO SALEM 8.5.A PAYROLL 31-JAN-12 COM HR RPTS
PWRVF01 VENDOR FLEX BENEFITS REPORT 8.1.B AGGREGATE 08-MAY-10 PC HR RPTS
PWRVI01 VENDOR INSURANCE REPORTS 8.7.B AGGREGATE 22-MAR-13 PC HR RPTS
PWRVINS INSURANCE VENDOR REPORTS 8.1.B AGGREGATE 08-MAY-10 PC HR RPTS
PWRVP01 PERS WEEKLY REPORT 8.1.B AGGREGATE 08-MAY-10 PC HR RPTS
PWRVP02 VENDOR PERS NOTICE OF ELIBILITY 8.1.B AGGREGATE PC HR RPTS
PWRVP03 PERS ANNUAL REPORT AND LIST 8.1.B AGGREGATE 08-MAY-10 PC HR RPTS
PWRVPBN PEBB BENEFITS DOWNLOAD FILE 8.2.A PAYROLL 08-MAY-10 PC HR PROC
PWRVPBS PEBB VENDOR SUMMARY REPORT 8.1.B PAYROLL 08-MAY-10 PC HR RPTS
PWRVPC1 PEBB CENSUS VENDOR FILE 8.1.B AGGREGATE 08-MAY-10 PC HR RPTS
PWRVPDT PAYROLL DETAIL 8.3.A AGGREGATE 19-AUG-10 PC PR RPTS
PWRVRFN REPORTING TO SOCIAL SECURITY ADMINISTRATION 8.1.B AGGREGATE 08-MAY-10 PC PR RPTS
PWRVSLI STANDARD LIFE INSURANCE REPORT 8.2.A AGGREGATE 08-MAY-10 PC HR RPTS
PWRVT02 TAX DEFERRED INVESTMENT, OPTIONAL RETIREMENT PROGRAM REPORTS 8.8.A AGGREGATE 15-NOV-13 PC HR RPTS
PZR1042 1042 AGGREGATION PROCESS 5.4.B PAYROLL 09-JUN-03 PC PR PROC
PZRPPAY EMPLOYEE SALARY CHANGE REPORT 5.2.A PAYROLL 28-SEP-01 PC PR RPTS
RECON_EDIT 2.1.11.A ACCTS PAY SQL DB OBJECTS
RUN_PWRORCN OWAG RECONCILIATION OPERATIONS SUBMIT COM 7.2.A PAYROLL 10-MAY-07 COM UTILITY
START_TREASURY 2.1.11.A ACCTS PAY COM UTILITY
TREASURY_DEFINES 2.1.11.A ACCTS PAY COM UTILITY
TREASURY_EMAIL 2.1.11.A ACCTS PAY COM UTILITY
TREASURY_LOAD 2.1.11.A ACCTS PAY COM UTILITY
TREASURY_LOAD.COM OBSOLETE IIT COM
TREASURY_PURGE_PLUS 2.1.11.A ACCTS PAY COM UTILITY
UPDATE_INST_CODE_GWBMODS UPDATE GWBMODS TABLE SQL SCRIPT 6.0.A MISC 12-MAY-04 SQL DB OBJECTS
OUS Index Contacts
 
Contact: Controller's Division
cdwebmaster@ous.edu - (541) 737-3636
©Oregon University System, 2006