| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ACMTST_DB_EMPL | ACMTST: Employee (DB-Table) | 7 | GENDER | ACMTST: Gender/Sex | nvarchar | 1 | 0 | | |
2 | EHHSSD_HSP_TCRIT | Protocol - Triggering Criteria | 11 | GENDER | Gender of Party | nvarchar | 1 | 0 | | |
3 | PA0616 | HR Master Record: Infotype 0616 | 29 | GENDER | HESA: Gender code | nvarchar | 1 | 0 | | |
4 | PAPBSGB_HESA_P | HESA: Archive table for NISR Person table | 11 | GENDER | HESA: Gender code | nvarchar | 1 | 0 | | |
5 | PAPBSGB_TPS_ARCH | TPS Archive table for TPS Annual return records of type 1 | 10 | GENDER | Gender Key | nvarchar | 1 | 0 | | |
6 | T7BREFD_EEOINF | Other information of employee | 6 | GENDER | Gender | nvarchar | 1 | 0 | | |
7 | T7UNPF_HR_CHILD | Child details | 9 | GENDER | Gender | nvarchar | 6 | 0 | | |
8 | T7UNPF_HR_DEPND | Dependent details | 9 | GENDER | Gender | nvarchar | 6 | 0 | | |
9 | T7UNPF_HR_STAFF | Staff Member Table | 12 | GENDER | Gender | nvarchar | 6 | 0 | | |
10 | ZPROMOTION | Retail Promotion DPR table | 8 | GENDER | | nvarchar | 5 | 0 | | |
TOPOccupational Health |
11 | T7EHS00_PROT | Health Surveillance Protocols | 40 | GENDER | Gender Key | nvarchar | 1 | 0 | | |
12 | T7EHS00_PROTAGNT | Agents for Protocol | 20 | GENDER | Gender Key | nvarchar | 1 | 0 | | |
13 | T7EHS00_PROTFREQ | Frequency of Protocol | 21 | GENDER | Gender Key | nvarchar | 1 | 0 | | |
TOPPatient Accounting |
14 | NEHC_PAT | IS-H: Health Insurance Card (Patient Data) | 7 | GENDER | IS-H: Sex Indicator - Internal | nvarchar | 1 | 0 | | |
TOPPayroll |
15 | T5TREGTRANS | HRCZ - table for transfer items of Insured Register to SAP | 26 | GENDER | Gender | nvarchar | 1 | 0 | | |
TOPTerminologyGlossary |
16 | STERM_LINK | Link Between Concept and Associated Terms | 14 | GENDER | Grammatical Gender of Terminology Entry | nvarchar | 1 | 0 | | |
17 | STERM_Q_CHECK | Table for Terminology Check | 27 | GENDER | Grammatical Gender of Terminology Entry | nvarchar | 1 | 0 | | |