PA0697 - Infotype 0697 ( Drug Screening)

Infotype 0697 ( Drug Screening) information is stored in SAP table PA0697.
It is part of development package P10P1 in software component PY-US-PS. This development package consists of objects that can be grouped under "HR Public Sector USA".

Fields for table PA0697

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	*
.INCLUDE		X		PAKEY	0
PERNR	Personnel Number	X	PERSNO	NUMC	16	PA0003
SUBTY	Subtype	X	SUBTY	CHAR	8
OBJPS	Object Identification	X	OBJPS	CHAR	4
SPRPS	Lock Indicator for HR Master Data Record	X	SPRPS	CHAR	2
ENDDA	End Date	X	ENDDA	DATS	16
BEGDA	Start Date	X	BEGDA	DATS	16
SEQNR	Number of Infotype Record With Same Key	X	SEQNR	NUMC	6
.INCLUDE				PSHD1	0
AEDTM	Last Changed On		AEDAT	DATS	16
UNAME	Name of Person Who Changed Object		AENAM	CHAR	24
HISTO	Historical Record Flag		HISTO	CHAR	2
ITXEX	Text Exists for Infotype		ITXEX	CHAR	2
REFEX	Reference Fields Exist (Primary/Secondary Costs)		PRFEX	CHAR	2
ORDEX	Confirmation Fields Exist		ORDEX	CHAR	2
ITBLD	Infotype Screen Control		ITBLD	CHAR	4
PREAS	Reason for Changing Master Data		PREAS	CHAR	4	T530E
FLAG1	Reserved Field/Unused Field		NUSED	CHAR	2
FLAG2	Reserved Field/Unused Field		NUSED	CHAR	2
FLAG3	Reserved Field/Unused Field		NUSED	CHAR	2
FLAG4	Reserved Field/Unused Field		NUSED	CHAR	2
RESE1	Reserved Field/Unused Field of Length 2		NUSED2	CHAR	4
RESE2	Reserved Field/Unused Field of Length 2		NUSED2	CHAR	4
GRPVL	Grouping Value for Personnel Assignments		PCCE_GPVAL	CHAR	8
.INCLUDE				PS0697	0
TESTY	Drug screening test type		P10_TESTY	CHAR	8	T591A
TESDT	Sample collecting date		P10_TESDT	DATS	16
TESRN	Drug screening test reason		P10_TERSN	CHAR	8	T5UPBS20DSR
TRESU	Overall test result		P10_TRESU	CHAR	2	T5UPBS20DSU
SANUM	Sample number		P10_SANUM	CHAR	16
TEXEC	Test executer name		P10_TEXEC	CHAR	160
TOBSE	Test observer name		P10_TOBSE	CHAR	160
TSITE	Test site		P10_TSITE	CHAR	8	T5UPBS20DSS
TMEDA	Test method for sample A		P10_TMEDA	CHAR	8	T5UPBS20DSM
TMEDB	Test method for sample B		P10_TMEDB	CHAR	8	T5UPBS20DSM
STA01	Substance test content code		P10_SUBST	CHAR	8	T5UPBS20DS
RSA01	Substance test result		P10_TSRES	CHAR	2	T5UPBS20DSUT
ATA01	Substance test amout		P10_TSAMT	QUAN	5
UTA01	Substance test unit		P10_TSUNT	UNIT	6
STA02	Substance test content code		P10_SUBST	CHAR	8	T5UPBS20DS
RSA02	Substance test result		P10_TSRES	CHAR	2	T5UPBS20DSUT
ATA02	Substance test amout		P10_TSAMT	QUAN	5
UTA02	Substance test unit		P10_TSUNT	UNIT	6
STA03	Substance test content code		P10_SUBST	CHAR	8	T5UPBS20DS
RSA03	Substance test result		P10_TSRES	CHAR	2	T5UPBS20DSUT
ATA03	Substance test amout		P10_TSAMT	QUAN	5
UTA03	Substance test unit		P10_TSUNT	UNIT	6
STA04	Substance test content code		P10_SUBST	CHAR	8	T5UPBS20DS
RSA04	Substance test result		P10_TSRES	CHAR	2	T5UPBS20DSUT
ATA04	Substance test amout		P10_TSAMT	QUAN	5
UTA04	Substance test unit		P10_TSUNT	UNIT	6
STA05	Substance test content code		P10_SUBST	CHAR	8	T5UPBS20DS
RSA05	Substance test result		P10_TSRES	CHAR	2	T5UPBS20DSUT
ATA05	Substance test amout		P10_TSAMT	QUAN	5
UTA05	Substance test unit		P10_TSUNT	UNIT	6
STA06	Substance test content code		P10_SUBST	CHAR	8	T5UPBS20DS
RSA06	Substance test result		P10_TSRES	CHAR	2	T5UPBS20DSUT
ATA06	Substance test amout		P10_TSAMT	QUAN	5
UTA06	Substance test unit		P10_TSUNT	UNIT	6
STA07	Substance test content code		P10_SUBST	CHAR	8	T5UPBS20DS
RSA07	Substance test result		P10_TSRES	CHAR	2	T5UPBS20DSUT
ATA07	Substance test amout		P10_TSAMT	QUAN	5
UTA07	Substance test unit		P10_TSUNT	UNIT	6
STA08	Substance test content code		P10_SUBST	CHAR	8	T5UPBS20DS
RSA08	Substance test result		P10_TSRES	CHAR	2	T5UPBS20DSUT
ATA08	Substance test amout		P10_TSAMT	QUAN	5
UTA08	Substance test unit		P10_TSUNT	UNIT	6
STA09	Substance test content code		P10_SUBST	CHAR	8	T5UPBS20DS
RSA09	Substance test result		P10_TSRES	CHAR	2	T5UPBS20DSUT
ATA09	Substance test amout		P10_TSAMT	QUAN	5
UTA09	Substance test unit		P10_TSUNT	UNIT	6
STA10	Substance test content code		P10_SUBST	CHAR	8	T5UPBS20DS
RSA10	Substance test result		P10_TSRES	CHAR	2	T5UPBS20DSUT
ATA10	Substance test amout		P10_TSAMT	QUAN	5
UTA10	Substance test unit		P10_TSUNT	UNIT	6
STB01	Substance test content code		P10_SUBST	CHAR	8	T5UPBS20DS
RSB01	Substance test result		P10_TSRES	CHAR	2	T5UPBS20DSUT
ATB01	Substance test amout		P10_TSAMT	QUAN	5
UTB01	Substance test unit		P10_TSUNT	UNIT	6
STB02	Substance test content code		P10_SUBST	CHAR	8	T5UPBS20DS
RSB02	Substance test result		P10_TSRES	CHAR	2	T5UPBS20DSUT
ATB02	Substance test amout		P10_TSAMT	QUAN	5
UTB02	Substance test unit		P10_TSUNT	UNIT	6
STB03	Substance test content code		P10_SUBST	CHAR	8	T5UPBS20DS
RSB03	Substance test result		P10_TSRES	CHAR	2	T5UPBS20DSUT
ATB03	Substance test amout		P10_TSAMT	QUAN	5
UTB03	Substance test unit		P10_TSUNT	UNIT	6
STB04	Substance test content code		P10_SUBST	CHAR	8	T5UPBS20DS
RSB04	Substance test result		P10_TSRES	CHAR	2	T5UPBS20DSUT
ATB04	Substance test amout		P10_TSAMT	QUAN	5
UTB04	Substance test unit		P10_TSUNT	UNIT	6
STB05	Substance test content code		P10_SUBST	CHAR	8	T5UPBS20DS
RSB05	Substance test result		P10_TSRES	CHAR	2	T5UPBS20DSUT
ATB05	Substance test amout		P10_TSAMT	QUAN	5
UTB05	Substance test unit		P10_TSUNT	UNIT	6
STB06	Substance test content code		P10_SUBST	CHAR	8	T5UPBS20DS
RSB06	Substance test result		P10_TSRES	CHAR	2	T5UPBS20DSUT
ATB06	Substance test amout		P10_TSAMT	QUAN	5
UTB06	Substance test unit		P10_TSUNT	UNIT	6
STB07	Substance test content code		P10_SUBST	CHAR	8	T5UPBS20DS
RSB07	Substance test result		P10_TSRES	CHAR	2	T5UPBS20DSUT
ATB07	Substance test amout		P10_TSAMT	QUAN	5
UTB07	Substance test unit		P10_TSUNT	UNIT	6
STB08	Substance test content code		P10_SUBST	CHAR	8	T5UPBS20DS
RSB08	Substance test result		P10_TSRES	CHAR	2	T5UPBS20DSUT
ATB08	Substance test amout		P10_TSAMT	QUAN	5
UTB08	Substance test unit		P10_TSUNT	UNIT	6
STB09	Substance test content code		P10_SUBST	CHAR	8	T5UPBS20DS
RSB09	Substance test result		P10_TSRES	CHAR	2	T5UPBS20DSUT
ATB09	Substance test amout		P10_TSAMT	QUAN	5
UTB09	Substance test unit		P10_TSUNT	UNIT	6
STB10	Substance test content code		P10_SUBST	CHAR	8	T5UPBS20DS
RSB10	Substance test result		P10_TSRES	CHAR	2	T5UPBS20DSUT
ATB10	Substance test amout		P10_TSAMT	QUAN	5
UTB10	Substance test unit		P10_TSUNT	UNIT	6
EADDR	Address number		P10_CADDR	CHAR	20	*
OADDR	Address number		P10_CADDR	CHAR	20	*
.INCLUDE				CI_P0697	0