PTCSSERVICECONF

(SQL Table)
 Index Back

  • Related Language Record: PTCSSRVCONFLANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    2 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    3 PTCS_SERVICEID Character(30) VARCHAR2(30) NOT NULL Services ID (see PSPTCSSRVDEFN).

    Prompt Table: PTCSSERVICEDEFN

    4 PTCS_ORDERNO Number(10,0) DECIMAL(10) NOT NULL Unique Order number
    5 PTCS_INSTANCEID Number(10,0) DECIMAL(10) NOT NULL Instance ID

    Default Value: 1

    6 PTCS_ISCOMPSERVICE Character(1) VARCHAR2(1) NOT NULL Component Service
    C=Services at Component Level
    F=Event Mapping Comp Rec Fld
    P=Services at Page level
    R=Event Mapping at Comp Rec
    7 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

    Prompt Table: PTCS_PNLLST_DVW

    8 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    9 PTCS_HIDEFROMSRCH Character(1) VARCHAR2(1) NOT NULL Private Data

    Y/N Table Edit

    Default Value: N

    10 IS_DEFAULT Character(1) VARCHAR2(1) NOT NULL Default Template
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    11 PTCS_MAPSECOPTIONS Character(1) VARCHAR2(1) NOT NULL Security options to display Map fields page
    P=Public Access
    R=Related Content Security
    T=Transaction Security
    12 HANDLERNAME Character(30) VARCHAR2(30) NOT NULL Handler Name
    13 PTCS_INSTANCELBL Character(50) VARCHAR2(50) NOT NULL Service Label
    14 PTCS_URLTARGET Character(4) VARCHAR2(4) NOT NULL Service Target
    MDLW=Modal Window
    NWIN=New Window
    RCF=Related Content
    SRCF=Right Frame
    TGTF=Target Content
    TOPF=Replace Window
    USRD=User Defined

    Default Value: RCF

    15 PTCS_RCMENUOPT Character(1) VARCHAR2(1) NOT NULL Related Content Menu
    N=No
    Y=Yes

    Default Value: Y

    16 PTCS_MAINMENUOPT Character(1) VARCHAR2(1) NOT NULL Related Actions Menu
    N=No
    Y=Yes

    Default Value: N

    17 PTCS_SEQNUM_MMNU Number(3,0) SMALLINT NOT NULL Sequence Number
    18 PTCS_SEQNUM_RMNU Number(3,0) SMALLINT NOT NULL Sequence Number
    19 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

    Prompt Table: PSPACKAGROOT_VW

    20 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path

    Prompt Table: PSPACKAGPATH_VW

    21 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

    Prompt Table: PSPACKAGCLAS_VW