Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
SPBPERS_ACTIVE_DUTY_SEPR_DATE |
TBD |
NO |
REPORTING VIEW |
PERSON_DETAIL PERSON_VETERAN PERSON |
MILITARY_SEPARATION_DATE MILITARY_SEPARATION_DATE MILITARY_SEPARATION_DATE |
NO NO NO |
|
SPBPERS_BIRTH_DATE |
SPAPERS |
NO |
REPORTING VIEW |
GOVERNMENT_FINANCIAL_AID CONSTITUENT_ENTITY PERSON_DETAIL GOVERNMENT_STUDENT PERSON_SENSITIVE PERSON_VETERAN GOVERNMENT_ADMISSIONS PERSON RELATIONSHIP GOVERNMENT_ACADEMIC_OUTCOME |
BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE BIRTH_DATE RELATED_BIRTH_DATE BIRTH_DATE |
NO NO NO NO NO NO NO NO NO NO |
NA |
SPBPERS_CITZ_CODE |
SPAPERS |
NO |
REPORTING VIEW |
PERSON_INTERNATIONAL PERSON PERSON_DETAIL GOVERNMENT_STUDENT |
CITIZENSHIP_TYPE CITIZENSHIP_TYPE CITIZENSHIP_TYPE CITIZENSHIP_TYPE |
NO NO NO NO |
NA |
SPBPERS_CITZ_IND |
STVCITZ |
NO |
REPORTING VIEW |
GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT |
CITIZENSHIP_IND CITIZENSHIP_IND |
NO NO |
NA |
SPBPERS_CONFID_IND |
SPAPERS |
NO |
REPORTING VIEW |
CONSTITUENT PERSON PERSON_VETERAN PERSON_DETAIL |
CONFIDENTIALITY_IND CONFIDENTIALITY_IND CONFIDENTIALITY_IND CONFIDENTIALITY_IND |
NO NO NO NO |
NA |
SPBPERS_CONFIRMED_RE_CDE |
SPAPERS |
NO |
REPORTING VIEW |
GOVERNMENT_STUDENT PERSON PERSON_DETAIL GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ADMISSIONS PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID |
RACE_ETHNICITY_CONFIRM_IND RACE_ETHNICITY_CONFIRM_IND RACE_ETHNICITY_CONFIRM_IND RACE_ETHNICITY_CONFIRM_IND RACE_ETHNICITY_CONFIRM_IND RACE_ETHNICITY_CONFIRM_IND RACE_ETHNICITY_CONFIRM_IND |
NO NO NO NO NO NO NO |
NA |
SPBPERS_CONFIRMED_RE_DATE |
SPAPERS |
NO |
REPORTING VIEW |
GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME PERSON_SENSITIVE GOVERNMENT_STUDENT PERSON_DETAIL GOVERNMENT_ADMISSIONS PERSON |
RACE_ETHNICITY_CONFIRM_DATE RACE_ETHNICITY_CONFIRM_DATE RACE_ETHNICITY_CONFIRM_DATE RACE_ETHNICITY_CONFIRM_DATE RACE_ETHNICITY_CONFIRM_DATE RACE_ETHNICITY_CONFIRM_DATE RACE_ETHNICITY_CONFIRM_DATE |
NO NO NO NO NO NO NO |
NA |
SPBPERS_DEAD_DATE |
SPAPERS |
NO |
REPORTING VIEW |
PERSON_INTERNATIONAL PERSON PLEDGE GIFT PERSON_DETAIL RELATIONSHIP PERSON_VETERAN |
DECEASED_DATE DECEASED_DATE DECEASED_DATE DECEASED_DATE DECEASED_DATE RELATED_DECEASED_DATE DECEASED_DATE |
NO NO NO NO NO NO NO |
NA |
SPBPERS_DEAD_IND |
SPAPERS |
NO |
REPORTING VIEW |
ORGANIZATION_CONTACT CONSTITUENT PERSON_VETERAN GIFT PERSON CONSTITUENT_ENTITY PERSON_DETAIL PERSON_INTERNATIONAL RELATIONSHIP PLEDGE |
CONTACT_DECEASED_IND DECEASED_IND DECEASED_STATUS DECEASED_STATUS DECEASED_STATUS DECEASED_IND DECEASED_STATUS DECEASED_STATUS RELATED_DECEASED_IND DECEASED_STATUS |
NO NO NO NO NO NO NO NO NO NO |
NA |
SPBPERS_ETHN_CDE |
SPAPERS |
NO |
REPORTING VIEW |
GOVERNMENT_STUDENT PERSON_DETAIL GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ADMISSIONS PERSON PERSON_SENSITIVE |
HISPANIC_LATINO_ETHNICITY_IND HISPANIC_LATINO_ETHNICITY_IND HISPANIC_LATINO_ETHNICITY_IND HISPANIC_LATINO_ETHNICITY_IND HISPANIC_LATINO_ETHNICITY_IND HISPANIC_LATINO_ETHNICITY_IND |
NO NO NO NO NO NO |
|
SPBPERS_ETHN_CODE |
SPAPERS |
NO |
REPORTING VIEW |
GOVERNMENT_ADMISSIONS PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID GOVERNMENT_FINANCIAL_AID PERSON_DETAIL GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT GOVERNMENT_FINANCIAL_AID PERSON |
PRIMARY_ETHNICITY PRIMARY_ETHNICITY HISPANIC_LATINO_ETHNICITY_IND PRIM_ETHNICITY_CATEGORY PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY PRIMARY_ETHNICITY |
NO NO NO NO NO NO NO NO NO |
NA |
SPBPERS_GNDR_CODE |
SPAPERS |
NO |
REPORTING VIEW |
GOVERNMENT_ADMISSIONS PERSON_DETAIL PERSON GOVERNMENT_STUDENT CONSTITUENT PERSON_SENSITIVE GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_FINANCIAL_AID |
GENDER_DESIGNATION GENDER_DESIGNATION GENDER_DESIGNATION GENDER_DESIGNATION GENDER_DESIGNATION GENDER_DESIGNATION GENDER_DESIGNATION GENDER_DESIGNATION |
NO NO NO NO NO NO NO NO |
NA |
SPBPERS_LEGAL_NAME |
SPAPERS |
NO |
REPORTING VIEW |
PERSON PERSON_DETAIL |
LEGAL_NAME LEGAL_NAME |
NO NO |
NA |
SPBPERS_LGCY_CODE |
SPAPERS |
NO |
REPORTING VIEW |
PERSON_DETAIL PERSON PERSON_SENSITIVE |
LEGACY LEGACY LEGACY |
NO NO NO |
NA |
SPBPERS_MRTL_CODE |
SPAPERS |
NO |
REPORTING VIEW |
CONSTITUENT PERSON PERSON_INTERNATIONAL PERSON_DETAIL RELATIONSHIP PERSON_SENSITIVE |
MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS MARITAL_STATUS |
NO NO NO NO NO NO |
NA |
SPBPERS_NAME_PREFIX |
SPAPERS |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT PERSON_DETAIL CONSTITUENT_ENTITY PERSON ORGANIZATION_CONTACT RELATIONSHIP |
NAME_PREFIX NAME_PREFIX NAME_PREFIX NAME_PREFIX CONTACT_NAME_PREFIX RELATED_PREFIX |
NO NO NO NO NO NO |
NA |
SPBPERS_NAME_SUFFIX |
SPAPERS |
NO |
REPORTING VIEW |
CONSTITUENT RECEIVABLE_ACCOUNT PERSON PERSON_DETAIL CONSTITUENT_ENTITY ORGANIZATION_CONTACT RELATIONSHIP |
NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX NAME_SUFFIX CONTACT_NAME_SUFFIX RELATED_SUFFIX |
NO NO NO NO NO NO NO |
NA |
SPBPERS_PIDM |
NA |
NO |
REPORTING VIEW |
PERSON MEDICAL_INFORMATION_SLOT PERSON_ADDRESS PERSON_INTERNATIONAL PERSON_SENSITIVE PERSON_VETERAN ORGANIZATION_ENTITY_ADDRESS |
PERSON_UID PERSON_UID PERSON_UID PERSON_UID PERSON_UID PERSON_UID ENTITY_UID |
NO NO NO NO NO NO NO |
NA |
SPBPERS_PPRN_CODE |
SPAPERS |
NO |
REPORTING VIEW |
CONSTITUENT GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT GOVERNMENT_ADMISSIONS PERSON PERSON_DETAIL GOVERNMENT_FINANCIAL_AID PERSON_SENSITIVE |
PERSONAL_PRONOUN PERSONAL_PRONOUN PERSONAL_PRONOUN PERSONAL_PRONOUN PERSONAL_PRONOUN PERSONAL_PRONOUN PERSONAL_PRONOUN PERSONAL_PRONOUN |
NO NO NO NO NO NO NO NO |
NA |
SPBPERS_PREF_FIRST_NAME |
SPAPERS |
NO |
REPORTING VIEW |
PERSON PERSON_DETAIL |
PREFERRED_FIRST_NAME PREFERRED_FIRST_NAME |
NO NO |
NA |
SPBPERS_RELG_CODE |
SPAPERS |
NO |
REPORTING VIEW |
PERSON_SENSITIVE PERSON PERSON_DETAIL |
RELIGION RELIGION RELIGION |
NO NO NO |
NA |
SPBPERS_SDVET_IND |
SPAPERS |
NO |
REPORTING VIEW |
STUDENT_EXTENDED PERSON PERSON_DETAIL PERSON_VETERAN STUDENT VETERAN_CERTIFICATION |
VETERAN_SPECIAL_DISABLED_IND VETERAN_SPECIAL_DISABLED_IND VETERAN_SPECIAL_DISABLED_IND VETERAN_SPECIAL_DISABLED_IND VETERAN_SPECIAL_DISABLED_IND VETERAN_SPECIAL_DISABLED_IND |
NO NO NO NO NO NO |
NA |
SPBPERS_SEX |
SPAPERS |
NO |
REPORTING VIEW |
GOVERNMENT_ADMISSIONS PERSON PERSON_DETAIL PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT RELATIONSHIP CONSTITUENT |
GENDER GENDER GENDER GENDER GENDER GENDER GENDER RELATED_GENDER GENDER |
NO NO NO NO NO NO NO NO NO |
NA |
SPBPERS_SSN |
SPAPERS |
NO |
REPORTING VIEW |
CROSS_REFERENCE_SLOT CROSS_REFERENCE_SLOT PERSON_INTERNATIONAL PERSON_SENSITIVE GOVERNMENT_FINANCIAL_AID CROSS_REFERENCE_SLOT CROSS_REFERENCE_SLOT PERSON PERSON_VETERAN ORGANIZATION_ENTITY PERSON_DETAIL RELATIONSHIP RECEIVABLE_ACCOUNT CROSS_REFERENCE_SLOT |
RELATED_TAX_ID1 RELATED_TAX_ID2 TAX_ID TAX_ID TAX_ID RELATED_TAX_ID3 RELATED_TAX_ID5 TAX_ID TAX_ID TAX_ID TAX_ID RELATED_CHILD_TAX_ID TAX_ID RELATED_TAX_ID4 |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
NA |
SPBPERS_VERA_IND |
SPAPERS |
NO |
REPORTING VIEW |
STUDENT PERSON_VETERAN VETERAN_CERTIFICATION PERSON STUDENT_EXTENDED PERSON_DETAIL |
VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY VETERAN_CATEGORY |
NO NO NO NO NO NO |
NA |
SPBPERS_VETC_FILE_NUMBER |
SPAPERS |
NO |
REPORTING VIEW |
STUDENT PERSON_DETAIL STUDENT_EXTENDED VETERAN_CERTIFICATION PERSON_VETERAN PERSON |
VETERAN_FILE_NO VETERAN_FILE_NO VETERAN_FILE_NO VETERAN_FILE_NO VETERAN_FILE_NUMBER VETERAN_FILE_NUMBER |
NO NO NO NO NO NO |
NA |