PSXPRPTPROP_VW

(SQL View)
 Index Back

BIP Report Properties

View for BIP Report Properties

SELECT A.PROPGROUP , A.PROPLNAME , '' , A.PROPTYPE , A.PROPVALUE , A.PROPDFLT , A.ORDERBYNUM , '' , '' , '' FROM PSXPGLBPROP_VW A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROPGROUP Character(2) VARCHAR2(2) NOT NULL Property Group
0=PeopleTools Settings
1=PDF Output
10=Printer Properties
11=PDF Digital Signature
12=PDF Submit Settings
13=XLS Output
2=PDF Security
3=RTF Output
4=HTML Output
5=FO Processing
6=PDF Template
7=RTF Template
8=PDF Document Merger
9=XLIFF Translation
2 PROPLNAME Character(60) VARCHAR2(60) NOT NULL Property
3 PROPVALUE Character(254) VARCHAR2(254) NOT NULL Value

Prompt Table: PSXPXDOPROPOPT

4 PROPTYPE Character(3) VARCHAR2(3) NOT NULL Type
0=Text
1=Prompt
2=Password
3=Boolean
5 PTVALUE Character(254) VARCHAR2(254) NOT NULL Value
6 PROPDFLT Character(254) VARCHAR2(254) NOT NULL Engine Default
7 ORDERBYNUM Number(3,0) SMALLINT NOT NULL Order-By Number
8 PROPTEXT Character(254) VARCHAR2(254) NOT NULL Text
9 PROPOPTION Character(18) VARCHAR2(18) NOT NULL Prompt Values

Prompt Table: PSXPXDOPROPOPT

10 PASSWORD Character(254) VARCHAR2(254) NOT NULL Password