ASSET_CLASSASSET_CLS_MC_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT a.ASSET_CLASS , a.DESCR50 FROM PS_ASSET_CLASS_TBL a WHERE a.EFFDT = ( SELECT MAX(b.effdt) FROM PS_ASSET_CLASS_TBL b WHERE a.SETID = b.SETID AND a.ASSET_CLASS = b.ASSET_CLASS) AND a.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ASSET_CLASS |
Character(10) | VARCHAR2(10) NOT NULL | Asset Class |
| 2 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |