# bknox_created

desciption:
created using UNIX script report (Report Generator)


desciption:
created from cmatch.sql for acctexp.fex conversion


desciption:
created lbrrpt_aims.sql from lbrrpt.sql for report (review of export) to AIMS


desciption:
created aims_lbrrpt.sql from lbrrpt_aims.sql for export to AIMS


desciption:
created from cmatch.sql for allexp.fex conversion


desciption:
created all dates version from approval_periodic.sql


desciption:
created from expnopr.sql for aswcc.fex conversion


desciption:
created from balance.sql for bal_detl.fex conversion


desciption:
created from bal_detl.sql for bal_summ.fex conversion


desciption:
created using UNIX script report (Report Generator) balance.fex conversion


desciption:
created from Blanket PO and Open Invoice


desciption:
created from sumbyorg.sql for budbyorg.fex conversion


desciption:
created from budbyorg.sql for budcfwd.fex conversion


desciption:
created from vx20101vx.sql for caa02.fex conversion


desciption:
created from v20101vx.sql for new bank account


desciption:
created from expdetl.sql for chgsumm9.fex conversion


desciption:
created from chgsumm9 for a by 12 Period version


desciption:
created from chgsumm9 for a by FSPD version


desciption:
created from chsumm9.sql for thru period report


desciption:
created from orgexp.sql for cmatch.fex conversion


desciption:
created from expbyorg.sql for countexp.fex conversion


desciption:
created from grantpay.sql for countsal.fex conversion


desciption:
created from apje15.sql for csbtrns.fex conversion


desciption:
created using UNIX script report (Report Generator) for csrees.fex conversion


desciption:
created using UNIX script report (Report Generator) for csrmonth.fex conversion


desciption:
created from expenser.sql for detail.fex conversion


desciption:
created from detail.sql for extract version


desciption:
created from lbrrpt.sql for distorgn.fex conversion


desciption:
created from es202non_ts04182003.sql to combine FED and non-FED versions


desciption:
created from csrees for exp_summ.fex conversion


desciption:
created from exspenser.sql for expbyorg.fex conversion


desciption:
created from csrees for expdetl.fex conversion


desciption:
created from allexp.sql for expenser.fex conversion


desciption:
created from exspenser.sql for expenses.fex conversion


desciption:
created from exspenser.sql for testing version


desciption:
created from expenser.sql for expnopr.fex conversion


desciption:
created from exspenser.sql for exprev.fex conversion


desciption:
created from exspenses.sql for expsumm.fex conversion


desciption:
created from v20101vx.sql for fa1vu.fex conversion


desciption:
created using UNIX script xtab (Report Generator)


desciption:
created from expenser.sql for fslexp.fex conversion


desciption:
created from grntdet.sql for funddet.fex conversion


desciption:
created from detail_extract.sql for extract by fund version


desciption:
created from benrec.sql for grantpay.fex conversion


desciption:
created from grantpay.sql for grantsal.fex conversion


desciption:
created from grntdet.sql for grdetail.fex conversion


desciption:
created from grantcomm.sql to convert jimcomm.fex


desciption:
created from detail.sql for grntdet.fex conversion


desciption:
created from detail.sql for grntdet_extract.fex conversion


desciption:
created from detail.sql for grntdet_jb.fex conversion


desciption:
created from exspenser.sql for grntexp.fex conversion


desciption:
created from exspenser.sql for grntexpr.fex conversion


desciption:
created Salary version for special "one time" System Office report


desciption:
created from id_list.sql (it is from Time Sheet Approvals and namedir_mgrsub.sql)


desciption:
created from exspenser.sql for indbyfnd.fex conversion


desciption:
created from orgexp.sql for indirect.fex conversion


desciption:
created from budbyorg.sql for ipmbudcf.fex conversion


desciption:
created from snipets of deduction.sql using report_skeleton.sql


desciption:
created is_sub from namedir2 (namedir rewrite to use Home Orgn)


desciption:
created from exspenser.sql for je15.fex conversion


desciption:
created using UNIX script report (Report Generator) for jobs_enc.fex conversion


desciption:
created from scr3f.sql for new bank account


desciption:
created to call jv_prints.sql (renamed jv_print.sql)


desciption:
created using UNIX script report (Report Generator) for lbrrpt.fex conversion


desciption:
created lbrrpt_aims.sql from lbrrpt.sql for export to AIMS


desciption:
created to find owner of bad email address


desciption:
created from exspenser.sql for lonoke.fex conversion


desciption:
created from exspenser.sql for lonokeag.fex conversion


desciption:
created to replace noencum.fex                (report_skeleton based)


desciption:
created non_payroll_mgr is_sub.sql for AIMS


desciption:
created using report.shl and code from open_invn2.sql


desciption:
created from budbyorg.sql for orgsumm.fex conversion


desciption:
created orgsumm_dbr.sql version to automatically run for current month - This will input the Daily Departmental Budget Report


desciption:
created from po_copier.sql PO Copier Overages Report


desciption:
created from po_cell_exp.sql PO Cell Phone Expenditures Report


desciption:
created from po_cell_exp.sql PO Cell Phone Report


desciption:
created from allexp.sql for prior.fex conversion


desciption:
created from exspenser.sql for reimbexp.fex conversion


