| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2BG_BG_OSI | OSI properties Bulgaria | 8 | CTTYP | Contract type | nvarchar | 1 | 0 | | |
2 | P2KZ_KZGRP | Groupings and statuses of PERNR | 11 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
3 | P2RB_ST | Tax payroll Belgium | 16 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
4 | P2RB_SV | Social Insurance payroll Belgium | 31 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
5 | P2RB_SVEVL | Payroll Results: DMFA Social Insurance table for Evaluation | 17 | CTTYP | Contract Type (00050) | nvarchar | 1 | 0 | | |
6 | P2RF_FMD | Payroll results: Master data | 7 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
7 | P2RF_SV | Payroll Result: Social Insurance (F) | 35 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
8 | P2RM_MFA | HR-DK: Payroll Results for FA Statistics | 8 | CTTYP | Work Contract for FA statistics | nvarchar | 1 | 0 | | |
9 | P2RP_SS | HR-PT: Payroll Results: Social Security | 14 | CTTYP | Contract type | nvarchar | 1 | 0 | | |
10 | P2UA_UAGRP | Groupings and statuses of PERNR | 12 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
11 | P2UR_RUSTA | Russian Statuses | 9 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
12 | T5FDSNCT | Temp table for PAYFR_RESULT-CT | 19 | CTTYP | Type de contrat | nvarchar | 2 | 0 | | |
13 | T5T47N | Labour law relationship types | 2 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
14 | T5UPBSTC02 | Certificate: Certificate Type | 2 | CTTYP | Certificate Type | nvarchar | 4 | 0 | | |
15 | T5UPBSTC02T | Certificate: Certificate Type Text Table | 3 | CTTYP | Certificate Type | nvarchar | 4 | 0 | | |
16 | T5UPBSTC11 | Certificate: Category | 6 | CTTYP | Certificate Type | nvarchar | 4 | 0 | | |
17 | T7QA47R | Contract Rule Setup | 4 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
18 | T7UNPAD_TEID | Termination Indemnity Number Translation | 4 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
TOPArgentina |
19 | T7AR30 | Types of work contract in Argentina | 2 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
TOPBelgium |
20 | T5BS3 | Employee information except reductions ( level 3 ) | 50 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
21 | T5BVB | Contract Type Belgium | 2 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
TOPDenmark |
22 | PA0204 | HR Master Record, Infotype 0204 (DA/DS Statistics DK) | 89 | CTTYP | Work Contract for FA statistics | nvarchar | 1 | 0 | | |
TOPFrance |
23 | HRP1685 | BD table for infotype 1685 | 22 | CTTYP | Contrat Type | nvarchar | 2 | 0 | | |
TOPItaly |
24 | T5ITEL | Relation type 770 | 2 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
25 | T5ITNG | 01/M data table - section B | 5 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
TOPNon Profit Organizations |
26 | T7UNPAD_RULES_CT | NPO: Rules Series Relationship to CTTYP | 3 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
TOPPayroll |
27 | PA0771 | Personel ana verileri: Bilgi tipi 0771 | 24 | CTTYP | Sözlesme türü | nvarchar | 2 | 0 | | |
28 | PA0935 | HR Master Record: Infotype 0935 | 24 | CTTYP | Contract type | nvarchar | 1 | 0 | | |
29 | PA0938 | HR Master Record: Infotype 0938 | 91 | CTTYP | Contract type | nvarchar | 1 | 0 | | |
30 | PA3261 | Commission contracts H | 25 | CTTYP | Contract type | nvarchar | 2 | 0 | | |
31 | PB0771 | Personel ana verileri: Bilgi tipi 0771 | 24 | CTTYP | Sözlesme türü | nvarchar | 2 | 0 | | |
32 | PB0935 | Applicant data infotype 0935 (model) | 24 | CTTYP | Contract type | nvarchar | 1 | 0 | | |
33 | PB0938 | Applicant data infotype 0938 (model) | 91 | CTTYP | Contract type | nvarchar | 1 | 0 | | |
34 | T5HPBS_LGART_PAR | Comm. - parameter table for specifying techn. wage type | 3 | CTTYP | Contract type | nvarchar | 2 | 0 | | |
35 | T5HPBS_SZERZ_TIP | Comm. - contract type | 2 | CTTYP | Contract type | nvarchar | 2 | 0 | | |
36 | T5HPBS_SZERZ_TIT | Comm. - contract type text table | 3 | CTTYP | Contract type | nvarchar | 2 | 0 | | |
37 | T5T47 | Contract types - extension of T547V | 2 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
38 | T7BG1B | Definition of Insurance Calc/NoCalc for InsTyp & Contr.Types | 2 | CTTYP | Contract type | nvarchar | 1 | 0 | | |
39 | T7BGC1 | Contract types | 1 | CTTYP | Contract type | nvarchar | 1 | 0 | | |
40 | T7BGC1T | Contract types - text | 2 | CTTYP | Contract type | nvarchar | 1 | 0 | | |
41 | T7BGC7 | Normative costs - obsolete (from 8/2011) | 1 | CTTYP | Contract type | nvarchar | 1 | 0 | | |
42 | T7BGC7N | Normative costs | 2 | CTTYP | Contract type | nvarchar | 1 | 0 | | |
43 | T7RO47V | Contract Types - Addition information | 2 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
44 | T7TRS09 | Istihdam durumunun Yasal Olanlar ile eslestirilmesi | 2 | CTTYP | Sözlesme türü | nvarchar | 2 | 0 | | |
TOPPersonnel Administration |
45 | PA0016 | HR Master Record: Infotype 0016 (Contract Elements) | 39 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
46 | T547S | Contract Type Texts | 3 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
47 | T547V | Contract Types | 2 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
48 | T7SI42A | Conversion of contract types to M1 values | 3 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
49 | T7SK47V | Contract type | 2 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
TOPPortugal |
50 | PA0332 | HR Master Record: Infotype 0332 (Social Security - PT) | 29 | CTTYP | Contract type | nvarchar | 1 | 0 | | |
51 | T5P2Y | HR-PT: Contract Types | 2 | CTTYP | Contract type | nvarchar | 1 | 0 | | |
52 | T5PCE | HR-PT: Contract Elements | 2 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |
TOPRecruitment |
53 | PB0016 | Applicant Master Record Infotype 0016 (Contract Elements) | 39 | CTTYP | Contract Type | nvarchar | 2 | 0 | | |