SAP ABAP Table PIQ_US_ITEM (Structure for Data Transfer to DMEE : CM US Legal Reporting)

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-US (Application Component) USA
     ⤷ PMIQ_US (Package) Campus Management USA

Basic Data

Table Category	INTTAB	Structure
Structure	PIQ_US_ITEM	Table Relationship Diagram
Short Description	Structure for Data Transfer to DMEE : CM US Legal Reporting

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	IPEDSREPORT_DATEIDT	☐	PIQ_US_IPEDSIDNT	CHAR20	CHAR	20	0	Category Description
2	STUDENTNUMBER	☐	PIQSTUDENT12	PIQSTUDENT12	CHAR	12	0	Student Number
3	FIRST_NAME	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
4	LAST_NAME	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
5	DATE_BIRTH	☐	PIQ_GBDAT	GBDAT	DATS	8	0	Date of Birth
6	GENDER_KEY	☐	GESCH	GESCH	CHAR	1	0	Gender Key
7	STD_ETHNIC	☐	PIQETHNIC	PIQETHNIC	CHAR	4	0	Ethnic Origin	*
8	ETHNIC_GRP_TXT	☐	PIQETHNICT	TEXT40	CHAR	40	0	Ethnic Origin (Description)
9	RESIDENCY_STATUS	☐	PIQRESIDSTATUS	RESIS	CHAR	1	0	Resident Status	*
10	RESIDENCY_STATUS_TXT	☐	RESTX	TEXT25	CHAR	25	0	Residence status texts
11	RESIDENCY_COUNTRY	☐	PIQRESIDCOUNTRY	LAND1	CHAR	3	0	Resident Country	*
12	RESIDENCY_REGION	☐	PIQRESIDREGIO	REGIO	CHAR	3	0	Resident State	*
13	STUDENT_OBJECTID	☐	PIQST_OBJID	HROBJID	NUMC	8	0	Object ID of Student	*
14	STUDY_OBJECTID	☐	PIQCSOBJID	HROBJID	NUMC	8	0	Object ID of Study Object (CS)	*
15	PROGRAM_OBJECTID	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID	*
16	OPTLENGTH	☐	PIQLENGTH	PIQLENGTH	NUMC	4	0	Program Duration
17	TIMEUNIT	☐	PIQTIMEUNIT	PIQTIMEUNIT	NUMC	2	0	Time Unit for Program Duration	*
18	GRPVAR	☐	PIQSCCGVAR	PIQSCCGVAR	NUMC	3	0	Module Group Variant for Program	*
19	GRPVARTXT	☐	PIQSCCGVART	TEXT25	CHAR	25	0	Module Group Variant for Program (Description)
20	PROG_TYPE	☐	PIQPROGC_VAR	PIQPROGC_VAR	CHAR	4	0	Program Type	*
21	PROG_TYPET	☐	PIQPROGC_VART	TEXT30	CHAR	30	0	Program Type (Description)
22	PROGRESSION_RESULT	☐	PIQPROG_GR_RESULT_G	CHAR4	CHAR	4	0	Progression Result
23	MODULEGROUP_OBJECTID	☐	PIQCGOBJID	HROBJID	NUMC	8	0	Module Group ID	*
24	MODULEGROUP_CATEGORY	☐	PIQMODGRPCAT	PIQMODGRPCAT	CHAR	4	0	Module Group Category	*
25	CATEGORY_TEXT	☐	PIQMODGRPCATT	TEXT40	CHAR	40	0	Module Group Category (Description)
26	MODULEGROUP_PRIORITY	☐	PIQCGPRIOX	CHAR2	CHAR	2	0	Specialization Priority
27	ADMIS_CATEGORY	☐	PIQADM_CATEG	PIQADM_CATEG	CHAR	2	0	Admission Category	*
28	QUAL_LEVEL	☐	PIQQUAL_LEVEL	PIQQUAL_LEVEL	CHAR	4	0	Degree Type	*
29	QUAL_CLASS	☐	PIQQUAL_CLASS	PIQQUAL_CLASS	CHAR	4	0	Degree Level	*
30	CQ_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
31	CQ_OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
32	VALID_FROM	☐	PIQCONFERQ_VALID_FROM		DATS	8	0	Validity Start Date of Qualification Conferment
33	ACAD_YEAR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	*
34	ACAC_SESSION	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	*
35	REGIST_DATE	☐	PIQREGPERDATE	DATUM	DATS	8	0	Activity Key Date for Sessional Registration
36	PARTTIME	☐	PIQPARTT	XFELD	CHAR	1	0	Indicator: Part-Time Study
37	PROGCLASS	☐	PIQPROGCLASS	PIQPROGCLASS	CHAR	4	0	Progress Classification	*
38	CLASS_BEGDATE	☐	PIQ_US_IPEDS_CLASSBEGIN	DATUM	DATS	8	0	IPEDS: Class Start Date
39	DISPL	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline	*
40	MAJOR1	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
41	MAJOR1TEXT	☐	PIQMODGRPCATT	TEXT40	CHAR	40	0	Module Group Category (Description)
42	MAJOR1PRIO	☐	PRIOX	CHAR2	CHAR	2	0	Priority
43	MAJOR1DISP	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline	*
44	MAJOR1DISPTEXT	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
45	MAJOR2	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
46	MAJOR2TEXT	☐	PIQMODGRPCATT	TEXT40	CHAR	40	0	Module Group Category (Description)
47	MAJOR2PRIO	☐	PRIOX	CHAR2	CHAR	2	0	Priority
48	MAJOR2DISP	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline	*
49	MAJOR2DISPTEXT	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
50	CIPCODE_DERIVE	☐	PIQ_US_CIPDERIVE	PIQORG_DERIVATION	CHAR	1	0	IPEDS CIP Code Derivation
51	US_STUDENTLEVEL	☐	PIQ_US_STLEVEL	PIQ_US_STLEVEL	NUMC	1	0	IPEDS Student Level	*
52	STUDENT_LEVELT	☐	PIQ_US_STLEVELT	CHAR40	CHAR	40	0	IPEDS Student Level Description
53	US_ETHNIC	☐	PIQ_US_ETHNIC	NUMC2	NUMC	2	0	IPEDS US Ethnic Group Classification
54	ETHNICT	☐	PIQ_US_ETHNICT	CHAR40	CHAR	40	0	IPEDS Ethnic Group Description
55	US_CIPCODE	☐	PIQ_US_IPEDS_CIPCODE	PIQSMDISZIP	CHAR	16	0	IPEDS: CIP Code	*
56	END_PROCESS	☐	PIQPROCESS_END	PIQPROCESS	CHAR	4	0	Activity for De-registration from Program	*
57	END_REASON	☐	PIQDERREASON	PIQAPPREASON	NUMC	4	0	De-registration Reason	*
58	END_KEY_DATE	☐	PIQDERDATE	DATUM	DATS	8	0	Activity Key Date of De-registration
59	AWARD_LEVEL	☐	PIQ_US_AWARDLEVEL	PIQ_US_AWARDL	NUMC	2	0	IPEDS Award Level	*
60	AWARD_LEVELT	☐	PIQ_US_AWARDLEVELT		CHAR	75	0	IPEDS Award Level Description
61	FIRST_TIME	☐	PIQ_US_ADMNCAT	CHECKBOX	CHAR	1	0	IPEDS First-Time Student
62	SECOND_MAJOR	☐	PIQ_US_SECONDMAJOR	CHECKBOX	CHAR	1	0	IPEDS Second Major
63	DEGREE_SEEKING	☐	PIQ_US_DEGREESEEK	CHECKBOX	CHAR	1	0	IPEDS Degree-Seeking Students
64	CERTI_SEEKING	☐	PIQ_US_CERTISEEK	CHECKBOX	CHAR	1	0	IPEDS Certificate-Seeking Students
65	FALLENROLLMENT	☐	PIQ_US_FECIPCODE	CHECKBOX	CHAR	1	0	IPEDS Fall Enrollment CIP Code indicator
66	FPRCD	☐	FPRCD	FPRCD	CHAR	3	0	Provincial tax code
67	SPORTS_TYPE	☐	PIQ_US_SPORTSTYP	PIQ_US_SPORTSTYP	CHAR	3	0	IPEDS Sports Type	*
68	SVBYEAR	☐	PIQ_US_SVBYEAR	PIQPERYR	NUMC	4	0	IPEDS: Sports Validity Start Year	*
69	SVBSESSION	☐	PIQ_US_SVBSESSION	PIQPERID	NUMC	3	0	IPEDS: Sports Validity Start Session	*
70	SVEYEAR	☐	PIQ_US_SVEYEAR	PIQPERYR	NUMC	4	0	IPEDS: Sports Validity End Year	*
71	SVESESSION	☐	PIQ_US_SVESESSION	PIQPERID	NUMC	3	0	IPEDS: Sports Validity End Session	*
72	SCHOLARSHIP	☐	PIQ_US_SCHOLARSHIP	CHECKBOX	CHAR	1	0	IPEDS: Scholarship Applicability
73	TRANSTYPE	☐	PIQTRTRANSTYPE	PIQTRTRANSTYPE	CHAR	4	0	Transcript Category	*
74	REPSTATE	☐	PIQSTATEREP	PIQREPSTATE	CHAR	4	0	Transcript Status	*
75	ISSUEDATE	☐	PIQTRISSUEDATE	DATUM	DATS	8	0	Issue Date of External Transcript
76	HIGH_SCHOOL	☐	PIQ_US_HIGHSCHOOL	CHECKBOX	CHAR	1	0	IPEDS High-School Completion Indicator
77	CATEGORY	☐	PIQMODGRPCAT	PIQMODGRPCAT	CHAR	4	0	Module Group Category	*
78	MGCATMAJOR	☐	PIQ_US_MGCATMAJOR	CHECKBOX	CHAR	1	0	IPEDS Module Group Category as Major
79	RESID_STATUS	☐	PIQ_US_RESDSTATUS	CHECKBOX	CHAR	1	0	IPEDS Resident Alien
80	DEREG_REASON	☐	PIQ_US_GRSDEREG	PIQ_US_GRSDEREG	NUMC	1	0	IPEDS GRS Deregistration Reason	*
81	FIRST_YEAR	☐	PIQ_US_IPEDS_FY	CHECKBOX	CHAR	1	0	IPEDS First Year
82	GRS_LINE_SEC23	☐	PIQ_US_GRSSEC23	NUMC2	NUMC	2	0	IPEDS : GRS LINE status for Section 2 & 3
83	GRS_LINE_SEC6	☐	PIQ_US_GRSSEC6	NUMC2	NUMC	2	0	IPEDS : GRS LINE Status for Section 6
84	ST_GRS5	☐	PIQ_US_SPORTGRS5	CHAR2	CHAR	2	0	IPEDS Sports Type for GRS Section 5
85	ST_GRS6	☐	PIQ_US_SPORTGRS6	CHAR2	CHAR	2	0	IPEDS Sports Type for GRS Section 6
86	FE_LINE_PARTA	☐	PIQ_US_FELINEA	NUMC2	NUMC	2	0	IPEDS : FE LINE status in Part A
87	FE_LINE_PARTB	☐	PIQ_US_FELINEB	NUMC2	NUMC	2	0	IPEDS : FE LINE status Part B
88	FE_EFRES01_PARTC	☐	PIQ_US_EFRES01C	CHAR1	CHAR	1	0	IPEDS : Indicator First Time First Year degree seeking
89	FE_EFRES02_PARTC	☐	PIQ_US_EFRES02C	CHAR1	CHAR	1	0	IPEDS : Indicator First Time fresh-school in last 12 months
90	FE_EFE01_PARTD	☐	PIQ_US_EFE01D	CHAR1	CHAR	1	0	IPEDS : UG entered institution in Fall Term
91	FE_CREDHRSU_PARTF	☐	PIQ_US_FECREDHRSUF	NUM8	NUMC	8	0	IPEDS : 12 months Under Graduate Credit Hours
92	FE_CONTHRS_PARTF	☐	PIQ_US_FECONTHRSF	NUM8	NUMC	8	0	IPEDS : 12 months UG Contact Hours
93	FE_CREDHRSG_PARTF	☐	PIQ_US_FECREDHRSGF	NUM8	NUMC	8	0	IPEDS : 12 months Graduates Credit Hours
94	FE_REP_YEAR_PARTF	☐	PIQ_US_FEREPYEARF	NUMC1	NUMC	1	0	IPEDS : FE Reporting Year
95	BACHELOR_DEGREE	☐	PIQ_US_BACHELOR	CHECKBOX	CHAR	1	0	IPEDS : Indicator Bachelor Degree
96	IPEDSREPORT_DATEID	☐	PIQ_US_IPEDSIDN	CHAR2	CHAR	2	0	IPEDS : IPEDS Report date identification

History

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