Nitesh9999
Nitesh9999
- Local time
- Today, 23:34
- Joined
- Mar 16, 2005
- Messages
- 42
Hey i have finally got around to create my actual db, putting into practice what i have learned in these forums over the last couple of weeks.
This is a bit of background on why the db is needed...
What im trying to do is convert our excel spreadsheets to a db. This has the benifits of giving us a wide range of reports at the click of a button, rather than the copying and pasting we currently do in excel.
We receive sheets from different areas (PCT's) telling us what treatments they have carried out. We store these in excel and send them back invoives with a copy of an excel spreadsheet summarizing what they have been billed for. and we send out monthy, yearly summaries.
Here goes on the Table structures
tblPCTCode
-PCTCode_ID-----around 35 codes to distinguish where the treatment was carried out
-PCTCode
tblTreatmentGroup
-TreatmentGroup_ID------ 6 groups a "parent" of the Treatment types below
-TreatmentGroup
tblTreatmentType
-TreatmentType_ID---------34 Treatment types each belong to a Treatment group above
-TreatmentType
-UnitCost--------- A value set at the begging of the financial year, maybe changed, used for calculations
-PlanValue------- Same as unit cost above
tblFinancialMonth
-FinancialMonth_ID
-FinancialMonth
tblPatients-------------------Contains the bulk of the Patients details
-Patient_ID
-PatientNHSNumber
-HospitalNumber
-PatientPostcode
-StartDate
-EndDate
-GPName
-GPPostcode
-Act
-Value
-PCTCode
-TreatmentGroup
-TreatmentType
-UnitCost
-PlanValue
-FinancialMonth
I appreciate any views on the structure. The db is attached with the above structure.
Nitesh
This is a bit of background on why the db is needed...
What im trying to do is convert our excel spreadsheets to a db. This has the benifits of giving us a wide range of reports at the click of a button, rather than the copying and pasting we currently do in excel.
We receive sheets from different areas (PCT's) telling us what treatments they have carried out. We store these in excel and send them back invoives with a copy of an excel spreadsheet summarizing what they have been billed for. and we send out monthy, yearly summaries.
Here goes on the Table structures
tblPCTCode
-PCTCode_ID-----around 35 codes to distinguish where the treatment was carried out
-PCTCode
tblTreatmentGroup
-TreatmentGroup_ID------ 6 groups a "parent" of the Treatment types below
-TreatmentGroup
tblTreatmentType
-TreatmentType_ID---------34 Treatment types each belong to a Treatment group above
-TreatmentType
-UnitCost--------- A value set at the begging of the financial year, maybe changed, used for calculations
-PlanValue------- Same as unit cost above
tblFinancialMonth
-FinancialMonth_ID
-FinancialMonth
tblPatients-------------------Contains the bulk of the Patients details
-Patient_ID
-PatientNHSNumber
-HospitalNumber
-PatientPostcode
-StartDate
-EndDate
-GPName
-GPPostcode
-Act
-Value
-PCTCode
-TreatmentGroup
-TreatmentType
-UnitCost
-PlanValue
-FinancialMonth
I appreciate any views on the structure. The db is attached with the above structure.
Nitesh