Skip to Search
Skip to Navigation
Skip to Content

University of Connecticut Kuali Financial Data Mart

KFDM Stars

GL Transaction Star

This table contains detailed transactional information from the General Ledger in KFS along with additional Account, Award, Object, Organization, Project, Sub-Account & Sub-Object configuration information. 
Note – This table is based off of general ledger transactions, so it will only have detail for organizations or accounts that have had transactions. In KFS, Budget Adjustments, Actuals and Encumbrances all generate transactions.

Dimensions
The views below represent the full detail for the dimensions of the GL_TRANSACTION star, including Accounts, Organizations, etc… that are configured in KFS but have not been transacted against yet.

ACCOUNT_VIEW
Account information including which organizations accounts belong to.

AWARD_VW
Award information.

OBJECT_VW
Object Code information.

ORGANIZATION_VW
Organization information. Executive Levels, Units, Departments and Sub-Departments are all classified as Organizations in KFS.

ORG_HIERARCHY_VW
This view shows the “Reports To” relationship of Organization Codes, so you can see which departments belong to a unit.

PROJECT_VW
Project information.

SUB_ACCOUNT_VW
User-defined Sub-Account information.

SUB_OBJECT_VW
User defined Sub-Object Code information.

GL_TRANSACTION Metadata

 

GL Current Star

This table contains detailed transactional information from the General Ledger in KFS along with additional Account, Award, Object, Organization, Project, Sub-Account & Sub-Object configuration information. It contains the most current account attributes such as Fiscal Officer, Account Supervisor, etc.
Note – This table is based off of general ledger transactions, so it will only have detail for organizations or accounts that have had transactions. In KFS, Budget Adjustments, Actuals and Encumbrances all generate transactions.

Dimensions
The views below represent the full detail for the dimensions of the GL_CURRENT star, including Accounts, Organizations, etc… that are configured in KFS but have not been transacted against yet.

ACCOUNT_VIEW
Account information including which organizations accounts belong to.

AWARD_VW
Award information.

OBJECT_VW
Object Code information.

ORGANIZATION_VW
Organization information. Executive Levels, Units, Departments and Sub-Departments are all classified as Organizations in KFS.

ORG_HIERARCHY_VW
This view shows the “Reports To” relationship of Organization Codes, so you can see which departments belong to a unit.

PROJECT_VW
Project information.

SUB_ACCOUNT_VW
User-defined Sub-Account information.

SUB_OBJECT_VW
User defined Sub-Object Code information.

GL_CURRENT Metadata

 

Payroll_Distribution Star

Joins Payroll Actuals and Encumbrances by Employee and Account from the KFS Labor Ledger with Job and Employee Information from Genesys.

Job_Funding Star

Pulls funding information including Accounts, FTE & Percent Funded from Genesys. It is rebuilt nightly so it will always contain the most recent funding information for an employee.

Purchase_Order Star

Joins together all relevant information for a Purchase Order.

Purchase_Order_Accounting Star

Has the same information as the Purchase Order star with the addition of the PO Accounting Lines.

Requisition_Star

Joins together all relevant information for a Requisition.

Requisition_Accounting Star

Has the same information as the Requisition star with the addition of the Requisition Accounting Lines.

Payment_Request Star

Joins together all relevant information for a Payment Request.

Payment_Request_Accounting Star

Has the same information as the Payment Request star with the addition of the Payment Request Accounting Lines.

Disbursement_Accounting Star

Joins together all relavant inforamtion related to Disbursements with the addition of Accounting Line Information

AR_Invoice Star

This star brings together KFS Accounts Receivable information related to invoices, customers, and unapplied balances for reporting.