| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RF_CCRT | Payroll Results: Cumulation of Contributions, Wage Types | 8 | ORGAN | SI contribution funds | nvarchar | 4 | 0 | | |
2 | P2RF_FPWP | PC2LF | 20 | ORGAN | | nvarchar | 4 | 0 | | |
3 | P2RF_RECOT | Payroll Results: Cumulation of Contributions | 9 | ORGAN | SI contribution funds | nvarchar | 4 | 0 | | |
4 | P2RT_BH | Structure table for challenge | 14 | ORGAN | Pension payment authority | nvarchar | 2 | 0 | | |
5 | P2SK_BH | PSK07 | 14 | ORGAN | Pension payment authority | nvarchar | 2 | 0 | | |
6 | PA0429 | HR Master Record, Infotype 0429 | 27 | ORGAN | | nvarchar | 4 | 0 | | |
7 | PA3307 | HR Master Record: Infotype 3307 | 25 | ORGAN | Injured Organ | nvarchar | 30 | 0 | | |
8 | PB3307 | Applicant data infotype 3307 (model) | 25 | ORGAN | Injured Organ | nvarchar | 30 | 0 | | |
9 | T5FDSNCOTIS | DSN: contributions parameter setting | 12 | ORGAN | SI contribution funds | nvarchar | 4 | 0 | | |
10 | T5FDSNCOTIS2 | DSN: contributions parameter setting | 16 | ORGAN | SI contribution funds | nvarchar | 4 | 0 | | |
11 | T5FPBS0ST | Texte organismes externes. | 3 | ORGAN | Code identifiant d'un organisme | nvarchar | 4 | 0 | | |
TOPClinical System |
12 | N1ORGAN | IS-H*MED: Table for the Codes for Organs | 3 | ORGAN | Description of an Organ | nvarchar | 6 | 0 | | |
13 | N1ORGANT | IS-H*MED: Text for the Organ Table | 4 | ORGAN | Description of an Organ | nvarchar | 6 | 0 | | |
14 | N1TPM | IS-H*MED: Medical Enhancements for the Service Catalog Items | 23 | ORGAN | Description of an Organ | nvarchar | 6 | 0 | | |
TOPFrance |
15 | T5F1A | SI organizations (France) | 2 | ORGAN | SI contribution funds | nvarchar | 4 | 0 | | |
16 | T5F1AC | Control of payment offsetting to calculate contributions | 3 | ORGAN | SI contribution funds | nvarchar | 4 | 0 | | |
17 | T5F1C | SI contributions:rates and wage types | 2 | ORGAN | SI contribution funds | nvarchar | 4 | 0 | | |
18 | T5F1E | SI Organizations - addresses | 2 | ORGAN | SI contribution funds | nvarchar | 4 | 0 | | |
19 | T5F1F | Assignment to social insurance fund model (France) | 4 | ORGAN | SI contribution funds | nvarchar | 4 | 0 | | |
20 | T5F1L | Deletion of bases for the contributions of organizations | 3 | ORGAN | SI contribution funds | nvarchar | 4 | 0 | | |
21 | T5F1M | Assignment to social insurance fund model (France) | 6 | ORGAN | SI contribution funds | nvarchar | 4 | 0 | | |
22 | T5F3C | Contributions and Profit Sharing Agencies | 4 | ORGAN | SI contribution funds | nvarchar | 4 | 0 | | |
23 | T5F4OC | Contributions by Social Protection Agency (OPS) | 6 | ORGAN | SI contribution funds | nvarchar | 4 | 0 | | |
24 | T5F4V | Do not use: replaced by T5F4W | 7 | ORGAN | SI contribution funds | nvarchar | 4 | 0 | | |
25 | T5F4W | Contributions linked to personnel type | 7 | ORGAN | SI contribution funds | nvarchar | 4 | 0 | | |
TOPPatient Management |
26 | NRSF | IS-H: Patient Risk Factors | 17 | ORGAN | IS-H: Drug Allergy - Organ Affected | nvarchar | 6 | 0 | | |
27 | TN17F | IS-H: Drug Allergies - Organs Affected | 2 | ORGAN | IS-H: Drug Allergy - Organ Affected | nvarchar | 6 | 0 | | |
28 | TN17O | IS-H: Drug allergy: text for organ affected | 3 | ORGAN | IS-H: Drug Allergy - Organ Affected | nvarchar | 6 | 0 | | |
TOPPayroll |
29 | T5T62 | HR master record Infotype 0620 | 27 | ORGAN | Pension payment authority | nvarchar | 2 | 0 | | |
TOPPersonnel Administration |
30 | PA0620 | HR master record Infotype 0620 | 27 | ORGAN | Pension payment authority | nvarchar | 2 | 0 | | |
31 | PA0621 | Personál.kmen.záznam Infotyp 0621 | 27 | ORGAN | Orgán vyplácajúci dôchodok | nvarchar | 2 | 0 | | |