QS_ALM_ACCESS(SQL Table) |
Index Back |
|---|---|
Alarm access list |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUQS_NONVW |
| 2 | QS_APP_CONTEXT |
Character(18) | VARCHAR2(18) NOT NULL |
QC application context identifier
Prompt Table: QS_APP_BU |
| 3 | QS_ALM_ACCESS_ID |
Character(8) | VARCHAR2(8) NOT NULL | ID used to access QS alarms |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | QS_REVIEW_PERIOD | Number(3,0) | SMALLINT NOT NULL |
Review period in days (alarm life)
Default Value: 2 |
| 6 | QS_ALARM_SEL_CD | Character(4) | VARCHAR2(4) NOT NULL |
Alarm selection switch (all, closed, ...)
ALL=All Alarms CLOS=Closed - Actions Logged OPEN=Open - No Actions Logged Default Value: ALL |
| 7 | QS_MOD_DATE | DateTime(26) | TIMESTAMP | General modification date for record change tracking |
| 8 | QS_MOD_BY | Character(30) | VARCHAR2(30) NOT NULL | Modified by "operator" |