# tblBannerAccessChanges

Description:
Added Query: Allotment Travel - Monthly Allotment Travel: Used to create Rpt


Description:
Added Query: Allotment Travel Month - Monthly Allotment Travel: Used to create Rpt


Description:
Added Query: Allotment Travel YTD - Monthly Allotment Travel: Used to create Rpt


Description:
Added Query: Commodity Issues - Quantity/cost for one selected commodities issued


Description:
Added Query: Federal Awards - Current Rev/Exp Balances: Federal Programs


Description:
Added Query: Federal Matching - Current Rev/Exp Balances: Federal Matching


Description:
Added Query: FGBGENL 00 - Bal Sheet (TBAL) balances: FY00


Description:
Added Query: FGBGENL 01 - Bal Sheet (TBAL) balances: FY01


Description:
Added Query: FGBGENL 02 - Bal Sheet (TBAL) balances: FY02


Description:
Added Query: FGBGENL Indirects/Special Proj - Bal Sheet (TBAL) balances: 13000's and 17000's funds


Description:
Added Query: FGBOPAL 13101 - Rev/Exp balances: Fund 13101


Description:
Added Query: FGBOPAL 13205 - Rev/Exp balances: Fund 13205


Description:
Added Query: FGBOPAL Federal Matching - Rev/Exp balances: Federal programs funds


Description:
Added Query: FGBOPAL FY00 - Rev/Exp balances: FY00


Description:
Added Query: FGBOPAL FY01 - Rev/Exp balances: FY01


Description:
Added Query: FGBOPAL Interdept Sales - Rev/Exp balances: Interdepartment Sales account code


Description:
Added Query: FGBOPAL Revenue - Rev/Exp balances: Fund 13107


Description:
Added Query: FGBOPAL Salaries_Benefits - Rev/Exp balances: Fund 13108


Description:
Added Query: FGBOPAL Special Programs -  Rev/Exp balances: Fund 13109


Description:
Added Query: FGBTRNH 13205 - Detail Rev/Exp Activity: Fund 13205


Description:
Added Query: FGBTRNH 13301 - Detail Rev/Exp Activity: Fund 13301


Description:
Added Query: FGBTRNH 13999 - Detail Rev/Exp Activity: Fund 13999


Description:
Added Query: FGBTRNH Allot Travel Mo - Detail Rev/Exp Activity: Allot. Trav (725001 acct rollup)


Description:
Added Query: FGBTRNH Allot Travel Mo1 - Detail Rev/Exp Activity: Allot. Trav (725001 acct rollup)


Description:
Added Query: FGBTRNH Allot Travel YR - Detail Rev/Exp Activity: Allot. Trav (725001 acct rollup)


Description:
Added Query: FGBTRNH CDIS Rule Code - Detail Rev/Exp Activity: CDIS trans for DFA reporting


Description:
Added Query: FGBTRNH IntraAgency Rev - Detail Rev/Exp Activity: IntraAgency account code


Description:
Added Query: FGBTRNH Print Shop - Detail Rev/Exp Activity: Fund 13304


Description:
Added Query: FGBTRNH Revenue - Detail Rev/Exp Activity: Revenue account codes


Description:
Added Query: FSRISSD One Commodity - Issues for selected commodities


Description:
Added Query: Interdepartmental Sales Totals - Interdepartmental Sales for year end elimination


Description:
Added Query: IntraAgency Revenue Detail - IntraAgency Revenue for Year End


Description:
Added Query: Stores Inventory - Stores inventory - all locations (see Rpt)


Description:
Added Query: Stores Inventory- Not Print Shop - Stores inventory - print shop (see Rpt)


Description:
Added Query: Travel Account Codes - Account codes used for travel


Description:
Added Query: Warehouse Inventory by Comm Code - Stores inventory - warehouse (see Rpt)


Description:
Added Query: Year to Date Transactions 13205 - Detail rev/exp activity - Fund 13205


Description:
Added Query: Year to Date Transactions FY4H - Detail rev/exp activity - FY4H Orgns


Description:
Added Query: Year to Date Transactions Print Shop - Detail rev/exp activity - Fund 13304


Description:
Added Report: rpt:Allotment Travel Monthly - Allotment Travel Budget Report


Description:
Added Report: rpt:Print Shop Inventory by Comm Code - Stores Inventory: Print Shop


Description:
Added Report: rpt:Stores Inventory- Not Print Shop - Stores Inventory: Warehouse/DIT


Description:
Added Report: rpt:Warehouse Inventory - Stores Inventory: Warehouse


Description:
Changed Query: Time to display 24 hour time per Steve Rea's suggestion.


Description:
FGBTRND Query: Restricted to current activity dates after 6/30/00


Description:
PPRCMNT Query: Fix for PPRCMNT_TEXT retrieval error.


Description:
SPRADDR Query(s): Improved current record selection Logic for SPRADDR, SPRADDR Home, SPRADDR Work, SPRADDR Check Mailing Queries


Description:
ORGN Labor Dist Query: removed DISTINCT and added SELECT criteria NBRBJOB_CONTRACT_TYPE = 'P'


Description:
changed option to compact database upon close


Description:
Added Query: NHRDIST - People for Acct via SQL


Description:
NBRJOBS Query - corrected selection of effective dated records


Description:
Titles for Appointment Query: added nbrbjob_contract_type to selected values


Description:
bk - AOS, BP - AOS, BP - Finance Managers Queries: added


Description:
NBRJLBD Query: corrected effective date selection for most current Active records.


Description:
Added Query: Length of Service - Fed, UA, CES


Description:
Budetary Orgn Query: improved selection logic


Description:
example - Annual Salary Query: added PIDM to returned columns


Description:
BAccess Table: Added Control Table for BannerAccess


Description:
Deductions Query: Added Deductions for the period defined by PHRHIST_EVENT_DATE BETWEEN BAccess_Begin_Date AND BAccess_End_Date


Description:
Combined BP and bk versions of AOS_Secretary


Description:
PPRCCMT with PTVCMTY Query: Added Person Coded Comment Repeating Table with Comment Type Validation Table Code Descriptions


Description:
SORDEGR with STVDEGC Query: Added Prior College Degree Table with Degree Code Validation Table


Description:
PEVEMPL with Source Fields Query: Added Employee Information View with names of source fields


Description:
PEVEMPL Query: Removed limit of non-Terminated to match Oracle View as seen from FOCUS or SQL*Plus


Description:
SPRTELE Work Query: Limited to only Primary Phone


Description:
GXRDIRD Query: Added Recipient Direct Deposit Information Table.


Description:
Terminated Employees Query: Added Terminated Employees (PIDMs)


Description:
PEVJOBS with Source Fields: Added PEVJOBS  Employee Jobs Information View with Source Fields


Description:
PEBEMPL Query: Remove all limiting criteria


Description:
NTVDOTT Query: Added Dictionary of Occupational Titles Code (DOTT) Validation Table


Description:
FARDIRD Query: Added Direct Deposit Table


Description:
PERDIRD Query: Added Employee Direct Deposit Repeating Table


Description:
PHRDIRD Query: Added Direct Deposit table to hold amounts from tape


Description:
PHRTDED Query: Added Temporary Deduction Table For Check/Direct Deposit Process


Description:
SPRADDR Query: Changed for From and To Date Logic (WebFor)


Description:
SPRADDR Home Query: Changed for From and To Date Logic (WebFor)


Description:
SPRADDR Check Mailing Query: Changed for From and To Date Logic (WebFor)


Description:
SPRADDR Work Query: Changed for From and To Date Logic (WebFor)


Description:
FRRGRPI Query: Added Grant Personnel Repeating Table


Description:
FGBOPAL Oper Funds Query: Added Operating Account Ledger for 14000/13101/13304


Description:
Direct Deposit Query: Added Active Employees Not on Direct Deposit


Description:
Changed Queries Ages, Names, Names - Active Employees, SPRIDEN - People to prevent returning record for Catastrophic Leave Bank


Description:
FRVGSUM Query: Added Grant Ledger Status Summary View


Description:
SJ - Travel Accounts Query: Added Orgn 3600 version of Travel Accounts


Description:
FRVGRST Query: Added Grant Status History Table


Description:
FRVPRST Query: Added Proposal Header Table


Description:
FRVCSUM Query: Added Grant Ledger Status Summary View based on Acct Class Code


Description:
FRRPLOC Query: Added Proposal Location Repeating Table


Description:
FRBPROP Query: Added Proposal Header Table


Description:
FRRGLOC Query: Added Grant Location Repeating Table


Description:
FFRMASA Query: Changed to return MAX FFRMASA_CHANGE_SEQ_NUM for each FFRMASA_OTAG_CODE


Description:
Renamed Table: BannerAccess Changes to tblBannerAccessChanges


Description:
Renamed Table: Table Descriptions local to tblTableDescriptions


Description:
Renamed Table: Table Field Descriptions local to tblTableFieldDescriptions


Description:
Renamed Table: Excluded Tables to tblExcludedTables


Description:
Renamed Table: Focus fex Conversion List to tblFocus_fex_Conversion_List


Description:
Renamed Table: Functions to tblFunctions


Description:
Renamed Table: ODBC Common Errors to tblODBC_CommonErrors


Description:
Renamed Table: Script List to tblScriptList


Description:
Renamed Table: Script List Ignored to tblScriptListIgnored


Description:
Renamed Table: ECLS - Classified to tbl:ECLS - Classified


Description:
Renamed Table: ECLS - Faculity to tbl:ECLS - Faculity


Description:
Renamed Table: ECLS - Temporary to tbl:ECLS - Temporary


Description:
Corrected Query: Pevempl with Source Fields removed ROWNUM Limit


Description:
Titles - Extended Working Titles Query: Added - These are Full Titles for the Directory, by PIDM


Description:
Added Query: Focus - qryBudgets and Report: rpt:Focus - Budgets, Converted budgets.fex


Description:
Added Query: Focus - qryBud_Fund and Report: rpt:Focus - Bud_Fund, Converted bud_fund.fex


Description:
Added Query: Salary Lookup and Report: rpt:Salary Lookup, Gives Annual Salary with Position Title & Full Working Title


Description:
Extended Query: SPRTELE Series combined area+number giving Phone, Cell, Fax, Work_Phone


Description:
Added Query: Telephone - Active Employees for a combined


Description:
Changed Query: FGBTRNH to add signed Amount using DB CR Rule


Description:
Added Query: FGOPAL Indirects/Spec Progs


Description:
Added Report: Rpt:YTD Activity including Revenue


Description:
Added Query: NHVEDST reports from NHRDIST and is related to NHIEDST Banner Form


Description:
Changed Query: Added NHRDIST_Amount (NHRDIST_AMT signed) to the NHRDIST series of Queries


Description:
Added Query: FSRADJD - Stores Inventory Adjustment Detail Table


Description:
Added Query: z - Who's On - from Steve Rea's whoson.sql


Description:
Added Query: 13205 Ledger - Current Rev/Exp Balances: Fund 13205


Description:
Added Query: 13301 Activity - Detail Rev/Exp Activity: Fund 13301


Description:
Added Query: 13301 Ledger - Current Rev/Exp Balances: Fund 13301


Description:
Added Query: 13302  Ledger - Current Rev/Exp Balances: Fund 13302


Description:
Added Query: 13303  Ledger - Current Rev/Exp Balances: Fund 13303


Description:
Made Subset for Standard BannerAccess Refresh


# tblFunctions

desc:
will calculate the class code for a passed


desc:
will return the description of the passed


desc:
return the description of the passed validation or rule code
REM   validation or rule code


desc:
is used to display the appropriate special finance description.


desc:
return indicator if comments exist for event


desc:
counts the number of attendees based on the function and


desc:
count the number of tasks for an associated event, function


desc:
return the rowid of the function expenses based on the event and function passed


desc:
return the rowid of the function fees based on the event and function passed


desc:
return the rowid of the function revenue based on the event and function passed


desc:
return an indicator to show if there is additional subject index data for the event and function


desc:
function determines if there are additional participants for either ther ptyp code or the function/event.