desciption:
created from expenser.sql for reimbsal.fex conversion


desciption:
created from exp_detl for rev_detl.fex conversion


desciption:
created from exp_detl.sql for rev_summ.fex conversion


desciption:
created from reinbsal.sql for revco.fex conversion


desciption:
created from exspenser.sql for revenue.fex conversion


desciption:
created from salary_proof.sql for Karin Grigsby


desciption:
created from reimbsal.sql for samples.fex conversion


desciption:
created from taxliab.sql for statetax.fex conversion


desciption:
created from sumbyorg.sql for sumbyfnd.fex conversion


desciption:
created from sumbyfnd.sql but all Funds vs. Selected Fund


desciption:
created from sumbyfnds.sql but only Jim Barrentine's Selected Funds vs. All Funds


desciption:
created from balance.sql for sumbyorg (chris.fex) conversion


desciption:
created from sumbyorg.sql for summary.fex conversion


desciption:
created from sumbyorg.sql for summary_extract.fex conversion


desciption:
created from email_leave_all supervisor-subordinate logic


desciption:
created from taxliab.sql for taxwage.fex conversion


desciption:
created from exp_detl.sql for transfer.fex conversion


desciption:
created from apje15.sql for v20101vx.fex conversion


# bknox_maint

Description:
created using UNIX script report (Report Generator)


Description:
created from cmatch.sql for acctexp.fex conversion


Description:
changed to select highest change seq number for cost records


Description:
changed Distribution Orgn to Budgetary Orgn


Description:
corrected spraddr lookup logic for changed addresses


Description:
changed from 'FED' to 'FIM' based extract


Description:
created using UNIX script report (Report Generator) for lbrrpt.fex conversion


Description:
corrected between logic and made test version to verify ranges lbrrpt_verify.sql


Description:
created lbrrpt_aims.sql from lbrrpt.sql for report (review of export) to AIMS


Description:
changed to Hourly Rate vs. Annual Salary


Description:
created aims_lbrrpt.sql from lbrrpt_aims.sql for export to AIMS


Description:
created from cmatch.sql for allexp.fex conversion


Description:
Changed to report only non-reconciled records (fabbktp_recon_ind != 'R')


Description:
modified !echo statements to better track runs reported to standard output


Description:
added jlipsey@uaex.edu dknuteson@uaex.edu lperry@uaex.edu to cc


Description:
changed lperry@uaex.edu to mratterree@uaex.edu (Michelle Ratterree)


Description:
changed to use FOAUAPP Form logic to show only those items that can be seen with FOAUAPP (Next Indicator = N)


Description:
changed to show Requested For, Commodity, Vendor, and Request Details


Description:
added Accounting information using UNION, corrected sort order for Item #s, removed extra blank lines.


Description:
removed FTVFSPD_PRD_STATUS_IND = 'O' from Accounting Information selection criteria


Description:
changed from FOBAINP_ACTIVITY_DATE to FOBUAPP_ACTIVITY_DATE to select yesterdays transactions (to eliminate orphaned transactions)


Description:
added check for Approval Table to make possible periodic running during a day


Description:
created all dates version from approval_periodic.sql


Description:
removed jlipsey@uaex.edu dknuteson@uaex.edu mratterree@uaex.edu from cc


Description:
split code to eliminate out of space errors: ORA-01652: unable to extend temp segment by 150 in tablespace TEMP


Description:
added jlipsey@uaex.edu sbaker@uaex.edu to cc, removed bpowell


Description:
corrected ((TRUNC(SYSDATE) BETWEEN FTVFSPD_PRD_START_DATE AND FTVFSPD_PRD_END_DATE) for End of Month Error


Description:
corrected Fund, Orgn, FORAQUS EFF_DATE Logic


Description:
changed mail Brett to Jim and added cc to Sheryl


Description:
corrected FORMAT for counters and fixed too early CLEAR COLUMNS


Description:
changed to newer apissues logic (check vendor)


Description:
created from expnopr.sql for aswcc.fex conversion


Description:
created from balance.sql for bal_detl.fex conversion


Description:
created from bal_detl.sql for bal_summ.fex conversion


Description:
created using UNIX script report (Report Generator) balance.fex conversion


Description:
change to provide before and after quorum court increase amounts


Description:
replace bdcola with this version of bdncinc.sql


Description:
created this version (bjv_print2.sql) from bjv_print.sql


Description:
change DB_Instance read to elimate buffer overflow from Oracle 8 changes


Description:
changed the account number that is credited on this feed from 5600 to 721110.


Description:
Added cat R and replaced Default Prog coding


Description:
Removed Penalty Mail (Cat B) and Bulk Mail (Cat C)


Description:
changed email reports from astacy to sbaker


Description:
for CL(classified), the account code for the salaries changed to 612000.


Description:
changed to remove extra bjv_print.sql run after Abort Program Exit section


Description:
change to include Printing Description (Job Desc)


Description:
change ACCT, if fund begins with 14 or 21 use 5200 Revenue Acct or 1320 A/R Acct


Description:
change ACCT, if fund begins with 28       use 5430 Revenue Acct or 1304 A/R Acct


Description:
NVL(,0) for Total_13301C, Total_14000C, and Total_Charges


Description:
change to credit Total Charges to 13306-3402-5600


Description:
removed commented total_13301c and total_14000c


Description:
moved parameter read to before Banner Security


Description:
Created from bjvfeed_h.sql Printing Batch JV Load


Description:
changed email reports from sbaker to astacy


Description:
made specific to bjvfeed_e and bjvfeed_f transactions


Description:
created from Blanket PO and Open Invoice


Description:
changed to soft dates based upon SYSDATE


Description:
Changed dates printed to MM\DD\YYYY Format


Description:
Added Vendor Name to Report, removed Termination Date, Closed Indicator, and


Description:
Changed Date selection to be Two months behind SYSDATE


Description:
created from sumbyorg.sql for budbyorg.fex conversion


Description:
created from budbyorg.sql for budcfwd.fex conversion


Description:
added nbrplbd_change_ind = 'A' and nbrjlbd_change_ind = 'A'to selection criteria


Description:
created from vx20101vx.sql for caa02.fex conversion


Description:
change the name to cancer/heart and add HHN, HHS, HMN, and HMS.


Description:
add Financial Manager PIDM and Active Employee


Description:
created from v20101vx.sql for new bank account


Description:
changed fringe rates from .0835 to .0801 and .2709 to .2743


Description:
created from expdetl.sql for chgsumm9.fex conversion


Description:
changed range from 'Unrestricted') GRP4,


