PSXPGLBPROP_VW(SQL View) |
Index Back |
|---|---|
Global Properties View |
| SELECT A.PROPGROUP , A.PROPLNAME , B.PROPVALUE , A.PROPTYPE , A.PROPVALUE , A.ORDERBYNUM , '' , '' , '' FROM PSXPXDOPROP A LEFT JOIN PSXPGLBPROP B ON A.PROPLNAME = B.PROPLNAME |
| # | 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 | PROPDFLT | Character(254) | VARCHAR2(254) NOT NULL | Engine Default |
| 6 | ORDERBYNUM | Number(3,0) | SMALLINT NOT NULL | Order-By Number |
| 7 | PROPTEXT | Character(254) | VARCHAR2(254) NOT NULL | Text |
| 8 | PROPOPTION | Character(18) | VARCHAR2(18) NOT NULL |
Prompt Values
Prompt Table: PSXPXDOPROPOPT |
| 9 | PASSWORD | Character(254) | VARCHAR2(254) NOT NULL | Password |