SAP ABAP Table PIQCONFERQ (Qualification Conferment)

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	PIQCONFERQ	Table Relationship Diagram
Short Description	Qualification Conferment

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	STUDENT_ID	☐	PIQSTUDENT	HROBJID	NUMC	8	0	Object ID of Student	*
2	NORMVAL	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
3	GRADESYMBOL	☐	PIQGRADESYM	PIQGRADESYM	CHAR	10	0	Grade Symbol
4	SCALE	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
5	CQNOTE	☐	PIQNOTE_GUID	SYSUUID_C	CHAR	32	0	GUID - Unique Note Identifier
6	CONF_COMMENT	☐	PIQCONFERQ_COMMENT	TEXT50	CHAR	50	0	Comment Regarding Qualification
7	CONFER_DATE	☐	PIQCONFERQ_DATE		DATS	8	0	Date of Qualification Conferment
8	AYEAR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	T7PIQYEAR
9	APERIOD	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	T7PIQPERIOD
10	VALID_FROM	☐	PIQCONFERQ_VALID_FROM		DATS	8	0	Validity Start Date of Qualification Conferment
11	VALID_TO	☐	PIQCONFERQ_VALID_TO		DATS	8	0	Validity End Date of Qualification Conferment
12	TRANSFERRED	☐	PIQTRANSFER	PIQTRANSFER	CHAR	1	0	External Academic Work or Qualification Transferred
13	CQ_ID	☐	PIQCQOBJID	HROBJID	NUMC	8	0	Internal Qualification Identification (ID)	*
14	PERIDFORCQ	☐	PIQCONFERQ_PERIDFORCQ	PIQPERCT	NUMC	3	0	Duration of Study Required to Achieve Qualification
15	PERIDFORCQUNIT	☐	PIQCONFERQ_PERIDFORCQUNIT	PIQCONFERQ_PERIDFORCQUNIT	CHAR	1	0	Unit for Number of Periods
16	.INCLUDE	☐				0	0	Objects Referenced for Qualification Conferment
17	REFOBJ_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
18	REFOBJ_REALO	☐	SOBID	CHAR45	CHAR	45	0	ID of Related Object
19	.INCLUDE	☐				0	0
20	COBOK	☐	PIQPEPE_COBOK	PIQPEPE_COBOK	CHAR	1	0	Conditional Booking
21	STAGE	☐	PIQLEVEL	PIQLEVEL	NUMC	2	0	Stage	*
22	REFPROC_GUIDTYPE	☐	PIQCONFERQ_REFPROC_GUIDTYPE	PIQGUIDTYPE	CHAR	4	0	Reference to a Process	T7PIQGUIDTYPE
23	REFPROC_GUID	☐	PIQCONFERQ_REFPROC_GUID	SYSUUID_C	CHAR	32	0	Process Identification (ID)
24	DIPLOMANAME	☐	PIQCONFERQ_DIPLOMANAME	TEXT80	CHAR	80	0	Diploma Name
25	FINALW_ID	☐	PIQCONFERQ_FINALW_ID	SYSUUID_C	CHAR	32	0	Module Booking ID of Individual Work
26	FINALW_TITLE	☐	PIQCONFERQ_FINALWTITLE	TEXT100	CHAR	100	0	Title of Qualifying Work
27	FINALW_LANGU	☐	PIQCONFERQ_FINALWLANGU	SPRAS	LANG	1	0	Original Language	T002
28	FINALW_TITLEALT	☐	PIQCONFERQ_FINALWTITLEALT	TEXT100	CHAR	100	0	Title of Qualifying Work in Other Language
29	FINALW_LANGUALT	☐	PIQCONFERQ_FINALWLANGUALT	SPRAS	LANG	1	0	Other Language	T002
30	ACADHONOR_SYM	☐	PIQCONFERQ_ACADHONOR_GRADESYM	PIQGRADESYM	CHAR	10	0	Academic Honors
31	ACADHONOR_GRADE	☐	PIQCONFERQ_ACADHONOR_GRADE	PIQSCALE_NORM_VAL	DEC	8	2	Academic Honors: Standard Value
32	ACADHONOR_SCALE	☐	PIQCONFERQ_ACADHONOR_SCALE	PIQSCALE_ID	CHAR	4	0	Academic Honors Scale	T7PIQSCALE
33	NOT_COMPLETED	☐	PIQCONFERQ_NOTCOMPL	PIQCONFERQ_NOTCOMPL	CHAR	1	0	Qualification Was Not Achieved

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQCONFERQ	ACADHONOR_SCALE	T7PIQSCALE	SCALEID
2	PIQCONFERQ	APERIOD	T7PIQPERIOD	PERID
3	PIQCONFERQ	AYEAR	T7PIQYEAR	PERYR
4	PIQCONFERQ	FINALW_LANGU	T002	SPRAS
5	PIQCONFERQ	FINALW_LANGUALT	T002	SPRAS
6	PIQCONFERQ	REFPROC_GUIDTYPE	T7PIQGUIDTYPE	TYPE
7	PIQCONFERQ	SCALE	T7PIQSCALE	SCALEID

History

Last changed by/on	SAP	20130529
SAP Release Created in