PSPTTSTDEFN

(SQL Table)
Index Back

PsTestFw Test Definition

  • Parent Record Of PSPTTSTCMDDESCR PSPTTSTDESCR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTTST_NAME Character(30) VARCHAR2(30) NOT NULL Test Name
    2 PTTST_PARENTFOLDER Character(200) VARCHAR2(200) NOT NULL Test Parent Folder
    3 PTTST_TYPE Character(1) VARCHAR2(1) NOT NULL Test Type
    F=Folder
    H=Shell Test
    L=Library
    S=Test
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    6 PTTST_USE_ERROR Character(1) VARCHAR2(1) NOT NULL User Error Handling

    Default Value: N

    7 PTTST_PV_ACTN Character(1) VARCHAR2(1) NOT NULL PVAction
    A=Read & Write
    N=None
    R=Read
    W=Write

    Default Value: N

    8 PTTST_APP_VER Character(50) VARCHAR2(50) NOT NULL Version

    Default Value: 8.52

    9 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    10 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    11 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    12 DESCRLONG Long Character CLOB Long Description