Description:
added 14xxx and range of 17800-17899 as Unrestricted


Description:
created from chgsumm9 for a by 12 Period version


Description:
created from chgsumm9 for a by FSPD version


Description:
created from chsumm9.sql for thru period report


Description:
created from orgexp.sql for cmatch.fex conversion


Description:
use highest hourly rate for employees with two positions


Description:
changed restriction from nbrbjob_end_date >= '01-JUL-&&year'


Description:
changed from nbrbjob_end_date >= '30-JUN-&&yearvar'


Description:
changed hardcoded dates for 2000 Fiscal Year


Description:
changed hardcoded dates for March 23, 2001


Description:
changed hardcoded dates for July 11, 2001


Description:
changed to list probable cutoff date for operator


Description:
created from expbyorg.sql for countexp.fex conversion


Description:
created from grantpay.sql for countsal.fex conversion


Description:
created from apje15.sql for csbtrns.fex conversion


Description:
created using UNIX script report (Report Generator) for csrees.fex conversion


Description:
created using UNIX script report (Report Generator) for csrmonth.fex conversion


Description:
changed from dd_email table to dd_audit table


Description:
changed to Reimbursements vs Travel, added


Description:
corrected email to only non-Exception addresses.


Description:
changed to "I0065002:       $120.95 for Invoice# 188728279-001 Item: electric stapler"  format


Description:
changed exception report to same format.


Description:
added second exception report (for bad Vendor email addresses) - uses SPRADDR_ATYP_CODE = 'P1' rather than 'CM' and uses FABINVH_ATYP_SEQ_NUM = SPRADDR_SEQNO rather than MIN(SPRADDR_SEQNO)


Description:
changed to use /home/common/dd_email_exceptions_print.shl vs. dd_email_exceptions_print.shl


Description:
changed expection reports to select only 'P' for Employees (People) and 'C' Venodor


Description:
REPLACEd Single Quotes, Double Quotes, Back Quotes, and Line Feeds in FARINVC_COMM_DESC to prevent mail errors


Description:
ignore records where employee and employer amts are both zero


Description:
(+) for missing records and add total to applicable gross


Description:
combine BI and MN runs use Month to select which Payno to select


Description:
modified listcol_conversion.sql to extract table and view descriptions


Description:
created from expenser.sql for detail.fex conversion


Description:
added ACCT_CODE = '613000' to selection criteria


Description:
created from detail.sql for extract version


Description:
added ACCT_CODE = '612000' and '617000' to selection criteria


Description:
changed sort order from ORDER BY ffbmast_invh_code to ORDER BY ffbmast_disp_date


Description:
created from lbrrpt.sql for distorgn.fex conversion


Description:
remove any "Input truncated to" lines from output


Description:
added logic to get email addresses PREFERRED AND ACTIVE only


Description:
corrected Terminated June 30th error (due to position budget process)


Description:
changed Orgn lookups to use FTVORGN_EFF_DATE <= SYSDATE instead of next fyend


Description:
changed to prevent automatic sending of the email.  i.e., commented ! .shl statement


Description:
changed email NVL to ckordsmeier @ uaex.edu


Description:
changed to allow non-person entity as supervisor


Description:
changed ckordsmeier @ uaex.edu to kbailey @ uaex.edu


Description:
added AC AES Classified and PC UAPB Classified


Description:
added AN AES Nonclassified and PN UAPB Nonclassified


Description:
Remove phrjobs_ts_roster_ind = 'O' constraint


Description:
changed to use Home_Orgn from pebempl instead of jobs record


Description:
removed phrjobs references, changed to use pebempl_ecls_code


Description:
changed to Labor Distribution Orgn, Location group members changed


Description:
eliminated Carolyn Grimes Orgn 7602 (leaving 7600)


Description:
created from es202non_ts04182003.sql to combine FED and non-FED versions


Description:
eliminated McDonnell, Glenda Kaye   Orgn 8000 (leaving 4854)


