RBW_ASTCAT3_VW(SQL View) | 
Index Back | 
|---|---|
View to display Asset Type3This view is used for displaying all asset type3 | 
| SELECT ASSET_CAT_TYPE ,ASSET_CAT_DESCR FROM PS_RBW_CAT_DEF_TBL WHERE AST_CAT_LEVEL = '3' | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(4) | VARCHAR2(4) NOT NULL | Asset category Type definition | |
| 2 | ASSET_CAT_DESCR | Character(40) | VARCHAR2(40) NOT NULL | Asset category Type description |