PiqCds_StudentData

Student Data CDS VIew | view: PIQCDSSTUDDATA | Extraction: Not supported | Component: Campus Management
Tables used: T7PIQCONFID, T7PIQCONFIDT, T7PIQSTFEECAT, T7PIQSTFEECATT, T7PIQSTGRP, T7PIQSTGRPT, T7PIQORIGIN, T7PIQORIGINT, CMACBPST, HRP1000, HRP1001, HRP1701, HRP1702, HRP1705, HRP1706, HRP1711, T002T, T005F, T005T, T005U, T500L, T505V, T522T, T502T
Column Name Description
Column Name Description
Column Name Description
Column Name Description
StudentDateOfBirth Date of Birth
StudentDateOfDeath Date of Death
StudentRecordedDateOfDeath Date On Which Death Was Recorded
StudentPassportIssueDate UCAS: Passport Issue Date
StudentPassportExpiryDate UCAS: Passport Expiry Date
Column Name Description
Column Name Description Domain name
StudentNumber Student Number PIQSTUDENT12
StudentAdditionalIdNumber Additional Identification Number CHAR40
StudentLastName Last Name PAD_NACHN
StudentFirstname First Name PAD_VORNM
StudentMiddleName Middle Name PAD_VORNM
StudentInitials Initials TEXT10
StudentBirthName Name at Birth PAD_NACHN
StudentKnownAs Known As PAD_VORNM
StudentCountryOfBirthName Name of Country/Region (Short) TEXT15
StudentRegionOfBirthName Description TEXT20
StudentBirthPlaceName Birthplace PAD_ORT01
StudentNationalityAtBirthName Nationality TEXT15
StudentNationalityName Nationality TEXT15
StudentSecondNationalityName Nationality TEXT15
StudentThirdNationalityName Nationality TEXT15
StudentLanguageOfCommName Name of Language SPTXT16
StudentFormOfAddressKeyName Long Text: Form of Address TEXT15
StudentGenderKeyName Short Text for Fixed Values DDTEXT
StudentMaritalStatusName Marital Status FATXT
StudentIdentificationNumber Identification Number CHAR20
StudentCampus ID of Related Object CHAR45
StudentCampusShortName Object Abbreviation TEXT12
StudentCampusName Object Name TEXT40
StudentAssignedOrg ID of Related Object CHAR45
StudentAssignedOrgShortName Object Abbreviation TEXT12
StudentAssignedOrgName Object Name TEXT40
StudentResidentStatusName Residence status texts TEXT25
StudentResidentCountryName Name of Country/Region (Short) TEXT15
StudentResidentStateName Description TEXT20
StudentResidentCountyName Description TEXT20
StudentPassportNumber Passport Number PIQPASSN
StudentOriginName Origin TEXT40
StudentPassportPlaceOfIssue UCAS: Passport Place of Issue CHAR30
StudentGroupName Student Group (Description) TEXT40
StudentModuleBookingTimeWindow Time Window Used in Module Booking Process CHAR4
StudentDataPrivacyLevelName Data Privacy Level (Description) TEXT40
StudentFeeCategoryName Student Fee Category (Description) TEXT30
Master Data Relations | to Other Relations ↓ Join Conditions
Country/Region of Birth
  • Country/Region of Birth
  • Client
  • PIQCDS_STUDENTDATA.STUDENTCOUNTRYOFBIRTH == T005.LAND1
  • PIQCDS_STUDENTDATA.MANDT == T005.MANDT
Data Privacy Level
  • Data Privacy Level
  • Client
  • PIQCDS_STUDENTDATA.STUDENTDATAPRIVACYLEVEL == T7PIQCONFID.CONFID
  • PIQCDS_STUDENTDATA.MANDT == T7PIQCONFID.MANDT
Student Fee Category
  • Student Fee Category
  • Client
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • PIQCDS_STUDENTDATA.MANDT == T522G.MANDT
  • PIQCDS_STUDENTDATA.STUDENTFORMOFADDRESSKEY == T522G.ANRED
Gender key PIQCDS_STUDENTDATA.STUDENTGENDERKEY == TSAD15.GENDER
Student Group
  • Client
  • Student Group
Language of Communication PIQCDS_STUDENTDATA.STUDENTLANGUAGEOFCOMMUNICATION == T002.SPRAS
Nationality (Citizenship)
  • Client
  • Nationality
  • Nationality
  • Nationality
  • Nationality (Citizenship)
  • Nationality
  • PIQCDS_STUDENTDATA.MANDT == T005.MANDT
  • PIQCDS_STUDENTDATA.STUDENTNATIONALITYNAME == T005.LAND1
  • PIQCDS_STUDENTDATA.STUDENTTHIRDNATIONALITYNAME == T005.LAND1
  • PIQCDS_STUDENTDATA.STUDENTSECONDNATIONALITYNAME == T005.LAND1
  • PIQCDS_STUDENTDATA.STUDENTNATIONALITY == T005.LAND1
  • PIQCDS_STUDENTDATA.STUDENTNATIONALITYATBIRTHNAME == T005.LAND1