Description:
eliminated Reed, Michelle           Orgn 8000 (leaving 6300)


Description:
eliminated Askew, Jean Ann          Orgn 4974 (leaving 4684)


Description:
eliminated Cope, Felecia Lynn       Orgn 4674 (leaving 4624)


Description:
added Tanya Yates back spriden_pidm = 1826 AND  ftvorgn_orgn_code = '4014'


Description:
eliminated Kelley Cochran Duplicate remove orgn 6300


Description:
eliminated Steven Sheets duplicate remove orgn 5004


Description:
ampersand bug in commented lines and added Marjorie Roberts back to ORGN 2000.


Description:
eliminated 779  Angie Blacklaw   4824	(leaving 4974)


Description:
eliminated 4418 Lisa Burris      4354	(leaving 4854)


Description:
eliminated 1518 Debbie Henry     7602	(leaving 7800)


Description:
eliminated 3237 Darlene Horne    6220	(leaving 4724)


Description:
eliminated 6967 Carly Meins      7300	(leaving 7800)


Description:
eliminated 6719 Steve Mooningham 3201	(leaving 3202)


Description:
eliminated 1119 Marion Snortland 7602	(leaving 7800)


Description:
eliminated 6273 Gus Wilson       4624	(leaving 4404)


Description:
eliminated 1521 Pamela Jane Hall	     - delete org 3201


Description:
eliminated 1289 Steve Kent Rodery	     - delete org 4344


Description:
eliminated 1286 Bernard Ferdinand Kurz     - delete org 4064


Description:
eliminated 1726 Rex Dwayne Herring	     - delete org 4994


Description:
eliminated 1598 Michael Keith Hamilton     - delete org 4434


Description:
eliminated 7270 Fredrick John Love         - delete org 6000 & 6100


Description:
eliminated 6327 Connie Lorraine Nelson     - delete org 4204


Description:
eliminated  669 Michael Clifford Andrews   - delete org 4184


Description:
eliminated 3695 Kris Tee Elliott           - delete org 4184


Description:
eliminated 3879 Tomeka Therese Nolen       - delete org 7800 & 7700


Description:
eliminated 1021 Gayla B Taylor             - delete org 4204


Description:
eliminated 1536 Daniel Joel Griffin        - delete org 4184


Description:
eliminated 7353 Craig S Allen              - delete org 4464


Description:
eliminated 5086 Andrew Dennis O'Neil       - delete org 4174


Description:
was requested to add back 1815 Alberto Caldwell


Description:
added back 6719 Steve Leonard Mooningham


Description:
Deletion    $629.76  Org 4755  773 Clara Mae Branham


Description:
Deletion  $6,942.94  Org 4194 5157 Audrey L Duncan


Description:
Deletion  $3,586.53  org 7700 7405 Terilyn Tennille Johnson


Description:
Deletion  $9,110.46  org 8000 7377 Stacey Wright McCullough


Description:
Deletion   ?                   7342 Stacey McCullough


Description:
Deletion  $6,725.82  org 4105 6265 John H McFarland


Description:
Deletion $10,212.94  org 4414 2557 Stewart K Runsick


Description:
Deletion $11,775.23  org 4615 1144 Phillip M Sims


Description:
Deletion $10,422.15  org 411  5426 Darrin G. Henderson


Description:
Additions $15,097.11   1019 1021 Gayla B Taylor


Description:
Additions $11,550.60   1536 Daniel Joel Griffin


Description:
Additions $10,927.35   1726 Rex Dwayne Herring


Description:
Additions  $4,796.79   3879 Tomeka Therese Nolen


Description:
Additions $15,097.11   1019 Gloria Dean Taylor 1019 1021 Gayla B Taylor


Description:
Additions $11,550.60   1536 Daniel Joel Griffin  OK


Description:
Additions $10,927.35   1726 Rex Dwayne Herring   OK


Description:
Additions  $4,796.79   3879 Tomeka Therese Nolen OK


Description:
Additions $15,097.11   1019 Gloria Dean Taylor


Description:
created from csrees for exp_summ.fex conversion


Description:
created from exspenser.sql for expbyorg.fex conversion


Description:
created from csrees for expdetl.fex conversion


Description:
created from allexp.sql for expenser.fex conversion


Description:
created from exspenser.sql for expenses.fex conversion


Description:
created from expenser.sql for expnopr.fex conversion


Description:
created from exspenser.sql for exprev.fex conversion


Description:
created from exspenses.sql for expsumm.fex conversion


Description:
created from v20101vx.sql for fa1vu.fex conversion


Description:
corrected ORDER BY error and added a line between records for readability


Description:
installed Dave Hill's (SCT) search.sql from Summit 99 CD


Description:
modified for ACES standards, added comments, moved SCT notes to end of program


Description:
created using UNIX script xtab (Report Generator)


Description:
added account 612999 and bug in FSYR variable use


Description:
removed phrjobs_ts_roster_ind = 'O' criteria


Description:
change uaces...txt references to flexible.csv


Description:
created from expenser.sql for fslexp.fex conversion


Description:
removed Brett, changed cc to a to for Angela, added Sheryl Baker to mail cc


Description:
added FTVFUND_USER_ID to report (Great Idea Sheryl:)


