PTCS_MAPFIELDS

index back
Map fields table

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: PTCSSERVICEDEFN

PTCS_ORDERNONumber(10,0)DECIMAL(10) NOT NULLUnique Order number
PTCS_INSTANCEIDNumber(10,0)DECIMAL(10) NOT NULLInstance ID

Default: 1

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
PTCS_MAPNULLVALUECharacter(1)VARCHAR2(1) NOT NULLIs Value Required?
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