Unit Title:
Electronic log of Governor Mark Sanford's constituent correspondence, 2003-2011
Accumulation:
2003-2011
Created:
2003-2011
Creator:
Governor (2003-2011: Sanford). --Constituent Services Division
Physical Description:
none
Language:
English
Biography or History:
unspecified
Custodial History:
unspecified
Acquisition Information:
Governor (2003-2011: Sanford). --Constituent Services Division
Scope and Content:
This series consists of a database used to log and track the progress of constituent correspondence received by the Governor's Office. The original database was received in FileMaker Pro 7 format and was converted to Microsoft Access 2007 for access to the public. A table of conversion errors from this process, mostly truncated fields, is located in the folders containing the exported versions of the database. The database contains one large table with over 300,000 entries. This table was then exported into comma separated value (.csv), Open Document Spreadsheet (.ods), and eXtensible Markup Language (XML) files. Due to the size of the table and Access 2007's limitations on the number of records that can be exported at time, the exported .csv and .ods files are divided into seven parts. The database lists correspondence in numerical order by the number assign to each item when it was received by the Constituent Services Division. Database fields include, but are not limited to: the constituent's name, the staff member assigned to the query, a summary of the query, whether the query is in support or opposition to specific legislation, and comments on the response from the Constituent Services Division.
Appraisal Information:
unspecified
Accruals:
no
Arrangement:
Series arranged by assigned correspondent number.
Conditions Governing Access:
Some correspondence referenced by this database may contain medical information or personal indentifying information such as Social Security Numbers and should be reviewed by staff.
Conditions Governing Use:
none
Physical Characteristics and Technical Requirements:
none
Other Finding Aid:
none
Location of Originals:
SCDAH
Alternative Form Available:
none
Related Material:
none
Bibliography:
none
Other Descriptive Data:
The correspondence indexed by this database is primarily located in S558018, Central Correspondence File. However, indexed correspondence may also be found in S558008, Order of the Palmetto Files; S558009, Order of the Silver Crescent Files; S558013, Correspondence relating to Veteran Affairs; S558014, Invitations Accepted; S558015, Invitation Regrets (sample), S558017, Holiday Cards; S166076, Magistrate Appointments; S166077, Local Foster Care Review Board Appointments; S166078, Local Board and Commission Appointments; and S166079, State Board and Commission Appointments.
Processing Information:
None
