Definitions of data acknowledgments, identifying the contributor, their role and condition

Table ID:
G_CREDIT_ACK     (57959)
Contents:
Definitions of data acknowledgments, identifying the contributor, their role and condition
Approx. number of rows:
12
Table type:
Documentation
Documentation Author:
Humphrey Southall
Chronology:
The data cover the period 1881 to 1911.

Notes:

  1. Rows in this table identify specific contributions to the statistical database: who made them, what their role was, and what conditions are consequently associated with the particular data values; all of these are defined in other tables.
  2. the system is designed to enable more than one contributor to be associated with a given data value, so for example one person may have transcribed a historical source onto paper, and then a second person computerised the data. For this reason, a given credit as defined in the g_credit table may link to more then one acknowledgment as defined here.


Indices:

IndexTypeColumn(s) indexed
g_credit_ack_pk Primary key g_credit_ack


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
g_credit_ack_pk Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
g_credit_ack Text string (max.len.=28). Credit identifier, usually combining a contributor ID and an indication of the source; for example 'GATLEYD_age_reg' or 'DEFRA_farm'.
g_seq Integer number. Sequence number, automatically inserted.
g_credit Text string (max.len.=28). Identifier for the credit this acknowledgment forms part of, these credit values being what actually appear in the data table.
g_credit_contributor Text string (max.len.=24). Identifier for the contributor, whether an individual or an organisation..
g_credit_role Text string (max.len.=7). Role of the contributor in creating the data value linked to.
condition_for_item Text string (max.len.=104). Condition applied to individual data item.
condition_for_dataset Text string (max.len.=104). Condition applied to data set as a whole. Both conditions should be specified, the assumption being that restrictions on whole data sets will be the same as or stricter than conditions on individual data items.
ack_text Long text. Optional text going into greater detail of the contribution, intended to appear on the public web site.
notes Long text. Comments, not intended for public display.