| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P08RTI_XMLD | RTI | 3 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
2 | P2RG_RTI | Real Time Information | 35 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
3 | P2RG_RTINI | Real Time Information - National Insurance | 17 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
4 | PA3331 | HR Master Record: Infotype 3331 | 31 | GLBID | B2A Object ID | nvarchar | 32 | 0 | | |
5 | T5G_RTIDC | RTI Declaration Data | 27 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
6 | T7BREFD_STLOG | Event status log | 10 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
TOPB2A Business to Administration |
7 | PB2AMGR | HR-B2A: Application Data | 3 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
8 | PB2ASTAT | HR-B2A: Status Management | 3 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
TOPCompany Pension Scheme Germany |
9 | P01RBM_HIST | Notification Status: Pension Receipt Notifications | 11 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
10 | P01RBM_STAT | Notification Status: Pension Receipt Notifications | 17 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
11 | P01RBM_STAT_R | Status of Confirmations (Pension Receipt Notifications) | 17 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
12 | P01RBM_TRANS | RBM: Status Table for Transfer | 10 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
TOPGreat Britain |
13 | PA0065 | HR Master Record: Infotype 0065 (Tax - GB) | 42 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
14 | PA0070 | HR Master Record: Infotype 0070 (Court Orders - GB) | 53 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
15 | PA0757 | HR Master Record: Infotype 0757 | 34 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
16 | T5GEF01 | HR-GB: filing - Store parsed recording coming in from GG | 3 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
17 | T5GEFDATA | HR-GB: filing - Store Infotype data coming in from GG | 3 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
18 | T5GEFMSGID | HR:GB eFiling : Temporary storage of Message IDs | 2 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
TOPJapan |
19 | T7JP_ACCLOG | Access Log | 3 | GLBID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
20 | T7JP_UPTLOG | Update Log | 3 | GLBID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
TOPPublic Sector |
21 | P01ZFA_NN_STATUS | ZfA: Status Management for ZKNN Notifications | 13 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
22 | P01ZFA_STATUS | ZfA: Status Management for Notifications | 14 | GLBID | ZfA: B2A Process ID | nvarchar | 32 | 0 | | |
23 | P01ZFA_TRANS | ZfA: Status Table for Transfer | 10 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
TOPReuse Services for Country Development |
24 | T5F99SE | Subdocument status table | 7 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
25 | T5F99SR | Document status table | 5 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
TOPSocial Insurance |
26 | P01SV_B2ATRNS | Status Table Transfer to Social Insurance Agency | 2 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
TOPSpain |
27 | PA0768 | Personal data | 42 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
28 | PA0799 | AFI message data | 52 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
29 | T5EL5 | Protected data access log | 3 | GLBID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
30 | T5EL7 | Log for accessing protected data for XML files | 2 | GLBID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
TOPTax |
31 | P01E2_LIST_ST | Status Table for ELStAM Procedure Change Lists | 5 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
32 | P01E2_TRANS | Relationship Between GLBID/Proc. Data Ticket/Transfer Ticket | 2 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
33 | P01E2_TRANS_ST | Status Table Transfer for ELStAM Procedure | 2 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
34 | P01T_TRANS | ETStmt: Administration/Processing Data Tickets | 9 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |
TOPUnited Kingdom |
35 | T5GBGC_XML | Link Correlation ID to Global B2A ID | 2 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | | |