EP_DIST_MGR_VW

(SQL View)
 Index Back

Mgr Desired Distribution Table

Manager self service desired distribution table.

SELECT A.EP_REVIEW_TYPE , A.EFFDT , T.EP_TEMPLATE_ID , B.RATING_MODEL , B.EP_CALC_METHOD , A.EFF_STATUS , A.EP_APPLY_TO_ALL , B.REVIEW_RATING , B.DESIRED_DIST_PCT FROM (PS_EP_DIST_MGR A LEFT OUTER JOIN PS_EP_DIST_MGR_TPL T ON A.EP_REVIEW_TYPE = T.EP_REVIEW_TYPE AND A.EFFDT = T.EFFDT) , PS_EP_DIST_MGR_PCT B WHERE A.EFF_STATUS = 'A' AND A.EP_REVIEW_TYPE = B.EP_REVIEW_TYPE AND A.EFFDT = B.EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EP_REVIEW_TYPE Character(8) VARCHAR2(8) NOT NULL Review type

Prompt Table: EP_REVW_PRF_VW

2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 EP_TEMPLATE_ID Character(8) VARCHAR2(8) NOT NULL Template unique identifier

Prompt Table: EP_TMPL_DIST_VW

4 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model

Prompt Table: RATING_MDL_TBL

5 EP_CALC_METHOD Character(1) VARCHAR2(1) NOT NULL Calculation method used - Summary, Average, Review Band
A=Average
R=Review Band
S=Summation
6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

7 EP_APPLY_TO_ALL Character(1) VARCHAR2(1) NOT NULL Flag for indicating setup applies to all templates

Y/N Table Edit

Default Value: Y

8 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating
9 DESIRED_DIST_PCT Number(6,2) DECIMAL(5,2) NOT NULL Desired Distribution