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

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_S	Table Relationship Diagram
Short Description	CM US Legal Reporting : Structure for Data Transfer to DMEE

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	PIQ_US_ITEM	☐	PIQ_US_ITEM		STRU	0	0
2	IPEDSREPORT_DATEIDT	☐	PIQ_US_IPEDSIDNT	CHAR20	CHAR	20	0	Category Description
3	STUDENTNUMBER	☐	PIQSTUDENT12	PIQSTUDENT12	CHAR	12	0	Student Number
4	FIRST_NAME	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
5	LAST_NAME	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
6	DATE_BIRTH	☐	PIQ_GBDAT	GBDAT	DATS	8	0	Date of Birth
7	GENDER_KEY	☐	GESCH	GESCH	CHAR	1	0	Gender Key
8	STD_ETHNIC	☐	PIQETHNIC	PIQETHNIC	CHAR	4	0	Ethnic Origin
9	ETHNIC_GRP_TXT	☐	PIQETHNICT	TEXT40	CHAR	40	0	Ethnic Origin (Description)
10	RESIDENCY_STATUS	☐	PIQRESIDSTATUS	RESIS	CHAR	1	0	Resident Status
11	RESIDENCY_STATUS_TXT	☐	RESTX	TEXT25	CHAR	25	0	Residence status texts
12	RESIDENCY_COUNTRY	☐	PIQRESIDCOUNTRY	LAND1	CHAR	3	0	Resident Country
13	RESIDENCY_REGION	☐	PIQRESIDREGIO	REGIO	CHAR	3	0	Resident State
14	STUDENT_OBJECTID	☐	PIQST_OBJID	HROBJID	NUMC	8	0	Object ID of Student
15	STUDY_OBJECTID	☐	PIQCSOBJID	HROBJID	NUMC	8	0	Object ID of Study Object (CS)
16	PROGRAM_OBJECTID	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID
17	OPTLENGTH	☐	PIQLENGTH	PIQLENGTH	NUMC	4	0	Program Duration
18	TIMEUNIT	☐	PIQTIMEUNIT	PIQTIMEUNIT	NUMC	2	0	Time Unit for Program Duration
19	GRPVAR	☐	PIQSCCGVAR	PIQSCCGVAR	NUMC	3	0	Module Group Variant for Program
20	GRPVARTXT	☐	PIQSCCGVART	TEXT25	CHAR	25	0	Module Group Variant for Program (Description)
21	PROG_TYPE	☐	PIQPROGC_VAR	PIQPROGC_VAR	CHAR	4	0	Program Type
22	PROG_TYPET	☐	PIQPROGC_VART	TEXT30	CHAR	30	0	Program Type (Description)
23	PROGRESSION_RESULT	☐	PIQPROG_GR_RESULT_G	CHAR4	CHAR	4	0	Progression Result
24	MODULEGROUP_OBJECTID	☐	PIQCGOBJID	HROBJID	NUMC	8	0	Module Group ID
25	MODULEGROUP_CATEGORY	☐	PIQMODGRPCAT	PIQMODGRPCAT	CHAR	4	0	Module Group Category
26	CATEGORY_TEXT	☐	PIQMODGRPCATT	TEXT40	CHAR	40	0	Module Group Category (Description)
27	MODULEGROUP_PRIORITY	☐	PIQCGPRIOX	CHAR2	CHAR	2	0	Specialization Priority
28	ADMIS_CATEGORY	☐	PIQADM_CATEG	PIQADM_CATEG	CHAR	2	0	Admission Category
29	QUAL_LEVEL	☐	PIQQUAL_LEVEL	PIQQUAL_LEVEL	CHAR	4	0	Degree Type
30	QUAL_CLASS	☐	PIQQUAL_CLASS	PIQQUAL_CLASS	CHAR	4	0	Degree Level
31	CQ_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type
32	CQ_OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID
33	VALID_FROM	☐	PIQCONFERQ_VALID_FROM		DATS	8	0	Validity Start Date of Qualification Conferment
34	ACAD_YEAR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year
35	ACAC_SESSION	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session
36	REGIST_DATE	☐	PIQREGPERDATE	DATUM	DATS	8	0	Activity Key Date for Sessional Registration
37	PARTTIME	☐	PIQPARTT	XFELD	CHAR	1	0	Indicator: Part-Time Study
38	PROGCLASS	☐	PIQPROGCLASS	PIQPROGCLASS	CHAR	4	0	Progress Classification
39	CLASS_BEGDATE	☐	PIQ_US_IPEDS_CLASSBEGIN	DATUM	DATS	8	0	IPEDS: Class Start Date
40	DISPL	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline
41	MAJOR1	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
42	MAJOR1TEXT	☐	PIQMODGRPCATT	TEXT40	CHAR	40	0	Module Group Category (Description)
43	MAJOR1PRIO	☐	PRIOX	CHAR2	CHAR	2	0	Priority
44	MAJOR1DISP	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline
45	MAJOR1DISPTEXT	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
46	MAJOR2	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
47	MAJOR2TEXT	☐	PIQMODGRPCATT	TEXT40	CHAR	40	0	Module Group Category (Description)
48	MAJOR2PRIO	☐	PRIOX	CHAR2	CHAR	2	0	Priority
49	MAJOR2DISP	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline
50	MAJOR2DISPTEXT	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
51	CIPCODE_DERIVE	☐	PIQ_US_CIPDERIVE	PIQORG_DERIVATION	CHAR	1	0	IPEDS CIP Code Derivation
52	US_STUDENTLEVEL	☐	PIQ_US_STLEVEL	PIQ_US_STLEVEL	NUMC	1	0	IPEDS Student Level
53	STUDENT_LEVELT	☐	PIQ_US_STLEVELT	CHAR40	CHAR	40	0	IPEDS Student Level Description
54	US_ETHNIC	☐	PIQ_US_ETHNIC	NUMC2	NUMC	2	0	IPEDS US Ethnic Group Classification
55	ETHNICT	☐	PIQ_US_ETHNICT	CHAR40	CHAR	40	0	IPEDS Ethnic Group Description
56	US_CIPCODE	☐	PIQ_US_IPEDS_CIPCODE	PIQSMDISZIP	CHAR	16	0	IPEDS: CIP Code
57	END_PROCESS	☐	PIQPROCESS_END	PIQPROCESS	CHAR	4	0	Activity for De-registration from Program
58	END_REASON	☐	PIQDERREASON	PIQAPPREASON	NUMC	4	0	De-registration Reason
59	END_KEY_DATE	☐	PIQDERDATE	DATUM	DATS	8	0	Activity Key Date of De-registration
60	AWARD_LEVEL	☐	PIQ_US_AWARDLEVEL	PIQ_US_AWARDL	NUMC	2	0	IPEDS Award Level
61	AWARD_LEVELT	☐	PIQ_US_AWARDLEVELT		CHAR	75	0	IPEDS Award Level Description
62	FIRST_TIME	☐	PIQ_US_ADMNCAT	CHECKBOX	CHAR	1	0	IPEDS First-Time Student
63	SECOND_MAJOR	☐	PIQ_US_SECONDMAJOR	CHECKBOX	CHAR	1	0	IPEDS Second Major
64	DEGREE_SEEKING	☐	PIQ_US_DEGREESEEK	CHECKBOX	CHAR	1	0	IPEDS Degree-Seeking Students
65	CERTI_SEEKING	☐	PIQ_US_CERTISEEK	CHECKBOX	CHAR	1	0	IPEDS Certificate-Seeking Students
66	FALLENROLLMENT	☐	PIQ_US_FECIPCODE	CHECKBOX	CHAR	1	0	IPEDS Fall Enrollment CIP Code indicator
67	FPRCD	☐	FPRCD	FPRCD	CHAR	3	0	Provincial tax code
68	SPORTS_TYPE	☐	PIQ_US_SPORTSTYP	PIQ_US_SPORTSTYP	CHAR	3	0	IPEDS Sports Type
69	SVBYEAR	☐	PIQ_US_SVBYEAR	PIQPERYR	NUMC	4	0	IPEDS: Sports Validity Start Year
70	SVBSESSION	☐	PIQ_US_SVBSESSION	PIQPERID	NUMC	3	0	IPEDS: Sports Validity Start Session
71	SVEYEAR	☐	PIQ_US_SVEYEAR	PIQPERYR	NUMC	4	0	IPEDS: Sports Validity End Year
72	SVESESSION	☐	PIQ_US_SVESESSION	PIQPERID	NUMC	3	0	IPEDS: Sports Validity End Session
73	SCHOLARSHIP	☐	PIQ_US_SCHOLARSHIP	CHECKBOX	CHAR	1	0	IPEDS: Scholarship Applicability
74	TRANSTYPE	☐	PIQTRTRANSTYPE	PIQTRTRANSTYPE	CHAR	4	0	Transcript Category
75	REPSTATE	☐	PIQSTATEREP	PIQREPSTATE	CHAR	4	0	Transcript Status
76	ISSUEDATE	☐	PIQTRISSUEDATE	DATUM	DATS	8	0	Issue Date of External Transcript
77	HIGH_SCHOOL	☐	PIQ_US_HIGHSCHOOL	CHECKBOX	CHAR	1	0	IPEDS High-School Completion Indicator
78	CATEGORY	☐	PIQMODGRPCAT	PIQMODGRPCAT	CHAR	4	0	Module Group Category
79	MGCATMAJOR	☐	PIQ_US_MGCATMAJOR	CHECKBOX	CHAR	1	0	IPEDS Module Group Category as Major
80	RESID_STATUS	☐	PIQ_US_RESDSTATUS	CHECKBOX	CHAR	1	0	IPEDS Resident Alien
81	DEREG_REASON	☐	PIQ_US_GRSDEREG	PIQ_US_GRSDEREG	NUMC	1	0	IPEDS GRS Deregistration Reason
82	FIRST_YEAR	☐	PIQ_US_IPEDS_FY	CHECKBOX	CHAR	1	0	IPEDS First Year
83	GRS_LINE_SEC23	☐	PIQ_US_GRSSEC23	NUMC2	NUMC	2	0	IPEDS : GRS LINE status for Section 2 & 3
84	GRS_LINE_SEC6	☐	PIQ_US_GRSSEC6	NUMC2	NUMC	2	0	IPEDS : GRS LINE Status for Section 6
85	ST_GRS5	☐	PIQ_US_SPORTGRS5	CHAR2	CHAR	2	0	IPEDS Sports Type for GRS Section 5
86	ST_GRS6	☐	PIQ_US_SPORTGRS6	CHAR2	CHAR	2	0	IPEDS Sports Type for GRS Section 6
87	FE_LINE_PARTA	☐	PIQ_US_FELINEA	NUMC2	NUMC	2	0	IPEDS : FE LINE status in Part A
88	FE_LINE_PARTB	☐	PIQ_US_FELINEB	NUMC2	NUMC	2	0	IPEDS : FE LINE status Part B
89	FE_EFRES01_PARTC	☐	PIQ_US_EFRES01C	CHAR1	CHAR	1	0	IPEDS : Indicator First Time First Year degree seeking
90	FE_EFRES02_PARTC	☐	PIQ_US_EFRES02C	CHAR1	CHAR	1	0	IPEDS : Indicator First Time fresh-school in last 12 months
91	FE_EFE01_PARTD	☐	PIQ_US_EFE01D	CHAR1	CHAR	1	0	IPEDS : UG entered institution in Fall Term
92	FE_CREDHRSU_PARTF	☐	PIQ_US_FECREDHRSUF	NUM8	NUMC	8	0	IPEDS : 12 months Under Graduate Credit Hours
93	FE_CONTHRS_PARTF	☐	PIQ_US_FECONTHRSF	NUM8	NUMC	8	0	IPEDS : 12 months UG Contact Hours
94	FE_CREDHRSG_PARTF	☐	PIQ_US_FECREDHRSGF	NUM8	NUMC	8	0	IPEDS : 12 months Graduates Credit Hours
95	FE_REP_YEAR_PARTF	☐	PIQ_US_FEREPYEARF	NUMC1	NUMC	1	0	IPEDS : FE Reporting Year
96	BACHELOR_DEGREE	☐	PIQ_US_BACHELOR	CHECKBOX	CHAR	1	0	IPEDS : Indicator Bachelor Degree
97	IPEDSREPORT_DATEID	☐	PIQ_US_IPEDSIDN	CHAR2	CHAR	2	0	IPEDS : IPEDS Report date identification
98	PIQ_US_NSCH_ITEM	☐	PIQ_US_NSCH_ITEM		STRU	0	0
99	ORG_OBJECTID	☐	PD_OBJID_R	NUM08	NUMC	8	0	Object ID
100	STUDENT_OBJID	☐	PIQST_OBJID	HROBJID	NUMC	8	0	Object ID of Student
101	STUDENTNUMBER	☐	PIQSTUDENT12	PIQSTUDENT12	CHAR	12	0	Student Number
102	PERSIDNO	☐	PIQ_PRDNI	CHAR20	CHAR	20	0	Identification Number
103	FIRST_NAME	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
104	MIDDLE_NAME	☐	PAD_MIDNM	PAD_VORNM	CHAR	40	0	Middle Name
105	LAST_NAME	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
106	INITIALS	☐	INITS	TEXT10	CHAR	10	0	Initials
107	NAME_AT_BIRTH	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
108	ENROLLMENT_STATUS	☐	PIQ_US_NSCH_ENROLSTS	PIQ_US_NSCH_ENROLSTS_DOM	CHAR	1	0	NSCH Enrollment Status of the student
109	ENROLL_START_DATE	☐	DATUM	DATUM	DATS	8	0	Date
110	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
111	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
112	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
113	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
114	POSTL_COD1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
115	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
116	ANTICIP_GRAD_DATE	☐	PIQAGD_DATE	DATE	DATS	8	0	Anticipated Graduation Date
117	DATE_BIRTH	☐	PIQ_GBDAT	GBDAT	DATS	8	0	Date of Birth
118	TERM_BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
119	TERM_ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
120	NSCH_GRAD_LEVEL	☐	PIQ_US_NSCH_GRADLEVEL	CHECKBOX	CHAR	1	0	NSCH Graduation Level Indicator
121	DATA_BLOCK_INDICATOR	☐	PIQ_US_NSCH_CONFID	CHECKBOX	CHAR	1	0	NSCH Confidentiality Indicator
122	NSCH_DEGREE_LEVEL	☐	PIQ_US_NSCH_DEGLEVEL	PIQ_US_NSCH_DEGLEVEL_DOM	CHAR	1	0	NSCH Degree Level
123	CQ_OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID
124	QUAL_DESC	☐	PIQCQ_STEXT	TEXT40	CHAR	40	0	Internal Qualification (Description)
125	QUAL_SHORT	☐	PIQCQ_SHORT	TEXT12	CHAR	12	0	Internal Qualification
126	SCHOOL_AWARDING_DEGREE	☐	STEXT	TEXT40	CHAR	40	0	Object Name
127	QUAL_CONFER_DATE	☐	PIQCONFERQ_DATE		DATS	8	0	Date of Qualification Conferment
128	PROGRAM_OBJECTID	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID
129	PROGRAM_NAME	☐	PIQAGRSTUDEY	CHAR40	CHAR	40	0	Program
130	REGIST_DATE	☐	PIQREGPERDATE	DATUM	DATS	8	0	Activity Key Date for Sessional Registration
131	MAJOR1	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
132	MAJOR2	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
133	MAJOR3	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
134	MAJOR4	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
135	MINOR1	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
136	MINOR2	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
137	MINOR3	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
138	MINOR4	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
139	MAJOR1_TXT	☐	PIQCGSTEXT	TEXT40	CHAR	40	0	Module Group (Description)
140	MAJOR2_TXT	☐	PIQCGSTEXT	TEXT40	CHAR	40	0	Module Group (Description)
141	MAJOR3_TXT	☐	PIQCGSTEXT	TEXT40	CHAR	40	0	Module Group (Description)
142	MAJOR4_TXT	☐	PIQCGSTEXT	TEXT40	CHAR	40	0	Module Group (Description)
143	MINOR1_TXT	☐	PIQCGSTEXT	TEXT40	CHAR	40	0	Module Group (Description)
144	MINOR2_TXT	☐	PIQCGSTEXT	TEXT40	CHAR	40	0	Module Group (Description)
145	MINOR3_TXT	☐	PIQCGSTEXT	TEXT40	CHAR	40	0	Module Group (Description)
146	MINOR4_TXT	☐	PIQCGSTEXT	TEXT40	CHAR	40	0	Module Group (Description)
147	CIP_MAJOR1	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline
148	CIP_MAJOR2	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline
149	CIP_MAJOR3	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline
150	CIP_MAJOR4	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline
151	CIP_MINOR1	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline
152	CIP_MINOR2	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline
153	CIP_MINOR3	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline
154	CIP_MINOR4	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline
155	CIP_TXT_MAJOR1	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
156	CIP_TXT_MAJOR2	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
157	CIP_TXT_MAJOR3	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
158	CIP_TXT_MAJOR4	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
159	CIP_TXT_MINOR1	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
160	CIP_TXT_MINOR2	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
161	CIP_TXT_MINOR3	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
162	CIP_TXT_MINOR4	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
163	CLASS	☐	PIQ_US_CLASS	PIQ_US_CLASS	CHAR	1	0	Progression Class Result for a Progression Category.
164	FIRST_TIME_FULL_TIME	☐	PIQ_US_UNDERGRAD_FLAG	PIQ_US_YES_NO_FLAG	CHAR	1	0	First Time Full Time
165	DEGREE_SEEKING	☐	PIQ_US_DEGREE_SEEKING	PIQ_US_YES_NO_FLAG	CHAR	1	0	Degree Seeking
166	HIGH_SCHOOL_CODE	☐	PIQ_US_HIGHSCHOOL_CODE	NUMC06	NUMC	6	0	High School Code
167	GENDER	☐	PIQ_US_GENDER	PIQ_US_GENDER	CHAR	1	0	Gender of Student
168	RACE_ETHINICITY	☐	PIQ_US_RACE_ETHNICITY	CHAR02	CHAR	2	0	Race/Ethnicity
169	COLLEGE_STUDENT_ID	☐	PIQ_US_COLLEGE_STUD_ID	PIQ_US_COLLEGE_STUD_ID	CHAR	20	0	College Student Id
170	STATE_STUDENT_ID	☐	PIQ_US_STATE_STUD_ID	PIQ_US_STATE_STUD_ID	CHAR	30	0	State Student Id
171	EMAIL_ID	☐	PMIQ_US_EMAIL	PMIQ_US_EMAIL	CHAR	128	0	Email Address of Student
172	GOOD_STUDENT	☐	PMIQ_US_GOOD_STUDENT	PIQ_US_YES_NO_FLAG	CHAR	1	0	Good Student

History

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