SEARCH_TERM_TBL

(SQL Table)
 Index Back

Legacy Terms Data Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME_KEY Character(15) VARCHAR2(15) NOT NULL Key Record Name
2 GUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
5 PTLANGUAGELIST Character(254) VARCHAR2(254) NOT NULL Language List
6 TRUNCATE_FLG Character(1) VARCHAR2(1) NOT NULL Truncate Total
7 LOOP_COUNT Number(4,0) SMALLINT NOT NULL Number of Program Loops
8 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
9 URL_ID Character(30) VARCHAR2(30) NOT NULL URL Identifier (see PSURLDEFN).
10 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)
    • 11 SQLTYPE Character(1) VARCHAR2(1) NOT NULL SQL Object type
  • 0=SQL Object referenced from elsewhere
  • 1=Application Engine Step
  • 2=SQL View
  • 5=Queries for DDDAUDIT and SYSAUDIT
  • 6= Application Engine Step XSLT
    • 12 PTCS_SERVICENAME Character(18) VARCHAR2(18) NOT NULL Service Name
    13 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
    14 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
    15 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
    16 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
    17 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
    18 PACKAGEID Character(30) VARCHAR2(30) NOT NULL Package Name (see PSDIAGREG).
    19 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID
    20 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path
    21 PTIBAPPLNAME Character(30) VARCHAR2(30) NOT NULL Application Service ID. (see PSIBAPPLDEFN).
    22 IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
    23 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
    24 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
    25 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    26 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    27 PTCS_SERVICEID Character(30) VARCHAR2(30) NOT NULL Services ID (see PSPTCSSRVDEFN).
    28 PTCS_INSTANCEID Number(10,0) DECIMAL(10) NOT NULL Instance ID
    29 PTCS_INSTANCELBL Character(50) VARCHAR2(50) NOT NULL Service Label
    30 PTCS_SELCREF Character(50) VARCHAR2(50) NOT NULL Select Content Reference
    31 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    32 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    33 DBTYPE Character(1) VARCHAR2(1) NOT NULL Database Type
    0=SQLBase
    1=DB2
    2=Oracle
    3=Informix
    4=DB2/UNIX
    5=AllBase
    6=Sybase
    7=Microsoft
    8=DB2/400
    34 EFFDT Date(10) DATE Effective Date
    35 AE_STEP Character(8) VARCHAR2(8) NOT NULL Name
    36 AE_STMT_TYPE Character(1) VARCHAR2(1) NOT NULL Type
    C=Comments
    D=Do Select
    H=Do When
    N=Do Until
    S=Select
    U=Update/Insert/Delete
    W=Do While
    37 FLAG Character(1) VARCHAR2(1) NOT NULL Flag
    N=No
    Y=Yes
    38 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
    39 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    40 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
    41 CONQRSNAME Character(30) VARCHAR2(30) NOT NULL Connected Queries object name
    42 PTSF_SBO_NAME Character(65) VARCHAR2(65) NOT NULL Search Definition (see PSPTSF_SD).
    43 PTSF_SRCCAT_NAME Character(65) VARCHAR2(65) NOT NULL Search Category Name (see PSPTSF_SRCCAT).
    44 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    45 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    46 TABLENAME Character(30) VARCHAR2(30) NOT NULL Table Name
    47 COUNTER Number(10,0) DECIMAL(10) NOT NULL Counter
    48 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    49 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
    50 PNLFLDID Number(4,0) SMALLINT NOT NULL Page Field ID
    51 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    52 FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value
    53 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    54 PORTAL_REFTYPE Character(1) VARCHAR2(1) NOT NULL Portal Reference Type
    C=Content
    F=Folder