PEOPLESOFT FINANCIALS - COMMONLY USED TABLES

1 NOTE: These TABLES do not contain any information that you could not otherwise find using files delivered with the PEOPLESOFT 1 of 4 RECORD (TABLE) NAMERECORD (TABLE) DEFINATION & DESCRIPTIONVENDORSVENDORV endor Header Table - Main Vendor table which contains many important fields related to the vendor. ( Vendor ID, Name, Address)VENDOR_LOCV endor Location - Location Information for each VendorVENDOR_ADDRV endor Address - Address Information for each VendorVENDOR_WTHD_JURV endor Withhold Jurisdiction - Withholding Information Populated (Important in 1099 Processing)REQUISITIONSREQ_HDRR equisition Header - Header Record for RequisitionREQ_LINER equisition Line - Line Record for RequisitionREQ_LINE_DISTRIBR equisition Line Distribution - Accounting Distribution for RequisitionREQ_LINE_SHIPR equisition Line Delivery Schd - Shipment Details for RequisitionREQ_APPROVALR equisition Approval - Approval Information for RequisitionREQUESTOR_TBLM aster Requester Table - Requester InformationPURCHASE ORDERSPO_HDRP urchase Order Header - Header Record for Purchase OrderPO_LINEP urchase Order Line - Line Record for Purchase OrderPO_LINE_DISTRIBPO Line Accounting Entries - Accounting Distribution for Purchase OrderPO_LINE_MATCHEDPO Line Billed Amounts - Match Information for PO (Voucher, Receipt, PO)

2 PO_APPROVALP urchase Order Approval - Approval Information for Purchase OrderPO_LINE_SHIPPO Line Shipping Schedule - Shipment Details for Purchase OrderRECEIPTSRECV_HDRR eceiver Header - Receipt Header TableRECV_LN_DISTRIBR eceipt Accounting Entries - Receipt Distribution LineRECV_LN_ASSETR eceiving Asset Interface Scrl - Receipt Line Asset InformationRECV_LN_SHIPR eceipt Shipping Schedule - Receipt Shipment InformationACCOUNTS PAYABLEVOUCHERAP Voucher Header Table - Header Record for VoucherVOUCHER_LINEV oucher Line - Line Record for VoucherDISTRIB_LINEV oucher Distribution Table - Accounting Distribution for VoucherGRP_APAP Control Group Table - AP Control Group DataTRAVEL AUTHORIZATIONSEX_TAUTH_HDRT ravel Authorization Header - Header Record for TAEX_TAUTH_LINELine Information - Line Record for TAEX_TAUTH_DISTT ravel Authorization Dist - Accounting Distribution for TAEXPENSE REPORTSEX_SHEET_HDRE xpense Sheet Header - Header Record for Expense ReportEX_SHEET_LINEE xpense Report Line - Line Record for Expense ReportEX_SHEET_DISTE xpense Line Distributions - Accounting Distribution for Expense ReportPEOPLESOFT FINANCIALS - COMMONLY used TABLESNOTE.

3 These TABLES do not contain any information that you could not otherwise find using files delivered with the PEOPLESOFT 2 of 4 RECORD (TABLE) NAMERECORD (TABLE) DEFINATION & DESCRIPTIONPEOPLESOFT FINANCIALS - COMMONLY used TABLESCASH ADVANCESEX_ADV_HDRA dvance Header - Header Record for AdvancesEX_ADV_LINEA dvance Line - Line Record for AdvancesEX_ADV_DISTCash Advance Distribution - Accounting Distribution for AdvancesEX_ADV_APPRVRA pprovers - Approval Information Related to AdvancesIDENTIFY PANTHER ID NUMBERPERS_DATA_EFFDT Effective Dated Personal Data - Main Personal Data table which contains many important fields related to the Employee. ( Employee ID and Name)EXPENSE APPROVERSEX_ADV_HDRA dvance Header - Header Record for AdvancesJOBEE Job History - HR Manager InformationPAYMENTSPAYMENT_TBLAP Disbursements - Detail of each payment generated from the Accounts Payable Pay Cycle.

