QS_APP_CONTEXTQS_APP_DEF_VW(SQL View) |
Index Back |
|---|---|
QC application definition rec |
| SELECT QS_APP_CONTEXT ,DESCR ,SCNTL_SESSN_LIFE ,SCNTL_EDIT_LIFE ,QS_MOD_DATE ,QS_MOD_BY ,QS_PURGE_DATE ,GREF_ID FROM PS_QS_APP_DEF |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | QS_APP_CONTEXT |
Character(18) | VARCHAR2(18) NOT NULL | QC application context identifier |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | SCNTL_SESSN_LIFE | Number(3,0) | SMALLINT NOT NULL | Session Data Life Days |
| 4 | SCNTL_EDIT_LIFE | Number(3,0) | SMALLINT NOT NULL | Edit Data Limit Days |
| 5 | QS_MOD_DATE | DateTime(26) | TIMESTAMP | General modification date for record change tracking |
| 6 | QS_MOD_BY | Character(30) | VARCHAR2(30) NOT NULL | Modified by "operator" |
| 7 | QS_PURGE_DATE | Date(10) | DATE | date on which the last session cleanup was run |
| 8 | GREF_ID | Number(4,0) | SMALLINT NOT NULL | Graph Preference ID |