24-7 Database
From 24-7Wiki
The main 24-7 Database is currently held in the access restricted document library. Please contact the General Manager, if you need access to this repository.
[edit]
Applying a new Gift Aid or Standing Order number to a database record
When adding a GA or SA number to a row in the database, increment the previous SA or GA number, not just the previous number from the same column. For example:
| Standing Order Number | Gift Aid Number | Name |
|---|---|---|
| SO-0211 | GA-0211 | J Smith |
| SO-0212 | GA-0212 | S Smith |
| SO-0213 | P Walter | |
| SO-0214 | GA-0214 | J Bloggs |
| SO-0215 | B Brown | |
| SO-0216 | M Brown | |
| GA-0217 | F Edge | |
| SO-0218 | M Mouse | |
| SO-0219 | GA-0219 | D Lock |
SO and GA numbers should therefore remain the same for the each row in the database.
[edit]
Data Dictionary
The data dictionary is now held in a google spreadsheet here. Please contact the General Manager if you require access.
