PIQDB_STACAD - Student Acad Work : Program Admission and Registration

Student Acad Work : Program Admission and Registration information is stored in SAP table PIQDB_STACAD.
It is part of development package PMIQ_STACAD_SIMP in software component IS-HER-CM. This development package consists of objects that can be grouped under "Student Academics Process Simplified".

Fields for table PIQDB_STACAD

Field Name	Description	Is Key	Data Element	Data Type	Length
MANDT	Client	X	MANDT	CLNT	6
PLVAR	Plan Version	X	PLVAR	CHAR	4
ST_OBJID	Object ID	X	HROBJID	NUMC	16
SC_OBJID	Object ID	X	HROBJID	NUMC	16
CS_OBJID	Object ID	X	HROBJID	NUMC	16
ACAD_PROCESS	Student Academic Academic Process	X	PIQACAD_PROCESS	CHAR	6
ACAD_RELN	Academic Relation	X	PIQDB_ACAD_RELATION	CHAR	8
ISTAT	Planning Status	X	ISTAT_D	CHAR	2
BEGDA_PROCESS	Start Date	X	BEGDATUM	DATS	16
ENDDA_PROCESS	End Date	X	ENDDATUM	DATS	16
ADM_GUID	Unique Key (GUID) of the Admission	X	PIQADM_GUID	CHAR	64
SUBTY	Subtype		SUBTYP	CHAR	8
CHOICE_NO	Program Choice		PIQCHOICE_NO	NUMC	4
ADM_AYEAR	Academic Year		PIQPERYR	NUMC	8
ADM_PERID	Academic Session		PIQPERID	NUMC	6
ADM_ACLEVEL	Stage		PIQLEVEL	NUMC	4
ADM_PROGCLASS	Progress Classification		PIQPROGCLASS	CHAR	8
ADM_PARTT	Indicator: Part-Time Study		PIQPARTT	CHAR	2
ADM_CATEG	Admission Category		PIQADM_CATEG	CHAR	4
ADM_ENRCATEG	Registration Type		PIQENRCATEG	CHAR	4
ADM_CODE	Admission Code		PIQADMCODE	CHAR	24
ADM_PERCT	Completed Length of Study		PIQPERCT	NUMC	6
ADM_STATUS_SUP	Status Supplement		PIQADMSTSUP	CHAR	8
ADM_DEC	Decision Date of Rejection or Admission		PIQADM_DEC	DATS	16
ADM_RECPT	Date of Admission Application Receipt		PIQADM_RECPT	DATS	16
ADM_WITH_DECL	Date of Withdrawal or Declination		PIQADM_WITH_DECL	DATS	16
ADM_QMNUM	Notification Number		PIQ_NOTIF_NUMBER	CHAR	24
COKEY	Correspondence key		COKEY_KK	CHAR	72
AEDTM	Changed on		AEDTM	DATS	16
UNAME	User Name		USRNAME	CHAR	24
REGAPPTYPE	Activity for Program Registration		PIQPROCESS_BEG	CHAR	8
REGREASON	Activity Reason		PIQPROCREASON	NUMC	8
REGDATE	Activity Key Date for Start of Study Segment		PIQREGDATE	DATS	16
DERAPPTYPE	Activity for De-registration from Program		PIQPROCESS_END	CHAR	8
DERREASON	De-registration Reason		PIQDERREASON	NUMC	8
DERDATE	Activity Key Date of De-registration		PIQDERDATE	DATS	16
EXAMREG	Unused Field (NUMC4)		PIQNUSED_NUMC4	NUMC	8
PR_STATUS	Sessional Registration Status		PIQREG_PERIODSTATUS	CHAR	2
PRS_STATE	Sessional Registration Status Specification		PIQREG_PRS_STATE	CHAR	2
APPTYPE	Activity for Sessional Registration (OBSOLETE)		PIQAPPTYPE_503	CHAR	8
REASON	Leave of Absence Reason		PIQLEAREASON	NUMC	8
ACLEVEL	Stage		PIQLEVEL	NUMC	4
FEEFL	Reserved Field/Unused Field		NUSED	CHAR	2
PERCT	Completed Length of Study		PIQPERCT	NUMC	6
REGCLASS	Registration Classification		PIQREGCLASS	CHAR	4
CANCPROCESS	Cancellation Activity (for Registration)		PIQREGCANCPROCESS	CHAR	8
CANCREASON	Cancellation Reason (For Registration)		PIQREGCANCREASON	NUMC	8
CANCDATE	Cancellation Date (Registration)		PIQREGCANCDATE	DATS	16
END_PROCESS	Activity for De-registration from Program		PIQPROCESS_END	CHAR	8
END_REASON	De-registration Reason		PIQDERREASON	NUMC	8
END_KEY_DATE	Activity Key Date of De-registration		PIQDERDATE	DATS	16
LAST_ATTEND	Last Day of Attendance		PIQREG_LAST_ATTEND	DATS	16
PRIOX	Program Priority (In Period)		PIQCSPRIOX	CHAR	4
REG_PARTT	Indicator: Part-Time Study		PIQPARTT	CHAR	2
REG_PROGCLASS	Progress Classification		PIQPROGCLASS	CHAR	8
REG_ENRCATEG	Registration Type		PIQENRCATEG	CHAR	4
.INCLUDE				CI_PIQDB_STACAD	0