TS_RECORDS

(SQL Table)
 Index Back

Text Searchable Records

Text Searchable Records

  • Parent Record Of TS_REC_KEYFLDS TS_REC_TXTFLDS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

    2 RELLANGRECNAME Character(15) VARCHAR2(15) NOT NULL Related Language Record Name

    Default Value: PSRECDEFN.RELLANGRECNAME

    Prompt Table: PSRECDEFN

    3 TS_OBJECT_TYPE Character(3) VARCHAR2(3) NOT NULL Object Type
    APP=Application Objects
    BPS=Business Processes
    MEN=Menu
    MSG=Messages
    OTH=Other
    PNL=Panel
    QRY=Queries and Strings
    REC=Records, Fields, Xlats
    4 TS_COMBINED Character(1) VARCHAR2(1) NOT NULL Combined Language Table

    Y/N Table Edit

    Default Value: N