SAP ABAP Table PIQRULEAPP (Application 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	PIQRULEAPP	Table Relationship Diagram
Short Description	Application 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	.INCLU-P	☐				0	0	Application: Personal Data
2	FIRST_NAMEP	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
3	LAST_NAMEP	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
4	MIDDLE_NAMEP	☐	PAD_MIDNM	PAD_VORNM	CHAR	40	0	Middle Name
5	NICKNAMEP	☐	PIQ_RUFNM	PAD_VORNM	CHAR	40	0	Known As
6	INITIALSP	☐	INITS	TEXT10	CHAR	10	0	Initials
7	NAME_AFFIXP	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
8	ARISTOCRATIC_TITLEP	☐	NAMZU	TITEL	CHAR	15	0	Other Title	T535N
9	TITELP	☐	TITEL	TITEL	CHAR	15	0	Title	T535N
10	FORM_OF_ADDRESS_KEYP	☐	ANRDE	ANRDE	CHAR	1	0	Form-of-Address Key	T522G
11	NAME_AT_BIRTHP	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
12	DATE_BIRTHP	☐	PIQ_GBDAT	GBDAT	DATS	8	0	Date of Birth
13	COUNTRY_OF_BIRTHP	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
14	REGION_OF_BIRTHP	☐	PIQ_GBDEP	REGIO	CHAR	3	0	Region of Birth (State, Province, County)	T005S
15	BIRTHPLACEP	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
16	NATIONALITY_AT_BIRTHP	☐	PIQ_GBNAT	LAND1	CHAR	3	0	Nationality (Citizenship) at Birth	*
17	NATIONALITYP	☐	NATSL	LAND1	CHAR	3	0	Nationality	*
18	SECOND_NATIONALITYP	☐	NATS2	LAND1	CHAR	3	0	Second Nationality	*
19	THIRD_NATIONALITYP	☐	NATS3	LAND1	CHAR	3	0	Third Nationality	*
20	CORRESP_LANGUAGEP	☐	PIQ_SPRAS	SPRAS	LANG	1	0	Language of Communication	T002
21	PERSIDNOP	☐	PIQ_PRDNI	CHAR20	CHAR	20	0	Identification Number
22	GENDER_KEYP	☐	GESCH	GESCH	CHAR	1	0	Gender Key
23	MARITAL_STATUSP	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	T502T
24	.INCLUDE	☐				0	0	Application: Additional Personal Data
25	RELIGION	☐	PIQKONFE	KONFE	CHAR	2	0	Religious Denomination Key	T516T
26	ETHNIC_GRP	☐	PIQETHNIC	PIQETHNIC	CHAR	4	0	Ethnic Origin	T7PIQETHNIC
27	JOB	☐	PIQTAETE	TAESL	NUMC	8	0	Student's Job	T513C
28	SOCIAL_GRP	☐	PIQSOCIAL	PIQSOCIAL	CHAR	2	0	Social Class	T7PIQSOCIAL
29	SERVICE_STATUS	☐	PIQSERV_STAT	MILSA	NUMC	2	0	Service Status	T505M
30	SERVICE_NUMBER	☐	PIQSERV_NR		CHAR	20	0	Service Number
31	VETERAN_NUMBER	☐	PIQVETERAN_NR		CHAR	20	0	Veteran Administration Number
32	DRIVERS_LICENSE_COUNTRY	☐	DR_LIC_LAND1_PS	LAND1	CHAR	3	0	Country in Which Driver's License Was Issued	T005
33	DRIVERS_LICENSE_REGION	☐	DR_LIC_REGIO_PS	REGIO	CHAR	3	0	Region in Which Driver's License Was Issued	T005S
34	DRIVERS_LICENSE_NO	☐	DR_LIC_NO_PS		CHAR	20	0	Driver's License Number
35	.INCLUDE	☐				0	0	Application: Address Data
36	ADDRESS_TYPE	☐	SUBTYP	SUBTYP	CHAR	4	0	Subtype	*
37	HOUSE_NO	☐	HAUSN_BAS	CHAR6	CHAR	6	0	House number
38	STREET	☐	PD_STRAS	TEXT30	CHAR	30	0	House Number and Street
39	STREET2	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
40	CITY	☐	KORT	TEXT40	CHAR	40	0	City
41	POSTAL_CD	☐	PD_PSTLZ	PSTLZ	CHAR	10	0	Postal Code
42	COUNTRY	☐	KLAND	LAND1	CHAR	3	0	Country	T005
43	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
44	TEL_NO	☐	TELENR	CHAR25	CHAR	25	0	Telephone Number
45	FAX_NO	☐	FAXNR	CHAR25	CHAR	25	0	Fax Number
46	.INCLUDE	☐				0	0	Application: Admission Data
47	SC_OBJID	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID	*
48	.INCLUDE	☐				0	0	Additional Relationship Data
49	CHOICE_NO	☐	PIQCHOICE_NO	PIQCHOICE_NO	NUMC	2	0	Program Choice	*
50	ADM_AYEAR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	*
51	ADM_PERID	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	*
52	ADM_ACLEVEL	☐	PIQLEVEL	PIQLEVEL	NUMC	2	0	Stage	*
53	ADM_PROGCLASS	☐	PIQPROGCLASS	PIQPROGCLASS	CHAR	4	0	Progress Classification	*
54	ADM_PARTT	☐	PIQPARTT	XFELD	CHAR	1	0	Indicator: Part-Time Study
55	ADM_CATEG	☐	PIQADM_CATEG	PIQADM_CATEG	CHAR	2	0	Admission Category	*
56	ADM_ENRCATEG	☐	PIQENRCATEG	PIQENRCATEG	CHAR	2	0	Registration Type	*
57	ADM_CODE	☐	PIQADMCODE	CHAR12	CHAR	12	0	Admission Code
58	ADM_PERCT	☐	PIQPERCT	PIQPERCT	NUMC	3	0	Completed Length of Study
59	ADM_QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	*
60	ADM_STATUS_SUP	☐	PIQADMSTSUP	PIQPROCESSSTSUP	CHAR	4	0	Status Supplement
61	ADM_DEC	☐	PIQADM_DEC	DATS	DATS	8	0	Decision Date of Rejection or Admission
62	ADM_RECPT	☐	PIQADM_RECPT	DATS	DATS	8	0	Date of Admission Application Receipt
63	ADM_WITH_DECL	☐	PIQADM_WITH_DECL	DATS	DATS	8	0	Date of Withdrawal or Declination
64	ADM_GUID	☐	PIQADM_GUID	SYSUUID_C	CHAR	32	0	Unique Key (GUID) of the Admission
65	COKEY	☐	COKEY_KK	COKEY_KK	CHAR	36	0	Correspondence key
66	.INCLUDE	☐				0	0
67	ADM_ACTIVITY	☐	PIQADM_ACTIVITY	PIQPROCESS	CHAR	4	0	Admission Activity	T7PIQPROCESS
68	.INCLUDE	☐				0	0	Application: Campus Data
69	CAMPUS	☐	PIQCAMPUS	HROBJID	NUMC	8	0	Campus	*
70	.INCLUDE	☐				0	0	Application: Challenge Data
71	CHALL_GRP	☐	PIQCHGRP	PIQCHGRP	CHAR	2	0	Challenge Group (Student)	T7PIQCHGRP
72	CHALL_PERC	☐	PIQCHALLPERC	DEC3_2	DEC	5	2	Degree of Challenge
73	CHALL_TYPE	☐	PIQCHTYP	PIQCHTYP	CHAR	2	0	Challenge Type	T7PIQCHTYP
74	DATE_CHALL_CERT	☐	PIQSBAUD	DATUM	DATS	8	0	Expiry Date of ID for Challenged Persons
75	.INCLUDE	☐				0	0	Application: E-Mail Data
76	E_MAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
77	.INCLUDE	☐				0	0	Application: Residence Data
78	RESIDENCY_STATUS	☐	PIQRESIDSTATUS	RESIS	CHAR	1	0	Resident Status	*
79	RESIDENCY_COUNTRY	☐	PIQRESIDCOUNTRY	LAND1	CHAR	3	0	Resident Country	T005
80	RESIDENCY_REGION	☐	PIQRESIDREGIO	REGIO	CHAR	3	0	Resident State	T005S
81	RESIDENCY_COUNTY	☐	PIQRESIDCOUNC	COUNC	CHAR	3	0	Resident County	T005E
82	PASSPORT_NUMBER	☐	PIQPASSN	PIQPASSN	CHAR	20	0	Passport Number
83	.INCLUDE	☐				0	0	Application: Program Data
84	ALTERNAT_STUDENT_NO	☐	PIQMATRIKEL	CHAR40	CHAR	40	0	Additional Identification Number
85	STUDENTGRP	☐	PIQSTGRP	PIQSTGRP	CHAR	4	0	Student Group	T7PIQSTGRP
86	.INCLUDE	☐				0	0	Application: Visa Data
87	VISA_TYPE	☐	PIQVISATYPE	PIQVISATYPE	CHAR	4	0	Visa/Registration Type	T7PIQVISATYPE
88	VISA_NUMBER	☐	PIQVISANUMBER	TEXT20	CHAR	20	0	Visa/Registration Number
89	VALID_FROM	☐	PIQVISABEGDA	DATUM	DATS	8	0	Visa / Registration Validity Start Date
90	VALID_UNTIL	☐	PIQVISAENDDA	DATUM	DATS	8	0	Visa / Registration Validity End Date
91	DATE_OF_ISSUE	☐	PIQVISADATE	DATS	DATS	8	0	Date of Issue for VISA/Registration
92	ISSUING_INSTITUTION	☐	PIQVISAINST	TEXT40	CHAR	40	0	Issuing Government / Authority
93	ISSUING_COUNTRY	☐	PIQVISACTRY	LAND1	CHAR	3	0	Country of Issue for VISA/Registration	T005
94	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQRULEAPP	ADM_ACTIVITY	T7PIQPROCESS	PROCESS	REF	1	CN
2	PIQRULEAPP	ARISTOCRATIC_TITLEP	T535N	TITEL	REF	1	CN
3	PIQRULEAPP	CHALL_GRP	T7PIQCHGRP	CHGRP	REF	1	CN
4	PIQRULEAPP	CHALL_TYPE	T7PIQCHTYP	CHTYP	REF	1	CN
5	PIQRULEAPP	CORRESP_LANGUAGEP	T002	SPRAS	REF	1	CN
6	PIQRULEAPP	COUNTRY	T005	LAND1
7	PIQRULEAPP	COUNTRY_OF_BIRTHP	T005	LAND1	REF	1	CN
8	PIQRULEAPP	DRIVERS_LICENSE_COUNTRY	T005	LAND1	REF	1	CN
9	PIQRULEAPP	DRIVERS_LICENSE_REGION	T005S	BLAND	REF	1	CN
10	PIQRULEAPP	ETHNIC_GRP	T7PIQETHNIC	ETHNIC
11	PIQRULEAPP	FORM_OF_ADDRESS_KEYP	T522G	ANRED	REF	1	CN
12	PIQRULEAPP	ISSUING_COUNTRY	T005	LAND1	KEY	1	CN
13	PIQRULEAPP	JOB	T513C	TAETE
14	PIQRULEAPP	MARITAL_STATUSP	T502T	FAMST	REF	1	CN
15	PIQRULEAPP	NAME_AFFIXP	T535N	TITEL	REF	1	CN
16	PIQRULEAPP	REGION	T005S	BLAND
17	PIQRULEAPP	REGION_OF_BIRTHP	T005S	BLAND	REF	1	CN
18	PIQRULEAPP	RELIGION	T516T	KONFE
19	PIQRULEAPP	RESIDENCY_COUNTRY	T005	LAND1	REF	1	CN
20	PIQRULEAPP	RESIDENCY_COUNTY	T005E	COUNC	REF	1	CN
21	PIQRULEAPP	RESIDENCY_REGION	T005S	BLAND	REF	1	CN
22	PIQRULEAPP	SERVICE_STATUS	T505M	MILSA
23	PIQRULEAPP	SOCIAL_GRP	T7PIQSOCIAL	SOCIAL		1	CN
24	PIQRULEAPP	STUDENTGRP	T7PIQSTGRP	STGRP		1	CN
25	PIQRULEAPP	TITELP	T535N	TITEL	REF	1	CN
26	PIQRULEAPP	VISA_TYPE	T7PIQVISATYPE	VISATYPE	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	463