FED_SUP_CLASS

(SQL Table)
Index Back

Federal Supply Class Codes

This record is used for maintaining Federal Supply class for Hazardous Asset

  • Related Language Record: FED_SUP_CLASLAN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 FSC_CODE Character(5) VARCHAR2(5) NOT NULL Hazardous Asset - Federal Supply Class code
    3 FSC_TYPE Character(1) VARCHAR2(1) NOT NULL Hazardous Asset - Federal Supply code Type
    P=Predominant
    S=Significant

    Default Value: S

    4 DESCRLONG Long Character CLOB Long Description
    5 ITEMS_CONTAINED Character(50) VARCHAR2(50) NOT NULL Hazardous asset , items contained for the Federal Supply code