| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2IE_PENS | Pension Funds (IE) | 7 | SCHID | Scheme Identification Number | nvarchar | 3 | 0 | | |
2 | P2RU_GRDOC | Payroll Results: Garnishment for US Document | 20 | SCHID | Separate check indicator | nvarchar | 1 | 0 | | |
3 | T5GPBS1 | CLASS CPX Pension Scheme Cross Reference | 5 | SCHID | CLASS CPX INTERFACE Scheme Id | nvarchar | 3 | 0 | | |
4 | T5GPBSP_PSCH | Local Government Pension Schemes | 2 | SCHID | Pension scheme | nvarchar | 3 | 0 | | |
5 | T5GPBST_PEN | TPS Primary and Additional pension schemes | 2 | SCHID | Pension scheme | nvarchar | 3 | 0 | | |
6 | T5GPBS_USS | Absence Evaluation: Scheme Switches | 2 | SCHID | Pension scheme | nvarchar | 3 | 0 | | |
7 | T5G_ERPENCUM | Employer's Pensionable Pay options | 3 | SCHID | Pension scheme | nvarchar | 3 | 0 | | |
TOPB2A Business to Administration |
8 | T50G_XML | XML-Global Schema | 7 | SCHID | XML-Schema Identification | nvarchar | 5 | 0 | | |
TOPGeneral Parts |
9 | T74_FBN_GB04 | Flexible Benefits Plan GB Pension Attribute | 6 | SCHID | Pension scheme | nvarchar | 3 | 0 | | |
TOPGreat Britain |
10 | T5G30 | Pension Schemes | 2 | SCHID | Pension scheme | nvarchar | 3 | 0 | | |
11 | T5G31 | Pension Contribution Calculation Rules | 2 | SCHID | Pension scheme | nvarchar | 3 | 0 | | |
12 | T5G32 | Pension Holidays | 2 | SCHID | Pension scheme | nvarchar | 3 | 0 | | |
13 | T5G37 | Pension Scheme Types | 2 | SCHID | Pension scheme | nvarchar | 3 | 0 | | |
14 | T5G3T | Pension Scheme Names | 3 | SCHID | Pension scheme | nvarchar | 3 | 0 | | |
15 | T5G_ERPEN | Absence Valuation | 5 | SCHID | Pension scheme | nvarchar | 3 | 0 | | |
TOPIreland |
16 | PA0361 | HR Master Record : Infotype 0361 (Pensions Admin. - IE) | 24 | SCHID | Scheme Identification Number | nvarchar | 3 | 0 | | |
17 | T7IEP | Pension schemes Ireland | 2 | SCHID | Scheme Identification Number | nvarchar | 3 | 0 | | |
TOPProduction Planning |
18 | TCPFS1 | Organization of data adjustment for external planning tool | 3 | SCHID | Planning tool | nvarchar | 10 | 0 | | |
19 | TCPFS3 | External planning tool: lock table | 3 | SCHID | Planning tool | nvarchar | 10 | 0 | | |
20 | TCPFS4 | External planning tool | 2 | SCHID | Planning tool | nvarchar | 10 | 0 | | |
21 | TCPFS4T | Planning tool description | 3 | SCHID | Planning tool | nvarchar | 10 | 0 | | |
22 | TCPFS5 | External planning tool: start parameters for Windows NT | 3 | SCHID | Planning tool | nvarchar | 10 | 0 | | |
TOPUnited Kingdom |
23 | T5GASHE1 | ASHE Pension Type | 2 | SCHID | Pension scheme | nvarchar | 3 | 0 | | |
24 | T5GPBSP_PRO | LGPS Protected Contribution Rates | 2 | SCHID | Pension scheme | nvarchar | 3 | 0 | | |
25 | T5GPBSP_SCH | GBLGP: Pension Schemes | 2 | SCHID | Pension scheme | nvarchar | 3 | 0 | | |
26 | T5GPBSP_UNP | LGPS Unprotected Contribution Rates | 2 | SCHID | Pension scheme | nvarchar | 3 | 0 | | |
TOPUSA |
27 | PA0194 | HR Master Record Infotype 0194 (Garnishment Document) | 29 | SCHID | Separate check indicator | nvarchar | 1 | 0 | | |