[Home] [Help]
[Dependency Information]
Object Name: | MTH_ENTITY_SUSTAIN_ASPECT_HOUR |
---|---|
Object Type: | TABLE |
Owner: | MTH |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
MTH_ENTITY_SUSTAIN_ASPECT_HOUR aggregates data from MTH_ENTITY_SUSTAIN_ASPECT by hour.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTH_ENTITY_SUSTAIN_ASPECT_H_U1 | NORMAL | UNIQUE |
![]() |
![]() |
MTH_ENTITY_SUSTAIN_ASPECT_H_U2 | NORMAL | UNIQUE |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ESA_HR_PK_KEY | NUMBER | Yes | System generated surrogate key for entity sustainability aspect hourly identifier | |
ENTITY_FK_KEY | NUMBER | Yes | Reference to entity | |
ENTITY_TYPE | VARCHAR2 | (30) | Yes | Entity type code |
SUSTAIN_ASPECT_FK_KEY | VARCHAR2 | (240) | Yes | Reference to suntainability aspect |
SUSTAIN_ASPECT | VARCHAR2 | (30) | Yes | Suntainability aspect code |
USAGE_CATEGORY | VARCHAR2 | (30) | Yes | Energy usage category code |
METER_FK_KEY | NUMBER | Yes | Reference to meter | |
METER_CATEGORY | VARCHAR2 | (30) | Yes | Meter category |
SHIFT_WORKDAY_FK_KEY | NUMBER | Yes | Reference to workday shift | |
HOUR_FK_KEY | NUMBER | Yes | Reference to hour | |
FROM_TIME | DATE | Yes | From time | |
TO_TIME | DATE | Yes | To time | |
ENTITY_NAME | VARCHAR2 | (100) | Entity name | |
ENTITY_TYPE_NAME | VARCHAR2 | (80) | Entity type name | |
SUSTAIN_ASPECT_NAME | VARCHAR2 | (80) | Suntainability aspect name | |
USAGE_CATEGORY_NAME | VARCHAR2 | (80) | Energy usage category name | |
METER_TYPE | VARCHAR2 | (30) | Meter type code | |
METER_TYPE_NAME | VARCHAR2 | (80) | Meter type name | |
METER_CATEGORY_NAME | VARCHAR2 | (80) | Meter category name | |
SIMULATION_NAME | VARCHAR2 | (80) | Simulation name | |
USAGE_VALUE | NUMBER | Yes | Usage value | |
USAGE_UOM | VARCHAR2 | (80) | Usage UOM | |
USAGE_COST | NUMBER | Usage cost | ||
CURRENCY | VARCHAR2 | (3) | Currency | |
PLANT_FK_KEY | NUMBER | Reference to plant | ||
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT ESA_HR_PK_KEY
, ENTITY_FK_KEY
, ENTITY_TYPE
, SUSTAIN_ASPECT_FK_KEY
, SUSTAIN_ASPECT
, USAGE_CATEGORY
, METER_FK_KEY
, METER_CATEGORY
, SHIFT_WORKDAY_FK_KEY
, HOUR_FK_KEY
, FROM_TIME
, TO_TIME
, ENTITY_NAME
, ENTITY_TYPE_NAME
, SUSTAIN_ASPECT_NAME
, USAGE_CATEGORY_NAME
, METER_TYPE
, METER_TYPE_NAME
, METER_CATEGORY_NAME
, SIMULATION_NAME
, USAGE_VALUE
, USAGE_UOM
, USAGE_COST
, CURRENCY
, PLANT_FK_KEY
, CREATION_DATE
, LAST_UPDATE_DATE
FROM MTH.MTH_ENTITY_SUSTAIN_ASPECT_HOUR;
MTH.MTH_ENTITY_SUSTAIN_ASPECT_HOUR does not reference any database object
MTH.MTH_ENTITY_SUSTAIN_ASPECT_HOUR is referenced by following:
|
|
|