| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T7UNPF_HR_MARM | Marital Status Mapping Table | 2 | STATUS_CD | Marital Status Key | nvarchar | 1 | 0 | | |
TOPOwnership |
2 | OIUOW_DTCH | DOI Transfer Change Header | 10 | STATUS_CD | Request status | nvarchar | 1 | 0 | | |
3 | OIUOW_ORP_TWB | ORP test workbench comparison history | 10 | STATUS_CD | Request status | nvarchar | 1 | 0 | | |
TOPProduction |
4 | OIUPR_SKFD_STS | Drilling Days SKF Major workover Status - TBLGR027 | 2 | STATUS_CD | Well completion status code | nvarchar | 2 | 0 | | |
5 | OIUPR_SKFW_ST | Well Count SKF Plug, Sold, Abandoned ST - TBLGR025 | 2 | STATUS_CD | Well completion status code | nvarchar | 2 | 0 | | |
TOPProduction and Revenue Accounting |
6 | OIU_PR_NPSTS | Non-Producing Well Status - TBLPR082 | 2 | STATUS_CD | Well completion status code | nvarchar | 2 | 0 | | |
7 | OIU_PR_WCVD | Well Completion Variable Data | 16 | STATUS_CD | Well completion status code | nvarchar | 2 | 0 | | |
8 | OIU_PR_WC_STS | Well completion status | 2 | STATUS_CD | Well completion status code | nvarchar | 2 | 0 | | |
9 | OIU_PR_WC_STS_TX | Well completion status | 3 | STATUS_CD | Well completion status code | nvarchar | 2 | 0 | | |
10 | OIU_PR_WSWCX | Well Class/Well Status Xref - Tblpr056 | 2 | STATUS_CD | Well completion status code | nvarchar | 2 | 0 | | |
11 | OIU_RV_VLRPT | Valuation Reporting | 22 | STATUS_CD | VL Status code | nvarchar | 2 | 0 | | |
TOPRemote Logistics Management |
12 | OIO_MX_OBJECT | RLM tracking extract object data | 10 | STATUS_CD | Status of document flow object | nvarchar | 2 | 0 | | |
13 | OIO_RT_RTDOC | RLM returns document - header | 9 | STATUS_CD | Status of returns document | nvarchar | 2 | 0 | | |
14 | OIO_RT_STATUS | Returns status | 2 | STATUS_CD | Status of returns document | nvarchar | 2 | 0 | | |
15 | OIO_RT_STATUS_TX | Returns status descriptions | 3 | STATUS_CD | Status of returns document | nvarchar | 2 | 0 | | |
16 | OIO_RT_STPIT | Recommended action step | 4 | STATUS_CD | Status of returns document | nvarchar | 2 | 0 | | |
TOPValuation |
17 | OIUVL_CUR_SEL | Valuation currect selection | 3 | STATUS_CD | VL Status code | nvarchar | 2 | 0 | | |
18 | OIUVL_PPN_REJSEL | PPN - Reject Selection | 6 | STATUS_CD | VL Status code | nvarchar | 2 | 0 | | |