0EMPLOYEE_0077_ATTR

Employee - additional person data | #ATTR | Extraction method: V | No Delta | Component: Personnel Administration Master Data
Tables used: PA0077 → show details
Column Name Description
DATEFROM Start Date
DATETO End Date
PERNR FK Personnel Number
RACKY FK Ethnic origin
MILSA FK Military status
DISAB Person disabled Show values
VETST Veteran status
DISDT Date of Determination of Disability Status
ETHEN FK Ethnicity
RAC01 FK Racial Category
RAC02 FK Racial Category
RAC03 FK Racial Category
RAC04 FK Racial Category
RAC05 FK Racial Category
RAC06 FK Racial Category
RAC07 FK Racial Category
RAC08 FK Racial Category
RAC09 FK Racial Category
RAC10 FK Racial Category
VETS1 Veteran Status New
VETS2 Veteran Status New
VETS3 Veteran Status New
VETS4 Veteran Status New
VETS5 Veteran Status New
VETS6 Veteran Status New
VETS7 Veteran Status New
VETS8 Veteran Status New
VETS9 Veteran Status New
VETS10 Veteran Status New
VETS11 Veteran Status New
VETS12 Veteran Status New
DCRDT Date of Discharge
Column Name Description
Column Name Description
Column Name Description
DATEFROM Start Date
DATETO End Date
DISDT Date of Determination of Disability Status
DCRDT Date of Discharge
Column Name Description
DISAB Person disabled Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Foreign key Check for Ethnicity against T505R-RACKY
  • Ethnicity
  • Client
  • 0EMPLOYEE_0077_ATTR.ETHEN == T505R.RACKY
  • 0EMPLOYEE_0077_ATTR.MANDT == T505R.MANDT
Military status
  • Military status
  • Client
  • 0EMPLOYEE_0077_ATTR.MILSA == T505M.MILSA
  • 0EMPLOYEE_0077_ATTR.MANDT == T505M.MANDT
Personnel Number
  • Client
  • Personnel Number
  • 0EMPLOYEE_0077_ATTR.MANDT == PA0003.MANDT
  • 0EMPLOYEE_0077_ATTR.PERNR == PA0003.PERNR
Foreign key Check for Race against T505R-RACKY
  • Racial Category
  • Client
  • 0EMPLOYEE_0077_ATTR.RAC01 == T505R.RACKY
  • 0EMPLOYEE_0077_ATTR.MANDT == T505R.MANDT
Foreign key Check for Race against T505R-RACKY
  • Racial Category
  • Client
  • 0EMPLOYEE_0077_ATTR.RAC02 == T505R.RACKY
  • 0EMPLOYEE_0077_ATTR.MANDT == T505R.MANDT
Foreign key Check for Race against T505R-RACKY
  • Racial Category
  • Client
  • 0EMPLOYEE_0077_ATTR.RAC03 == T505R.RACKY
  • 0EMPLOYEE_0077_ATTR.MANDT == T505R.MANDT
Foreign key Check for Race against T505R-RACKY
  • Racial Category
  • Client
  • 0EMPLOYEE_0077_ATTR.RAC04 == T505R.RACKY
  • 0EMPLOYEE_0077_ATTR.MANDT == T505R.MANDT
Foreign key Check for Race against T505R-RACKY
  • Racial Category
  • Client
  • 0EMPLOYEE_0077_ATTR.RAC05 == T505R.RACKY
  • 0EMPLOYEE_0077_ATTR.MANDT == T505R.MANDT
Foreign key Check for Race against T505R-RACKY
  • Racial Category
  • Client
  • 0EMPLOYEE_0077_ATTR.RAC06 == T505R.RACKY
  • 0EMPLOYEE_0077_ATTR.MANDT == T505R.MANDT
Foreign key Check for Race against T505R-RACKY
  • Racial Category
  • Client
  • 0EMPLOYEE_0077_ATTR.RAC07 == T505R.RACKY
  • 0EMPLOYEE_0077_ATTR.MANDT == T505R.MANDT
Foreign key Check for Race against T505R-RACKY
  • Racial Category
  • Client
  • 0EMPLOYEE_0077_ATTR.RAC08 == T505R.RACKY
  • 0EMPLOYEE_0077_ATTR.MANDT == T505R.MANDT
Foreign key Check for Race against T505R-RACKY
  • Racial Category
  • Client
  • 0EMPLOYEE_0077_ATTR.RAC09 == T505R.RACKY
  • 0EMPLOYEE_0077_ATTR.MANDT == T505R.MANDT
Foreign key Check for Race against T505R-RACKY
  • Racial Category
  • Client
  • 0EMPLOYEE_0077_ATTR.RAC10 == T505R.RACKY
  • 0EMPLOYEE_0077_ATTR.MANDT == T505R.MANDT
Ethnic origin
  • Ethnic origin
  • Client
  • 0EMPLOYEE_0077_ATTR.RACKY == T505R.RACKY
  • 0EMPLOYEE_0077_ATTR.MANDT == T505R.MANDT