SAP ABAP Table PS3297 (Pension Auto Enrolment)

Hierarchy

☛ SAP_HRCGB (Software Component) Sub component SAP_HRCGB of SAP_HR
   ⤷ PA-PA-GB (Application Component) Great Britain
     ⤷ PB08 (Package) HR master data: UK

Basic Data

Table Category	INTTAB	Structure
Structure	PS3297	Table Relationship Diagram
Short Description	Pension Auto Enrolment

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	NOTUK	☐	P08_NOTUK	XFELD	CHAR	1	0	PAE: Not working in UK
2	NOTWK	☐	P08_NOTWK	XFELD	CHAR	1	0	PAE: Not a worker
3	STGDT	☐	P08_STGDT	P08_STGDT	DATS	8	0	PAE: Staging Assessment Date
4	STAGE	☐	P08_STAGE	P08_STAGE	NUMC	3	0	PAE: Staging Employee Age
5	STQER	☐	P08_STQER	P08_STQER	CURR	15	2	PAE: Staging Qualifying Earnings
6	STWRC	☐	P08_STWRC	P08_STWRC	CHAR	4	0	PAE: Staging Worker Category
7	STATY	☐	P08_STATY	P08_STATY	CHAR	1	0	PAE: Staging Earnings Assessment Type
8	STQPS	☐	P08_STQPS	P08_SCHID	CHAR	3	0	PAE: Staging Qualifying Pension Scheme	T5G30
9	STDEN	☐	P08_STDEN	P08_STDEN	DATS	8	0	PAE: Staging Date Notice Sent
10	PTNTY	☐	P08_PTNTY	P08_PTNTY	CHAR	3	0	PAE: Staging Postponement Notice Type
11	PTAGE	☐	P08_PTAGE	P08_PTAGE	NUMC	2	0	PAE: Staging Postponement Employee Age
12	PTQER	☐	P08_PTQER	P08_PTQER	CURR	15	2	PAE: Staging Postponement Qualifying Earnings
13	PTWRC	☐	P08_PTWRC	P08_PTWRC	CHAR	4	0	PAE: Staging Postponement Worker Category
14	PTATY	☐	P08_PTATY	P08_PTATY	CHAR	1	0	PAE: Staging Postponement Assessment Type
15	PTQPS	☐	P08_PTQPS	P08_SCHID	CHAR	3	0	PAE: Staging Postponement Qualifying Pension Scheme	T5G30
16	PTDEN	☐	P08_PTDEN	P08_PTDEN	DATS	8	0	PAE: Staging Postponement Date Sent - NOT USED
17	PTDDT	☐	P08_PTDDT	P08_PTDDT	DATS	8	0	PAE: Staging Postponement Date
18	PTDDN	☐	P08_PTDDN	P08_PTDDN	DATS	8	0	PAE: Staging Postponement Date - NOT USED
19	AEGDT	☐	P08_AEGDT	P08_AEGDT	DATS	8	0	PAE: Enrolment Assessment Date
20	AEAGE	☐	P08_AEAGE	P08_AEAGE	NUMC	3	0	PAE: Enrolment Employee Age
21	AEQER	☐	P08_AEQER	P08_AEQER	CURR	15	2	PAE: Enrolment Qualifying Earnings
22	AEWRC	☐	P08_AEWRC	P08_AEWRC	CHAR	4	0	PAE: Enrolment Worker Category
23	AEATY	☐	P08_AEATY	P08_AEATY	CHAR	1	0	PAE: Enrolment Earnings Assessment Type
24	AEQPS	☐	P08_AEQPS	P08_SCHID	CHAR	3	0	PAE: Enrolment Qualifying Pension Scheme	T5G30
25	AEDEN	☐	P08_AEDEN	P08_AEDEN	DATS	8	0	PAE: Enrolment Date Notice Sent
26	APTTY	☐	P08_APNTY	P08_APNTY	CHAR	3	0	PAE: Enrolment Postponement Notice Type
27	APAGE	☐	P08_APAGE	P08_APAGE	NUMC	2	0	PAE: Enrolment Postponement Employee Age
28	APQER	☐	P08_APQER	P08_APQER	CURR	15	2	PAE: Enrolment Postponement Qualifying Earnings
29	APWRC	☐	P08_APWRC	P08_APWRC	CHAR	4	0	PAE: Enrolment Postponement Worker Category
30	APATY	☐	P08_APATY	P08_APATY	CHAR	1	0	PAE: Enrolment Postponement Earnings AssessmentType
31	APQPS	☐	P08_APQPS	P08_SCHID	CHAR	3	0	PAE: Enrolment Postponement Qualifying Pension Scheme	T5G30
32	APDEN	☐	P08_APDEN	P08_APDEN	DATS	8	0	PAE: Enrolment Postponement Date Notice Sent
33	APDDT	☐	P08_APDDT	P08_APDDT	DATS	8	0	PAE: Enrolment Postponement Assessment Postponed Until Date
34	APDDN	☐	P08_APDDN	P08_APDDN	DATS	8	0	PAE: Enrolment Postponement Enrolment Date
35	OIFDT	☐	P08_OIFDT	P08_OIFDT	DATS	8	0	PAE: Opt-In Form Received Date
36	OIVFM	☐	P08_OIVFM	XFELD	CHAR	1	0	PAE: Opt-In Valid Form
37	OIAGE	☐	P08_OIAGE	P08_OIAGE	NUMC	3	0	PAE: Opt-In Employee Age
38	OIQER	☐	P08_OIQER	P08_OIQER	CURR	15	2	PAE: Opt-In Qualifying Earnings
39	OIWRC	☐	P08_OIWRC	P08_OIWRC	CHAR	4	0	PAE: Opt-In Worker Category
40	OIATY	☐	P08_OIATY	P08_OIATY	CHAR	1	0	PAE: Opt-In Earnings Assessment Type
41	OIQPS	☐	P08_OIQPS	P08_SCHID	CHAR	3	0	PAE: Opt-In Qualifying Pension Scheme	T5G30
42	OIDEN	☐	P08_OIDEN	P08_OIDEN	DATS	8	0	PAE: Opt-In Date Notice Sent - NOT USED
43	OOFDT	☐	P08_OOFDT	P08_OOFDT	DATS	8	0	PAE: Opt-Out Form Received Date
44	OOWFM	☐	P08_OOWFM	P08_OOWFM	DATS	8	0	PAE: Opt-Out Window From Date
45	OOAGE	☐	P08_OOAGE	P08_OOAGE	NUMC	3	0	PAE: Opt-Out Employee Age
46	OOQER	☐	P08_OOQER	P08_OOQER	CURR	15	2	PAE: Opt-Out Qualifying Earnings
47	OOWRC	☐	P08_OOWRC	P08_OOWRC	CHAR	4	0	PAE: Opt-Out Worker Category
48	OOVFM	☐	P08_OOVFM	XFELD	CHAR	1	0	PAE: Opt-Out Valid Form
49	OOVTO	☐	P08_OOVTO	P08_OOVTO	DATS	8	0	PAE: Opt-Out Window To Date
50	OOATY	☐	P08_OOATY	P08_OOATY	CHAR	1	0	PAE: Opt-Out Assessment Type
51	OOQPS	☐	P08_OOQPS	P08_SCHID	CHAR	3	0	PAE: Opt-Out Qualifying Pension Scheme	T5G30
52	OODEN	☐	P08_OODEN	P08_OODEN	DATS	8	0	PAE: Opt-Out Date Notice Sent - NOT USED
53	OOPDT	☐	P08_OOPDT	P08_OOPDT	DATS	8	0	PAE: Enrolment Pension Provider Date Membership Achieved
54	TPEMC	☐	P08_TPEMC	P08_TPEMC	CHAR	1	0	PAE: Transitional Period
55	OISCH	☐	P08_OISCH	P08_SCHID	CHAR	3	0	PAE: Opt-In Pension Scheme	T5G30
56	OOSCH	☐	P08_OOSCH	P08_SCHID	CHAR	3	0	PAE: Opt-Out Pension Scheme	T5G30
57	AESCH	☐	P08_AESCH	P08_SCHID	CHAR	3	0	PAE: Auto-Enrolment Scheme	T5G30
58	OONRN	☐	P08_PAE_NEST_ID_OO	CHAR20	CHAR	20	0	PAE: NEST Opt-Out Reference Number
59	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PS3297	AEQPS	T5G30	SCHID
2	PS3297	AESCH	T5G30	SCHID		1	CN
3	PS3297	APQPS	T5G30	SCHID
4	PS3297	OIQPS	T5G30	SCHID
5	PS3297	OISCH	T5G30	SCHID		1	CN
6	PS3297	OOQPS	T5G30	SCHID
7	PS3297	OOSCH	T5G30	SCHID		1	CN
8	PS3297	PTQPS	T5G30	SCHID
9	PS3297	STQPS	T5G30	SCHID

History

Last changed by/on	SAP	20131127
SAP Release Created in