parameters:
(event varchar2, function varchar2, which_view_type varchar2,


desc:
return an indicator to show if there are more than the passed number of task types


desc:
function will return the rowid of the GERPART table


desc:
return indicator if comments exist for the subject index for the function and event passed.


desc:
The dummy function returns the EEOC category description.


desc:
return the subject index code from the gtvsdax table for the event and function passed


desc:
Initial release of F_VbsErrorMessage function.


desc:
(str varchar2, fmt_str varchar2 default null) return boolean;


desc:
(pidm number, npin varchar2) return boolean;


desc:
(pidm number, directory_type varchar2) return boolean;


desc:
Procedure and function definitions go here.


desc:
g$_foreign_sql_fnc (in_sql varchar2) return integer;


desc:
identifies Human Resource Cobra persons.


desc:
stored function will, based on the pidm and term passed,


desc:
function will determine, based on the passed pidm, if an individual


desc:
function will return a null high school code for institutions that


desc:
REM 1. The dummy function returns the rowid for the high school row for a


desc:
returns a null value when BANNER Student is not


desc:
will return the rowid of the sortest record


desc:
will return the rowid of the sgbstdn table for the


desc:
stored function will return the rowid of the address record


desc:
stored function will return the rowid of the address telephone


desc:
The function calculates the age for a given series of dates. Also,


desc:
stored function will return the description of the passed


desc:
stored function will, depend on city, state, zip, county, nation,


desc:
function will return the rowid of the sprhold table for the


desc:
function will return the rowid of the most recently issued


desc:
function is used to retrieve a description for the tenure code


desc:
stored function will split and return the field desired based on


desc:
stored function will return the rowid of the sprtele record


desc:
dummy stored function will calculate the account balance for a


desc:
will calculate the term ranges for a specified acyr and initiate the appropriate A/R function.


desc:
dummy stored function will calculate the balance for all


desc:
will return a "Y" in a view when a row exists in


desc:
will calculate the account balance for all


desc:
dummy stored function will return the calculated aged days


desc:
REM 1.This dummy stored function will return the description of the passed


desc:
dummy stored function will calculate the memo amount for all


desc:
dummy stored function will return the balance for all charges


desc:
dummy stored function will calculate the payments for the


desc:
function is used to return a not found condition when attempting


desc:
will calculate the total accepted amount of


desc:
will determine and return the cost of education


desc:
will determine and return the family contribution


desc:
will determine and return the family income


desc:
will determine if an individual is a Financial


desc:
will determine and return the parent contribution


desc:
will return a zero value when F/A is not installed


desc:
dummy stored function will determine the aged day slots by using


desc:
return an indicator to show if the task type for the associated event and function is complete or not


desc:
return the task type from the gtvsdax table for the event and function passed


desc:
compile all General and Common database triggers, packages, functions, procedures, General event functions, VBS functions and procedures


desc:
general utilities for use within banner. --


desc:
general utilities for use within banner. -- 
general utilities for use within banner.


# tblODBC_CommonErrors

Most Likely:
SQL Coding error such as missing relational


Most Likely:
trying to update without update privileges granted


Most Likely:
data type error such as comparing date to "text"


Most Likely:
Message: "The MS Jet database engine cannot find the input table or query."

Next Most Likely:
Check Design>View>Properties make sure Returns Records is set to Yes


Most Likely:
Insufficient privileges to use the table or view
table or view does not exist.


Most Likely:
Message: "Invalid precision for decimal data type."


# tblTableDescriptions

TABLE_DESC:
Encumbrance Open Close Document Header Table.


TABLE_DESC:
Purchase Order Batch Close Process Collector Table


TABLE_DESC:
Encumbrance Open Close Document Accounting Detail Table.


TABLE_DESC:
Encumbrance Open Close Document Purchase Order/Req Item Table.


TABLE_DESC:
Encumbrance Open Close Document Item Table.


TABLE_DESC:
Research Accounting Grants Billing Table


TABLE_DESC:
Indirect Cost Charge Account code Header Table.


TABLE_DESC:
Indirect Cost Distribution Code Header Table.


TABLE_DESC:
Billing Form 272 Table for Reporting Purpose


TABLE_DESC:
Distributed interest calculation table with balances


TABLE_DESC:
Operation Ledger/General Ledger Control Account Collector Table.


TABLE_DESC:
FGROPRC Fiscal Year / Fiscal Period Collector Table.


TABLE_DESC:
The Control Account Code Collector Table.


TABLE_DESC:
General Ledger Report Totals Temp. Table


TABLE_DESC:
Web for Executives Operating Ledger Period 14 View


TABLE_DESC:
Normalized Operating Account Ledger view for BANNERQuest


TABLE_DESC:
Web for Executives Operating Ledger 01-13 Excluding Accruals View


TABLE_DESC:
Web for Executives Operating Ledger 01-13 Including Accruals View


TABLE_DESC:
BOND BASE TABLE: It is created to maintain the specific data relative to bonds and participating funds.


TABLE_DESC:
Research Accounting Account Detail Information view.


TABLE_DESC:
Position Control Budget Update Collector Table


TABLE_DESC:
ORGN HIER Collector Table for Budget Distribution


TABLE_DESC:
EDI Control File:  This file contains one record with flags indicating if a Banner Finance module is EDI enabled.


TABLE_DESC:
Adjustment to Fixed Assets Header Table.


TABLE_DESC:
Fixed Asset Depreciation Summary Collector Table


TABLE_DESC:
Fixed Assets Adjustment Accounting Detail Table.


TABLE_DESC:
Adjustment to Fixed Assets Detail Table.


TABLE_DESC:
Fixed Asset Depreciation Error Message Collector table


TABLE_DESC:
Fixed Asset Origination Tag Extraction Collector Table


TABLE_DESC:
Fixed Assset User Defined Attributes Table


TABLE_DESC:
Fixed Assets Capitalization and Depreciation Accounting Table.


TABLE_DESC:
Fixed Asset Acquisition Method Code Table


TABLE_DESC:
Fixed Asset User Defined Attributes Validation Table.


TABLE_DESC:
MATCHING REPORT COLLECTOR TABLE: Used  when running the report fabmatc to group the processed invoices for reporting purposes.


TABLE_DESC:
MATCHING REPORT COLLECTOR TABLE: Used in the matching report fabmatc to group invoice commodity records for reporting purposes.


TABLE_DESC:
Multiple Vendor Invoice Commodity Collector Table


TABLE_DESC:
Multiple Vendor Invoice Cross Reference Table


TABLE_DESC:
Batch Check/Invoice Detail Temporary Table


TABLE_DESC:
Document Summary View for Vendor History View/Query


TABLE_DESC:
Vendor History (Open Invoices,Paid Invoices,Credit Memos) by Fiscal Year View


TABLE_DESC:
This view retrieves all the attributes (sets,types,values) associated with a ORGN code.


TABLE_DESC:
This view retrieves a periodic balance sheet account information and joins in pertinent validation tables. Beginning and ending balances are calculated for each period.


TABLE_DESC:
This view retrieves accounting distribution analysis information and other data on pertinent validation tables.


TABLE_DESC:
This view retrieves all the attributes (sets,types,values) associated with a PROG code.


TABLE_DESC:
This views retrieve proposal information


TABLE_DESC:
This view contains the AR Reconciliation information for BANNER reporting


TABLE_DESC:
This view retrieves transaction detail information and joins in pertinent validation tables.


TABLE_DESC:
This view retrieves vendor volume information from the invoice tables and joins in pertinent validation tables.


TABLE_DESC:
This view retrieves yearly balance sheet account information and pertinent validation tables.


TABLE_DESC:
This view retrieves yearly operating statement information and joins in pertinent validation tables.


TABLE_DESC:
Sponsored Research Proposal Events Proxy User ID Repeating Table.


TABLE_DESC:
Research Accounting System Control Table


TABLE_DESC:
Grant Rebuild Transaction History Collector Table


TABLE_DESC:
Billing Exclusion Code Validation Table.


TABLE_DESC:
Catalog of Federal Domestic Assistance Codes Table.


TABLE_DESC:
Cost Share Credit Account code Validation Table.


TABLE_DESC:
Cost Share Distribution code Validation Table.


TABLE_DESC:
Proposal Events Code Validation Repeating Table.


TABLE_DESC:
Research Accounting Fund Repeating Table.


TABLE_DESC:
Grant Ledger Status View for the Begin Grand Period


TABLE_DESC:
Grant Ledger Status View for the End Grand Period


TABLE_DESC:
Indirect Cost Charge Account code Validation Table.


TABLE_DESC:
Indirect Cost Rate code Validation Table.


TABLE_DESC:
Grants Labor Clearing Account Cross Reference Account Table.


TABLE_DESC:
Grant Labor Clearing Account Type Cross Reference  Table.


TABLE_DESC:
APPRECIABLE PROPERTY DETAIL TABLE: It is the table related to the appreciable property base table.


TABLE_DESC:
REVALUATION COLLECTOR TABLE: Table to hold pool investments for revaluation.


TABLE_DESC:
SPENDABLE AMOUNT MAINTENANCE TABLE: It is used to maintain the spendable amount values that are used in the distribution of income process.


TABLE_DESC:
STOCK COLLECTOR TABLE: It is created to maintain the specific data relative to stock instruments and participating funds.


TABLE_DESC:
STOCK DETAIL TABLE: It is the table related to the stock base table.


TABLE_DESC:
STOCK OPTION COLLECTOR TABLE: It is created to maintain the specific data relative to stock options and participating funds.


TABLE_DESC:
STOCK OPTION DETAIL TABLE: It is the table related to the stock base table.


TABLE_DESC:
MATCHING FUND COLLECTOR TABLE.  Used for totals in matching fund report.


TABLE_DESC:
TOTAL RETURN COLLECTOR TABLE: Table to hold investments for non pool funds.


TABLE_DESC:
FNBUNTD - Endowment Unitization Collector Table.


TABLE_DESC:
Endowment Funds User Defined Fields Table.


TABLE_DESC:
Combined Operating and General Ledgers activitiy table.


TABLE_DESC:
Endowment User Defined Fields Validation Table.


TABLE_DESC:
1099 Magnetic Tape Transmitter information


TABLE_DESC:
View for determining queue id-s for the Approval Process


TABLE_DESC:
CERTIFICATE OF DEPOSIT BASE TABLE: It is created to maintain the specific data relative to certificate of deposit and participating funds.


TABLE_DESC:
CUSIP BASE TABLE: Contains general information about the CUSIP.  It has a one to many relationship with the CUSIP Unit Market Value Table and the CUSIP Dividend Payable Table.


TABLE_DESC:
INTEREST DIVIDEND PROCESS TABLE : The table which holds the interest dividend date from last FIRINDV process run.


TABLE_DESC:
MONEY MARKET BASE TABLE: It is created to maintain the specific data relative to money market and participating funds.


TABLE_DESC:
INVESTMENT POOL BASE TABLE: This table will store summarized information for the pool fund for pool purchases, additions and deductions.


TABLE_DESC:
POOL COLLECTOR TABLE: This table will be a permanent temporary table used to initiate the revaluation of a pool(unitized method or average daily balance)


TABLE_DESC:
APPRECIABLE PROPERTY BASE TABLE: It is created to maintain the specific data relative to the appreciable property and participating funds.


TABLE_DESC:
STOCK BASE TABLE: It is created to maintain the specific data relative to stock instruments and participating funds.


TABLE_DESC:
STOCK OPTION BASE TABLE: It is created to maintain the specific data relative to stock options and participating funds.


TABLE_DESC:
MATCHING ACCOUNT COLLECTOR TABLE.  Used in matching fund report.


TABLE_DESC:
BOND INTEREST SCHEDULE TABLE: It is created to maintain the specific data for the bond interest schedule.


TABLE_DESC:
BOND COLLECTOR TABLE: It is created to maintain the specific data relative to bonds and participating funds.


TABLE_DESC:
BOND DETAIL TABLE: It is the table related to the bond base table.


TABLE_DESC:
CUSIP CALLABLE DATE COLLECTING TABLE: Contains information about the callable date which are to update CUSIPs bond callable date.


TABLE_DESC:
CUSIP CALLABLE DATE REPEATING TABLE: Contains information about the callable date for CUSIPs.  It is applicable only to the investment category of bonds.


TABLE_DESC:
Enque control for processes which cannot run concurrently and locks do not provide sufficient control.


TABLE_DESC:
Process/Form to Rule Group History Table


TABLE_DESC:
Web for Executives Operating Ledger Account Hierarchy Extract


TABLE_DESC:
Collector table to hold approval queue routing records during transaction approval processing.


TABLE_DESC:
Web for Executives Operating Ledger Fund Hierarchy Extract


TABLE_DESC:
Web for Executives General Ledger Account Hierarchy Extract


TABLE_DESC:
Web for Executives General Ledger Extract


TABLE_DESC:
Web for Executives General Ledger Fund Hierarchy Extract


TABLE_DESC:
Web for Executives Operating Ledger Organization Hierarchy Extract


TABLE_DESC:
Web for Executives Operating Ledger Program Hierarchy Extract


TABLE_DESC:
Web for Executives Sponsored Research Account Hierarchy Extract


TABLE_DESC:
Web for Executives - Sponsored Research Extract


TABLE_DESC:
Web for Executives Sponsored Research Fund Hierarchy Extract


TABLE_DESC:
Web for Executives Sponsored Research Organization Hierarchy Extract


TABLE_DESC:
Web for Executives Finance Cleansing View


TABLE_DESC:
Budget Availability Ledger Temporary Table.


TABLE_DESC:
Archive Transaction History Detail Table


TABLE_DESC:
Direct Cash Receipt Tax and Rebate Table.


TABLE_DESC:
Collector table for fund hierarchy for Budget Availability Checking


TABLE_DESC:
Research Accounting Transaction Detail Table


TABLE_DESC:
Grant Budget Proposal Lines Detail Table.


TABLE_DESC:
Research Accounting Transaction Detail History Table


TABLE_DESC:
Research Accounting Exception Report Table


TABLE_DESC:
Sponsored Research Grant Events Fixed Schedule Data Repeating Table.


TABLE_DESC:
Billing Format Accounts and ATyp matching Repeating Table.


TABLE_DESC:
Billing Format Subtotal Repeating Table.


TABLE_DESC:
Proposal Budget Collector Table usage with FRIBUDT.


TABLE_DESC:
Proposal Budget Account Line Items Table.


TABLE_DESC:
Cost Share Credit Account code Repeating Table.


TABLE_DESC:
Cost Share Distribution code Repeating Table.


TABLE_DESC:
Grant Grouped Events Table. This table stores groups of events linked to the grant codes.


TABLE_DESC:
Proposal Grouped Events Table. This table stores groups of events linked to the proposal codes.


TABLE_DESC:
Sponsored Research Grant Events Status Repeating Table


TABLE_DESC:
Sponsored Research Proposal Events Status Repeating Table


TABLE_DESC:
Expenses Towards Cost Share by Grant and Account Table


TABLE_DESC:
Grant Expenses Towards Indirect Cost Table


TABLE_DESC:
Research Accounting Billing Report Collector Table


TABLE_DESC:
Grant User Defined Codes Repeating Table.


TABLE_DESC:
Indirect Cost Charge Account code Repeating Table.


TABLE_DESC:
Indirect Cost Distribution code Repeating Table.


TABLE_DESC:
This view retrieves accounting distribution analysis information from the invoice tables and other data on pertinent validation tables.


TABLE_DESC:
This view retrieves all the attributes (sets,types,values) associated with a ACCT code.


TABLE_DESC:
This view retrieves all the attributes (sets,types,values) associated with a ACTV code.


TABLE_DESC:
This view retrieves all the sets of attributes and the types and values associated with them.


TABLE_DESC:
Research Accounting Transaction Detail view.


TABLE_DESC:
This view retrieves budget availability information and joins in pertinent validation tables.


TABLE_DESC:
This view retrieves all the attribute types for a chart and the values associated with them.


TABLE_DESC:
This view retrieves disbursement analysis information from the invoice and check tables and joins in pertinent validation tables.


TABLE_DESC:
This view returns history of the distribution of spendable income to spendable funds associated with endowment funds.


TABLE_DESC:
This view retrieves detail unitization data for endowment funds.


TABLE_DESC:
This view retrieves all the foapal elements that have no attributes associated with them.


TABLE_DESC:
This view retrieves all the attributes (sets,types,values) associated with a fund code.


TABLE_DESC:
This view retrieves informationabout the grant by FOAPAL


TABLE_DESC:
This view retrieves all the attributes (sets,types,values) associated with a LOCN code.


TABLE_DESC:
Sponsored Research Grant Events Proxy User ID Repeating Table.


TABLE_DESC:
CERTIFICATE OF DEPOSIT COLLECTOR TABLE: It is created to maintain the specific data relative to certificate of deposit and participating funds.


TABLE_DESC:
CERTIFICATE OF DEPOSIT DETAIL TABLE: It is the table related to the certificate of deposit base table.


TABLE_DESC:
CUSIP DIVIDEND PAYABLE COLLECTING TABLE: Contains information about dividend amounts for CUSIPs with the Investment Type of stock which are to update the FIRCUDV


TABLE_DESC:
CUSIP DIVIDEND PAYABLE REPEATING TABLE: Contains information about dividend amounts for CUSIPs with the Investment Type of stock.


TABLE_DESC:
CUSIP COLLECT TABLE: Contain the stataus information which is to update the CUSIP.


TABLE_DESC:
CUSIP UNIT MARKET VALUATION COLLECTING TABLE: Contains the current market values which are to update the CUSIPs maintained on the base table.


TABLE_DESC:
CUSIP UNIT MARKET VALUATION REPEATING TABLE: Contains the current market values for the CUSIPs maintained on the base table.


TABLE_DESC:
DISTRIBUTION OF INCOME POOLED INCOME COLLECTOR TABLE: It is a temporary table used to hold the pooled income and pooled gains amount values that are used in the distribution of income process.


TABLE_DESC:
LAST DISTRIBUTION OF INCOME TABLE: It is used in running the report firdist.


TABLE_DESC:
CUSIP SUMMARY TABLE:  Created to maintain a summary of investment information at the CUSIP and fund level.


TABLE_DESC:
MONEY MARKET COLLECTOR TABLE: It is created to maintain the specific data relative to money market and participating funds.


TABLE_DESC:
MONEY MARKET DETAIL TABLE: It is the table related to the money market base table.


TABLE_DESC:
Income Account Type and Gain/Loss Account Type Parameter Table


TABLE_DESC:
INVESTMENT POOL BASE TABLE: This table will store individual investment fund for pool purchases, additions and deductions.


TABLE_DESC:
APPRECIABLE PROPERTY COLLECTOR TABLE: It is created to maintain the specific data relative to the appreciable property and participating funds.


TABLE_DESC:
Grant Billing Payment Management System Code Validation Table


TABLE_DESC:
Grant User Defined System Codes Validation Table.


TABLE_DESC:
Web for Executives Grant Ledger Period 14 View


TABLE_DESC:
Web for Executives Grant Ledger 01-13 Excluding Accrual View


TABLE_DESC:
Web for Executives Grant Ledger 01-13 Including Accrual View


TABLE_DESC:
STORES INVENTORY ADJUSTMENT TABLE: The table which holds Inventory Cost and Quantity Adjustment Documents for Stores Inventory.


TABLE_DESC:
ISSUES HEADER TABLE: The table which holds store issue document header information.


TABLE_DESC:
STORES INVENTORY SYSTEM CONTROL TABLE:  The table which contains system control information for the Stores Inventory Module only.


TABLE_DESC:
STORES TRANSFER HEADER: Header data for stores transfers


TABLE_DESC:
STORES INVENTORY ADJUSTMENT DETAIL TABLE: The table which holds Inventory Cost and Quantity Adjustment detail information for Stores Inventory.


TABLE_DESC:
STORES INVENTORY RECEIVING/ISSUES COLLECTOR TABLE: Table used to merge both receiving and issues data to be reported on a single report.


TABLE_DESC:
ISSUES ACCOUNTING TABLE: The table which holds stores issue document accounting information.


TABLE_DESC:
ISSUES COLLECTOR TABLE: Collector table which triggers the initial print of Issue tickets when an Issue document is completed.


TABLE_DESC:
ISSUES COMMODITY DETAIL TABLE: The table which holds stores issue document commodity detail information.


TABLE_DESC:
ISSUES COMMODITY LOCATION TABLE: The table which holds stores issue document commodity location information.


TABLE_DESC:
STORES PRELIMINARY REQUISITION TABLE: Stores Inventory table used to store those commodity codes which need to be re-ordered.


TABLE_DESC:
STORES INVENTORY ADJUSTMENT SYSTEM CONTROL TABLE: Stores inventory adjustment system control contains start and end dates for adjustments to quantity and unit cost of a stores item.


TABLE_DESC:
STORES TRANSFER DETAIL: Detail (commodity) data for stores transfers


TABLE_DESC:
STORES TRANSFER DETAIL LOCATIONS: Location detail data for stores transfers


TABLE_DESC:
STORES VALUATION DETAIL: Detail history data for stores valuation process


TABLE_DESC:
Account code and Attributes association table


TABLE_DESC:
Account code and set code association table


TABLE_DESC:
Activity code and Attributes association table


TABLE_DESC:
Activity code and set code association table


TABLE_DESC:
Set and Attribute type association table


TABLE_DESC:
Chart of Accounts attributes value validation table.


TABLE_DESC:
Fund code and Attributes association table


TABLE_DESC:
Fund code and set code association table


TABLE_DESC:
Location code and Attributes association table


TABLE_DESC:
Location code and set code association table


TABLE_DESC:
Organization code and Attributes association table


TABLE_DESC:
Organization code and set code association table


TABLE_DESC:
Program code and Attributes association table


TABLE_DESC:
Program code and set code association table


TABLE_DESC:
Vendor tax collector repeating validation table


TABLE_DESC:
ACCOUNT CODE INVESTMENT TYPE REPEATING TABLE: Links the investment types of the user to an account code that is used for editing data in the load process.


TABLE_DESC:
Pro Rata Allocation Charge Control Table.


TABLE_DESC:
Pro Rata Allocation Rule Group Control Table.


TABLE_DESC:
Chart of Accounts attributes Set validation table


TABLE_DESC:
Chart of Accounts attributes Type validation table


TABLE_DESC:
Cost Share Contribution Validation Table


TABLE_DESC:
This view retrieves all the attributes (sets,types,values) associated with a foapal code.


TABLE_DESC:
FUND BALANCE ACCOUNT TABLE: Identifies multiple fund balance accounts.


TABLE_DESC:
This view retrieves all the sets associated with a foapal code.


TABLE_DESC:
Freight Terms :  This table contains Freight Terms Codes indicating who is responsible for paying Freight charges.


TABLE_DESC:
INVESTMENT MANAGER TABLE: Identifies investment managers in the system.


TABLE_DESC:
Indirect Cost Validation Recipient Table


TABLE_DESC:
INTEREST SCHEDULE VALIDATION TABLE: This table is used to maintain the interest schedule codes that determine when the interest is calculated for a bond or money market.


TABLE_DESC:
STORES COMMODITY MASTER: Defines inventory parameters for stores commodities


TABLE_DESC:
INVESTMENT CATEGORY VALIDATION TABLE: Links the investment types of the user to an investment category that is hard coded data in the system.


TABLE_DESC:
STOCK LOCATION TABLE: Table will hold Stores Inventory commodity locations.


TABLE_DESC:
UNIT VALUE MEASUREMENT VALIDATION TABLE: Maintains the unit value measurements that apply to the units for an investment type and CUSIP.


TABLE_DESC:
GJRSWPT: This table contains information about jobs running in sleep/wake mode.


TABLE_DESC:
Letter Generation Application Rules Table


TABLE_DESC:
Letter Generation Calculation Collector Table


TABLE_DESC:
Survey Response Header Table. This table contains one row for each person who responds to the survey.


TABLE_DESC:
Workflow Electronic Documents Dictionary Base table


TABLE_DESC:
Workflow Electronic Documents Base Table


TABLE_DESC:
Collector table of persons address for the Geographic Regions/Divisionprocess.


TABLE_DESC:
Event Queue Record Maintenance Detail Table.


TABLE_DESC:
Geographic Regions/Divisions for persons address.


TABLE_DESC:
Survey Repsonses Repeating Table. This tables store the individual responses.


TABLE_DESC:
Workflow Electronic Docuents Builder Table


TABLE_DESC:
Workflow Electronic Documents Dictionary Repeating Table


TABLE_DESC:
Workflow Electronic Documents History Table


TABLE_DESC:
Workflow Electronic Documents Repeating Table


TABLE_DESC:
Workflow Electronic Documents Temporary Table


TABLE_DESC:
Workflow Electronic Documents Builder View


TABLE_DESC:
This table is used to subdivide geographic regions to capture cost center information by disctirct or division.


TABLE_DESC:
The GTVEMAL table contains the valid e-mail type codes.


TABLE_DESC:
Letter Process Paragraph Validation Table


TABLE_DESC:
EDI STANDARD CODE VALIDATION TABLE:  This table contains the standard EDI codes based on element id and standards organization.  Data in this table is used to create cross references to various user defined codes that need tobe sent in EDI transactions/me


TABLE_DESC:
Workflow Electronic Documents Validation Table


TABLE_DESC:
Geographic information system location address table.


TABLE_DESC:
GUBLETR: Contains information about paragraphs within a letter.


TABLE_DESC:
The job submission base output table used to store header information from batch jobs executed in a client server environment.


TABLE_DESC:
Survey Header Table. This tables defines the header information for surveys.


TABLE_DESC:
Pledge Payment to Alumni Development Table


TABLE_DESC:
Table to track Banner Forms item attributes in order to keep the Workflow BCC up to date.


TABLE_DESC:
Table used to record what database modifications have been made to this database


TABLE_DESC:
Address Collector Table used to store parameters by user session for FOCUS


TABLE_DESC:
This table contains all the entries available to a particular form from the option menu pick. It contains the names of Blocks, Windows, Forms and Processes which may be invoked from the form identified in guroptm_form_name


TABLE_DESC:
The job submission repeating output table used to store the output from batch jobs executed in a client server environment.


TABLE_DESC:
Survey Questions Repeating Table. This tables defines the survey questions.


TABLE_DESC:
Survey Roles Repeating Table. This tables defines which roles may respond.


TABLE_DESC:
PREFERENCE TABLE THAT STORES TOOLBAR AND MENU INFOG


TABLE_DESC:
Recipient Direct Deposit Information Table.


TABLE_DESC:
Base Job Labor Distribution History Table


TABLE_DESC:
Fringe Charge Back Position Budget. Repeating Table


TABLE_DESC:
Assignment Labor Distribution History Repeating Table


TABLE_DESC:
Premium Earnings Budget Totals Repeating Table


TABLE_DESC:
Position Labor Distribution Account Temporary Table


TABLE_DESC:
Premium Earnings Budget Totals Temporary Table


TABLE_DESC:
Temporary Table for the nhrecrt - Effort Certification Report


TABLE_DESC:
Transaction Approvals Default Earnings Table


TABLE_DESC:
Transaction Approvals Labor Distributions Table


TABLE_DESC:
Parameter Collector Repeating Table; used to hold multiple values of parameters for reports etc.


TABLE_DESC:
Electronic Approvals Default Values Table


TABLE_DESC:
Electronic Approval Type Form/Block Rule Table


TABLE_DESC:
Electronic Approval Type Field Rule Table


TABLE_DESC:
Electronic Approval Block Usage Rule Table.


TABLE_DESC:
Electronic Approval Field Usage Rule Table.


TABLE_DESC:
Electronic Approval Form Usage Rule Table


TABLE_DESC:
Fringe External Funding Source Rate Definition Rule Table


TABLE_DESC:
Fringe Installation Rate and Labor Distribution Override Rule Table


TABLE_DESC:
Fringe External Funding Source Labor Distribution Override Rule Table


TABLE_DESC:
Position Control Installation Rule Table


TABLE_DESC:
Mass Job/Assignment Salary Increase Rule Table


TABLE_DESC:
Mass Job/Assignment Table Grades Rule Table


TABLE_DESC:
Mass Job/Assignment Salary Table Roll Rule Table


TABLE_DESC:
Dictionary of Occupational Titles Code (DOTT) Validation Table


TABLE_DESC:
Federal Occupational Code (FOC) Validation Table


TABLE_DESC:
National Occupational Code (NOC) Validation Table


TABLE_DESC:
Position Requirements Factor of Importance Table.


TABLE_DESC:
Temp table for Web for Executive Requisition/Application profile extract


TABLE_DESC:
Web for Employees Release Version Table.


TABLE_DESC:
Cobra Beneficiary Coverage Repeating Table


TABLE_DESC:
COBRA Dependent and Beneficiary Repeating Table


TABLE_DESC:
Cobra Payment Administration Repeating Table


TABLE_DESC:
Dependent and Beneficiary Repeating Table


TABLE_DESC:
Employee Flexible Benefits Balance Table


TABLE_DESC:
California PERS Report of Payroll Contributions Required Data Elements Table.


TABLE_DESC:
Health and Safety Position Hazard Rule Table


TABLE_DESC:
Record of Employment Information Base table


TABLE_DESC:
Family Medical Leave Act Leave Comments Table.


TABLE_DESC:
Employee Defer Pay Adjustment Repeating Table


TABLE_DESC:
Time Entry Pay Period Days History Table.


TABLE_DESC:
Time Entry Pay Period Effective Date Breakdown Table.


TABLE_DESC:
Employee Deduction History Repeating Table


TABLE_DESC:
Employee Monthly Benefit / Deduction Totals Repeating Table


TABLE_DESC:
Time Entry Labor Distribution Repeating Table


TABLE_DESC:
Time Entry Earnings Labor Distribution Repeating Table


TABLE_DESC:
Employee Monthly Earnings Totals Repeating Table


TABLE_DESC:
Time Entry Hours Breakdown History Table


TABLE_DESC:
Health and Safety Incident Medical Table


TABLE_DESC:
Health and Safety Incident Recommendations and Actions Table


TABLE_DESC:
Employee Monthly Job Totals Repeating Table


TABLE_DESC:
History Employee Leave Balances Repeating Table


TABLE_DESC:
Employee Canadian Pension Credit Repeating Table.


TABLE_DESC:
Record of Employment Comments Information table


TABLE_DESC:
Record of Employment Holiday Information table


TABLE_DESC:
Record of Employment Other Monies Information table


TABLE_DESC:
Temporary Table for Work Force Analysis Reports


TABLE_DESC:
Jobs Excluded From the EEO-5 Report Table


TABLE_DESC:
temp table Web for Executive Degree profile extract


TABLE_DESC:
Time Entry Hours Breakdown Temporary Table


TABLE_DESC:
temp table for Web for Executive Employee/Appointment profile extract


TABLE_DESC:
Direct Deposit table to hold amounts from tape


TABLE_DESC:
Pay History L/D Override Repeating Table


TABLE_DESC:
Fair Labor Standards Act Overtime reporting Table


TABLE_DESC:
California STRS/PERS Pension Contribution Table.


TABLE_DESC:
Payroll Labor Redistribution work table.


TABLE_DESC:
Temporary Deduction Table For Check/Direct Deposit Process


TABLE_DESC:
Temporary Table To Implement Roster and Organizational Time Sheet Reports


TABLE_DESC:
Temporary Table To Implement Work Schedules.


TABLE_DESC:
Temporary History Labor Distributions Table


TABLE_DESC:
Canadian Unemployment Insurance Compensation Weeks


TABLE_DESC:
California STRS/PERS Pension Contribution Temporary Table


TABLE_DESC:
Previous values for user by process on web


TABLE_DESC:
Prototypes (templates) for web processes


TABLE_DESC:
Temporary table for associated documents


TABLE_DESC:
Employee Class Code Security Access List Rule Table


TABLE_DESC:
Employer Code Security Access List Rule Table


TABLE_DESC:
Organization Code Security Access List Rule Table


TABLE_DESC:
Benefit/Deduction group member rule table


TABLE_DESC:
Benefit/Deduction primary group rule table


TABLE_DESC:
Benefit/Deduction secondary group rule table


TABLE_DESC:
Bene/Dedn Earn Code Exclusions Rule Table


TABLE_DESC:
ECLS Eligible Benefit Category Rule Table


TABLE_DESC:
Government Taxable Life Insurance Premium Rule Table.


TABLE_DESC:
Health and Safety Incident Locations Table


TABLE_DESC:
Health and Safety Medical Condition Rule Table


TABLE_DESC:
Health and Safety Hazard Comments Rule Table


TABLE_DESC:
Health and Safety Hazard Precautions Table


TABLE_DESC:
Employee Canadian Pension Credit Calculation Rule Table.


TABLE_DESC:
Employee Canadian Pension Credit Limits Rule Table.


TABLE_DESC:
Premium Pay Eligible Earnings Rule Table


TABLE_DESC:
Projected Statistics Annual Salary Table


TABLE_DESC:
Retroactive Pay Period Information Table.


TABLE_DESC:
Supplemental Payroll Deductions Rule Table


TABLE_DESC:
Supplemental Payroll Earn Codes Rule Table


TABLE_DESC:
Statistics Annual Salary Calculation Table


TABLE_DESC:
Statistics Annual Salary Excluded Suffixes Table


TABLE_DESC:
California PERS MR-87 Transaction Code Validation Table.


TABLE_DESC:
Position Class Description Validation Table


TABLE_DESC:
Health and Safety Disability Type Validation Table


TABLE_DESC:
EEO Contract Group Code Validation Table


TABLE_DESC:
Family Medical Leave Act Status Validation Table.


TABLE_DESC:
Family Medical Leave Act Leave Reason Validation Table.


TABLE_DESC:
Grievance Participant Type Validation Table


TABLE_DESC:
Grievance Standard Results Validation Table


TABLE_DESC:
Health and Safety Costs Reasons Validation Table


TABLE_DESC:
Health and Safety Medical Condition Type Table


TABLE_DESC:
Health and Safety Party Classification Validation Table


TABLE_DESC:
Health and Safety Incident Type Code Validation Table


TABLE_DESC:
Hazzards Standard Precautions Validation Table


TABLE_DESC:
T4A-NR Service Industry Validation table


TABLE_DESC:
Stats Canada Colleges Faculty Type Validation Table.


TABLE_DESC:
Stats Canada Employer Type Validation Table.


TABLE_DESC:
Stats Canada Full Time Faculty Type Validation table.


TABLE_DESC:
Stats Canada Part Time Faculty Type Validation table.


TABLE_DESC:
Statistics Canada Category Code Validation Table


TABLE_DESC:
Statistics Canada Grouping Type Validation Table


TABLE_DESC:
Workers Compensation Classification Validation Table


TABLE_DESC:
Magnetic Tape Tax Reporting ...  Employer information


TABLE_DESC:
Magetic Tape Tax Reporting ...  Installation / Transmitter information.


TABLE_DESC:
W2 Wage and Tax Statement Magnetic Reporting Table for Puerto Rico


TABLE_DESC:
W2 Wage and Tax Statement Magnetic Reporting Table


TABLE_DESC:
Holding Area for Writing Large Output Records


TABLE_DESC:
Tax Reporting Benefit/Deduction Box Designation Table


TABLE_DESC:
Tax Reporting Earnings Box Designation Table


TABLE_DESC:
Faculty Workload Contract FTE Rule Table


TABLE_DESC:
Source/Background Institution Academic Repeating Table


TABLE_DESC:
Source/Background Institution Characteristics Repeating Table


TABLE_DESC:
Source/Background Institution Comments Repeating Table


TABLE_DESC:
Source/Background Institution Contact Person Repeating Table


TABLE_DESC:
Source/Background Institution Degrees Offered Repeating Table


TABLE_DESC:
Source/Background Institution Demographics Repeating Table


TABLE_DESC:
Source/Background Institution Diplomas Offered Repeating Table


TABLE_DESC:
Source/Background Institution Ethnic Make-up Repeating Table


TABLE_DESC:
Source/Backround Institution Test Score Repeating Table


TABLE_DESC:
Prior college concentration area repeating table


TABLE_DESC:
Person Medical Information Repeating Table


TABLE_DESC:
Room Assignment Status Code Validation Table


TABLE_DESC:
Background Institution Characteristics Validation Table


TABLE_DESC:
Faculty Member Degree Level Validation Table


TABLE_DESC:
Geographic Region Division Validation Table


TABLE_DESC:
Academic History Institutional Honors Validation Table


TABLE_DESC:
Recruiting Initials Code Validation Table


TABLE_DESC:
Major, Minor, Concentration Validation Table


TABLE_DESC:
Recruiting Material Code Validation Table


TABLE_DESC:
Disability Service Code Validation Table


TABLE_DESC:
Previously Applied Contracts and Exemptions


TABLE_DESC:
BANNER Reporting view to retrieve detail code information


TABLE_DESC:
Web for Executives Accounts Receivable Cleansing View


TABLE_DESC:
Research accounting  billing information  view.


TABLE_DESC:
Research accounting application of payment history view.


TABLE_DESC:
View calculating the details for the students


