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
⤷ 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 |