| Table Name and Description |
| dbo_DW_ldr_acct_bal_v |
| |
Provides Account Balance information:
A life-to-date(SmartStream LTD) analysis by UDAK for fiscal
year for Actuals or Budfund broken down by month(period). |
| dbo_DW_FY##_LABal_Actual_v |
| |
Provides a Year-to-Date account
balance by UDAK for the fiscal year. There are seperate
tables for fiscal years 2000 and current (2001). Also notice
a seperation by MC and MU (Medical Center and University). |
| dbo_DW_FYcurrent_Tran_Invoice_v
|
|
|
Provides current fiscal year transaction
information (posted journal lines/invoices); including UDAK,
journal id#, invoice number, pmt request voucher number(PO,
DV, Release #, etc.) |
|
dbo_DW_LTD_Tran_Invoice_v
|
| |
Provides life-to-date(SmartStream
LTD) transaction information (invoices/posted journals):
including invoice number, check number, pmt request voucher
number(PO, DV, Release #, etc.), journal Id.. |
|
dbo_DW_FY####_Tran_Invoice_v
|
| |
Provides fiscal year invoice and
posted journal transaction information: including invoice
number, check number, pmt request voucher number(PO, DV,
Release #, etc.), journal id. There are tables for FY2000,
FY1999, and FY1998. |
|
dbo_DW_FYcurrent_Tran_PJL_Actual_v
|
| |
Provides current fiscal year posted
journal line information for amount class type ACTUAL; including
UDAK, journal ID#, transaction amount, posting year and
month. |
|
dbo_DW_FYcurrent
_P01_PJL_ACTUAL thru dbo_DW_FYcurrent
_P12_PJL_ACTUAL
|
|
|
Posted journal line information (actual transactions)
for each month of the current fiscal year. |
| dbo_DW_FYcurrent_Tran_PJL_v |
| |
Posted journal line transactions
for current fiscal year including Actual and Budfund for
all periods |
| dbo_DW_FYTD_Tran_ACTUAL_v |
| |
Current fiscal year transactions
(posted journals) for Actuals only (not Budfund); including
UDAK, journal ID, posting period, transaction amount. |
| dbo_DW_open_po_MC |
|
|
Provides open/outstanding Purchase
Order information for the Medical Center (MUHA site id) |
| dbo_DW_open_po_MU |
| |
Provides open/outstanding Purchase
Order information for the Medical University (MUSC site
id) |
| dbo_DW_open_req_MC |
| |
Provides open/outstanding Requisition
information for the Medical Center (MUHA site id) |
| dbo_DW_open_req_MU |
| |
Provides open/outstanding Requisition
information for the Medical University (MUSC site id) |