4 Includes fields such as Check #, Payment #, Vendor Paid, Employee ID Paid (From Expenses), Address and Method of Payment, Payment Status ( Cancelled, Scheduled)PYMNT_VCHR_XREFV oucher Scheduled Payment - Accounts Payable Detail ( Voucher ID) related to a EX_ADVNCE_PYMNTA dvance Payment - Cash Advance Detail related to a specific Payment - Expense Report Detail related to a specific LEDGER (Ledger populated by GL Posting Process)JRNL_HEADERJ ournal Header Data - Header Record for Journal. Important Fields include the following:JOURNAL_ID, JOURNAL_DATE, JRNL_HDR_STATUS,BUDGET_HDR_STATUS, DESCR254 JRNL_LNJournal Line Data - Line Record for Journal. Important fields include the following: Journal ID, Journal Line #, Department ID and Account (and Other Chartfields), Budget Line Status, Distribution Amounts, Budget Dates, Close FlagLEDGERL edger Data - Summary of Balances by Chartfields by Fiscal Year, Accounting PeriodCOMMITMENT CONTROL (Populated by Budget Check process)LEDGER_KKLedger Data - Summary of Balances by Chartfields by Fiscal Year, Accounting Period.

5 Similar to LEDGER table with the additional field, for Budget Budget Journal Line - Budget Transfer and Budget Entry Journal LinesKK_BUDGET_HDRKK Budget Journal Header - Budget Transfer and Budget Entry Journal HeaderKK_ACTIVITY_LOGKK budget activity record - Transaction Accounting Details populated on this record when an Item is 'Budget Checked'.Each transaction is identified by KK Transaction IDKK_SOURCE_HDRComm. Cntrl. Source Hdr Table - Associates the KK Transaction ID's with a more module specific Identifier, like a specific Voucher IDKK_LIQUIDATIONComm. Cntrl. Liquidation Table - For each KK Transaction ID, the amount remaining to be liquidated. ( Amount of encumbrance remaining to be released for PO or TA)NOTE: These TABLES do not contain any information that you could not otherwise find using files delivered with the PEOPLESOFT 3 of 4 RECORD (TABLE) NAMERECORD (TABLE) DEFINATION & DESCRIPTIONPEOPLESOFT FINANCIALS - COMMONLY used TABLESBUDGET PREPARATIONFIU_POSTN_BUDGT Position Budget Reporting - Position Budgets (Unique to FIU)LEDGER_BUDGB udget Ledger Data - Ledger for Last Year's Budget, Forecast and Requested budgetsCHARTFIELD TABLESDEPT_TBLD epartments - Department IdsPROJECTP rojects - Stores the Project information when a new Project is created, keyed by Business Unit (FIU01 - Grants & Construction only as of 7/1/12.)

6 FIU02 - Various)GL_ACCOUNT_TBLA ccounts - AccountsSPEEDTYP_TBLS peedTypes - SpeedtypesFUND_TBLFund Table - Fund Codes:E&G, AUX, C&G, Agencies, FA, Student Related Activities, and ConcessionsCLASS_CF_TBLC lass of Trade Table - Class (Campus / Location) Codes: 1. Modesto A. Madique Campus 2. Biscayne Bay Campus 3. Broward 4. Pembroke Pines 5. WolfsonianPROGRAM_TBLP rogram Table - PCS Codes \ Functional Component \ Program CodesBUD_REF_TBLB udget Reference Table - Budget Reference ( used by Construction ONLY as of 7/1/12)ALTACCT_TBL Alternate Account - Alternate Accounts established by the State of Florida for state accountingCOMBO_DATA_TBL ChartField Combo Data Tbl - Contains Valid CF Combinations (or Invalid depending on Rule Definition)ASSETSBOOKF inancial Book - The table has the financial Asset Book transactions. Important fields include BU, Asset #, Book, Begin_Depr_DtCOSTA sset Cost Transactions - The table has the Asset Cost transactions Important fields include Asset #, Book, Group_Asset_ID, Category, Cost Type, CostINTFC_PRE_AMPre-Interface Table to AM - Table initially loaded with asset detail from other system.

