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