SAP ABAP Table PIQRULESTUDENT (Structure for Student Data)

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	PIQRULESTUDENT	Table Relationship Diagram
Short Description	Structure for Student Data

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	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	*
2	OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
3	STUDENTNUMBER	☐	PIQSTUDENT12	PIQSTUDENT12	CHAR	12	0	Student Number
4	PARTNER	☐	PIQST_PARTNER	BU_PARTNER	CHAR	10	0	Student's Business Partner Number	*
5	KEYDATE	☐	PIQKEYDATE	DATUM	DATS	8	0	Key Date
6	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
7	LANGU_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
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	NAME_AFFIX	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
16	ARISTOCRATIC_TITLE	☐	NAMZU	TITEL	CHAR	15	0	Other Title	T535N
17	NICKNAME	☐	PIQ_RUFNM	PAD_VORNM	CHAR	40	0	Known As
18	NAME_AT_BIRTH	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
19	DATE_BIRTH	☐	PIQ_GBDAT	GBDAT	DATS	8	0	Date of Birth
20	BIRTHPLACE	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
21	COUNTRY_OF_BIRTH	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
22	COUNTRY_OF_BIRTH_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
23	NAMEOFBIRTHCOUNTRY	☐	LANDX	TEXT15	CHAR	15	0	Country Name
24	REGION_OF_BIRTH	☐	PIQ_GBDEP	REGIO	CHAR	3	0	Region of Birth (State, Province, County)	T005S
25	NAMEOFBIRTHSTATE	☐	BEZEI20	TEXT20	CHAR	20	0	Description
26	NATIONALITY_AT_BIRTH	☐	PIQ_GBNAT	LAND1	CHAR	3	0	Nationality (Citizenship) at Birth	T005
27	NATIONALITY_AT_BIRTH_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
28	NATIONALITY_AT_BIRTH_TXT	☐	NATIO	TEXT15	CHAR	15	0	Nationality
29	NATIONALITY	☐	NATSL	LAND1	CHAR	3	0	Nationality	*
30	NATIONALITY_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
31	NATIONALITY_TXT	☐	NATIO	TEXT15	CHAR	15	0	Nationality
32	SECOND_NATIONALITY	☐	NATS2	LAND1	CHAR	3	0	Second Nationality	*
33	SECOND_NATIONALITY_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
34	SECOND_NATIONALITY_TXT	☐	NATIO	TEXT15	CHAR	15	0	Nationality
35	THIRD_NATIONALITY	☐	NATS3	LAND1	CHAR	3	0	Third Nationality	*
36	THIRD_NATIONALITY_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
37	THIRD_NATIONALITY_TXT	☐	NATIO	TEXT15	CHAR	15	0	Nationality
38	GENDER_KEY	☐	GESCH	GESCH	CHAR	1	0	Gender Key
39	GENDER_KEY_TXT	☐	PIQGESCHT		CHAR	15	0	Gender of Student
40	MARITAL_STATUS	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	T502T
41	MARITAL_STATUS_TXT	☐	FATXT	FATXT	CHAR	6	0	Marital Status
42	PERSIDNO	☐	PIQ_PRDNI	CHAR20	CHAR	20	0	Identification Number
43	CORRESP_LANGUAGE	☐	PIQ_SPRAS	SPRAS	LANG	1	0	Language of Communication	T002
44	CORRESP_LANGUAGE_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
45	CORRESP_LANGUAGE_TXT	☐	SPTXT	SPTXT16	CHAR	16	0	Name of Language
46	RELIGION	☐	PIQKONFE	KONFE	CHAR	2	0	Religious Denomination Key	T516T
47	RELIGION_TXT	☐	KNFTX	TEXT25	CHAR	25	0	Religious Denomination Long Text
48	ETHNIC_GRP	☐	PIQETHNIC	PIQETHNIC	CHAR	4	0	Ethnic Origin	T7PIQETHNIC
49	ETHNIC_GRP_TXT	☐	PIQETHNICT	TEXT40	CHAR	40	0	Ethnic Origin (Description)
50	JOB	☐	PIQTAETE	TAESL	NUMC	8	0	Student's Job	T513C
51	JOB_TXT	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
52	SOCIAL_GRP	☐	PIQSOCIAL	PIQSOCIAL	CHAR	2	0	Social Class	T7PIQSOCIAL
53	SOCIAL_GRP_TXT	☐	PIQSOCIALT	TEXT40	CHAR	40	0	Social Class (Description)
54	SERVICE_STATUS	☐	PIQSERV_STAT	MILSA	NUMC	2	0	Service Status	*
55	SERVICE_STATUS_TXT	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
56	SERVICE_NUMBER	☐	PIQSERV_NR		CHAR	20	0	Service Number
57	VETERAN_NUMBER	☐	PIQVETERAN_NR		CHAR	20	0	Veteran Administration Number
58	DRIVERS_LICENSE_NO	☐	DR_LIC_NO_PS		CHAR	20	0	Driver's License Number
59	DRIVERS_LICENSE_COUNTRY	☐	DR_LIC_LAND1_PS	LAND1	CHAR	3	0	Country in Which Driver's License Was Issued	T005
60	DRIVERS_LICENSE_COUNTRY_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
61	NAMEOFLICENCECOUNTRY	☐	LANDX	TEXT15	CHAR	15	0	Country Name
62	DRIVERS_LICENSE_REGION	☐	DR_LIC_REGIO_PS	REGIO	CHAR	3	0	Region in Which Driver's License Was Issued	T005S
63	NAMEOFLICENSESTATE	☐	BEZEI20	TEXT20	CHAR	20	0	Description
64	CHALL_GRP	☐	PIQCHGRP	PIQCHGRP	CHAR	2	0	Challenge Group (Student)	T7PIQCHGRP
65	CHALL_GRP_TXT	☐	PIQCHGRPT	TEXT40	CHAR	40	0	Challenge Group (Description)
66	CHALL_PERC	☐	PIQCHALLPERC	DEC3_2	DEC	5	2	Degree of Challenge
67	CHALL_TYPE	☐	PIQCHTYP	PIQCHTYP	CHAR	2	0	Challenge Type	T7PIQCHTYP
68	CHALL_TYPE_TXT	☐	PIQCHTYPT	TEXT40	CHAR	40	0	Challenge Type (Description)
69	DATE_CHALL_CERT	☐	PIQSBAUD	DATUM	DATS	8	0	Expiry Date of ID for Challenged Persons
70	RESIDENCY_STATUS	☐	PIQRESIDSTATUS	RESIS	CHAR	1	0	Resident Status	*
71	RESIDENCY_STATUS_TXT	☐	RESTX	TEXT25	CHAR	25	0	Residence status texts
72	RESIDENCY_COUNTRY	☐	PIQRESIDCOUNTRY	LAND1	CHAR	3	0	Resident Country	T005
73	RESIDENCY_COUNTRY_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
74	NAMEOFRESIDENCYCOUNTRY	☐	LANDX	TEXT15	CHAR	15	0	Country Name
75	RESIDENCY_REGION	☐	PIQRESIDREGIO	REGIO	CHAR	3	0	Resident State	T005S
76	NAMEOFRESIDENCYSTATE	☐	BEZEI20	TEXT20	CHAR	20	0	Description
77	RESIDENCY_COUNTY	☐	PIQRESIDCOUNC	COUNC	CHAR	3	0	Resident County	T005E
78	NAMEOFRESIDENCYCOUNTY	☐	BEZEI20	TEXT20	CHAR	20	0	Description
79	ORIGIN	☐	PIQORIGIN	PIQORIGIN	CHAR	4	0	Origin	T7PIQORIGIN
80	ORIGIN_TXT	☐	PIQORIGINT	TEXT40	CHAR	40	0	Origin
81	ALTERNAT_STUDENT_NO	☐	PIQMATRIKEL	CHAR40	CHAR	40	0	Additional Identification Number
82	STUDENTGRP	☐	PIQSTGRP	PIQSTGRP	CHAR	4	0	Student Group	T7PIQSTGRP
83	STUDENTGRP_TXT	☐	PIQSTGRPT	TEXT40	CHAR	40	0	Student Group (Description)
84	STUDENT_FEE_CATEG	☐	PIQSTFEECAT	PIQSTFEECAT	CHAR	4	0	Student Fee Category	T7PIQSTFEECAT
85	STUDENT_FEE_CATEG_TXT	☐	PIQSTFEECATT	TEXT30	CHAR	30	0	Student Fee Category (Description)
86	BENEFIT_CATEG	☐	PIQBENCAT	PIQBENCAT	CHAR	4	0	Benefit Category	T7PIQBENCAT
87	BENEFIT_CATEG_TXT	☐	PIQBENCATT	TEXT30	CHAR	30	0	Benefit Category (Description)
88	ASSIGNED_ORGUNIT	☐	PIQSTORGUNIT_ASSIGNED	HROBJID	NUMC	8	0	Assigned Organizational Unit of Student	*
89	ASSIGNED_ORGUNIT_TXT	☐	PIQSTORGTX	TEXT40	CHAR	40	0	Name of the Student's Organizational Unit
90	ASSIGNED_ORGUNIT_SHT	☐	PIQSTORGSHT	TEXT12	CHAR	12	0	Organizational Unit of Student (Abbreviation)
91	CAMPUS	☐	PIQCAMPUS	HROBJID	NUMC	8	0	Campus	*
92	CAMPUS_TXT	☐	PIQCAMPUSTXT	TEXT40	CHAR	40	0	Campus Name
93	CAMPUS_SHT	☐	PIQCAMPUSSHT	TEXT12	CHAR	12	0	Campus Abbreviation
94	CONFIDENTIALITY	☐	PIQCONFID	PIQCONFID	CHAR	2	0	Data Privacy Level	T7PIQCONFID
95	CONFIDENTIALITY_TXT	☐	PIQCONFIDT	TEXT40	CHAR	40	0	Data Privacy Level (Description)
96	.INCLUDE	☐				0	0	CM Rules Structure for Addt'l Student Fields (Substitution)
97	PRINCIPAL_ORGUNIT	☐	PIQSTORGUNIT_PRINCIPAL	HROBJID	NUMC	8	0	Principal Organizational Unit of Student	*
98	PRINCIPAL_ORGUNIT_SHT	☐	PIQSTORGSHT	TEXT12	CHAR	12	0	Organizational Unit of Student (Abbreviation)
99	PRINCIPAL_ORGUNIT_TXT	☐	PIQSTORGTX	TEXT40	CHAR	40	0	Name of the Student's Organizational Unit
100	DERIVED_ORGUNIT	☐	PIQSTORGUNIT_DERIVED	HROBJID	NUMC	8	0	Derived Organizational Unit of Student	*
101	DERIVED_ORGUNIT_SHT	☐	PIQSTORG_DER_SHT	TEXT12	CHAR	12	0	Derived Organizational Unit of Student (Short Name)
102	DERIVED_ORGUNIT_TXT	☐	PIQSTORGTX	TEXT40	CHAR	40	0	Name of the Student's Organizational Unit
103	FT_PT_STATUS	☐	PIQSTFTPTSTATUS		CHAR	10	0	Part-Time Status of Student
104	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQRULESTUDENT	ARISTOCRATIC_TITLE	T535N	TITEL	REF	1	CN
2	PIQRULESTUDENT	BENEFIT_CATEG	T7PIQBENCAT	BENCAT
3	PIQRULESTUDENT	CHALL_GRP	T7PIQCHGRP	CHGRP	REF	1	CN
4	PIQRULESTUDENT	CHALL_TYPE	T7PIQCHTYP	CHTYP	REF	1	CN
5	PIQRULESTUDENT	CONFIDENTIALITY	T7PIQCONFID	CONFID
6	PIQRULESTUDENT	CORRESP_LANGUAGE	T002	SPRAS		1	CN
7	PIQRULESTUDENT	COUNTRY_OF_BIRTH	T005	LAND1		1	CN
8	PIQRULESTUDENT	DRIVERS_LICENSE_COUNTRY	T005	LAND1		1	CN
9	PIQRULESTUDENT	DRIVERS_LICENSE_REGION	T005S	BLAND		1	CN
10	PIQRULESTUDENT	ETHNIC_GRP	T7PIQETHNIC	ETHNIC		1	CN
11	PIQRULESTUDENT	FORM_OF_ADDRESS_KEY	T522G	ANRED		1	CN
12	PIQRULESTUDENT	JOB	T513C	TAETE		1	CN
13	PIQRULESTUDENT	MARITAL_STATUS	T502T	FAMST	REF	1	CN
14	PIQRULESTUDENT	NAME_AFFIX	T535N	TITEL	REF	1	CN
15	PIQRULESTUDENT	NATIONALITY_AT_BIRTH	T005	LAND1	REF	1	CN
16	PIQRULESTUDENT	ORIGIN	T7PIQORIGIN	ORIGIN	REF	1	CN
17	PIQRULESTUDENT	REGION_OF_BIRTH	T005S	BLAND	REF	1	CN
18	PIQRULESTUDENT	RELIGION	T516T	KONFE
19	PIQRULESTUDENT	RESIDENCY_COUNTRY	T005	LAND1	REF	1	CN
20	PIQRULESTUDENT	RESIDENCY_COUNTY	T005E	COUNC	REF	1	CN
21	PIQRULESTUDENT	RESIDENCY_REGION	T005S	BLAND	REF	1	CN
22	PIQRULESTUDENT	SOCIAL_GRP	T7PIQSOCIAL	SOCIAL		1	CN
23	PIQRULESTUDENT	STUDENTGRP	T7PIQSTGRP	STGRP	REF	1	CN
24	PIQRULESTUDENT	STUDENT_FEE_CATEG	T7PIQSTFEECAT	STFEECAT	REF	1	CN
25	PIQRULESTUDENT	TITEL	T535N	TITEL	REF	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in	462