7 ( Accounts Payable)INTFC_FINAM Interface- financial - Accounting Detail associated with asset initially loaded into Asset ManagementASSETA sset General Information - The primary Asset table populated when an asset is created. Important fields include: Asset #, Tag, Description, Acquisition dates, Serial #, ProfileDEPRECIATIOND epreciation Transactions - The table has the Depreciation transactions. Important fields include the following:BU, Asset #, Book, Start_PD, End_PD, Trans_DtASSET_ACQ_DETA sset Acquisition Detail - Asset Acquisition DetailASSET_NBV_TBLA sset NBV Reporting Table - Asset Net Book Value DetailNOTE: These TABLES do not contain any information that you could not otherwise find using files delivered with the PEOPLESOFT 4 of 4 RECORD (TABLE) NAMERECORD (TABLE) DEFINATION & DESCRIPTIONPEOPLESOFT FINANCIALS - COMMONLY used TABLESSUB-MODULE INTERFACE TABLES (STAGING TABLES ) - Prior to Journal GenerationVCHR_ACCTG_LNAP Accounting Entries - Accounts Payables (Vouchers)EX_ACCTG_LINEE xpense Accounting Line - Travel & Expenses (Cash Advances \ Expense Reports)DIST_LNAM Accounting Entries - Asset Management (Assets)CA_ACCTG_LN_PCAccounting line tbl for CA/PC - Contracts (Grants Billing)BI_ACCT_ENTRYB illing Account Entry table - Billing (Grants Billing)ITEM_DSTC ustomer Item Distribution - Receivables (Grants Receivables \ Payments)PAY_MISC_DSTNon Customer Payment Distrib - Receivables (Grants Payments)

8 SF_ACCTG_LNStudent FINANCIALS Acctg Line - Student FINANCIALS (including Cashiering)HR_ACCTG_LINEP ayroll Accounting Line - Payroll (PSFT HR\Payroll on 1/1/2012)JGEN_ACCT_ENTRYJrnlGen Accounting Entry Table - Pinnacle (Telecommunications)CONTRACTS \ GRANTSCA_DETAIL_DSTC ontract Distribution Detail - Links Projects to Contracts/ Awards CA_CONTR_HDRC ontract Header - Line Record for Purchase OrderPROJECTP rojects - Stores the Project information when a new Project is created, keyed by Business Unit (FIU01 - Grants & Construction only as of 7/1/12; FIU02 - Various)PROJ_RESOURCEP roject Resources - Gives the Budget and expense Information for every project in the systemGM_AWARDA ward Parent Record - Header Record for AwardGM_PROPOSALG rants Proposal - Header Record for ProposalBILLINGBI_HDRBill Header - Header record for Customer BillBI_LINEBill Lines - Line Information for customer billsRECEIVABLESITEMC ustomer Items - Header Record for Receivables ItemsITEM_ACTIVITYC ustomer Item Activity - Detail Line information for Receivables ItemsITEM_DSTC ustomer Item Distribution - Item Chartfield DistributionPAYMENTSDEPOSIT_CONTROLD eposit Control Information - List the Customer Deposit Information (Deposit BU and Deposit ID are Keys)PAYMENTP ayments - Payment information for the Customers (Customer Payments\Receipts)

9 PAYMENT_ID_CUSTP ayment Customer Identification - Payment Customer InformationPAYMENT_ID_ITEMP ayment Item Identification - Payment Item IdentificationCUSTOMERSCUSTOMERC ustomer Header Information - Header for Customer DataCUST_ADDRESSC ustomer Address Detail - Customer Address InformationCUST_CONTACTC ustomer Contact Detail - Customer Contact InformationCUST_DATAC ustomer Info / Balances - Customer Details such as Customer Balance, Last Payment, Last AgedCUST_AGINGC ustomer Aging - Customer Details such as Aging Id, Aging Amount, Count, SPECIFIC