 |
Page History
The following table lists the data fields by the table in which they are recorded. It also provides the field number (field position in a row); and the format and character limits for each field.
| Tables |
|---|
| Field (Field Position in a Row) | Format (Maximum Number of Characters) | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| COLLECTIONS | Study Identifier (2) | Text (35) | ||||||||
| COLLECTIONS | Change Code (11) | Number (1) | ||||||||
| PATIENTS | Study Identifier (2) | Text (35) | ||||||||
| PATIENTS | Study Subject Identifier (3) | Text (20) | ||||||||
| PATIENTS | ZIP Code (4) | Text (10) | ||||||||
| PATIENTS | Country of Residence (5) | Text (2) | ||||||||
| PATIENTS | Patient's Date of Birth (6) | Date (YYYYMM) | ||||||||
| PATIENTS | Gender of a Person (7) | Text (10) | ||||||||
| PATIENTS | Ethnicity (8) | Text (25) | ||||||||
| PATIENTS | Payment Method (9) | Text (50) | ||||||||
| PATIENTS | Subject Registration Date (10) | Date (YYYYMMDD) | ||||||||
| PATIENTS | Registering Group Identifier (11) | Text (25) | ||||||||
| PATIENTS | Study Site Identifier (12) | Text (25) | ||||||||
| PATIENTS |
Subject Disease Code (22)
| Number (10) | ||||||||
| PATIENT_RACES | Study Identifier (2) | Text (35) | ||||||||
| PATIENT_RACES | Study Subject Identifier (3) | Text (20) | ||||||||
| PATIENT_RACES | Race (4) | Text (45) |
| Info |
|---|
The relation between COLLECTIONS, PATIENTS, and PATIENT_RACES is that COLLECTIONS can have multiple PATIENTS, and PATIENTS can have multiple PATIENT_RACES. These relations are maintained through the use of consistent Study Identifier and Study Subject Identifier fields. |
...
