FC21. Father’s Death FCDeathType FATHER.DEATH_REASON_TEXT>LONG_TEXT Circumstances Type FC22. Father’s Military FCMilitaryStatus FATHER.MILITARY_STATUS_CODE 1 Status FC23. Father’s FCImmigration description) Immigration Status FC24. Father’s Marriage FCMarriageBeginDate FATHER > MARITAL_COHABITATION_HISTORY(where MARRIED_CODE = YES).BEGIN_DATE Beginning Date FC25. Father’s Marriage FCMarriageEndDate FATHER > MARITAL_COHABITATION_HISTORY(where MARRIED_CODE = YES). END_DATE Termination Date FC26. Father’s Marriage FCMarriageTermType FATHER > MARITAL_COHABITATION_HISTORY(where MARRIED_CODE = YES). Termination Type MARRIAGE_TERMINATION_TYPE(short description) FC27. Father’s Parental FCRightsEffectvDate FATHER>PTRNYDET(where PATERNITY_ESTABLISHED_CODE = Alleged father is Legal father and FKCHLD_CLT = Rights Effective CLIENT.ID). PATERNITY_HEARING_DATE Date (formerly named) FCRightsEffectiveDate FC28. Father’s Parental FCRightsTermDate FATHER>PARENTAL_RIGHT_TERMINATION(where CLIENT = FKCHLD_CLT).Date Rights Termination FC29. Father’s Attorney FCAttorney FATHER End_Date = NULL)> ATTORNEY.(First Name + MIDDLE_INITIAL_NAME + Last Name Name) FC29a Father's Attorney's FCAttrnyEmailAddress FATHER > CLIENT_ATTORNEY (where End_Date = NULL) > ATTORNEY.Email_Address SCR 8341 E-mail Address (R6.3) (formerly named) FCAttorneyEmailAddress 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 GCID GUARDIAN.Id Convert to 22 character format. Number
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.
111415_County%20_Templates.docx