| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P2IN_GRY | Payroll structure for Gratuity | 9 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| 2 | P2IN_SAN | Payroll structure for Superannuation | 9 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| 3 | T5GPBS_ALL | ALL Constants & Texts (as required) | 3 | ALGRP | ALL Table Group | nvarchar | 4 | 0 | | |
| 4 | T5GPBS_ALLT | ALL Text Table | 4 | ALGRP | ALL Table Group | nvarchar | 4 | 0 | | |
| 5 | T5LSW_ALL | ALL Constants & Texts (as required) | 3 | ALGRP | ALL Table Group | nvarchar | 4 | 0 | | |
| 6 | T5LSW_ALLT | ALL Text Table | 4 | ALGRP | ALL Table Group | nvarchar | 4 | 0 | | |
| 7 | T77WWW_CLMLSELIG | LTC Schemes mapping with Allowance Grouping | 3 | ALGRP | Allowance Grouping | nvarchar | 4 | 0 | | |
| 8 | T7INWTY_BASICPAY | Basic Pay wage types | 3 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| TOPIndia |
| 9 | T7INA1 | Reimbursement Allowances & Perks grouping | 3 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| 10 | T7INA2 | Text for Pay scale grouping for allowances | 3 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| 11 | T7INA3 | Allowance grouping definition table | 8 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| 12 | T7INA5 | Wage type Model for Pay scale grouping for Allowances | 3 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| 13 | T7INA9 | Reimbursement Allowances Perks - eligibility and calculati | 3 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| 14 | T7INAA | Salary years for Pay scale grouping for allowances | 3 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| 15 | T7INB1 | Basic Wage Type for Allowance Modifiers | 3 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| 16 | T7INB5 | Basic Codes for Allowance Groups | 3 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| 17 | T7INB8 | Appraisal Criteria | 3 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| 18 | T7INB9 | Increment criteria | 3 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| 19 | T7INC3 | Eligibility for company owned car scheme(COCS) | 3 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| 20 | T7INC7 | Eligibility for car schemes(COCS/OYCS) | 3 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| 21 | T7INC9 | Conveyance Eligibilty | 3 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| 22 | T7IND7 | Dearness allowance calculation rules | 3 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| 23 | T7INF5 | Company rates for provident fund | 3 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| 24 | T7ING1 | Gratuity details | 3 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| 25 | T7INL1 | Leave validation for LTA | 3 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| 26 | T7INO1 | One Day Salary Deduction | 3 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| 27 | T7INS1 | Superannuation details | 3 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| 28 | T7INY1 | Round off recovery | 3 | ALGRP | Pay scale grouping for allowances | nvarchar | 4 | 0 | | |
| TOPIreland |
| 29 | T7IEPS_ALL | ALL Constants & Texts (as required) | 3 | ALGRP | ALL Table Group | nvarchar | 4 | 0 | | |
| 30 | T7IEPS_ALLT | ALL Text Table | 4 | ALGRP | ALL Table Group | nvarchar | 4 | 0 | | |
