Banner Tables July 2009

OWNERTABLE_NAMECOMMENTS
ALUMNIAABDINSMembership Dues Installment Base Table
ALUMNIAABDUESDues Entry Base Table
ALUMNIAABMINTMembership Interest Header Table
ALUMNIAABMSHPMembership Header Table
ALUMNIAARACKNMembership Ackowledgement Repeating Table
ALUMNIAARACKRMembership Ackowledgement Rules Table
ALUMNIAARAJBDBase Dues Adjustment Table
ALUMNIAARAJINIndividual Membership Interest Adjustment Table
ALUMNIAARAJRDDues Adjustment Repeating Table
ALUMNIAARAKCTMembership Category Type Include/Exclude Rules Table
ALUMNIAARAKDNMembership Donor Categories Include/Exclude Table
ALUMNIAARAKEXMembership Category Type Include/Exclude Rules Table
ALUMNIAARAKINInterest Include/Exclude Rules Table
ALUMNIAARAKMBMembership Include/Exclude Rules Table
ALUMNIAARCMEMCo-Membership Repeating Table
ALUMNIAARDINSDues Installment Table
ALUMNIAARDUESDues Entry Table
ALUMNIAARINCMMembership Header Interests Comments Table
ALUMNIAARMBCMMembership Header Comments Table
ALUMNIAARMBDPMembership Default Premium/Benefits Rule Table
ALUMNIAARMBINMembership Header Interest Table
ALUMNIAARMBRLMembership Rules Table
ALUMNIAARMCHGThis table is used to maintain changes to tables associated with the AA_MEMBERSHIP composite view for incremental refresh processing in the ODS.
ALUMNIAARMCMTIndividual Membership Comments Table
ALUMNIAARMEMBMembership Repeating Table
ALUMNIAARMINTIndividual Membership Interest Table
ALUMNIAARMPREIndividual Premium Repeating Table
ALUMNIAARRLETMembership Reminder/Renewal Letter Table
ALUMNIADBCTRLDesignation Supervisor Table
ALUMNIADBDESGDesignation Base Table                   
ALUMNIADRADAJDesignation Adjustment Repeating Table   
ALUMNIADRATTRDesignation Attributes Table
ALUMNIADRCOMTDesignation Comment Repeating Table      
ALUMNIADRCONFDesignation Comment Confidentiality Table
ALUMNIADRDIDSDesignation IDs Table
ALUMNIADRFUNDDesignation Financial Aid Funds Table
ALUMNIADRPCMTDesignation Comments Table
ALUMNIADRSUBJDesignation Comments Subject Table
ALUMNIADRSUMMDesignation Summary Repeating Table      
ALUMNIADRYEARDesignation Year Table. This tables defines the years which are valid for a designation.
APLOCALADVEXTR_TEMP 
BANINST1ADV_TEMP 
APLOCALADV_TT_CONTACT_VBS 
ALUMNIAERCPDGFunction Campaign/Designation Table
ALUMNIAERPROJFunction Projects Table
ALUMNIAFBCAMPCampaign Base Table                      
ALUMNIAFRCOMTCampaign Comment Repeating Table         
ALUMNIAFRCORGCampaign Organization Repeating Table    
ALUMNIAFRCRESCampaign Result Repeating Table          
ALUMNIAFRCSLTCampaign Solicitor Repeating Table       
ALUMNIAFRCSOLCampaign Solicitation Type Repeating Table    
ALUMNIAFRCTYPCampaign Contact Repeating Table         
ALUMNIAFRDESGDesignation In Campaign Repeating Table  
ALUMNIAFREXPNCampaign Expense Repeating Table         
ALUMNIAFRMAILCampaign Mail Code Repeating Table       
ALUMNIAGBCSHRAdvancement Cashier Session Table
ALUMNIAGBCTRLControl Defaults Table
ALUMNIAGBGHLDWeb Gift Detail Hold Table.
ALUMNIAGBGIFTGift/Pledge Payment Base Table           
ALUMNIAGBIDRLSplit Pledge/Gift Rule for ID Base Table
ALUMNIAGBMGIDMatching Gift Waiting Id Base Table      
ALUMNIAGBPDEFPledge/Gift Default Camp/Desg            
ALUMNIAGBPINSPledge Installment Base Table            
ALUMNIAGBPLDGPledge Base Table                        
ALUMNIAGBSPRLSplit Pledge/GifT Rule Base Table
ALUMNIAGBWPLGWeb Pledge Header Table. Collects information for pledges from the Web.
ALUMNIAGRACHGThis table is used to maintain changes to tables associated with the AA_ANNUAL_GIVING composite view for incremental refresh processing in the ODS.
ALUMNIAGRACKNGift Acknowledgement Table
ALUMNIAGRACKRGift Acknowledgement Rules Table
ALUMNIAGRADJRPrior Years Adjustment Rule Table        
ALUMNIAGRAGDSGift/Pledge Payment Adjustment Designation Table 
ALUMNIAGRAGIFGift/Pledge Payment Adjustment Table    
ALUMNIAGRAKCPGift Acknowledgement Campaign Table
ALUMNIAGRAKCTGift Acknowledgement Campaign Types Table
ALUMNIAGRAKDCGift Acknowledgement Donor Club Table
ALUMNIAGRAKDGGift Acknowledgement Designation Table
ALUMNIAGRAKDNGift Acknowledgement Donor Categories Table
ALUMNIAGRAKEXGift Acknowledgement Exclusion Code Table
ALUMNIAGRAKGCGift Acknowledgement Gift Class Table
ALUMNIAGRAKGTGift Acknowledgement Gift Type Table
ALUMNIAGRAKPCGift Acknowledgement Preferred Class Table
ALUMNIAGRALETGift Acknowledgement Advancement Letter Table
ALUMNIAGRAPDSAdjustment Pledge Designation Table      
ALUMNIAGRAPLGAdjustment Pledge Base Table             
ALUMNIAGRGASCAssociated ID Table
ALUMNIAGRGAUXGift Auxiliary Amount Table.
ALUMNIAGRGCAMGift Campaign Repeating Table            
ALUMNIAGRGCHGThis table is used to maintain changes to tables associated with the AA_GIFT composite view for incremental refresh processing in the ODS.
ALUMNIAGRGDESGift Designation Repeating Table         
ALUMNIAGRGHDEWeb Gift Detail Hold Table.
ALUMNIAGRGIDSGift Multiple Id Repeating Table         
ALUMNIAGRGMEMGift Memo Id Repeating Table             
ALUMNIAGRGMLTDetail Gift Multiple Credit Table
ALUMNIAGRGMMODetail Gift Memo Credit Table
ALUMNIAGRGPAYGift/Pledge Payment Repeating Table      
ALUMNIAGRGSOLGift Solicitor Repeating Table           
ALUMNIAGRIDRLSplit Pledges/Gifts for ID Rule Table
ALUMNIAGRLCHGThis table is used to maintain changes to tables associated with the AA_GIFT_MULTIPLE composite view for incremental refresh processing in the ODS.
ALUMNIAGRMCAMMatching Gift Campaign Repeating Table   
ALUMNIAGRMCHGThis table is used to maintain changes to tables associated with the AA_GIFT_MEMO composite view for incremental refresh processing in the ODS.
ALUMNIAGRMDESMatching Gift Designation Repeating Table
ALUMNIAGRMGIFMatching Gift Ident Repeating Table      
ALUMNIAGRMSOLMatching Gift Solicitor Repeating Table  
ALUMNIAGRPASCAssociated ID Table
ALUMNIAGRPAUXPledge Auxiliary Data Table
ALUMNIAGRPCAMPledge Campaign Repeating Table          
ALUMNIAGRPCHGThis table is used to maintain changes to tables associated with the AA_PLEDGE composite view for incremental refresh processing in the ODS.
ALUMNIAGRPCONPledge Condition Table
ALUMNIAGRPDESPledge Designation Repeating Table       
ALUMNIAGRPIDSPledge Multiple Id Repeating Table       
ALUMNIAGRPINSPledge Installment Repeating Table       
ALUMNIAGRPMEMPledge Memo Id Repeating Table           
ALUMNIAGRPMLTDetail Pledge Multiple Credit Table
ALUMNIAGRPMMODetail Pledge Memo Credit Table
ALUMNIAGRPSOLPledge Solicitor Repeating Table         
ALUMNIAGRRCPTTax Receipt Table
ALUMNIAGRSPRLSplit Pledges/Gifts Rule Table
ALUMNIAGRTEMPTemporary table to be used for internal processing within processes
ALUMNIAGRTFEDFeed to Finance Temporary Table
ALUMNIAGRTMP2Temporary table to be used for internal processing from within processes
ALUMNIAGRTPFDData Field Position Rule Table.
ALUMNIAGRWPRM 
ALUMNIAGTCHI1This table is used as the first staging table to get all gift and pledge records without the amounts
ALUMNIAGTCHISThis table is used as a staging table to get all gift and pledge records with the amounts
ALUMNIAGTGTCRThis Gift Credit staging table holds data for household giving
ALUMNIAGTOGIVCombined Lifetime Giving for a spouse pair.
ALUMNIAMBMAILMailing Address Base Table               
ALUMNIAMBPLANProspect Management Strategy Plan Base Table
ALUMNIAMBPROPProspects Proposals Base Table
ALUMNIAMBSTGYProspect Management Strategy Assignment Table
ALUMNIAMRCONFProspect Confidentiality Table
ALUMNIAMRCONTProspect Contact Table
ALUMNIAMRDESGPledge Condition Table
ALUMNIAMREXRTProspect External Ratings Table
ALUMNIAMRINFOProspect Information Table
ALUMNIAMRMCHGThis table is used to maintain changes to tables associated with the AA_CONSTITUENT_PLAN composite view for incremental refresh processing in the ODS.
ALUMNIAMRPCCMProspect Contact Comment Table
ALUMNIAMRPCHGThis table is used to maintain changes to tables associated with the AA_PROSPECT_INFO composite view for incremental refresh processing in the ODS.
ALUMNIAMRPCMTProspect Comment Table
ALUMNIAMRPEXPProspect Expense Table
ALUMNIAMRPLANProspect Management Strategy Planning Table
ALUMNIAMRPRINProspect Project/Interest Table
ALUMNIAMRPROPProspects Proposals Projects repeating Table
ALUMNIAMRPRRTProspect Rating Table
ALUMNIAMRPRSCProspect Research Information Table
ALUMNIAMRPSRCProspect Source Information Table
ALUMNIAMRPUSRProspect User Defined Table
ALUMNIAMRSTAFProspect Staff Assignment Table
ALUMNIAMRSTGYProspect Management Strategy Plan Rule Table
ALUMNIAMRSUBJProspect Subject Comment Table
ALUMNIAOBDOSRAdvancement Officer Search Options Preference Header Table
ALUMNIAOBDOWPDevelopment Officer Profile Preference Header Table.
ALUMNIAOBORGNOrganization Base Table
ALUMNIAOBSTMPDevelopment Officer Search Temporary Table.
ALUMNIAOBWRULAdvancement Self-Service Rules Header Table, defines rules for Web processing.
ALUMNIAORCONTOrganization Contact Repeating Table     
ALUMNIAORDOSRAdvancement Officer Search Options Preference Repeating  Table
ALUMNIAORDOWPDevelopment Officer Profile Preference Repeating Table.
ALUMNIAORFUNDOrganization Fund  Table
ALUMNIAORJPSTJob Posting Repeating Table, stores job postings from Web users.
ALUMNIAORMACCMatching Gift Institution Accreditation Table
ALUMNIAORMASTMatching Gift Advancement Status Table
ALUMNIAORMCTLMatching Gift Institution Control Table
ALUMNIAORMDEFMatching Gift Deferred Gift Table
ALUMNIAORMEDUMatching Gift Education Institute Types for an Orgainzation.
ALUMNIAORMERQMatching Gift Employment Requirements Table
ALUMNIAORMGCDMatching Gift Campaign/Designation Ratio Table
ALUMNIAORMGCMMatching Gift Comments Table
ALUMNIAORMINDMatching Gift Industry Code Table
ALUMNIAORMLOCMatching Gift Institution Location Table
ALUMNIAORMLVLMatching Gift Level of Institution Table
ALUMNIAORMNATMatching Gift National Associations Table
ALUMNIAORMNEDMatching Gift Non-educational Institution Table
ALUMNIAORMPROMatching Gift Procedure Table
ALUMNIAORMPURMatching Gift Related Purpose Table
ALUMNIAORMRTOMatching Gift Campaign/Designation Ratio Table
ALUMNIAOROCHGThis table is used to maintain changes to tables associated with the AA_ORGANIZATIONAL_CONSTITUENT composite view for incremental refresh processing in the ODS.
ALUMNIAPBCONSConstituent Base Table                   
ALUMNIAPBCTRLConstituent Comment Supervisor Control Table
ALUMNIAPBGHISGiving History Summary Base Table        
ALUMNIAPBWIDNWeb Access Base Record Hold Table.
ALUMNIAPBWSESAdvancement Self-Service Session Header Table
ALUMNIAPRACLDActivity Leadership Table
ALUMNIAPRACTYSpecial Activity Repeating Table         
ALUMNIAPRACYRSpecial Activity Year Repeating Table    
ALUMNIAPRADEGAcademic Degree Repeating Table          
ALUMNIAPRAMAJAcademic Major Repeating Table           
ALUMNIAPRCATGAlumni Category Repeating Table          
ALUMNIAPRCCHGThis table is used to maintain changes to tables associated with the AA_CONSTITUENT composite view for incremental refresh processing in the ODS.
ALUMNIAPRCCMTChildren Comment Repeating Table         
ALUMNIAPRCHISGiving History By Campaign Repeating Table    
ALUMNIAPRCHLDChildren Repeating Table                 
ALUMNIAPRCOMTConstituent Comment Repeating Table      
ALUMNIAPRCONFSolicitor Contacts Results repeating table.
ALUMNIAPRCRVWChild data load table.
ALUMNIAPRCSPSConstituent Spouse Table
ALUMNIAPRDCCMGift Society Comments Table              
ALUMNIAPRDCCPGift Society Campaign Rule Table
ALUMNIAPRDCCTGift Society Campaign Type Rule Table
ALUMNIAPRDCDCGift Society Donor Code Rule Table
ALUMNIAPRDCDPGift Society Donor Club Default Premiums Table
ALUMNIAPRDCDSGift Society Designation Rule Table
ALUMNIAPRDCGLGift Society Member Goal repeating table.
ALUMNIAPRDCGTGift Society Gift Code Rule Table
ALUMNIAPRDCHGThis table is used to maintain changes to tables associated with the AA_DESIGNATION_GIVING_HISTORY composite view for incremental refresh processing in the ODS.
ALUMNIAPRDCLBGift Society Table                       
ALUMNIAPRDCPCGift Society Preferred Year Rule Table
ALUMNIAPRDCPRGift Society Benefits/Premiums Table     
ALUMNIAPRDCRLGift Society Rule Table
ALUMNIAPRDCTMGift Society Temporary Processing Table
ALUMNIAPRDCXRGift Society Cross Reference Rule Table
ALUMNIAPRDHISGiving History By Desg Repeating Table   
ALUMNIAPRDRVWDegree data load table.
ALUMNIAPRECMTEmployment Comment Repeating Table       
ALUMNIAPREHISEmployment History Repeating Table       
ALUMNIAPRERVWEmployer data load table.
ALUMNIAPREXCLExclusion Code Repeating Table           
ALUMNIAPRHCHGThis table is used to maintain changes to tables associated with the AA_CAMPAIGN_GIVING_HISTORY composite view for incremental refresh processing in the ODS.
ALUMNIAPRIGRPPersonal Interest Group Table.
ALUMNIAPRMAILMail Code Repeating Table                
ALUMNIAPRPCMTConstituent Comment Table
ALUMNIAPRPMEMProcedural Memo Repeating Table          
ALUMNIAPRPROSSpecial Purpose Repeating Table          
ALUMNIAPRSALUSalutation Repeating Table               
ALUMNIAPRSRVWSpouse  data load table.
ALUMNIAPRSUBJProspect Subject Comment Table
ALUMNIAPRTCFACFAE Processing Temporary Table
ALUMNIAPRTPFDData Field Process Rules Table.
ALUMNIAPRTRANData Translation table.
ALUMNIAPRVIPCAdvancement Vip Code Repeating Table
ALUMNIAPRXREFCross Reference Repeating View
ALUMNIAPTADDRTemporary table used to track household information when viewing/updating addresses for all household members.
ALUMNIAPTCHISTemporary Giving History table used by the afixpd.sql process.
ALUMNIAPTDHISTemporary Giving History table used by the afixpd.sql process.
APLOCALAPTEMP_SYRR255 
ALUMNIAPTPCHNAdvancement Prospect Channel Temporary Table
ALUMNIAPTTELE 
BANINST1AQ$_EVENT_BULKSYNC_TABLE_G 
BANINST1AQ$_EVENT_BULKSYNC_TABLE_H 
BANINST1AQ$_EVENT_BULKSYNC_TABLE_I 
BANINST1AQ$_EVENT_BULKSYNC_TABLE_S 
BANINST1AQ$_EVENT_BULKSYNC_TABLE_T 
BANINST1AQ$_EVENT_SYNC_TABLE_G 
BANINST1AQ$_EVENT_SYNC_TABLE_H 
BANINST1AQ$_EVENT_SYNC_TABLE_I 
BANINST1AQ$_EVENT_SYNC_TABLE_S 
BANINST1AQ$_EVENT_SYNC_TABLE_T 
ALUMNIASBSORGSolicitor Organization Base Table        
ALUMNIASRCOMTSolicitor Organization Comment Repeating Table
ALUMNIASRCONTSolicitor Contact Types Repeating Table  
ALUMNIASRCORGSolicitor Organization Hierarchy Table 
ALUMNIASRSOAGSolicitor Organization Annual Goals Table 
ALUMNIASRSORGSolicitor Organization Repeating Table   
ALUMNIASRSSAGSolicitor Annual Goals Table 
ALUMNIATVADJTDesignation Adjustment Type Validation Table  
ALUMNIATVAMCTMembership Category Code Validation Table
ALUMNIATVAMGPMembership Group Code Validation Table
ALUMNIATVAMINMembership Interest Type Validation Table
ALUMNIATVAMPMMembership Promotion Code Validation Table
ALUMNIATVAMSTMembership Status Code Validation Table
ALUMNIATVAMTPMembership Type Validation Table
ALUMNIATVASSCAssociated Appraiser Type Code Table
ALUMNIATVAUXLAuxiliary Code Table
ALUMNIATVCFAECFAE Code Validation Table               
ALUMNIATVCMTPCampaign Type Validation Table           
ALUMNIATVCONTSolicitor Contact Types Validation Table 
ALUMNIATVCTYPPledge Condition Type Code Validation Table
ALUMNIATVDATRDesignation Attributes Code Table
ALUMNIATVDCAMGift Society Assignment Validation Table 
ALUMNIATVDCNPGift Society Validation Table            
ALUMNIATVDCPRGift Society Premiums Validation Table   
ALUMNIATVDCSTGift Society Type Validation Table
ALUMNIATVDCYRGift Society Year Validation Table       
ALUMNIATVDGRPDesignation Group Table
ALUMNIATVDISTDesignation ID Status Table
ALUMNIATVDITPDesignation ID Type Table
ALUMNIATVDNAMDefault Name Code Validation Table.
ALUMNIATVDONRDonor Category Validation Table          
ALUMNIATVDOSRAdvancement Officer Search Options Table
ALUMNIATVDOTTDOTT Codes Validation Table              
ALUMNIATVDOWPDevelopment Officer Web Profile Items Validation Table.
ALUMNIATVDSRCData Source Identifier Validation Table.
ALUMNIATVDSTADesignation Status Code Table
ALUMNIATVDSTPDesignation Type Validation Table
ALUMNIATVEMPSEmployment Status Validation Table
ALUMNIATVEXCLAdvancement Exclusion Codes Validation Table
ALUMNIATVEXRSExternal Ratings Source Validation Table
ALUMNIATVFISCFiscal Year Validation Table             
ALUMNIATVFREQPledge Frequency Validation Table        
ALUMNIATVFUNDFund Code Validation Table
ALUMNIATVGACKGift Range Validation Table
ALUMNIATVGCLSGift Classification Validation Table     
ALUMNIATVGIFTGift Type Validation Table               
ALUMNIATVGIVHGiving Vehicle Validation Table
ALUMNIATVGIVLGiving Level Validation Table            
ALUMNIATVIGRPInterest Group Code Validation Table
ALUMNIATVINCMIncome Validation Table                  
ALUMNIATVJOBCJob Category Validation Table            
ALUMNIATVMACCMatching Gift Institution Accreditation Validation Table
ALUMNIATVMASTMatching Gift Alumni Status Validation Table
ALUMNIATVMCTLMatching Gift Institution Control Validation Table
ALUMNIATVMDEFMatching Gift Deferred Code Validation Table
ALUMNIATVMDISMatching Gift Distribution Validation Table
ALUMNIATVMEDU 
ALUMNIATVMERQMatching Gift Employment Requirments Validation Table
ALUMNIATVMINDMatching Gift Industry Codes Validation Table
ALUMNIATVMLOCMatching Gift Institution Location Code Validation Table
ALUMNIATVMLVLMatching Gift Level of Institution Validation Table
ALUMNIATVMNATMatching Gift National Assoc Code Validation Table
ALUMNIATVMNEDMatching Gift Non-educational Inst. Validation Table
ALUMNIATVMOVEMove Type Validation Table
ALUMNIATVMPROMatching Gift Procedure Validation Table
ALUMNIATVMPURMatching Gift Related Purpose Validation Table
ALUMNIATVOCONOrganization Contact Type Validation Table    
ALUMNIATVPACKPledge Range Validation Table
ALUMNIATVPCATPledge Category Code Validation Table
ALUMNIATVPCLSPledge Classification Validation Table
ALUMNIATVPDURPledge Duration Validation Table         
ALUMNIATVPGVEPledge Gift Vehicle Code Validation Table.
ALUMNIATVPLDGPledge Type Validation Table
ALUMNIATVPRCDSpecial Purpose Code Validation Table
ALUMNIATVPRMDPledge Reminder Type Validation Table    
ALUMNIATVPROJProject/Interest Area Validation Table
ALUMNIATVPROPProposal Code Validation Table
ALUMNIATVPRSTProspect Status Code Table
ALUMNIATVPRTPSpecial Purpose Type Validation Table
ALUMNIATVPSTAPledge Status Validation Table           
ALUMNIATVRATERate Code Validation Table
ALUMNIATVREFRProspect Reference Code Validation Table
ALUMNIATVRSCRRating Screening Code Validation Table
ALUMNIATVRSTAReceipt Status Code Table
ALUMNIATVRTGTRating Type Code Validation Table
ALUMNIATVSALUSalutation Type Validation Table         
ALUMNIATVSCNTSolicitor Contact Validation Table       
ALUMNIATVSCRSSolicitor Contact Result Validation Table
ALUMNIATVSICCSIC Code Validation Table                
ALUMNIATVSOLCSolicitation Code Validation Table       
ALUMNIATVSOLTSolicitor Type Validation Table          
ALUMNIATVSORCSource Code Validation Table
ALUMNIATVSOTPSolicitor Org Type Validation Table      
ALUMNIATVSRCESource Code Validation Table
ALUMNIATVSSTASolicitor/Organization Status Validation Table 
ALUMNIATVSTFTStaff Type Code Validation Table
ALUMNIATVTAPEData File Validation Table.
ALUMNIATVTPFDData Field Names Validation Table.
ALUMNIATVUSRCUser Defined Code Validation Table
ALUMNIATVVIPCVariable Purpose Code Validation Table
ALUMNIATVXREFCross Reference Validation Table         
ALUMNIAUBCTRLSupervisor Control Table
ALUMNIAUBIGRPInterest Group Detail Header Table.
ALUMNIAUBINSTAdvancement Installation Control Table
ALUMNIAURVERSAdvancement Version Tracking Table
ALUMNIAXBMGIDExpected Matching Gift Waiting ID base table.
ALUMNIAXRDCPTGift Society Pledge Type Rule table.
ALUMNIAXRMCAMExpected Matching Gift Campaign repeating table.
ALUMNIAXRMDESExpected Matching Gift Designation repeating table.
ALUMNIAXRMGRNMatching Gift Reason table.
ALUMNIAXRMSOLExpected Matching Gift Solicitation repeating table.
FIMSMGRBETH_PYRFEED 
BWAMGRBWAVERSAdvancement Self-Service Version Tracking Table
BWFMGRBWFVERSFinance Self-Service Version Tracking Table.
BWGMGRBWGVERSWeb General Version Tracking Table
BWLMGRBWLVERSFaculty and Advisors Self-Service Version Tracking Table
BWPMGRBWPVERSEmployee Self-Service Version Tracking Table
BWRMGRBWRVERSFinancial Aid Self-Service Version Tracking Table
BWSMGRBWSVERSStudent Self-Service Version Tracking Table
APLOCALBYSTUWDR 
APLOCALBYSTWRSN 
BANINST1CLN_NCOA 
BANINST1CREATE$JAVA$LOB$TABLE 
BANINST1EVENT_BULKSYNC_TABLE 
BANINST1EVENT_SYNC_TABLE 
FIMSMGREXCEPTIONS 
GENERALEXCEPTIONS 
PAYROLLEXCEPTIONS 
BANSECREXCEPTIONS 
SATURNEXCEPTIONS 
TAISMGREXCEPTIONS 
WTAILOREXCEPTIONS 
FAISMGREXCEPTIONS 
ALUMNIEXCEPTIONS 
POSNCTLEXCEPTIONS 
FIMSMGRFAB10991099 Tax Detail Table
FIMSMGRFABBKTPBank Tape Table
FIMSMGRFABBRCC 
FIMSMGRFABCHKABatch Check/Invoice Detail Table
FIMSMGRFABCHKSCheck Summary Table
FIMSMGRFABCKMCMATCHING REPORT COLLECTOR TABLE: Used  when running the report fabmatc to group the processed invoices for reporting purposes.
FIMSMGRFABFEDCFed Credit Card Transaction Control Table.
FIMSMGRFABINCKInvoice/Check Table
FIMSMGRFABINVHInvoice Header Table
FIMSMGRFABINVTPurchase Card Transactions Header Table.
FIMSMGRFABREBTTax Rebate Maintenance Table.
FIMSMGRFABRUIVReusable Invoice Table
FIMSMGRFARACHGThis table is used to maintain changes to tables associated with the AF_INVOICE_ACCOUNTING composite view for incremental refresh processing in the ODS.
FIMSMGRFARBCHGThis table is used to maintain changes to tables associated with the AF_CHECKS composite view for incremental refresh processing in the ODS.
FIMSMGRFARBKTHBank Tape History Table
FIMSMGRFARCCHGThis table is used to maintain changes to tables associated with the AF_INVOICE_CHECK composite view for incremental refresh processing in the ODS.
FIMSMGRFARCKMCMATCHING REPORT COLLECTOR TABLE: Used in the matching report fabmatc to group invoice commodity records for reporting purposes.
FIMSMGRFARDCHGThis table is used to maintain changes to tables associated with the AF_INVOICE composite view for incremental refresh processing in the ODS.
FIMSMGRFARDIRDDirect Deposit Table.
FIMSMGRFARICHGThis table is used to maintain changes to tables associated with the AF_INVOICE_ITEM composite view for incremental refresh processing in the ODS.
FIMSMGRFARINTXInvoice Tax Allocation Table
FIMSMGRFARINVAInvoice Accounting Table
FIMSMGRFARINVCInvoice Commodity Table
FIMSMGRFARINVTPurchase Card Transactions Accounting Table.
FIMSMGRFARREBTMultiple Tax Rebate Maintenance Table.
FIMSMGRFARTCHGThis table is used to maintain changes to tables associated with the AF_INVOICE_TAX_RATE composite view for incremental refresh processing in the ODS.
FIMSMGRFARVICMMultiple Vendor Invoice Commodity Collector Table
FIMSMGRFARVINVMultiple Vendor Invoice Cross Reference Table
FIMSMGRFARXCHGThis table is used to maintain changes to tables associated with the AF_ACCOUNT_INDEX composite view for incremental refresh processing in the ODS.
FIMSMGRFATCARDTemporary Purchase Card Transactions Table.
FIMSMGRFATCKDTBatch Check/Invoice Detail Temporary Table
FIMSMGRFATCKINBatch Check/Invoice Temporary Table
FIMSMGRFATCKNOBatch Check Number Temporary Table
FIMSMGRFATTAXBMagnetic 1099 Record B
FIMSMGRFATTAXT Temporary 1099 Magnetic Tape DATA
FIMSMGRFBBBLIN 
FIMSMGRFBBBPRCBudget Process Control Table
FIMSMGRFBBCHGPMASS CHANGE PARAMETER TABLE
FIMSMGRFBBLOCKOrganization Lock Table.
FIMSMGRFBRATHCACCT HIERARCHY Table    
FIMSMGRFBRAUDTBudget Line Audit History Table.
FIMSMGRFBRBCHGThis table is used to maintain changes to tables associated with the AF_BUDGET_DETAIL composite view for incremental refresh processing in the ODS.
FIMSMGRFBRBDLCOrganization Lock Collector Table.
FIMSMGRFBRBDPRBudget Process Delete Table
FIMSMGRFBRBDQCBUDGET QUERY Table    
FIMSMGRFBRBDWCBudget Worksheet Colletor Table.
FIMSMGRFBRDISP 
FIMSMGRFBRDIST 
FIMSMGRFBRFDHCFUND HIER Table for Budget Distrib
FIMSMGRFBRFEDCPosition Control Budget Update Collector Table
FIMSMGRFBRLNBPBudget Build FOAPAL Options Parameter Table.
FIMSMGRFBRLOHCLOCN HIER Table for Budget Distrib
FIMSMGRFBRORHCORGN HIER Collector Table for Budget Distribution
FIMSMGRFBRPGHCPROG HIER Table for Budget Distrib
FIMSMGRFBRWKSHFBRWKSH REPORT Collector Table
FIMSMGRFBTBLINTEMPORARY BUDGET LINE ITEM TABLE
FIMSMGRFCBEMPLEmployee Table
FIMSMGRFCBPARMCost Accounting Batch Parameter Table
FIMSMGRFCBPHSTProject History Table
FIMSMGRFCBPRJCProject/Customer Charges Table
FIMSMGRFCBPRJDProject Detail Table
FIMSMGRFCBRATEInternal Rates Table
FIMSMGRFCREMPOEmployee/Org/Classification Table
FIMSMGRFCTBDTRTemporary Billing Detail Report Table
FIMSMGRFEABATCEDI BATCH PROCESSING TABLE
FIMSMGRFEBEDICEDI Control File:  This file contains one record with flags indicating if a Banner Finance module is EDI enabled.
FIMSMGRFEREDICEDI Transaction Control File.
FIMSMGRFERPHSTEDI PO History Table.
FIMSMGRFFBADJHAdjustment to Fixed Assets Header Table.
FIMSMGRFFBDSMCFixed Asset Depreciation Summary Collector Table
FIMSMGRFFBDTGHFixed asset DTAG header Table
FIMSMGRFFBMASTFixed Asset Master table
FIMSMGRFFBOTAGFixed Asset Origination Tag Table
FIMSMGRFFBSYSCFixed Assets System Control
FIMSMGRFFRACHGThis table is used to maintain changes to tables associated with the FINANCE ATTRIBUTE composite views for incremental refresh processing in the ODS.
FIMSMGRFFRADJAFixed Assets Adjustment Accounting Detail Table.
FIMSMGRFFRADJDAdjustment to Fixed Assets Detail Table.
FIMSMGRFFRDEMCFixed Asset Depreciation Error Message Collector table
FIMSMGRFFRDEPRFixed Asset Depreciation History table
FIMSMGRFFRDTGAFixed asset DTAG Accounting Table
FIMSMGRFFRDTGDFixed asset DTAG detail Table.
FIMSMGRFFREXTCFixed Asset Origination Tag Extraction Collector Table
FIMSMGRFFRFCHGThis table is used to maintain changes to tables associated with the AF_FIXED_ASSET_DEPRECIATION composite view for incremental refresh processing in the ODS.
FIMSMGRFFRFUSNFixed Assset User Defined Attributes Table
FIMSMGRFFRICHGThis table is used to maintain changes to tables associated with the AF_FIXED_ASSET_ITEM composite view for incremental refresh processing in the ODS.
FIMSMGRFFRJCHGThis table is used to maintain changes to tables associated with the AF_FIXED_ASSET_ADJUSTMENT composite view for incremental refresh processing in the ODS.
FIMSMGRFFRMASAFixed Assets Capitalization and Depreciation Accounting Table.
FIMSMGRFFRMASFFixed Assets Accounting Source Table.
FIMSMGRFFRTRANFixed Asset Transfer table
FIMSMGRFFVACONFixed Asset Condition Code Table
FIMSMGRFFVACQMFixed Asset Acquisition Method Code Table
FIMSMGRFFVDISPFixed Asset Disposal Method Code Table
FIMSMGRFFVSDATFixed Asset User Defined Attributes Validation Table.
FIMSMGRFFVTTSTFixed Asset Title-To Code Table
FIMSMGRFGADOCBDocument Balancing Temp Table
FIMSMGRFGBARCDArchived Documents Table
FIMSMGRFGBAUTOAutomatic Journal Voucher Table
FIMSMGRFGBBAVCBudget Availability Ledger Temporary Table.
FIMSMGRFGBBAVLBudget Availability Ledger Table
FIMSMGRFGBCSHDDirect Cash Receipt Detail Table.
FIMSMGRFGBCSHHDirect Cash Receipt Header Table.
FIMSMGRFGBENCDEncumbrance Distribution Table
FIMSMGRFGBENCHEncumbrance Ledger Header Table
FIMSMGRFGBENCPEncumbrance Period Detail Table
FIMSMGRFGBGENLGeneral Ledger Table
FIMSMGRFGBGPFCFGBGPFC Opal Collector Table
FIMSMGRFGBJVCDJournal Voucher Detail Table
FIMSMGRFGBJVCHJournal Voucher Header Table
FIMSMGRFGBOPALOperating Account Ledger Table
FIMSMGRFGBRCLELedger reclassification Entries table.
FIMSMGRFGBTRNDTransaction History Detail Table
FIMSARCFGBTRNDArchive Transaction History Detail Table
FIMSMGRFGBTRNHTransaction History Table
FIMSARCFGBTRNHArchive Transaction History Table
FIMSMGRFGBTRNITransaction Input Table
FIMSMGRFGBYRLMYear-End Maintenance
FIMSMGRFGRATHCACCT HIERARCHY Table    
FIMSMGRFGRBABCBavl Posting Backout Collector Table
FIMSMGRFGRBAKCBAKO - like Collector Table.
FIMSMGRFGRBAKOBavl Posting Backout Table
FIMSMGRFGRBCHGThis table is used to maintain changes to tables associated with the AF_BUDGET_AVAILABILITY_LEDGER composite view for incremental refresh processing in the ODS.
FIMSMGRFGRCFBCREOC REPORT Table    
FIMSMGRFGRCGBCREPORT COLLECTOR Table 
FIMSMGRFGRCGSCREPORT COLLECTOR Table 
FIMSMGRFGRCSBCREPORT COLLECTOR Table 
FIMSMGRFGRCSHDDirect Cash Receipt Tax and Rebate Table.
FIMSMGRFGRCTRCControl Report Collector Table
FIMSMGRFGRDCHGThis table is used to maintain changes to tables associated with the AF_TRANSACTION_DETAIL composite view for incremental refresh processing in the ODS.
FIMSMGRFGRECHGThis table is used to maintain changes associated with the AF_ENCUMBRANCE composite view for incremental refresh processing in the ODS.
FIMSMGRFGRFDHCFUND HIERARCHY Table    
FIMSMGRFGRFDSCREPORT COLLECTOR Table 
FIMSMGRFGRFNDCCollector table for fund hierarchy for Budget Availability Checking
FIMSMGRFGRFPHCFTYP HIERARCHY Table    
FIMSMGRFGRFTPCREPORT COLLECTOR Table 
FIMSMGRFGRFTSCFUND TYPE SEQUENCE COLLECTOR Table 
FIMSMGRFGRGCHGThis table is used to maintain changes to tables associated with the AF_GENERAL_LEDGER composite view for incremental refresh processing in the ODS.
FIMSMGRFGRGENCFGRACTG RPT Collector Table
FIMSMGRFGRGRNTGrant Accounting Table
FIMSMGRFGRGRTCGrant Conversion Edit Table 
FIMSMGRFGRINTADistributed interest calculation table with balances
FIMSMGRFGRINTCDistributed interest calculation table
FIMSMGRFGRLCHGThis table is used to maintain changes associated with the AF_ENCUMBRANCE composite view for incremental refresh processing in the ODS.
FIMSMGRFGRLISCLINE ITEM SEQUENCE COLLECTOR Table 
FIMSMGRFGRLOHCLOCN HIER Table for Budget Roll Query
FIMSMGRFGROCHGThis table is used to maintain changes to tables associated with the AF_OPERATING_LEDGER composite view for incremental refresh processing in the ODS.
FIMSMGRFGROPPCOperation Ledger/General Ledger Control Account Collector Table.
FIMSMGRFGROPRCFGROPRC Fiscal Year / Fiscal Period Collector Table.
FIMSMGRFGROPTCThe Control Account Code Collector Table.
FIMSMGRFGRORHCORGN HIERARCHY Table    
FIMSMGRFGRPARCInput Parameter Collector Table
FIMSMGRFGRPGHCPROG HIERARCHY Table    
FIMSMGRFGRRCLELedger reclassification accounting entries table.
FIMSMGRFGRREBCREOB REPORT Table    
FIMSMGRFGRRECCREOC REPORT Table    
FIMSMGRFGRRLPCRule Code Processing Collector Table
FIMSMGRFGRSTSCControl Report Status Collector Table.
FIMSMGRFGRTOTSGeneral Ledger Report Totals Temp. Table
FIMSMGRFGRTRNCTransaction History Detail Table
FIMSMGRFGRTRNRBatch Transaction Error Report Table
FIMSMGRFGTARCCArchive/Purge Temporary Collector Table
FIMSMGRFGWREPTGASB reports data extract warehouse table.
FIMSMGRFHRINDRIndirect Cost Rate History Table.
FIMSMGRFIBBONDBOND BASE TABLE: It is created to maintain the specific data relative to bonds and participating funds.
FIMSMGRFIBCERDCERTIFICATE OF DEPOSIT BASE TABLE: It is created to maintain the specific data relative to certificate of deposit and participating funds.
FIMSMGRFIBCUSPCUSIP 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.
FIMSMGRFIBIDDTINTEREST DIVIDEND PROCESS TABLE : The table which holds the interest dividend date from last FIRINDV process run.
FIMSMGRFIBMMKTMONEY MARKET BASE TABLE: It is created to maintain the specific data relative to money market and participating funds.
FIMSMGRFIBPHISINVESTMENT POOL BASE TABLE: This table will store summarized information for the pool fund for pool purchases, additions and deductions.
FIMSMGRFIBPOOLPOOL COLLECTOR TABLE: This table will be a permanent temporary table used to initiate the revaluation of a pool(unitized method or average daily balance)
FIMSMGRFIBPRTYAPPRECIABLE PROPERTY BASE TABLE: It is created to maintain the specific data relative to the appreciable property and participating funds.
FIMSMGRFIBSTCKSTOCK BASE TABLE: It is created to maintain the specific data relative to stock instruments and participating funds.
FIMSMGRFIBSTOPSTOCK OPTION BASE TABLE: It is created to maintain the specific data relative to stock options and participating funds.
FIMSMGRFIRACCTMATCHING ACCOUNT COLLECTOR TABLE.  Used in matching fund report.
FIMSMGRFIRBDISBOND INTEREST SCHEDULE TABLE: It is created to maintain the specific data for the bond interest schedule.
FIMSMGRFIRBONCBOND COLLECTOR TABLE: It is created to maintain the specific data relative to bonds and participating funds.
FIMSMGRFIRBONDBOND DETAIL TABLE: It is the table related to the bond base table.
FIMSMGRFIRCADCCUSIP CALLABLE DATE COLLECTING TABLE: Contains information about the callable date which are to update CUSIPs bond callable date.
FIMSMGRFIRCADTCUSIP CALLABLE DATE REPEATING TABLE: Contains information about the callable date for CUSIPs.  It is applicable only to the investment category of bonds.
FIMSMGRFIRCERCCERTIFICATE OF DEPOSIT COLLECTOR TABLE: It is created to maintain the specific data relative to certificate of deposit and participating funds.
FIMSMGRFIRCERDCERTIFICATE OF DEPOSIT DETAIL TABLE: It is the table related to the certificate of deposit base table.
FIMSMGRFIRCUDCCUSIP DIVIDEND PAYABLE COLLECTING TABLE: Contains information about dividend amounts for CUSIPs with the Investment Type of stock which are to update the FIRCUDV
FIMSMGRFIRCUDVCUSIP DIVIDEND PAYABLE REPEATING TABLE: Contains information about dividend amounts for CUSIPs with the Investment Type of stock.
FIMSMGRFIRCUSCCUSIP COLLECT TABLE: Contain the stataus information which is to update the CUSIP.
FIMSMGRFIRCUUCCUSIP UNIT MARKET VALUATION COLLECTING TABLE: Contains the current market values which are to update the CUSIPs maintained on the base table.
FIMSMGRFIRCUUVCUSIP UNIT MARKET VALUATION REPEATING TABLE: Contains the current market values for the CUSIPs maintained on the base table.
FIMSMGRFIRDSDCDISTRIBUTION 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.
FIMSMGRFIRDSDTLAST DISTRIBUTION OF INCOME TABLE: It is used in running the report firdist.
FIMSMGRFIRISUMCUSIP SUMMARY TABLE:  Created to maintain a summary of investment information at the CUSIP and fund level.
FIMSMGRFIRMMKCMONEY MARKET COLLECTOR TABLE: It is created to maintain the specific data relative to money market and participating funds.
FIMSMGRFIRMMKTMONEY MARKET DETAIL TABLE: It is the table related to the money market base table.
FIMSMGRFIRPARMIncome Account Type and Gain/Loss Account Type Parameter Table
FIMSMGRFIRPFIFINVESTMENT POOL BASE TABLE: This table will store individual investment fund for pool purchases, additions and deductions.
FIMSMGRFIRPRTCAPPRECIABLE PROPERTY COLLECTOR TABLE: It is created to maintain the specific data relative to the appreciable property and participating funds.
FIMSMGRFIRPRTYAPPRECIABLE PROPERTY DETAIL TABLE: It is the table related to the appreciable property base table.
FIMSMGRFIRRIPCREVALUATION COLLECTOR TABLE: Table to hold pool investments for revaluation.
FIMSMGRFIRSPNDSPENDABLE AMOUNT MAINTENANCE TABLE: It is used to maintain the spendable amount values that are used in the distribution of income process.
FIMSMGRFIRSTCCSTOCK COLLECTOR TABLE: It is created to maintain the specific data relative to stock instruments and participating funds.
FIMSMGRFIRSTCKSTOCK DETAIL TABLE: It is the table related to the stock base table.
FIMSMGRFIRSTOCSTOCK OPTION COLLECTOR TABLE: It is created to maintain the specific data relative to stock options and participating funds.
FIMSMGRFIRSTOPSTOCK OPTION DETAIL TABLE: It is the table related to the stock base table.
FIMSMGRFIRTLTCMATCHING FUND COLLECTOR TABLE.  Used for totals in matching fund report.
FIMSMGRFIRTOTCTOTAL RETURN COLLECTOR TABLE: Table to hold investments for non pool funds.
FIMSMGRFNBDSTHDistribution Process History Table.
FIMSMGRFNBUNTDFNBUNTD - Endowment Unitization Collector Table.
FIMSMGRFNBUNTHEndowment Unitization History Table.
FIMSMGRFNREUSNEndowment Funds User Defined Fields Table.
FIMSMGRFNRSPND Spendable Income Rate Table.
FIMSMGRFNRUCTRUnitized Funds Market Value Table.
FIMSMGRFNRUNITEndowment Funds Units Table.
FIMSMGRFNTUNTZUnitization Temporary Table.
FIMSMGRFNVENDWEndowment Fund Table.
FIMSMGRFNVPOOLEndowed Pool Definition Table.
FIMSMGRFNVSDATEndowment User Defined Fields Validation Table.
FIMSMGRFOB10991099 Magnetic Tape Transmitter information
FIMSMGRFOBAINPApprovals in Process Table
FIMSMGRFOBAPPDApproved Document Table
FIMSMGRFOBAPPHApproval History Table
FIMSMGRFOBCLAUClause Validation Table
FIMSMGRFOBCOLRView for determining queue id-s for the Approval Process
FIMSMGRFOBDINPDocument in Progress Table  
FIMSMGRFOBENQEEnque control for processes which cannot run concurrently and locks do not provide sufficient control.
FIMSMGRFOBETXTEntity Text Table.
FIMSMGRFOBFSEQMaintains unique document code prefixes and maximum document sequence numbers for an (Upload Entity) System ID
FIMSMGRFOBPREFSite Preference Titles for Web
FIMSMGRFOBPREVPrevious values for user by process on web
FIMSMGRFOBPROCProcess Lock Table
FIMSMGRFOBPROFUser Profile Validation Table     
FIMSMGRFOBPRTOPrototypes (templates) for web processes
FIMSMGRFOBSEQNSequence Number Base Table
FIMSMGRFOBSYSCSystem Control Table
FIMSMGRFOBTEXTText Table
FIMSMGRFOBUAPPUnapproved Document Table
FIMSMGRFORAQRCUser to Fund/Fund Type Table
FIMSMGRFORAQUSApproval Queue Definition Table
FIMSMGRFORCLAUClause Text Table
FIMSMGRFORCOMPAdditional Computation Columns
FIMSMGRFORDCHCFOIDOCH FORM Collector Table
FIMSMGRFORDUMCDUMMY REPEATING COLLECTOR TABLE.
FIMSMGRFORPRGHProcess/Form to Rule Group History Table
FIMSMGRFORPRRGProcess/Form to Rule Group Table
FIMSMGRFORTCHGThis table is used to maintain changes to FOBTEXT for incremental refresh processing in the ODS.
FIMSMGRFORTEMPTemporary table for associated documents
FIMSMGRFORUFNHUser to Fund/Fund Type History Table
FIMSMGRFORUORHUser to Organization History Table
FIMSMGRFORURGHUser to Rule Group History Table 
FIMSMGRFORUSFNUser to Fund/Fund Type Table
FIMSMGRFORUSORUser to Organization Table
FIMSMGRFORUSRGUser to Rule Group Table
FIMSMGRFORVCHGThis table is used to maintain changes to tables associated with the AF_VENDOR composite view for incremental refresh processing in the ODS.
FIMSMGRFOTACCTWeb for Executives Operating Ledger Account Hierarchy Extract
FIMSMGRFOTAQRCCollector table to hold approval queue routing records during transaction approval processing.
FIMSMGRFOTFUNDWeb for Executives Operating Ledger Fund Hierarchy Extract
FIMSMGRFOTGACTWeb for Executives General Ledger Account Hierarchy Extract
FIMSMGRFOTGEXTWeb for Executives General Ledger Extract
FIMSMGRFOTGFNDWeb for Executives General Ledger Fund Hierarchy Extract
FIMSMGRFOTOEXT 
FIMSMGRFOTORGNWeb for Executives Operating Ledger Organization Hierarchy Extract
FIMSMGRFOTPROGWeb for Executives Operating Ledger Program Hierarchy Extract
FIMSMGRFOTRACTWeb for Executives Sponsored Research Account Hierarchy Extract
FIMSMGRFOTREXTWeb for Executives - Sponsored Research Extract
FIMSMGRFOTRFNDWeb for Executives Sponsored Research Fund Hierarchy Extract
FIMSMGRFOTRORGWeb for Executives Sponsored Research Organization Hierarchy Extract
FIMSMGRFOTRPRG 
FIMSMGRFOTTEXTCollector table to store Requisition AND Purchase
Order Document Text and Item text prior to the assigning of a Req or PO number.
This table is used to populate FOBTEXT. When a Req or PO sent to processing,
the FOTTEXT record is deleted.
FIMSMGRFPBAGRHAgreement Header Table
FIMSMGRFPBBIDHBid Header Information Table
FIMSMGRFPBBIDSBid Summary Table
FIMSMGRFPBEOCDEncumbrance Open Close Document Header Table.
FIMSMGRFPBEPRFTable Description: Third Party eProcurement system Interface preferences Table.
FIMSMGRFPBPOHDPurchase Order Header Table
FIMSMGRFPBRCDTPacking Slip Header Table
FIMSMGRFPBRCHD 
FIMSMGRFPBREQHRequest Header Table
FIMSMGRFPBRTRNReturns Table
FIMSMGRFPRACHGThis table is used to maintain changes to tables associated with the AF_PURCHASE_ORDER_ACCOUNTING composite view for incremental refresh processing in the ODS.
FIMSMGRFPRAGRDAgreement Detail Table
FIMSMGRFPRBIDDBid/Vendor Information Table
FIMSMGRFPRBIDVBID/VENDOR TELEPHONE INTERSECTION TABLE
FIMSMGRFPRBLAOBLANKET ORDER balance process table
FIMSMGRFPRDCHGThis table is used to maintain changes to tables associated with the AF_PURCHASE_ORDER composite view for incremental refresh processing in the ODS.
FIMSMGRFPRDELVPO/Request Delivered Detail Table
FIMSMGRFPRENCCPurchase Order Batch Close Process Collector Table
FIMSMGRFPREOCAEncumbrance Open Close Document Accounting Detail Table.
FIMSMGRFPREOCCEncumbrance Open Close Document Purchase Order/Req Item Table.
FIMSMGRFPREOCDEncumbrance Open Close Document Item Table.
FIMSMGRFPRICHGThis table is used to maintain changes to tables associated with the AF_PURCHASE_ORDER_ITEM composite view for incremental refresh processing in the ODS.
FIMSMGRFPRPODAPurchase Order Accounting Detail Table
FIMSMGRFPRPODTPurchase Order Detail GOODS Table
FIMSMGRFPRPOTXFPRPOTX Purchase Order Commodity Tax
FIMSMGRFPRRCDTReceiving Detail Table
FIMSMGRFPRRCHGThis table is used to maintain changes to tables associated with the AF_RECEIVED_ITEM composite view for incremental refresh processing in the ODS.
FIMSMGRFPRREQARequest Accounting Table
FIMSMGRFPRREQDRequest Detail Table
FIMSMGRFPRRQTXRequisition Commodity Tax.
FIMSMGRFPRRTRNReturns Item Table
FIMSMGRFPRTCHGThis table is used to maintain changes to tables associated with the AF_PURCHASE_ORDER_TAX_RATE composite view for incremental refresh processing in the ODS.
FIMSMGRFRBBASIBASE HEADER TABLE.
FIMSMGRFRBBUDGGrant Budget Header Table.
FIMSMGRFRBBUDPProposal Budget Header Table.
FIMSMGRFRBCSTACost Share Credit Account Header Table.
FIMSMGRFRBCSTD 
FIMSMGRFRBEVNGGrant Events Code Base Table.
FIMSMGRFRBEVNPProposal Events Code Base Table.
FIMSMGRFRBGBILResearch Accounting Grants Billing Table
FIMSMGRFRBGRNTGrant Header Table.
FIMSMGRFRBINDAIndirect Cost Charge Account code Header Table.
FIMSMGRFRBINDDIndirect Cost Distribution Code Header Table.
FIMSMGRFRBPROPProposal Header Table.
FIMSMGRFRCBFIXGrant Event Fixed Bill Collector Table.
FIMSMGRFRCBUDDGrant Budget Detail Collector Table.
FIMSMGRFRCBUDHGrant Budget Header Collector Table.
FIMSMGRFRCEVNGGrant Event Collector Table.
FIMSMGRFRCGLOCGrant Location Collector Table.
FIMSMGRFRCGRNTGrant Header Collector table.
FIMSMGRFRCGRPIGrant PI Collector table.
FIMSMGRFRCGUSNGrant User Defined Collector Table.
FIMSMGRFRCTRNRGrant Error Collector Table.
FIMSMGRFRR134BBilling Form 1304 Table
FIMSMGRFRR269R Form 269 Report Table 
FIMSMGRFRR270BBilling Form 270 Table
FIMSMGRFRR272BBilling Form 272 Table
FIMSMGRFRR272RBilling Form 272 Table for Reporting Purpose
FIMSMGRFRRAGPTFinance Pass-through Agency Table.
FIMSMGRFRRAGYHRetrieves Agency Hierarchy Information.
FIMSMGRFRRBASIBase Repeating Table.
FIMSMGRFRRBCHGThis table is used to maintain changes to tables associated with the AF_GRANT_BILLING_DETAIL composite view for incremental refresh processing in the ODS.
FIMSMGRFRRBDETResearch Accounting Transaction Detail Table
FIMSMGRFRRBDGPGrant Budget Proposal Lines Detail Table.
FIMSMGRFRRBDTHResearch Accounting Transaction Detail History Table
FIMSMGRFRRBECLBilling Exclusion Repeating Table.
FIMSMGRFRRBEXCResearch Accounting Exception Report Table
FIMSMGRFRRBFIXSponsored Research Grant Events Fixed Schedule Data Repeating Table.
FIMSMGRFRRBFRABilling Format Accounts and ATyp matching Repeating Table.
FIMSMGRFRRBFRMBilling Format Group  Repeating Table.
FIMSMGRFRRBFRSBilling Format Subtotal Repeating Table.
FIMSMGRFRRBUDCProposal Budget Collector Table usage with FRIBUDT.
FIMSMGRFRRBUDGGrant Budget Lines Detail Table.
FIMSMGRFRRBUDPProposal Budget Account Line Items Table.
FIMSMGRFRRCSTACost Share Credit Account code Repeating Table.
FIMSMGRFRRCSTDCost Share Distribution code Repeating Table.
FIMSMGRFRRCSTRCost Share Rate Repeating Table.
FIMSMGRFRRDCHGThis table is used to maintain changes to tables associated with the AF_ENDOWMENT_DIST_PROFILE composite view for incremental refresh processing in the ODS.
FIMSMGRFRRECHGThis table is used to maintain changes to tables associated with the AF_ENDOWMENT_FUND_PROFILE composite view for incremental refresh processing in the ODS.
FIMSMGRFRREGRPEvents Group Repeating Table.
FIMSMGRFRREVGGGrant Grouped Events Table. This table stores groups of events linked to
the grant codes.
FIMSMGRFRREVGPProposal Grouped Events Table. This table stores groups of events linked to
the proposal codes.
FIMSMGRFRREVNGSponsored Research Grant Events Status Repeating Table
FIMSMGRFRREVNPSponsored Research Proposal Events Status Repeating Table
FIMSMGRFRRFCHGThis table is used to maintain changes to tables associated with the AF_GRANT_FUND composite view for incremental refresh processing in the ODS.
FIMSMGRFRRFFRRFederal Financial Report Table
FIMSMGRFRRGAMTGrant Amounts Table.
FIMSMGRFRRGCHGThis table is used to maintain changes to tables associated with the AF_GRANT composite view for incremental refresh processing in the ODS.
FIMSMGRFRRGCSAExpenses Towards Cost Share by Grant and Account Table
FIMSMGRFRRGCSTCost Share Total Amount Per Grant Table
FIMSMGRFRRGENBGeneric Bill Table
FIMSMGRFRRGENRGeneric Report Table
FIMSMGRFRRGICAGrant Expenses Towards Indirect Cost Table
FIMSMGRFRRGICTGrant Indirect Cost Total Amount Table
FIMSMGRFRRGLOCGrant Location Repeating Table.
FIMSMGRFRRGNBCResearch Accounting Billing Report Collector Table
FIMSMGRFRRGRNCDEFER GRANT COLLECTOR TABLE
FIMSMGRFRRGRNLGrant Ledger Table.
FIMSMGRFRRGRPIGrant Personnel Repeating Table.
FIMSMGRFRRGRTCGrant Rebuild Edit Collector Table
FIMSMGRFRRGUSNGrant User Defined Codes Repeating Table.
FIMSMGRFRRINDAIndirect Cost Charge Account code Repeating Table.
FIMSMGRFRRINDDIndirect Cost Distribution code Repeating Table.
FIMSMGRFRRINDRIndirect Cost Rate Reeating Table.
FIMSMGRFRRLCHGThis table is used to maintain changes to tables associated with the AF_GRANT_LEDGER composite view for incremental refresh processing in the ODS.
FIMSMGRFRRMEMLGRANT MEMO LEDGER  TABLE
FIMSMGRFRRPCHGThis table is used to maintain changes to tables associated with the AF_PROPOSAL composite view for incremental refresh processing in the ODS.
FIMSMGRFRRPLOCProposal Location Repeating Table.
FIMSMGRFRRPRPIProposal Personnel Repeating Table.
FIMSMGRFRRPRPTFinance Pass-through Proposal Table.
FIMSMGRFRRPRXGSponsored Research Grant Events Proxy User ID Repeating Table.
FIMSMGRFRRPRXPSponsored Research Proposal Events Proxy User ID Repeating Table.
FIMSMGRFRRPUSN 
FIMSMGRFRRSYSCResearch Accounting System Control Table
FIMSMGRFRRTMPC 
FIMSMGRFRRTRNCGrant Rebuild Transaction History Collector Table
FIMSMGRFRVBASIBase Validation Table.
FIMSMGRFRVBECLBilling Exclusion Code Validation Table.
FIMSMGRFRVBFRMBilling Format Code Validation Table.
FIMSMGRFRVCFDACatalog of Federal Domestic Assistance Codes Table.
FIMSMGRFRVCSTACost Share Credit Account code Validation Table.
FIMSMGRFRVCSTDCost Share Distribution code Validation Table.
FIMSMGRFRVCSTRCost Share Rate code Validation Table.
FIMSMGRFRVEGRPEvents Group Code Validation Table.
FIMSMGRFRVEVNTProposal Events Code Validation Repeating Table.
FIMSMGRFRVFUNDResearch Accounting Fund Repeating Table.
FIMSMGRFRVGRSTGrant Status History Table.
FIMSMGRFRVINDAIndirect Cost Charge Account code Validation Table.
FIMSMGRFRVINDDIndirect Cost Distribution code Table.
FIMSMGRFRVINDRIndirect Cost Rate code Validation Table.
FIMSMGRFRVISACAgency Sponsor Account Table.
FIMSMGRFRVISATAgency Sponsor Account Type Table.
FIMSMGRFRVLCACGrants Labor Clearing Account Cross Reference Account Table.
FIMSMGRFRVLCATGrant Labor Clearing Account Type Cross Reference  Table.
FIMSMGRFRVPMSCGrant Billing Payment Management System Code Validation Table
FIMSMGRFRVPRSTProposal Header Table.
FIMSMGRFRVSACTAgency Sponsor Account Table.
FIMSMGRFRVSDATGrant User Defined System Codes Validation Table.
FIMSMGRFSBADJHSTORES INVENTORY ADJUSTMENT TABLE: The table which holds Inventory Cost and Quantity Adjustment Documents for Stores Inventory.
FIMSMGRFSBISSHISSUES HEADER TABLE: The table which holds store issue document header information.
FIMSMGRFSBSYSCSTORES INVENTORY SYSTEM CONTROL TABLE:  The table which contains system control information for the Stores Inventory Module only.
FIMSMGRFSBTRAHSTORES TRANSFER HEADER: Header data for stores transfers
FIMSMGRFSRADJDSTORES INVENTORY ADJUSTMENT DETAIL TABLE: The table which holds Inventory Cost and Quantity Adjustment detail information for Stores Inventory.
FIMSMGRFSRDTLCSTORES INVENTORY RECEIVING/ISSUES COLLECTOR TABLE: Table used to merge both receiving and issues data to be reported on a single report.
FIMSMGRFSRISSAISSUES ACCOUNTING TABLE: The table which holds stores issue document accounting information.
FIMSMGRFSRISSCISSUES COLLECTOR TABLE: Collector table which triggers the initial print of Issue tickets when an Issue document is completed.
FIMSMGRFSRISSDISSUES COMMODITY DETAIL TABLE: The table which holds stores issue document commodity detail information.
FIMSMGRFSRISSLISSUES COMMODITY LOCATION TABLE: The table which holds stores issue document commodity location information.
FIMSMGRFSRPREQSTORES PRELIMINARY REQUISITION TABLE: Stores Inventory table used to store those commodity codes which need to be re-ordered.
FIMSMGRFSRSYSASTORES 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.
FIMSMGRFSRTRADSTORES TRANSFER DETAIL: Detail (commodity) data for stores transfers
FIMSMGRFSRTRALSTORES TRANSFER DETAIL LOCATIONS: Location detail data for stores transfers
FIMSMGRFSRVALDSTORES VALUATION DETAIL: Detail history data for stores valuation process
FIMSMGRFTRACTAAccount code and Attributes association table
FIMSMGRFTRACTSAccount code and set code association table
FIMSMGRFTRACVAActivity code and Attributes association table
FIMSMGRFTRACVSActivity code and set code association table
FIMSMGRFTRATTSSet and Attribute type association table
FIMSMGRFTRATTVChart of Accounts attributes value validation table.
FIMSMGRFTRATYAAccount Type code and Attributes association table
FIMSMGRFTRATYSAccount Type and set code association table
FIMSMGRFTRCOMMCommodity Repeating Table
FIMSMGRFTRFNDAFund code and Attributes association table
FIMSMGRFTRFNDSFund code and set code association table
FIMSMGRFTRFTYAFund Type code and Attributes association table
FIMSMGRFTRFTYSFund Type and set code association table
FIMSMGRFTRLCNALocation code and Attributes association table
FIMSMGRFTRLCNSLocation code and set code association table
FIMSMGRFTRORGAOrganization code and Attributes association table
FIMSMGRFTRORGSOrganization code and set code association table
FIMSMGRFTRPRGAProgram code and Attributes association table
FIMSMGRFTRPRGSProgram code and set code association table
FIMSMGRFTRTGTRTax group/Tax Rate repeating table
FIMSMGRFTRVTCLVendor tax collector repeating validation table
FIMSMGRFTVACCIAccount Index Validation Table
FIMSMGRFTVACCTAccount Validation Table     
FIMSMGRFTVACIVACCOUNT 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.
FIMSMGRFTVACTLControl Account Validation Table
FIMSMGRFTVACTVActivity Validation Table    
FIMSMGRFTVADJTAdjustment Code Table
FIMSMGRFTVAGCYAgency Validation Table    
FIMSMGRFTVALCHPro Rata Allocation Charge Control Table.
FIMSMGRFTVALRGPro Rata Allocation Rule Group Control Table.
FIMSMGRFTVAPPQApproval Queue Definition Table
FIMSMGRFTVARATOrg/Account/Rate Validation Table
FIMSMGRFTVASTYAsset Type Table
FIMSMGRFTVATTSChart of Accounts attributes Set validation table
FIMSMGRFTVATTTChart of Accounts attributes Type validation table
FIMSMGRFTVATYPAccount Type Validation Table
FIMSMGRFTVAUSEAsset Use Table
FIMSMGRFTVBCLSBID CLASS CODE VALIDATION TABLE
FIMSMGRFTVBDPOBid/PO Verification Table
FIMSMGRFTVBUYCBuyer/Commodity Table
FIMSMGRFTVBUYOBuyer/Organization Table
FIMSMGRFTVBUYRBuyer Verification Table
FIMSMGRFTVCARDPurchase Credit Card Table.
FIMSMGRFTVCHRGProject/Customer Charges Validation Table
FIMSMGRFTVCLASClassification Code Validation Table
FIMSMGRFTVCOASCHART of ACCOUNTS VALIDATION TABLE
FIMSMGRFTVCOMMCommodity Verification Table
FIMSMGRFTVCRATProject/Customer Rates Validation Table
FIMSMGRFTVCRPAClosed Request/PO Audit Trail Table.
FIMSMGRFTVCRSNClosed Document Reason Code Table.
FIMSMGRFTVCSTOCost Type/Organization Validation Table
FIMSMGRFTVCTYPCost Type Validation Table
FIMSMGRFTVCUSTCustomer Table
FIMSMGRFTVDEPRDepreciation Table
FIMSMGRFTVDISCDiscount Terms Table
FIMSMGRFTVDTYPDocument Type Verification Table
FIMSMGRFTVECLSEmployee Class Rule Table
FIMSMGRFTVEDITRule Class Edit Table
FIMSMGRFTVEELCElement Identification Validation Table
FIMSMGRFTVEELIExternal Element ID Validation Table
FIMSMGRFTVEELTExternal Translation Validation Table
FIMSMGRFTVEENTExternal Entity ID Validation Table
FIMSMGRFTVEQPTEquipment Validation Table
FIMSMGRFTVEQULEquivalency Table
FIMSMGRFTVEXRTExternal Rate Code Validation Table
FIMSMGRFTVFBALFUND BALANCE ACCOUNT TABLE: Identifies multiple fund balance accounts.
FIMSMGRFTVFMGRFinancial Manager Validation Table
FIMSMGRFTVFOBSFOB Code Table
FIMSMGRFTVFSPDFiscal Period Validation Table 
FIMSMGRFTVFSYRFiscal Year Validation Table 
FIMSMGRFTVFTRMFreight Terms :  This table contains Freight Terms Codes indicating who is responsible for paying Freight charges.
FIMSMGRFTVFTYPFUND TYPE VALIDATION TABLE
FIMSMGRFTVFUNDFUND VALIDATION TABLE
FIMSMGRFTVHBUDHierarchical Budget Control Table
FIMSMGRFTVIMGRINVESTMENT MANAGER TABLE: Identifies investment managers in the system.
FIMSMGRFTVINCL 
FIMSMGRFTVINJV 
FIMSMGRFTVINRTInternal Rate Code Validation Table
FIMSMGRFTVINTSINTEREST 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.
FIMSMGRFTVINVMSTORES COMMODITY MASTER: Defines inventory parameters for stores commodities
FIMSMGRFTVINVTInventory Validation Table
FIMSMGRFTVIRTOInternal Rate/Organization Validation Table
FIMSMGRFTVITYPIncome Type Table
FIMSMGRFTVIVTPINVESTMENT CATEGORY VALIDATION TABLE: Links the investment types of the user to an investment category that is hard coded data in the system.
FIMSMGRFTVLOCNLocation Validation Table 
FIMSMGRFTVMCATMerchant Category Code Validation Table.
FIMSMGRFTVOBPHOperating Budget Phase Table
FIMSMGRFTVOBUDOperating Budget Table
FIMSMGRFTVORGNOrganization Validation Table
FIMSMGRFTVPAYMPay Method Validation Table
FIMSMGRFTVPCLSPURCHASE ORDER CLASSIFICATION   
FIMSMGRFTVPCSHPurchase Card Payment Cutoff Schedule Table.
FIMSMGRFTVPOOLDescription of table here    
FIMSMGRFTVPRCEVendor Products Verification Table
FIMSMGRFTVPROGProgram Validation Table    
FIMSMGRFTVPROJProject Validation Table
FIMSMGRFTVPRSTPROPOSAL STATUS TABLE 
FIMSMGRFTVRCMTReceiving Method Verification Table
FIMSMGRFTVRECPReport Recipient Validation Table
FIMSMGRFTVRGRCRule Class to Rule Group Table 
FIMSMGRFTVRGUSUser Id/Rule Group Cross-reference
FIMSMGRFTVRQBDReq Bid Intersection Table
FIMSMGRFTVRQPORequest/PO Verification Table
FIMSMGRFTVRRGHRule Class to Rule Group History Table 
FIMSMGRFTVRRSNRETURN REASON TABLE 
FIMSMGRFTVRSNC 
FIMSMGRFTVRTCLRate/Classification Validation Table
FIMSMGRFTVRTCTRate Code/Cost Type Validation Table
FIMSMGRFTVRTYPRate Type Validation Table
FIMSMGRFTVRUCLRule Class Validation Table     
FIMSMGRFTVRUGRUser to Rule Group 
FIMSMGRFTVRULPRule Class Validation Table     
FIMSMGRFTVSDATSystem Data Validation Table
FIMSMGRFTVSHIPShip To Verification Table
FIMSMGRFTVSTKLSTOCK LOCATION TABLE: Table will hold Stores Inventory commodity locations.
FIMSMGRFTVTGRPTax group validation table
FIMSMGRFTVTRATTax Rate Table
FIMSMGRFTVTRSKTransit Risk Table
FIMSMGRFTVUOMSUNIT OF MEASURE TABLE 
FIMSMGRFTVUVMSUNIT VALUE MEASUREMENT VALIDATION TABLE: Maintains the unit value measurements that apply to the units for an investment type and CUSIP.
FIMSMGRFTVVENDVendor Validation Table
FIMSMGRFTVVENTVendor/Vendor Type Table
FIMSMGRFTVVTYPVendor Type Table
FIMSMGRFUBFEDCSweep Collector Table
FIMSMGRFURVERSFinance Version Tracking Table.
FIMSMGRFYRACCX 
APLOCALFYRBFFD 
FIMSMGRFYRXWLK 
APLOCALFYTBKTP 
FIMSMGRFZREDITThis table stores the data from each report that is to be used for the FZREDIT report
FIMSMGRFZRTBRBThis table defines budget information to be use for Tennessee Board of Regents Budget reports for forms I, II and VIII.  This is for processes FZROF01, FZRJF01, FZROF02, FZRJF02, FZROF08 and FZRJF08
FIMSMGRFZVALLCAllocation codes for budgets used in FZRTBRB
GENERALGEBFUNCFunction Header Table
GENERALGERATTDInvitee Table
GENERALGERECHGThis table is used to maintain changes to tables associated with the AG_EVENT composite view for incremental refresh processing in the ODS.
GENERALGERFCOMFunction Comments Table
GENERALGERFCONFunction Constituency Table
GENERALGERFCORFunction Correspondence Table
GENERALGERFEXPFunction Expense Table
GENERALGERFFEEFunction Fee Table
GENERALGERFGSTEvent Function Guest Table
GENERALGERFREVFunction Revenue Table
GENERALGERMENUFunction Menu Table
GENERALGERPARTFunction Participant Table
GENERALGERSUBJFunction Subject Comment Table
GENERALGERTASKFunction Task Table
GENERALGERTKIDFunction Task Associated ID Table
MODSMGRGGRTTMP_WORK 
GENERALGJBCOLRJobs Parameter Collector Table
GENERALGJBJOBSReport/Process Definition Table
GENERALGJBPDEFJobs Parameter Definition Table
GENERALGJBPDFTDefault Parameter Table
GENERALGJBPRUNProcess Run Parameter Table
GENERALGJBPVALGeneral Jobs Parameter Value Table
GENERALGJBRSLTExternal Process Results Table
MODSMGRGJBRSLTExternal Process Results Table
GENERALGJBVPDIVPDI Support Table to store Job Seq Number with related MIF code submitted
BANSECRGJRINVCJob Submission Character Validation Table contains rows of characters which are either allowed or prohibited for use in various Job Submission parameters based on Type column.
GENERALGJRJPRMJob Parameter Set Rule Table
GENERALGJRSWPTGJRSWPT: This table contains information about jobs running in sleep/wake mode.
GENERALGLBAPPLLetter Generation Application Table
GENERALGLBEXTRPopulation Selection Extract Base Table
GENERALGLBOBJTLetter Generation Object Base Table
GENERALGLBSLCTPopulation Selection Base Table
GENERALGLBVRBLLetter Generation Variable Base Table
GENERALGLRAPPLLetter Generation Application Rules Table
GENERALGLRCALCLetter Generation Calculation Collector Table
GENERALGLRCMPLSelection Identifier Compiled Statements
GENERALGLRCOLRLetter Generation Collector Table
GENERALGLROBJTLetter Generation Object Rules Table
GENERALGLRORDRLetter Generation Order Table
GENERALGLRSFRMPopulation Selection Select Table
GENERALGLRSLCTPopulation Selection Rules Table
GENERALGLRVFRMLetter Generation Variable Select Table
GENERALGLRVRBLLetter Generation Variable Rules Table
APLOCALGOARMYED_GRADES 
APLOCALGOARMYED_GRADES_CUMM 
APLOCALGOARMYED_GRADES_TEMP 
GENERALGOBBACRAccess Rule Base
GENERALGOBCMUSCommon Matching User Setup Table 
GENERALGOBDIRODirectory Options Rule Table
GENERALGOBEACCEnterprise Oracle Access Table
GENERALGOBEQRCEvent Queue Record Maintenance Table.
GENERALGOBFDMNFGAC Domain Driver Table Table
GENERALGOBFDTPFGAC Domain Type Rule Table
GENERALGOBFEOBFGAC objects excluded from FGAC processing rules table.
GENERALGOBFGACFGAC Group Access Rules Table
GENERALGOBFNXRThird-Party Function Calls Table.
GENERALGOBFPUDFGAC Personal User Defaults.
GENERALGOBICPSGOBICPS: Integration Configuration Process/Setting Name Table.
GENERALGOBINTLVisa International Information Table
GENERALGOBPCRLVBS Secured Item Pattern Control
GENERALGOBSEGCAccess Group Base
GENERALGOBSEVSSEVIS Reporting base table
GENERALGOBSRIDIMS Sourced ID Base Table.
GENERALGOBSRVRSurvey Response Header Table. This table contains one row for each person who responds to the survey.
GENERALGOBTPACThird Party Access Table
GENERALGOBVBSCVBS Application Control
GENERALGOBVBSTVBS 
GENERALGOBVCRLVBS Access Rule Control
GENERALGOBVPDIVPDI Support Table to store VPDI enabled forms
GENERALGOBVUSRVBS User Profile Base
GENERALGOBWFDDWorkflow Electronic Documents Dictionary Base table
GENERALGOBWFEDWorkflow Electronic Documents Base Table
GENERALGORADRLAddress/User Roles Rules Table
GENERALGORBLOBCentralized storage for Binary Large Objects.
GENERALGORCCAUSCT Banner Credit Card Audit Table
GENERALGORCCRDCREDIT CARD RULES Table
GENERALGORCGEOCollector table of persons address for the Geographic Regions/Division
process.
GENERALGORCMDDCommon Matching Data Dictionary Table 
GENERALGORCMDHCommon Matching Display Hierarchy Table 
GENERALGORCMDOCommon Matching Display Options Table 
GENERALGORCMSCCommon Matching Source Code Rules Table 
GENERALGORCMSPCommon Matching Source Priority Table.
GENERALGORCMSRCommon Matching Rules Table 
GENERALGORCMUPCommon Matching User Procedure Table.
GENERALGORDADDDirectory Address Table
GENERALGORDLUP Add-In Data Lookup Repeating table 
GENERALGORDMCLDisplay Mask Column Rules Table
GENERALGORDMSKDisplay Mask Column Rules Table
GENERALGORDOCMDocument Information Table
GENERALGORDPRFDirectory Profile Table
GENERALGORDPRP Step Property Repeating Table 
GENERALGORDSECUser Security Repeating table.
GENERALGORDSPRWizard Step Properties Repeating table 
GENERALGORDSTEWizard Step Repeating table 
GENERALGORDSTPStep Type Property Repeating Table 
GENERALGORDWIZAdd-In Wizard Association table 
GENERALGOREMALPerson E-mail repeating table.
APLOCALGOREMAL_04162008 
GENERALGOREQERError Log Event Queue Table.
GENERALGOREQNMEvent Queue Name Definition Table
GENERALGOREQPGParameter Group Code Rule Table
GENERALGOREQRCEvent Queue Record Maintenance Detail Table.
GENERALGORFBPIFGAC PII domain business profile assignments.
GENERALGORFBPRFGAC business profile assignments.
GENERALGORFDPIFGAC PII Policy Table
GENERALGORFDPLFGAC Domain Policy Table
GENERALGORFGBPFGAC Profiles per Predicate and Domain Table
GENERALGORFGUSFGAC Users defined for predicate and domain.
GENERALGORFILXFile System File Index Pointer Table
GENERALGORFPIIFGAC PII Domains per person.
GENERALGORFPRDFGAC Predicate per Domain Table
GENERALGORGMGRAccess Group Management Control
GENERALGORGMSKAccess Group Rule Assignment Mask
GENERALGORGRULAccess Group Rule Association
GENERALGORGUSRAccess Group User Association
GENERALGORICCRGORICCR: Integration Configuration Rules Table.
GENERALGORIMMUImmunization Code Repeating Table
GENERALGORINTGIntegration Partner System Rule Table.
GENERALGORIROLGORIROL: Institution Role Table.
GENERALGORMEDRMedical Disability Rule Table 
GENERALGORMERCCREDIT CARD TYPE BY MERCHANT ID Table
GENERALGORNAMECommon Matching Person Name Translation Table.
GENERALGORNPNMCommon Matching Non-Person Name Translation Table.
GENERALGORPAUDThird Party Access Audit Table
GENERALGORPGEOGeographic Regions/Divisions for persons address.
GENERALGORPPRMThird-Party Function Parameters Table.
GENERALGORPRACPerson Race Table.
GENERALGORRACERace Rules Table.
GENERALGORRAVLVBS Access Rule Secured Values
GENERALGORRSQLSQL Process Rules Table
GENERALGORSEVDSEVIS Reporting Dependent Table
GENERALGORSEVH 
GENERALGORSEVSSEVIS Reporting repeating history table
GENERALGORSGEOGeographic Regions/Divisions for SBGI.
GENERALGORSQPASQL Process Parameter Table
GENERALGORSRVRSurvey Repsonses Repeating Table. This tables store the individual responses.
GENERALGORSVAHSEVIS Reporting Activity Site History Table
GENERALGORSVASSEVIS Reporting Activity Site Table
GENERALGORSVBHBatch header table for transactions to be sent to SEVIS.
GENERALGORSVEHSEVIS Reporting Employment History Table
GENERALGORSVEISEVIS Reporting Employment Information Table
GENERALGORSVSQSEVIS SQL Rules Table
GENERALGORTCRLUser ID table
GENERALGORTCTLThird-Party Electronic Controls Table.
GENERALGORVCTLVoice Response Controls Table.
GENERALGORVGACAccess Group Rule Control
GENERALGORVISAVisa Information Table
GENERALGORVMACVBS User Module Access Control
GENERALGORVMGAVBS Person Secured Items
GENERALGORVRACVBS User Access Rule Control
GENERALGORVSVRValidation Table VBS Control
GENERALGORVTBLSecured Validation Table Codes
GENERALGORWFAPElectronic Documents Application Table
GENERALGORWFDBWorkflow Electronic Docuents Builder Table
GENERALGORWFDDWorkflow Electronic Documents Dictionary Repeating Table
GENERALGORWFDHWorkflow Electronic Documents History Table
GENERALGORWFDSThis table defines the userid access for Workflow electronic documents.
GENERALGORWFEDWorkflow Electronic Documents Repeating Table
GENERALGORWFMPElectronic Documents Mapping Table
GENERALGORWFPMParameters Table
GENERALGORWFSQDocuments Sequence Table
GENERALGOTCMMECommon Matching Match Entry Global Temporary Table 
GENERALGOTCMRTCommon Matching Results Global Temporary Table 
GENERALGOTDMSGSPREADSHEET MESSAGE TABLE
GENERALGOTDPARSPREADSHEET USER INPUT TABLE
GENERALGOTDWKSWorksheet Temporary Table
GENERALGOTISQLTable created to temporarily store information related to Institutional rule processing.
GENERALGOTSVBTCollector table for batch transactions to be sent to SEVIS.
GENERALGOTWFEDWorkflow Electronic Documents Temporary Table
GENERALGOTXMLDTemporary table to store XML files as CLOB data type for processing.
GENERALGTRMAPSGIS Mapping Description Rule Table.
GENERALGTVBLOTFile Types stored as Binary Large Objects.
GENERALGTVCALLQuickFlow Validation Table
GENERALGTVCCRDCREDIT CARD TYPE Validation Table
GENERALGTVCELGCertification of Eligibility Table
BANSECRGTVCLASValidation table of user classes defined to the BANNER security system.
GENERALGTVCMSCCommon Matching Source Code Table 
GENERALGTVCURRCurrency conversion validation table.
GENERALGTVDADDAdd-In code Validation Table 
GENERALGTVDICDThis table is used to subdivide geographic regions to capture cost center information by disctirct or division.
GENERALGTVDIRODirectory Options Validation Table
GENERALGTVDOCMDocument Code Validation Table
GENERALGTVDPRPStep Property Validation Table 
GENERALGTVDSTPStep Type code Validation Table 
GENERALGTVDUNTDuration Unit Code Validation Table
GENERALGTVEMALThe GTVEMAL table contains the valid e-mail type codes.
GENERALGTVEMPHFunction Emphasis Validation Table
GENERALGTVEQNMEvent Code Validation Table
GENERALGTVEQPGGROUP CODE Validation Table
GENERALGTVEQPMParameter Code Validation Table.
GENERALGTVEQTSTarget System Code Validation Table
GENERALGTVEXPNExpense Code Validation Table
GENERALGTVFBPRFGAC Business Profile Code Validation Table
GENERALGTVFDMNFGAC Domain Code Validation Table
GENERALGTVFDTPFGAC Domain Type Code Validation Table
GENERALGTVFEESFee Status Code Table
GENERALGTVFGACFGAC Group Access Code Validation Table
GENERALGTVFSTAFunction Status Validation Table
GENERALGTVFTYPFunction Type Code Validation Table
GENERALGTVFUNCFunction Code Validation Table
GENERALGTVICSNGTVICSN: Integration Configuration Setting Name Code Validation Table.
GENERALGTVIMMUImmunization Code Validation Table
GENERALGTVIMSTImmunization Status Code Validation Table
GENERALGTVINSMInstructional Method Code  Validation Table
GENERALGTVINTPIntegration Partner System Code Validation Table.
GENERALGTVLETRLetter Process Letter Validation Table
GENERALGTVLFSTLearner Field of Study Type Validation Table
GENERALGTVMAILMail Code Validation Table
GENERALGTVMENUMenu Code Table
GENERALGTVMTYPMeeting Type Code validation table
GENERALGTVNTYPThis table defines the Banner name type codes.
GENERALGTVOBJTVBS Object Code Validation
GENERALGTVPARALetter Process Paragraph Validation Table
GENERALGTVPARSValidation entries for Partition codes.  Partition Codes define campus zones, which are catagories or groupings of rooms.
GENERALGTVPDIRPre/Post direction table
GENERALGTVPRNTPrinter Validation Table
GENERALGTVPROCPROCESS NAME Validation Table
GENERALGTVPTYPParticipant Type Code Validation Table
GENERALGTVPURPFunction Purpose Validation Table
GENERALGTVRATERate Code Validation Table
GENERALGTVREVNFunction Revenue Validation Table
GENERALGTVRRACRegulatory Race Validation Table.
GENERALGTVRSVPRSVP Code Table
GENERALGTVRTNGRating Code Validation Table.
GENERALGTVSCHSValidation entries for Schedule Status Codes.
GENERALGTVSCODEDI STANDARD CODE VALIDATION TABLE: This table contains standard EDI codes based on element id and standards organization.  This data is used to create cross references to various user defined codes that need to be sent in EDI transactions/messages.
GENERALGTVSDAXSDA crosswalk/conversion table
GENERALGTVSDIVSubdivision table
GENERALGTVSEGCAccess Group Validation
GENERALGTVSQPASQL Process Parameter Validation Table
GENERALGTVSQPRValidation entries for SQL Process Codes.
GENERALGTVSQRUValidation entries for SQL Rule Codes.
GENERALGTVSRCEVisa Source Code Validation Table
GENERALGTVSSFXSuffix table
GENERALGTVSUBJSubject Index Validation Table
GENERALGTVSVAPValidation entries for SEVIS Auto-populate codes.
GENERALGTVSVBAValidation entries for SEVIS Business Action Codes.
GENERALGTVSVCAValidation entries for SEVIS Student Cancellation Reason codes.
GENERALGTVSVCCValidation entries for SEVIS Category Codes for Exchange Visitor program.
GENERALGTVSVCPValidation entries for SEVIS Consular Post Codes.
GENERALGTVSVCRValidation entries for SEVIS Creation Reason codes.
GENERALGTVSVCTGTVSVCT: Validation entries for SEVIS Occupation Category Type Codes for Exchange Visitor program.
GENERALGTVSVDTValidation entries for SEVIS Dependent Termination codes.
GENERALGTVSVELValidation entries for SEVIS Educational Level codes.
GENERALGTVSVEPValidation entries for SEVIS End EV Program Reason codes.
GENERALGTVSVFTValidation entries for SEVIS Drop Below Full Time Reason codes.
GENERALGTVSVGOValidation entries for SEVIS Governmental Organization Codes.
GENERALGTVSVIOValidation entries for SEVIS International Organization Codes.
GENERALGTVSVITValidation entries for SEVIS Infraction Type Codes.
GENERALGTVSVPCValidation entries for SEVIS Position Codes.
GENERALGTVSVRPValidation entries for SEVIS Request for Form Reprint codes.
GENERALGTVSVTRValidation entries for SEVIS Termination Reason codes.
GENERALGTVSVTSValidation entries for SEVIS Transmittal Status Codes.
GENERALGTVSYSISystem Indicator Validation Table
GENERALGTVTARGTarget Audience Validation Table
GENERALGTVTASKFunction Task Code Table
GENERALGTVTRTPEDI Transaction Type Code Table.
GENERALGTVTSTATask Status Type Code Table
GENERALGTVTTYPTask Type Code Table
GENERALGTVUOMSUnit of Measure Validation Table
GENERALGTVUTYPUnit type table
GENERALGTVVAPPVBS Application Code Values
GENERALGTVVBTYVBS Application Type Code
GENERALGTVVISSVisa Issuing Authority Validation Table
GENERALGTVVOBJThis table defines Value-Based Security (VBS) objects.
BANSECRGTVVPDIVPD Institution Code Validation Table
GENERALGTVWFEDWorkflow Electronic Documents Validation Table
GENERALGTVZIPCZip Code Validation Table
GENERALGUBBHLPBanner Dynamic help table
GENERALGUBGISLGeographic information system location address table.
MODSMGRGUBGRNTGUBGRNT: This table is used during upgrades to store the owner and table or view name of objects to be dropped and recreated during a BANNER upgrade.
GENERALGUBINSTInstitutional Description Table
BANSECRGUBIPRFSite profile record. This table contains only one record. It defines what level of security is being used, seed numbers and if version number checking is active.
GENERALGUBLAPILocal API User Exit Mapping Table
GENERALGUBLETRGUBLETR: Contains information about paragraphs within a letter.
GENERALGUBLHLPLocal help table
GENERALGUBOBJSGeneral Object Base Table
GENERALGUBOUTDThe Data Extract table used to store header information for Data Extracts being performed.
GENERALGUBOUTPThe job submission base output table used to store header information from batch jobs executed in a client server environment.
GENERALGUBPARALetter Paragraph Table
GENERALGUBPPRFEnterprise Pin Preference table.
BANSECRGUBROLEThis table stores the encrypted passwords for the Banner roles. This table is automatically maintained when passwords are generated or regenerated for the Banner roles.
GENERALGUBRSLTExternal Process Results Table
GENERALGUBSRVYSurvey Header Table. This tables defines the header information for surveys.
GENERALGURADDLGurrddl process DDL Collector Table.
GENERALGURALMPPledge Payment to Advancement Table
BANSECRGURALOGBanner Security Violation Log. This table contains a record of several types of Banner Security violations that have occurred.
MODSMGRGURAMODTable used during the creation of the modification scripts
BANSECRGURAOBJThis table defines all valid Banner objects and what the current version number is. This table also defines the default role to be used when the object is first granted to the user or a class.
GENERALGURAPAYAccounting Feed Accounts Payable Table
FIMSMGRGURAPAY_PIDMSREFUND CUSTOM TABLE: CROSSWALK TABLE OF SIS IDS AND BANNER PIDMS
TAISMGRGURAPAY_PIDMSREFUND CUSTOM TABLE: CROSSWALK TABLE OF SIS IDS AND BANNER PIDMS
FIMSMGRGURAPAY_TEMPREFUND CUSTOM TABLE: STUDENT REFUND CHECK FEED TABLE TO BANNER INTERFACE INITIAL TABLE FOR UNFORMATTED DATA FROM LEGACY
FIMSMGRGURAPAY_TEMP2REFUND CUSTOM TABLE: MASS CHECKS TABLE FEED TO BANNER INTERFACE - FINAL GURAPAY LOAD TABLE
BANSECRGURATABGURATAB: This table defines all the forms and their related tabs that can be used for tab based security.
GENERALGURCALLQuickFlow Repeating Table
GENERALGURCARDTable to contain Campus Card Holder XML document for each role.
GENERALGURCATLTable to track Banner Forms' item attributes in order to keep the Workflow BCC up to date.
GENERALGURCURRCurrency conversion rate table.
GENERALGURDMODTable used to record what database modifications have been made to this database
GENERALGURFCLRAddress Collector Table used to store parameters by user session for FOCUS
GENERALGURFDEDPayroll Deduction Table
GENERALGURFEEDFinance Transaction Input Table
GENERALGURHLOGTable to contain history records for each occurrence of a given column change to table SPBPERS.
GENERALGURHMNUGeneral Hierarchical Menu Table
GENERALGURIDENGeneral Identification Table.
GENERALGURMAILMail Table
GENERALGURMCHGThis table is used to maintain changes to tables associated with Rule or Validation tables in Banner that use the Code as their key..
GENERALGURMENUGeneral Menu Repeating Table
GENERALGURMESGTable to contain Banner business objects.
GENERALGUROPTMThis 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
GENERALGUROUTDThe Data Extract repeating global temporary table used to store the data from Data Extract being performed.
GENERALGUROUTPThe job submission repeating output table used to store the output from batch jobs executed in a client server environment.
GENERALGURPOSTTable used to record patches that have been applied. New as of 6.0
GENERALGURRCHGThis table is used to maintain changes to tables associated with Rule or Validation tables in Banner that use the Code as their key..
BANSECRGURSQLLLog of SQL commands that are dynamically generated and executed by the security system front end.
GENERALGURSRVQSurvey Questions Repeating Table. This tables defines the survey questions.
GENERALGURSVRLSurvey Roles Repeating Table. This tables defines which roles may respond.
GENERALGURTEXTTable which holds text associated with Documents uploaded to GURFEED
GENERALGURTKLRGeneral Tickler Table.
GENERALGURTPRFPREFERENCE TABLE THAT STORES TOOLBAR AND MENU INFOG
BANSECRGURUCLSTable to track what BANNER security classes a user is authorized to access.
BANSECRGURUCLS_121407 
BANSECRGURUOBJThis table defines the type of access, by userid, for each Banner object.
GENERALGURUPRFPersonal Preference Table
BANSECRGURUSRIVPD Institution/Banner User Table
BANSECRGURUTABGURUTAB: This table defines all the forms and their related tabs that are in use for tab based security for a user or a class.
GENERALGURVERSGeneral Version Tracking Table
GENERALGUTMENUGlobal Temporary Table for Product Menus for Tree Component.
GENERALGUTPMNUGlobal Temporary Table for Personal Menu for Tree Component.
GENERALGUTWUSRWorkflow User Extraction Table.
GENERALGXRDIRDRecipient Direct Deposit Information Table.
GENERALGXRETIDEDI Transaction ID Table.
GENERALGXRTPIDEDI Trading Partner Table.
GENERALGXVBANKBank Validation Table
GENERALGXVDIRDRecipient Bank Validation Table
APLOCALGYRGRPSEmail Group table
APLOCALGYRLETR 
APLOCALGYTEMAL 
APLOCALGYTEMAL_12172007 
APLOCALGYTFEML 
GENERALGZBKANIKansas Instructor Data Table
GENERALGZBKITPPlus Data - Kansas Instructor Temp Data Table
GENERALGZBKTMPKansas (B) Report Temp Table with Instructor Data
BANSECRGZDSECR_USERS 
BANSECRGZDSECR_VIEWS 
GENERALGZRKCTPPlus Data - Kansas Course with Instructor Temp Data Table
GENERALGZRPINFContains information about jobs to be executed
GENERALGZRXWLKData Crosswalk Table
APLOCALIYGOAGMK_LOG 
APLOCALIYGORGMK_LOG 
BANINST1JAVA$CLASS$MD5$TABLE 
LCBMGRLCBVERSLCBVERS Version Tracking Table
POSNCTLNBBFISCFiscal Year Base Table
POSNCTLNBBPOSNPosition Base Table
POSNCTLNBBWKSHWork Schedule Base Table
POSNCTLNBRBCHGThis table is used to maintain changes to tables associated with the AP_POSITION_BUDGET composite view for incremental refresh processing in the ODS.
POSNCTLNBRBHISBudget History Table
POSNCTLNBRBJLHBase Job Labor Distribution History Table
POSNCTLNBRBJOBAssignment Repeating Base Table
POSNCTLNBRBJQEOverride Approvals Queue Base Table.
POSNCTLNBRCLSHPosition Classification History Table
POSNCTLNBREARNEmployee Default Earnings Code Table
POSNCTLNBREHDRSalary Planner Extract Header Table.
POSNCTLNBREJLDExtracted Job Labor Distribution Salary Planner Table.
POSNCTLNBREJOBExtracted Job Detail Salary Planner Table.
POSNCTLNBREPLDExtracted Position Labor Distribution Salary Planner Table.
POSNCTLNBREPSAExtracted Position Salary Planner Table.
POSNCTLNBRERRNExtracted Job Default Hours Salary Planner Table.
POSNCTLNBRFCHGThis table is used to maintain changes to tables associated with the AP_FISCAL_YEAR composite view for incremental refresh processing in the ODS.
POSNCTLNBRFCLDFringe Charge Back Position Budget. Repeating Table
POSNCTLNBRFTOTFringe Benefits Budget Totals Table.
POSNCTLNBRJCHGThis table is used to maintain changes to tables associated with the AP_EMPLOYEE_POSITION composite view for incremental refresh processing in the ODS.
POSNCTLNBRJFTEJob FTE Calculations and Tracking Table
POSNCTLNBRJLBDAssignment Labor Dist.  Repeating Table
POSNCTLNBRJLHSAssignment Labor Distribution History Repeating Table
POSNCTLNBRJOBSAssignment Repeating Table
POSNCTLNBRLOCKSalary Planner Organization Lock Table.
POSNCTLNBRPCHGThis table is used to maintain changes to tables associated with the AP_POSITION_DEFINITION composite view for incremental refresh processing in the ODS.
POSNCTLNBRPLBDPosition L/D Account Repeating Table
POSNCTLNBRPOSHPosition History Table
POSNCTLNBRPTOTPosition Budget Totals Table.
POSNCTLNBRRJQEOverride Approvals Queue Repeating Table.
POSNCTLNBRRTOTPremium Earnings Budget Totals Repeating Table
POSNCTLNBRSALCSalary Planner Salary Change Table.
POSNCTLNBRSPLCSalary Planner Organization Lock Collector Table.
POSNCTLNBRWKSHWork Schedule Base Table
POSNCTLNBRXDEDExcluded Deductions by Job Table
POSNCTLNBTEMPFSalary Planner Extracted Employee Temporary Table.
POSNCTLNBTFPRMSalary Planner Filter Parameter Table.
POSNCTLNBTFTOTFringe Actual Budget Temporary Table
POSNCTLNBTJERRSalary Planner Upload Jobs Error Temporary Table.
POSNCTLNBTJOBFSalary Planner Employee's Jobs Filter Temporary Table.
POSNCTLNBTORSFSalary Planner Organization Summary Filter Temporary Table.
POSNCTLNBTPERRSalary Planner Upload Position Error Temporary Table.
POSNCTLNBTPLBDPosition Labor Distribution Account Temporary Table
POSNCTLNBTPOSFSalary Planner Position Filter Temporary Table.
POSNCTLNBTPTOTSalary Budget Temporary Table.
POSNCTLNBTRTOTPremium Earnings Budget Totals Temporary Table
POSNCTLNHRDCHGThis table is used to maintain changes to tables associated with the AN_PAYROLL_DISTRIBUTION composite view for incremental refresh processing in the ODS.
POSNCTLNHRDISTPayroll Distribution History Table
POSNCTLNHRECRTTemporary Table for the nhrecrt - Effort Certification Report
POSNCTLNHRENCDEncumbrance Number Sequence Table.
POSNCTLNHRFINCHR/Finance Interface Distribution Table
POSNCTLNHRSDSTCollector Table for the nhrsdst report.
POSNCTLNHRTBUDPayroll Distribution History Table
POSNCTLNOBTRANTransaction Approvals Base Table
POSNCTLNORCMNTElectronic Approval Comments Table 
POSNCTLNOREAERElectronic Approvals Error Table
POSNCTLNORROUTTransaction Routing Repeating Table
POSNCTLNORTERNTransaction Approvals Default Earnings Table
POSNCTLNORTLBDTransaction Approvals Labor Distributions Table
POSNCTLNORTRANTransaction Approvals Repeating Table
POSNCTLNPRCOLRParameter Collector Repeating Table; used to hold multiple values of parameters for reports etc.
POSNCTLNSRSPSCSalary Planner Security Table.
POSNCTLNTRACATApproval Category Rule Table
POSNCTLNTRACLVApproval Category Levels Rule Table
POSNCTLNTRADFVElectronic Approvals Default Values Table
POSNCTLNTRAGIDElectronic Approval Category Group User ID Rules Table
POSNCTLNTRAGRPElectronic Approval Group Rules Table
POSNCTLNTRALVLApproval Level Rule Table
POSNCTLNTRAPFBElectronic Approval Type Form/Block Rule Table
POSNCTLNTRAPFDElectronic Approval Type Field Rule Table
POSNCTLNTRAUBKElectronic Approval Block Usage Rule Table.
POSNCTLNTRAUFDElectronic Approval Field Usage Rule Table.
POSNCTLNTRAUFMElectronic Approval Form Usage Rule Table
POSNCTLNTRBQUERouting Queue Rules Base Table.
POSNCTLNTRBROLBudget Roll Parameter Table
POSNCTLNTRCROLRoll Contract Dates Rule Table
POSNCTLNTRFBEXFringe External Funding Source Rate Definition Rule Table
POSNCTLNTRFBINFringe Installation Rate and Labor Distribution Override Rule Table
POSNCTLNTRFELDFringe External Funding Source Labor Distribution Override Rule Table
POSNCTLNTRFINIHR/Finance Set Up Rule Table
POSNCTLNTRFRNGFringe Benefits Budgeting Rule Table
POSNCTLNTRHROLRoll Encumbrance Hours Rule Table
POSNCTLNTRINSTPosition Control Installation Rule Table
POSNCTLNTRJINCMass Job/Assignment Salary Increase Rule Table
POSNCTLNTRJINRRule Set Mass Job/Assignment  Code Validation Table.
POSNCTLNTRJOBPJob Progression Rule Table
POSNCTLNTRJTGRMass Job/Assignment Table Grades Rule Table
POSNCTLNTRJTPCMass Job/Assignment Table Position Class Rule Table.
POSNCTLNTRJTRLMass Job/Assignment Salary Table Roll Rule Table
POSNCTLNTRJTSTMass Job/Assignment Table Step Rule Table.
POSNCTLNTRLVIDApproval Level Id"s Rule Table
POSNCTLNTRPCLSPosition Classification Rule Table
POSNCTLNTRPROXProxy Rule Table
POSNCTLNTRROUTTransaction Routing Repeating Table
POSNCTLNTRRQUERouting Queue Roles Repeating Table.
POSNCTLNTRSALASalary/Rate Rule Table
POSNCTLNTRSALBSalary/Rate Base Rule Table
POSNCTLNTRSCHGThis table is used to maintain changes to tables associated with the AP_SALARY_RATE composite view for incremental refresh processing in the ODS.
POSNCTLNTRSGRPSalary Group Rule Table
POSNCTLNTRSPBUSalary Planner Extract Bargaining Unit Rule Table.
POSNCTLNTRSPECSalary Planner Extract Employee Class Rule Table.
POSNCTLNTRSPEXSalary Planner Extract Rule Table.
POSNCTLNTRSPPRSalary Planner Extract Budget Profile Rule Table.
POSNCTLNTRSTGRMass Salary Table Grades Rule Table
POSNCTLNTRSTRLMass Salary Table Roll Rule Table
POSNCTLNTRTPRX 
POSNCTLNTRWKSHWork Schedule Rule Table
POSNCTLNTVACATApproval Category Code Validation Form
POSNCTLNTVAGRPElectronic Approval Groups Validation Table
POSNCTLNTVAPTYApproval Type Code Validation Table
POSNCTLNTVBPROBudget Profile Validation Table.
POSNCTLNTVDOTTDictionary of Occupational Titles Code (DOTT) Validation Table
POSNCTLNTVJOBPJob Progression Validation Table
POSNCTLNTVPFOCFederal Occupational Code (FOC) Validation Table
POSNCTLNTVPNOCNational Occupational Code (NOC) Validation Table
POSNCTLNTVWKSHWork Schedule Code Validation Table
POSNCTLNURVERSPosition Control Version Table
POSNCTLNZBBUDEPosition and Employee Extract Table
POSNCTLNZBBUDE_2009MAR 
POSNCTLNZCBUDEPosition and Employee Extract Table
POSNCTLNZCCHRTPosition and Employee Extract Table
POSNCTLNZCLBDEPosition L/D Account Repeating Table
POSNCTLNZCPETCPosition and Employee Extract Table
POSNCTLNZCTITLPosition and Employee Extract Table
POSNCTLNZRBTMPPosition and Employee Extract Table
POSNCTLNZRLBDEPosition L/D Account Repeating Table
POSNCTLNZRLBDE_2009MAR 
POSNCTLNZRSALETennessee Salary Extract table.
POSNCTLNZTPOSU 
POSNCTLNZTSALR 
POSNCTLNZTSALU 
PAYROLLPABAPPLApplicant Base Table
PAYROLLPABPFACPosition Requirements Factor of Importance Table.
PAYROLLPABREQUPosition Requisition Table
PAYROLLPARACHGThis table is used to maintain changes to tables associated with the AP_HR_APPLICATION composite view for incremental refresh processing in the ODS.
PAYROLLPARAPINApplicant Interviewer Table
PAYROLLPARAPSTApplicant Status Repeating Table
PAYROLLPARCDESPosition Classification Description Table
PAYROLLPARPCERPosition Certifications Required Table
PAYROLLPARPCMTPosition Comments Table.
PAYROLLPARPCONPosition Area of Concentration Table
PAYROLLPARPDEGPosition Degree Table
PAYROLLPARPDESPosition/Position Classification Description Table
PAYROLLPARPENDPosition Endorsements Required Table
PAYROLLPARPEXMPosition Exams Required Table
PAYROLLPARPMAJPosition Major Table
PAYROLLPARPMINPosition Minor Table
PAYROLLPARPSKLPosition Skills Required Table
PAYROLLPARRCHGThis table is used to maintain changes to tables associated with the AP_HR_REQUISITION composite view for incremental refresh processing in the ODS.
PAYROLLPATRECRTemp table for Web for Executive Requisition/Application profile extract
APLOCALPATRON_TEMP 
ROBINSOBPAYFEED 
PAYROLLPCBPERSCobra Person Base Table
PAYROLLPCRBCOVCobra Beneficiary Coverage Repeating Table
PAYROLLPCRBENECOBRA Dependent and Beneficiary Repeating Table
PAYROLLPCRCPAYCobra Payment Administration Repeating Table
PAYROLLPCRDEDNCobra Person Benefit Repeating Table
PAYROLLPDR1042Windstar Payment Information Repeating Table.
PAYROLLPDRBCHGThis table is used to maintain changes to tables associated with the AP_BENEFIT_DEDUCTION composite view for incremental refresh processing in the ODS.
PAYROLLPDRBCHSBeneficiary Coverage Table.
PAYROLLPDRBCOVBeneficiary Coverage Repeating Table
PAYROLLPDRBDEDEmployee Deduction Repeating Base Table
PAYROLLPDRBEHSBeneficiaries/Dependents Table.
PAYROLLPDRBENEDependent and Beneficiary Repeating Table
PAYROLLPDRBFLXFlex Benefit Base Table
PAYROLLPDRDEDNEmployee Deduction Repeating Table
PAYROLLPDRF496F-496 REQUIRED DATA ELEMENTS TABLE.
PAYROLLPDRFBALEmployee Flexible Benefits Balance Table
PAYROLLPDRFCLMEmployee Flexible Benefits Claims Table
PAYROLLPDRFLEXEmployee Flexible Benefits Table
PAYROLLPDRMR87MR-87 REQUIRED DATA ELEMENTS TABLE.
PAYROLLPDRPERSCalifornia PERS Report of Payroll
Contributions Required Data Elements Table.
PAYROLLPDRXPIDEmp Dedn Excl Pay Id Repeating Table
PAYROLLPEAPNHZHealth and Safety Position Hazard Rule Table
PAYROLLPEBEMPLEmployee Base Table
PAYROLLPEBGREVGrievance Table.
PAYROLLPEBHSINHealth and Safety Incident Table
PAYROLLPEBPAYMOne-Time Payments Payment Method Information Table.
PAYROLLPEBROECRecord of Employment Information Base table
PAYROLLPER10421042S Information Upload Repeating Table.
PAYROLLPERACTLFaculty Action Academic Title Table.
PAYROLLPERAHISEmployee Accommodation History Table 
PAYROLLPERAPPTFaculty Appointment/Tenure History Table.
PAYROLLPERASGNEmployee Assignment Data Table
PAYROLLPERBARGEmployee Bargaining Unit Table
PAYROLLPERBFACFaculty Information Base Table.
PAYROLLPERBFMLFamily Medical Leave Act Base Table.
PAYROLLPERCAPLFaculty Action Appeal Table.
PAYROLLPERCAPRFaculty Action Approval Table.
PAYROLLPERCFMLFamily Medical Leave Act Comment Table.
PAYROLLPERCOMMOne-Time Payments Job Comments Table.
PAYROLLPERDADJEmployee Defer Pay Adjustment Repeating Table
PAYROLLPERDAYHTime Entry Pay Period Days History Table.
PAYROLLPERDAYSTime Entry Pay Period Effective Date Breakdown Table.
PAYROLLPERDCHGThis table is used to maintain changes to tables associated with the AP_MONTHLY_DEDUCTION composite view for incremental refresh processing in the ODS.
PAYROLLPERDEMOTable Description: CA MIS Demographic Table.
PAYROLLPERDHISEmployee Deduction History Repeating Table
PAYROLLPERDIRDEmployee Direct Deposit Repeating Table
PAYROLLPERDTOTEmployee Monthly Benefit / Deduction Totals Repeating Table
PAYROLLPEREACCEmployee Accommodation Tracking Table 
PAYROLLPEREARHTime Entry Earnings History Table
PAYROLLPEREARIOne-Time Payments Earn Code Information Table.
PAYROLLPEREARNTime Entry Earnings Repeating Table
PAYROLLPERECHGThis table is used to maintain changes to tables associated with the AP_EMPLOYEE composite view for incremental refresh processing in the ODS.
PAYROLLPEREEO1Required Fields Repeating Table
PAYROLLPEREEO4Required Fields Repeating Table
PAYROLLPEREEO5Required Fields Repeating Table
PAYROLLPEREEO6Required Fields Repeating Table
PAYROLLPEREEOTMagnetic Tape Reporting Table
PAYROLLPEREFMLFamily Medical Leave Act Earning Table.
PAYROLLPEREHISEmployee History Repeating Table
PAYROLLPERELBDTime Entry Labor Distribution Repeating Table
PAYROLLPERELBHTime Entry Earnings Labor Distribution Repeating Table
PAYROLLPERETOTEmployee Monthly Earnings Totals Repeating Table
PAYROLLPERFACCFaculty Action Comments Table.
PAYROLLPERFACLPosition Control Faculty Load Table
PAYROLLPERFAPLFaculty Appeal Table.
PAYROLLPERFAPRFaculty Approval Table.
PAYROLLPERFMLAFamily Medical Leave Act Usage Table.
PAYROLLPERGRDSGrievance Description Table
PAYROLLPERGRPAGrievance Participants Table.
PAYROLLPERGRRAGrievance Resulting Actions Table
PAYROLLPERGRREGrievance Resolution Table
PAYROLLPERHFMLFamily Medical Leave Act History Table.
PAYROLLPERHIREEmployee Hire Control Table
PAYROLLPERHOUHTime Entry Hours Breakdown History Table
PAYROLLPERHOURTime Entry Hours Breakdown Table
PAYROLLPERHSCTHealth and Safety Incident Costs Table
PAYROLLPERHSFCHealth and Safety Incident Table.
PAYROLLPERHSIDIncident Comments Table.
PAYROLLPERHSIHHealth and Safety Incident Hazard Table
PAYROLLPERHSIMHealth and Safety Incident Medical Table
PAYROLLPERHSIPHealth and Safety Incident Partys Table
PAYROLLPERHSITHealth and Safety Incident Type Table
PAYROLLPERHSRAHealth and Safety Incident Recommendations and Actions Table
PAYROLLPERINDVIndividual Information Upload Repeating Table.
PAYROLLPERJACTEmployee Job Activity Table
PAYROLLPERJBBGJobs Bargaining Unit Table
PAYROLLPERJFACJob Point Factor Assignment Table
PAYROLLPERJHISAssignment History Repeating Table
PAYROLLPERJLBDOne-Time Payments Job Labor Distribution Information Table.
PAYROLLPERJLEVEmployee Leave Balances by Jobs Repeating Table.
PAYROLLPERJLHSHistory of Employee Leave Balances by Jobs Repeating Table.
PAYROLLPERJOBHTime Entry Jobs History Table
PAYROLLPERJOBIOne-Time Payments Job Information Table.
PAYROLLPERJOBPEmployee Job Progression Table
PAYROLLPERJOBSTime Entry Jobs Table
PAYROLLPERJTOTEmployee Monthly Job Totals Repeating Table
PAYROLLPERLEAVEmployee Leave Balances Repeating Table
PAYROLLPERLHISHistory Employee Leave Balances Repeating Table
PAYROLLPERLVTKEmployee Leave Hours Taken Table.
PAYROLLPERNASGEmployee Assignment Data Table
PAYROLLPERPADVPay Advance Table
PAYROLLPERPCREEmployee Canadian Pension Credit Repeating Table.
PAYROLLPERRANKFaculty Rank History Table.
PAYROLLPERRCMTRecord of Employment Comments Information table
PAYROLLPERREVWEmployee Review Type Repeating Table
PAYROLLPERRHOLRecord of Employment Holiday Information table
PAYROLLPERROTHRecord of Employment Other Monies Information table
PAYROLLPERROUHTime Entry Routing Queue History Table
PAYROLLPERROUTTime Entry Routing Queue Table
PAYROLLPERSABBFaculty Sabbatical/Other Leaves History Table.
PAYROLLPERSAHSEmployee Seniority Adjustment History Table
PAYROLLPERSNBLEmployee Seniority Balance Table
PAYROLLPERSTANEmployee Statistics Annual Salary Table
PAYROLLPERTCHGThis table is used to maintain changes to tables associated with the AP_EARNING_TOTALS composite view for incremental refresh processing in the ODS.
PAYROLLPERTETHTime Entry Transaction History Table
PAYROLLPERTITHTime In/Out History Table
PAYROLLPERTITOTime Entry Hours Breakdown Table
PAYROLLPERTWFATemporary Table for Work Force Analysis Reports
PAYROLLPERXJOBJobs Excluded From the EEO-5 Report Table
PAYROLLPERYCHGThis table is used to maintain changes to tables associated with the AP_EMPLOYEE_EARNING composite view for incremental refresh processing in the ODS.
PAYROLLPETDEGRtemp table Web for Executive Degree profile extract
PAYROLLPETEDIREmployee Directory Temporary Table
PAYROLLPETJOBSTime Entry Temporary Jobs Table
PAYROLLPETJTLEEmployee Job Title Temporary Table
PAYROLLPETTIMETime Entry Hours Breakdown Temporary Table
PAYROLLPETWEMPtemp table for Web for Executive Employee/Appointment profile extract
PAYROLLPHR10421042 REPORTING TABLE
PAYROLLPHRACCRCurrent Leave Accruals Repeating Table
PAYROLLPHRATNDPay History Attendance Repeating Table
PAYROLLPHRBKTPPayroll Bank Tape Table
PAYROLLPHRDCHGThis table is used to maintain changes to tables associated with the AN_PAYROLL_DISTRIBUTION composite view for incremental refresh processing in the ODS.
PAYROLLPHRDEDNPay History Deduction Repeating Table
PAYROLLPHRDIRDDirect Deposit table to hold amounts from tape
PAYROLLPHRDOCMDocument Number Repeating Table
PAYROLLPHREARNPay History Earnings Repeating Table
PAYROLLPHRELBDPay History L/D Override Repeating Table
PAYROLLPHRERRLPay History Error Log Repeating Table
PAYROLLPHRFLSAFair Labor Standards Act Overtime reporting Table
PAYROLLPHRHISTPay History Repeating Table
PAYROLLPHRHOURHour Validation Table
PAYROLLPHRJACRCurrent Leave Accruals by Jobs Repeating Table.
PAYROLLPHRJOBSPay History Jobs Repeating Table
PAYROLLPHRMTIMMass Time Entry Table
PAYROLLPHRPENSCalifornia STRS/PERS Pension Contribution Table.
PAYROLLPHRREDSPayroll Labor Redistribution work table.
PAYROLLPHRTDEDTemporary Deduction Table For Check/Direct Deposit Process
PAYROLLPHRTERNTemporary Table To Implement Roster and Organizational Time Sheet Reports
PAYROLLPHRTHRSTemporary Table To Implement Work Schedules.
PAYROLLPHRTLBDTemporary History Labor Distributions Table
PAYROLLPHRUICWCanadian Unemployment Insurance Compensation Weeks
PAYROLLPHTPENSCalifornia STRS/PERS Pension Contribution Temporary Table
PAYROLLPHTRETORetro Pay Details Temporary Table
PAYROLLPHTRPERTemporary Retro Active Pay Period Table
APLOCALPIN_CHG_ERRORS 
APLOCALPIN_CHG_NO_EMAIL_ADDR 
FIMSMGRPLAN_TABLE 
PAYROLLPORCONTUnion Contract Information Table.
PAYROLLPORUNINUnion Address Information Table.
PAYROLLPOTPARMTemporary Parameter Table for Views
PAYROLLPPRCCMTPerson Coded Comment Repeating Table
PAYROLLPPRCERTPerson Certification Repeating Table
PAYROLLPPRCMNTW2 Position Comment Table.
PAYROLLPPRCOLRParameter Collector Repeating Table; used to hold multiple values of parameters for reports etc. 
PAYROLLPPRDLICDriver License Information Table.
PAYROLLPPRENDSEmployee Endorsement Repeating Table
PAYROLLPPREXAMPerson Exam Repeating Table
PAYROLLPPREXPEPrior Experience Repeating Table
PAYROLLPPRHNAWHonors and Awards Information Table.
PAYROLLPPRPUBLPublished Works Table
PAYROLLPPRQRYTTemporary Table for Queries
PAYROLLPPRREFEApplicant References Table
PAYROLLPPRSKILPerson Skills Inventory Repeating Table
PAYROLLPSRECLSEmployee Class Code Security Access List Rule Table
PAYROLLPSREMPREmployer Code Security Access List Rule Table
PAYROLLPSRORGNOrganization Code Security Access List Rule Table
PAYROLLPTRAFANAvailability Factor Analysis Rule Table
PAYROLLPTRAPPSApplicant Status Rule Table
PAYROLLPTRATRMAssociated Term Validation Table
PAYROLLPTRBCATBenefit/Deduction Category Rule Table
PAYROLLPTRBCDNBenefit Category Set-up Rule Table
PAYROLLPTRBDASBenefit/Deduction Associated Deductions Table
PAYROLLPTRBDCABenefit/Deduction Calculation Rule Table
PAYROLLPTRBDCGBenefit / Deduction Contingent Rule Table
PAYROLLPTRBDFQBenefit Payroll Frequency Rule Table
PAYROLLPTRBDGMBenefit/Deduction group member rule table
PAYROLLPTRBDIDBenefit/Deduction Inclusions Rule Table
PAYROLLPTRBDLDLabor Distribution Rule Table
PAYROLLPTRBDMCBenefit/Deduction Mass Change Rule Table
PAYROLLPTRBDPDPrecluded Deduction Rule Table
PAYROLLPTRBDPGBenefit/Deduction primary group rule table
PAYROLLPTRBDPLBenefit/Deduction Valid Plan Rule Table
PAYROLLPTRBDSGBenefit/Deduction secondary group rule table
PAYROLLPTRBDXDBenefit/Deductions Exclusions Rule Table
PAYROLLPTRBDXEBene/Dedn Earn Code Exclusions Rule Table
PAYROLLPTRBRELBeneficiary Relationship Rule Table
PAYROLLPTRBSDD 
PAYROLLPTRBUREBargaining Unit Relationship Status Table
PAYROLLPTRCALNPayroll Calendar Rule Table
PAYROLLPTRCBENCobra Benefit Coverage Rule Table
PAYROLLPTRCERTCertification Code Validation Table
PAYROLLPTRCFACCompensable Factor Rule Table
PAYROLLPTRCITZTable Description:Foreign Persons Citizenship Rule Table.
PAYROLLPTRCOBRCobra Rule Table
PAYROLLPTRCOVRLife Insurance Coverage Rule Table
PAYROLLPTRDCHNDeduction Chain Rule Table
PAYROLLPTRDFPNDefer Pay Period Paynumbers Rule Table
PAYROLLPTRDFPRDefer Pay Period Rule Table
PAYROLLPTREARNEarnings Code Rule Table
PAYROLLPTRECBCECLS Eligible Benefit Category Rule Table
PAYROLLPTRECLCECLS Eligible Leave Category Rule Table
PAYROLLPTRECLDEarnings Code Labor Dist Rule Table
PAYROLLPTRECLSEmployee Class Rule Table
PAYROLLPTREEOSEEO Salary Level Rule Table
PAYROLLPTREERNEmployee Class Earn Code Rule Table
PAYROLLPTREHOLEmployee Holidays Rule Table
PAYROLLPTREMPREmployer Rule Table
PAYROLLPTREMTYEmployer Type Code Rule Table.
PAYROLLPTRERSTEmployer State Information Table
PAYROLLPTREXAMExamination Rule Table
PAYROLLPTRFBENFlexible Benefits Rule Table
PAYROLLPTRFILEFlat File Column Definition Rule Table.
PAYROLLPTRFLEXFlexible Benefits Period Rule Table
PAYROLLPTRFTYPFaculty Type Code Rule Table.
PAYROLLPTRGTAXGovernment Taxable Life Insurance Premium Rule Table.
PAYROLLPTRHAZDHealth and Safety Hazards Rule Table
PAYROLLPTRHSILHealth and Safety Incident Locations Table
PAYROLLPTRHSMEHealth and Safety Medical Condition Rule Table
PAYROLLPTRHZCMHealth and Safety Hazard Comments Rule Table
PAYROLLPTRHZPRHealth and Safety Hazard Precautions Table
PAYROLLPTRHZTPHazard Type Table
PAYROLLPTRINCDTable Description:Foreign Persons Income Deduction Rule Table.
PAYROLLPTRINSEOne-Time Payments Position Information Table.
PAYROLLPTRINSTPayroll Institution Rule Table
PAYROLLPTRJBLNJob/Hiring Location Rule Table.
PAYROLLPTRJCREJob Change Reason Table
PAYROLLPTRLCDEUnion Local Rule Table.
PAYROLLPTRLEAVLeave Title Rule Table
PAYROLLPTRLGTYLongevity code rule table
PAYROLLPTRLIFELife Insurance Calc Process Rule Table
PAYROLLPTRLIFILife Insurance Rule Table
PAYROLLPTRLOCNLocation Rule Table
PAYROLLPTRLREALeave Reason Code Rule Table.
PAYROLLPTRLVACLeave Accrual Rule Table
PAYROLLPTRLVASLeave Assignment Rule Table
PAYROLLPTRLVPRLeave Priority Code Table
PAYROLLPTRNATNNation/Country Cross-Reference Rule Table
PAYROLLPTRPCALEmployee Canadian Pension Credit Calculation Rule Table.
PAYROLLPTRPCLMEmployee Canadian Pension Credit Limits Rule Table.
PAYROLLPTRPERNPremium Pay Eligible Earnings Rule Table
PAYROLLPTRPGRPPosition Group Validation Table
PAYROLLPTRPICTPayroll Identification Code Rule Table
PAYROLLPTRPPASPremium Pay Assignment Rule Table
PAYROLLPTRPPAYPremium Pay Code Rule Table
PAYROLLPTRPPCMPremium Pay Computation Rule Table
PAYROLLPTRPREMLife Insurance Premium Rule Table
PAYROLLPTRPSASProjected Statistics Annual Salary Table
PAYROLLPTRRANKFaculty Rank Rule Table
PAYROLLPTRREQSRequisition Status Rule Table
PAYROLLPTRRERNRetro Active Pay Earnings Rule Table
PAYROLLPTRRPERRetroactive Pay Period Information Table.
PAYROLLPTRSCDPStats Canada Department Rule Table
PAYROLLPTRSCHLSchool Rule Table
PAYROLLPTRSCRDDefine Minimum Hours for Full-Time Student Employee Rules Table
PAYROLLPTRSDEDSupplemental Payroll Deductions Rule Table
PAYROLLPTRSEHSStatistics Earnings History Table
PAYROLLPTRSERNSupplemental Payroll Earn Codes Rule Table
PAYROLLPTRSHFTShift Number Rule Table
PAYROLLPTRSKILSkill Code Rule Table.
PAYROLLPTRSKLVSkill Levels Rule Table
PAYROLLPTRSTANStatistics Annual Salary Calculation Table
PAYROLLPTRSTAN_R20Statistics Annual Salary Calculation Table
PAYROLLPTRSTAXStatistics Annual Salary Excluded Suffixes Table
PAYROLLPTRSTDEStudent Deduction Rule Table
PAYROLLPTRTENRFaculty Member Tenure Status Code Table
PAYROLLPTRTESH 
PAYROLLPTRTPCMThird Party Category Code and Map Column Repeating Table.
PAYROLLPTRTPCSThird Party Category Code Repeating Table.
PAYROLLPTRTREATermination Reason Rule Table
PAYROLLPTRTSFNTime Sheet Footnotes Rule Table
PAYROLLPTRUNLOUnion Local Rule Table.
PAYROLLPTRUSERUser Code Rule Table
PAYROLLPTRWKPRWork Period Table
PAYROLLPTV10991099 Distribution Code Validation Table
PAYROLLPTV87TRCalifornia PERS MR-87 Transaction Code Validation Table.
PAYROLLPTVACSTAccommodation Status Validation Table 
PAYROLLPTVASRCApplicant Source Code Validation Table
PAYROLLPTVASSNCalifornia STRS Employee Assignment Code Validation Table.
PAYROLLPTVATRMAssociated Term Validation Table
PAYROLLPTVBARGBargaining  Unit Validation Table
PAYROLLPTVBDPGBenefit/Deduction Group Code Validation Table.
PAYROLLPTVBDTYBenefit/Deduction Type Validation Table
PAYROLLPTVBTPCThird Party Category Code Base Table.
PAYROLLPTVCATYContract and Agreement Type Table.
PAYROLLPTVCDESPosition Class Description Validation Table
PAYROLLPTVCMTYComment Type Validation Table
PAYROLLPTVDISAHealth and Safety Disability Type Validation Table
PAYROLLPTVDISPDiscipline Code Validation Table.
PAYROLLPTVEEOCEEO Ethnic Codes Validation Table
PAYROLLPTVEEOGEEO Contract Group Code Validation Table
PAYROLLPTVEFUNEEO Function Code Validation Table
PAYROLLPTVEGRPEmployee Group Code Table
PAYROLLPTVENDSEndorsement Validaton Table.
PAYROLLPTVERGREarnings group code and desc Table
PAYROLLPTVESKLEEO Skill Code Validation Table
PAYROLLPTVFACCFaculty Action Comment Code Validation Table.
PAYROLLPTVFMSTFamily Medical Leave Act Status Validation Table.
PAYROLLPTVFREAFamily Medical Leave Act Leave Reason Validation Table.
PAYROLLPTVGRPTGrievance Participant Type Validation Table
PAYROLLPTVGRSRGrievance Standard Results Validation Table
PAYROLLPTVGRTPGrievance Type Validation Table
PAYROLLPTVHSCRHealth and Safety Costs Reasons Validation Table
PAYROLLPTVHSLTHealth and Safety Location Type Table
PAYROLLPTVHSMTHealth and Safety Medical Condition Type Table
PAYROLLPTVHSPCHealth and Safety Party Classification Validation Table
PAYROLLPTVHSTCHealth and Safety Incident Type Code Validation Table
PAYROLLPTVHZSPHazzards Standard Precautions Validation Table
PAYROLLPTVHZTCHazard Type Code Validation Table
PAYROLLPTVISTAIncident Status Validation Table
PAYROLLPTVJACTJob Activity Code Table
PAYROLLPTVJCTYJob Change Type Table
PAYROLLPTVLCATLeave Category Rule Table
PAYROLLPTVLCSVLicense/Certification Status Code Validation Table
PAYROLLPTVLGCDLongevity Code Validation Table
PAYROLLPTVLITGLitigation Status Validation Table
PAYROLLPTVMANUManufacturer Validation Table
PAYROLLPTVNRSIT4A-NR Service Industry Validation table
PAYROLLPTVORGNOrganization Code Validation Table.
PAYROLLPTVPCATPremium Pay Category Validation Table
PAYROLLPTVPUBTPublication Code Validation Table
PAYROLLPTVRANKRank Code Validation Table
PAYROLLPTVREPTTax Report Table
PAYROLLPTVREVTReview Type Validation Table
PAYROLLPTVROERRecord Of Employment Validation Table
PAYROLLPTVRQSTAccommodation Request Status Validation Table 
PAYROLLPTVRSTARecommendation Status Validation Table
PAYROLLPTVSARCSeniority Adjustment Reason Validation Table
PAYROLLPTVSBTYSabbatical Type Code Validation Table.
PAYROLLPTVSCCTStats Canada Colleges Faculty Type Validation
Table.
PAYROLLPTVSCETStats Canada Employer Type Validation Table.
PAYROLLPTVSCFTStats Canada Full Time Faculty Type Validation
table.
PAYROLLPTVSCPTStats Canada Part Time Faculty Type Validation
table.
PAYROLLPTVSHCDShift Code Rule Table
PAYROLLPTVSTCAStatistics Canada Category Code Validation Table
PAYROLLPTVSTGRStatistics Canada Grouping Type Validation Table
PAYROLLPTVTPCDThird Party Vendor Code Validation Table.
PAYROLLPTVWKCPWorkers' Compensation Classification Validation Table
PAYROLLPURCMNTHR Comment on Column Table
PAYROLLPURVERSHuman Resources Version Tracking Table
PAYROLLPXR10991099-R Data Holding Table
PAYROLLPXRADDSTax Additional Step Repeating Table
PAYROLLPXRASCCAnnual Statistics Canada Survey Data: Colleges and Related Institutions Educational Staff Survey Table.
PAYROLLPXRASCFAnnual Statistics Canada Surveys: University Full-Time Teaching Staff Survey Table.
PAYROLLPXRASCPAnnual Statistics Canada Surveys: University Part-Time Teaching Staff Survey Table.
PAYROLLPXRCALCAlternate Tax Calculation Table
PAYROLLPXREXEMTax Exemption Repeating Table
PAYROLLPXRFSTATax Filing Status Table
PAYROLLPXRGRADTax Graduated Table Repeating Table
PAYROLLPXRMT42Foreign Person's Magnetic Tape Table
PAYROLLPXRMTERMagnetic Tape Tax Reporting ...  Employer information
PAYROLLPXRMTINMagetic Tape Tax Reporting ...  Installation / Transmitter information.
PAYROLLPXRMTPRW2 Wage and Tax Statement Magnetic Reporting Table for Puerto Rico
PAYROLLPXRMTT4Canadian T4 Magnetic Tape Table
PAYROLLPXRMTTACanadian T4A Magnetic Tape Table.
PAYROLLPXRMTTNCanadian T4A-NR Magnetic Tape Table
PAYROLLPXRMTW2W2 Wage and Tax Statement Magnetic Reporting Table
PAYROLLPXROUTFHolding area for output file records
PAYROLLPXROUTPHolding Area for Writing Large Output Records
PAYROLLPXRRBOXTax Reporting Box Identification Table
PAYROLLPXRRDEDTax Reporting Benefit/Deduction Box Designation Table
PAYROLLPXRREGNCanadian Registration Number Table
PAYROLLPXRREPTTax Reporting Rule Table.
PAYROLLPXRRERNTax Reporting Earnings Box Designation Table
PAYROLLPXRROECCanadian ROE Generation: generates Canadian Record of Employment Table.
PAYROLLPXRT4SSCanadian T4 Supplementary Table.
PAYROLLPXRTVFYTax calculation test data table
PAYROLLPXRTXCDTax Code Table
PAYROLLPXRW2CDW-2 and W-2C Coded Information Table
PAYROLLPXRW2EFElectronic Filing Submitter Information.
PAYROLLPXRW2ERElectronic Filing Employer Information.
PAYROLLPXRW2FDW-2 and W-2C Federal Table
PAYROLLPXRW2LCW-2 and W-2C Local Table
PAYROLLPXRW2PSPuerto Rico W-2 Snapshot Table
PAYROLLPXRW2SSW-2 Snapshot Table
PAYROLLPXRW2STW-2 and W-2C State Table
PAYROLLPYRBDLD 
PAYROLLPYRECLS 
PAYROLLPYRFEED 
APLOCALPYTEMAL 
PAYROLLPZBACLRYear-End Leave Liability Collector Table
PAYROLLPZBANNLEmployee Leave Taken Table
PAYROLLPZBEMPLTennessee Employee Tracking Experience Table.
PAYROLLPZCDEPDTIS Dependent and Coverage Records Table
PAYROLLPZCEMPDTIS Employee Eligibility Records Table
PAYROLLPZCEMPITIS Employee Enrollment Records Table
PAYROLLPZPCHGSAudit Change Report Information 
PAYROLLPZPDLMTAudit Change Report Information 
PAYROLLPZPLONGAudit Change Report Information 
PAYROLLPZPLTDDAudit Change Report Information 
PAYROLLPZPTIAATIAA table: Table for TIAA
PAYROLLPZRBCOVTIS Beneficiary Coverage Repeating Table
PAYROLLPZRBENETIS Dependent and Beneficiary Repeating Table
PAYROLLPZREMPREMPLOLYER TIS RULE TABLE
PAYROLLPZREO6D 
PAYROLLPZRTCRSRetro Retirement Adjustment
PAYROLLPZTFLLD 
PAYROLLPZTPREMTIS Premiums Due Temporary Table
FAISMGRRBBABUDApplicant Budget Table
FAISMGRRBRACMPApplicant Budget Component Table
FAISMGRRBRCCHGThis table is used to maintain changes to tables associated with the AR_FINAID_BUDGET_COMPONENT composite view for incremental refresh processing in the ODS.
FAISMGRRBRCOMPBudget Component Rules Table
FAISMGRRBRGMSGBudget Group Message Rules Table
FAISMGRRBRGTYPBudget Group/Budget Type Rules Table
FAISMGRRBRMIXDApplicant Mixed Enrollment Table
FAISMGRRCRAIDYTelephone Financial Aid Award Year Table defines the award years that are available for telephone financial aid callers.
FAISMGRRCRAPP1Financial Aid Application Table - Part 1
FAISMGRRCRAPP2Financial Aid Application Table - Part 2
FAISMGRRCRAPP3Financial Aid Application Table - Part 3
FAISMGRRCRAPP4Financial Aid Application Table - Part 4
FAISMGRRCRESARFinancial Aid Application Table - ESAR Data
FAISMGRRCRIMP1Additional CSS PROFILE Data 
FAISMGRRCRINFCInterface Data Aid Year Rule Table.
FAISMGRRCRINFRMatching Rules Table
FAISMGRRCRLDS1Applicant NSLDS Table Part 1
FAISMGRRCRLDS2Applicant NSLDS Table Part 2
FAISMGRRCRLDS3Applicant NSLDS Table Part 3
FAISMGRRCRLDS4Applicant NSLDS Table Part 1
FAISMGRRCRLDS5Applicant NSLDS Table Part 2
FAISMGRRCRLDS6Applicant NSLDS Table Part 3
FAISMGRRCRLDS7NSLDS Pell Payment Repeating Table
FAISMGRRCRLDS8NSLDS Name History Table
FAISMGRRCRLDSANSLDS ACG Payment Permanent Table.
FAISMGRRCRLDSSNSLDS SMART Payment Permanent Table.
FAISMGRRCRLDSTNSLDS TEACH Payment Permanent Table
FAISMGRRCRNAMEFirst Name Translation Rules Table.
FAISMGRRCRNCHGThis table is used to maintain changes to tables associated with the AR_NEED_ANALYSIS composite view for incremental refresh processing in the ODS.
FAISMGRRCRTERMTelephone Financial Aid Term Table defines the terms that are available within an award year, for giving students disbursement information in telephone financial aid.
FAISMGRRCRTMP1Financial Aid Temp.  Appl.  Table - Part 1
FAISMGRRCRTMP2Financial Aid Temp. Appl. Table - Part 2
FAISMGRRCRTMP3Financial Aid Temp. Appl. Table - Part 3
FAISMGRRCRTMP4Financial Aid Temp. Appl. Table - Part 4
FAISMGRRCRTMP5Additional CSS PROFILE Data 
FAISMGRRCRTMP6Financial Aid Temp. Appl. Table - Part 6
FAISMGRRCRTPTRFinancial Aid Tape Translation Table
FAISMGRRCTESARFinancial Aid Application Table - ESAR Data
FAISMGRRCTINFRTemporary Tape Load ID Table
FAISMGRRCTLDS1Applicant NSLDS Temp Table Part 1
FAISMGRRCTLDS2Applicant NSLDS Temp Table Part 2
FAISMGRRCTLDS3Applicant NSLDS Temp Table Part 3
FAISMGRRCTLDS4Applicant NSLDS Temporary Table Part 1
FAISMGRRCTLDS5Applicant NSLDS Temp Table Part 2
FAISMGRRCTLDS6Applicant NSLDS Temp Table Part 3
FAISMGRRCTLDS7NSLDS Pell Payment Repeating Table
FAISMGRRCTLDSANSLDS ACG Payment Temporary Table.
FAISMGRRCTLDSSNSLDS SMART Payment Temporary Table.
FAISMGRRCTLDSTNSLDS TEACH Payment Temporary Table
FAISMGRRCTRECRFinaid Temporary SRBRECR Table
FAISMGRRCTROUTFinaid Temporary SRRROUT Table
FAISMGRRCTRSRCTemporary Recruiting Source Table
FAISMGRRCTXMLDTemporary XML Document Table.
FAISMGRREBDRCTEDE Directory Table
FAISMGRREBDSOADetail Statement of Account Table
FAISMGRREBORIGFederal Grant Origination Table
FAISMGRREBPAYVPell Origination Table
FAISMGRREBRDRQGrant Data Request Table.
FAISMGRREBRMRRGrant Multiple Reporting Record Table.
FAISMGRREBSSOASummary Statement of Account Table
FAISMGRREBTCHOTEACH Grant Origination Table
FAISMGRREBYTDDGrant Year to Date Detail Disbursement Record Table.
FAISMGRREBYTDOGrant Year to Date Detail Origination Record Table.
FAISMGRREBYTDSGrant Year to Date Summary Table
BANINST1REGFILE 
FAISMGRRERCODDCOD Document Control Table
FAISMGRRERRECNGrant COD Reconciliation Table.
FAISMGRRERSTIDCOD Identifier Table
PAYROLLRETIRE_CVT 
FAISMGRRFRASCHFund Award Schedule Rules Table
FAISMGRRFRASPCFund Aid Year Specific Data
FAISMGRRFRBASEFund Base Data Table
FAISMGRRFRBCMPFund / Budget Component Table
FAISMGRRFRCOMMFund Comments
FAISMGRRFRDEFADefault Fund Award Schedule Rules Table
FAISMGRRFRDEFDDefault Fund Disbursement Schedule Rules Table
FAISMGRRFRDETCFund / Detail Code Rules Table
FAISMGRRFRDLCKFund Disbursement Lock Table
FAISMGRRFRDSCHFund Disbursement Schedule Rules Table
FAISMGRRFRFCHGThis table is used to maintain changes to tables associated with the AR_FINAID_FUND composite view for incremental refresh processing in the ODS.
FAISMGRRFRFFIDFederal Fund Id Table
FAISMGRRFRMESGFund / Message Assignment Rules Table
FAISMGRRFRPROMPromissory Note Requirement Table
FAISMGRRFRSTCDState Fund Code Table
FAISMGRRFRTREQFund / Requirements Assignment Rules Table
FAISMGRRFTASPCTemporary Fund Aid Year Specific Data
FAISMGRRHBDFLTTranscript Default Table
FAISMGRRHBTINFInstitution Transcript Information Table
FAISMGRRHBTRNSPrior Institution Transcript Base Table
FAISMGRRHRAWRDPrior Institution Transcript Award Table
FAISMGRRHRCOMMApplicants Comments
FAISMGRRHRFUNDTranscript Rules Table
FAISMGRRHRLOANPrior Institution Transcript Loan Table
FAISMGRRHRPCMTPrior Institution Transcript Comment Table
FAISMGRRHRPCOLPrior Institution Transcript Prior College Table
FAISMGRRHRRQSTTranscript Request Table
FAISMGRRHRTCMTTranscript Comment Table
FAISMGRRJBJOBTJob Title Table
FAISMGRRJBPLBDPlacement Base Data Table
FAISMGRRJBSEDRStudent Employment Default Rules Table
FAISMGRRJRPAYLPayroll Load Rules Table
FAISMGRRJRPLRLPlacement Rules Table
FAISMGRRJRSEARStudent Employment Authorization Table
FAISMGRRJRSERFStudent Employment Referral Table
FAISMGRRJRSEWHStudent Employment Work History Table
FAISMGRRLRAPP1Financial Aid Application Log Table - Part 1
FAISMGRRLRAPP2Financial Aid Application Log Table - Part 2
FAISMGRRLRAPP3Financial Aid Application Log Table - Part 3
FAISMGRRLRAPP4Financial Aid Application Log Table - Part 4
FAISMGRRLRIMP1Logging Additional CSS PROFILE Data 
FAISMGRRLRLDS1Applicant NSLDS Log Table Part 1
FAISMGRRLRLDS2Applicant NSLDS Log Table Part 2
FAISMGRRLRLDS3Applicant NSLDS Log Table Part 3
FAISMGRRLRLDS4Applicant NSLDS Logging Table Part 1
FAISMGRRLRLDS5Applicant NSLDS LOG Table Part 2
FAISMGRRLRLDS6Applicant NSLDS Log Table Part 3
FAISMGRRLRLDS7NSLDS Pell Payment Repeating Table
FAISMGRRLRLDS8NSLDS Name History Logging Table
FAISMGRRLRLDSANSLDS ACG Payment Logging Table.
FAISMGRRLRLDSSNSLDS SMART Payment Logging Table.
FAISMGRRLRLDSTNSLDS TEACH Payment Logging Table.
FAISMGRRLROVRDLogging override field
FAISMGRRLRSTATApplicant Status Log Table
FAISMGRRNRACMTFinancial Aid Application Comments 
FAISMGRRNRGLBLINAS Global Policy Options Table
FAISMGRRNROCMTFinancial Aid Application Override Comments 
FAISMGRRNROVRDApplicant Need Analysis Override Table
FAISMGRRNRTMNTNSLDS Transfer Monitoring Process Table
FAISMGRRNRVRFYNeeds Analysis Verification Table
FAISMGRROALOGDArchive Data Log Activity Detail Table
FAISMGRROALOGMArchive Data Log Activity Master Table
FAISMGRROBALOGAudit Log Table
FAISMGRROBEXTRReport Extract Base Table
FAISMGRROBFSAPFISAP report interim processing table. Records created during and deleted after execution of FISAP report.
FAISMGRROBINSTFinancial Aid Institution Table
FAISMGRROBLOGCLogging Control Base Table
FAISMGRROBNYUDApplicant Non Year User-Defined Data Table
FAISMGRROBUSDFApplicant User-Defined Data Table
FAISMGRRORACHGThis table is used to maintain changes to tables associated with the AR_FINAID_APPLICANT_STATUS composite view for incremental refresh processing in the ODS.
FAISMGRRORAPELPell Grant Alternate Schedule Table.
FAISMGRRORATNDFinancial Aid Enrollment Attending Hours Table
FAISMGRRORAUDTAudit Grading Mode Table
FAISMGRRORCAMPFinancial Aid Campus Table
FAISMGRRORCLVECourse Level Exclusion Table
FAISMGRRORCMPLSelection Identifier Compiled Statements
FAISMGRRORCODICOD Entity ID Rules Table.
FAISMGRRORCOLSAll Financial Aid columns Table
FAISMGRRORCRHRCredit Hours Table
FAISMGRRORDATAData Dictionary Table
FAISMGRRORDSUPSupplemental Log Data
FAISMGRRORDVALAudit Log Form/Data Code Table
FAISMGRRORECHGThis table is used to maintain changes to tables associated with the AR_FINAID_ENROLLMENT composite view for incremental refresh processing in the ODS.
FAISMGRRORELTFE-Mail Letter Format Rules Table
FAISMGRRORELTRE-Mail Letter Rules Table
FAISMGRRORENRLFinancial Aid Enrollment Table
FAISMGRRORGDATGroup Selection Rules Base Table
FAISMGRRORGSQLGenerated SQL Selection Identifier Table
FAISMGRRORHOLDApplicant Holds Table
FAISMGRRORHSDTApplicant High School and Admission Data Table
FAISMGRRORINIDFinancial Aid College Codes Table
FAISMGRRORLEXMLocal Exit Mapping Table
FAISMGRRORLOGCLogging Control Repeating Table
FAISMGRRORLOGDData Log Activity Detail Table
FAISMGRRORLOGMData Log Activity Master Table
FAISMGRRORMESGFinancial Aid Messages
FAISMGRRORMVALMiscellaneous Validation Rules Table
FAISMGRRORNCHGThis table is used to maintain changes to tables associated with the AR_APPLICANT_NEED composite view for incremental refresh processing in the ODS.
FAISMGRRORNYVDNon Year User-Defined Variables Description Table
FAISMGRRORPELLPELL Grant Payment Schedule Table
FAISMGRRORPOSTBatch Posting Rules Table
FAISMGRRORSAPRSatisfactory Academic Progress Rules Table
FAISMGRRORSCHGThis table is used to maintain changes to tables associated with the AR_SATISFACTORY_ACAD_PROGRESS composite view for incremental refresh processing in the ODS.
FAISMGRRORSECTCourse Sections Unavailable for Aid Table
FAISMGRRORSLOGAudit Log Supplemental Data Table
FAISMGRRORSTATApplicant Status Table
FAISMGRRORSTRFSAP Translation Rules Table
FAISMGRRORSYMBLetter Generation Variable Table
FAISMGRRORTPRDAid Period/Term Code Table
FAISMGRRORUCHGThis table is used to maintain changes to tables associated with the AR_USER_DEFINED_FIELDS composite view for incremental refresh processing in the ODS.
FAISMGRRORUSERUser-Defined Variables Description Table
FAISMGRRORVIEWView Selection Table
FAISMGRRORWBQAWeb Question Answers Rules Table
FAISMGRRORWEBAWeb Accept Tracking Rules Table
FAISMGRRORWEBQWeb Questions Rules Table
FAISMGRRORWEBRWeb Rules Table
FAISMGRRORWKSTCampus/Verification Worksheet Table
FAISMGRRORWSQLWeb Text SQL Rules Table
FAISMGRRORWTABWeb Tab Rules Table
FAISMGRRORWTXTWeb Text Rules Table
FAISMGRRORWVARWeb Variable Table
FAISMGRROTADDRFinaid Temporary SPRADDR Table
FAISMGRROTEMALTemporary E-Mail Address Table
FAISMGRROTENRLTemporary FISAP Enrollment Table
FAISMGRROTFSAPTemporary Table for FISAP
FAISMGRROTIDENFinaid Temporary SPRIDEN Table
FAISMGRROTPERSFinaid Temporary SPBPERS Table
FAISMGRROTSAPRTemporary Satisfactory Academic Progress Rules Table
FAISMGRROTSTATTemp.  Applicant Status Table
FAISMGRROTSTTSPackaging Simulation Applicant Status Table
FAISMGRROTWFAEWeb for Executives - Financial Aid Extract.
FAISMGRRPBLNDALenders and Disbursing Agents Base Table
FAISMGRRPBLNDRLender Base Data Table
FAISMGRRPBLOPTLoan Options Table
FAISMGRRPBLPRDLoan Period Base Data Table
FAISMGRRPBOPTSPackaging Options Table
FAISMGRRPBSTABShort-Term Credit Account Base Table
FAISMGRRPRADSBApplicant Award Disbursement Table
FAISMGRRPRARSCApplicant Resource Table
FAISMGRRPRASTCApplicant Short-Term Credit Comments
FAISMGRRPRASTDApplicant Short-Term Credit Table
FAISMGRRPRATRMApplicant Award by Term Table
FAISMGRRPRAUTHFinancial Aid Authorization Table
FAISMGRRPRAWRDApplicant Award Table
FAISMGRRPRBAKOBackout Award Table
FAISMGRRPRCASHDirect Lending Cash Detail 
FAISMGRRPRCIPCSMART Grant Qualified Course Code Table
FAISMGRRPRCLSSClass Code Translation Table
FAISMGRRPRCLVLCampus Undergraduate Level Code Rules Table
FAISMGRRPRCNCLAward Cancellation Process Table
FAISMGRRPRCOLRPackaging Collector Table
FAISMGRRPRCONTThird Party Contract Rules Table
FAISMGRRPRDATEEnrollment Options by Term Table
FAISMGRRPRDCHGThis table is used to maintain changes to tables associated with the AR_AWARD_DISBURSEMENT composite view for incremental refresh processing in the ODS.
FAISMGRRPRDEFEDefault Equity Packaging Rules Table
FAISMGRRPRDEFGDefault Gap Packaging Rules Table
FAISMGRRPRDEFSDefault Self-Help Packaging Rules Table
FAISMGRRPRDEGRFinancial Aid Degree Rules
FAISMGRRPRDLASDirect Loan Account Statement Table
FAISMGRRPRDSASDirect Lending School Account Statement Summary Record
FAISMGRRPREFTDEFT Disbursement Table
FAISMGRRPREPMTElectronic Payment Receipt 
FAISMGRRPREXPTExemption Rules Table
FAISMGRRPRFCHGThis table is used to maintain changes to tables associated with the AR_AWARD_BY_FUND composite view for incremental refresh processing in the ODS.
FAISMGRRPRFEDRFederal Rules Table
FAISMGRRPRFSRCMaximum Amount Per Fund Source
FAISMGRRPRFUNDPackaging Fund Total Table
FAISMGRRPRGEQYPackaging Group Equity Packaging Rules Table
FAISMGRRPRGFNDPackaging Group/Fund Rules Table
FAISMGRRPRGGAPPackaging Group Gap Packaging Rules Table
FAISMGRRPRGSHPPackaging Group Self-Help Packaging Rules Table
FAISMGRRPRINFOSelf-Service Student Supplied Information Table
FAISMGRRPRLADBLoan Disbursement Schedule
FAISMGRRPRLAPPLoan Application Table
FAISMGRRPRLARFLoan Application Reference Table
FAISMGRRPRLATRLoan Term Schedule Rules Table
FAISMGRRPRLCHGThis table is used to maintain changes to tables associated with the AR_LOAN_APPLICATION composite view for incremental refresh processing in the ODS.
FAISMGRRPRLCRTLoan Certification Table
FAISMGRRPRLDSBLoan Period / Disbursement Schedule Rules Table
FAISMGRRPRLECSElectronic Counseling Table
FAISMGRRPRLNDPLender Participation Table
FAISMGRRPRLPAPLoan Period / Aid Period Rules Table
FAISMGRRPRLTRMLoan Period / Term Schedule Rules Table
FAISMGRRPRMAJRFinancial Aid Major Rules Table
FAISMGRRPRPCHGThis table is used to maintain changes to tables associated with the AR_AWARD_BY_PERSON composite view for incremental refresh processing in the ODS.
FAISMGRRPRRECNDirect Lending Cash Reconciliation Summary 
FAISMGRRPRRFNDDirect Loan Refund Table
FAISMGRRPRRSLTDisbursement Message Table
FAISMGRRPRSADSDL Statement of Account Disbursement Summary.
FAISMGRRPRSAHPACG Rigorous High School Program Code Table.
FAISMGRRPRSLNDStudent Lender History Table
FAISMGRRPRSTACShort-Term Credit Account Comments
FAISMGRRPRTATSTEACH Grant Agreement to Serve Table
FAISMGRRPRTIIVReturn of Title IV Funds Table
FAISMGRRPRVRSTOnline Validation Results Table
FAISMGRRPTAWRDTemporary Applicant Award Table
FAISMGRRPTCONTTemporary Recruiting Contact Table
FAISMGRRRRAREQApplicant Requirements Table
FAISMGRRRRGREQTracking Group/Requirements Rules Table
FAISMGRRRRRCHGThis table is used to maintain changes to tables associated with the AR_TRACKING_REQUIREMENT composite view for incremental refresh processing in the ODS.
FAISMGRRRRTMSGTracking Requirement Message Rules Table
FAISMGRRTVAPRDAid Period Validation Table
FAISMGRRTVARSCFinancial Aid Resource Codes
FAISMGRRTVAUSTEmployment Authorization Status Validation Table
FAISMGRRTVAWSTAward Status Validation Table
FAISMGRRTVBGRPBudget Group Validation Table
FAISMGRRTVBTYPBudget Type Validation Table
FAISMGRRTVCCOMComment Category Code Validation Table
FAISMGRRTVCDNTCOD Nation Code Rules Table
FAISMGRRTVCDSTCOD State Code Rules Table
FAISMGRRTVCINTCertification Initials Validation Table
FAISMGRRTVCOMPBudget Component Validation Table
FAISMGRRTVDLBTBatch Type Validation Table defines the batch types that are available in Direct Lending, one type for each kind of record sent to or received by the servicer.
FAISMGRRTVELTME-Mail Letter Module Validation Table
FAISMGRRTVFSRCFund Source Validation Table
FAISMGRRTVFTYPFund Type Validation Table
FAISMGRRTVHOLDFinancial Aid Hold Type Validation Table
FAISMGRRTVICMTISIR Comment Code Text Validation Table
FAISMGRRTVINFCSource Code Validation Table
FAISMGRRTVLNSTLoan Status Validation Table
FAISMGRRTVMESGMessage Validation Table
FAISMGRRTVPGRPPackaging Group Validation Table
FAISMGRRTVPHASCommonLine Loan Application Phase Code Validation Table
FAISMGRRTVPRCDProgram Code validation table for NSLDS
FAISMGRRTVPTYPBatch Posting Type Validation Table
FAISMGRRTVRFSTReferral Status Validation Table
FAISMGRRTVRJCTReject Validation Table
FAISMGRRTVRPSRRepayment Source Validation Table
FAISMGRRTVSAPRSatisfactory Academic Progress Validation Table
FAISMGRRTVTGRPTracking Group Validation Table
FAISMGRRTVTREQTracking Requirements Validation Table
FAISMGRRTVTRSTTracking Requirements Status Validation Table
FAISMGRRTVUSERThis table is no longer used by Banner. It has been replaced by the RORUSER table.
FAISMGRRTVWEBQWeb Questions Validation Table
FAISMGRRTVWTXTWeb Text Rule Code Validation Table
FAISMGRRTVWVARWeb Variable Validation Table
FAISMGRRTVYICDYear in College Description Table
FAISMGRRURVERSFinancial Aid Version Tracking Table
BOSSREPORTRW_SERVER_JOB_QUEUE 
FAISMGRRZBTELSTELS -TSAC Roster Data Table.
FAISMGRRZBTSAATSAA -TSAC Roster Data Table.
FAISMGRRZRENRLTELS Scholarship Enrollment Table
FAISMGRRZRFAFR 
FAISMGRRZRFASR 
FAISMGRRZRLNDRTable of recommended lenders for lender selection.
FAISMGRRZRLNNTContains notes (such as special benefits offered) on the recommended lenders.
FAISMGRRZRTNFTFund code - Grant Type Translation Table.
SATURNSABAUDFApplication User Defined Fields Table
SATURNSABBTCHAdmission Report Id Selection Table
SATURNSABECRLElectronic Admissions Control Table
SATURNSABECTMEDI Cross-Reference Term Code Rules
SATURNSABIDENPerson ID Control Table
SATURNSABNSTUElectronic Admissions Non-Student Table
SATURNSABSTUDElectronic Admissions Student Record Table
SATURNSABSUPLApplication Supplemental Information Base Table
SATURNSABVWIDAdmission Decision View Selection Table
SATURNSABXMITElectronic Admissions Transmission Header Table
SATURNSARAATTAdmissions Attribute Repeating Table.
SATURNSARACHGThis table is used to maintain changes to tables associated with the AS_ADMISSIONS_APPLICATION composite view for incremental refresh processing in the ODS.
SATURNSARACMTApplication Comments Repeating Table.
SATURNSARACTVElectronic Admissions Activities Table
SATURNSARADAPAdmissions Application Repeating Table
SATURNSARADDRElectronic Admissions Address Table.
SATURNSARADHSAdmissions Decision High School Rule Table
SATURNSARADRTSelective Admissions Calculated Decision Rating Type Rule Table
SATURNSARADTSAdmissions Decision Test Score Rule Table
SATURNSARAMCCAMCAS Error Collector Table
SATURNSARAPPDStudent Application Decision Repeating Table
SATURNSARASTAElectronic Admissions Application Status Table
SATURNSARCHKBAdmission Request Checklist Build Table
SATURNSARCHKLAdmissions Checklist Repeating Table
SATURNSARCHRTCohort Admissions Table
SATURNSARCTRLElectronic Admissions Load Control Table
SATURNSARDCSNAdmissions Decision Rule Table
SATURNSARDFOSElectronic Admissions Date - Field of Study Table
SATURNSARDNTEElectronic Admissions Prior College Degree Note Table
SATURNSARDSCLSelective Admissions Collector Table for Batch Decision Posting
SATURNSAREFOSElectronic Admissions Date - Field of Study Table
SATURNSAREMPLElectronic Admissions Employment Table
SATURNSARERULElectronic Admissions Application Rules Table.
SATURNSARETRYElectronic Admissions Entry-Exit Dates Table
SATURNSAREVALElectronic Admissions Letters of Recommendations Evaluation Table
SATURNSARHCRSElectronic Admissions Academic Session Courses Table
SATURNSARHEADElectronic Admissions Application Header Table
SATURNSARHLTHElectronic Admissions Health Conditions Table
SATURNSARHSCHElectronic Admissions Academic Status Table
SATURNSARHSESElectronic Admissions Academic Status Sessions Table
SATURNSARHSUMElectronic Admissions Degree Summary Information Table
SATURNSARIMMZElectronic Admissions Immunizations
SATURNSARLANGElectronic Admissions Language Use
SATURNSARLCOMElectronic Admissions Lettersof Recommendations Table
SATURNSARLMSGElectronic Admissions Letters of Recommendation Messages Table
SATURNSARLRECElectronic Admissions Letters of Recommendation Table
SATURNSARLXMSLine Number Transaction Set Table
SATURNSARLXNOLine Number Transaction Set Table
SATURNSARMATLData area to store electronic applicants requested materials.
SATURNSARMONYElectronic Admissions Monetary Amount Table
SATURNSARORTNAdmissions Orientation information table for Voice Response.
SATURNSARPCHGThis table is used to maintain changes to tables associated with the AS_PRE_STUDENT composite view for incremental refresh processing in the ODS.
SATURNSARPCOLElectronic Admissions Previous College Information Table
SATURNSARPCRSElectronic Admissions Academic Session Courses Table
SATURNSARPDEGElectronic Admissions Prior College Degree Table
SATURNSARPERRElectronic Admissions Results Table
SATURNSARPERSElectronic Admissions Person Table
SATURNSARPHONElectronic Admissions Phone Table
SATURNSARPRACTemporary Race table.
SATURNSARPRFNElectronic Admissions Person Related Reference Table
SATURNSARPRTNElectronic Admissions Routine Control Table
SATURNSARPSESElectronic Admissions Prior College Sessions Table
SATURNSARPSTAElectronic Admissions Person Status Table
SATURNSARQKERQuick Entry Rules Repeating Table
SATURNSARQUANData area to store questions and answers to applicant during admissions process.
SATURNSARRESDElectronic Admissions Residence Information Table
SATURNSARRFNOElectronic Admissions Reference Numbers Table
SATURNSARRLGNElectronic Admissions Religions Table
SATURNSARRLSTElectronic Admissions Results Control Table
SATURNSARRQSTElectronic Admissions Request for Information Table
SATURNSARRRATSelective Admissions Student Application Rating
SATURNSARRRCTSelective Admissions Rating Type Rule Form by Term
SATURNSARRRDFThis table contains the components that define the Admissions Rating Formula. The formula will be comprised of the following components: left parenthesis, right parenthesis, Admissions Rating Factor Codes and mathematical operators. This formula will be
extracted from the database, evaluated and executed in SARRATE, the Admissions Rating Process.
SATURNSARRRFTThis table contains Rating Factor Rules and Rating Factor Value definitions. The available values for specifying rules include term, level, campus, college, program, admit type, student type, residency and major.  Institutions
can enter any combination of values to tailor the rating factors to meet their needs.  The value of a Rating Factor can be a static value or can be a key value that will be used in the generation of dynamic SQL to retrieve a factor value from the databas
e.
SATURNSARRRRTSelective Admissions Rating Type Rules by Term and Administrator
SATURNSARRSRCSource of Application Repeating Table.
SATURNSARTERMTelephone Admissions Term Table controls the terms and timeframes that telephone admissions is available for callers.
SATURNSARTESTElectronic Admissions Test Scores Table
SATURNSARWAADCalendar controls for data entry of standard applicants on the admissions web pages.
SATURNSARWADFDefault data and rules for Web Admissions Application.
SATURNSARWADPRules to control pull down list values for specific Web Admissions Application.
SATURNSARWALTEntries for Signature Page Letters for Web Applications.
SATURNSARWAPCRepeating table of Application Type codes associated with a curriculum major used in Web Quick Start! application processing.
SATURNSARWAPFData element configuration controls for placement of elements on Admissions web pages.
SATURNSARWAPPWeb Application Section Rules Table
SATURNSARWATDCalendar controls for displaying electronic applicants on the admissions web pages.
SATURNSARWATRCalendar controls for data entry of electronic applicants on the admissions web pages.
SATURNSARWSCTWWW Application Section Table
SATURNSARWUDQWeb User Defined Questions Table
SATURNSCBCDEPCollege/Department Table
SATURNSCBCDTLCourse catalog description narrative text by college and department table
SATURNSCBCRKYCourse Catalog Base Table
SATURNSCBCRSECourse General Information Base Table
SATURNSCBDESCCourse Catalog Description Narrative Text Table
SATURNSCBSUPPSupplemental Course Data Table
SATURNSCRACHGThis table is used to maintain changes to tables associated with the AS_COURSE_CATALOG composite view for incremental refresh processing in the ODS.
SATURNSCRATTRCourse Attribute Repeating Table
SATURNSCRCCHGThis table is used to maintain changes to tables associated with the AS_COURSE_CATALOG composite view for incremental refresh processing in the ODS.
SATURNSCRCDTXCollege/Department Text Table
SATURNSCRCORQCourse Corequisites Repeating Table
SATURNSCRCPRTPartition Codes define campus zones, which are catagories or groupings of rooms.  This table contains course partition codes in the catalog module.
SATURNSCRCRDFRoom definition/attribute Codes for catalog entries. This describes characteristics of rooms required for the scheduling tool.
SATURNSCREQIVEquivalent Course Repeating Table
SATURNSCRFEESCourse Fees Repeating Table
SATURNSCRGMODCourse Grading Modes Repeating Table
SATURNSCRINTGIntegration Partners for Courses.
SATURNSCRLEVLCourse Level Repeating Table
SATURNSCRRARECourse Area Restriction Table.
SATURNSCRRCAMCatalog Campus Restriction Table
SATURNSCRRCLSCourse Class Restriction Repeating Table
SATURNSCRRCMPCourse Campus Restriction Repeating Table
SATURNSCRRCOLCourse College Restriction Repeating Table
SATURNSCRRDEGCourse Degree Restriction Table.
SATURNSCRRLVLCourse Level Restriction Repeating Table
SATURNSCRRMAJCourse Major Restriction Repeating Table
SATURNSCRRPRGCourse Program Restriction Table.
SATURNSCRRTRMCourse Term Restriction Repeating Table
SATURNSCRRTSTThe course test score restriction and course pre-requisites table
SATURNSCRSBGISource background institution agreements table
SATURNSCRSCHDCourse Schedule Type Repeating Table
SATURNSCRSECTSchedule History Table
SATURNSCRSPRTPartition Codes define campus zones, which are catagories or groupings of rooms.  This table contains subject partition codes in the catalog module.
SATURNSCRSRDFRoom definition/attribute Codes for catalog subject entries. This describes characteristics of rooms required for the scheduling tool.
SATURNSCRSYLNCourse Syllabus course long name table
SATURNSCRSYLOCourse Syllabus course learning objective table
SATURNSCRSYRMCourse Syllabus course required materials table
SATURNSCRSYTRCourse Syllabus course technical requirements table
SATURNSCRTEXTCourse Descriptive Text Repeating Table
SATURNSDBCMARCompliance Area Requirements Table
SATURNSDBCMGRCompliance General Requirements Table
SATURNSDBCMPLCompliance Base Information Table
SATURNSDBCMRCCompliance Request Collector File
SATURNSDBDEGRDdgree Audit Degree Definition Table
SATURNSDBDPGRDegree Program General Requirements Table
SATURNSDBPROGProgram Code Maintenance Table
SATURNSDBSMUCStudent Degree Program Multiple Use Course Table
SATURNSDBSSARStudent Specific Area Requirements Table
SATURNSDRACTXDegree Program General Requirements Comments Table
SATURNSDRCCNUCompliance Courses Not Used Repeating Table
SATURNSDRCMATAttribute General Requirements Compliance Repeating Table
SATURNSDRCMCRCompliance Cluster Requirements Table
SATURNSDRCMSRCompliance Course Requirements Satisfied Repeating Table
SATURNSDRCNCRCompliance Non-Course Requirements Repeating Table
SATURNSDRCOLRDegree Audit Collector Table
SATURNSDRDCMTStudent Degree Program Comments Table
SATURNSDRDPARDegree Program Area Requirements Repeating Table
SATURNSDRDPATAttribute General Requirements Repeating Table
SATURNSDRDPCRDegree Program Cluster Requirements Repeating Table
SATURNSDRDPNCDegree Program Non-Course Requirements Repeating Table
SATURNSDRDPPRDegree Program Group Requirements Repeating Table
SATURNSDRDPSRDegree Program Course Requirements Repeating Table
SATURNSDRMCTXDegree Program General Requirement Comments Table
SATURNSDRNCTXDegree Program Non-course Requirements Comments Table
SATURNSDRPCNCProgram Code Area Of Concentration Repeating Table
SATURNSDRPCTXDegree Program Area Requirements Comments Table
SATURNSDRPMJRProgram Code Major Repeating Table
SATURNSDRPMNRProgram Code Minor Repeating Table
SATURNSDRSAWVStudent Degree Program Area Waivers Repeating Table
SATURNSDRSCADStudent Degree Program Course Additions Table
SATURNSDRSCAJStudent Degree Program Course Adjustments Repeating Table
SATURNSDRSCSBStudent Degree Program Course Substitutions Repeating Table
SATURNSDRSCWVStudent Degree Program Course Waivers Repeating Table
SATURNSDRSMURStudent Degree Program Multiple Use Requirement Repeating Table
SATURNSDRSNCAStudent Degree Non-Course Requirements Approval Repeating Table
SATURNSDRSSCRStudent Specific Cluster Requirements Table
SATURNSDRSSGRStudent Specific Group Requirements Table
SATURNSDRSSSRStudent Specific Course Requirements Repeating Table
SATURNSERDTGLStudent service group assignments
SATURNSERDTNDStudent service need assignments
SATURNSERDTSRStudent service group assignments
SATURNSERGLATStudent service goal attribute assignments
SATURNSERGLCMStudent service goal comment assignments
SATURNSERGOALService group code goal code rules table
SATURNSERNDATStudent service need attribute assignments
SATURNSERNDCMStudent service need comment assignments
SATURNSERNEEDService group code Need code rules table
SATURNSERSRATStudent service service attribute assignments
SATURNSERSRCMStudent service need comment assignments
SATURNSERSSERService group code service code rules table
SATURNSERSSGPStudent service group assignments
SATURNSETATNDTemporary table to hold attendance detail data for FTES
SATURNSFBCREQCourse Request Transaction Table
SATURNSFBESTSStudent Registration Status Table
SATURNSFBETRMStudent Registration Table
SATURNSFBPIPERegistration DBMS PIPE Identifier Table
SATURNSFBRESTCourse Request Restriction Table
SATURNSFBRFSTStudent Refund Percentage Table
SATURNSFBRGRPStudent Registration Group Code Table
SATURNSFBSECTCourse Request Section Table
SATURNSFBWCTLStudent Registration Group Table
SATURNSFRAFEERegistration Additional Fees Repeating Table
SATURNSFRAREGOpen Learning Additional Registration Information table
SATURNSFRATWTStudent Registration Audit Trail Work Table.
SATURNSFRBTCHBatch Fee Assessment Collector Table
SATURNSFRCBRQCollector File Used For Recursive Schedule Printing
SATURNSFRCOLRFee Assessment View Collector Table
SATURNSFRCTRLVoice Response Registration Management Control Table for limiting student accesss to telephone registration.
SATURNSFREFEEStudent Registration Additional Fees Repeating Table
SATURNSFRENPOPayment options for enrollment verification requests made through the self service.
SATURNSFRENRLEnrollment Verification Request
SATURNSFRENSSProcessing options for enrollment verification requests made thru the self service.
SATURNSFREPRTEnrollment Verification Request Type Table
SATURNSFRFAUDRegistration Fee Assessment Audit Table.
SATURNSFRFMAXRegistration Fees Maximum Table
SATURNSFRFREQCourse Request Final Request Transaction Table
SATURNSFRMESGEnrollment Verification Message Table
SATURNSFRMHRSRegistration Maximum Hours Table
SATURNSFRRACLRegistration Access Control table
SATURNSFRREGDRegistration Drop-Delete Collector Table For Registration Fee Assessment.
SATURNSFRRFCRCourse Refund Percentage Table
SATURNSFRRFNDRefund Control Table
SATURNSFRRGFERegistration Fees Table
SATURNSFRROVRStudent Registration permit-override Rules table
SATURNSFRRSTSRegistration Status Table By Term
SATURNSFRSRPOStudent Registration permit-override applied table
SATURNSFRSTCAStudent Course Registration Archive Table.
SATURNSFRSTCRStudent Course Registration Repeating Table
SATURNSFRTCTLNational Student Loan Clearinghouse Data Extract Process Control Table.
SATURNSFRTERMTelephone Registration Term Table controls the terms and timeframes that telephone registration is available for callers.
SATURNSFRTHSTStudent Enrollment Time Status History Table.
SATURNSFRTIMETime Conflict Temporary Work Table
SATURNSFRTMSLFull/Part Time Status Level Code Table
SATURNSFRTMSTFull/Part Time Status Rules Code Table
SATURNSFRWCTLStudent Registration Priority Table
SATURNSFRWDRLStudent Withdrawal Table
SATURNSFTAREARegistration Area Pre-requisite assignment temporary table.
SATURNSFTFEESTemporary table to hold course information for use in fee assessment processing during a user session.
SATURNSFTREGSTemporary registration table, used as a workpad during the registration process.
SATURNSFTRGAMTemporary table for holding administrative messages during registration processing.
SATURNSGBEOPSEducation Opportunity Programs and Services Base Table
SATURNSGBOEDUStudent Other Educational Programs Table
SATURNSGBSTDNStudent Base Table
SATURNSGBUSERStudent Institutional Reporting Requirements Table
SATURNSGRACHGThis table is used to maintain changes to tables associated with the AS_ACADEMIC_STUDY composite view for incremental refresh processing in the ODS.
SATURNSGRACMTAssistantship/Fellowship/Internship comment table.
SATURNSGRADVRMultiple Advisors Repeating Table
SATURNSGRASSIAssistantship/Fellowship/Internship information table.
SATURNSGRASSTAssistantship/Fellowship/Internship task/duties table.
SATURNSGRCATTClass Attribute Repeating Table.
SATURNSGRCCHGThis table is used to maintain changes to tables associated with the student classification tables for incremental refresh processing in the ODS.
SATURNSGRCHRTStudent Cohort Table.
SATURNSGRCHRT_TEMP 
SATURNSGRCLSRStudent Classification Table
SATURNSGRCMNTGeneral Student Sport Comments Table
SATURNSGRCOLRStudent Right to Know Detail Reporting Table
SATURNSGRCOOPCooperative Education Repeating Table
SATURNSGRDISAStudent Disability Services Table
SATURNSGRDSERStudent Disability Service Support Table
SATURNSGRDUTYCooperative Education Duties Repeating Table
SATURNSGRESELEligibility Factor table
SATURNSGRPCHGThis table is used to maintain changes to tables associated with the AS_STUDENT composite view for incremental refresh processing in the ODS.
SATURNSGRSACTStudent Activity Repeating Table
SATURNSGRSATTStudent Attribute Repeating Table.
SATURNSGRSCHGThis table is used to maintain changes to tables associated with the AS_STUDENT composite view for incremental refresh processing in the ODS.
SATURNSGRSCMTStudent Comment Table
SATURNSGRSPRTSport Table
SATURNSGRVETNVeteran Repeating Table
SATURNSHBCATTCermony Attendance Information Table
SATURNSHBCGPACampus GPA Processing Base Table
SATURNSHBCOMICommittee Information Table
SATURNSHBCRMYCermony Information Table
SATURNSHBDIPLDiploma Information Table
SATURNSHBGCTLGradable Components Control.
SATURNSHBGEDIEDI Grade Qualifier Rules Table. This table is used by EDI to classify courses based upon the term taught, the course level, and the course grading mode. The resulting code will be sent with the electronic transcript.
SATURNSHBGRADGraduation Default Control Table
SATURNSHBGRULGrade Rule Definition Table.
SATURNSHBGSCHGrade Scale Header.
SATURNSHBHEADEDI Master Header Table
SATURNSHBOGSCInstitution GPA Selection Code Table: Contains the selection code for selecting the students gpa term. Valid values are F(irst), L(ast) and C(urrent rules). 
SATURNSHBRPTRRepeat/Equivalent Course Rules Table
SATURNSHBRPTSThis is the Base Course Repeat Processing Parameter Table.
SATURNSHBRTYPRule Type definition table
SATURNSHBTATCTransfer Institution Transfer Catalog Data
SATURNSHBWTRRWeb Transcript Request Rules Table.
SATURNSHRACHGThis table is used to maintain changes to tables associated with the AS_ADMISSIONS_APPLICATION composite view for incremental refresh processing in the ODS.
SATURNSHRASDLDeans List Calculation Rules Table
SATURNSHRASESEDI Academic Session Table.
SATURNSHRASGEDeans List Grade Code Excluded Table
SATURNSHRASTRAcademic Status Rules Table
SATURNSHRASUMEDI Academic Overall Summary Table.
SATURNSHRATTCHistory Course Section Attribute Table per CRN.
SATURNSHRATTRHistory Course Section Attribute Table
SATURNSHRAUDEAcademic Record UDE for Import of XML Transcript
SATURNSHRCAPPGown Size Attendee Table
SATURNSHRCASTRules for Combined Academic Standing calculation.  Various fields qualify the record for use against a particular student, and based on progress evaluation code and academic standing, a new combined academic standing code is assigned.
SATURNSHRCATTCeremony Attendance Comment Table
SATURNSHRCCHGThis table is used to maintain changes to tables associated with the AS_STUDENT_COURSE composite view for incremental refresh processing in the ODS.
SATURNSHRCCMTCeremony Comment Table
SATURNSHRCGDRThe Campus Grade point Average Rules Table contains the rules for rounding or truncating and number of digits to display for the campus.  
SATURNSHRCGPACalculate of GPA required Request Table
SATURNSHRCHRTCohort Academic History Table
SATURNSHRCMRKGrade Component Composite .
SATURNSHRCOMCCommittee Comments Table
SATURNSHRCOMMCommittee Information Table
SATURNSHRCRSREDI Course Record Table
SATURNSHRDCHGThis table is used to maintain changes to tables associated with the AS_ACADEMIC_OUTCOME composite view for incremental refresh processing in the ODS.
SATURNSHRDCMTDiploma Comment Table
SATURNSHRDGCMDegree Comment Table
SATURNSHRDGDHDepartmental Honors By Degree Repeating Table
SATURNSHRDGIHInstitutional Honors By Degree Repeating Table
SATURNSHRDGMRDegree Table
SATURNSHRDRTMEDI Date-Range to Termcode Crosswalk
SATURNSHREDISEDI Status Table
SATURNSHREGPATransfer Institution Transfer GPA Repeating Table
SATURNSHREPTDExport PESC XML Transcript Document Status Table
SATURNSHREVNTAcademic History Events Repeating Table
SATURNSHRGCHGThis table is used to maintain changes to tables associated with the AS_GPA composite view for incremental refresh processing in the ODS.
SATURNSHRGCOLGrade Mailer Collector Table
SATURNSHRGCOMGrade Component Rule .
SATURNSHRGOWNGown Size Attendee Table
SATURNSHRGPACCampus GPA Table by Term and Level
SATURNSHRGPALGPA Level Table by Campus
SATURNSHRGRDEGrading Code Maintenance Table
SATURNSHRGRDOValid Grading Modes Maintenance Table
SATURNSHRGRDSGrading Code Substitution Table
SATURNSHRGRSCGrade Component Detail.
SATURNSHRGRULGrade Rule Parameter Values Definition Table.
SATURNSHRHDR4EDI Document Header Table
SATURNSHRICIPTemporary IPEDS table used for ICIP
SATURNSHRICMTTransfer Articulation Institution Course Comment
SATURNSHRIDENEDI Identification Table
SATURNSHRIMMUImmunization Code Repeating Temporary Table
SATURNSHRINSTHistory Section Instructors Repeating Table
SATURNSHRIPDSIPEDS Data Collection Table
SATURNSHRIPEDIPED temporary work table
SATURNSHRIPTDImport PESC XML Transcript Document Status Table
SATURNSHRLCHGThis table is used to maintain changes to tables associated with the AS_GPA composite view for incremental refresh processing in the ODS.
SATURNSHRLGDRThe Level Grade point Average Rules Table contains the rules for rounding or truncating and number of digits to display for the level.  
SATURNSHRLGPALevel GPA Table
SATURNSHRLGSCContains the selection code for selecting the students gpa term, by level. Valid values are F(irst), L(ast) and C(urrent rules). 
SATURNSHRMEDIImmunization Data from PESC XML Transcript
SATURNSHRMRKAGrade Component Student Audit Record
SATURNSHRMRKSGrade Component Student Record
SATURNSHRNCRDStudent Non-Course Requirements Applying Degree Repeating Table
SATURNSHRNCRSStudent  Non-Course Requirements  Repeating Table
SATURNSHROGDRThe Institution Grade point Average Rules Table contains the rules for rounding or truncating and number of digits to display for the institution.  
SATURNSHRPREVRules for Progress Evaluaton.  Various fields qualify the record for use against a particular student, and based on previous progress evaluation code and other values in the record, a new progress evaluation code is assigned.
SATURNSHRPRGEProgress Evaluation Excluded Grades table, indicates which grade(s) will be excluded from Progress evaluation comparisons.  Any courses with these grades will not be counted nor used in the percentage calculation.
SATURNSHRQPNDQualifying Paper Comments Repeating Record
SATURNSHRQPNMQualifying Paper Name Repeating Table
SATURNSHRRDEFCermony Accomodation Attributes Table
SATURNSHRRPARRule Type Parameters table.
SATURNSHRRPEQTemporary Student Course Table
SATURNSHRSCOMGrade Component Definition Table.
SATURNSHRSMRKGrade Sub-Component Student Record
SATURNSHRSRKAGrade Sub-Component Student Audit Record
SATURNSHRSSUMEDI Academic Session Summary Table
SATURNSHRSTSCSubtest Score Data from PESC XML Transcript
SATURNSHRSTSTSubtest Score Data from PESC XML Transcript
SATURNSHRSUDEStudent UDE for Import of XML Transcript
SATURNSHRSUMAEDI Academic Overall Summary Table.
SATURNSHRSUMSEDI Academic Session Summary Table
SATURNSHRTATCTransfer Institution Transfer Catalog Equivalent Data
SATURNSHRTATTHistory Transfer Course Section Attribute Table
SATURNSHRTCKDInstitutional Course Term Degree Applied Repeating Table
SATURNSHRTCKGInstitutional Courses Grade Repeating Table
SATURNSHRTCKLInstitutional Course Maintenance Level Applied Repeating Table
SATURNSHRTCKNInstitutional Course Term Maintenance Repeating Table
SATURNSHRTCMTTransfer Articulation Transfer Course Comment
SATURNSHRTESTTest Score Data from PESC XML Transcript
SATURNSHRTGPATerm GPA Table
SATURNSHRTGRDTransfer Institution Transfer Grade Table
SATURNSHRTMCMTranscript Comments by Level or Matriculation Repeating Table
SATURNSHRTPRTTranscript Rules Request Type Table
SATURNSHRTRAMAttendance Period by Transfer Institution Repeating Table
SATURNSHRTRATTransfer Articulation Course Attribute Repeating Table
SATURNSHRTRCDTransfer Course Degree Applied Repeating Table
SATURNSHRTRCETransfer Course Equivalent Repeating Table
SATURNSHRTRCRTransfer Course Detail Repeating Table
SATURNSHRTREPRepeat Processing Temporary Table
SATURNSHRTRITTransfer Institution Repeating Record
SATURNSHRTRNMTranscript type name hierarchy definition. All transcripts printed for this type will use the name hierarchy defined in this table.  If no name is found for any of the name sources defined for the hierarchy, the person's current name from the SPRIDEN ta
ble is used.  The name type code is enterable only if the name source type has that indicator set to a Y value.
SATURNSHRTRNSRules for transcript name sources that can be printed on the transcript.
SATURNSHRTRPOWeb Transcript Request Payment Options Table.
SATURNSHRTRSSWeb Transcript Request Self Services Table.
SATURNSHRTRTATransfer Articulation Course Attribute Repeating Table
SATURNSHRTRTKTransfer Institution Transfer Course Taken Repeating Table
SATURNSHRTTCMTranscript Comments by Term Repeating Table
SATURNSHRTTRMInstitutional Course Maintenance Term Header Repeating Table
SATURNSHRTUDECollege Transcript UDE for Import of XML Transcript
SATURNSHTIACTTemporary table used by program shriact.pc.
SATURNSHTTRANTranscript Request Temporary Table
SATURNSHTTRNMThe name hierarchy is entered for an individual if it is different from what is defined for the transcript type.  This hierarchy is used before the one coded for the transcript type.  If no name is found for any of the name sources defined for this hiera
rchy, the hierarchy defined for the transcript type is used.  The name type code is enterable only if the name source type has that indicator set to a Y value.
SATURNSHTTRTCTranscript Selection Table
SATURNSIBCFTEFaculty Workload Contract FTE Rule Table
SATURNSIBFACDFaculty Information Table
SATURNSIBFACD_TMPFaculty Information Table
SATURNSIBINSTFaculty Member Base Table
SATURNSIBTERMFaculty load FTE and calculation fators rules Base Table
SATURNSIRASGNFaculty Member Instructional Assignment  Repeating Table
SATURNSIRATTRFaculty Attribute Information  Repeating Table
SATURNSIRCMNTFaculty Comment Information Repeating Table
SATURNSIRCOLCFaculty Member Collector Table
SATURNSIRCOLRFaculty Load Collector Repeating Table
SATURNSIRDPCLFaculty Member Department and College Information Repeating Table
SATURNSIRFCHGThis table is used to maintain changes to tables associated with the AS_FACULTY composite view for incremental refresh processing in the ODS.
SATURNSIRFCNTFaculty Contract Rule Information Repeating Table
SATURNSIRFLCTFaculty Member Contract Term Rule Table
SATURNSIRFLRCFaculty Member Workload Contract Rule Table
SATURNSIRFLRTFaculty Member Workload Term Rule Table
SATURNSIRICNTFaculty Contract Type Repeating Table
SATURNSIRLVASFaculty Leave Assignment Table
SATURNSIRNISTFaculty Member Non-instructional Assignment  Repeating Table
SATURNSIRNLVAFaculty Leave Non-Instructional Assignment Table
SATURNSIROFFCThis table permits the display and maintenance of an instructor's office hours.
SATURNSLBBLDGLocation/Building Description Table
SATURNSLBEVNTEvent Base Table
SATURNSLBRDEFRoom Description Table
SATURNSLBRMAPRoom and Meal Application Table
SATURNSLBRMPFRoommate Preference Request Table
SATURNSLBTERMLocation Management Term Control Table
SATURNSLRASCDRoom Status Table By Term
SATURNSLRBCATRoom Catagory Definition Table
SATURNSLRBCMTBuilding Comments Table
SATURNSLRBDEFBuilding Attributes Definition Table
SATURNSLRCMNTBuilding/Room Comments Table
SATURNSLRCOLCRoom Attributes Collector Table
SATURNSLRCOLRLocation Management Assessment View Collector Table
SATURNSLRDCOLDorm Room Attributes Collector Table
SATURNSLRECMTEvents Comments Table
SATURNSLRLMFEHousing/Meal/Phone Rate Code Rules Table
SATURNSLRMASGMeal Assignment Table
SATURNSLRMCHGThis table is used to maintain changes to tables associated with the AS_MEAL_ASSIGNMENT composite view for incremental refresh processing in the ODS.
SATURNSLRMFCRMeal Refund Percentage Table
SATURNSLRMSCDMeal Status Table By Term
SATURNSLRPASGPhone Assignment Table
SATURNSLRPCHGThis table is used to maintain changes to tables associated with the AS_PHONE_ASSIGNMENT composite view for incremental refresh processing in the ODS.
SATURNSLRPFCRPhone Refund Percentage Table
SATURNSLRPREQHousing Special Requirements Table
SATURNSLRPSCDPhone Status Table By Term
SATURNSLRRASGRoom Assignment Table
SATURNSLRRCHGThis table is used to maintain changes to tables associated with the AS_ROOM_ASSIGNMENT composite view for incremental refresh processing in the ODS.
SATURNSLRRDEFRoom Attributes Definition Table
SATURNSLRRFCRHousing Refund Percentage Table
SATURNSLRRMATRoommate Application Request Table
SATURNSLRRMDFRoommate Attributes Definition Table
SATURNSLRRUSERoom Usage Restriction Table
SATURNSLRTASGTemporary Room Assignment Table
SATURNSLTFTRNLocation Management Fee Assessment Transactions
SATURNSMBAGENGeneral Area Requirements Table
SATURNSMBAGRLArea Group Attachment Rule Base Table
SATURNSMBAOGNGeneral Area Overall Results Table
SATURNSMBARULArea Restricted Subject/Course Attachment Rule Base Table
SATURNSMBATRKArea Adjustment Tracking Table
SATURNSMBDFLTTable containing Compliance Default Parameter values to be used in the creation of SMRRQCM records.
SATURNSMBDRRQDetail Area/Group Rule Base Table
SATURNSMBGGENGeneral Group Requirements Table
SATURNSMBGOGNGeneral Group Overall Results Table
SATURNSMBGRRQArea Group Attachment Results for Rule Base Table
SATURNSMBGRULGroup Restricted Subject/Course Attachment Rule Base Table
SATURNSMBGTRKGroup Adjustment Tracking Table
SATURNSMBPGENGeneral Program Requirements Table
SATURNSMBPOGNGeneral Program Overall Results Table
SATURNSMBPTRKProgram Adjustment Tracking Table
SATURNSMBPVPRProgram Variable Area Priority Table
SATURNSMBSAGNStudent Adjustment General Area Requirements Table
SATURNSMBSAGRStudent Adjustment Area Group Attachment Rule Base Table
SATURNSMBSARUStudent Adjustment Area Restricted Subject/Course Attachment Rule Base Table
SATURNSMBSGGNStudent Adjustment General Group Requirements Table
SATURNSMBSGRUStudent Adjustment Group Restricted Subject/Course Attachment Rule Base Table
SATURNSMBSLIBStudent Adjustment Library Table.
SATURNSMBSOTKOther Adjustment Tracking Table
SATURNSMBSPGNStudent Adjustment General Program Requirements Table
SATURNSMBWCRLWebCAPP Rules Table
SATURNSMRACAAArea Course/Attribute Attachment Table
SATURNSMRACCMArea Attached Course Comment Table
SATURNSMRACLVArea Attached Course Additional Levels Allowed Table
SATURNSMRACMTArea Requirements Comment Table
SATURNSMRAEXLArea Course/Attribute Exclusion Table
SATURNSMRAGAMArea Group Attachment and Management Table
SATURNSMRAGRLArea Group Attachment Rule Repeating Table
SATURNSMRAGRTArea Group Attachment Rule Comment Table
SATURNSMRALIBArea Library Table
SATURNSMRALVLAdditional Area Levels Allowed Table
SATURNSMRAOGDArea Restricted Grade Results Table
SATURNSMRAOLVArea Additional Level Results Table
SATURNSMRAOSAArea Restricted Subject/Attribute Results Table
SATURNSMRAOSTArea Group Attachment Results by Set Table
SATURNSMRAQUAArea Library Qualifiers Table
SATURNSMRARCMArea Rule Attached Course Comment Table
SATURNSMRAREXArea Rule Course/Attribute Exclusion Table
SATURNSMRARGCArea Restricted Grade Comment Table
SATURNSMRARGDArea Restricted Grade Code Table
SATURNSMRARLTArea Course Attachment Rule Comment Table
SATURNSMRARLVArea Rule Attached Course Additional Levels Allowed Table
SATURNSMRARSAArea Restricted Subjects/Attributes Table
SATURNSMRARSCArea Restricted Subject Attribute Comments Table
SATURNSMRARULArea Subject/Course Attachment Rule Repeating Table
SATURNSMRATRKArea Adjustment Tracking Comment Table
SATURNSMRAUSEArea Used by this Program Collector Table
SATURNSMRCOLRBatch Compliance Collector Control Table
SATURNSMRCORQCompliance Process Records
SATURNSMRCPRTCompliance Print Type Rules Table
SATURNSMRDOANDetail Attributes Not Used by Program Table.
SATURNSMRDOCNDetail Courses Not Used by Program Table
SATURNSMRDOEXDetail Area/Group Exclusions Table
SATURNSMRDOLVDetail Area/Group Additional Level Results Table
SATURNSMRDORJDetail Course/Attribute Rejected by an Area/Group
SATURNSMRDORQDetail Area/Group Requirements Table
SATURNSMRDOSTArea/Group Detail Attachment Results by Set Table
SATURNSMRDOUSDetail Course/Attribute Used by Program Table
SATURNSMRDREXDetail Area/Group Exclusions for Rule Table
SATURNSMRDRLVDetail Area/Group Additional Level for Rule Results Table
SATURNSMRDRRQDetail Area/Group Rule Requirements Table
SATURNSMRGCAAGroup Course/Attribute Attachment Table
SATURNSMRGCCMGroup Attached Course Comment Table
SATURNSMRGCLVGroup Attached Course Additional Levels Allowed Table
SATURNSMRGCMTGroup Requirement Comments Table
SATURNSMRGEXLGroup Course/Attribute Exclusion Table
SATURNSMRGLIBGroup Library Table
SATURNSMRGLVLAdditional Group Levels Allowed Table
SATURNSMRGOATGroup Attachment Output Table
SATURNSMRGOGDGroup Restricted Grade Results Table
SATURNSMRGOLVGroup Additional Level Results Table
SATURNSMRGOSAGroup Restricted Subject/Attribute Results Table
SATURNSMRGRCMGroup Rule Attached Course Comment Table
SATURNSMRGREXGroup Rule Course/Attribute Exclusion Table
SATURNSMRGRGCGroup Restricted Grade Comment Table
SATURNSMRGRGDGroup Restricted Grade Code Table
SATURNSMRGRLTGroup Course Attachment Rule Comment Table
SATURNSMRGRLVGroup Rule Attached Course Additional Levels Allowed Table
SATURNSMRGRRQArea Group Attachment Results for Detail Rules Table
SATURNSMRGRSAGroup Restricted Subjects/Attributes Table
SATURNSMRGRSCGroup Restricted Subject Attribute Comments Table
SATURNSMRGRULGroup Subject/Course Attachment Rule Repeating Table
SATURNSMRGTRKGroup Adjustment Tracking Comment Table
SATURNSMRGUSEGroup Used by this Area Collector Table
SATURNSMRIEATArea Include/Exclude for Attribute Code table.
SATURNSMRIECCArea Include/Exclude for Concentration Code.
SATURNSMRIECOArea Include/Exclude for College Code table.
SATURNSMRIECPArea Include/Exclude for Campus Code table.
SATURNSMRIEDGArea Include/exclude for Degree Code.
SATURNSMRIEDPArea Include/Exclude for Department Code table.
SATURNSMRIEMJArea Include/exclude for Major Code.
SATURNSMRIEMNArea Include/Exclude for Minor Code table.
SATURNSMRPAAPProgram Area Attachment and Priority Table
SATURNSMRPATRProgram Attribute Requirements Table
SATURNSMRPCMTProgram Text Table
SATURNSMRPCRSCompliance Request Planned Course Table.
SATURNSMRPLVLAdditional Program Levels Allowed Table
SATURNSMRPNCRProgram Non-Course Requirements Table
SATURNSMRPOANArea Not Used by a Program.
SATURNSMRPOATProgram Attribute Results Table
SATURNSMRPOGDProgram Restricted Grade Results Table
SATURNSMRPOLVProgram Additional Level Results Table
SATURNSMRPONCProgram Non-course Results Table
SATURNSMRPOSAProgram Restricted Subject/Attribute Results Table
SATURNSMRPRGCProgram Restricted Grade Comment Table
SATURNSMRPRGDProgram Restricted Grade Code Table
SATURNSMRPRLEProgram Rules Table
SATURNSMRPRRQCompliance Request Output Print Table.
SATURNSMRPRSAProgram Restricted Subjects/Attributes Table
SATURNSMRPRSCProgram Restricted Subject Attribute Comment Table
SATURNSMRPTRKProgram Adjustment Tracking Comment Table
SATURNSMRRQCMCompliance Request Management Table.
SATURNSMRSACAStudent Adjustment Area Course/Attribute Attachment Table
SATURNSMRSACESudent Adjustment Area Course/Attribute Exclusion Table
SATURNSMRSACLStudent Adjustment Area Attached Course Additional Levels Allowed Table
SATURNSMRSACM Student Adjustment Area Requirements Comment Table
SATURNSMRSACTStudent Adjustment Area Attached Course Comment Table
SATURNSMRSAGCStudent Adjustment Area Restricted Grade Comment Table
SATURNSMRSAGDStudent Adjustment Area Group Attachment Rule Comment Table
SATURNSMRSAGMStudent Adjustment Area Group Attachment and Management Table
SATURNSMRSAGRStudent Adjustment Area Group Attachment Rule Repeating Table
SATURNSMRSALVStudent Adjustment Additional Area Levels Allowed Table
SATURNSMRSAPVValid Program for Area Student Adjustments Table
SATURNSMRSARCStudent Adjustment Area Restricted Subject Attribute Comments Table
SATURNSMRSARDStudent Adjustment Area Course Attachment Rule Comment Table
SATURNSMRSAREStudent Adjustment Area Rule Course/Attribute Exclusion Table
SATURNSMRSARGStudent Adjustment Area Restricted Grade Code Table
SATURNSMRSARLStudent Adjustment Area Rule Attached Course Additional Levels Allowed Table
SATURNSMRSARSStudent Adjustment Area Restricted Subjects/Attributes Table
SATURNSMRSARTStudent Adjustment Area Rule Attached Course Comment Table
SATURNSMRSARUStudent Adjustment Area Subject/Course Attachment Rule Repeating Table
SATURNSMRSGAVValid Area for Group Student Adjustments Table
SATURNSMRSGCAStudent Adjustment Group Course/Attribute Attachment Table
SATURNSMRSGCEStudent Adjustment Group Course/Attribute Exclusion Table
SATURNSMRSGCLGroup Attached Course Additional Levels Allowed Table
SATURNSMRSGCMStudent Adjustment Group Requirement Comments Table
SATURNSMRSGCTStudent Adjustment Group Attached Course Comment Table
SATURNSMRSGGCStudent Adjustment Group Restricted Grade Comment Table
SATURNSMRSGLVStudent Adjustment Additional Group Levels Allowed Table
SATURNSMRSGRCStudent Adjustment Group Restricted Subject Attribute Comments Table
SATURNSMRSGRDStudent Adjustment Group Course Attachment Rule Comment Table
SATURNSMRSGREStudent Adjustment Group Rule Course/Attribute Exclusion Table
SATURNSMRSGRGStudent Adjustment Group Restricted Grade Code Table
SATURNSMRSGRLStudent Adjustment Group Rule Attached Course Additional Levels Allowed Table
SATURNSMRSGRSStudent Adjustment Group Restricted Subjects/Attributes Table
SATURNSMRSGRTStudent Adjustment Group Rule Attached Course Comment Table
SATURNSMRSGRUStudent Adjustment Group Subject/Course Attachment Rule Repeating Table
SATURNSMRSOTKOther Adjustment Tracking Comment Table
SATURNSMRSPAPStudent Adjustment Program Area Attachment and Priority Table
SATURNSMRSPATStudent Adjustment Program Attribute Requirements Table
SATURNSMRSPCMStudent Adjustment Program Text Table
SATURNSMRSPGCStudent Adjustment Program Restricted Grade Comment Table
SATURNSMRSPLVAdditional Student Adjustment Program Levels Allowed Table
SATURNSMRSPNCStudent Adjustment Program Non-Course Requirements Table
SATURNSMRSPRCStudent Adjustment Program Restricted Subject Attribute Comment Table
SATURNSMRSPRGStudent Adjustment Program Restricted Grade Code Table
SATURNSMRSPRSStudent Adjustment Program Restricted Subjects/Attributes Table
SATURNSMRSSPVValid Program for Student Adjusment Substitution Table
SATURNSMRSSUBStudent Adjustment Substitution Table.
SATURNSMRSTPVValid Program for Student adjustment Targets Table
SATURNSMRSTRGStudent Adjustment Targeting Table.
SATURNSMRSWAVStudent Adjustment Waiver Table.
SATURNSMRSWPVValid Program for Student Adjustment Waivers Table
SATURNSMTASELCompliance Dynamic Area Selection Temporary Table
SATURNSMTCRSETemporary table to hold student course list during compliance processing
SATURNSMTCUSECompliance Course Used Temporary Table
SATURNSMTPRRQTemporary Compliance Request Output Print Table.
SATURNSMTRUSECourse Status Before Use in Rule Temporary Table
SATURNSMTSPATCompliance Split Course Attribute Temporary Table
SATURNSMTSPLTCompliance Split Courses Temporary Table
SATURNSMTSTRGStudent Adjustment Targets Temporary Table
SATURNSOBCACTStudent curriculum activity status rules table.
SATURNSOBCALDCollege Calendar Day Information Table
SATURNSOBCNVTTape Code Conversion Base Table
SATURNSOBCPLNCommunication Plan Assignment Base Table
SATURNSOBCTRLCurriculum Rules Control Table.
SATURNSOBCURRCurriculum Base Rules.
SATURNSOBLMODLearner modules rules table
SATURNSOBMATLMaterial Base Table
SATURNSOBODTEOpen Learning Registration Date Default table
SATURNSOBPROFCampus Security Table
SATURNSOBPTRMSection Part-of-Term Validation Table
SATURNSOBROLERole assignment table.
SATURNSOBSBGASource/Background Access Table for PESC XML Transcript
SATURNSOBSBGISource/Background Institution Base Table
SATURNSOBSEQNSequence Number Base Table
SATURNSOBTEQUTest Score Equivalency Table. This table contains institution-defined test score equivalency data by effective term. An actual test code, actual test score and an actual test source will be used at the time of data loading to determine and load the equiv
alent test code and equivalent test score. The effective term and source used in the lookup will be the term and source specified in the data load process.
SATURNSOBTERMTerm Base Table
SATURNSORADASSelective Admissions Administrative Assignment Rules Definition
SATURNSORADDASelective Admissions Administrative Assignment Rules
SATURNSORAINFSelective Admissions Administrator Assignment
SATURNSORAPPTAppointments Repeating Table.
SATURNSORAROLSelective Admissions Administrator Roles
SATURNSORATRMWeb Admissions Terms.
SATURNSORBACDSource/Background Institution Academic Repeating Table
SATURNSORBCHRSource/Background Institution Characteristics Repeating Table
SATURNSORBCMTSource/Background Institution Comments Repeating Table
SATURNSORBCNTSource/Background Institution Contact Person Repeating Table
SATURNSORBDEGSource/Background Institution Degrees Offered Repeating Table
SATURNSORBDMOSource/Background Institution Demographics Repeating Table
SATURNSORBDPLSource/Background Institution Diplomas Offered Repeating Table
SATURNSORBETHSource/Background Institution Ethnic Make-up Repeating Table
SATURNSORBTACTransfer Articulation Comment Table
SATURNSORBTAGTransfer Articulation General Data
SATURNSORBTAITransfer Articulation Institution Accreditation
SATURNSORBTALTransfer Articulation Levels
SATURNSORBTAPTransfer Articulation Program Accreditation
SATURNSORBTSTSource/Backround Institution Test Score Repeating Table
SATURNSORCCOLCommunication Plan Collector Table
SATURNSORCCONConcentration Curriculum Rules.
SATURNSORCGRPCommunications Group Material Repeating Table
SATURNSORCMJRCurriculum Major Rules.
SATURNSORCMNRCurriculum Minor Rules.
SATURNSORCOMMCommunications Rules Repeating Table
SATURNSORCONCPrior college concentration area repeating table
SATURNSORCONTContact between Individual and Institution Repeating Table.
SATURNSORCRSSApplicant Course Summary Base Table
SATURNSORCSTSCurriculum Status Events table
SATURNSORCTRMContinuing Terms Repeating Table
SATURNSORDEGRPrior College Degree Table
SATURNSORDLIMTape file delimiter type rules table.
SATURNSORDPMRDuplicate Materials Rules Table.
SATURNSORELTLRules table for letters that can be consructed using the HTML letter process.
SATURNSORELTRRules table for letter format that will be consructed using the HTML letter process.
SATURNSOREPSCEnrollment Planning Service (EPS) Rules Table.
SATURNSOREQUI 
SATURNSOREXTNOpen Learning Registration Extension Processing Rules table
SATURNSORFADRFin.  Aid Data Reconciliation Table
SATURNSORFAPCFaculty/Advisor Process Control
SATURNSORFOLKParent Information Repeating Table
SATURNSORFRYRT2202A Federal Reporting Year Table
SATURNSORGEORGeographic Region Rules Table
SATURNSORGPATPerson GPA Types Table
SATURNSORHCURLearner curriculum archive table.
SATURNSORHFOSLearner curriculum field of study archive table.
SATURNSORHSBJPerson Related HS Subject Repeating Table
SATURNSORHSCHPerson Related High School Base Table
SATURNSORICHGThis table is used to maintain changes to tables associated with the AS_INSTITUTION composite view for incremental refresh processing in the ODS.
SATURNSORINFRInterface Rules Repeating Table
SATURNSORINTSOutside Interests Repeating Table.
SATURNSORLCDFUser Curriculum Default Data table
SATURNSORLCURLearner Curriculum repeating table to store level, college, program and other data associated with curriculum.
SATURNSORLFOSLearner curriculum field of study.
SATURNSORLMFSLearner module field of study rules table
SATURNSORMADMMaterial Admit Type Repeating Table
SATURNSORMAJRPrior college major repeating table
SATURNSORMAPDMaterial Admissions Decision Repeating Table
SATURNSORMAPSMaterial codes for application status code.
SATURNSORMATTMaterial Attribute Repeating Table
SATURNSORMCNTMaterial Contact Repeating Table
SATURNSORMCRLBase Curriculum Module Controls.
SATURNSORMCTZMaterial Citizenship Repeating Table
SATURNSORMDPTMaterial Department Repeating Table
SATURNSORMEPSMaterial codes for geographic regions and divisions defined for persons high school address.
SATURNSORMETHMaterial Ethnicity Repeating Table
SATURNSORMGEOMaterial codes for geographic regions and divisions defined for persons address or SBGI school address.
SATURNSORMINRPrior college minor repeating table
SATURNSORMINTMaterial Outside Interest Repeating Table
SATURNSORMLGYMaterial Legacy Code Repeating Table
SATURNSORMMJRMaterial Major Repeating Table
SATURNSORMRTYMaterial Recruit Type Repeating Table
SATURNSORMSEXMaterial Sex Repeating Table
SATURNSORMSRCMaterial codes for application/recruit source code.
SATURNSORMSTAMaterial State Repeating Table
SATURNSORMSTYMaterial Student Type Repeating Table
SATURNSORMTESMaterial Test Score Repeating Table
SATURNSORNAMEFirst Name Translation Rules Table.
SATURNSOROCHGThis table is used to maintain changes to tables associated with the AS_ORGANIZATION_ENTITY composite view for incremental refresh processing in the ODS.
SATURNSORPCOLPrior College Table
SATURNSORPLNGCommunications Plan Group Repeating Table
SATURNSORPLNMCommunications Plan Material Repeating Table
SATURNSORRFNDOpen Learning Registration Refunding Rules table
SATURNSORRSTSOpen Learning Registration Status Code Rules table
SATURNSORRTRMWeb registration dates tables
SATURNSORT22AT2202A Tax Credits Table
SATURNSORTBRKTerm Break Period Table
SATURNSORTESTStudent Test Score Repeating Table
SATURNSORTSPCTemporary Test Percentile Table.
SATURNSORWDSPTable to Cusomize Web Display of Validation Tables.
SATURNSORXREFCross-Reference Rules Table
SATURNSORXREF_TEMP 
SATURNSOTCMMEStudent Common Matching Match Entry Global Temporary Table 
SATURNSOTHSCHTemporary SORHSCH table
SATURNSOTINFRTemporary Interface Table
SATURNSOTINTSOutside Interests Repeating Table.
SATURNSOTLCURCurriculum Base Verification Global Temporary Table 
SATURNSOTLFOSField of Study Verification Global Temporary Table 
SATURNSOTPCOLTemporary SORPCOL Table
SATURNSOTPRNTTemporary table to store report information. Shared packages will insert information and C programs will select rows to generate reports. Initially created for Grade Roll processing (SHRROLL).
SATURNSOTTESTTemporary SORTEST Table
SATURNSOTVCURCurriculum Term Parameter Global Temporary Table 
SATURNSOTWADAWeb for Executives - Recruiting Admissions Contact Extract.
SATURNSOTWADEWeb for Executives - Recruiting Admissions Basic Extract.
SATURNSOTWENRWeb for Executives Student Enrollment Extract
SATURNSOTWGREWeb for Executives - Completion Extract.
SATURNSOTWREGWeb for Executives Course Registration Extract
SATURNSPBPERSBasic Person Base Table
SATURNSPRADDRAddress Repeating Table
SATURNSPRAPINStudent Alternate PIN Table
SATURNSPRCMNTPerson Comments Repeating Table
SATURNSPRCOLRPerson Collector Table
SATURNSPREMRGEmergency Contact Repeating Table
SATURNSPRHOLDPerson Related Holds Repeating Table
SATURNSPRIDENPerson Identification/Name Repeating Table
SATURNSPRINTLInternational Student Repeating Table
SATURNSPRMEDIPerson Medical Information Repeating Table
SATURNSPRPCHGThis table is used to maintain changes to tables associated with the AS_PERSON composite view for incremental refresh processing in the ODS.
SATURNSPRTELETelephone Table
SATURNSPTADDRTemporary SPRADDR Table
SATURNSPTIDENTemporary SPRIDEN Table
SATURNSPTPERSTemporary SPBPERS Table
SATURNSRBPREDDefault values for Web for Prospect Web pages.
SATURNSRBRECRRecruiting Base Table
SATURNSRBWPDSWeb Prospect Validation Code Display Section Rules Form.  This form determines which validation values from the validation tables will be displayed on specific Prospect Web pages.
SATURNSRBWPROWeb Prospect Section Rules Form, SRAWPRO that will be used by an institution to designate what pieces of data will be displayed on each different type of Prospect Code defined on STVWPRO.
SATURNSRRCHRTCohort Recruiting Table
SATURNSRRICHGThis table is used to maintain changes to tables associated with the AS_RECRUITMENT_INFORMATION composite view for incremental refresh processing in the ODS.
SATURNSRRLENDTable used to store how I learned of the institution code of Recruit.
SATURNSRRRATTRecruiting Attribute Repeating Table.
SATURNSRRRCMTRecruiting Comment Table
SATURNSRRRSRCSource of Recruit Repeating Table
SATURNSRRTPTSTape file test score control table.
SATURNSRRVISTRecuiters Visit to Source Repeating Table
SATURNSRRWACKWeb Prospect Acknowledgment Letter Ruels.
SATURNSRTADDRElectronic Prospect address loaded from search and test score tapes, or entered on Web for Prospects.
SATURNSRTCRSSTemporary Course Summary table.
SATURNSRTDEGRTemporary Degree table.
SATURNSRTEMALTable used to store email of Electronic Prospect before moving to Banner Production Table GUREMAL.
SATURNSRTGPATTemporary GPA Type table.
SATURNSRTHSCHHigh Schools loaded from Electronic Prospect sources.
SATURNSRTIDENElectronic Prospect person data loaded from search and test score tapes, or entered on Web for Prospects.
SATURNSRTINTLTable used to store international information of Electronic Prospect before migrating the prospect to Banner Production Tables.
SATURNSRTINTSTable used to store interests of Electronic Prospect before migrating the prospect to Banner Production Tables.
SATURNSRTLENDTable used to store how I learned of the institution code of Electronic Prospect before migrating the prospect to Banner Production Tables.
SATURNSRTMAJRTemporary Major table.
SATURNSRTMATLData area to store electronic prospect requested materials.
SATURNSRTPCOLElectronic Prospect prior college loaded from search and test score tapes, or entered on Web for Prospects.
SATURNSRTPERSElectronic Prospect biographic data loaded from search and test score tapes, or entered on Web for Prospects.
SATURNSRTPRACTemporary Race table.
SATURNSRTPRELElectronic Prospect source information table.
SATURNSRTRECRTemporary SRBRECR Table
SATURNSRTSUPLTemporary Supplemental Information table.
SATURNSRTTELEElectronic Prospect telephone numbers loaded from search and test score tapes, or entered on Web for Prospects.
SATURNSRTTESTElectronic Prospect test scores loaded from test score tapes and entered on Web for Prospects.
SATURNSRTTPFDRule Table to identify the position and length of data items on Electronic Prospect Tapes.
SATURNSRTTSPCTemporary Test Percentile Table.
SATURNSSBACRLCensus Information Base Table
SATURNSSBDESCSection Description Table
SATURNSSBDFEETuition Fee Assessment by Status
SATURNSSBFSECThis table provides the capability to set faculty self-service display controls by term and section.
SATURNSSBOVRRSchedule Override Table
SATURNSSBSECTSection General Information Base Table
SATURNSSBSSECThis table provides override capability by term and section for student self-service display controls.
SATURNSSBXLSTCross List Enrollment Information Base Table
SATURNSSRATTRDegree Program Attribute Repeating Table
SATURNSSRBLCKBlock Code Definition Repeating Table
SATURNSSRCORQSection Corequisite Repeating Table
SATURNSSRCTRLSchedule Control table containing processing and file definition parameters for scheduling tool interface.
SATURNSSREVALSection Evaluation Repeating Table
SATURNSSREXCLSchedule Exclusion Date Repeating Table
SATURNSSREXTNSection OLR Extension rules table
SATURNSSRFEESSection Fees Repeating Table
SATURNSSRLINKSection Link Course Repeating Table
SATURNSSRMEETSection Meeting Times Repeating Table
SATURNSSRMPRTPartition Codes define campus zones, which are catagories or groupings of rooms.  This table contains meeting partition codes in the schedule module.
SATURNSSRMRDFRoom Definition Codes define room attributes.  This table contains meeting room definition codes in the schedule module.
SATURNSSROCHGThis table is used to maintain changes to tables associated with the AS_COURSE_OFFERING composite view for incremental refresh processing in the ODS.
SATURNSSRRARESection Area Restriction Table.
SATURNSSRRCLSSection Class Restriction Repeating Table
SATURNSSRRCMPSection Campus Restriction Table
SATURNSSRRCOLSection College Restriction Repeating Table
SATURNSSRRDEGSection Degree Restriction Table.
SATURNSSRRESVSection Reserved Seat Repeating Table
SATURNSSRRFNDSection OLR Refunding Table
SATURNSSRRLVLSection Level Restriction Repeating Table
SATURNSSRRMAJSection Major Restriction Repeating Table
SATURNSSRRPRGSection Program Restriction Table.
SATURNSSRRSTSSection OLR Registration Status Code Table
SATURNSSRRTSTTest score restriction and course pre-requisites table
SATURNSSRSCCDCourse Section Contract Code Repeating Table
SATURNSSRSPRTPartition Codes define campus zones, which are catagories or groupings of rooms.  This table contains course partition codes in the schedule module.
SATURNSSRSRDFRoom definition/attribute Codes for schedule entries. This describes characteristics of rooms required for the scheduling tool.
SATURNSSRSYLNSection Syllabus Long Name table
SATURNSSRSYLOSection Syllabus Learning Objectives table
SATURNSSRSYRMSection Syllabus Required Materials table
SATURNSSRSYTRSection Syllabus Technical Requirements table
SATURNSSRTEXTSection Comments Repeating Table
SATURNSSRXLSTCross List Section Repeating Table
SATURNSSTSCHWSchedule Work table contains the class list and schedule information including building/room needed for a scheduling tool.
SATURNSTUVERSStudent Web Version Tracking Table
SATURNSTVACATAward Catagory Validation Table
SATURNSTVACCGActivity Category Validation Table
SATURNSTVACCLAcademic Calendar Type Validation Table
SATURNSTVACCTAttendance Accounting Method Code Validation Table
SATURNSTVACPRAccreditation Practice Validation Table
SATURNSTVACSTInstitutional Accreditation Status Validation Table
SATURNSTVACTCStudent Activity Validation Table
SATURNSTVACTNStudent Adjustment Action Code Validation Table
SATURNSTVACTPActivity Type Validation Table
SATURNSTVACYRAcademic Year Validation Table
SATURNSTVADDASelective Admissions Administrator Assignment Data Element table
SATURNSTVADMRAdmission Request Code Validation Table
SATURNSTVADMTAdmission Type Validation Table
SATURNSTVADVRAdvisor Type Validation Table
SATURNSTVAFCTAdmissions Rating Factor Code Validation Table.  This table contains valid values for Admissions Rating Factor Codes.  Factor codes are used in an institution-defined rating formula stored in table SARRRDF.  This formula is in turn used by the Rating Cal
culation Process, SARRATE.
SATURNSTVAFDCStudent Care AFDC Duration Validation Table.
SATURNSTVAPDCAdmission Application Decision Validation Table
SATURNSTVAPLSElectronic Admissions Application Source Validation Table
SATURNSTVAPRNApprenticeship Code Validation Table
SATURNSTVAPRVCatalog Approval Code Validation Table
SATURNSTVAPSTAdmission Application Status Validation Table
SATURNSTVAREADegree Requirements Distribution Area Validation Table
SATURNSTVARTPRoom/Meal Application Request Type Validation Table
SATURNSTVASCDRoom Assignment Status Code Validation Table
SATURNSTVASRCAddress Source Code Validation Table.
SATURNSTVASTAElectronic Admissions Status Codes Validation Table
SATURNSTVASTDAcademic Standing Validation Table
SATURNSTVASTYAssignment Type Validation Table
SATURNSTVATRAInstitution Defined Day Attribute One
SATURNSTVATRBInstitution Defined Day Attribute Two
SATURNSTVATRCInstitution Defined Day Attribute Three
SATURNSTVATRDInstitution Defined Day Attribute Four
SATURNSTVATREInstitution Defined Day Attribute Five
SATURNSTVATTRDegree Program Attribute Validation Table
SATURNSTVATTSStudent Attribute Validation Table
SATURNSTVATYPAddress Type Validation Table
SATURNSTVBCHRBackground Institution Characteristics Validation Table
SATURNSTVBLCKBlock Code Validation Table
SATURNSTVBLDGBuilding Code Validation Table
SATURNSTVBSKLBasic Skill ValidationTable
SATURNSTVCACTCurriculum Activity Status Code Validation Table
SATURNSTVCALDTransfer Articulation Calendar Type Table
SATURNSTVCAMPCampus Validation Table
SATURNSTVCAPLCareer Planning Validation Table
SATURNSTVCASTValid values for use in combined academic standing calculation.
SATURNSTVCCSLClassification Code Validation Table
SATURNSTVCERTGraduation Ceremony Type Validation Table
SATURNSTVCGRPCommunications Group Validation Table
SATURNSTVCHRTCohort Validation Table
SATURNSTVCIPCCIP Code Validation Table
SATURNSTVCITZCitizen Type Validation Table
SATURNSTVCKSRApplication Checklist Source
SATURNSTVCKSTApplication Checklist Source
SATURNSTVCLASClass Code Validation Table
SATURNSTVCMTTComment Type Validation Table
SATURNSTVCNTRContract Rules Code Validation Table
SATURNSTVCNTYCounty Code Validation Table
SATURNSTVCOLLCollege Validation Table
SATURNSTVCOMFCommittee Function Code Table
SATURNSTVCOMSCommittee Status Code Table
SATURNSTVCOMTCommittee Type Code Table
SATURNSTVCOPCCooperative Education Code Validation Table.
SATURNSTVCPLNCommunications Plan Validation Table
SATURNSTVCPRTCompliance Print Type Validation Table
SATURNSTVCREACohort Reason Validation Table
SATURNSTVCRSSCourse Summary Type Validation Table
SATURNSTVCSTACourse Status Code Validation Table
SATURNSTVCSTSStudent Curriculum Status Code Validation Table
SATURNSTVCTYPRecruiting Contact Code Validation Table
SATURNSTVCUDAInstitutional Reporting Element Validation Table
SATURNSTVCUDBInstitutional Reporting Element Validation Table
SATURNSTVCUDCInstitutional Reporting Element Validation Table
SATURNSTVCUDDInstitutional Reporting Element Validation Table
SATURNSTVCUDEInstitutional Reporting Element Validation Table
SATURNSTVCUDFCatalog Element Six Validation Table.
SATURNSTVDAYSDay of Week Validation Table
SATURNSTVDAYTDay Type Validation Table
SATURNSTVDEGCDegree Code Validation Table
SATURNSTVDEGSDegree Status Code Validation Table
SATURNSTVDEPSStudent Care Number of Dependents Validation Table.
SATURNSTVDEPTDepartment Validation Table
SATURNSTVDFLTValidation table for Default Compliance Parameters Codes to be used in creation of SMRRQCM compliance request records.
SATURNSTVDISADisability Type Validation Table
SATURNSTVDIVSDivision Code Validation Table
SATURNSTVDLEVFaculty Member Degree Level Validation Table
SATURNSTVDPLMDiploma Type Validation Table
SATURNSTVDPMRDuplicate Material Rule Code Table.
SATURNSTVDRESCeremony Dress Type Validation Table
SATURNSTVDSTSEDI Status Document Code Validation Table
SATURNSTVEAPLValidation entries for Personal and Application Status codes that are used for applications on Web Application Quick Start!.
SATURNSTVEDISElectronic Status Code Validation Table.
SATURNSTVEDLVEducation Level Validation Table
SATURNSTVEGOLEducation Goal Validation Table
SATURNSTVEGRPEDI Rule Group Validation Code Table
SATURNSTVELIGEligibility Validation Table
SATURNSTVELMTValidation entries for modules and corresponding views that are used for data source on HTML letters.
SATURNSTVEMEXEmployment Expectation Validation Table
SATURNSTVEMPLEmployer Validation Table
SATURNSTVEMPTEmployment Type Validation Table
SATURNSTVEOPSEducation Opportunity Programs and Services Validation Table
SATURNSTVEPRTEnrollment Verification Request Rules Code
SATURNSTVEPSCEnrollment Planning Service (EPS) Validation Table.
SATURNSTVESELEligibility Factor Validation Table
SATURNSTVESTSStudent Registration Status Validation Table
SATURNSTVETCTIPEDS Ethnic Validation Table
SATURNSTVETHNEthnic Code Validation Table
SATURNSTVETYPEvent Type Validation Table
SATURNSTVEVALInstructor Evaluation Question Table
SATURNSTVEVENAcademic History Events Code Validation Table
SATURNSTVEXAMCredit By Examination Code Validation Table
SATURNSTVFATTFaculty Member Attributes Code Validation Table
SATURNSTVFCNTFaculty Contract Code Validation Table
SATURNSTVFCSTFaculty Status Validation Table
SATURNSTVFCTGFaculty Category Validation Table
SATURNSTVFSTPFaculty Staff Type Validation Table
SATURNSTVFTYPFee Type Validation Table
SATURNSTVGAINGain Status Code Validation Table
SATURNSTVGATTStudent services goal attribute code table
SATURNSTVGCHGGrade Change Reason Validation Table
SATURNSTVGCMTGradebook coded comment validation table
SATURNSTVGEODGeographic Region Division Validation Table
SATURNSTVGEORGeographic Region Validation Table
SATURNSTVGMODGrading Mode Code Validation Table
SATURNSTVGOALStudent Goal Code Validation Table
SATURNSTVGPATGPA Type Validation Table
SATURNSTVGRSTGraduation Status Validation Table
SATURNSTVGSTAAssistantship/Fellowship/Internship Information Status Table
SATURNSTVGTYPAssistantship/Fellowship/Internship Type Table
SATURNSTVHAPSHousing Application Status Code Validation Table
SATURNSTVHLDDPerson Hold Type Validation Table
SATURNSTVHLWKHighest Level of Work Validation Table
SATURNSTVHONDDegree Honors Validation Code Table
SATURNSTVHONRAcademic History Institutional Honors Validation Table
SATURNSTVINCMIncome Range Validation Table
SATURNSTVINFCInterface Code Validation Table
SATURNSTVINITRecruiting Initials Code Validation Table
SATURNSTVINNMGraduation Institution Name Validation Table
SATURNSTVINTSOutside Interests Code Validation Table
SATURNSTVINTVInterview Code Validation Table
SATURNSTVLANGNative Language Validation Table
SATURNSTVLEADLeadership Validation Table
SATURNSTVLEAVLeave of Absence Validation Table
SATURNSTVLENDWeb Prospect codes that define how someone learned about the institution
SATURNSTVLEVLStudent Level Validation Table
SATURNSTVLGCYLegacy Code Validation Table
SATURNSTVLMODStudent learner module code validation table
SATURNSTVMAJRMajor, Minor, Concentration Validation Table
SATURNSTVMARSStudent Care Marital Status Validation Table.
SATURNSTVMATLRecruiting Material Code Validation Table
SATURNSTVMDEQMedical Equipment Code Validation Table
SATURNSTVMEASMeasurement Validation Table
SATURNSTVMEDIMedical Code Validation Table
SATURNSTVMEETMeeting Time Code Validation Table
SATURNSTVMRCDMeal Rate Code Validation Table
SATURNSTVMRTLMarital Status Validation Table
SATURNSTVMSCDMeal Status Code Validation Table
SATURNSTVNATNNation Validation Table
SATURNSTVNATTStudent services need attribute code table
SATURNSTVNCRQNon-Course Requirements Validation Table
SATURNSTVNCSTNon-Course Requirement Status Validation Table
SATURNSTVNDRFNeed Referral Validation Table
SATURNSTVNEEDStudent Needs Validation Table
SATURNSTVNISTFaculty Non-instructional Validation Table
SATURNSTVOCCSOccupational Course Indicator Table
SATURNSTVORIGOriginator Validation Table
SATURNSTVORSNOrientation Session Validation Table
SATURNSTVPENTPort of Entry Validation Table
SATURNSTVPRACPractical Training Validation Table
SATURNSTVPRCDPhone Rate Code Validation Table
SATURNSTVPRELElectronic Prospect Code Validation Table.
SATURNSTVPREVValid values for use in progress evaluation.
SATURNSTVPRGAProgram Accreditation Validation Table
SATURNSTVPRNTPrint Type Validation Table
SATURNSTVPROCProcess Control Validation
SATURNSTVPSCDPhone Status Code Validation Table
SATURNSTVPTRMPart-of-Term Validation Table
SATURNSTVPTYPPerson Type Validation Table
SATURNSTVPWAVPre-Requisite Waiver Code Validation Table
SATURNSTVQPTPQualifying Paper Type Code Validation Table
SATURNSTVRADMSelective Admissions Administrator Code Validation table
SATURNSTVRATEStudent Fee Assessment Rate Validation Table
SATURNSTVRATPSelective Admissions Rating Type Code Validation table
SATURNSTVRDEFBuilding/Room Attributes Validation Table
SATURNSTVREASRequirements Reason Validation Table
SATURNSTVRECRRecruiter Identification Validation Table
SATURNSTVRELGReligion Code Validation Table
SATURNSTVRELTRelationship Validation Table
SATURNSTVREPSRepeat Status Validation Table
SATURNSTVRESDResidency Validation Table
SATURNSTVRGRERegistration Reason Validation Table
SATURNSTVRMSTRoom Status Code Validation Table
SATURNSTVROLERule definition validation table
SATURNSTVROVRRegistration Permit-Override Rule Code Table
SATURNSTVRRCDRoom Rate Code Validation Table
SATURNSTVRSLTRecruiting Appointment Results Validation Table
SATURNSTVRSTARecruiting Status Code Validation Table
SATURNSTVRSTSCourse Registration Validation Status Table
SATURNSTVRTRMTerm Restriction Code Validation Table
SATURNSTVRTYPRecruit Type Validation Table
SATURNSTVSAPRSpecial Approval Validation Table
SATURNSTVSATTStudent services service attribute code table
SATURNSTVSBGISource/Background Inst Validation Table
SATURNSTVSBJCHigh School Subject Validation Table
SATURNSTVSCCDSchedule Contract Code Validation Table
SATURNSTVSCHDSchedule Type Code Validation Table
SATURNSTVSEPRStudent Services Provided Validation Table
SATURNSTVSESSSession Validation Table
SATURNSTVSFAEState Financial Eligibility Code Table
SATURNSTVSITESite Validation Table
SATURNSTVSIZESize Validation Table
SATURNSTVSOFFAssistantship/Fellowship/Internship Source of Funds Table
SATURNSTVSPONInternational Sponsor Validation Table
SATURNSTVSPRVStudent services provider code table
SATURNSTVSPSRDisability Service Code Validation Table
SATURNSTVSPSTSport Status Validation Table
SATURNSTVSSEPStudent Services Exemption Validation Table
SATURNSTVSSERStudent Services Code Validation Table
SATURNSTVSSGPStudent Service Group Validation Table
SATURNSTVSSRSStudent Services Result Validation Table
SATURNSTVSSSTStudent Services Status Validation Table
SATURNSTVSSTSSection Status Validation Table
SATURNSTVSTATState Code Validation Table
SATURNSTVSTSTStudent Status Code Validation Table
SATURNSTVSTYPStudent Type Validation Table
SATURNSTVSUBJSubject Validation Table
SATURNSTVSUDAInstitution Defined Reporting Element Validation Table
SATURNSTVSUDBInstitution Defined Reporting Element Validation Table
SATURNSTVSUDCInstitution Defined Reporting Element Validation Table
SATURNSTVSUDDInstitution Defined Reporting Element Validation Table
SATURNSTVSUDEInstitution Defined Reporting Element Validation Table
SATURNSTVSUDFInstitution Defined Reporting Element Validation Table
SATURNSTVSUDGInstitution Defined Reporting Element Validation Table
SATURNSTVSUDHInstitution Defined Reporting Element Validation Table
SATURNSTVSUDIInstitution Defined Reporting Element Validation Table
SATURNSTVSUDJInstitution Defined Reporting Element Validation Table
SATURNSTVTAAUTransfer Articulation Acceptance Authority Table
SATURNSTVTADMAdmissions Test Admin. Type Validation Table
SATURNSTVTAPEValidation for Electronic Prospect Tape Source.
SATURNSTVTASKAssistantship/Fellowship/Internship Task Table
SATURNSTVTASTTransfer Articulation Course Status
SATURNSTVTEACTest Accomodation Validation Table
SATURNSTVTEFRTest Form Validation Table
SATURNSTVTEINTest Instrument Validation Table
SATURNSTVTELETelephone Type Validation Table.
SATURNSTVTEPRTest Purpose Validation Table
SATURNSTVTERMTerm Code Validation Table
SATURNSTVTESCTest Score Validation Table
SATURNSTVTLVL 
SATURNSTVTLVL_OLDTransfer Institution Level Validation Table
SATURNSTVTMSTFull/Part Time Status Validation Table
SATURNSTVTOPSTaxonomy of Program Validation Table
SATURNSTVTOSTWeb Prospect Type of Study Validation table. Determines how someone plans to study courses at the institution
SATURNSTVTPFDValidation for Data Items on Electronic Prospect Tape.
SATURNSTVTPRTTranscript Verification Request Type Table
SATURNSTVTRACAcceptance Reason Validation Table
SATURNSTVTRCNTransfer Center Code Validation Table
SATURNSTVTREQStudent Time Requirement Validation Table
SATURNSTVTRMTTerm Type Validation Table
SATURNSTVTRNSSource of names that can be printed on the transcript.
SATURNSTVTSPTTest Score Percentile Types Table.
SATURNSTVTSRCAdmissions Test Score Source Validation Table
SATURNSTVTYPEType Validation Table
SATURNSTVVETCVeteran Type Code Validation Table
SATURNSTVVOEDVocational Education Code Validation Table
SATURNSTVVTABValidation Table for Customizing Web Display of Validation Tables.
SATURNSTVVTYPVisa Type Code Validation Table
SATURNSTVWACKWeb Prospect Acknowledgment Letter Code Validation
SATURNSTVWAIVValidation entries for application fee waiver reasons.  Waiver entered on Web Application and SAAADMS.
SATURNSTVWAPPWeb Admissions Application Type Validation Table.
SATURNSTVWDRLWithdrawal Status Validation Table
SATURNSTVWKLDWorkload Rules Code Validation Table
SATURNSTVWLTTValidation entries for modules and corresponding views that are used for data source on Web Application Customize Letter Types.
SATURNSTVWPICDetermines what information will be displayed on the Web for Prospect pages on each Prospect Code
SATURNSTVWPYOWeb Payment Options Validation Table.
SATURNSTVWRSNWithdrawal Reason Validation Table
SATURNSTVWSCFValidation entries for data elements that are on Admissions web pages.
SATURNSTVWSCTWeb  Application Section Validation Table.
SATURNSTVWSSOWeb Self Service Validation Table.
SATURNSTVWTHDStudent EOPS/Care Withdrawal Reason Validation Table.
SATURNSTVXLBLEDI Verification Label Validation Code Table.
SATURNSURVERSStudent Version Tracking Table
GENERALSWANUSERS 
SCTCVTSYRACAR 
APLOCALSYRAPIN_FC_LOG 
APLOCALSYRAPIN_MC_LOG 
APLOCALSYRMADMT 
APLOCALSYRMEOS 
APLOCALSYRR035 
APLOCALSYRR035_02042008 
APLOCALSYRR035_04162008 
APLOCALSYRR035_06182008 
APLOCALSYRRCTY 
APLOCALSYRRFFD 
APLOCALSYRRFFD_BEFOREDELETE 
APLOCALSYRRSCD 
APLOCALSYRXCNG 
APLOCALSYTDEGR 
APLOCALSYTR400 
SATURNSZBDCTL[MC] Academic Deficiency Rules Control Table
APLOCALSZBEARLEarly Alert Term Temp Table for SZREARL report
SATURNSZBICTL[MC] Immunization processing rules control table.
SATURNSZBITRK[MC] Student Immunization Tracking Registration Restriction Base Table
SATURNSZBRPTRRepeat Course Rule Base Table
SATURNSZBSTER 
APLOCALSZBSTER_PREV 
SATURNSZBTERM[MC] Customized Term Base Table
SATURNSZRADEF[MC] Student Academic Deficiency Repeating Table
SATURNSZRATNDStudent Class Roster Repeating Table
SATURNSZRCIPD[TBR-503] Cip Degree Repeating Table
SATURNSZRCMAX[MC] Course level maximum tuition charge control table.
SATURNSZRCRSETELS Transfer Course Equivalent Repeating Table
APLOCALSZREARLEarly Alert Student Repeating Table
APLOCALSZREARPEarly Alert Problem Table
APLOCALSZREARREarly Alert Recommendation Table
APLOCALSZREART 
SATURNSZRENRLRegents Online Degree Program and Continuing Education Log Table.
SATURNSZRIMMRImmunization Tracking Processing Rules
SATURNSZRIMMZ[MC] Immunization tracking rules table.
SATURNSZRITRK[MC] Student Immunization Tracking Information Repeating Table
SATURNSZRTELR[MC] TELS Scholarship Criterion Rules Table
SATURNSZRTGPATELS GPA Table
SATURNSZRTSTA[MC] TELS Scholarship Support Table
SATURNSZRTSTS[MC] TELS Scholarship Status Table. Temp table used by szpteli.pc and szptelc.pc
SATURNSZTTEST[MC] Transaction Level Global Temporary Table for ACT and SAT Test Dates
SATURNSZVADEF[MC] Academic Deficiency Code Validation Table
SATURNSZVCRIT[MC] TELS Scholarship Criterion Validation Table
APLOCALSZVEARPEarly Alert Problem Validation Table
APLOCALSZVEARREarly Alert Recommendation Validation Table
SATURNSZVIMMZ[MC] Immunization Code Validation Table
APLOCALTABLE_COL_SRCH_RSLTS 
APLOCALTABLE_SRCH_RSLTS 
TAISMGRTBBACCTAccount Header Table
TAISMGRTBBCCLRCollector Table Used For Various Cashiering Operations
TAISMGRTBBCCTXContract Text Table by Contract Number and Term
TAISMGRTBBCONTContract Header Table
TAISMGRTBBCPRFCustomer Profile Attributes Table.
TAISMGRTBBCSHRCashier Session Table
TAISMGRTBBCSTTContract Student Text Table
TAISMGRTBBCSTUContract Student Authorization Table
TAISMGRTBBCTRLAccounts Receivable Billing Control Table.
TAISMGRTBBDEPCDeposit Detail Definition Table
TAISMGRTBBDETCDetail Charge/Payment Code Definition Table
TAISMGRTBBEACTEffective Dated Detail Code Account Definition Base Table.
TAISMGRTBBESTUExemption Student Authorization Table
TAISMGRTBBETBDEffective Dated Term-Based Designator Definition Base Table.
TAISMGRTBBEXPTExemption Header Table
TAISMGRTBBIAACBase Plan/Term record for Automated Installment Plan assignment rules.
TAISMGRTBBIPLNBase Plan/Term record for Automated Installment Plan calculation rules.
TAISMGRTBBISTCInstallment Plan Definition Table
TAISMGRTBBMISCMiscellaneous Transaction Receipt Header Table
TAISMGRTBBPIDMPidm Collector Table for TBVAPPL view and various collector processes.
TAISMGRTBBRETCReturned Check Code Definition Table
TAISMGRTBBRQSTReapplication of Payment Request Table.
TAISMGRTBBSBRLSchedule/Bill Rules Table
TAISMGRTBBSTMTStatements Produced Table
TAISMGRTBBTBDSTerm-Based Designator Rules Table
TAISMGRTBBTERMAccounts Receivable Term Control
TAISMGRTBBTPRLThird Party Billing Rules Definition Table
TAISMGRTBBUPRFAccounts Receivable Userid Profile table
TAISMGRTBRACCDAccount Charge/Payment Detail Table
TAISMGRTBRACCTDetail Code Account Definition Table
TAISMGRTBRACDTAccount Charge/Payment Detail Text Table
TAISMGRTBRACHGThis table is used to maintain changes to tables associated with the AT_APPLICATION_OF_PAYMENT composite view for incremental refresh processing in the ODS.
TAISMGRTBRAPPLDetail Application of Payment Table
TAISMGRTBRCACCContract Account Level Authorization Definition Table
TAISMGRTBRCASNCashier Assignment Table
TAISMGRTBRCBRQCollector Table Used For Recursive Invoice Processing
TAISMGRTBRCCATContract Detail Category Level Authorization Definition Table
TAISMGRTBRCCHGThis table is used to maintain changes to tables associated with the AT_ACCOUNT composite view for incremental refresh processing in the ODS.
TAISMGRTBRCCRCCollector table used by the TBVRCPT view
TAISMGRTBRCCSIContract Detail Category Level Authorization Source Definition Table
TAISMGRTBRCDETContract Detail Level Authorization Definition Table
TAISMGRTBRCDSIContract Detail Level Authorization Source Definition Table
TAISMGRTBRCHLDCollector Table Used For Auto Hold Report Processing.
TAISMGRTBRCISPAutomated Installment Plan collector table.
TAISMGRTBRCLCTCollector File Used In Credit Calculations
TAISMGRTBRCMISCollector Table Used For Recursive Miscellaneous Receipt Printing
TAISMGRTBRCMNTComment Table
TAISMGRTBRCOLCAccount Collection Repeating Table
TAISMGRTBRCOLRCashiering Collector Table
TAISMGRTBRCRCPCollector Table Used For Recursive Receipt Printing
TAISMGRTBRCREQContracts Course Requirements Table.
TAISMGRTBRCSUMCollector Table Used For Recursive Student Summary Report Processing
TAISMGRTBRCTEXIntermediate File Containing Credit Amounts
TAISMGRTBRDCHGThis table is used to maintain changes to tables associated with the AT_DEPOSIT composite view for incremental refresh processing in the ODS.
TAISMGRTBRDEPODeposit Table
TAISMGRTBREACCExemption Account Level Authorization Definition Table
TAISMGRTBRECATExemption Detail Category Level Authorization Definition Table
TAISMGRTBRECHGThis table is used to maintain changes to tables associated with the AT_EXEMPTION composite view for incremental refresh processing in the ODS.
TAISMGRTBRECSIExemption Detail Category Level Authorization Source Definition Table
TAISMGRTBREDETExemption Detail Level Authorization Definition Table
TAISMGRTBREDSIExemption Detail Level Authorization Source Definition Table
TAISMGRTBREREQExemptions Course Requirements Table.
TAISMGRTBRIACLInstallment Assignment Rules for College
TAISMGRTBRIACMInstallment Assignment Rules for Campus
TAISMGRTBRIADGInstallment Assignment Rules for Degree
TAISMGRTBRIALVInstallment Assignment Rules for Level
TAISMGRTBRIAMJInstallment Assignment Rules for Major
TAISMGRTBRIARTInstallment Assignment Rules for Rate
TAISMGRTBRICBAAutomated Installment Plan dynamic calculation reported on TSRCBIL
TAISMGRTBRICHGThis table is used to maintain changes to tables associated with the AT_INSTALLMENT composite view for incremental refresh processing in the ODS.
TAISMGRTBRIDCTInstallment Calculation Include Category Code
TAISMGRTBRIDETInstallment Calculation Include Detail Code
TAISMGRTBRIDTXInstallment Calculation Exclude Detail Code
TAISMGRTBRISTLInstallment Plan Table
TAISMGRTBRISTPDefine Installment Plan by dates and percentages
TAISMGRTBRLBOXLock Box Intermediate Table
TAISMGRTBRLCHGThis table is used to maintain changes to tables associated with the AT_LEDGER_ACCOUNTING composite view for incremental refresh processing in the ODS.
TAISMGRTBRMEMOCharge/Payment Detail Memo Table
TAISMGRTBRMESGBilling Message Table
TAISMGRTBRMISDMiscellaneous Transaction Charge/Payment Detail Table
TAISMGRTBRNCHGThis table is used to maintain changes to tables associated with the AT_ACCOUNT_DETAIL composite view for incremental refresh processing in the ODS.
TAISMGRTBRRRASRecurring Receivables Assignment Table
TAISMGRTBRSBMSSchedule/Bill Message Table
TAISMGRTBRSBRLSchedule/Bill Collector Table
TAISMGRTBRTCHGThis table is used to maintain changes to tables associated with the AT_CONTRACT composite view for incremental refresh processing in the ODS.
TAISMGRTBRUPRFAccounts Receivable User Restrictions Table
TAISMGRTBTDTLCGlobal Temporary Table for AR Detail processing
TAISMGRTBTFADBFin.  Aid Intermediate Disbursement Table
FIMSMGRTEMPFEEDCUSTOM TABLE: Legacy JE Feed Table from different systems into Banner Finance
FIMSMGRTEMPFEED2CUSTOM TABLE: Legacy JE Feed Table Feed 2 which contains data compatible with GURFEED table.
PAYROLLTEMP_CERT 
TAISMGRTGRCLR2Collector table used by tgrrcon to store summary information which is later used to produce the reconciliation report.
TAISMGRTGRCLR3Collector table used to store the parameter entered chart of accounts.
TAISMGRTGRCOLRCollector table used by tgrrcon to produce the reconciliation report.
NLSUSERTMURVERSTranslation Manager Version Tracking Table
TAISMGRTOTACCTWeb for Executives Accounts Receivable Account Hierarchy Extract
TAISMGRTOTFUNDWeb for Executives Accounts Receivable Fund Hierarchy Extract
TAISMGRTOTORGNWeb for Executives Accounts Receivable Organization Hierarchy Extract
TAISMGRTOTPROGWeb for Executives Accounts Receivable Program Hierarchy Extract
TAISMGRTOTWAREWeb for Executives Accounts Receivable Extract
TAISMGRTPRRHLDAuto Hold/Release Rules Table.
TAISMGRTRRACCDResearch Accounting Account Detail Table
TAISMGRTRRACHGThis table is used to maintain changes to tables associated with the AT_GRANT_ACCOUNTING_DETAIL composite view for incremental refresh processing in the ODS.
TAISMGRTRRAGTCResearch Accounting Aging Report Collector Table
TAISMGRTRRAPPLResearch Accounting Application of Payment Table
TAISMGRTRRCOLLGrant Billing Collection Repeating Table
TAISMGRTRRGCHGThis table is used to maintain changes to tables associated with the AT_GRANT_APPLICATION_PAYMENT composite view for incremental refresh processing in the ODS.
TAISMGRTRVCOLLCollection Code Table
TAISMGRTSRCTPBCollector Table Used For TSRTBIL Report Processing.
TAISMGRTSRTERMVoice Response Accounts Receivable Term Table
TAISMGRTTB10981098-T Tax Information Form.
TAISMGRTTBIRSCCollector Table for IRS 1220 data.
TAISMGRTTBPROCCollector table for tsp1098 process.
TAISMGRTTBTAXNTax notification table for student. This is similar to the IRS 1098T form. This form enables students to apply for tax relief for qualified fees.
TAISMGRTTBTSPCCollector Table for tsp1098  process.
TAISMGRTTBTXRNTax Report Code for Student Notification. This table enables to maintain students report code with the total amount for a single report code.
TAISMGRTTBXSMCCollector table for the ttvxsum view.
TAISMGRTTRDTLCThis collector table holds the student report code details with the total amount for a single report code.
TAISMGRTTRTAXRRules table for terms and dates.
TAISMGRTTRTAXTTRA Term Code Rule Table
TAISMGRTTRTXCDRule table for Detail code and Category Code.
TAISMGRTTRTXEXRule table for Excluded Detail codes.
TAISMGRTTRTXPRTax Report Proration Table
TAISMGRTTTTAXCGlobal Temporary Table used in calculating reportable amounts for 1098-T
TAISMGRTTVBILLBill Code Validation Table
TAISMGRTTVCCRDVoice Response Credit Card Type Table
TAISMGRTTVDCATDetail Charge/Payment Category Code Validation Table
TAISMGRTTVDELIDelinquency Code Validation Table.
TAISMGRTTVDTYPDeposit Type Validation Table
TAISMGRTTVECATEntity Category Code Validation Table.
TAISMGRTTVPAYTDetail Code Payment Type Validation Table
TAISMGRTTVREPTTax Report Code Validation Table.
TAISMGRTTVRHLDAuto Hold/Release Rules Code Validation Table
TAISMGRTTVSBRCSchedule/Bill Rules Code Validation Table
TAISMGRTTVSRCEBilling Detail Source Validation Table
TAISMGRTTVTAXTTax Code Validation Table
TAISMGRTTVTBDSTerm-Based Designator Validation Table
TAISMGRTTVTPRCThird Party Billing Rules Code Validation Table.
APLOCALTT_FTVPROG_CONV_CODES 
APLOCALTT_FTVPROG_CONV_COLS 
APLOCALTT_ORA_ERR_LOG 
TAISMGRTURVERSAccounts Receivable Version Tracking Table.
TAISMGRTVRAUTHTitle IV Authorization Maintenance Table.
TAISMGRTVRCREQTitle IV Requirement to Authorization Collector Table.
TAISMGRTVVAUTHTitle IV Authorization Validation Table.
WTAILORTWGBFRAMWeb Tailor HTML Frameset Information table
WTAILORTWGBGLUIWeb Tailor - Global Web User Interface settings table
WTAILORTWGBIMAGWeb Tailor Image Information table
WTAILORTWGBLDAPThis table will store LDAP specific parameters.
WTAILORTWGBOVRRWeb Tailor - Web Overrides table
WTAILORTWGBPARMWeb Tailor - Web Parameters table
WTAILORTWGBRETCWeb Tailor Login Return Code base table
WTAILORTWGBTLBRWeb Tailor Navigation Bar Information table
WTAILORTWGBWMNUWeb Tailor Main Web Page Settings table
WTAILORTWGBWMNU_BWS70303U 
WTAILORTWGBWMNU_FA711_UPDATES 
WTAILORTWGBWRULWeb Tailor - Web Rules table
WTAILORTWGBWSESWeb Tailor Web SessionID table
WTAILORTWGRCHNL 
WTAILORTWGRCMAP 
WTAILORTWGRFRRLWeb Tailor Frameset Roles table
WTAILORTWGRINFOWeb Tailor Repeating Information Text table
WTAILORTWGRMENUWeb Tailor Repeating Menu Item table
WTAILORTWGRMENU_BWS70303U 
WTAILORTWGRMENU_FA711_UPDATES 
WTAILORTWGRRETCWeb Tailor Login Return Code repeating table
WTAILORTWGRROLEWeb Tailor User Roles repeating table
WTAILORTWGRTLBRWeb Tailor Navigation Bar Elements table
WTAILORTWGRUPRF 
WTAILORTWGRVERSWebTailor Version Tracking Table
WTAILORTWGRWMRLWeb Tailor Menu Roles table
SATURNTWGRWMRL_COM_ROLES 
SATURNTWGRWMRL_FAC_ROLES 
GENERALTWGRWMRL_ROLES 
WTAILORTWGRWMRL_ROLES 
PAYROLLTWGRWMRL_ROLES 
FIMSMGRTWGRWMRL_ROLES 
ALUMNITWGRWMRL_ROLES 
SATURNTWGRWMRL_STU_ROLES 
WTAILORTWGRWPRMWeb Tailor User Parameters table
WTAILORTWTVMODUWeb Tailor Module validation table
WTAILORTWTVROLEWeb Tailor User Role validation table
TAISMGRTZRSTSFStudent Term Payment Status Table
TAISMGRTZRWMSGSelf Service Enrollment Student Confirmation message text table
TAISMGRTZVSPSTStudent Payment Status Code Validation Table
WFBANNERWFCTCIDT 
WFBANNERWFCTCSSO 
WFBANNERWFITWIPA 
WFBANNERWFITWIQU 
WFBANNERWFITWLOG 

 

SELECT a.owner, a.table_name, a.comments
FROM all_tab_comments a
where a.owner not in ('SYS','SYSTEM','OUTLN','WMSYS','XDB','SYSMAN','UPGRADE1','THEC_TABLES','WORKFLOW','TSMSYS','DBSNMP','BANWORX','BOSSCARS','BOSSSEC','CLNADDR','EVISIONS','ICMGR')
and a.table_name not like '%_INSTALL'
and a.table_name not like '%_CONVERT'
and a.table_name not like 'BIN%'
and a.table_type = 'TABLE'
order by a.table_name