METER_TYPEWM_ASSETMTR2_VW(SQL View) |
Index Back |
|---|---|
Asset Meter ViewAsset Meter View |
| SELECT A.METER_TYPE , B.DESCR FROM PS_ASSET_METER A , PS_AM_METER_TYPE B , PS_SET_CNTRL_REC C WHERE A.METER_TYPE = B.METER_TYPE AND A.BUSINESS_UNIT = C.SETCNTRLVALUE AND A.STATUS = 'A' AND B.METER_OPTION IN ('D', 'I', 'R') AND B.SETID = C.SETID AND C.REC_GROUP_ID = 'AM_13' AND C.RECNAME = 'AM_METER_TYPE' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | METER_TYPE |
Character(30) | VARCHAR2(30) NOT NULL | Meter Type |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |