PTPRCBINDPARMVW

(SQL View)

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 PeopleSoft Field Type Database Column Type Description

1 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name

2 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type

3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

4 RECFIELDNAME Character(34) VARCHAR2(34) NOT NULL Record.Field

5 PT_PRCSFIELDLABEL Character(60) VARCHAR2(60) NOT NULL Field Label

6 PRCS_IS_VAL_REQD Character(1) VARCHAR2(1) NOT NULL Validation?
0=0
1=1

7 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

8 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path

9 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

10 PT_APPCLASSMETHOD Character(60) VARCHAR2(60) NOT NULL Application Class Method Name

11 PT_RECFIELDVALUE Character(100) VARCHAR2(100) NOT NULL Parameter Value

12 PT_PRCSLBLTYPE Character(1) VARCHAR2(1) NOT NULL Label Type
1=Message Catalog
2=RFT Short
3=RFT Long

13 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

14 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

15 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PRCSNAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name
2	PRCSTYPE	Character(30)	VARCHAR2(30) NOT NULL	Process Type
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
4	RECFIELDNAME	Character(34)	VARCHAR2(34) NOT NULL	Record.Field
5	PT_PRCSFIELDLABEL	Character(60)	VARCHAR2(60) NOT NULL	Field Label
6	PRCS_IS_VAL_REQD	Character(1)	VARCHAR2(1) NOT NULL	Validation? 0=0 1=1
7	PACKAGEROOT	Character(30)	VARCHAR2(30) NOT NULL	Root Package ID
8	QUALIFYPATH	Character(127)	VARCHAR2(127) NOT NULL	Qualified Package/Class Path
9	APPCLASSID	Character(30)	VARCHAR2(30) NOT NULL	Application Class ID
10	PT_APPCLASSMETHOD	Character(60)	VARCHAR2(60) NOT NULL	Application Class Method Name
11	PT_RECFIELDVALUE	Character(100)	VARCHAR2(100) NOT NULL	Parameter Value
12	PT_PRCSLBLTYPE	Character(1)	VARCHAR2(1) NOT NULL	Label Type 1=Message Catalog 2=RFT Short 3=RFT Long
13	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
14	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
15	LABEL_ID	Character(18)	VARCHAR2(18) NOT NULL	LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.