CS_TMPL_RULE_VW

(SQL View)
 Index Back

Rule Drill Down

10/23/06 SCC: View of effective dated rule based on the View As of Date of the document configurator.

SELECT A.OPRID , A.SETID , A.CS_TEMPLATE_ID , B.CS_RULE_ID , C.EFFDT , B.DESCR60 , B.CS_RULE_TYPE , C.EFF_STATUS FROM PS_CS_TLEXP_DT_TMP A , PS_CS_RULES B , PS_CS_RULE_DTLS C WHERE A.SETID=B.SETID AND A.CS_OBJECT_TYPE_SRC='0007' AND B.SETID = C.SETID AND B.CS_RULE_ID = C.CS_RULE_ID AND C.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_CS_RULE_DTLS D WHERE C.SETID=D.SETID AND C.CS_RULE_ID=D.CS_RULE_ID AND D.EFFDT <= A.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 CS_TEMPLATE_ID Character(20) VARCHAR2(20) NOT NULL SCC 09/01/04
4 CS_RULE_ID Character(20) VARCHAR2(20) NOT NULL t
5 EFFDT Date(10) DATE Effective Date
6 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
7 CS_RULE_TYPE Character(1) VARCHAR2(1) NOT NULL Rule Type
A=Alternate
S=Standard
8 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive