IT_SUBTYPE_H

(SQL View)
 Index Back

IT Subtypes for Hardware


SELECT IT_SUBTYPE , DESCR , DESCR15 , ACTIVE_STATUS , RECON_FLG , UNDISCOVERED_FLAG , DISCOVERY_DATE FROM %Table(IT_SUBTYPE) WHERE ASSET_TYPE = '010'

  • Related Language Record: IT_SUBTYPE_H_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IT_SUBTYPE Character(15) VARCHAR2(15) NOT NULL IT Subtype
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCR15 Character(15) VARCHAR2(15) NOT NULL Short Description
    4 ACTIVE_STATUS Character(1) VARCHAR2(1) NOT NULL Transfer Template Status
    A=Active
    I=Inactive

    Default Value: A

    5 RECON_FLG Character(1) VARCHAR2(1) NOT NULL Discover/Reconcile

    Y/N Table Edit

    Default Value: N

    6 UNDISCOVERED_FLAG Character(1) VARCHAR2(1) NOT NULL Undiscovered Flag

    Y/N Table Edit

    Default Value: N

    7 DISCOVERY_DATE Date(10) DATE Last Inventory Date

    Default Value: %DATE