QS_ALM_ACCSS_VW

(SQL View)
 Index Back

Alarm access list view

CN#MG801-1.0 - 08/28/00 - mt - Added catalog dtype to view to allow composing correct SQL selects

SELECT a.business_unit , a.qs_app_context , a.qs_alm_access_id , b.descr , b.qs_review_period , b.qs_alarm_sel_cd , b.qs_mod_date , b.qs_mod_by , a.qs_seq , a.qs_field_comp_name , a.qs_field_value , a.qs_field_operator , c.cat_descr , c.qs_select_dtyp FROM ps_qs_alm_acclist8 a , ps_qs_alm_access b , PS_QS_CATALOG c WHERE (b.business_unit = a.business_unit AND b.qs_app_context = a.qs_app_context AND b.qs_alm_access_id = a.qs_alm_access_id) AND (c.cat_fieldname = a.qs_field_comp_name)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 QS_APP_CONTEXT Character(18) VARCHAR2(18) NOT NULL QC application context identifier
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)
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
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"
9 QS_SEQ Number(5,0) INTEGER NOT NULL Generic sequence number
10 QS_FIELD_COMP_NAME Character(18) VARCHAR2(18) NOT NULL QC application structure field component
11 QS_FIELD_VALUE Character(40) VARCHAR2(40) NOT NULL Generic field for trace value input
12 QS_FIELD_OPERATOR Character(4) VARCHAR2(4) NOT NULL Field selection operator
<>=<>
===
ALL=ALL
BTWN=BETWEEN
LIKE=LIKE
13 CAT_DESCR Character(20) VARCHAR2(20) NOT NULL Catalog Field Description
14 QS_SELECT_DTYP Character(4) VARCHAR2(4) NOT NULL Specify datatype for SQL/Select verifictaion
CHAR=Character
NUM=Numeric