P08P1CLS

CLASS CPX INTERFACE Snapshot Table | #transactional | Component: null
Column Name Description
MANDT Client
PERNR Personnel Number
SDATE CLASS CPX INTERFACE Control File Snapshot Date
RUNNO CLASS CPX INTERFACE Control File Run Number
RECTP CLASS CPX INTERFACE Record Type (Starter,Amendment,Leaver) Show values
NINUM CLASS CPX INTERFACE National Insurance Number
FILL1 CLASS CPX INTERFACE Filler 3 Characters
KEY2 CLASS CPX INTERFACE Second Key
Column Name Description
Column Name Description
Column Name Description
SDATE CLASS CPX INTERFACE Control File Snapshot Date
Column Name Description
RECTP CLASS CPX INTERFACE Record Type (Starter,Amendment,Leaver) Show values
CLASS CLASS CPX INTERFACE Class Show values
Column Name Description Domain name
SNAME CLASS CPX INTERFACE Surname CHAR25
FNAME CLASS CPX INTERFACE Forenames CHAR25
SCHEM CLASS CPX INTERFACE Scheme Id CHAR3
STATU CLASS CPX INTERFACE Status CHAR1
SEX CLASS CPX INTERFACE Sex CHAR1
DOB CLASS CPX INTERFACE Date Of Birth CHAR8
DJEMP CLASS CPX INTERFACE Date Joined Employer CHAR8
DJFUN CLASS CPX INTERFACE Date Joined Fund CHAR8
LSDAT CLASS CPX INTERFACE Location Start Date CHAR8
LOCAT CLASS CPX INTERFACE Location CHAR5
FILL2 CLASS CPX INTERFACE Filler 5 Characters CHAR5
DSPEN CLASS CPX INTERFACE Date Commenced Pensionable Service CHAR8
DOSER CLASS CPX INTERFACE Date Contracted Out Of SERPS CHAR8
FILL3 CLASS CPX INTERFACE Filler 8 digits. CHAR8
TITLE CLASS CPX INTERFACE Title CHAR4
FILL4 CLASS CPX INTERFACE Filler 14 Characters CHAR14
NILET CLASS CPX INTERFACE NI Table Letter CHAR1
REDNI CLASS CPX INTERFACE Reduced NI Indicator CHAR1
PTIND CLASS CPX INTERFACE Part-time Indicator CHAR1
CRATE CLASS CPX INTERFACE Contribution Rate CHAR6
DLEFT CLASS CPX INTERFACE Date Left Active Service CHAR8
LEFTR CLASS CPX INTERFACE Reason For Leaving CHAR4
FILLC CLASS CPX INTERFACE Filler 3 Characters CHAR3
KEY3 CLASS CPX INTERFACE Third Key CHAR12
KEY4 CLASS CPX INTERFACE Fourth Key CHAR12
SPDT1 CLASS CPX INTERFACE Spare Date 1 CHAR8
SPDT2 CLASS CPX INTERFACE Spare Date 2 CHAR8
SPDT3 CLASS CPX INTERFACE Spare Date 3 CHAR8
SPIND CLASS CPX INTERFACE Spare Indicator CHAR1
PTPER CLASS CPX INTERFACE Part-time Percentage CHAR9
NOTUS CLASS CPX INTERFACE NOT FOR USE CHAR2
LADD1 CLASS CPX INTERFACE Leavers Address Line 1 CHAR30
LADD2 CLASS CPX INTERFACE Leavers Address Line 2 CHAR30
LADD3 CLASS CPX INTERFACE Leavers Address Line 3 CHAR30
LADD4 CLASS CPX INTERFACE Leavers Address Line 4 CHAR30
LADD5 CLASS CPX INTERFACE Leavers Address Line 5 CHAR20
LPTCD CLASS CPX INTERFACE Leavers Post Code CHAR10
SPNAM CLASS CPX INTERFACE NOK Spouse's Name CHAR25
SPV CLASS CPX INTERFACE NOK Spouse "V" CHAR1
SPKID CLASS CPX INTERFACE NOK Number Of Children CHAR1
SPMDT CLASS CPX INTERFACE NOK Spouse Date Of Marriage CHAR8
SPV2 CLASS CPX INTERFACE NOK Spouse V CHAR1
SPID1 CLASS CPX INTERFACE NOK Spouse Indicator 1 CHAR1
SPID2 CLASS CPX INTERFACE NOK Spouse Indicator 2 CHAR1
SPGEN CLASS CPX INTERFACE NOK Spouse General CHAR9
CADD1 CLASS CPX INTERFACE Correspondence Address Line 1 CHAR30
CADD2 CLASS CPX INTERFACE Correspondence Address Line 2 CHAR30
CADD3 CLASS CPX INTERFACE Correspondence Address Line 3 CHAR30
CADD4 CLASS CPX INTERFACE Correspondence Address Line 4 CHAR30
CADD5 CLASS CPX INTERFACE Correspondence Address Line 5 CHAR30
CPTCD CLASS CPX INTERFACE Correspondence Post Code CHAR10
FILL5 CLASS CPX INTERFACE Filler 13 Characters CHAR13
S1SDT CLASS CPX INTERFACE Service 1 Start Date CHAR8
S1EDT CLASS CPX INTERFACE Service 1 End Date CHAR8
S1ADJ CLASS CPX INTERFACE Service 1 Adjustment CHAR11
S1ID1 CLASS CPX INTERFACE Service 1 Indicator 1 CHAR1
S1ID2 CLASS CPX INTERFACE Service 1 Indicator 2 CHAR1
FILL6 CLASS CPX INTERFACE Filler 1 Character CHAR1
S1SI1 CLASS CPX INTERFACE Scheme Indicator 1 CHAR3
S1SI2 CLASS CPX INTERFACE Scheme Indicator 2 CHAR3
S1SI3 CLASS CPX INTERFACE Scheme Indicator 3 CHAR3
FILL7 CLASS CPX INTERFACE Filler 15 Characters CHAR15
S2SDT CLASS CPX INTERFACE Service 2 Start Date CHAR8
S2EDT CLASS CPX INTERFACE Service 2 End Date CHAR8
S2ADJ CLASS CPX INTERFACE Service 2 Adjustment CHAR11
S2ID1 CLASS CPX INTERFACE Service 2 Indicator 1 CHAR1
S2ID2 CLASS CPX INTERFACE Service 2 Indicator 2 CHAR1
FILL8 CLASS CPX INTERFACE Filler 1 Character CHAR1
S2SI1 CLASS CPX INTERFACE Scheme Indicator 1 CHAR3
S2SI2 CLASS CPX INTERFACE Scheme Indicator 2 CHAR3
S2SI3 CLASS CPX INTERFACE Scheme Indicator 3 CHAR3
FILL9 CLASS CPX INTERFACE Filler 15 Characters CHAR15
SBSDT CLASS CPX INTERFACE Service Break Start Date CHAR8
SBEDT CLASS CPX INTERFACE Service Break End Date CHAR8
SBHR1 CLASS CPX INTERFACE Service Break Hours 1 CHAR5
SBHR2 CLASS CPX INTERFACE Service Break Hours 2 CHAR5
SBID1 CLASS CPX INTERFACE Service Break Indicator 1 CHAR1
SBID2 CLASS CPX INTERFACE Service Break Indicator 2 CHAR1
SBID3 CLASS CPX INTERFACE Service Break Indicator 3 CHAR1
FILLA CLASS CPX INTERFACE Filler 1 Character CHAR1
SBGEN CLASS CPX INTERFACE Service Break General CHAR18
DMEMC CLASS CPX INTERFACE Date 1 (Members Contributions) CHAR8
AMEMC CLASS CPX INTERFACE Amount 1 (Members Contributions) CHAR11
DSTRC CLASS CPX INTERFACE Date 2 (Strike Break Contributions) CHAR8
ASTRC CLASS CPX INTERFACE Amount 2 (Strike Break Contributions) CHAR11
DNICC CLASS CPX INTERFACE Date 3 (NI Earnings) CHAR8
ANICC CLASS CPX INTERFACE Amount 3 (NI Earnings) CHAR11
DACTC CLASS CPX INTERFACE Date 4 (Actual Remuneration) CHAR8
AACTC CLASS CPX INTERFACE Amount 4 (Actual Remuneration) CHAR11
DPENC CLASS CPX INTERFACE Date 5 (Pensionable Remuneration) CHAR8
APENC CLASS CPX INTERFACE Amount 5 (Pensionable Remuneration) CHAR11
DSIX CLASS CPX INTERFACE Date 6 CHAR8
ASIX CLASS CPX INTERFACE Amount 6 CHAR11
S2DAT CLASS CPX INTERFACE Date (Set 2) CHAR8
S2AM1 CLASS CPX INTERFACE Amount 1 (Set 2) CHAR11
S2AM2 CLASS CPX INTERFACE Amount 2 (Set 2) CHAR11
S2TYP CLASS CPX INTERFACE Type (Set 2) CHAR4
S3DAT CLASS CPX INTERFACE Date (Set 3) CHAR8
S3AM1 CLASS CPX INTERFACE Amount 1 (Set 3) CHAR11
S3AM2 CLASS CPX INTERFACE Amount 2 (Set 3) CHAR11
S3TYP CLASS CPX INTERFACE Type (Set 3) CHAR4
S4DAT CLASS CPX INTERFACE Date (Set 4) CHAR8
S4AM1 CLASS CPX INTERFACE Amount 1 (Set 4) CHAR11
S4AM2 CLASS CPX INTERFACE Amount 2 (Set 4) CHAR11
S4AM3 CLASS CPX INTERFACE Amount 3 (Set 4) CHAR11
S4AM4 CLASS CPX INTERFACE Amount 4 (Set 4) CHAR11
S4TYP CLASS CPX INTERFACE Type (Set 4) CHAR4
FILLB CLASS CPX INTERFACE Filler 10 Characters CHAR10