SAP ABAP Table PIQAGM_ED_INT_W (Internal Academic Achievement)

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	PIQAGM_ED_INT_W	Table Relationship Diagram
Short Description	Internal Academic Achievement

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	GRP	☐	PIQEDGROUP	CHAR2	CHAR	2	0	Academic Work Grouping
2	AGMID	☐	PIQEDAGMID	SYSUUID_C	CHAR	32	0	ID of Transfer Regulation for External Achievement
3	.INCLUDE	☐				0	0	ED Activity Document: Internal Academic Work
4	OTYPE	☐	PIQEDINTOTYPE	PIQED_INTOTYPE	CHAR	2	0	Object Type of Internal Academic Achievement
5	OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
6	GRADESYM	☐	PIQGRADESYM	PIQGRADESYM	CHAR	10	0	Grade Symbol
7	GRADE	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
8	GRADESCALE	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
9	.INCLUDE	☐				0	0	Credits
10	CPATTEMP	☐	PIQCPATTEMP	PIQCP	QUAN	10	5	Attempted Credits
11	CPEARNED	☐	PIQCPEARNED	PIQCP	QUAN	10	5	Earned Credits
12	CPGRADED	☐	PIQCPGRADED	PIQCP	QUAN	10	5	Graded Credits
13	CPUNIT	☐	PIQCPUNIT	MEINS	UNIT	3	0	Unit of Measurement for Credits	T7PIQCP
14	PROGC_VAR	☐	PIQPROGC_VAR	PIQPROGC_VAR	CHAR	4	0	Program Type	T7PIQPROGCVAR
15	SC_OBJID	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID	*
16	TRANSFERBOOKID	☐	PIQEDTRANSFERID	SYSUUID_C	CHAR	32	0	Relationship Identifier (ID)
17	AWSTATUS	☐	PIQEDINTAWSTATUS	PIQEDAWSTATUS	CHAR	1	0	Status of Internal Academic Work or Qualification
18	PERYR	☐	PIQEDINTYEAR	PIQPERYR	NUMC	4	0	Assigned Academic Year of Internal Academic Work/Qualif.	T7PIQYEAR
19	PERID	☐	PIQEDINTSESSION	PIQPERID	NUMC	3	0	Assigned Academic Session of Internal Academic Work/Qualif.	T7PIQPERIOD
20	AGRBEGDA	☐	PIQAGRBEGDA	PIQDATE	DATS	8	0	Start of Appraisal Validity
21	AGRENDDA	☐	PIQAGRENDDA	PIQDATE	DATS	8	0	End of Appraisal Validity
22	.INCLUDE	☐				0	0	Internal Academic Work (Texts)
23	SHORT	☐	PIQEDINT_SHORT	TEXT12	CHAR	12	0	Internal Academic Achievement (Abbreviation)
24	STEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
25	OTYPET	☐	PIQEDOTYPE_INT_TEXT	TEXT25	CHAR	25	0	Object Type of Internal Work/Qualification (Description)
26	SCALET	☐	PIQSCALETEXT	PIQSCALE_TEXT	CHAR	30	0	Scale (Description)
27	PROGC_VART	☐	PIQPROGC_VART	TEXT30	CHAR	30	0	Program Type (Description)
28	GRADESYMT	☐	PIQSCALE_GRADETEXT	PIQSCALE_GRADETEXT	CHAR	20	0	Scale Value (Description)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQAGM_ED_INT_W	CPUNIT	T7PIQCP	CPUNIT	KEY	1	CN
2	PIQAGM_ED_INT_W	GRADESCALE	T7PIQSCALE	SCALEID
3	PIQAGM_ED_INT_W	PERID	T7PIQPERIOD	PERID
4	PIQAGM_ED_INT_W	PERYR	T7PIQYEAR	PERYR
5	PIQAGM_ED_INT_W	PROGC_VAR	T7PIQPROGCVAR	PROGC_VAR

History

Last changed by/on	SAP	20070914
SAP Release Created in	473