IT_SUBTYPE

(SQL Table)
 Index Back

IT SubType Record

  • Related Language Record: IT_SUBTYPE_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL Asset Type
    010=IT Hardware
    020=IT Software
    040=Equipment
    050=Property
    060=Fleet
    070=Machinery
    080=Furniture
    090=Facility
    100=Intangible
    200=Asset Retirement Obligations
    999=Other

    Default Value: 010

    2 IT_SUBTYPE Character(15) VARCHAR2(15) NOT NULL IT Subtype
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCR15 Character(15) VARCHAR2(15) NOT NULL Short Description
    5 ACTIVE_STATUS Character(1) VARCHAR2(1) NOT NULL Transfer Template Status
    A=Active
    I=Inactive

    Default Value: A

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    8 DISCOVERY_DATE Date(10) DATE Last Request Date

    Default Value: %DATE

    9 AUTHORIZE_SFTWR Character(1) VARCHAR2(1) NOT NULL This field is used on the ITAM IT Subtype to indicate whether the Subtype is to be used for Serial Number (or Device) based Software Licensing (vs Employee-based Software licensing model). Field generally named to allow extension if we ever need to support other models.

    Y/N Table Edit

    Default Value: N