OPRIDCAF_SESSION_IDCAF_FACTOR_IDCAF_SUBFACTOR_IDCAF_SEQ_NUMCAF_CODECAF_SESSPVPT_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT PG.OPRID , PG.CAF_SESSION_ID , PG.CAF_FACTOR_ID , PG.CAF_SUBFACTOR_ID , PG.CAF_SEQ_NUM , PG.CAF_CODE , PG.PTPG_PGRIDNAME , PG.PTPG_VIEWNAME FROM PS_CAF_SESSION_PGV PG , PSPGQRYPROMPT PT WHERE PG.PTPG_PGRIDNAME = PT.PTPG_PGRIDNAME AND %Substring(PG.PTPG_VIEWNAME,7,32) = %Substring(PT.PTPG_VIEWNAME,7,32) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | CAF_SESSION_ID |
Character(36) | VARCHAR2(36) NOT NULL | Session ID |
| 3 | CAF_FACTOR_ID |
Character(30) | VARCHAR2(30) NOT NULL | Factor ID |
| 4 | CAF_SUBFACTOR_ID |
Character(128) | VARCHAR2(128) NOT NULL | Subfactor ID |
| 5 | CAF_SEQ_NUM |
Number(4,0) | SMALLINT NOT NULL | Sequence |
| 6 | CAF_CODE |
Character(4) | VARCHAR2(4) NOT NULL | Code |
| 7 | PTPG_PGRIDNAME | Character(30) | VARCHAR2(30) NOT NULL | Pivot Grid Name (see PSPGCORE). |
| 8 | PTPG_VIEWNAME | Character(40) | VARCHAR2(40) NOT NULL | View Name |