GC18a. Guardian's GCAttrnyEmailAddress GUARDIAN > CLIENT_ATTORNEY (where End_Date = NULL) > ATTORNEY.Email_Address SCR 8341 Attorney's E-mail (formerly named) (R6.3) Address GCAttorneyEmailAddress PTS 24602 (R7.0.1) MOTHER - as derived by: CLIENT > CLIENT RELATIONSHIP(Primary or Secondary end date is null) >CLIENT (Mother) where .CLIENT RELATIONSHIP.Client Relationship Type starts with 'Mother/', and the child is identified as the secondary individual, OR .Client Relationship contains '/Mother' (i.e., 'Mother' is the second part of the relationship), and the child is identified as the primary individual. SCR 7605 Note: a child can have several types of Mothers, use the following search hierarchy: Adoptive, Birth, Presumed, (R6.3) Alleged, Step,. Foster parent should not be used. MOTHER is the CLIENT (Mother) and is used for items MC1 thru MC28 MC1. Mother Client ID MCID MOTHER.Id Convert to 22 character format. Number MC2. Mother’s MCFirstName MOTHER.Common Name Name MC3. Mother’s Middle MCMiddleName MOTHER.Common Middle Name Name MC4. Mother’s Last MCLastName MOTHER.Common Last Name Name MC5. Mother’s Date of MCBirthDate MOTHER. (where .Estimated_DOB_Code != Y).Birth Date else leave blank. Birth MC6. Mother’s SSN MCSSN MOTHER.Social Security Number MC7. Mother’s Driver MCLicenseNumber MOTHER.DRIVER_LICENSE_NUMBER License Number MC8. Mother’s Primary MCPriLanguage MOTHER.PRIMARY_LANGUAGE_TYPE(short description) Language MC9. Mother’s Primary MCPriEthnicity MOTHER.PRIMARY_ETHNICITY_TYPE description) Ethnicity MC9a. Mother's E-mail MCEmailAddress MOTHER.Email_Address SCR 8341 Address (R6.3)
GC18a. Guardian's Attorney's E-mail Address GCAttrnyEmailAddress (formerly named) GCAttorneyEmailAddress GUARDIAN > CLIENT_ATTORNEY (where End_Date = NULL) > ATTORNEY.Email_Address SCR 8341 (R6.3) PTS 24602 (R7.0.1) MOTHER - as derived by: CLIENT > CLIENT RELATIONSHIP(Primary or Secondary end date is null) >CLIENT (Mother) where .CLIENT RELATIONSHIP.Client Relationship Type starts with 'Mother/', and the child is identified as the secondary individual, OR .Client Relationship contains '/Mother' (i.e., 'Mother' is the second part of the relationship), and the child is identified as the primary individual. Note: a child can have several types of Mothers, use the following search hierarchy: Adoptive, Birth, Presumed, Alleged, Step,. Foster parent should not be used. MOTHER is the CLIENT (Mother) and is used for items MC1 thru MC28 SCR 7605 (R6.3) MC1. Mother Client ID Number MCID MOTHER.Id Convert to 22 character format. MC2. Mother’s Name MCFirstName MOTHER.Common Name MC3. Mother’s Middle Name MCMiddleName MOTHER.Common Middle Name MC4. Mother’s Last Name MCLastName MOTHER.Common Last Name MC5. Mother’s Date of Birth MCBirthDate MOTHER. (where .Estimated_DOB_Code != Y).Birth Date else leave blank. MC6. Mother’s SSN MCSSN MOTHER.Social Security Number MC7. Mother’s Driver License Number MCLicenseNumber MOTHER.DRIVER_LICENSE_NUMBER MC8. Mother’s Primary Language MCPriLanguage MOTHER.PRIMARY_LANGUAGE_TYPE(short description) MC9. Mother’s Primary Ethnicity MCPriEthnicity MOTHER.PRIMARY_ETHNICITY_TYPE description) MC9a. Mother's E-mail Address MCEmailAddress MOTHER.Email_Address SCR 8341 (R6.3)
County%20_Templates_Data_Elements_and_Bookmarks.docx