WCS_EE_VC_VW

(SQL View)
 Index Back

Employee VC View

Record stores variable compensation plan related data for each employee - view of WCS_ECM_EE_VC record

SELECT BUDGET_ID , BUDGET_START_DT , TREE_NODE_NUM , EMPLID , EMPL_RCD , VC_PLAN_ID , WCS_VC_FLG , WCS_EE_STATUS , WCS_STATUS_DTTM , WCS_ECM_EXCLUDED , WCS_T_PCT , WCS_C_PCT , WCS_T_AMT , WCS_C_AMT , WCS_A_AMT , WCS_P_AMT FROM PS_WCS_ECM_EE_VC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUDGET_ID Character(10) VARCHAR2(10) NOT NULL Budget ID
2 BUDGET_START_DT Date(10) DATE NOT NULL Budget Start Date
3 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
6 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID

Prompt Table: VC_PLAN_TBL

7 WCS_VC_FLG Character(1) VARCHAR2(1) NOT NULL Flag Indicating Employee Exists on VC_AWARD Table

Y/N Table Edit

8 WCS_EE_STATUS Character(3) VARCHAR2(3) NOT NULL Employee Status Indicator
BYP=Bypass
LDE=Load Error
PND=Pending
PRC=Processed
9 WCS_STATUS_DTTM DateTime(26) TIMESTAMP Status Date/Time Stamp
10 WCS_ECM_EXCLUDED Character(1) VARCHAR2(1) NOT NULL Employee Exclusion Flag

Y/N Table Edit

Default Value: N

11 WCS_T_PCT Number(6,2) DECIMAL(5,2) NOT NULL Employee Targeted Percentage
12 WCS_C_PCT Number(6,2) DECIMAL(5,2) NOT NULL Calculated Percent
13 WCS_T_AMT Number(16,6) DECIMAL(15,6) NOT NULL Employee Target Amount
14 WCS_C_AMT Number(16,6) DECIMAL(15,6) NOT NULL Calculated Amount
15 WCS_A_AMT Number(16,6) DECIMAL(15,6) NOT NULL Adjusted Amount
16 WCS_P_AMT Number(16,6) DECIMAL(15,6) NOT NULL Employee Proposed Amount