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 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
PTVALUECharacter(254)VARCHAR2(254) NOT NULLValue
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