| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BOBF/AU_DAC_UPD | Used by Unit Tests of FUGR /BOPF/CL_DAC_UPDATE | 3 | UNIQUE_ID | | nvarchar | 10 | 0 | | |
2 | OIUY6Y_WY_MASTER | Royalty 2.0 - WY - Master Data PPN | 11 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
3 | OIUY6_WY_ASU_DT | Royalty 2.0 - WY - Auto Suspend Detail | 10 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
4 | OIUY6_WY_INTSTG | Royalty 2.0 - WY - Royalty Transaction Interface (Staging) | 50 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
5 | OIUY6_WY_INTTXN | Royalty 2.0 - WY - Royalty Transaction Interface | 50 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
6 | OIUY6_WY_LEASE | Royalty 2.0 - WY - Lease Data | 3 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
7 | OIUY6_WY_MASTER | Royalty 2.0 - WY - Master Data | 11 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
8 | OIUY6_WY_OOSHST | Royalty 2.0 - WY - Out of Statute Royalty Transaction Hist | 47 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
9 | OIUY6_WY_OOSTXN | Royalty 2.0 - WY - Out of Statute Royalty Transactions | 47 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
10 | OIUY6_WY_PRDT | Royalty 2.0 - WY - Royalty PRA Details | 49 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
11 | OIUY6_WY_PRDTA | Royalty 2.0 - WY - Royalty PRA Details (Allocated) | 50 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
12 | OIUY6_WY_PRICE | Royalty 2.0 - WY - Report Pricing | 4 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
13 | OIUY6_WY_ROYHST | Royalty 2.0 - WY - Royalty Transaction History | 47 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
14 | OIUY6_WY_ROYHSTA | Royalty 2.0 - WY - Royalty Transaction History (Allocated) | 48 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
15 | OIUY6_WY_ROYSTG | Royalty 2.0 - WY - Royalty Transactions (Staging) | 47 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
16 | OIUY6_WY_ROYTXN | Royalty 2.0 - WY - Royalty Transactions | 47 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
17 | OIUY6_WY_ROYTXNA | Royalty 2.0 - WY - Royalty Transactions (Allocated) | 48 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
18 | OIUY6_WY_RPDTC | Royalty 2.0 - WY - Lease/Unit Report Detail - CA | 5 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
19 | OIUY6_WY_RPDTD | Royalty 2.0 - WY - Report Details | 6 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
20 | OIUY6_WY_RPDTM | Royalty 2.0 - WY - Lease/Unit Report Detail - Masters | 5 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
21 | OIUY6_WY_RPDTP | Royalty 2.0 - WY - Lease/Unit Report Detail - Production | 5 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
22 | OIUY6_WY_RPDTS | Royalty 2.0 - WY - Lease/Unit Report Detail - PR/CA Summar | 5 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
23 | OIUY6_WY_RPDTU | Royalty 2.0 - WY - Report Details Unit | 5 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
24 | OIUY6_WY_SOLEDT | Royalty 2.0 - WY Statute of Limitation Exception Detail | 4 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
25 | OIUY6_WY_ZVOL | Royalty 2.0 - WY - Zero Volume Master | 6 | UNIQUE_ID | Royalty 2.0 - Wyoming - PSA | nvarchar | 20 | 0 | | |
26 | T7UNPF_FI_OPRHD | Operation Header | 3 | UNIQUE_ID | Unique ID | nvarchar | 15 | 0 | | |
27 | T7UNPF_HR_CHILD | Child details | 4 | UNIQUE_ID | Unique ID | nvarchar | 15 | 0 | | |
28 | T7UNPF_HR_CNTRC | Contract details | 4 | UNIQUE_ID | Org Global Unique ID | nvarchar | 15 | 0 | | |
29 | T7UNPF_HR_DEPND | Dependent details | 4 | UNIQUE_ID | Unique ID | nvarchar | 15 | 0 | | |
30 | T7UNPF_HR_DS | Duty Station details | 4 | UNIQUE_ID | Org Global Unique ID | nvarchar | 15 | 0 | | |
31 | T7UNPF_HR_LANG | Language Allowance | 4 | UNIQUE_ID | Org Global Unique ID | nvarchar | 15 | 0 | | |
32 | T7UNPF_HR_LWOP | Leave Without Pay | 4 | UNIQUE_ID | Org Global Unique ID | nvarchar | 15 | 0 | | |
33 | T7UNPF_HR_OPRHD | Operation Header | 3 | UNIQUE_ID | Unique ID | nvarchar | 15 | 0 | | |
34 | T7UNPF_HR_PART | Parttime Details | 4 | UNIQUE_ID | Org Global Unique ID | nvarchar | 15 | 0 | | |
35 | T7UNPF_HR_SAL | Salary details | 4 | UNIQUE_ID | Org Global Unique ID | nvarchar | 15 | 0 | | |
36 | T7UNPF_HR_SECON | Staff Secondment details | 4 | UNIQUE_ID | Org Global Unique ID | nvarchar | 15 | 0 | | |
37 | T7UNPF_HR_SEP | Staff Member Separation details | 4 | UNIQUE_ID | Org Global Unique ID | nvarchar | 15 | 0 | | |
38 | T7UNPF_HR_STAFF | Staff Member Table | 4 | UNIQUE_ID | Org Global Unique ID | nvarchar | 15 | 0 | | |
TOPCentral Part of Product Master |
39 | COMC_ALTID_TYPE | Control Data for Alternative Product IDs | 14 | UNIQUE_ID | Indicator: Alternative ID Type is Unique | nvarchar | 1 | 0 | | |
TOPData Staging |
40 | RSICSDELSTAT | Statistics on Records in Requests After Selective Deletion | 8 | UNIQUE_ID | User field for cluster PC (national) | nvarchar | 25 | 0 | | |
41 | RSICSDELSTATCTRL | Control Table for RSICSDELSTAT for Selective Deletion | 12 | UNIQUE_ID | User field for cluster PC (national) | nvarchar | 25 | 0 | | |
TOPeCATT Extended Computer Aided Test Tool |
42 | ECWD_RESOURCES | eCATT: Database Table for WD Resources (HTML) | 1 | UNIQUE_ID | | nvarchar | 65 | 0 | | |
TOPOffice Suite Program |
43 | SOSP_T_BKT_PERFM | Book Keeping table for Performance | 2 | UNIQUE_ID | GUID | nvarchar | 32 | 0 | | |
44 | SOSP_T_MAP_INFO | Mapping Information | 2 | UNIQUE_ID | GUID | nvarchar | 32 | 0 | | |
45 | SOSP_T_STAT_ACTN | Status Transition - Action customization | 2 | UNIQUE_ID | GUID | nvarchar | 32 | 0 | | |
TOPSecurity |
46 | LAW_ERROR | Error Text Table for License Administration Workbench | 1 | UNIQUE_ID | Numeric Character Field, Length 10 | nvarchar | 10 | 0 | | |
47 | LAW_GROUPING | Temporary Table for Grouping Users | 20 | UNIQUE_ID | Numeric Character Field, Length 10 | nvarchar | 10 | 0 | | |
48 | LAW_RESULT | Result of License Measurement Consolidation | 1 | UNIQUE_ID | LAW: Unique Identification Within the LAW | nvarchar | 10 | 0 | | |
49 | LAW_UNIQUE | Grouped User Data | 20 | UNIQUE_ID | Numeric Character Field, Length 10 | nvarchar | 10 | 0 | | |
50 | LAW_UTYPES | Result of License Measurement Consolidation | 1 | UNIQUE_ID | Numeric Character Field, Length 10 | nvarchar | 10 | 0 | | |