| Data element |
Definition |
EXTRACT_DATE
Indexed - yes
Format - date
May be null? no |
The date the record was extracted from BEN Assets, the Oracle Fixed Assets system, and loaded into the Data Warehouse. |
LAST_UPDATED_BY_USER
Indexed - no
Format - varchar2(100)
May be null? yes |
The BEN Financials login identification (ID) for the person or batch job that last updated the lease record. |
LAST_UPDATE_DATE
Indexed - no
Format - date
May be null? yes |
The date on which the lease record was last updated in BEN Assets. |
LEASE_DESC
Indexed - no
Format - varchar2(30)
May be null? yes |
The description of the lease. |
LEASE_ID
Indexed - yes
Format - number(15)
May be null? no |
The unique system identifier for a lease. |
LEASE_NUMBER
Indexed - yes
Format - varchar2(15)
May be null? yes |
The unique identifier for the lease. |
LEASE_TERM
Indexed - no
Format - number
May be null? yes |
The term of the lease. |
LEASE_TYPE
Indexed - no
Format - varchar2(1)
May be null? yes |
The type of lease. |
LESSOR_ID
Indexed - no
Format - number(15)
May be null? yes |
The unique identifier for the lessor. |