Description:
added cc for bhinkle@uaex.edu and reformatted the message


Description:
FORMAT explicitly required now.  Also, removed lbatts.


Description:
restricted extract to FTVFUND_DATA_ENTRY_IND = 'Y' (Entry Allowed)


Description:
restricted extract to FTVFUND_STATUS_IND = 'A' (Active)


Description:
added default Orgn for Becky's Extract version


Description:
created from grntdet.sql for funddet.fex conversion


Description:
created from detail_extract.sql for extract by fund version


Description:
created from benrec.sql for grantpay.fex conversion


Description:
created from grantpay.sql for grantsal.fex conversion


Description:
created from grntdet.sql for grdetail.fex conversion


Description:
created from grantcomm.sql to convert jimcomm.fex


Description:
created from detail.sql for grntdet.fex conversion


Description:
created from detail.sql for grntdet_extract.fex conversion


Description:
created from grntdet.sql for jimdet.fex conversion


Description:
created from detail.sql for grntdet_jb.fex conversion


Description:
created from exspenser.sql for grntexp.fex conversion


Description:
created from exspenser.sql for grntexpr.fex conversion


Description:
rewrite using health_rpt.sql template/called-program and improved payno selection


Description:
created Salary version for special "one time" System Office report


Description:
created to find owner of bad email address


Description:
created from exspenser.sql for lonoke.fex conversion


Description:
created from exspenser.sql for lonokeag.fex conversion


Description:
added AND pc.nbrptot_status = 'A' to selection criteria to correct for July 1 change in Table


Description:
change end date to be <= (less than or equal to) instead of < (less than).


Description:
changed phone source from spraddr to sprtele


Description:
changed to use Home Orgn vs. Budgetary Orgn


Description:
excluded labor distribution orgn 4999 folks on our payroll but not belonging to us for civil service status


Description:
removed duplicates due to splits in appointment % for Job


Description:
change pebempl selection to allow future term_date and last_work_date


Description:
corrected NBRBJOB selection for times always being TRUNC() plus NBRJOBS_EFFECTIVE_DATE) < TRUNC(SYSDATE))


Description:
AIMS Changes for Multiple Counties (Last 5 days, job_chg_days)


Description:
Changed Status to Jobs Status unless Employee Terminated


Description:
corrected date ranges for Job and Labor Distribution, and exit SETs


Description:
changed Last 5 days, job_chg_days to Last 30 days


Description:
fix for Labor Distribution (most recent effective date)


Description:
Manager Records added based upon FTVORGN FMgr (with any Active PEBEMPL Home Orgn matching record)


Description:
Remove PEBEMPL Record requirement for Managers.


Description:
Substitute PEBEMPL_ECLS_CODE when NBRJOBS_ECLS_CODE IS NULL


Description:
Added guess for 'AES' and 'UAPB' "District"


Description:
Corrected MSS Code (Secretaries are now with the 90s)


Description:
Changed Last 30 days, job_chg_days to Last 5 days.


Description:
Removed the consolidation of Warehouse, Maintenance, etc.


Description:
Added Best Guess at County Description from City when County Description was NULL.


Description:
Separate Work Address From Work Address/Telephone SELECT


Description:
Corrected Mgr Routine Any Active Employee in Home Orgn


Description:
Added PEBEMPL Info for Mgr Records in Separate lookup


Description:
remove restriction: FGBTRNH_DOC_CODE NOT BETWEEN 'B0000529' AND 'B0000557'


Description:
changed to use FY from SYSDATE-15 vs. SYSDATE


Description:
changed to use FY from SYSDATE-32 VS. SYSDATE-15


Description:
FISCAL_YEAR for heading is from hrrec.sql


Description:
created from id_list.sql (it is from Time Sheet Approvals and namedir_mgrsub.sql)


Description:
created from exspenser.sql for indbyfnd.fex conversion


Description:
created from orgexp.sql for indirect.fex conversion


Description:
created from budbyorg.sql for ipmbudcf.fex conversion


Description:
created from snipets of deduction.sql using report_skeleton.sql


Description:
created is_sub from namedir2 (namedir rewrite to use Home Orgn)


Description:
created from exspenser.sql for je15.fex conversion


Description:
Y2k mods and changed to hp4000 line count


Description:
Changed to allow 2003 transactions for Jennifer Gibson


Description:
Changed to allow 2003 transactions for Karen Ballard


Description:
fix bug in heading display for input variable


Description:
created using UNIX script report (Report Generator) for jobs_enc.fex conversion


Description:
created from scr3f.sql for new bank account


Description:
created to call jv_prints.sql (renamed jv_print.sql)


Description:
changed total calculation to ignore Debit/Credit Indicator


Description:
created lbrrpt_aims.sql from lbrrpt.sql for export to AIMS


Description:
created from salary_proof.sql for Karin Grigsby


Description:
Created from salary_proof.sql		Salary Reconciliation For July 1


Description:
added 02 report back into program with for temp mods


Description:
changed to report NBRJOBS_REG_RATE (hourly rate) instead of Annual Salary


Description:
changed from ntrpcls_desc to NBRPOSH_TITLE for Position Name


Description:
changed from NBRPOSH_TITLE to ntrpcls_desc for Position Name


