PSXPRPTPROP_VW

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 Field Type Column Type Description
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
PROPLNAME Character(60) VARCHAR2(60) NOT NULL Property
PROPVALUE Character(254) VARCHAR2(254) NOT NULL Value

Prompt Table: PSXPXDOPROPOPT

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

Prompt Table: PSXPXDOPROPOPT

PASSWORD Character(254) VARCHAR2(254) NOT NULL Password
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19