P08P1CLS - CLASS CPX INTERFACE Snapshot Table

CLASS CPX INTERFACE Snapshot Table information is stored in SAP table P08P1CLS.
It is part of development package P08P1 in software component PY-GB-PS. This development package consists of objects that can be grouped under "HR Public Sector Great Britain".

Fields for table P08P1CLS

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	3	*
PERNR	Personnel Number	X	PERSNO	NUMC	8	*
SDATE	CLASS CPX INTERFACE Control File Snapshot Date	X	P08_CNT01	DATS	8
RUNNO	CLASS CPX INTERFACE Control File Run Number	X	P08_CNT02	NUMC	10
.INCLUDE		X		P08P1_CLSK	0
RECTP	CLASS CPX INTERFACE Record Type (Starter,Amendment,Leaver)	X	P08_CLS01	CHAR	1
NINUM	CLASS CPX INTERFACE National Insurance Number	X	P08_CLS02	CHAR	9
FILL1	CLASS CPX INTERFACE Filler 3 Characters	X	P08_CLS03	CHAR	3
KEY2	CLASS CPX INTERFACE Second Key	X	P08_CLS04	CHAR	12
.INCLUDE				P08P1_CLSN	0
SNAME	CLASS CPX INTERFACE Surname		P08_CLS05	CHAR	25
FNAME	CLASS CPX INTERFACE Forenames		P08_CLS06	CHAR	25
SCHEM	CLASS CPX INTERFACE Scheme Id		P08_CLS07	CHAR	3
STATU	CLASS CPX INTERFACE Status		P08_CLS08	CHAR	1
SEX	CLASS CPX INTERFACE Sex		P08_CLS09	CHAR	1
CLASS	CLASS CPX INTERFACE Class		P08_CLS10	CHAR	2
DOB	CLASS CPX INTERFACE Date Of Birth		P08_CLS11	CHAR	8
DJEMP	CLASS CPX INTERFACE Date Joined Employer		P08_CLS12	CHAR	8
DJFUN	CLASS CPX INTERFACE Date Joined Fund		P08_CLS13	CHAR	8
LSDAT	CLASS CPX INTERFACE Location Start Date		P08_CLS14	CHAR	8
LOCAT	CLASS CPX INTERFACE Location		P08_CLS15	CHAR	5
FILL2	CLASS CPX INTERFACE Filler 5 Characters		P08_CLS16	CHAR	5
DSPEN	CLASS CPX INTERFACE Date Commenced Pensionable Service		P08_CLS17	CHAR	8
DOSER	CLASS CPX INTERFACE Date Contracted Out Of SERPS		P08_CLS18	CHAR	8
FILL3	CLASS CPX INTERFACE Filler 8 digits.		P08_CLS19	CHAR	8
TITLE	CLASS CPX INTERFACE Title		P08_CLS20	CHAR	4
FILL4	CLASS CPX INTERFACE Filler 14 Characters		P08_CLS21	CHAR	14
NILET	CLASS CPX INTERFACE NI Table Letter		P08_CLS22	CHAR	1
REDNI	CLASS CPX INTERFACE Reduced NI Indicator		P08_CLS23	CHAR	1
PTIND	CLASS CPX INTERFACE Part-time Indicator		P08_CLS24	CHAR	1
CRATE	CLASS CPX INTERFACE Contribution Rate		P08_CLS25	CHAR	6
DLEFT	CLASS CPX INTERFACE Date Left Active Service		P08_CLS26	CHAR	8
LEFTR	CLASS CPX INTERFACE Reason For Leaving		P08_CLS27	CHAR	4
FILLC	CLASS CPX INTERFACE Filler 3 Characters		P08_CLS03	CHAR	3
KEY3	CLASS CPX INTERFACE Third Key		P08_CLS28	CHAR	12
KEY4	CLASS CPX INTERFACE Fourth Key		P08_CLS29	CHAR	12
SPDT1	CLASS CPX INTERFACE Spare Date 1		P08_CLS30	CHAR	8
SPDT2	CLASS CPX INTERFACE Spare Date 2		P08_CLS31	CHAR	8
SPDT3	CLASS CPX INTERFACE Spare Date 3		P08_CLS32	CHAR	8
SPIND	CLASS CPX INTERFACE Spare Indicator		P08_CLS33	CHAR	1
PTPER	CLASS CPX INTERFACE Part-time Percentage		P08_CLS34	CHAR	9
NOTUS	CLASS CPX INTERFACE NOT FOR USE		P08_CLS35	CHAR	2
LADD1	CLASS CPX INTERFACE Leavers Address Line 1		P08_CLS36	CHAR	30
LADD2	CLASS CPX INTERFACE Leavers Address Line 2		P08_CLS37	CHAR	30
LADD3	CLASS CPX INTERFACE Leavers Address Line 3		P08_CLS38	CHAR	30
LADD4	CLASS CPX INTERFACE Leavers Address Line 4		P08_CLS39	CHAR	30
LADD5	CLASS CPX INTERFACE Leavers Address Line 5		P08_CLS40	CHAR	20
LPTCD	CLASS CPX INTERFACE Leavers Post Code		P08_CLS41	CHAR	10
SPNAM	CLASS CPX INTERFACE NOK Spouse's Name		P08_CLS42	CHAR	25
SPV	CLASS CPX INTERFACE NOK Spouse "V"		P08_CLS43	CHAR	1
SPKID	CLASS CPX INTERFACE NOK Number Of Children		P08_CLS44	CHAR	1
SPMDT	CLASS CPX INTERFACE NOK Spouse Date Of Marriage		P08_CLS45	CHAR	8
SPV2	CLASS CPX INTERFACE NOK Spouse V		P08_CLS46	CHAR	1
SPID1	CLASS CPX INTERFACE NOK Spouse Indicator 1		P08_CLS47	CHAR	1
SPID2	CLASS CPX INTERFACE NOK Spouse Indicator 2		P08_CLS48	CHAR	1
SPGEN	CLASS CPX INTERFACE NOK Spouse General		P08_CLS49	CHAR	9
CADD1	CLASS CPX INTERFACE Correspondence Address Line 1		P08_CLS50	CHAR	30
CADD2	CLASS CPX INTERFACE Correspondence Address Line 2		P08_CLS51	CHAR	30
CADD3	CLASS CPX INTERFACE Correspondence Address Line 3		P08_CLS52	CHAR	30
CADD4	CLASS CPX INTERFACE Correspondence Address Line 4		P08_CLS53	CHAR	30
CADD5	CLASS CPX INTERFACE Correspondence Address Line 5		P08_CLS54	CHAR	30
CPTCD	CLASS CPX INTERFACE Correspondence Post Code		P08_CLS55	CHAR	10
FILL5	CLASS CPX INTERFACE Filler 13 Characters		P08_CLS56	CHAR	13
S1SDT	CLASS CPX INTERFACE Service 1 Start Date		P08_CLS57	CHAR	8
S1EDT	CLASS CPX INTERFACE Service 1 End Date		P08_CLS58	CHAR	8
S1ADJ	CLASS CPX INTERFACE Service 1 Adjustment		P08_CLS59	CHAR	11
S1ID1	CLASS CPX INTERFACE Service 1 Indicator 1		P08_CLS60	CHAR	1
S1ID2	CLASS CPX INTERFACE Service 1 Indicator 2		P08_CLS61	CHAR	1
FILL6	CLASS CPX INTERFACE Filler 1 Character		P08_CLS62	CHAR	1
S1SI1	CLASS CPX INTERFACE Scheme Indicator 1		P08_CLS63	CHAR	3
S1SI2	CLASS CPX INTERFACE Scheme Indicator 2		P08_CLS64	CHAR	3
S1SI3	CLASS CPX INTERFACE Scheme Indicator 3		P08_CLS65	CHAR	3
FILL7	CLASS CPX INTERFACE Filler 15 Characters		P08_CLS66	CHAR	15
S2SDT	CLASS CPX INTERFACE Service 2 Start Date		P08_CLS67	CHAR	8
S2EDT	CLASS CPX INTERFACE Service 2 End Date		P08_CLS68	CHAR	8
S2ADJ	CLASS CPX INTERFACE Service 2 Adjustment		P08_CLS69	CHAR	11
S2ID1	CLASS CPX INTERFACE Service 2 Indicator 1		P08_CLS70	CHAR	1
S2ID2	CLASS CPX INTERFACE Service 2 Indicator 2		P08_CLS71	CHAR	1
FILL8	CLASS CPX INTERFACE Filler 1 Character		P08_CLS72	CHAR	1
S2SI1	CLASS CPX INTERFACE Scheme Indicator 1		P08_CLS73	CHAR	3
S2SI2	CLASS CPX INTERFACE Scheme Indicator 2		P08_CLS74	CHAR	3
S2SI3	CLASS CPX INTERFACE Scheme Indicator 3		P08_CLS75	CHAR	3
FILL9	CLASS CPX INTERFACE Filler 15 Characters		P08_CLS76	CHAR	15
SBSDT	CLASS CPX INTERFACE Service Break Start Date		P08_CLS77	CHAR	8
SBEDT	CLASS CPX INTERFACE Service Break End Date		P08_CLS78	CHAR	8
SBHR1	CLASS CPX INTERFACE Service Break Hours 1		P08_CLS79	CHAR	5
SBHR2	CLASS CPX INTERFACE Service Break Hours 2		P08_CLS80	CHAR	5
SBID1	CLASS CPX INTERFACE Service Break Indicator 1		P08_CLS81	CHAR	1
SBID2	CLASS CPX INTERFACE Service Break Indicator 2		P08_CLS82	CHAR	1
SBID3	CLASS CPX INTERFACE Service Break Indicator 3		P08_CLS83	CHAR	1
FILLA	CLASS CPX INTERFACE Filler 1 Character		P08_CLS84	CHAR	1
SBGEN	CLASS CPX INTERFACE Service Break General		P08_CLS85	CHAR	18
DMEMC	CLASS CPX INTERFACE Date 1 (Members Contributions)		P08_CLS86	CHAR	8
AMEMC	CLASS CPX INTERFACE Amount 1 (Members Contributions)		P08_CLS87	CHAR	11
DSTRC	CLASS CPX INTERFACE Date 2 (Strike Break Contributions)		P08_CLS88	CHAR	8
ASTRC	CLASS CPX INTERFACE Amount 2 (Strike Break Contributions)		P08_CLS89	CHAR	11
DNICC	CLASS CPX INTERFACE Date 3 (NI Earnings)		P08_CLS90	CHAR	8
ANICC	CLASS CPX INTERFACE Amount 3 (NI Earnings)		P08_CLS91	CHAR	11
DACTC	CLASS CPX INTERFACE Date 4 (Actual Remuneration)		P08_CLS92	CHAR	8
AACTC	CLASS CPX INTERFACE Amount 4 (Actual Remuneration)		P08_CLS93	CHAR	11
DPENC	CLASS CPX INTERFACE Date 5 (Pensionable Remuneration)		P08_CLS94	CHAR	8
APENC	CLASS CPX INTERFACE Amount 5 (Pensionable Remuneration)		P08_CLS95	CHAR	11
DSIX	CLASS CPX INTERFACE Date 6		P08_CLS96	CHAR	8
ASIX	CLASS CPX INTERFACE Amount 6		P08_CLS97	CHAR	11
S2DAT	CLASS CPX INTERFACE Date (Set 2)		P08_CLS98	CHAR	8
S2AM1	CLASS CPX INTERFACE Amount 1 (Set 2)		P08_CLS99	CHAR	11
S2AM2	CLASS CPX INTERFACE Amount 2 (Set 2)		P08_CLSA0	CHAR	11
S2TYP	CLASS CPX INTERFACE Type (Set 2)		P08_CLSA1	CHAR	4
S3DAT	CLASS CPX INTERFACE Date (Set 3)		P08_CLSA2	CHAR	8
S3AM1	CLASS CPX INTERFACE Amount 1 (Set 3)		P08_CLSA3	CHAR	11
S3AM2	CLASS CPX INTERFACE Amount 2 (Set 3)		P08_CLSA4	CHAR	11
S3TYP	CLASS CPX INTERFACE Type (Set 3)		P08_CLSA5	CHAR	4
S4DAT	CLASS CPX INTERFACE Date (Set 4)		P08_CLSA6	CHAR	8
S4AM1	CLASS CPX INTERFACE Amount 1 (Set 4)		P08_CLSA7	CHAR	11
S4AM2	CLASS CPX INTERFACE Amount 2 (Set 4)		P08_CLSA8	CHAR	11
S4AM3	CLASS CPX INTERFACE Amount 3 (Set 4)		P08_CLSA9	CHAR	11
S4AM4	CLASS CPX INTERFACE Amount 4 (Set 4)		P08_CLSB0	CHAR	11
S4TYP	CLASS CPX INTERFACE Type (Set 4)		P08_CLSB1	CHAR	4
FILLB	CLASS CPX INTERFACE Filler 10 Characters		P08_CLSB2	CHAR	10