PTPRCBINDPARMVW

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_SET_NBR , A.MESSAGE_NBR , A.LABEL_ID FROM PS_PRCS_RUNPARM A

PeopleSoft Field Name Field Type Column Type Description
PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
RECFIELDNAME Character(34) VARCHAR2(34) NOT NULL Record.Field
PT_PRCSFIELDLABEL Character(60) VARCHAR2(60) NOT NULL Field Label
PRCS_IS_VAL_REQD Character(1) VARCHAR2(1) NOT NULL Validation?
0=0
1=1
PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID
QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path
APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
PT_APPCLASSMETHOD Character(60) VARCHAR2(60) NOT NULL Application Class Method Name
PT_RECFIELDVALUE Character(100) VARCHAR2(100) NOT NULL Parameter Value
PT_PRCSLBLTYPE Character(1) VARCHAR2(1) NOT NULL Label Type
1=Message Catalog
2=RFT Short
3=RFT Long
MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_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.uk PeopleTools 8.54
PTRef generated on 09-JUN-19