|
|
|
|
Association table schema definition
The principal difference between mappings for an association and mappings for other trial objects is that the schema definition of the CDD table for an association is fixed; you do not create table column mapping definitions. When you create an association mapping definition, the InForm Architect application generates a table with the following columns:
Column |
Definition |
|---|---|
PageAssocID: numeric |
Primary key of the association mapping table |
PageID_1: numeric |
ID of the first CRF in the association. |
PageIndex_1: float |
Index of the instance of the first CRF. |
VisitID_1: numeric |
ID of the visit in which the first CRF occurs. |
VisitIndex_1: numeric |
Visit index of the visit in which the first CRF occurs |
PageID_2: numeric |
ID of the second CRF in the association. |
PageIndex_2: float |
Index of the instance of the second CRF. |
VisitID_2: numeric |
ID of the visit in which the second CRF occurs. |
VisitIndex_2: numeric |
Visit index of the visit in which the second CRF occurs |
State: numeric |
Status of the association:
|
PatientID: numeric |
ID of the patient for whom data is being transferred |
You can create an association mapping table for each association, or you can map multiple associations to the same table. Each table you create has the format described above.
