ASSET_CRITICALITYWM_AM_CRIT_VW(SQL View) |
Index Back |
|---|---|
WM Asset Criticality Level |
| SELECT ASSET_CRITICALITY , ASSET_CRITICALITY %Concat ' - ' %Concat DESCR , ASSET_CRIT_FACTOR FROM PS_AM_CRIT_LVL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ASSET_CRITICALITY |
Character(2) | VARCHAR2(2) NOT NULL | Asset Criticality |
| 2 | ASSET_CRIT_DESCR | Character(35) | VARCHAR2(35) NOT NULL | Asset Criticality |
| 3 | ASSET_CRIT_FACTOR | Number(3,0) | SMALLINT NOT NULL | Criticality Factor |