SAP ABAP Table PSG08 (Pensions Scheme Records)
Hierarchy
☛ SAP_HRCSG (Software Component) Sub component SAP_HRCSG of SAP_HR
   ⤷ PY-SG-PS (Application Component) Public Sector
     ⤷ P25P4 (Package) HR-PS-SG: Public Sector Singapore (Pensions Scheme)
Basic Data
Table Category INTTAB    Structure 
Structure PSG08   Table Relationship Diagram
Short Description Pensions Scheme Records    
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 PERNR PERNR_D PERNR NUMC 8   0   Personnel Number  
2 STYPE P25_STYPE P25_STYPE CHAR 6   0   Superannuation Scheme *
3 STYPT P25_STYPT TEXT50 CHAR 50   0   Text for Superannuation Scheme  
4 SCODE P25_SCODE P25_SCODE CHAR 6   0   Pensions Scheme Codes  
5 PROCE P25_PROCE PSEN_PROCE CHAR 4   0   Length of Service at Pensions Scheme level *
6 MASSG MASSG MASSG CHAR 2   0   Reason for Action *
7 QPERIOD P25_NMSER NUMC04 NUMC 4   0   Number of Months of Service  
8 NQPL NQP_LOG   TTYP 0   0    
9 QPL QP_LOG   TTYP 0   0    
10 COMPQPL CQP_LOG   TTYP 0   0    
11 CPFL CPF_LOG   TTYP 0   0    
12 OPTL OPT_LOG   TTYP 0   0    
13 HIRED DATUM DATUM DATS 8   0   Date  
14 LEFTD DATUM DATUM DATS 8   0   Date  
15 PBSAMT P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
16 PAAMT P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
17 APEAMT P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
18 MPBSAMT P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
19 MPAAMT P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
20 MAPEAMT P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
21 FNAME PAD_CNAME TEXT80 CHAR 80   0   Complete Name  
22 ALIA ALNAM TEXT60 CHAR 60   0   Alternative name  
23 ICNUM P25_IDNUM CHAR30 CHAR 30   0   Identity Number  
24 IDNUM P25_IDNUM CHAR30 CHAR 30   0   Identity Number  
25 ICTYPE ICTXT TEXT30 CHAR 30   0   IC description  
26 ICCOL ICCOL TEXT15 CHAR 15   0   IC color  
27 DOB DATUM DATUM DATS 8   0   Date  
28 AGE NUM03 NUM03 NUMC 3   0   Counter  
29 SAPPT STLTX TEXT25 CHAR 25   0   Job Title  
30 DIV PSG_DVTXT TEXT50 CHAR 50   0   Division text  
31 MINISTRY PBTXT TEXT30 CHAR 30   0   Personnel Area Text  
32 DEPT BTRTX TEXT15 CHAR 15   0   Personnel Subarea Text  
33 TENURE PGTXT TEXT20 CHAR 20   0   Name of Employee Group  
34 BNKAC BANKN BANKN CHAR 18   0   Bank account number  
35 BNKNAME BANKA TEXT60 CHAR 60   0   Name of bank  
36 BNKADDR STRAS_GP TEXT35 CHAR 35   0   House number and street  
37 RETIRERSN TEXT30 TEXT30 CHAR 30   0   Text (30 Characters)  
38 RETIRESECT TEXT72 TEXT72 CHAR 72   0   Text Line  
39 RETIRESECT1 TEXT72 TEXT72 CHAR 72   0   Text Line  
40 AMTREF P25_AMTACT BETRG CURR 9   2   Employer's CPF contribution amount already refunded  
41 RECEIPTNO CHAR_35 CHAR_35 CHAR 35   0   Text field, length 35  
42 RECEIPTDATE DATUM DATUM DATS 8   0   Date  
43 ENCLNO CHAR_35 CHAR_35 CHAR 35   0   Text field, length 35  
44 AMTNREF P25_AMTOPT BETRG CURR 9   2   Employer's CPF contribution amount to be refunded  
45 CPFDEDN P25_RECPFA P_AMT07V CURR 13   2   CPF minimum top up sum paid to officer's CPF account  
46 CSAL P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
47 CALLOWN P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
48 CAPE P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
49 NCALYY PSEN_CALYY PSEN_CALYY DEC 7   4   Employment period calculation interface: Duration in years  
50 NCALMM PSEN_CALMM PSEN_CALMM DEC 9   4   Employment period calculation interface: Duration in months  
51 NCALDD PSEN_CALDD PSEN_CALDD DEC 11   4   Employment period calculation interface: Duration in days  
52 FPEN P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
53 RPEN P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
54 GRAT P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
55 FGRAT P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
56 FROAMT P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
57 WAERS WAERS WAERS CUKY 5   0   Currency Key *
58 FROSAL P25_FROSAL P_AMT07V CURR 13   2   Frozen salary  
59 CPERIOD P25_NMSER NUMC04 NUMC 4   0   Number of Months of Service  
60 RETDATE DATUM DATUM DATS 8   0   Date  
61 FORMTY CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
62 LDS_PBSAMT P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
63 LDS_PAAMT P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
64 LDS_APEAMT P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
65 LDS_MPBSAMT P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
66 LDS_MPAAMT P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
67 LDS_MAPEAMT P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
68 LIAMT P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
69 MIN_AGE NUM03 NUM03 NUMC 3   0   Counter  
70 NO_MONTH NUM03 NUM03 NUMC 3   0   Counter  
71 DISCOUNT_FACTOR PSG_DEC_12_10 PSG_DEC_12_10 DEC 12   10   Decimals  
72 DISCOUNT_FGRAT P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
73 DEDPC P25_DEDPC DEC03_2 DEC 5   2   Deduction Percentage due to discipline  
74 RED_FACTOR P25_DEDPC DEC03_2 DEC 5   2   Deduction Percentage due to discipline  
75 APORX TEXT30 TEXT30 CHAR 30   0   Text (30 Characters)  
76 FGRAT_OLD P25_APEAMT BETRG CURR 9   2   Pensions Scheme Annual Pensionable Emolument Amount  
77 CPF_PAYMENT P25_AMTOPT BETRG CURR 9   2   Employer's CPF contribution amount to be refunded  
78 AVEL PSG_AVE_LOG   TTYP 0   0    
79 SUMMARYL PSG_SUMMARY_LOG   TTYP 0   0    
80 PAGENO4 P25_RPAGE DEC2 DEC 2   0   Page number  
81 PAGENO4A P25_RPAGE DEC2 DEC 2   0   Page number  
82 PAGENO4B P25_RPAGE DEC2 DEC 2   0   Page number  
83 PAGENO4C P25_RPAGE DEC2 DEC 2   0   Page number  
84 PAGENO5 P25_RPAGE DEC2 DEC 2   0   Page number  
85 PAGENO5A P25_RPAGE DEC2 DEC 2   0   Page number  
86 PAGENO6 P25_RPAGE DEC2 DEC 2   0   Page number  
87 PAGENO7 P25_RPAGE DEC2 DEC 2   0   Page number  
88 PAGENO8 P25_RPAGE DEC2 DEC 2   0   Page number  
89 QPCONTROL CHAR_02 CHAR02 CHAR 2   0   Character length 2  
90 NQPCONTROL CHAR_02 CHAR02 CHAR 2   0   Character length 2  
91 QPNET_FLAG CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
92 PDATE DATUM DATUM DATS 8   0   Date  
93 PTIME UZEIT UZEIT TIMS 6   0   Time  
94 NS_BEGDA DATUM DATUM DATS 8   0   Date  
95 NS_ENDDA DATUM DATUM DATS 8   0   Date  
96 GROSS_LOS P25_NMSER NUMC04 NUMC 4   0   Number of Months of Service  
97 AMTNREF2 P25_AMTOPT BETRG CURR 9   2   Employer's CPF contribution amount to be refunded  
98 GPE_FLAG CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
99 MOSTFAVOR_NO CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
100 NAME2 PAD_RUFNM PAD_VORNM CHAR 40   0   Nickname  
101 ALIA2 ALNAM TEXT60 CHAR 60   0   Alternative name  
History
Last changed by/on SAP  20130529 
SAP Release Created in 46C