Description:
created from reimbsal.sql for samples.fex conversion


Description:
created from taxliab.sql for statetax.fex conversion


Description:
created from sumbyorg.sql for sumbyfnd.fex conversion


Description:
created from sumbyfnd.sql but all Funds vs. Selected Fund


Description:
created from sumbyfnds.sql but only Jim Barrentine's Selected Funds vs. All Funds


Description:
created from balance.sql for sumbyorg (chris.fex) conversion


Description:
created from sumbyorg.sql for summary.fex conversion


Description:
created from sumbyorg.sql for summary_extract.fex conversion


Description:
created from email_leave_all supervisor-subordinate logic


Description:
changed FTVTRAT dates selection to be determined by fabinvh_trans_date


Description:
created from taxliab.sql for taxwage.fex conversion


Description:
change Ending_String to correct addresses


Description:
added  kgrigsby@uaex.edu sfunderburg@uaex.edu to cc


Description:
added notice for partial entry items all but PERJOBS_STATUS_IND IN ('P','A','C')


Description:
changed Sort_Order field to properly sort multiple due dates in one run


Description:
fixed format of report by removing extra lines of code.


Description:
corrected length of Name and Improved Sorts


Description:
created from exp_detl.sql for transfer.fex conversion


Description:
Changed to allow Primary Contract based upon Home Orgn and Secondary based upon Time Sheet Orgn


Description:
Changed to Time Sheet Orgn and Roll-up Orgn FMgr When FMgr=Sub


Description:
changed to Time Sheet Orgn then (use Home Orgn FMgr when When Time Sheet Orgn FMgr=Sub)


Description:
Added 1202 to 1200 Override per Steve Hall


Description:
created to replace noencum.fex                (report_skeleton based)


Description:
created non_payroll_mgr is_sub.sql for AIMS


Description:
change selection criteria to include 'R%' Documents


Description:
created using report.shl and code from open_invn2.sql


Description:
Restricted extract to FTVORGN_DATA_ENTRY_IND = 'Y' (Entry Allowed)


Description:
Restricted extract to FTVORGN_STATUS_IND = 'A' (Active)


Description:
changed to use Budgetary Roll-up Orgn vs Dist_Orgn


Description:
created from budbyorg.sql for orgsumm.fex conversion


Description:
created orgsumm_dbr.sql version to automatically run for current month - This will input the Daily Departmental Budget Report


Description:
modified to create a temp table instead of .csv file, this will be passed to a COBOL program for reporting


Description:
created from po_copier.sql PO Copier Overages Report


Description:
created from po_cell_exp.sql PO Cell Phone Expenditures Report


Description:
created from po_cell_exp.sql PO Cell Phone Report


Description:
Changed Requisition Detail restrictions to match actual sent items:)


Description:
From List version of 11-9-2004 po_imaging.sql used to get indexes for Cedar files missing info.


Description:
changed to setup other user's printer_userid.sql


Description:
created from allexp.sql for prior.fex conversion


Description:
created from exspenser.sql for reimbexp.fex conversion


Description:
added rule to force RUCL CNNC D/c IND + to be Amount Entered


Description:
created from expenser.sql for reimbsal.fex conversion


Description:
add funds starting with 29 to the list of funds


Description:
increased vendor name length (displayed)


Description:
created from exp_detl for rev_detl.fex conversion


Description:
created from exp_detl.sql for rev_summ.fex conversion


Description:
created from reinbsal.sql for revco.fex conversion


Description:
created from exspenser.sql for revenue.fex conversion


Description:
Y2k and getprinter mods, made hardcoded date soft


Description:
added   AND spriden_pidm = spbpers_pidm, fixed asofdate


Description:
Y2k and getprinter mods, made hardcoded dates soft


Description:
replaced DECODE for Fund Grouping with Morie's


Description:
change orgn and fund lookup to more efficent code


Description:
add FEGLI Codes, Grouping and Totals, and reformat print layout for Legal


Description:
generalized selection dates to 1st of asofdate and last day of prior month


Description:
change selection criteria to 1st payroll of month for BI and MN UOL deduction


Description:
created from apje15.sql for v20101vx.fex conversion


# Bknox_script_desc

Description:
generate 'FUND Changed Notice' email report


Description:
Extract Fund Code and Description for Inventory System


Description:
Extract Fund Code and Description for Inventory System - Becky's Vehicle Reporting system Extract


Description:
Detailed Listing of Charges to Grant/Reimbursable Funds


Description:
Property Inventory Acquisitions Report by Invoice Number


Description:
Report of Charges to General Institutional Budget


Description:
Departmental Budget Summary - General Institutional Funds


Description:
Open Commitments for Selected Funds Report


Description:
Report of Expenses on Grant/Project Funds


Description:
Gross Salaries Paid - By Account and Earn Code


Description:
Gross Wages and Unemployment Applicable Gross


Description:
Gross Wages and Work Comp Applicable Gross


Description:
export SEED information for Table gtvsdax


Description:
Health Insurance Deductions Report by Plan Number


Description:
Insurance Reports for Death/Life Deductions


Description:
Major Medical Health Insurance Reports for Triple Option and Classic Option


Description:
report template (skeleton) called by health.sql


