SAP ABAP Table PIQTRCOURSE_EXT_TXT (Text Structure for PIQTRCOURSE_EXT)

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	PIQTRCOURSE_EXT_TXT	Table Relationship Diagram
Short Description	Text Structure for PIQTRCOURSE_EXT

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	External Subject
2	COURSEID	☐	PIQTRCOURSEID	HROBJID	NUMC	8	0	Registered Subject	*
3	EXTGRADE	☐	PIQTREXTGRADE		CHAR	10	0	Original Grade in External Subject
4	EXTGRADESCALE	☐	PIQTREXTGRADESCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Original Grade	T7PIQSCALE
5	COREPEATFLAG	☐	PIQTRCOREPEATFLAG		CHAR	1	0	Indicator: Repeated Subject
6	HONORSINDIC	☐	PIQTRHONORSINDIC		CHAR	1	0	Indicator: Honors Subject
7	EXTCOATMCRED	☐	PIQTREXTCOATMCRED	PIQCP	QUAN	10	5	Attempted Credits in External Subject
8	EXTCOGRDCRED	☐	PIQTREXTCOGRDCRED	PIQCP	QUAN	10	5	Graded Credits in External Subject
9	EXTCOERNCRED	☐	PIQTREXTCOERNCRED	PIQCP	QUAN	10	5	Earned Credits in External Subject
10	EXTCOCREDTYPE	☐	PIQTREXTCOCREDTYPE	MEINS	UNIT	3	0	Original Credit Type of External Subject	T7PIQCP
11	BASFORCOCRED	☐	PIQTRBASFORCOCRED	PIQTRBASFORCRED	CHAR	4	0	Basis for Accomplished Credits	T7PIQTRBASFORCP
12	COREFLAG	☐	PIQTRCOREFLAG		CHAR	1	0	Indicator for Core Subject
13	COWITHDRDATE	☐	PIQTRCOWITHDRDATE		DATS	8	0	Date of Withdrawal
14	COSESID	☐	PIQTRCOSESID	PIQTRSESSIONID	CHAR	4	0	Session In Which External Subject Was Taken	T7PIQTREXTSES
15	COSESYEAR	☐	PIQTRCOSESYEAR	PIQTRSESSIONYEAR	NUMC	4	0	Year In Which Subject Was Taken
16	COBEGDATE	☐	PIQTRCOBEGDATE		DATS	8	0	Start Date of Subject
17	COENDDATE	☐	PIQTRCOENDDATE		DATS	8	0	End Date of Subject
18	.INCLUDE	☐				0	0	Texts for Structure PIQTRCOURSE_EXT
19	COURSE_SHORT	☐	PIQTRCOURSESHORT	TEXT12	CHAR	12	0	Registered Subject (Abbreviation)
20	COURSE_STEXT	☐	PIQTRCOURSESTEXT	TEXT40	CHAR	40	0	Registered Subject (Description)
21	EXTGRADET	☐	PIQTREXTGRADETEXT	PIQSCALE_GRADETEXT	CHAR	20	0	Original Grade in External Subject
22	EXTGRADESCALET	☐	PIQSCALETEXT	PIQSCALE_TEXT	CHAR	30	0	Scale (Description)
23	EXTCOCREDTYPET	☐	PIQCPUNITT	TEXT25	CHAR	25	0	Description of Credit Type Unit
24	COSEST	☐	PIQTRSESSIONT	TEXT20	CHAR	20	0	External Academic Session (Description)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQTRCOURSE_EXT_TXT	BASFORCOCRED	T7PIQTRBASFORCP	BASISFORCP		1	CN
2	PIQTRCOURSE_EXT_TXT	COSESID	T7PIQTREXTSES	SESSIONID		1	CN
3	PIQTRCOURSE_EXT_TXT	EXTCOCREDTYPE	T7PIQCP	CPUNIT		1	CN
4	PIQTRCOURSE_EXT_TXT	EXTGRADESCALE	T7PIQSCALE	SCALEID		1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in