| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2IS_INS | Payroll Indonesia JAMSOSTEK & Other Insurance Data | 8 | INSTY | Indonesia Social Insurance Type | nvarchar | 4 | 0 | | |
TOPIndonesia |
2 | PA0319 | Indonesia Private Insurances | 24 | INSTY | Private Insurance Schemes | nvarchar | 4 | 0 | | |
3 | T7ID11 | Social Insurance Types - Indonesia | 2 | INSTY | Indonesia Social Insurance Type | nvarchar | 4 | 0 | | |
4 | T7ID12 | Social Insurance Types - Indonesia - Text | 3 | INSTY | Indonesia Social Insurance Type | nvarchar | 4 | 0 | | |
5 | T7ID13 | Insurance Scheme Levels and Contributions (Indonesia) | 2 | INSTY | Indonesia Social Insurance Type | nvarchar | 4 | 0 | | |
6 | T7ID14 | Text Table for Insurance Levels | 3 | INSTY | Indonesia Social Insurance Type | nvarchar | 4 | 0 | | |
TOPJapan |
7 | T5J33 | HR Insurance company type JPN | 2 | INSTY | Insurance Type | nvarchar | 2 | 0 | | |
8 | T5J34 | HR Insurance company type text JPN | 3 | INSTY | Insurance Type | nvarchar | 2 | 0 | | |
9 | T5J47 | HR Combination Insurance Type/Insurance Company JPN | 2 | INSTY | Insurance Type | nvarchar | 2 | 0 | | |
10 | T5J58 | HR Combination Insurance Company Type/Product JPN | 2 | INSTY | Insurance Type | nvarchar | 2 | 0 | | |
TOPPayroll |
11 | T7BG10 | Insurance Bank transfer | 2 | INSTY | Insurance Type | nvarchar | 4 | 0 | | |
12 | T7BG11 | Insurance Type of payment | 2 | INSTY | Insurance Type | nvarchar | 4 | 0 | | |
13 | T7BG1A | Insurance calculation | 1 | INSTY | Insurance Type | nvarchar | 4 | 0 | | |
14 | T7BG1B | Definition of Insurance Calc/NoCalc for InsTyp & Contr.Types | 1 | INSTY | Insurance Type | nvarchar | 4 | 0 | | |
15 | T7BG1E | Insurance calculation - rates | 2 | INSTY | Insurance Type | nvarchar | 4 | 0 | | |
16 | T7RO10 | Insurance institutions | 2 | INSTY | Insurance type | nvarchar | 1 | 0 | | |
17 | T7RO1A | Insurance calculation | 2 | INSTY | Insurance type | nvarchar | 1 | 0 | | |
18 | T7ROER | HR Cluster 2 - ER Insurances | 9 | INSTY | Insurance type | nvarchar | 1 | 0 | | |
TOPPersonnel Administration |
19 | T5JIC | HR Insurance company key master JP | 2 | INSTY | Insurance company type | nvarchar | 2 | 0 | | |
20 | T5JTI | HR Insurance company type JP | 2 | INSTY | Insurance company type | nvarchar | 2 | 0 | | |
TOPPersonnel Management |
21 | T7HR10 | Insurance institutions | 2 | INSTY | Insurance type | nvarchar | 4 | 0 | | |
22 | T7HR1A | Insurance calculation | 1 | INSTY | Insurance type | nvarchar | 4 | 0 | | |
23 | T7HR1B | SI insurance - rates | 2 | INSTY | Insurance type | nvarchar | 4 | 0 | | |
24 | T7HR1C | SI insurance - rates for companies | 3 | INSTY | Insurance type | nvarchar | 4 | 0 | | |
25 | T7HRBK | (Obsolete) | 2 | INSTY | Insurance type | nvarchar | 4 | 0 | | |