WCS_MSS_ACTY_VW

(SQL View)
 Index Back

Comp Manager Activities

Use this view to retrieve the Compensation Activities associated to a Manager for action.

SELECT ACC.EMPLID , CFG.BUDGET_ID , CFG.BUDGET_START_DT , STS.TREE_NODE_NUM , STS.WCS_NODE_STATUS , ACC.WCS_SP_ACCESS_TYPE , ACC.DELEGATOR_ID , CFG.EOAWPRCS_ID , HCDL.TRANSACTION_NAME FROM PS_WCS_ECM_CYC_CFG CFG , PS_WCS_ECM_NOD_STS STS , PS_WCS_ECM_ACCESS ACC , PS_WCS_HCDL_ACCESS HCDL WHERE CFG.BUDGET_ID = STS.BUDGET_ID AND CFG.BUDGET_ID = ACC.BUDGET_ID AND CFG.BUDGET_START_DT = STS.BUDGET_START_DT AND CFG.BUDGET_START_DT = ACC.BUDGET_START_DT AND ACC.TREE_NODE_NUM = STS.TREE_NODE_NUM AND CFG.WCS_CYCLE_STATUS IN ('OPN', 'FIN') AND ACC.WCS_SP_ACCESS_TYPE <> 'C' AND ACC.WCS_SP_ACCESS_TYPE = HCDL.WCS_SP_ACCESS_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 BUDGET_ID Character(10) VARCHAR2(10) NOT NULL Budget ID
3 BUDGET_START_DT Date(10) DATE Budget Start Date
4 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
5 WCS_NODE_STATUS Character(3) VARCHAR2(3) NOT NULL Node Status
CLC=Calculated
CME=Completed with Errors
CMP=Completed
CNF=Confirmed
INP=In Progress
PSB=Pushed Back
RTL=Ready to Load
SUB=Submitted
6 WCS_SP_ACCESS_TYPE Character(1) VARCHAR2(1) NOT NULL Access Type/Role
A=Confirmer
C=Compensation Adminstrator
R=Reviewer
S=Submitter
7 DELEGATOR_ID Character(11) VARCHAR2(11) NOT NULL Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.
8 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
9 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name