Current View: | Related.MDB:viewChildren | ||||
Record Count: | 7 | (Deleted records excluded) | Date: | 3/3/2010 7:06:56 PM |
Child Name | Child Birthdate | Child HIV Positive at 18 Months? | UniqueKey | RecStatus | FKey |
---|---|---|---|---|---|
Tom | 11-11-2000 | No | 1 | 1 | 1 |
Mary | 11-11-2002 | No | 2 | 1 | 1 |
Ralph | 01-01-2004 | Yes | 3 | 1 | 1 |
Rene | 11-11-2001 | No | 4 | 1 | 2 |
Leila | 01-01-2004 | No | 5 | 1 | 4 |
Jose | 01-01-2003 | No | 6 | 1 | 5 |
Matilda | 01-01-2004 | No | 7 | 1 | 5 |
Current View: | Related.MDB:viewChildren | ||||
Relate: | viewMOTHER | ||||
Record Count: | 7 | (Deleted records excluded) | Date: | 3/3/2010 7:06:56 PM |
Line | Child Name | Child Birthdate | Child HIV Positive at 18 Months? | Mother Record Number | Mother Birthdate | UniqueKey |
---|---|---|---|---|---|---|
1 | Tom | 11-11-2000 | No | 1 | 11-11-1980 | 1 |
2 | Mary | 11-11-2002 | No | 1 | 11-11-1980 | 2 |
3 | Ralph | 01-01-2004 | Yes | 1 | 11-11-1980 | 3 |
4 | Rene | 11-11-2001 | No | 2 | 11-11-1982 | 4 |
5 | Leila | 01-01-2004 | No | 44 | 11-11-1990 | 5 |
6 | Jose | 01-01-2003 | No | 555 | 11-11-1985 | 6 |
7 | Matilda | 01-01-2004 | No | 555 | 11-11-1985 | 7 |
Line | RecStatus | FKey | UniqueKey | RecStatus |
---|---|---|---|---|
1 | 1 | 1 | 1 | 1 |
2 | 1 | 1 | 1 | 1 |
3 | 1 | 1 | 1 | 1 |
4 | 1 | 2 | 2 | 1 |
5 | 1 | 4 | 4 | 1 |
6 | 1 | 5 | 5 | 1 |
7 | 1 | 5 | 5 | 1 |
Line | Child Name | Child Birthdate | Child HIV Positive at 18 Months? | Mother Record Number | Mother Birthdate | UniqueKey |
---|---|---|---|---|---|---|
1 | Tom | 11-11-2000 | No | 1 | 11-11-1980 | 1 |
2 | Mary | 11-11-2002 | No | 1 | 11-11-1980 | 2 |
3 | Ralph | 01-01-2004 | Yes | 1 | 11-11-1980 | 3 |
4 | Rene | 11-11-2001 | No | 2 | 11-11-1982 | 4 |
5 | Leila | 01-01-2004 | No | 44 | 11-11-1990 | 5 |
6 | Jose | 01-01-2003 | No | 555 | 11-11-1985 | 6 |
7 | Matilda | 01-01-2004 | No | 555 | 11-11-1985 | 7 |
Line | RecStatus | FKey | UniqueKey | RecStatus | MOTHERAGE |
---|---|---|---|---|---|
1 | 1 | 1 | 1 | 1 | 20 |
2 | 1 | 1 | 1 | 1 | 22 |
3 | 1 | 1 | 1 | 1 | 23 |
4 | 1 | 2 | 2 | 1 | 19 |
5 | 1 | 4 | 4 | 1 | 13 |
6 | 1 | 5 | 5 | 1 | 17 |
7 | 1 | 5 | 5 | 1 | 18 |
Current View: | NewRelated.MDB:MotherChildAge | ||||
Record Count: | 7 | Date: | 3/3/2010 7:06:56 PM |
Line | ChildName | ChildBirthdate | ChildHivPositive | MotherRecord | MotherBirthdate | FKey |
---|---|---|---|---|---|---|
1 | Tom | 11/11/2000 | No | 1 | 11/11/1980 | 1 |
2 | Mary | 11/11/2002 | No | 1 | 11/11/1980 | 1 |
3 | Ralph | 1/1/2004 | Yes | 1 | 11/11/1980 | 1 |
4 | Rene | 11/11/2001 | No | 2 | 11/11/1982 | 2 |
5 | Leila | 1/1/2004 | No | 44 | 11/11/1990 | 4 |
6 | Jose | 1/1/2003 | No | 555 | 11/11/1985 | 5 |
7 | Matilda | 1/1/2004 | No | 555 | 11/11/1985 | 5 |
Line | RecStatus | MOTHER_RecStatus | UniqueKey | MOTHERAGE |
---|---|---|---|---|
1 | Yes | Yes | 1 | 20 |
2 | Yes | Yes | 1 | 22 |
3 | Yes | Yes | 1 | 23 |
4 | Yes | Yes | 2 | 19 |
5 | Yes | Yes | 4 | 13 |
6 | Yes | Yes | 5 | 17 |
7 | Yes | Yes | 5 | 18 |
Current View: | Related.MDB:viewMOTHER | ||||
Relate: | viewLabTests | ||||
Record Count: | 9 | (Deleted records excluded) | Date: | 3/3/2010 7:06:57 PM |
Line | Mother Record Number | Mother Birthdate | Lab Test Date | Lab HIV Antibody Present? | UniqueKey | RecStatus |
---|---|---|---|---|---|---|
1 | 1 | 11-11-1980 | 11-11-2000 | No | 1 | 1 |
2 | 1 | 11-11-1980 | 11-11-2002 | No | 1 | 1 |
3 | 1 | 11-11-1980 | 11-11-2003 | No | 1 | 1 |
4 | 1 | 11-11-1980 | 01-01-2004 | Yes | 1 | 1 |
5 | 2 | 11-11-1982 | 11-11-2001 | No | 2 | 1 |
6 | 3 | 11-11-1979 | 11-11-2001 | No | 3 | 1 |
7 | 44 | 11-11-1990 | 01-01-2004 | Yes | 4 | 1 |
8 | 555 | 11-11-1985 | 01-01-2003 | Yes | 5 | 1 |
9 | 555 | 11-11-1985 | 02-02-2004 | Yes | 5 | 1 |
Line | UniqueKey | RecStatus | FKey |
---|---|---|---|
1 | 1 | 1 | 1 |
2 | 2 | 1 | 1 |
3 | 3 | 1 | 1 |
4 | 4 | 1 | 1 |
5 | 5 | 1 | 2 |
6 | 6 | 1 | 3 |
7 | 7 | 1 | 4 |
8 | 8 | 1 | 5 |
9 | 9 | 1 | 5 |
Current View: | Related.MDB:viewMOTHER | ||||
Relate: | viewLabTests | ||||
Select: | LabHivAntibody = (+) | ||||
Record Count: | 4 | (Deleted records excluded) | Date: | 3/3/2010 7:06:57 PM |
Current View: | Related.MDB:viewMOTHER | ||||
Record Count: | 6 | (Deleted records excluded) | Date: | 3/3/2010 7:06:57 PM |
Mother Record Number | Mother Birthdate | UniqueKey | RecStatus |
---|---|---|---|
1 | 11-11-1980 | 1 | 1 |
2 | 11-11-1982 | 2 | 1 |
3 | 11-11-1979 | 3 | 1 |
44 | 11-11-1990 | 4 | 1 |
555 | 11-11-1985 | 5 | 1 |
- | - | 6 | 1 |
Current View: | Related.MDB:viewMOTHER | ||||
Relate: | FirstHIVPosDate | ||||
Record Count: | 6 | (Deleted records excluded) | Date: | 3/3/2010 7:06:57 PM |
Mother Record Number | Mother Birthdate | MotherRecord | FirstHIVPosDate | UniqueKey | RecStatus |
---|---|---|---|---|---|
1 | 11-11-1980 | 1 | 1/1/2004 | 1 | 1 |
2 | 11-11-1982 | - | - | 2 | 1 |
3 | 11-11-1979 | - | - | 3 | 1 |
44 | 11-11-1990 | 44 | 1/1/2004 | 4 | 1 |
555 | 11-11-1985 | 555 | 1/1/2003 | 5 | 1 |
- | - | - | - | 6 | 1 |
Current View: | NewRelated.MDB:MotherPosDate | ||||
Relate: | MotherChildAge | ||||
Select: | ChildBirthdate >= FirstHIVPosDate | ||||
Record Count: | 24 | Date: | 3/3/2010 7:06:58 PM |
ChildHivPositive | Frequency | Percent | Cum Percent | |
Yes | 6 | 25.0% | 25.0% | |
No | 18 | 75.0% | 100.0% | |
Total | 24 | 100.0% | 100.0% |