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)
APPLICANT sECTION: For Adoptive Child Clients CLIENT > ADOPTIVE_CHILD_CLIENT> ADOPTIVE_PLACEMENT>ADOPTION_HOME_STUDY > PLACEMENT_HOME_SUB_CARE_PROVID > SUBSTITUTE_CARE_PROVIDER SUBSTITUTE_CARE_PROVIDER parameter is used for items 168 thru 177 If more than one, the user must choose from a list displayed using a dialog box. AP1. Applicant’s Last Name APLastName SUBSTITUTE_CARE_PROVIDER. LAST_NAME AP2. Applicant’s First Name APFirstName SUBSTITUTE_CARE_PROVIDER. FIRST_NAME AP3. Applicant’s Middle Initial APMiddleInitial SUBSTITUTE_CARE_PROVIDER. MIDDLE_INITIAL_NAME AP4. Applicant’s Gender APGender SUBSTITUTE_CARE_PROVIDER. GENDER_IND AP5. Applicant’s Street Number APStreetNumber SUBSTITUTE_CARE_PROVIDER. STREET_NUMBER AP6. Applicant’s Street Name APStreetName SUBSTITUTE_CARE_PROVIDER. STREET_NAME AP7. Applicant’s City Name APCityName SUBSTITUTE_CARE_PROVIDER. CITY_NAME AP8. Applicant’s State APState SUBSTITUTE_CARE_PROVIDER. STATE_CODE_TYPE(Short Description) AP9. Applicant’s Zip Number APZipNumber SUBSTITUTE_CARE_PROVIDER. ZIP_NUMBER AP10. Applicant’s Zip Suffix Number APZipSuffix SUBSTITUTE_CARE_PROVIDER. ZIP_SUFFIX_NUMBER AP10a. Applicant's E-mail Address APEmailAddress SUBSTITUTE__PROVIDER.Email_Address SCR 8341 (R6.3) AP11. Applicant’s Date APBirthDate SUBSTITUTE_CARE_PROVIDER. BIRTH_DATE PRIMARY SUBSTITUTE CARE PROVIDER CLIENT > PLACEMENT_EPISODE (where end_date = null) > OUT_OF_HOME_PLACEMENT where ((.End_Date > System Date), if it exists, else .End_Date = null) > PLACEMENT_HOME > PLACEMENT_HOME_SUBSTITUTE_CARE_PROVIDER (where . PRIMARY_PROVIDER_IND = Y and .End_Date = null) > SUBSTITUTE_CARE_PROVIDER SUBSTITUTE_CARE_PROVIDER parameter is used for items PP1 thru PP13
SP1. Secondary SCP Last Name SPLastName SUBSTITUTE_CARE_PROVIDER. LAST_NAME SP2. Secondary SCP Name SPFirstName SUBSTITUTE_CARE_PROVIDER. FIRST_NAME SP3. Secondary SCP Middle Initial SPMiddleInitial SUBSTITUTE_CARE_PROVIDER. MIDDLE_INITIAL_NAME SP4. Secondary SCP Gender SPGender SUBSTITUTE_CARE_PROVIDER. GENDER_IND SP5. Secondary SCP Street Number SPStreetNumber SUBSTITUTE_CARE_PROVIDER. STREET_NUMBER SP66. Secondary SCP Street Name SPStreetName SUBSTITUTE_CARE_PROVIDER. STREET_NAME SP7. Name SPCityName SUBSTITUTE_CARE_PROVIDER. CITY_NAME SP8. SPState SUBSTITUTE_CARE_PROVIDER. STATE_CODE_TYPE(Short Description) SP9. Secondary SCP Zip Number SPZipNumber SUBSTITUTE_CARE_PROVIDER. ZIP_NUMBER SP10 Secondary SCP Zip Suffix Number SPZipSuffix SUBSTITUTE_CARE_PROVIDER. ZIP_SUFFIX_NUMBER SP11 Secondary SCP Phone SPPhone SUBSTITUTE__PROVIDER > PHONE_CONTACT_DETAIL (where .Established_For_Code = 'S' and .Established_For_Id = SUBSTITUTE_CARE_IDER.Id) .Phone_Number + .Phone_Extension_Number. If more than one number exists, then print the first number found according to the following hierarchy: .Phone_Number_Type_Code = 'C', 'A', 'H', 'W', 'F'. SCR 8341 (R6.3) SP11a. Secondary 's Address SPEmailAddress SUBSTITUTE__PROVIDER.Email_Address SCR 8341 (R6.3) SP12 Secondary SCP DOB SPBirthDate SUBSTITUTE_CARE_PROVIDER. BIRTH_DATE SP13 Secondary SCP SSN SPSSN SUBSTITUTE_CARE_PROVIDER. SOCIAL_SECURITY_NUMBER ATTORNEY SECTION: CLIENT(child client) > CLIENT_ATTORNEY>ATTORNEY ATTORNEY parameter used for items AT1 thru AT9 AT1 Attorney # ATPhone ATTORNEY.P_P_N