RTBL=Real Time Bottom Line
SYS=System
USER=User Defined
CAF_SESSION_IDCAF_PGV_PT_VW2(SQL View) |
Index Back |
|---|---|
PVG Prompts of cur SessionThis view contains the PVG prompt fields of the current sessions that should be updated. It is used by CAFNUI_CORE:HANDLER:OnlineHandler |
| SELECT P.CAF_CONFIG_TYPE , P.CAF_CONFIG_ID , PV.CAF_SESSION_ID , PV.CAF_FACTOR_ID , PV.PTPG_PGRIDNAME , PT.PTPG_VIEWNAME , P.PTPG_UNIQPROMPFLD , P.RECNAME , P.FIELDNAME FROM PS_CAF_SESSION S , PS_CAF_SESSION_PGV PV , PSPGQRYPROMPT PT , PS_CAF_FCT_PVPTTBL P WHERE P.CAF_CONFIG_TYPE = S.CAF_CONFIG_TYPE AND P.CAF_CONFIG_ID = S.CAF_CONFIG_ID AND PV.OPRID = S.OPRID AND PV.CAF_SESSION_ID = S.CAF_SESSION_ID AND PV.PTPG_PGRIDNAME = PT.PTPG_PGRIDNAME AND %Substring(PV.PTPG_VIEWNAME,7,32) = %Substring(PT.PTPG_VIEWNAME,7,32) AND P.CAF_FACTOR_ID = PV.CAF_FACTOR_ID AND P.PTPG_UNIQPROMPFLD = PT.PTPG_UNIQPROMPFLD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAF_CONFIG_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Analysis Type
RTBL=Real Time Bottom Line SYS=System USER=User Defined |
| 2 | CAF_CONFIG_ID | Character(30) | VARCHAR2(30) NOT NULL | Analysis ID |
| 3 | CAF_SESSION_ID |
Character(36) | VARCHAR2(36) NOT NULL | Session ID |
| 4 | CAF_FACTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Factor ID |
| 5 | PTPG_PGRIDNAME | Character(30) | VARCHAR2(30) NOT NULL | Pivot Grid Name (see PSPGCORE). |
| 6 | PTPG_VIEWNAME | Character(40) | VARCHAR2(40) NOT NULL | View Name |
| 7 | PTPG_UNIQPROMPFLD | Character(30) | VARCHAR2(30) NOT NULL | Unique Prompt Name |
| 8 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 9 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |