BUSINESS_UNITMETER_TYPELANGUAGE_CDWM_METERTYPE_LG(SQL View) |
Index Back |
|---|---|
Meter Types |
| SELECT %Substring(S.SETCNTRLVALUE, 1, 5) , M.METER_TYPE , M.LANGUAGE_CD , M.DESCR FROM PS_AM_METER_TYPE_L M , PS_SET_CNTRL_REC S , PS_AM_METER_TYPE T WHERE M.SETID = S.SETID AND S.RECNAME = 'AM_METER_TYPE' AND M.SETID = T.SETID AND M.METER_TYPE = T.METER_TYPE AND T.STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | METER_TYPE |
Character(30) | VARCHAR2(30) NOT NULL | Meter Type |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |