| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /FLDQ/AD_INI_ERR | Record records which encounter an error in RSADRINI | 16 | DEPARTMENT | Department | nvarchar | 40 | 0 | | |
2 | /FLDQ/AD_INI_IDX | Copy of Shadow Table /fldq/ad_mtc_sh | 16 | DEPARTMENT | Department | nvarchar | 40 | 0 | | |
3 | /FLDQ/AD_MTCCODE | FirstLogic Match Code Index Table | 16 | DEPARTMENT | Department | nvarchar | 40 | 0 | | |
4 | /FLDQ/AD_MTCRSLT | Match Results table to store results from RSADRINI program | 17 | DEPARTMENT | Department | nvarchar | 40 | 0 | | |
5 | /FLDQ/AD_MTC_SH | FirstLogic Shadow table for /FLDQ/AD_MTCCODE | 16 | DEPARTMENT | Department | nvarchar | 40 | 0 | | |
6 | /FLDQ/AD_MTC_SH2 | FirstLogic Shadow table for /FLDQ/AD_MTCCODE | 16 | DEPARTMENT | Department | nvarchar | 40 | 0 | | |
7 | /FLDQ/AD_PUPDATE | Matchcode Records pending to be updated | 16 | DEPARTMENT | Department | nvarchar | 40 | 0 | | |
8 | /FLDQ/HNA_BM_IN | HANA task Batch Match Input Records | 9 | DEPARTMENT | Department | nvarchar | 40 | 0 | | |
9 | /OPT/WT_3S_MAP | Supplier Self Service - User Mapping | 6 | DEPARTMENT | Supplier Self Service - Invoice Criteria | nvarchar | 20 | 0 | | |
10 | /ORS/RECENTUSER | Most Recently Selected Users | 9 | DEPARTMENT | Department | nvarchar | 50 | 0 | | |
11 | /ORS/USERMAP | Optura User Mapping Object | 9 | DEPARTMENT | Department | nvarchar | 50 | 0 | | |
12 | /XLSO/ROLE_ASSGN | For assigning partner function after effective date | 6 | DEPARTMENT | Department number | nvarchar | 4 | 0 | | |
13 | /XLSO/USER_COMP | XLSO Table to store the assignment of Company and User | 4 | DEPARTMENT | Department number | nvarchar | 4 | 0 | | |
14 | BBP_TMP_ZA_ASP | Temporary: Request 'Bidder', Contact Addresses | 67 | DEPARTMENT | Department | nvarchar | 4 | 0 | | |
15 | GRACREQUSERADR | User Communication Fields | 5 | DEPARTMENT | Department | nvarchar | 100 | 0 | | |
16 | GRACUSER | User Table | 8 | DEPARTMENT | Department | nvarchar | 100 | 0 | | |
17 | REQADDRESS | Delivery Address for Requirement Coverage Request Lines | 34 | DEPARTMENT | Department | nvarchar | 40 | 0 | | |
18 | T7BREFD_ININFO | Trainee exclusive information | 7 | DEPARTMENT | Action area of the trainee | nvarchar | 50 | 0 | | |
19 | ZSE_RSUSR100 | ZZRSUSR100 | 16 | DEPARTMENT | Department | nvarchar | 40 | 0 | | |
20 | ZSKSYSUSER | user in den IDES-Systemen | 6 | DEPARTMENT | | nvarchar | 30 | 0 | | |
21 | ZZRSUSR100 | ZZRSUSR100 | 14 | DEPARTMENT | Department | nvarchar | 40 | 0 | | |
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector |
22 | CRMAHR | Data on Persons | 7 | DEPARTMENT | Department | nvarchar | 40 | 0 | | |
TOPAddress ManagementBusiness Address |
23 | ADCP | Person/Address Assignment (Business Address Services) | 9 | DEPARTMENT | Department | nvarchar | 40 | 0 | | |
24 | ADCPS | Shadow Table: Assignment Person/Addr. (Bus. Addr. Services) | 10 | DEPARTMENT | Department | nvarchar | 40 | 0 | | |
TOPBasic Functions |
25 | LECI_EVENT_DATA | Activity Data Within the Check-in/Check-out Process | 26 | DEPARTMENT | Department | nvarchar | 40 | 0 | | |
TOPClaims Management |
26 | ICLDIAGNOSIS | Diagnoses Made | 26 | DEPARTMENT | Department (Key) | nvarchar | 4 | 0 | | |
27 | ICLPROCEDURES | Procedures | 16 | DEPARTMENT | Department (Key) | nvarchar | 4 | 0 | | |
28 | ICSDIAGNOSIS | Diagnoses | 26 | DEPARTMENT | Department (Key) | nvarchar | 4 | 0 | | |
29 | ICSPROCEDURES | Procedures | 16 | DEPARTMENT | Department (Key) | nvarchar | 4 | 0 | | |
30 | TICL364 | Departments | 2 | DEPARTMENT | Department (Key) | nvarchar | 4 | 0 | | |
31 | TICL364T | Texts for Departments | 3 | DEPARTMENT | Department (Key) | nvarchar | 4 | 0 | | |
TOPCommunication Services Mail, Fax, SMS, Telephony |
32 | BCST_PPFMD | Persistence of BCS Medium for PPF | 13 | DEPARTMENT | Spool Department Name | nvarchar | 12 | 0 | | |
33 | BCST_RESPO | BCS: Persistence of a Spool/Print Recipient | 3 | DEPARTMENT | Spool Department Name | nvarchar | 12 | 0 | | |
TOPCross-Application Components |
34 | SDEPMENT | Departments: Starting Situation | 3 | DEPARTMENT | Department code | nvarchar | 4 | 0 | | |
35 | SDEPMENTT | Texts for the Departments: Starting Situation | 3 | DEPARTMENT | Department code | nvarchar | 4 | 0 | | |
36 | SDEPMENT_CH | Departments: Enhance with Dept. Head and Time in Incl. (2) | 3 | DEPARTMENT | Department code | nvarchar | 4 | 0 | | |
37 | SDEPMENT_CSH | Departments: Collective Search Help | 3 | DEPARTMENT | Department code | nvarchar | 4 | 0 | | |
38 | SDEPMENT_SEARCH | Departments: Search Help | 3 | DEPARTMENT | Department code | nvarchar | 4 | 0 | | |
39 | SEMPLOYES | Employee Table: Starting Version | 6 | DEPARTMENT | Department code | nvarchar | 4 | 0 | | |
40 | SEMPLOYES_APP | Employees: Enhancement by Append (4) | 6 | DEPARTMENT | Department code | nvarchar | 4 | 0 | | |
41 | SEMPLOYES_RB | Employees: Enhancement by No. of Agency (2) | 6 | DEPARTMENT | Department code | nvarchar | 4 | 0 | | |
42 | SEMPLOYES_TI | Employees: Enhancement by Time Field in Include (3) | 6 | DEPARTMENT | Department code | nvarchar | 4 | 0 | | |
43 | SEMPLOY_CSH | Employee table: Collective Search Help | 6 | DEPARTMENT | Department code | nvarchar | 4 | 0 | | |
44 | SEMPLOY_SEARCH | Employee Table: Search Help Attachment to Table | 6 | DEPARTMENT | Department code | nvarchar | 4 | 0 | | |
TOPGeneral Application Functions |
45 | TFAX1 | Fax information extendable sample | 4 | DEPARTMENT | Text | nvarchar | 50 | 0 | | |
TOPPost Processing Framework |
46 | PPFTBCSTE | Transmission Medium Database Table (Template) | 16 | DEPARTMENT | Spool Department Name | nvarchar | 12 | 0 | | |
47 | PPFTSFPRRU | PPF: Medium Smart Forms Print (Runtime) | 4 | DEPARTMENT | Spool Department Name | nvarchar | 12 | 0 | | |
48 | PPFTSFPRT2 | PPF: Medium Smart Forms Print (Template) | 4 | DEPARTMENT | Spool Department Name | nvarchar | 12 | 0 | | |
49 | PPFTSFPRTE | PPF: Medium Smart Forms Print (Template) | 4 | DEPARTMENT | Spool Department Name | nvarchar | 12 | 0 | | |
TOPSAP Business Workflow |
50 | SWH_ABSENCE | Workflow: Demo for Workflow Infos | 6 | DEPARTMENT | Department | nvarchar | 40 | 0 | | |
51 | SWXFORMABS | Form: Notification of Absence | 9 | DEPARTMENT | Department | nvarchar | 40 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
52 | NLDBC_014 | ISH NL: DBC Ablauf steurung | 27 | DEPARTMENT | IS-H: Org. eenheid die spec. aan een ZGV wordt toegewezen | nvarchar | 8 | 0 | | |
TOPUser and Authorization Management |
53 | USARC_CD | Not Required: Archived User Data -> Change Documents | 15 | DEPARTMENT | Department | nvarchar | 40 | 0 | | |