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