SAP ABAP Table PIQEDRUN_INT_W (Internal Academic Achievement in ED Run)

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	PIQEDRUN_INT_W	Table Relationship Diagram
Short Description	Internal Academic Achievement in ED Run

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

History

Last changed by/on	SAP	20070914
SAP Release Created in