| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P05TPRNL_EE_RG | Pension Return: Income Relationship - Sector Risk Group | 5 | REGYR | For-Period Year | nvarchar | 4 | 0 | | |
2 | P05TPRNL_PR_OUT | Pension Return: PR - Output Data | 6 | REGYR | For-Period Year | nvarchar | 4 | 0 | | |
3 | PIQDB_NL_IBGH | IBG History | 3 | REGYR | Academic Year | nvarchar | 4 | 0 | | |
TOPReporting |
4 | P05TPRNL_C_SEQNO | Pension Return: Current sequence number per period | 3 | REGYR | For-Period Year | nvarchar | 4 | 0 | | |
5 | P05TPRNL_EE_ADM | Pension Return: Admin Income Relationship - Pers Level | 5 | REGYR | For-Period Year | nvarchar | 4 | 0 | | |
6 | P05TPRNL_EE_ADMS | Pension Return: Admin of Status Income Relationship - Pers L | 5 | REGYR | For-Period Year | nvarchar | 4 | 0 | | |
7 | P05TPRNL_EE_IRI | Pension Return: Income Relationship Indicators | 5 | REGYR | For-Period Year | nvarchar | 4 | 0 | | |
8 | P05TPRNL_EE_IRP | Pension Return: Income Relationship - Income Period - Pers L | 5 | REGYR | For-Period Year | nvarchar | 4 | 0 | | |
9 | P05TPRNL_EE_PD | Pension Return: Personal Data - Pers Level | 5 | REGYR | For-Period Year | nvarchar | 4 | 0 | | |
10 | P05TPRNL_EE_PR | Pension Return: Income Relationship Pens/Ins Relationship PL | 5 | REGYR | For-Period Year | nvarchar | 4 | 0 | | |
11 | P05TPRNL_EE_PRP | Pension Return: Income Rel - Pens/Ins Relation Period - PL | 5 | REGYR | For-Period Year | nvarchar | 4 | 0 | | |
12 | P05TPRNL_EE_PRPI | Pension Return: Income Rel - Pens/Ins Rel Period Indic PL | 5 | REGYR | For-Period Year | nvarchar | 4 | 0 | | |
13 | P05TPRNL_LP_ADM | Pension Return: Administration - Legal Pers Level | 5 | REGYR | For-Period Year | nvarchar | 4 | 0 | | |
14 | P05TPRNL_LP_ADMS | Pension Return: Administration of Status - Legal Pers Level | 5 | REGYR | For-Period Year | nvarchar | 4 | 0 | | |
15 | P05TPRNL_LP_COLL | Pension Return: Collective Return - Legal Pers Level | 5 | REGYR | For-Period Year | nvarchar | 4 | 0 | | |