PSPTCS_MAPFLDS

index back
Map fields table

  • Parent record: PSPTCSSRVCONF
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).
    PORTAL_OBJNAMECharacter(30)VARCHAR2(30) NOT NULLPortal Object Name
    PTCS_SERVICEIDCharacter(30)VARCHAR2(30) NOT NULLServices ID (see PSPTCSSRVDEFN).

    Prompt Table: PSPTCSSRVDEFN

    PTCS_INSTANCEIDNumber(10,0)DECIMAL(10) NOT NULLInstance ID
    PTCS_PARAMETERNAMECharacter(128)VARCHAR2(128) NOT NULLParameter Name
    PTCS_PNLFLDNAMECharacter(254)VARCHAR2(254) NOT NULLPage Field Name
    PTCS_PNLNAMECharacter(30)VARCHAR2(30) NOT NULLPage Name
    PTCS_MAPFIELDTYPECharacter(2)VARCHAR2(2) NOT NULLMapping Type
    DC=Data Column
    FV=Fixed Value
    KF=Key Field
    ML=Menu Location
    PF=Page Field
    PP=Prompt
    SV=System Variable
    PTCSREFRESHSERVICECharacter(1)VARCHAR2(1) NOT NULLRefresh Service On Change

    Y/N Table Edit

    Default: N

    PTCS_MAPNULLVALUECharacter(1)VARCHAR2(1) NOT NULLIs Value Required?

    Y/N Table Edit

    Default: N

    PTCS_FIELDMENUOPTCharacter(1)VARCHAR2(1) NOT NULLDisplay in field menu
    N=No
    Y=Yes

    Default: N

    PTCS_SEQNUM_FMNUNumber(3,0)SMALLINT NOT NULLSequence Number
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19