|
LEASE_NUMBER
| VARCHAR2 | 21 | The number assigned to a lease by the regulatory agency having jurisdiction over mineral activity in the territory where the lease is located. |
|
MMS_COMPANY_NUM
| VARCHAR2 | 15 | The number assigned by the Minerals Management Service to a business entity, individual, or agency with whom MMS does business or exchanges information. |
|
BUS_ASC_NAME
| VARCHAR2 | 300 | The name of a **business associate**. |
|
ASGN_STATUS_CODE
| VARCHAR2 | 3 | Indicates the stage in the approval process of a lease assignment. |
|
OWNER_ALIQUOT_CD
| VARCHAR2 | 3 | Indicates different percentage ownerships within a lease as a result of a partial assignment. |
|
SN_LSE_OWNER
| NUMBER | 22 | Autogenerated sequence number which uniquely identifies each instance of a lease owner. |
|
ASSGN_APRV_DATE
| DATE | 7 | The date an assignment of interest is approved by the Minerals Management Service (MMS), and the date the official MMS records are changed. |
|
MMS_STRT_DATE
| DATE | 7 | The date that a business entity began doing business with the Minerals Management Service. |
|
ASSGN_TERM_DATE
| DATE | 7 | The date that a lease assignment is terminated by the Minerals Management Service. |
|
OWNER_GROUP_CODE
| VARCHAR2 | 3 | Indicates different percentage ownerships within a lease as a result of a partial assignment. |
|
ASSIGNMENT_PCT
| NUMBER | 22 | The lessee's financial interest in a lease. |
|
ASSGN_EFF_DATE
| DATE | 7 | The date requested as an effective date by the parties to the assignment. |
