RF_AG_LN_COV_VW (SQL View)	Index Back
Agreement Line Coverage View Agreement Line View of the coverage being used for Material, Time and Expense.

RF_AG_LN_COV_VW

(SQL View)

Agreement Line Coverage View

Agreement Line View of the coverage being used for Material, Time and Expense.

SELECT A.SETID , A.AGREEMENT_CODE , A.AGR_RENEWAL_NUM , A.AGREEMENT_LINE , A.ENTITLE_NAME , B.ENTITLE_TYPE , B.COVERAGE_TYPE , B.AGRT_COV_PCT FROM PS_RF_AG_LINE_ENTL 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.

2 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement

3 AGR_RENEWAL_NUM Number(4,0) SMALLINT NOT NULL This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)

4 AGREEMENT_LINE Character(10) VARCHAR2(10) NOT NULL This field records the value for the agreement line number

5 ENTITLE_NAME Character(10) VARCHAR2(10) NOT NULL This field represents the name of the entitlement

6 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

7 COVERAGE_TYPE Character(4) VARCHAR2(4) NOT NULL This field represents the coverage type of an entitlement
EXP=Expenses
MAT=Material
TIME=Time

8 AGRT_COV_PCT Number(3,0) SMALLINT NOT NULL This field represents the agreement coverage percentage

#	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.
2	AGREEMENT_CODE	Character(30)	VARCHAR2(30) NOT NULL	This field represents the agreement code (name) for an agreement
3	AGR_RENEWAL_NUM	Number(4,0)	SMALLINT NOT NULL	This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)
4	AGREEMENT_LINE	Character(10)	VARCHAR2(10) NOT NULL	This field records the value for the agreement line number
5	ENTITLE_NAME	Character(10)	VARCHAR2(10) NOT NULL	This field represents the name of the entitlement
6	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
7	COVERAGE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	This field represents the coverage type of an entitlement EXP=Expenses MAT=Material TIME=Time
8	AGRT_COV_PCT	Number(3,0)	SMALLINT NOT NULL	This field represents the agreement coverage percentage