| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DMC_COMPARE | Table for compare result for table | 4 | REPORT_TYPE | Compare data: Report Type | nvarchar | 20 | 0 | | |
2 | GRACPPDATA | Risk Analysis PPF Runtime Package Data. | 4 | REPORT_TYPE | Report Types For Parallel Processing. | nvarchar | 20 | 0 | | |
3 | GRACPPPARAM | Global Application Parameter for Risk Analysis PPF. | 5 | REPORT_TYPE | Report Types For Parallel Processing. | nvarchar | 20 | 0 | | |
4 | OIUY3_TX_RPGDT | Royalty 2.0 - TX GLO/TAMU - Gas Report | 14 | REPORT_TYPE | Royalty 2.0 - Texas GLO/TAMU - Report Type | nvarchar | 1 | 0 | | |
5 | OIUY3_TX_RPODT | Royalty 2.0 - TX GLO/TAMU - Oil Report | 14 | REPORT_TYPE | Royalty 2.0 - Texas GLO/TAMU - Report Type | nvarchar | 1 | 0 | | |
6 | T7CN_RPT_COLUMN | Table for report column maintenance | 1 | REPORT_TYPE | Report Type | nvarchar | 6 | 0 | | |
7 | T7CN_RPT_MGT | Table for report management | 2 | REPORT_TYPE | Report Type | nvarchar | 6 | 0 | | |
TOPBusiness Package for Manager Self-Service FI |
8 | FPB_LP6_ROLE_TYP | Application Types for Role | 2 | REPORT_TYPE | Application Category in Launchpad | nvarchar | 3 | 0 | | |
9 | FPB_LP6_R_TYP_C | Type of Report | 5 | REPORT_TYPE | Application Category in Launchpad | nvarchar | 3 | 0 | | |
TOPClaims Management |
10 | ICL_CREGREP_RPRT | Context and Trigger Details for Reports | 2 | REPORT_TYPE | Type of Regulatory Report | nvarchar | 10 | 0 | | |
11 | ICL_CRPTTYPE | Report Types for Regulatory Reporting | 2 | REPORT_TYPE | Type of Regulatory Report | nvarchar | 10 | 0 | | |
12 | ICL_CRPTTYPE_TXT | Text Table for Report Type | 3 | REPORT_TYPE | Type of Regulatory Report | nvarchar | 10 | 0 | | |
13 | ICL_REGREP_LOG | Regulatory Reporting Log | 6 | REPORT_TYPE | Type of Regulatory Report | nvarchar | 10 | 0 | | |
TOPGovernance, Risk and Compliance |
14 | GRFNREPHEADER | Report header | 2 | REPORT_TYPE | Report type | nvarchar | 1 | 0 | | |
TOPManagement of Internal Controls |
15 | FOPC_BTC_REPORTS | Background Reports in System | 11 | REPORT_TYPE | Report Type | nvarchar | 3 | 0 | | |
TOPOffice Suite Program |
16 | /OSP/T_REGIS | /OSP/ Time points registration table. | 7 | REPORT_TYPE | Report Type | nvarchar | 2 | 0 | | |
17 | /OSP/T_UNSENT | Store unsent details | 9 | REPORT_TYPE | Report Type | nvarchar | 2 | 0 | | |
TOPProcess Controls |
18 | GRPC_BTC_REPORTS | Background Reports in System | 11 | REPORT_TYPE | Report Type | nvarchar | 3 | 0 | | |
TOPProduction and Revenue Accounting |
19 | OIU_RV_VLRPT | Valuation Reporting | 3 | REPORT_TYPE | Report Type | nvarchar | 2 | 0 | | |
TOPRevenue |
20 | OIUE2_ESCH_RPDTH | Proc 2.0 - Escheat - Report Detail - Holder | 5 | REPORT_TYPE | Proc 2.0 - Escheat - ASCII - Report Type | nvarchar | 1 | 0 | | |
TOPRoyalty Reporting |
21 | OIUREP_LGL_RPTS | Legal Reports for Tax and Royalty Reporting | 3 | REPORT_TYPE | Report Type (Tax or Royalty) | nvarchar | 1 | 0 | | |
TOPRuntime WorkbenchMonitoring |
22 | SXMS_BCKGND_JOBS | List of monitoring reports with assigned background jobs | 2 | REPORT_TYPE | Report type regarding functionality: archive, reorg, etc. | nvarchar | 3 | 0 | | |
TOPValuation |
23 | OIUVL_PPN_REJSEL | PPN - Reject Selection | 3 | REPORT_TYPE | Report Type | nvarchar | 2 | 0 | | |