SAP ABAP Table PIQCONFERQEXT (Qualification Conferment (Extended))

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	PIQCONFERQEXT	Table Relationship Diagram
Short Description	Qualification Conferment (Extended)

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in