Table SNPAFF

Table	Abbreviation	Description	Module	Activity code
SNPAFF	SPAF	Employee assignment	Common Data	PJM

Key	Description	Duplicates	Activity code
PAF0	SNPVCR+OPPNUM+PAFCLB	No

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation	Act
AUUID	Single identifier		AUUID
CREDAT	Date created		D
CREDATTIM	Date time		ADATIM
CREUSR	User		AUS			[AUS]CODUSR=[SPAF]CREUSR	Other
OPPNUM	Project number		PIM			[PIM]PIM0=[SPAF]OPPNUM	Block
PAFCLB	Employee		AUS			[AUS]CODUSR=[SPAF]PAFCLB	Block
PAFROL	Role		ADI			[ADI]CODE=639;PAFROL	Block
SNPVCR	Snapshot code		VPJ
UPDDAT	Change date		D
UPDDATTIM	Date time		ADATIM
UPDUSR	User		AUS			[AUS]CODUSR=[SPAF]UPDUSR	Other