BUSINESS_UNITASSET_IDFSC_CODEPrompt Table: FED_SUP_CLASS
P=Predominant
S=Significant
Default Value: S
AM_ED_HAZARD(SQL View) |
Index Back |
|---|---|
Asset related FSC- Hazardous |
| SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.FSC_CODE , B.FSC_TYPE , B.DESCRLONG , B.ITEMS_CONTAINED FROM PS_ASSET_FSC A , PS_FED_SUP_CLASS B , PS_SET_CNTRL_REC C WHERE C.RECNAME = 'FED_SUP_CLASS' AND C.SETID = B.SETID AND A.BUSINESS_UNIT = C.SETCNTRLVALUE AND A.FSC_CODE = B.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 |