RF_SVC_COV_VW(SQL View) |
Index Back |
|---|---|
Service Coverage ViewView listing the coverage for the various types for a Service |
| SELECT A.SETID , A.SERVICE_ID , A.ENTITLE_NAME , B.ENTITLE_TYPE , B.COVERAGE_TYPE , B.AGRT_COV_PCT FROM PS_RF_SERVICE_ENT A , PS_RF_ENTITLEMENTS B WHERE B.SETID = ( SELECT C.SETID FROM PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE = A.SETID AND C.RECNAME = 'RF_ENTITLEMENTS') AND A.ENTITLE_NAME = B.ENTITLE_NAME AND B.ENTITLE_TYPE = 'COV' AND B.COVERAGE_TYPE IN ('MAT', 'TIME', 'EXP') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW |
| 2 | SERVICE_ID |
Character(20) | VARCHAR2(20) NOT NULL | Service ID |
| 3 | ENTITLE_NAME |
Character(10) | VARCHAR2(10) NOT NULL |
This field represents the name of the entitlement
Prompt Table: RF_ENTITLEMENTS |
| 4 | ENTITLE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
This field represents the type of entitlement
COV=Guaranteed Coverage PPM=Service Level RESP=Guaranteed Response REST=Guaranteed Restore |
| 5 | COVERAGE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
This field represents the coverage type of an entitlement
EXP=Expenses MAT=Material TIME=Time |
| 6 | AGRT_COV_PCT | Number(3,0) | SMALLINT NOT NULL | This field represents the agreement coverage percentage |