| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPRoyalty Reporting |
| 1 | OIUREPP_LEASE | MMS-2014 - Lease PPA | 4 | FED_INDIAN_CD | Production: MMS-2014 - Federal or Indian Code | nvarchar | 1 | 0 | | |
| 2 | OIUREP_FEDINDIAN | MMS-2014 - Federal or Indian Leases | 3 | FED_INDIAN_CD | MMS-2014: Federal, Indian, or Both - Lease Types | nvarchar | 1 | 0 | | |
| 3 | OIUREP_LEASE | MMS-2014 - Lease | 4 | FED_INDIAN_CD | Production: MMS-2014 - Federal or Indian Code | nvarchar | 1 | 0 | | |
| 4 | OIUREP_MMS_REJS | MMS-2014 - Extraction Rejects | 8 | FED_INDIAN_CD | Production: MMS-2014 - Federal or Indian Code | nvarchar | 1 | 0 | | |
| 5 | OIUREP_MRT_HIST | MMS-2014 MMS Royalty Transaction Processed History | 8 | FED_INDIAN_CD | Production: MMS-2014 - Federal or Indian Code | nvarchar | 1 | 0 | | |
| 6 | OIUREP_MRT_PEND | MMS-2014 MMS Royalty Transaction Processed - Pending | 8 | FED_INDIAN_CD | Production: MMS-2014 - Federal or Indian Code | nvarchar | 1 | 0 | | |
| 7 | OIUREP_RTPEND | MMS-2014 - Royalty Transaction Pending | 7 | FED_INDIAN_CD | Production: MMS-2014 - Federal or Indian Code | nvarchar | 1 | 0 | | |
| 8 | OIUREP_RT_HIST | MMS-2014 - Royalty Transaction (Pending) History | 7 | FED_INDIAN_CD | Production: MMS-2014 - Federal or Indian Code | nvarchar | 1 | 0 | | |
