SAP ABAP Table PIQ_US_NSCH_ITEM (Structure to form DMEE format tree for CM US NSCH Report)

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_NSCH_ITEM	Table Relationship Diagram
Short Description	Structure to form DMEE format tree for CM US NSCH Report

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	ORG_OBJECTID	☐	PD_OBJID_R	NUM08	NUMC	8	0	Object ID
2	STUDENT_OBJID	☐	PIQST_OBJID	HROBJID	NUMC	8	0	Object ID of Student	*
3	STUDENTNUMBER	☐	PIQSTUDENT12	PIQSTUDENT12	CHAR	12	0	Student Number
4	PERSIDNO	☐	PIQ_PRDNI	CHAR20	CHAR	20	0	Identification Number
5	FIRST_NAME	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
6	MIDDLE_NAME	☐	PAD_MIDNM	PAD_VORNM	CHAR	40	0	Middle Name
7	LAST_NAME	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
8	INITIALS	☐	INITS	TEXT10	CHAR	10	0	Initials
9	NAME_AT_BIRTH	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
10	ENROLLMENT_STATUS	☐	PIQ_US_NSCH_ENROLSTS	PIQ_US_NSCH_ENROLSTS_DOM	CHAR	1	0	NSCH Enrollment Status of the student
11	ENROLL_START_DATE	☐	DATUM	DATUM	DATS	8	0	Date
12	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
13	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
14	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
15	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
16	POSTL_COD1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
17	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
18	ANTICIP_GRAD_DATE	☐	PIQAGD_DATE	DATE	DATS	8	0	Anticipated Graduation Date
19	DATE_BIRTH	☐	PIQ_GBDAT	GBDAT	DATS	8	0	Date of Birth
20	TERM_BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
21	TERM_ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
22	NSCH_GRAD_LEVEL	☐	PIQ_US_NSCH_GRADLEVEL	CHECKBOX	CHAR	1	0	NSCH Graduation Level Indicator
23	DATA_BLOCK_INDICATOR	☐	PIQ_US_NSCH_CONFID	CHECKBOX	CHAR	1	0	NSCH Confidentiality Indicator
24	NSCH_DEGREE_LEVEL	☐	PIQ_US_NSCH_DEGLEVEL	PIQ_US_NSCH_DEGLEVEL_DOM	CHAR	1	0	NSCH Degree Level
25	CQ_OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
26	QUAL_DESC	☐	PIQCQ_STEXT	TEXT40	CHAR	40	0	Internal Qualification (Description)
27	QUAL_SHORT	☐	PIQCQ_SHORT	TEXT12	CHAR	12	0	Internal Qualification
28	SCHOOL_AWARDING_DEGREE	☐	STEXT	TEXT40	CHAR	40	0	Object Name
29	QUAL_CONFER_DATE	☐	PIQCONFERQ_DATE		DATS	8	0	Date of Qualification Conferment
30	PROGRAM_OBJECTID	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID	*
31	PROGRAM_NAME	☐	PIQAGRSTUDEY	CHAR40	CHAR	40	0	Program
32	REGIST_DATE	☐	PIQREGPERDATE	DATUM	DATS	8	0	Activity Key Date for Sessional Registration
33	MAJOR1	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
34	MAJOR2	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
35	MAJOR3	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
36	MAJOR4	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
37	MINOR1	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
38	MINOR2	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
39	MINOR3	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
40	MINOR4	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
41	MAJOR1_TXT	☐	PIQCGSTEXT	TEXT40	CHAR	40	0	Module Group (Description)
42	MAJOR2_TXT	☐	PIQCGSTEXT	TEXT40	CHAR	40	0	Module Group (Description)
43	MAJOR3_TXT	☐	PIQCGSTEXT	TEXT40	CHAR	40	0	Module Group (Description)
44	MAJOR4_TXT	☐	PIQCGSTEXT	TEXT40	CHAR	40	0	Module Group (Description)
45	MINOR1_TXT	☐	PIQCGSTEXT	TEXT40	CHAR	40	0	Module Group (Description)
46	MINOR2_TXT	☐	PIQCGSTEXT	TEXT40	CHAR	40	0	Module Group (Description)
47	MINOR3_TXT	☐	PIQCGSTEXT	TEXT40	CHAR	40	0	Module Group (Description)
48	MINOR4_TXT	☐	PIQCGSTEXT	TEXT40	CHAR	40	0	Module Group (Description)
49	CIP_MAJOR1	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline	*
50	CIP_MAJOR2	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline	*
51	CIP_MAJOR3	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline	*
52	CIP_MAJOR4	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline	*
53	CIP_MINOR1	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline	*
54	CIP_MINOR2	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline	*
55	CIP_MINOR3	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline	*
56	CIP_MINOR4	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline	*
57	CIP_TXT_MAJOR1	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
58	CIP_TXT_MAJOR2	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
59	CIP_TXT_MAJOR3	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
60	CIP_TXT_MAJOR4	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
61	CIP_TXT_MINOR1	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
62	CIP_TXT_MINOR2	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
63	CIP_TXT_MINOR3	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
64	CIP_TXT_MINOR4	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
65	CLASS	☐	PIQ_US_CLASS	PIQ_US_CLASS	CHAR	1	0	Progression Class Result for a Progression Category.	*
66	FIRST_TIME_FULL_TIME	☐	PIQ_US_UNDERGRAD_FLAG	PIQ_US_YES_NO_FLAG	CHAR	1	0	First Time Full Time
67	DEGREE_SEEKING	☐	PIQ_US_DEGREE_SEEKING	PIQ_US_YES_NO_FLAG	CHAR	1	0	Degree Seeking
68	HIGH_SCHOOL_CODE	☐	PIQ_US_HIGHSCHOOL_CODE	NUMC06	NUMC	6	0	High School Code
69	GENDER	☐	PIQ_US_GENDER	PIQ_US_GENDER	CHAR	1	0	Gender of Student
70	RACE_ETHINICITY	☐	PIQ_US_RACE_ETHNICITY	CHAR02	CHAR	2	0	Race/Ethnicity
71	COLLEGE_STUDENT_ID	☐	PIQ_US_COLLEGE_STUD_ID	PIQ_US_COLLEGE_STUD_ID	CHAR	20	0	College Student Id
72	STATE_STUDENT_ID	☐	PIQ_US_STATE_STUD_ID	PIQ_US_STATE_STUD_ID	CHAR	30	0	State Student Id
73	EMAIL_ID	☐	PMIQ_US_EMAIL	PMIQ_US_EMAIL	CHAR	128	0	Email Address of Student
74	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	600