IT_STYP_UNDSC

(SQL View)
 Index Back

IT Subtypes for reconciliation

This view filters out IT Subtypes that are included in the reconciliation process

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

  • Related Language Record: IT_STYP_UNDSCLG

    • # 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