WCS_PROPOSAL_VW

(SQL View)
 Index Back

Proposal Information

Used in fluid approvals for compensation cycles.

SELECT CYC.BUDGET_ID , CYC.BUDGET_START_DT , HDR.TREE_NODE_NUM , 000.000000 , 000.000000 , 000.00 , 000.00 , 000.000000 , CYC.CURRENCY_CD , 'Funded' , 'Proposed' , 'Balance' , ' ' , ' ' , ' ' FROM PS_WCS_ECM_CYC_CFG CYC , PS_WCS_AWE_NOD_HDR HDR WHERE CYC.BUDGET_ID = HDR.BUDGET_ID AND CYC.BUDGET_START_DT = HDR.BUDGET_START_DT

# 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 WCS_TOT_A_AMT Number(22,6) DECIMAL(21,6) NOT NULL Total Adjusted Amount in Node (direct and indirect)
5 WCS_TOT_P_AMT Number(22,6) DECIMAL(21,6) NOT NULL Total Proposed Amount in Node (direct and indirect)
6 WCS_DSP_PCT_3 Signed Number(7,2) DECIMAL(5,2) NOT NULL Workstrategy, Inc - eComp+
7 WCS_DSP_PCT_2 Signed Number(7,2) DECIMAL(5,2) NOT NULL New Percent in Range
8 WCS_DSP_AMT_4 Signed Number(23,6) DECIMAL(21,6) NOT NULL Display Amount
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
10 WCS_AMT_DESCR01 Character(20) VARCHAR2(20) NOT NULL Used to display formatted amounts.
11 WCS_AMT_DESCR02 Character(20) VARCHAR2(20) NOT NULL Used to display formatted amounts.
12 WCS_AMT_DESCR03 Character(20) VARCHAR2(20) NOT NULL Used to display formatted amounts.
13 WCS_CHAR_AMT01 Character(30) VARCHAR2(30) NOT NULL Character field used to display formatted amounts.
14 WCS_CHAR_AMT02 Character(30) VARCHAR2(30) NOT NULL Character field used to display formatted amounts.
15 WCS_CHAR_AMT03 Character(30) VARCHAR2(30) NOT NULL Character field used to display formatted amounts.