| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OTTM/BL_T_PARAM | Parameter table for travel expenses management | 2 | PGROUP | Parameter group | nvarchar | 5 | 0 | | |
2 | T7EHS00_PROTEHSM | Proposed Health Surveillance Protocols from EHSM | 3 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
3 | TN1MCI_PROC | Communication Processes | 3 | PGROUP | Process Group | nvarchar | 30 | 0 | | |
TOPeCATT Extended Computer Aided Test Tool |
4 | ECSCR_PAR | Definition of eCATT Script Parameters and Variables | 6 | PGROUP | Group for Parameters and Command Interfaces | nvarchar | 30 | 0 | | |
5 | ECSP_PAR | Definition of eCATT Test Run Parameters and Variables | 6 | PGROUP | Group for Parameters and Command Interfaces | nvarchar | 30 | 0 | | |
6 | ECTD_PAR | Definition of Test Data Container Parameters | 6 | PGROUP | Group for Parameters and Command Interfaces | nvarchar | 30 | 0 | | |
TOPOccupational Health |
7 | T7EHS00_COMMENPR | Comments at Start/End of a Protocol Assignment | 3 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
8 | T7EHS00_COMMENSC | Comments on Assignment of a Protocol to the Person | 3 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
9 | T7EHS00_PERPROSC | Assign Persons -> Protocols | 3 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
10 | T7EHS00_PERPRSCD | Enter Validity of Protocol with Respect to Person | 3 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
11 | T7EHS00_PGROUP | Protocol Categories | 2 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
12 | T7EHS00_PGROUPT | Text Table for Protocol Categories | 3 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
13 | T7EHS00_PREGANA | Table for Comment Field: Protocol_Regulation-analysis_text | 2 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
14 | T7EHS00_PREGDES | Table for Comment Field: Protocol_Regulation-description | 2 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
15 | T7EHS00_PREGFOL | Table for Comment Field: Protocol_Regulation-follow_up | 2 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
16 | T7EHS00_PREGPRO | Table for Comment Field: Protocol_Regulation-procedure_text | 2 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
17 | T7EHS00_PROT | Health Surveillance Protocols | 2 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
18 | T7EHS00_PROTAGNT | Agents for Protocol | 2 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
19 | T7EHS00_PROTEXAM | Examinations for Protocol | 2 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
20 | T7EHS00_PROTFREQ | Frequency of Protocol | 2 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
21 | T7EHS00_PROTJOB | Task Assignment Health Surv. Protocol | 2 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
22 | T7EHS00_PROTMEM | Table for Comment Field: Protocol Description | 2 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
23 | T7EHS00_PROTREG | Regulations for Protocol | 2 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
24 | T7EHS00_PROTT | Protocol Text Table | 2 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
25 | T7EHS00_PRO_TXT | Comment Lines for Protocols in Medical Service | 3 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
26 | T7EHS00_SRV_EXA | Individual Examinations in a Medical Service | 18 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
27 | T7EHS00_SRV_PROT | Health Surv. Protocols for a Med. Service | 3 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
28 | T7EHS00_VACCH | EHS: Vaccination Data Header Information | 20 | PGROUP | Health Surveillance Protocol Category | nvarchar | 3 | 0 | | |
TOPSouth Africa |
29 | T5W4A | Leave parameter table - Southern Africa | 4 | PGROUP | Employee Group | nvarchar | 1 | 0 | | |
30 | T5W4B | Leave entitlement (IT0005) parameter table - Southern Africa | 4 | PGROUP | Employee Group | nvarchar | 1 | 0 | | |