TL_VALID_SET

(SQL Table)
 Index Back

Validation Set

Defines a set of Validation Definitions. The M:M relationship is resolved by Validation Item. To wit, TL_VALID_SET ---< TL_VALID_ITEM >--- TL_VALID_DEFN Where: TL_VALID_SET: This entity TL_VALID_ITEM: Resolution entity TL_VALID_DEFN: Validation Definition

  • Related Language Record: TL_VALD_SET_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 VALID_SET_ID Character(10) VARCHAR2(10) NOT NULL Validation Set
    2 PS_DELIVERED Character(1) VARCHAR2(1) NOT NULL PeopleSoft Delivered
    N=No
    Y=Yes

    Default Value: N

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: TL_VALID_SET.DESCR

    5 COMMENTS Long Character CLOB Comment