SAP ABAP Table PIQAW_DIAL (Selection Criteria for Academic Work)

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	PIQAW_DIAL	Table Relationship Diagram
Short Description	Selection Criteria for Academic Work

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	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
2	STOBJID	☐	PIQSTUDENT	HROBJID	NUMC	8	0	Object ID of Student	*
3	ALL_STUDIESFLAG	☐	PIQAW_ALL_STUDIES	FLAG	CHAR	1	0	Select All Academic Work of Student
4	PROG_TYPEFLAG	☐	PIQAW_PROG_TYPE	FLAG	CHAR	1	0	Select Academic Work for Program Type
5	PROGRAMFLAG	☐	PIQAW_PROGRAM	FLAG	CHAR	1	0	Select Academic Work for Program
6	PROGC_VAR	☐	PIQPROGC_VAR	PIQPROGC_VAR	CHAR	4	0	Program Type	T7PIQPROGCVAR
7	SCOBJID	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID	*
8	ALL_SESSIONSFLAG	☐	PIQAW_ALL_SESSIONS	FLAG	CHAR	1	0	Select Academic Work for All Academic Sessions
9	SEL_SESSIONFLAG	☐	PIQAW_SEL_SESSION	FLAG	CHAR	1	0	Select Academic Work for Academic Period
10	ACAD_YEAR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	T7PIQYEAR
11	ACAD_SESSION	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	T7PIQPERIOD
12	WORKCAT	☐	PIQAW_WORKCAT	PIQAW_WORKCAT	CHAR	1	0	Academic Work Category
13	ALL_WORK	☐	PIQAW_ALL_WORK	FLAG	CHAR	1	0	Select All Completed and Transferred Academic Work
14	TRANSFERRED	☐	PIQAW_TRANSFERRED	FLAG	CHAR	1	0	Select Transferred Academic Work
15	COMPLETED	☐	PIQAW_COMPLETED	FLAG	CHAR	1	0	Select Completed Academic Work

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQAW_DIAL	ACAD_SESSION	T7PIQPERIOD	PERID
2	PIQAW_DIAL	ACAD_YEAR	T7PIQYEAR	PERYR
3	PIQAW_DIAL	PLVAR	T778P	PLVAR
4	PIQAW_DIAL	PROGC_VAR	T7PIQPROGCVAR	PROGC_VAR

History

Last changed by/on	SAP	20130529
SAP Release Created in	471