PSPGDPTHRPER

index back

Pivot Grid Threshold Personali


PeopleSoft Field Name Field Type Column Type Description
PTPG_PGRIDNAME Character(30) VARCHAR2(30) NOT NULL Pivot Grid Name (see PSPGCORE).
PTPG_VIEWNAME Character(40) VARCHAR2(40) NOT NULL View Name
PTPG_YAXIS Character(24) VARCHAR2(24) NOT NULL y-Axis
PTPG_AXISCOL Character(254) VARCHAR2(254) NOT NULL Axis Column
PTPG_SERIES_CHART Character(254) VARCHAR2(254) NOT NULL Series Field
USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
PTPG_DSUNIQUEFLD Character(254) VARCHAR2(254) NOT NULL Unique Heading
PTPG_XAXIS Character(24) VARCHAR2(24) NOT NULL x-Axis
PTPG_SERIES Character(24) VARCHAR2(24) NOT NULL Series
PTPG_THRESHOLDTYPE Character(1) VARCHAR2(1) NOT NULL Threshold Type
1=Distinct
2=Range
PTPG_THR_DIST_VAL Character(100) VARCHAR2(100) NOT NULL Threshold Value
PTPG_THR_LOW_VAL Character(100) VARCHAR2(100) NOT NULL Lower Limit
PTPG_THR_HIGH_VAL Character(100) VARCHAR2(100) NOT NULL Higher Limit
PTPG_THR_COLOR Character(20) VARCHAR2(20) NOT NULL Threshold Color
PTPG_THR_DESCR Character(254) VARCHAR2(254) NOT NULL Threshold Description
PTPG_THR_NOT_COND Character(2) VARCHAR2(2) NOT NULL Alert Criteria
AR=Above Range
BR=Below Range
EQ=Equal
GT=Greater Than
IR=In the Range
LT=Less Than
NE=Not Equal
NR=Not in Range
PTPG_THR_ALRT_TYPE Character(1) VARCHAR2(1) NOT NULL Alert Type
A=Alert
B=Both
M=Mail
N=No
Y=Yes

Y/N Table Edit

Default: N

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20