| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| SPBPERS_ACTIVE_DUTY_SEPR_DATE |
TBD |
NO |
|
|
|
|
|
| SPBPERS_BIRTH_DATE |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON |
BIRTH_DATE |
NO |
NA |
| SPBPERS_CITZ_CODE |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON |
CITIZENSHIP_TYPE |
NO |
NA |
| SPBPERS_CITZ_IND |
STVCITZ |
NO |
|
|
|
|
NA |
| SPBPERS_CONFID_IND |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON |
CONFIDENTIALITY_IND |
NO |
NA |
| SPBPERS_CONFIRMED_RE_CDE |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON |
RACE_ETHNICITY_CONFIRM_IND |
NO |
NA |
| SPBPERS_CONFIRMED_RE_DATE |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON |
RACE_ETHNICITY_CONFIRM_DATE |
NO |
NA |
| SPBPERS_DEAD_DATE |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON |
DECEASED_DATE |
NO |
NA |
| SPBPERS_DEAD_IND |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON AA_ORGANIZATION_CONTACT |
DECEASED_STATUS CONTACT_DECEASED_IND |
NO NO |
NA |
| SPBPERS_ETHN_CDE |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON |
HISPANIC_LATINO_ETHNICITY_IND |
NO |
|
| SPBPERS_ETHN_CODE |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON |
PRIMARY_ETHNICITY |
NO |
NA |
| SPBPERS_GNDR_CODE |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON |
GENDER_DESIGNATION |
NO |
NA |
| SPBPERS_LEGAL_NAME |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON |
LEGAL_NAME |
NO |
NA |
| SPBPERS_LGCY_CODE |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON |
LEGACY |
NO |
NA |
| SPBPERS_MRTL_CODE |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON |
MARITAL_STATUS |
NO |
NA |
| SPBPERS_NAME_PREFIX |
SPAPERS |
NO |
COMPOSITE VIEW |
AT_ACCOUNT AS_PERSON AA_ORGANIZATION_CONTACT |
NAME_PREFIX NAME_PREFIX CONTACT_NAME_PREFIX |
NO NO NO |
NA |
| SPBPERS_NAME_SUFFIX |
SPAPERS |
NO |
COMPOSITE VIEW |
AT_ACCOUNT AS_PERSON AA_ORGANIZATION_CONTACT |
NAME_SUFFIX NAME_SUFFIX CONTACT_NAME_SUFFIX |
NO NO NO |
NA |
| SPBPERS_PIDM |
NA |
NO |
|
|
|
|
NA |
| SPBPERS_PPRN_CODE |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON |
PERSONAL_PRONOUN |
NO |
NA |
| SPBPERS_PREF_FIRST_NAME |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON |
PREFERRED_FIRST_NAME |
NO |
NA |
| SPBPERS_RELG_CODE |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON |
RELIGION |
NO |
NA |
| SPBPERS_SDVET_IND |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON |
VETERAN_SPECIAL_DISABLED_IND |
NO |
NA |
| SPBPERS_SEX |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON |
GENDER |
NO |
NA |
| SPBPERS_SSN |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON AA_RELATIONSHIP AT_ACCOUNT |
TAX_ID RELATED_CHILD_TAX_ID SSN |
NO NO NO |
NA |
| SPBPERS_VERA_IND |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON |
VETERAN_CATEGORY |
NO |
NA |
| SPBPERS_VETC_FILE_NUMBER |
SPAPERS |
NO |
COMPOSITE VIEW |
AS_PERSON |
VETERAN_FILE_NO |
NO |
NA |