BUSINESS_UNITPrompt Table: SP_BU_AM_NONVW
ASSET_IDPrompt Table: ASSET
METER_TYPEPrompt Table: ASSET_METER_VW
MAINT_DTTMMAINT_TYPEREADING_DTTMPrompt Table: AM_MET_READ_VW
AM_MAINT_RD_VW(SQL View) |
Index Back |
|---|---|
Related Meter Readings |
| SELECT D.BUSINESS_UNIT ,D.ASSET_ID ,D.METER_TYPE ,D.MAINT_DTTM ,D.MAINT_TYPE ,D.READING_DTTM ,A.READING ,A.CUM_READING FROM PS_AM_METER_READ A , PS_AM_MAINT_READ B , PS_AM_MAINT_READ D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ASSET_ID = B.ASSET_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.ASSET_ID = D.ASSET_ID AND A.METER_TYPE = D.METER_TYPE AND A.READING_DTTM = D.READING_DTTM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_AM_NONVW |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table: ASSET |
| 3 | METER_TYPE |
Character(30) | VARCHAR2(30) NOT NULL |
Meter Type
Prompt Table: ASSET_METER_VW |
| 4 | MAINT_DTTM |
DateTime(26) | TIMESTAMP NOT NULL | Maintenance Date/Time |
| 5 | MAINT_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | This field is used for maintenance type |
| 6 | READING_DTTM |
DateTime(26) | TIMESTAMP NOT NULL |
As of Date/Time
Prompt Table: AM_MET_READ_VW |
| 7 | READING | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Reading |
| 8 | CUM_READING | Signed Number(21,4) | DECIMAL(19,4) NOT NULL | Cumulative Reading |