PORTAL_NAMEPORTAL_OBJNAMEPTCS_PARAMETERNAMEAVG=Average
CDI=Count Distinct
CNT=Count
MAX=Maximum
MIN=Minimum
NON=None
SUM=Sum
DIM=Axis
DISO=Display
VAL=Value
PTCSPG_PGDS_VW(SQL View) |
Index Back |
|---|
| SELECT '_PTCS_PTPG' , PTPG_PGRIDNAME , PTPG_DSUNIQUEFLD , PTPG_DSUNIQUEFLD , PTPG_DSCOLUMN , PTPG_AGGREGATE , PTPG_COLMNTYPE FROM PSPGMODEL WHERE PTPG_COLMNTYPE IN ('DIM','VAL') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PORTAL_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
| 2 | PORTAL_OBJNAME |
Character(30) | VARCHAR2(30) NOT NULL | Portal Object Name |
| 3 | PTCS_PARAMETERNAME |
Character(128) | VARCHAR2(128) NOT NULL | Parameter Name |
| 4 | PTCS_PNLFLDNAME | Character(254) | VARCHAR2(254) NOT NULL | Data Column |
| 5 | PTPG_DSCOLUMN | Character(254) | VARCHAR2(254) NOT NULL | Data Source Columns |
| 6 | PTPG_AGGREGATE | Character(3) | VARCHAR2(3) NOT NULL |
Aggregate Functions
AVG=Average CDI=Count Distinct CNT=Count MAX=Maximum MIN=Minimum NON=None SUM=Sum |
| 7 | PTPG_COLMNTYPE | Character(4) | VARCHAR2(4) NOT NULL |
Column Type
DIM=Axis DISO=Display VAL=Value |