Description:
Hello User - Pretest Banner username/pw as 1st Step in a UNIX Script


Description:
Hello2 User - Pretest Banner username/pw as 1st Step in a UNIX Script


Description:
Total Hours Worked by Temporary Employees


Description:
Total Hours Worked by Temporary Employees by most hours


Description:
generate 'ID List Notices' email reports


Description:
IRS 5500 Report (Cafeteria Plan Deduction Reporting)


Description:
Hello User (je_aes) - Pretest Banner username/pw as 1st Step in a UNIX Script


Description:
Compare Annual Salary to Job Labor Distribution - NBAJOBS vs. NHRDIST


Description:
Labels for Home Mailing (and Address Report)


Description:
Verify Rates - Test Ranges of Funds for Rate Application


Description:
generate 'Leave Requests Notices (Awaiting Your Approval)' email reports


Description:
Gathers Leave Request Records from PERJOBS/PERHOUR runs leave_requests.sql


Description:
created for non-Temp, non_Federal Life Insurance Census for TIAA-CREF


Description:
Produces a listing of a table and associated columns (fields).


Description:
Extract Name and Work Address for Directory


Description:
Extract for Directory Manager PIDM - Subordinate PIDM


Description:
Directory Names Missing Work Address Report


Description:
Journal Vouchers - Missing Encumbrance Number


Description:
Open Commitments for Unrestricted General Funds by Orgn Report


Description:
List county agents and their supervisors  NBBPOSN_TITLE like "%gent%"


Description:
Non-Check Transactions on the State Treasury Account-TBH-35


Description:
Update the dd_audit table with values from the FATCKIN temporary table


Description:
generate email messages for Reimbursements Direct Deposit


Description:
try to run dd_payroll_send_mmddyyyy.shl for SYSDATE


Description:
generate email messages for Payroll Direct Deposit Notices


Description:
Payroll Deduction Report by bdca_code, employee name


Description:
Deduction Report for bdca code &&bdcacodevar


Description:
Extract for Directory Departments based upon Home Orgn


Description:
Produces extracts of table and associated columns (fields).


Description:
DFNA to Gross Comparison Report For bdca codes UIT and WCT


Description:
Direct Print Reports that use the Report_Skeleton printer selection Logic


Description:
generate email messages ( email reports)


Description:
generate email messages to managers for temp hours


Description:
generate email messages to managers for leave


Description:
Bene-Dedn Earn Code Exclusions Rule Table


Description:
YTD Summary of Expenditures by Fund Group and Account Type


Description:
Non-Check Transactions on the State Treasury Account-KBH-01-02


Description:
Payroll Expenses per Operating Ledger Detail Table FGBTRND


Description:
Flexible Benefit Group Report and Extract


Description:
Deduction Report for bdca code FSM and FSU


Description:
Deduction Report for bdca code FSM, FSU and F57


Description:
- Object:Access functions owned by baninst1


Description:
- Object:Access source code for each function from sys.dba_source


Description:
- Object:Access functions and the views calling them


Description:
Open PO (Aging) Report by Established Date


Description:
Report of Expenses on Grant-Project Funds


Description:
Extract Orgn Code and Description for Inventory System


Description:
Extract Orgn Code and Description for Directory System


Description:
Reports the Orgn that a manager supervises (Budget_Orgn/FMgr_PIDM)


Description:
generate 'P-Card Approval Notices (Awaiting Your Approval)' email reports


Description:
Clear Records from Leave Table No Longer In Process and Unapproved


Description:
Close the PO related Tables for a single PO entry


Description:
List the Current Indicators and Status Flags for PO related Tables


Description:
Extract PO.pdf indexes for Document Imaging System


Description:
Positive Pay Prepare for Transmission to Bank


Description:
Positive A/P Prepare for Transmission to Bank (from dd_audit)


Description:
Update the positive_pay table with A/P run values from the FATCKIN temporary table


Description:
Positive Pay Payroll Prepare for Transmission to Bank


Description:
Update the positive_pay table with Payroll (php) run values from the PHRDOCM table


Description:
Direct Print of reports that use the Report_Skeleton printer selection Logic


Description:
Specify Standard WordPad Printer for USER bknox


Description:
Specify Standard Printer for USER drothber


Description:
Specify Standard Printer for USER kgrigsby


Description:
Specify Standard Printer for USER lmeeks


Description:
Specify Standard Printer for USER nboston


Description:
Specify Standard Printer for USER vthompso


Description:
Property Inventory Funding Source Report by P_Tag


Description:
First section of code used to create report_skeleton2.sql


Description:
Final section of code used to create report_skeleton2.sql


Description:
generate 'Requisition Closed to PO Notices' email reports


Description:
Revenues by Fund Group, Fund Code, Account Type, and Account Code


Description:
Revenues by Fund Group, Account Type, Account Code


Description:
Salary Distribution A21 Letter Report and Extract


Description:
Salary Distribution Banner Extract Report


Description:
July 1 Salary Increase For Classified Employees Report


Description:
July 1 Salary Increase For Federal Employees Report


Description:
Salary Reconciliation For July 1 Hourly (BI) Only


Description:
Salary Reconciliation (for Temporary Employees) For Entered Date


Description:
Payroll Positions Extract for County Agent Changes Speadsheet


