PIQDBAD_D - Decision: Decision Dates

Decision: Decision Dates information is stored in SAP table PIQDBAD_D.
It is part of development package PMIQ_AD_BACK in software component IS-HER-CM. This development package consists of objects that can be grouped under "Admission Decision Back-end Core".

Fields for table PIQDBAD_D

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE	KEY	X		PIQAD_OBJ_KEY_C	0
MANDT	Client	X	MANDT	CLNT	6	*
.INCLUDE	OBJ_KEY	X		PIQAD_OBJ_KEY	0
OBJECT_ID	Admission Object ID	X	PIQAD_OBJECT_ID	NUMC	32
VERSION	Admission: Version	X	PIQAD_VERSION	NUMC	12
.INCLUDE	ADMIN			PIQAD_ADMIN_INFO	0
.INCLUDE				PIQAD_EDIT_INFO	0
CREATED_AT	Created At (Output in User Time Zone)		COMT_CREATED_AT_USR	DEC	8
CREATED_BY	User that Created the Transaction		CRMT_CREATED_BY	CHAR	24
CHANGED_AT	Changed At (Output in User Time Zone)		COMT_CHANGED_AT_USR	DEC	8
CHANGED_BY	Transaction Last Changed By		CRMT_CHANGED_BY	CHAR	24
.INCLUDE	PARENT			PIQAD_OBJ_PARENT	0
PARENT_TYPE	Decision: Object Category		PIQAD_OBJECT_TYPE	CHAR	6	*
PARENT_ID	Admission Object ID		PIQAD_OBJECT_ID	NUMC	32
.INCLUDE	HEADER			PIQAD_OBJ_HEADER	0
HEADER_TYPE	Decision: Object Category		PIQAD_OBJECT_TYPE	CHAR	6	*
HEADER_ID	Admission Object ID		PIQAD_OBJECT_ID	NUMC	32
STATE	Admission: Version State		PIQAD_STATE	CHAR	2
DEL	Admission: Deletion Indicator		PIQAD_DELETED	CHAR	2
OBJNR	Object number		J_OBJNR	CHAR	44	*
.INCLUDE	DATA			PIQAD_ADD_DATA	0
OBJECT_SUB_TYPE	Decision: Date Type		PIQAD_ADD_TYPE	CHAR	8	*
DATA_SOURCE	Decision: Data Source		PIQAD_DATA_SOURCE	CHAR	2
DATE_FROM	Decision: Date		PIQAD_DATE	DATS	16
TIME_FROM	Decision: Time		PIQAD_TIME	TIMS	12
TIMESTAMP_FROM	Decision: Timestamp (Output in User Time Zone)		PIQAD_TIMESTAMP	DEC	8
DATE_TO	Decision: Date		PIQAD_DATE	DATS	16
TIME_TO	Decision: Time		PIQAD_TIME	TIMS	12
TIMESTAMP_TO	Decision: Timestamp (Output in User Time Zone)		PIQAD_TIMESTAMP	DEC	8
IS_PERIOD	Indicate if a date type is a period		PIQAD_ADD_IS_PERIOD	CHAR	2