RUNCNTLPARAM_VW

index back

SELECT A.PRCSNAME , A.PRCSTYPE , A.RECNAME , A.RECFIELDNAME , A.PRCS_IS_VAL_REQD , A.PACKAGEROOT , A.QUALIFYPATH , A.APPCLASSID , A.PT_APPCLASSMETHOD , A.PT_PRCSLBLTYPE , A.MESSAGE_NBR , A.MESSAGE_SET_NBR , A.LABEL_ID FROM PS_PRCS_RUNPARM A

PeopleSoft Field NameField TypeColumn TypeDescription
PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name
PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
RECFIELDNAMECharacter(34)VARCHAR2(34) NOT NULLRecord.Field
PRCS_IS_VAL_REQDCharacter(1)VARCHAR2(1) NOT NULLValidation?
0=0
1=1
PACKAGEROOTCharacter(30)VARCHAR2(30) NOT NULLRoot Package ID
QUALIFYPATHCharacter(127)VARCHAR2(127) NOT NULLQualified Package/Class Path
APPCLASSIDCharacter(30)VARCHAR2(30) NOT NULLApplication Class ID
PT_APPCLASSMETHODCharacter(60)VARCHAR2(60) NOT NULLApplication Class Method Name
PT_PRCSLBLTYPECharacter(1)VARCHAR2(1) NOT NULLLabel Type
1=Message Catalog
2=RFT Short
3=RFT Long
MESSAGE_NBRNumber(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.
MESSAGE_SET_NBRNumber(5,0)INTEGER NOT NULLMessage Set Number. This field refers to the Message Set Number in the Message Catalog.
LABEL_IDCharacter(18)VARCHAR2(18) NOT NULLLABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19