Description:
First section of code used to create salary_schedule_xtab.sql


Description:
Final section of code used to create salary_schedule_xtab.sql


Description:
Salary Schedule - Salaries Paid by Fund - for submit to DHE


Description:
Salary Schedule - Salaries Paid by Legislative Title Code by Employee Name


Description:
Non-Check Transactions on the State Treasury Account-SCR


Description:
Vertical Display of SQL Search, modified version of Dave Hill's script


Description:
Faculty Specialist Report by ntrpcls_desc (title)


Description:
Faculty Specialist Report by nbrjobs_desc (title)


Description:
Faculty Specialist Report by nbbposn_title + ntrpcls_desc (title)


Description:
Budget: Statement of Present Estimate Report


Description:
State Withholding Tax, Unemployment and Work Comp Report


Description:
Grant/Reimbursable Funds Budgetary Summary Report


Description:
Fund Balance and Activity Summary by Fund Group and Fund Code


Description:
Extract Supervisor to Subordinate Info for Email Notices


Description:
Generate SPT Query Code From an SCT Banner Table


Description:
Tax Liability and Federal Applicable Gross Report


Description:
TDA Calculations for TIAA-CREF written to tdacalc.txt


Description:
generate 'Time Entry Approval Notices (Awaiting Your Approval)' email reports


Description:
Time Entry Yet - Should Notices be sent yet??


Description:
generate email messages for Time Entry without Entry for Period


Description:
generate email messages for Web Time Entry without Entry for Period


Description:
Check TIME_ENTRY TABLE used to assign TS_ORGNs to Departmental Time Entry Persons


Description:
Titles Report by Employee Name and Position


Description:
Directory Working Titles by Position Report


Description:
Titles Report by Position, Employee Name


Description:
Summary of Inter/Intra Fund Transfers by Fund Group and Fund Type


Description:
Deduction Report for bdca code TSM and TSU


Description:
Deduction Report for bdca code TSM, TSU and T57


Description:
First section of code used to create unempl.sql


Description:
Final section of code used to create unempl.sql


Description:
Non-Check Transactions on the State Treasury Account-KBH-01-05


Description:
Extract Vendor Name and Address for Inventory System


Description:
Comment Code Listing for Non-Vested Codes 002 and 004


Description:
- Object:Access views and the names of functions referenced in them


Description:
Deduction Report for bdca code TSM, TSU and T57 and


Description:
Account Description Extract for A/R (Foxpro)


Description:
First section of code used to create across_nhrdist.sql


Description:
Final section of code used to create across_nhrdist.sql


Description:
create SED file use by ACROSS xtab generator part 1


Description:
create SED file use by ACROSS xtab generator part 2


Description:
Work, Check Mailing, and Residence Address Extract


Description:
Salary+Fringe Hourly Rates Export for AIMS


Description:
State and Federal Applicable Gross Report


Description:
Accounts Payable Bank Reconciliation Table: fabbktp Report


Description:
Accounts Payable Bank unReconciliation Table: fabbktp Report


Description:
Outstanding Checks - Operating Bank Account


Description:
Checks Issued on the Operating Bank Account


Description:
JE15 Transactions on the Operating Bank Account


Description:
Outstanding Checks - State Treasury Bank Account


Description:
Clear Records from APPROVAL Table No Longer In Process and Unapproved


Description:
Gathers Approval Records from FOBUAPP, Controls when approval_periodic.sql


Description:
Audit Listing for APPROVAL and FOBUAPP Tables


Description:
generate 'Requisitions Awaiting Your Approval' email reports


Description:
generate 'Requisitions Pending Approval with Errors' email reports


Description:
generate 'Requisitions Long Pending Approval' email reports


Description:
Non-Check Transactions on the Operating Bank Account


Description:
Checks Voided on the Operating Bank Account


Description:
Balance Sheet Summary by Fund Group and Account Type, and Fund Code


Description:
Bank Reconciliation Table: phrbktp Report


Description:
Budgeting Cost of Living Speadsheet Extract


Description:
Split the bdncinc information into separate files


Description:
Batch Journal Voucher Load Category 2 - Generic Batch JV Load to GURFEED


Description:
loads all transactions as (cat B) to bjvfins


Description:
loads (cat E) Accounts Receivable to GURFEED directly


Description:
will load (cat F) Reversal A/R on the 1st on the Month


Description:
loads (cat G) UAF Salary Settlement to GURFEED directly


Description:
loads (cat J) Unbilled Accounts Receivable to GURFEED directly


Description:
will load (cat K) Reversal Unbilled A/R as the 1st of the Month after Cat J


Description:
Extracts Blanket PO Data from Banner for Export


Description:
Non-Check Transactions on the State Treasury Account-CAA-02


Description:
Insurance Report and Extract for Cancer Insurance


Description:
Non-Check Transactions on the State Treasury Account-CES


Description:
YTD Summary of Revenues and Expenditures by Fund Group and Account Type


Description:
Compare 403B maximum salary reductions -> compdedn.lst


# Service Level Current Charges

Service Name:
Jeff Branson Air Card ORGN 7300 FUND 28251


Service Name:
Tracia Coney-Tinzie ORGN 6300 FUND 25005


# 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


# 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:
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:
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:
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


