PSXPRPTPROP_VW |
index back |
|---|---|
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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |