FC21. Father’s Death Circumstances Type FCDeathType FATHER.DEATH_REASON_TEXT>LONG_TEXT FC22. Father’s Military Status FCMilitaryStatus FATHER.MILITARY_STATUS_CODE 1 FC23. Father’s Immigration Status FCImmigration description) FC24. Father’s Marriage Beginning Date FCMarriageBeginDate FATHER > MARITAL_COHABITATION_HISTORY(where MARRIED_CODE = YES).BEGIN_DATE FC25. Father’s Marriage Termination Date FCMarriageEndDate FATHER > MARITAL_COHABITATION_HISTORY(where MARRIED_CODE = YES). END_DATE FC26. Father’s Marriage Termination Type FCMarriageTermType FATHER > MARITAL_COHABITATION_HISTORY(where MARRIED_CODE = YES). MARRIAGE_TERMINATION_TYPE(short description) FC27. Father’s Parental Rights Effective Date FCRightsEffectvDate (formerly named) FCRightsEffectiveDate FATHER>PTRNYDET(where PATERNITY_ESTABLISHED_CODE = Alleged father is Legal father and FKCHLD_CLT = CLIENT.ID). PATERNITY_HEARING_DATE FC28. Father’s Parental Rights Termination FCRightsTermDate FATHER>PARENTAL_RIGHT_TERMINATION(where CLIENT = FKCHLD_CLT).Date FC29. Father’s Attorney Name FCAttorney FATHER End_Date = NULL)> ATTORNEY.(First Name + MIDDLE_INITIAL_NAME + Last Name) FC29a Father's Attorney's E-mail Address FCAttrnyEmailAddress (formerly named) FCAttorneyEmailAddress FATHER > CLIENT_ATTORNEY (where End_Date = NULL) > ATTORNEY.Email_Address SCR 8341 (R6.3) PTS 24602 (R7.0.1) GUARDIAN - as derived by: CLIENT > CLIENT RELATIONSHIP(Primary or Secondary where end date is null) >CLIENT (Legal Guardian) where .CLIENT RELATIONSHIP.Client Relationship Type starts with 'Guardian/', and the child is identified as the secondary individual, OR .Client Relationship contains '/Guardian' (i.e., ' LEGAL GUARDIAN' is the second part of the relationship), and the child is identified as the primary individual. GUARDIAN is the CLIENT Guardian) and is used for items 83 thru 99 GC1. Guardian Client ID Number GCID GUARDIAN.Id Convert to 22 character format.
MC27. Mother’s Parental Rights Termination MCRightsTermDate MOTHER > CLIENT = FKCHLD_CLT).Date MC28. Mother’s Attorney Name MCAttorney MOTHER >CLIENT_ATTORNEY(where End_Date = NULL)> ATTORNEY.(First Name + MIDDLE_INITIAL_NAME + Last Name) MC28a. Mother's Attorney's E-mail Address MCAttrnyEmailAddress (formerly named) MCAttorneyEmailAddress MOTHER > CLIENT_ATTORNEY (where End_Date = NULL) > ATTORNEY.Email_Address SCR 8341 (R6.3) PTS 24602 (R7.0.1) perpetrator - as derived by: REFERRAL (where REFERRAL.Id = Passed Parameter) > (all) ALLEGATION >CLIENT> (Named_As_Perpetrator) NOTE: Only use substantiated and Inconclusive allegations where the allegation is NOT for ‘General Neglect’ or ‘Caretaker Absence’. If more than one, the user must choose from a list displayed using a dialog box. PERPETR is the CLIENT (Alleged Perpetr) and is used for items 130 thru 145 PC1. Perpetrator Client ID Number PCID PERPETR.Id Convert to 22 character format. PC2. Perpetrator’s First Name PCFirstName PERPETR.Common First Name PC3. Perpetrator’s Middle Name PCMiddleName PERPETR.Common Middle Name PC4. Perpetrator’s Last Name PCLastName PERPETR.Common Last Name PC5. Perpetrator’s Date of PCBirthDate PERPETR. (where .Estimated_DOB_Code != Y).Birth Date else leave blank. PC6. Perpetrator’s SSN PCSSN PERPETR.Social Security Number PC7. Perpetrator’s Driver License Number PCLicenseNumber PERPETR.DRIVER_LICENSE_NUMBER PC8. Perpetrator’s Primary Language PCPriLanguage PERPETR.PRIMARY_LANGUAGE_TYPE(short description) PC10. Perpetrator’s AKA PCAKA PERPETR >OTHER_CLIENT_NAME. NAME_PREFIX_DESCRIPTION + FIRST_NAME + MIDDLE_NAME + LAST_NAME + SUFFIX_TITLE_DESCRIPTION Note: If more than one name, separate names with carriage return.