Download original attachment
(Excel spreadsheet)
This is an HTML version of an attachment to the Freedom of Information request
'What formats to you store what data in,'.
(Excel spreadsheet)
| Table | May-09 | Other1 | Other2 |
| cAuthorityBFs | |||
| cActionTaken | |||
| cActionTakenLink | 37457 | ||
| cAddress | 203872 | ||
| cAddressType | |||
| cAdhocClauses | Not required | ||
| cAdhocFieldsTest | Not required | ||
| cAdhocJoinsTest | Not required | ||
| cAdhocSavedQueries | Not required | ||
| cAgeRange | |||
| cAgeTest | |||
| cAudit | 8738809 | ||
| cAuthCatInvalidList | |||
| cBFSchedule | |||
| cCategory | |||
| cCategoryRange | |||
| cComebackBasis | |||
| cComebackBasisLink | 12723 | ||
| cComebackType | |||
| cComplainantType | |||
| cComplaintDetails | |||
| cCorrespondenceType | |||
| cCouncilBF | |||
| cCounty | |||
| cCrossReferred | 42073 | ||
| cDateDescBF | |||
| cDateDescriptions | 21 | ||
| cDecisionRoute | |||
| cDisabilityCode | |||
| cDisabilityDesc | |||
| cDisabilityLink | 26080 | ||
| cEthnicLanguage | 14 | ||
| cEthnicOrigin | 20 | ||
| cFinalOutcome | |||
| cGender | 4 | ||
| cInformationSource | |||
| cInfoSourceUserLink | 123419 | ||
| cInvestigator | |||
| cInvHistory | 27838 | ||
| cKeywords | |||
| cKeywordsLink | 443318 | ||
| clabels | |||
| clabelsold | |||
| cLinked | 1356 | ||
| cLocalAuthContact | |||
| cLocalAuthority | |||
| cLocalAuthorityType | |||
| cLocks | |||
| cLookUpList | 54 | ||
| cMdf | |||
| cOtherOrg | |||
| covdecletmissing | |||
| cPCMedium | |||
| cPreComplaintDetails | |||
| cPurposeOfContact | |||
| cPurposeOfContactLink | 50567 | ||
| cRemedy | |||
| cRemedyLink | 33248 | ||
| cReportStatus | 7 | ||
| cRoles | 416 | Roles assigned to user | Use in setting permissions |
| cRoleType | Roles for permission levels | ||
| cScreenOrder | Not required | ||
| cSource | |||
| cStandardDocs | |||
| cStatus | |||
| cSubTeam | 28 | ||
| cSubTeamGroup | 0 | Assume not used | |
| cTeam | |||
| cTerminationReason | |||
| cTitle | |||
| cUsers | |||
| cUserSubTeams | |||
| cYearPrefix | 2 |