Nationality (Citizenship) at Birth
  • Nationality (Citizenship) at Birth
  • Client
  • PIQCDS_STUDENTDATA.STUDENTNATIONALITYATBIRTH == T005.LAND1
  • PIQCDS_STUDENTDATA.MANDT == T005.MANDT
Object ID
  • Object ID
  • ?
  • Client
  • ?
  • PIQCDS_STUDENTDATA.STUDENTOBJECTID == PLOGI.OBJID
  • PIQCDS_STUDENTDATA.[column in domain "OTYPE"] == PLOGI.OTYPE
  • PIQCDS_STUDENTDATA.MANDT == PLOGI.MANDT
  • PIQCDS_STUDENTDATA.[column in domain "PLVAR"] == PLOGI.PLVAR
Origin
  • Origin
  • Client
Region of Birth (State, Province, County)
  • Region of Birth (State, Province, County)
  • Country/Region of Birth
  • Client
  • PIQCDS_STUDENTDATA.STUDENTREGIONOFBIRTH == T005S.BLAND
  • PIQCDS_STUDENTDATA.STUDENTCOUNTRYOFBIRTH == T005S.LAND1
  • PIQCDS_STUDENTDATA.MANDT == T005S.MANDT
Resident Country/Region
  • Client
  • Resident Country/Region
  • PIQCDS_STUDENTDATA.MANDT == T005.MANDT
  • PIQCDS_STUDENTDATA.STUDENTRESIDENTCOUNTRY == T005.LAND1
Resident County
  • Client
  • Resident County
  • Resident Country/Region
  • Resident State
  • PIQCDS_STUDENTDATA.MANDT == T005E.MANDT
  • PIQCDS_STUDENTDATA.STUDENTRESIDENTCOUNTY == T005E.COUNC
  • PIQCDS_STUDENTDATA.STUDENTRESIDENTCOUNTRY == T005E.LAND1
  • PIQCDS_STUDENTDATA.STUDENTRESIDENTSTATE == T005E.REGIO
Resident State
  • Client
  • Resident Country/Region
  • Resident State
  • PIQCDS_STUDENTDATA.MANDT == T005S.MANDT
  • PIQCDS_STUDENTDATA.STUDENTRESIDENTCOUNTRY == T005S.LAND1
  • PIQCDS_STUDENTDATA.STUDENTRESIDENTSTATE == T005S.BLAND
Resident Status
  • Client
  • ?
  • Resident Status
  • PIQCDS_STUDENTDATA.MANDT == T505U.MANDT
  • PIQCDS_STUDENTDATA.[column in domain "MOLGA"] == T505U.MOLGA
  • PIQCDS_STUDENTDATA.STUDENTRESIDENTSTATUS == T505U.RESIS
Second Nationality (Citizenship)
  • Second Nationality (Citizenship)
  • Client
  • PIQCDS_STUDENTDATA.STUDENTSECONDNATIONALITY == T005.LAND1
  • PIQCDS_STUDENTDATA.MANDT == T005.MANDT
Third Nationality (Citizenship)
  • Client
  • Third Nationality (Citizenship)
  • PIQCDS_STUDENTDATA.MANDT == T005.MANDT
  • PIQCDS_STUDENTDATA.STUDENTTHIRDNATIONALITY == T005.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Marital Status Key
  • Marital Status Key
  • Language of Communication
  • Client
  • PIQCDS_STUDENTDATA.STUDENTMARITALSTATUS == T502T.FAMST
  • PIQCDS_STUDENTDATA.STUDENTLANGUAGEOFCOMMUNICATION == T502T.SPRSL
  • PIQCDS_STUDENTDATA.MANDT == T502T.MANDT
Name Prefix
  • ?
  • Client
  • Name Prefix
  • PIQCDS_STUDENTDATA.[column in domain "DZSART"] == T535N.ART
  • PIQCDS_STUDENTDATA.MANDT == T535N.MANDT
  • PIQCDS_STUDENTDATA.STUDENTNAMEPREFIX == T535N.TITEL
Other Title
  • ?
  • Client
  • Other Title
  • PIQCDS_STUDENTDATA.[column in domain "DZSART"] == T535N.ART
  • PIQCDS_STUDENTDATA.MANDT == T535N.MANDT
  • PIQCDS_STUDENTDATA.STUDENTOTHERTITLE == T535N.TITEL
Title
  • ?
  • Client
  • Title
  • PIQCDS_STUDENTDATA.[column in domain "DZSART"] == T535N.ART
  • PIQCDS_STUDENTDATA.MANDT == T535N.MANDT
  • PIQCDS_STUDENTDATA.STUDENTTITLE == T535N.TITEL