PTCS_MAPFIELDS

index back
Map fields table

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

Prompt Table: PTCSSERVICEDEFN

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

Default: 1

PTCS_PARAMETERNAME Character(128) VARCHAR2(128) NOT NULL Parameter Name
PTCS_PNLFLDNAME Character(254) VARCHAR2(254) NOT NULL Page Field Name
PTCS_PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name
PTCS_MAPFIELDTYPE Character(2) VARCHAR2(2) NOT NULL Mapping Type
DC=Data Column
FV=Fixed Value
KF=Key Field
ML=Menu Location
PF=Page Field
PP=Prompt
SV=System Variable
PTCSREFRESHSERVICE Character(1) VARCHAR2(1) NOT NULL Refresh Service On Change
PTCS_MAPNULLVALUE Character(1) VARCHAR2(1) NOT NULL Is Value Required?
PTCS_FIELDMENUOPT Character(1) VARCHAR2(1) NOT NULL Display in field menu
N=No
Y=Yes

Default: N

PTCS_SEQNUM_FMNU Number(3,0) SMALLINT NOT NULL Sequence Number
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19