SAP ABAP Table PIQ_STUDENTLDB_DETAILDATA (Detailed Data for Logical Database RHIQ_STUDENT_LDB)

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-AD (Application Component) Administration
     ⤷ PMIQ (Package) Campus Management

Basic Data

Table Category	INTTAB	Structure
Structure	PIQ_STUDENTLDB_DETAILDATA	Table Relationship Diagram
Short Description	Detailed Data for Logical Database RHIQ_STUDENT_LDB

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Object
2	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
3	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
4	OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
5	FLAG1_DETAIL3	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
6	STUDENTNUMBER	☐	PIQSTUDENT12	PIQSTUDENT12	CHAR	12	0	Student Number
7	.INCLUDE	☐				0	0	BAPI Structure for Student: Personal Data (Text Fields)
8	FORM_OF_ADDRESS_KEY	☐	ANRDE	ANRDE	CHAR	1	0	Form-of-Address Key	T522G
9	FORM_OF_ADDRESS_KEY_TXT	☐	ANRLT	TEXT15	CHAR	15	0	Long Text: Form of Address
10	INITIALS	☐	INITS	TEXT10	CHAR	10	0	Initials
11	FIRST_NAME	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
12	LAST_NAME	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
13	MIDDLE_NAME	☐	PAD_MIDNM	PAD_VORNM	CHAR	40	0	Middle Name
14	TITEL	☐	TITEL	TITEL	CHAR	15	0	Title	T535N
15	TITEL_TXT	☐	TTOUT	TEXT15	CHAR	15	0	Output text for name affix
16	NAME_AFFIX	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
17	NAME_AFFIX_TXT	☐	TTOUT	TEXT15	CHAR	15	0	Output text for name affix
18	ARISTOCRATIC_TITLE	☐	NAMZU	TITEL	CHAR	15	0	Other Title	T535N
19	ARISTOCRATIC_TITLE_TXT	☐	TTOUT	TEXT15	CHAR	15	0	Output text for name affix
20	NICKNAME	☐	PIQ_RUFNM	PAD_VORNM	CHAR	40	0	Known As
21	NAME_AT_BIRTH	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
22	DATE_BIRTH	☐	PIQ_GBDAT	GBDAT	DATS	8	0	Date of Birth
23	BIRTHPLACE	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
24	COUNTRY_OF_BIRTH	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
25	COUNTRY_OF_BIRTH_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
26	NAMEOFBIRTHCOUNTRY	☐	LANDX	TEXT15	CHAR	15	0	Country Name
27	REGION_OF_BIRTH	☐	PIQ_GBDEP	REGIO	CHAR	3	0	Region of Birth (State, Province, County)	T005S
28	NAMEOFBIRTHSTATE	☐	BEZEI20	TEXT20	CHAR	20	0	Description
29	NATIONALITY_AT_BIRTH	☐	PIQ_GBNAT	LAND1	CHAR	3	0	Nationality (Citizenship) at Birth	*
30	NATIONALITY_AT_BIRTH_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
31	NATIONALITY_AT_BIRTH_TXT	☐	PIQNATIO	TEXT15	CHAR	15	0	Nationality (Citizenship)
32	NATIONALITY	☐	PIQNATSL	LAND1	CHAR	3	0	Nationality (Citizenship)	*
33	NATIONALITY_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
34	NATIONALITY_TXT	☐	PIQNATIO	TEXT15	CHAR	15	0	Nationality (Citizenship)
35	SECOND_NATIONALITY	☐	PIQNATS2	LAND1	CHAR	3	0	Second Nationality (Citizenship)	*
36	SECOND_NATIONALITY_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
37	SECOND_NATIONALITY_TXT	☐	PIQNATIO	TEXT15	CHAR	15	0	Nationality (Citizenship)
38	THIRD_NATIONALITY	☐	PIQNATS3	LAND1	CHAR	3	0	Third Nationality (Citizenship)	*
39	THIRD_NATIONALITY_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
40	THIRD_NATIONALITY_TXT	☐	PIQNATIO	TEXT15	CHAR	15	0	Nationality (Citizenship)
41	GENDER_KEY	☐	GESCH	GESCH	CHAR	1	0	Gender Key
42	GENDER_KEY_TXT	☐	PIQGESCHT		CHAR	15	0	Gender of Student
43	MARITAL_STATUS	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	T502T
44	MARITAL_STATUS_TXT	☐	FATXT	FATXT	CHAR	6	0	Marital Status
45	PERSIDNO	☐	PIQ_PRDNI	CHAR20	CHAR	20	0	Identification Number
46	CORRESP_LANGUAGE	☐	PIQ_SPRAS	SPRAS	LANG	1	0	Language of Communication	T002
47	CORRESP_LANGUAGE_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
48	CORRESP_LANGUAGE_TXT	☐	SPTXT	SPTXT16	CHAR	16	0	Name of Language
49	DEATH_DATE	☐	PIQ_DEATHDATE	DATE	DATS	8	0	Date of Death
50	DEATH_REGDATE	☐	PIQ_REGDEATHDATE	DATE	DATS	8	0	Date On Which Death Was Recorded
51	.INCLUDE	☐				0	0	BAPI Structure for Student: Addit'l Pers. Data (Text Fields)
52	RELIGION	☐	PIQKONFE	KONFE	CHAR	2	0	Religious Denomination Key	T516T
53	RELIGION_TXT	☐	KNFTX	TEXT25	CHAR	25	0	Religious Denomination Long Text
54	ETHNIC_GRP	☐	PIQETHNIC	PIQETHNIC	CHAR	4	0	Ethnic Origin	T7PIQETHNIC
55	ETHNIC_GRP_TXT	☐	PIQETHNICT	TEXT40	CHAR	40	0	Ethnic Origin (Description)
56	JOB	☐	PIQTAETE	TAESL	NUMC	8	0	Student's Job	T513C
57	JOB_TXT	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
58	SOCIAL_GRP	☐	PIQSOCIAL	PIQSOCIAL	CHAR	2	0	Social Class	T7PIQSOCIAL
59	SOCIAL_GRP_TXT	☐	PIQSOCIALT	TEXT40	CHAR	40	0	Social Class (Description)
60	SERVICE_STATUS	☐	PIQSERV_STAT	MILSA	NUMC	2	0	Service Status	*
61	SERVICE_STATUS_TXT	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
62	SERVICE_NUMBER	☐	PIQSERV_NR		CHAR	20	0	Service Number
63	VETERAN_NUMBER	☐	PIQVETERAN_NR		CHAR	20	0	Veteran Administration Number
64	DRIVERS_LICENSE_NO	☐	DR_LIC_NO_PS		CHAR	20	0	Driver's License Number
65	DRIVERS_LICENSE_COUNTRY	☐	DR_LIC_LAND1_PS	LAND1	CHAR	3	0	Country in Which Driver's License Was Issued	T005
66	DRIVERS_LICENSE_COUNTRY_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
67	NAMEOFLICENCECOUNTRY	☐	LANDX	TEXT15	CHAR	15	0	Country Name
68	DRIVERS_LICENSE_REGION	☐	DR_LIC_REGIO_PS	REGIO	CHAR	3	0	Region in Which Driver's License Was Issued	T005S
69	NAMEOFLICENSESTATE	☐	BEZEI20	TEXT20	CHAR	20	0	Description
70	.INCLUDE	☐				0	0	BAPI Structure for Student: Challenge Data (Text Fields)
71	CHALL_GRP	☐	PIQCHGRP	PIQCHGRP	CHAR	2	0	Challenge Group (Student)	T7PIQCHGRP
72	CHALL_GRP_TXT	☐	PIQCHGRPT	TEXT40	CHAR	40	0	Challenge Group (Description)
73	CHALL_PERC	☐	PIQCHALLPERC	DEC3_2	DEC	5	2	Degree of Challenge
74	CHALL_TYPE	☐	PIQCHTYP	PIQCHTYP	CHAR	2	0	Challenge Type	T7PIQCHTYP
75	CHALL_TYPE_TXT	☐	PIQCHTYPT	TEXT40	CHAR	40	0	Challenge Type (Description)
76	DATE_CHALL_CERT	☐	PIQSBAUD	DATUM	DATS	8	0	Expiry Date of ID for Challenged Persons
77	.INCLUDE	☐				0	0	BAPI Structure for Student: Residence (Text Fields)
78	RESIDENCY_STATUS	☐	PIQRESIDSTATUS	RESIS	CHAR	1	0	Resident Status	*
79	RESIDENCY_STATUS_TXT	☐	RESTX	TEXT25	CHAR	25	0	Residence status texts
80	RESIDENCY_COUNTRY	☐	PIQRESIDCOUNTRY	LAND1	CHAR	3	0	Resident Country	T005
81	RESIDENCY_COUNTRY_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
82	NAMEOFRESIDENCYCOUNTRY	☐	LANDX	TEXT15	CHAR	15	0	Country Name
83	RESIDENCY_REGION	☐	PIQRESIDREGIO	REGIO	CHAR	3	0	Resident State	T005S
84	NAMEOFRESIDENCYSTATE	☐	BEZEI20	TEXT20	CHAR	20	0	Description
85	RESIDENCY_COUNTY	☐	PIQRESIDCOUNC	COUNC	CHAR	3	0	Resident County	T005E
86	NAMEOFRESIDENCYCOUNTY	☐	BEZEI20	TEXT20	CHAR	20	0	Description
87	PASSPORT_NUMBER	☐	PIQPASSN	PIQPASSN	CHAR	20	0	Passport Number
88	ORIGIN	☐	PIQORIGIN	PIQORIGIN	CHAR	4	0	Origin	T7PIQORIGIN
89	ORIGIN_TXT	☐	PIQORIGINT	TEXT40	CHAR	40	0	Origin
90	.INCLUDE	☐				0	0	BAPI Structure for Student: Study Data (Text Fields)
91	ALTERNAT_STUDENT_NO	☐	PIQMATRIKEL	CHAR40	CHAR	40	0	Additional Identification Number
92	STUDENTGRP	☐	PIQSTGRP	PIQSTGRP	CHAR	4	0	Student Group	T7PIQSTGRP
93	STUDENTGRP_TXT	☐	PIQSTGRPT	TEXT40	CHAR	40	0	Student Group (Description)
94	REGISTWINDOW	☐	PIQREGWINDOW	CHAR4	CHAR	4	0	Time Window Used in Module Booking Process
95	.INCLUDE	☐				0	0	BAPI Structure for Student: Fee Calc. Data (Text Fields)
96	STUDENT_FEE_CATEG	☐	PIQSTFEECAT	PIQSTFEECAT	CHAR	4	0	Student Fee Category	T7PIQSTFEECAT
97	STUDENT_FEE_CATEG_TXT	☐	PIQSTFEECATT	TEXT30	CHAR	30	0	Student Fee Category (Description)
98	BENEFIT_CATEG	☐	PIQBENCAT	PIQBENCAT	CHAR	4	0	Benefit Category	T7PIQBENCAT
99	BENEFIT_CATEG_TXT	☐	PIQBENCATT	TEXT30	CHAR	30	0	Benefit Category (Description)
100	PERS_DISCOUNT1	☐	PIQPDISCT1	PIQPDISCT1	CHAR	4	0	Discount/Surcharge Category 1	T7PIQPDISCT1
101	PERS_DISCOUNT1_TXT	☐	PIQPDISCT1T	TEXT30	CHAR	30	0	Discount/Surcharge Category 1 (Description)
102	PERS_DISCOUNT2	☐	PIQPDISCT2	PIQPDISCT2	CHAR	4	0	Discount/Surcharge Category 2	T7PIQPDISCT2
103	PERS_DISCOUNT2_TXT	☐	PIQPDISCT2T	TEXT30	CHAR	30	0	Discount/Surcharge Category 2 (Description)
104	PERS_DISCOUNT3	☐	PIQPDISCT3	PIQPDISCT3	CHAR	4	0	Discount/Surcharge Category 3	T7PIQPDISCT3
105	PERS_DISCOUNT3_TXT	☐	PIQPDISCT3T	TEXT30	CHAR	30	0	Discount/Surcharge Category 3 (Description)
106	PERS_DISCOUNT4	☐	PIQPDISCT4	PIQPDISCT4	CHAR	4	0	Discount/Surcharge Category 4	T7PIQPDISCT4
107	PERS_DISCOUNT4_TXT	☐	PIQPDISCT4T	TEXT30	CHAR	30	0	Discount/Surcharge Category 4 (Description)
108	PERS_DISCOUNT5	☐	PIQPDISCT5	PIQPDISCT5	CHAR	4	0	Discount/Surcharge Category 5	T7PIQPDISCT5
109	PERS_DISCOUNT5_TXT	☐	PIQPDISCT5T	TEXT30	CHAR	30	0	Discount/Surcharge Category 5 (Description)
110	PERS_DISCOUNT6	☐	PIQPDISCT6	PIQPDISCT6	CHAR	4	0	Discount/Surcharge Category 6	T7PIQPDISCT6
111	PERS_DISCOUNT6_TXT	☐	PIQPDISCT6T	TEXT30	CHAR	30	0	Discount/Surcharge Category 6 (Description)
112	.INCLUDE	☐				0	0	BAPI Structure for Student: Org. Unit (Text Fields)
113	ASSIGNED_ORGUNIT	☐	PIQSTORGUNIT_ASSIGNED	HROBJID	NUMC	8	0	Assigned Organizational Unit of Student	*
114	ASSIGNED_ORGUNIT_TXT	☐	PIQSTORGTX	TEXT40	CHAR	40	0	Name of the Student's Organizational Unit
115	ASSIGNED_ORGUNIT_SHT	☐	PIQSTORGSHT	TEXT12	CHAR	12	0	Organizational Unit of Student (Abbreviation)
116	.INCLUDE	☐				0	0	BAPI Structure for Student: Campus (Text Fields)
117	CAMPUS	☐	PIQCAMPUS	HROBJID	NUMC	8	0	Campus	*
118	CAMPUS_TXT	☐	PIQCAMPUSTXT	TEXT40	CHAR	40	0	Campus Name
119	CAMPUS_SHT	☐	PIQCAMPUSSHT	TEXT12	CHAR	12	0	Campus Abbreviation
120	.INCLUDE	☐				0	0	BAPI Structure for Student: Status Attributes (Text Fields)
121	CONFIDENTIALITY	☐	PIQCONFID	PIQCONFID	CHAR	2	0	Data Privacy Level	*
122	CONFIDENTIALITY_TXT	☐	PIQCONFIDT	TEXT40	CHAR	40	0	Data Privacy Level (Description)
123	FLAG2_DETAIL3	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
124	.INCLUDE	☐				0	0	BAPI: Student Identification Data (Detail Screen)
125	IDENTIFICATIONTYPE	☐	PIQVISATYPE	PIQVISATYPE	CHAR	4	0	Visa/Registration Type	T7PIQVISATYPE
126	IDENTIFICATIONNUMBER	☐	PIQVISANUMBER	TEXT20	CHAR	20	0	Visa/Registration Number
127	FROM_DATE	☐	BEGDA	DATUM	DATS	8	0	Start Date
128	TO_DATE	☐	ENDDA	DATUM	DATS	8	0	End Date
129	ISSUING_INSTITUTION	☐	PIQVISAINST	TEXT40	CHAR	40	0	Issuing Government / Authority
130	DATE_OF_ISSUE	☐	PIQVISADATE	DATS	DATS	8	0	Date of Issue for VISA/Registration
131	ISSUING_COUNTRY	☐	PIQVISACTRY	LAND1	CHAR	3	0	Country of Issue for VISA/Registration	T005
132	ISSUING_COUNTRY_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
133	FLAG1_ADDRESS	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
134	.INCLUDE	☐				0	0	SAP BP: BAPI Structure for Address Data
135	STANDARDADDRESS	☐	BU_XDFADR	XFELD	CHAR	1	0	Indicator: Address is standard address
136	C_O_NAME	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
137	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
138	DISTRICT	☐	AD_CITY2	TEXT40	CHAR	40	0	District
139	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	ADRREGGRP
140	NAMEOFREGIOGROUP	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
141	POSTL_COD1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
142	POSTL_COD2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
143	POSTL_COD3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
144	PCODE1_EXT	☐	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
145	PCODE2_EXT	☐	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
146	PCODE3_EXT	☐	AD_PST3XT	CHAR10	CHAR	10	0	(Not Supported) Major Customer Postal Code Extension
147	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
148	PO_W_O_NO	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
149	PO_BOX_CIT	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
150	PO_BOX_REG	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)	T005S
151	PO_BOX_NAMEOFSTATE	☐	BEZEI20	TEXT20	CHAR	20	0	Description
152	POBOX_CTRY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	T005
153	PO_CTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
154	PO_BOX_NAMEOFCOUNTRY	☐	LANDX	TEXT15	CHAR	15	0	Country Name
155	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
156	STR_ABBR	☐	AD_STRABBR	STRTYPEAB	CHAR	2	0	(Not Supported) Abbreviation of Street Name	ADRSTRTYPE
157	HOUSE_NO	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
158	HOUSE_NO2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
159	HOUSE_NO3	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
160	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
161	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
162	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
163	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
164	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
165	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
166	ROOM_NO	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
167	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
168	COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
169	NAMEOFCOUNTRY	☐	LANDX	TEXT15	CHAR	15	0	Country Name
170	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
171	NAMEOFSTATE	☐	BEZEI20	TEXT20	CHAR	20	0	Description
172	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone	TTZZ
173	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
174	HOME_CITY	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
175	TRANSPZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	*
176	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
177	LANGUISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
178	LANGUAGE	☐	SPTXT	SPTXT16	CHAR	16	0	Name of Language
179	COMM_TYPE	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)	*
180	COMM_TYPE_TEXT	☐	AD_COM_TX	TEXT20	CHAR	20	0	Communication type description
181	.INCLUDE	☐				0	0	Telephone Data for Logical Database RHIQ_STUDENT_LDB
182	PHONE_COUNTRY	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
183	PHONE_COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
184	PHONE_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
185	TELEPHONE	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
186	PHONE_EXTENSION	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
187	TEL_NO	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
188	CALLER_NO	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
189	PHONE_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
190	PHONE_R_3_USER	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
191	PHONE_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
192	PHONE_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
193	PHONE_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
194	.INCLUDE	☐				0	0	Fax Data for Logical Database RHIQ_STUDENT_LDB
195	FAX_COUNTRY	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
196	FAX_COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
197	FAX_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
198	FAX	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
199	FAX_EXTENSION	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
200	FAX_NO	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
201	SENDER_NO	☐	AD_FAXNRCL	CHAR30	CHAR	30	0	Fax number for finding sender
202	FAX_GROUP	☐	AD_FXGRP	AD_FXGRP	CHAR	1	0	Fax group (G3, G4, ...)
203	FAX_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
204	FAX_R_3_USER	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
205	FAX_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
206	FAX_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
207	FAX_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
208	.INCLUDE	☐				0	0	Teletex Data for Logical Database RHIQ_STUDENT_LDB
209	TTX_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
210	TTX_COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
211	TTX_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
212	TELETEX	☐	AD_TTXNMBR	TEXT30	CHAR	30	0	Teletex number
213	TTX_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
214	TTX_R_3_USER	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
215	TTX_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
216	TTX_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
217	TTX_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
218	.INCLUDE	☐				0	0	Telex Data for Logical Database RHIQ_STUDENT_LDB
219	TLX_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
220	TLX_COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
221	TLX_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
222	TELEX_NO	☐	AD_TLXNMBR	TEXT30	CHAR	30	0	Telex number
223	TLX_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
224	TLX_R_3_USER	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
225	TLX_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
226	TLX_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
227	TLX_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
228	.INCLUDE	☐				0	0	SMTP Data for Logical Database RHIQ_STUDENT_LDB
229	SMTP_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
230	E_MAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
231	EMAIL_SRCH	☐	AD_SMTPAD2	CHAR20	CHAR	20	0	E-Mail Address Search Field
232	SMTP_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
233	SMTP_R_3_USER	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
234	ENCODE	☐	AD_ENCODE	AD_ENCODE	CHAR	1	0	Desired Data Coding (E-Mail)
235	SMTP_TNEF	☐	AD_TNEF6	XFELD	CHAR	1	0	Flag: Receiver can receive TNEF coding via SMTP
236	SMTP_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
237	SMTP_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
238	SMTP_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
239	.INCLUDE	☐				0	0	RML Data for Logical Database RHIQ_STUDENT_LDB
240	RML_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
241	SYMB_DEST	☐	AD_SYMBDST	CHAR10	CHAR	10	0	Symbolic destination
242	REC_TYPE	☐	AD_RCVRTYP	CHAR1	CHAR	1	0	Recipient type (not currently used)
243	R_MAIL_CLT	☐	AD_UMAND	CHAR3	CHAR	3	0	RML- Client (Remote Mail, SAP - SAP - Communication)
244	R_MAIL	☐	AD_UNAME	CHAR12	CHAR	12	0	RML Name (Remote Mail, SAP - SAP - Communication)
245	RML_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
246	RML_R_3_USER	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
247	RML_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
248	RML_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
249	RML_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
250	.INCLUDE	☐				0	0	X400 Data for Logical Database RHIQ_STUDENT_LDB
251	X400_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
252	X400_COUNTRY	☐	AD_X4CNTRY	LAND1	CHAR	3	0	X.400 country code	*
253	X400_COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
254	ADM_DOM	☐	AD_X4ADMIN	CHAR16	CHAR	16	0	X.400 administration domain
255	PRIV_DOM	☐	AD_X4PRIVD	CHAR16	CHAR	16	0	X.400 private domain
256	ORGANIZATN	☐	AD_X4ORG	CHAR64	CHAR	64	0	X.400 organization
257	ORG_UNIT_1	☐	AD_X4ORG1	CHAR32	CHAR	32	0	X.400 organizational unit 1
258	ORG_UNIT_2	☐	AD_X4ORG2	CHAR32	CHAR	32	0	X.400 organizational unit 2
259	ORG_UNIT_3	☐	AD_X4ORG3	CHAR32	CHAR	32	0	X.400 organizational unit 3
260	ORG_UNIT_4	☐	AD_X4ORG4	CHAR32	CHAR	32	0	X.400 organizational unit 4
261	LASTNAME	☐	AD_X4LNAME	CHAR40	CHAR	40	0	X.400 last name
262	FIRSTNAME	☐	AD_X4FNAME	CHAR16	CHAR	16	0	X.400 first name
263	X400_INITIALS	☐	AD_X4INI	CHAR5	CHAR	5	0	X.400 Initials
264	GENERATION	☐	AD_X4GENER	CHAR3	CHAR	3	0	X.400 generation
265	X_121_ADDR	☐	AD_X4X121	CHAR15	CHAR	15	0	X.400 X.121 network address
266	TERM_ID	☐	AD_X4TRMID	CHAR24	CHAR	24	0	X.400 Terminal ID
267	TERM_TYPE	☐	AD_X4TRMTP	CHAR1	CHAR	1	0	X.400 terminal type
268	UANID	☐	AD_X4UANID	CHAR32	CHAR	32	0	X.400 user agent numeric ID
269	TYPE1	☐	AD_X4DDAT1	TEXT8	CHAR	8	0	X.400 domain defined attribute, type 1
270	VALUE1	☐	AD_X4DDAV1	TEXT128	CHAR	128	0	X.400 domain defined attribute, value 1
271	TYPE2	☐	AD_X4DDAT2	TEXT8	CHAR	8	0	X.400 domain defined attribute, type 2
272	VALUE2	☐	AD_X4DDAV2	TEXT128	CHAR	128	0	X.400 domain defined attribute, value 2
273	TYPE3	☐	AD_X4DDAT3	TEXT8	CHAR	8	0	X.400 domain defined attribute, type 3
274	VALUE3	☐	AD_X4DDAV3	TEXT128	CHAR	128	0	X.400 domain defined attribute, value 3
275	DDA_TYPE4	☐	AD_X4DDAT4	TEXT8	CHAR	8	0	X.400 domain defined attribute, type 4
276	DDA_VALUE4	☐	AD_X4DDAV4	TEXT128	CHAR	128	0	X.400 domain defined attribute, value 4
277	X400_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
278	X400_R_3_USER	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
279	TXT_ENCODE	☐	AD_TENCODE	AD_TENCODE	CHAR	1	0	Desired text data coding (X.400)
280	X400_TNEF	☐	AD_TNEF8	XFELD	CHAR	1	0	Flag: Receiver can receive TNEF coding via X.400
281	X400_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
282	X400_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
283	X400_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
284	.INCLUDE	☐				0	0	RFC Data for Logical Database RHIQ_STUDENT_LDB
285	RFC_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
286	LOG_DEST	☐	AD_LOGDEST	RFCDEST	CHAR	32	0	RFC logical destination	*
287	RFC_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
288	RFC_R_3_USER	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
289	RFC_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
290	RFC_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
291	RFC_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
292	.INCLUDE	☐				0	0	Print Data for Logical Database RHIQ_STUDENT_LDB
293	PRT_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
294	PRINT_DEST	☐	RSPOPNAME	RSPOPNAME	CHAR	4	0	Spool: Output device	*
295	PRT_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
296	PRT_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
297	PRT_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
298	PRT_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
299	.INCLUDE	☐				0	0	SSF Data for Logical Database RHIQ_STUDENT_LDB
300	SSF_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
301	SSF_DUMMY	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
302	SSF_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
303	SSF_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
304	SSF_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
305	RFCDEST	☐	RFCDEST	RFCDEST	CHAR	32	0	Logical Destination (Specified in Function Call)	*
306	SSFIDSHORT	☐	AD_SSFSCR	AD_SSFSCR	CHAR	132	0	SSFID field for screen display
307	SSF_NS	☐	SSFNS	SSFNSD	CHAR	10	0	SSF Namespace label
308	SSF_PROF	☐	SSFPROF	TEXT132	CHAR	132	0	SSF profile name
309	SSFIDPART1	☐	AD_SSFID_1	AD_SSFID_1	CHAR	250	0	SSF name signatory/recipient: Parts 1-8
310	SSFIDPART2	☐	AD_SSFID_1	AD_SSFID_1	CHAR	250	0	SSF name signatory/recipient: Parts 1-8
311	SSFIDPART3	☐	AD_SSFID_1	AD_SSFID_1	CHAR	250	0	SSF name signatory/recipient: Parts 1-8
312	SSFIDPART4	☐	AD_SSFID_1	AD_SSFID_1	CHAR	250	0	SSF name signatory/recipient: Parts 1-8
313	SSFIDPART5	☐	AD_SSFID_1	AD_SSFID_1	CHAR	250	0	SSF name signatory/recipient: Parts 1-8
314	SSFIDPART6	☐	AD_SSFID_1	AD_SSFID_1	CHAR	250	0	SSF name signatory/recipient: Parts 1-8
315	SSFIDPART7	☐	AD_SSFID_1	AD_SSFID_1	CHAR	250	0	SSF name signatory/recipient: Parts 1-8
316	SSFIDPART8	☐	AD_SSFID_1	AD_SSFID_1	CHAR	250	0	SSF name signatory/recipient: Parts 1-8
317	SSFIDPART9	☐	AD_SSFID_9	TEXT48	CHAR	48	0	SSF name signatory/recipient - part 9
318	SSF_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
319	.INCLUDE	☐				0	0	URI Data for Logical Database RHIQ_STUDENT_LDB
320	URI_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
321	URI_TYPE	☐	AD_URITYPE	AD_URITYPE	CHAR	3	0	URI type flag
322	URI	☐	AD_URISCR	AD_URISCR	CHAR	132	0	URI, e.g. Homepage or ftp Address
323	URI_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
324	URI_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
325	URI_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
326	URI_PART1	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
327	URI_PART2	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
328	URI_PART3	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
329	URI_PART4	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
330	URI_PART5	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
331	URI_PART6	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
332	URI_PART7	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
333	URI_PART8	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
334	URI_PART9	☐	AD_URI_9	TEXT48	CHAR	48	0	Universal Resource Identifier (URI) - Part 9
335	URI_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
336	.INCLUDE	☐				0	0	Pager Data for Logical Database RHIQ_STUDENT_LDB
337	PAG_COUNTRY	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
338	PAG_COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
339	PAG_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
340	PAGER_TYPE	☐	AD_PAGSERV	CHAR4	CHAR	4	0	Pager Service
341	PAGER	☐	AD_PAGNMBR	TEXT30	CHAR	30	0	Pager number
342	PAGER_NO	☐	AD_PGNRLNG	CHAR30	CHAR	30	0	Normalized pager search field
343	PAG_CALLER_NO	☐	AD_PAGNRCL	CHAR30	CHAR	30	0	Pager number for finding sender
344	PAG_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
345	PAG_R_3_USER	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
346	PAG_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
347	PAG_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
348	PAG_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
349	.INCLUDE	☐				0	0	Address Notes for Logical Database RHIQ_STUDENT_LDB
350	ADDR_VERS	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	*
351	REM_LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
352	REM_LANGU_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
353	ADR_NOTES	☐	AD_REMARK1	TEXT50	CHAR	50	0	Address notes
354	REM_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
355	.INCLUDE	☐				0	0	Communication Data for Logical Database RHIQ_STUDENT_LDB
356	COM_COMM_TYPE	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)	*
357	COM_LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
358	COM_LANGU_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
359	COMM_NOTES	☐	AD_REMARK2	TEXT50	CHAR	50	0	Communication link notes
360	COM_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
361	COM_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
362	.INCLUDE	☐				0	0	SAP BP: BAPI Structue for Address Uses (Text Fields)
363	ADDRESSTYPE	☐	BU_ADRKIND	BU_ADRKIND	CHAR	10	0	Address Type	TB009
364	ADDRESSTYPETEXT	☐	BU_TXL010	TEXT40	CHAR	40	0	Name of address type
365	STANDARDADDRESSUSAGE	☐	BU_XDFADU	XFELD	CHAR	1	0	Indicator: Standard Address Usage
366	FLAG2_ADDRESS	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQ_STUDENTLDB_DETAILDATA	ADDRESSTYPE	TB009	ADR_KIND	KEY	1	CN
2	PIQ_STUDENTLDB_DETAILDATA	ARISTOCRATIC_TITLE	T535N	TITEL	REF	1	CN
3	PIQ_STUDENTLDB_DETAILDATA	BENEFIT_CATEG	T7PIQBENCAT	BENCAT	REF	1	CN
4	PIQ_STUDENTLDB_DETAILDATA	CHALL_GRP	T7PIQCHGRP	CHGRP	REF	1	CN
5	PIQ_STUDENTLDB_DETAILDATA	CHALL_TYPE	T7PIQCHTYP	CHTYP	REF	1	CN
6	PIQ_STUDENTLDB_DETAILDATA	CORRESP_LANGUAGE	T002	SPRAS	REF	1	CN
7	PIQ_STUDENTLDB_DETAILDATA	COUNTRY	T005	LAND1	REF	1	CN
8	PIQ_STUDENTLDB_DETAILDATA	COUNTRY_OF_BIRTH	T005	LAND1	REF	1	CN
9	PIQ_STUDENTLDB_DETAILDATA	DRIVERS_LICENSE_COUNTRY	T005	LAND1	REF	1	CN
10	PIQ_STUDENTLDB_DETAILDATA	DRIVERS_LICENSE_REGION	T005S	BLAND	REF	1	CN
11	PIQ_STUDENTLDB_DETAILDATA	ETHNIC_GRP	T7PIQETHNIC	ETHNIC
12	PIQ_STUDENTLDB_DETAILDATA	FORM_OF_ADDRESS_KEY	T522G	ANRED	REF	1	CN
13	PIQ_STUDENTLDB_DETAILDATA	IDENTIFICATIONTYPE	T7PIQVISATYPE	VISATYPE
14	PIQ_STUDENTLDB_DETAILDATA	ISSUING_COUNTRY	T005	LAND1
15	PIQ_STUDENTLDB_DETAILDATA	JOB	T513C	TAETE
16	PIQ_STUDENTLDB_DETAILDATA	MARITAL_STATUS	T502T	FAMST	REF	1	CN
17	PIQ_STUDENTLDB_DETAILDATA	NAME_AFFIX	T535N	TITEL	REF	1	CN
18	PIQ_STUDENTLDB_DETAILDATA	ORIGIN	T7PIQORIGIN	ORIGIN	REF	1	CN
19	PIQ_STUDENTLDB_DETAILDATA	OTYPE	T778O	OTYPE
20	PIQ_STUDENTLDB_DETAILDATA	PERS_DISCOUNT1	T7PIQPDISCT1	PDISCT1	REF	1	CN
21	PIQ_STUDENTLDB_DETAILDATA	PERS_DISCOUNT2	T7PIQPDISCT2	PDISCT2	REF	1	CN
22	PIQ_STUDENTLDB_DETAILDATA	PERS_DISCOUNT3	T7PIQPDISCT3	PDISCT3	REF	1	CN
23	PIQ_STUDENTLDB_DETAILDATA	PERS_DISCOUNT4	T7PIQPDISCT4	PDISCT4	KEY	1	CN
24	PIQ_STUDENTLDB_DETAILDATA	PERS_DISCOUNT5	T7PIQPDISCT5	PDISCT5	REF	1	CN
25	PIQ_STUDENTLDB_DETAILDATA	PERS_DISCOUNT6	T7PIQPDISCT6	PDISCT6	REF	1	CN
26	PIQ_STUDENTLDB_DETAILDATA	PLVAR	T778P	PLVAR
27	PIQ_STUDENTLDB_DETAILDATA	POBOX_CTRY	T005	LAND1	REF	C	CN
28	PIQ_STUDENTLDB_DETAILDATA	PO_BOX_REG	T005S	BLAND		C	CN
29	PIQ_STUDENTLDB_DETAILDATA	REGIOGROUP	ADRREGGRP	REGIOGROUP	REF	C	CN
30	PIQ_STUDENTLDB_DETAILDATA	REGION	T005S	BLAND	REF	C	CN
31	PIQ_STUDENTLDB_DETAILDATA	REGION_OF_BIRTH	T005S	BLAND	REF	1	CN
32	PIQ_STUDENTLDB_DETAILDATA	RELIGION	T516T	KONFE
33	PIQ_STUDENTLDB_DETAILDATA	RESIDENCY_COUNTRY	T005	LAND1	REF	1	CN
34	PIQ_STUDENTLDB_DETAILDATA	RESIDENCY_COUNTY	T005E	COUNC	REF	1	CN
35	PIQ_STUDENTLDB_DETAILDATA	RESIDENCY_REGION	T005S	BLAND	REF	1	CN
36	PIQ_STUDENTLDB_DETAILDATA	SOCIAL_GRP	T7PIQSOCIAL	SOCIAL		1	CN
37	PIQ_STUDENTLDB_DETAILDATA	STR_ABBR	ADRSTRTYPE	STRTYPEAB	REF	C	CN
38	PIQ_STUDENTLDB_DETAILDATA	STUDENTGRP	T7PIQSTGRP	STGRP		1	CN
39	PIQ_STUDENTLDB_DETAILDATA	STUDENT_FEE_CATEG	T7PIQSTFEECAT	STFEECAT	REF	1	CN
40	PIQ_STUDENTLDB_DETAILDATA	TIME_ZONE	TTZZ	TZONE	REF	C	CN
41	PIQ_STUDENTLDB_DETAILDATA	TITEL	T535N	TITEL	REF	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in