EP_APPR_RULE_VW (SQL View)	Index Back
ePerformance Approval Rule Vw

EP_APPR_RULE_VW

(SQL View)

ePerformance Approval Rule Vw

SELECT A.APPR_RULE_SET , A.EFFDT FROM PS_APPR_RULE_HDR A , PS_SS_PROC_RULES B WHERE B.TRANSACTION_NAME = 'EP_APPRAISAL' AND B.SS_CONFIG_OPTION IN ('1','2') AND A.APPR_RULE_SET = B.APPR_RULE_SET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 APPR_RULE_SET Character(30) VARCHAR2(30) NOT NULL Approval Rule Set

2 EFFDT Date(10) DATE Effective Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	APPR_RULE_SET	Character(30)	VARCHAR2(30) NOT NULL	Approval Rule Set
2	EFFDT	Date(10)	DATE	Effective Date