SAP ABAP Table PS0495 (HR-PS-SG: Pensions Scheme)
Hierarchy
SAP_HRCSG (Software Component) Sub component SAP_HRCSG of SAP_HR
   PY-SG-PS (Application Component) Public Sector
     P25P1 (Package) Public Sector Singapore
Basic Data
Table Category INTTAB    Structure 
Structure PS0495   Table Relationship Diagram
Short Description HR-PS-SG: Pensions Scheme    
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 STYPE P25_STYPE P25_STYPE CHAR 6   0   Superannuation Scheme T5RPBS8A
2 PTYPE P25_PTYPE P25_PTYPE CHAR 6   0   Payment Option T5RPBS8B
3 FUTDTE P25_FUTDTE DATUM DATS 8   0   Date of payment for CPF payment  
4 APEAMT P25_LIAMT P_AMT07V CURR 13   2   Liability amount  
5 PBSAMT P25_PBSAMT BETRG CURR 9   2   SG Public Sector Pensions Scheme Basic Salary Per Annum  
6 PAAMT P25_PAAMT BETRG CURR 9   2   SG PS Pensions Scheme Pensionable Allowance Per Annum  
7 RESECT P25_RESECT TEXT50 CHAR 50   0   SG PS Pensions Scheme Relevant Section of Pensions Act  
8 REFOPT P25_REFOPT P25_REFOPT CHAR 1   0   Refund Option  
9 REFACT P25_REFACT CHECKBOX CHAR 1   0   Flag to indicate whether CPF contributions already refunded  
10 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
11 AMTOPT P25_AMTOPT BETRG CURR 9   2   Employer's CPF contribution amount to be refunded  
12 AMTACT P25_AMTACT BETRG CURR 9   2   Employer's CPF contribution amount already refunded  
13 DTREF P25_DTREF DATUM DATS 8   0   Date of payment for refund of Govt's CPF share  
14 REFRNO P25_REFRNO TEXT20 CHAR 20   0   SG PS Pensions Receipt No for Refund of CPF Contributions  
15 REFRDT P25_REFRDT DATUM DATS 8   0   SG PS Pensions Receipt Date for Refund of CPF Contributions  
16 REFENO P25_REFENO TEXT20 CHAR 20   0   SG PS Pensions Enclosure No for Refund of CPF Contributions  
17 RECPFA P25_RECPFA P_AMT07V CURR 13   2   CPF minimum top up sum paid to officer's CPF account  
18 PROCF P25_PROCF CHECKBOX CHAR 1   0   Flag to indicate whether Ee has been processed for Pensions  
19 OPUPF P25_OPUPF CHECKBOX CHAR 1   0   Indicator for Pensions Scheme Option selected via report  
20 OPMPF P25_OPMPF CHECKBOX CHAR 1   0   Indicator for Scheme Option maintained manually by user  
21 ACO01 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service  
22 BEG01 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
23 END01 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
24 ACO02 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service  
25 BEG02 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
26 END02 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
27 ACO03 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service  
28 BEG03 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
29 END03 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
30 ACO04 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service  
31 BEG04 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
32 END04 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
33 ACO05 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service  
34 BEG05 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
35 END05 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
36 ACO06 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service  
37 BEG06 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
38 END06 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
39 ACO07 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service  
40 BEG07 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
41 END07 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
42 ACO08 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service  
43 BEG08 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
44 END08 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
45 ACO09 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service  
46 BEG09 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
47 END09 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
48 ACO10 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service  
49 BEG10 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
50 END10 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
51 ACO11 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service  
52 BEG11 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
53 END11 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
54 ACO12 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service  
55 BEG12 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
56 END12 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
57 ACO13 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service  
58 BEG13 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
59 END13 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
60 ACO14 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service  
61 BEG14 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
62 END14 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
63 ACO15 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service  
64 BEG15 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
65 END15 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
66 ACO16 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service  
67 BEG16 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
68 END16 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
69 ACO17 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service  
70 BEG17 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
71 END17 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
72 ACO18 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service  
73 BEG18 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
74 END18 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
75 ACO19 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service  
76 BEG19 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
77 END19 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
78 ACO20 P25_ACODE P25_ACODE CHAR 4   0   Absence Code for absences not counted as pensionable service  
79 BEG20 P25_BEGDA DATUM DATS 8   0   SG Public Sector Pensions Scheme Start Date  
80 END20 P25_ENDDA DATUM DATS 8   0   SG Public Sector Pensions Scheme End Date  
81 PENSAL P25_PENSAL P_AMT07V CURR 13   2   Pensionable Salary for Computation of Govt's share of CPF  
82 NPESAL P25_NPESAL P_AMT07V CURR 13   2   Non-Pensionable Salary for Computing Govt's share of CPF  
83 FROSAL P25_GUABS P_AMT07V CURR 13   2   Guaranteed Basic Salary  
84 GUAPA P25_GUAPA P_AMT07V CURR 13   2   Guaranteed Pensionable Allowance  
85 CPFPY P25_CPFPY P_AMT07V CURR 13   2   CPF Payment amount to CPF board  
86 BENTY P25_BENTY P25_BENTY CHAR 3   0   Superannuation option T5RPBS8U
87 DEDPC P25_DEDPC DEC03_2 DEC 5   2   Deduction Percentage due to discipline  
88 PEACD P25_PEACD P25_PEACD CHAR 3   0   Pensions Act Code T5RPBS8T
89 PENS P25_PENS P25_PENS CHAR 1   0   Flag for Pension scheme 2006  
90 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 PS0495 BENTY T5RPBS8U BENTY    
2 PS0495 PEACD T5RPBS8T PEACD    
3 PS0495 PTYPE T5RPBS8B PTYPE    
4 PS0495 STYPE T5RPBS8A STYPE    
5 PS0495 WAERS TCURC WAERS    
History
Last changed by/on SAP  20130529 
SAP Release Created in