PSXPGLBPROP_VW

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 NameField TypeColumn TypeDescription
PROPGROUPCharacter(2)VARCHAR2(2) NOT NULLProperty 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
PROPLNAMECharacter(60)VARCHAR2(60) NOT NULLProperty
PROPVALUECharacter(254)VARCHAR2(254) NOT NULLValue

Prompt Table: PSXPXDOPROPOPT

PROPTYPECharacter(3)VARCHAR2(3) NOT NULLType
0=Text
1=Prompt
2=Password
3=Boolean
PROPDFLTCharacter(254)VARCHAR2(254) NOT NULLEngine Default
ORDERBYNUMNumber(3,0)SMALLINT NOT NULLOrder-By Number
PROPTEXTCharacter(254)VARCHAR2(254) NOT NULLText
PROPOPTIONCharacter(18)VARCHAR2(18) NOT NULLPrompt Values

Prompt Table: PSXPXDOPROPOPT

PASSWORDCharacter(254)VARCHAR2(254) NOT NULLPassword
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19