BUSINESS_UNITASSET_IDFSC_CODEPrompt Table: FED_SUP_CLASS
P=Predominant
S=Significant
Default Value: S
WM_ASSET_FSC_VW(SQL View) |
Index Back |
|---|---|
Asset related FSC- HazardousAsset Hazardous Codes view for web services. |
| SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.FSC_CODE , B.FSC_TYPE , B.DESCRLONG , B.ITEMS_CONTAINED , A.SYNCDTTM FROM PS_ASSET_FSC A , PS_FED_SUP_CLASS B , PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'FED_SUP_CLASS' AND B.SETID = C.SETID AND B.FSC_CODE = A.FSC_CODE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | FSC_CODE |
Character(5) | VARCHAR2(5) NOT NULL |
Hazardous Asset - Federal Supply Class code
Prompt Table: FED_SUP_CLASS |
| 4 | FSC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Hazardous Asset - Federal Supply code Type
P=Predominant S=Significant Default Value: S |
| 5 | DESCRLONG | Long Character | CLOB | Long Description |
| 6 | ITEMS_CONTAINED | Character(50) | VARCHAR2(50) NOT NULL | Hazardous asset , items contained for the Federal Supply code |
| 7 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |