IB_RESTRESH_VW

index back

SELECT routingdefnname , effdt , nametype , propname , propvalue , comments FROM psrtngdfnprop WHERE nametype = 'I'

PeopleSoft Field NameField TypeColumn TypeDescription
ROUTINGDEFNNAMECharacter(30)VARCHAR2(30) NOT NULLRouting Name
EFFDTDate(10)DATEEffective Date

Default: %date

NAMETYPECharacter(1)VARCHAR2(1) NOT NULLProperty Name Type
C=Category
I=Identification
S=Search

Default: C

PROPNAMECharacter(30)VARCHAR2(30) NOT NULLProperty Name
PROPVALUECharacter(254)VARCHAR2(254) NOT NULLValue
COMMENTSLong CharacterCLOBComment
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19