10 likes | 78 Views
This model illustrates the relationships between entities like Cost Centre, Funding, Program, and Campus within the SHCN system. It outlines how data such as Cost Centre Classification, EFT details, Centre Description, Awards, and Labour Categories are connected. The model helps in understanding the flow of information and the structure of the program and funding data for efficient management and analysis.
E N D
Entity Relationship Model for SHCN Program and Funding data Data Cost Centre Classification Cost_centre Classn Eft_basic Eft_otime Eft_wcover Eft_productive Eft_non-productive Cost_cent Cent_desc Campus Fund Prog_no Classn Class Name Award_no Labour_category Fund Campus Award Labour Category Fund Fund Name Campus Campus Name Award_no Award_desc FN_Base_Hours Lab_cat Lavour_category_desc Sub Program Program Cost_cent Prog No Sub Program Prog No Prog Name