BUDGET_IDBUDGET_START_DTTREE_NODE_NUMWCS_AWE_DTL_VW(SQL View) |
Index Back |
|---|---|
Proposal InformationUsed in HTML email approvals for compensation cycles. |
| SELECT CYC.BUDGET_ID , CYC.BUDGET_START_DT , HDR.TREE_NODE_NUM , ' ' , ' ' , %Sql(HR_HT_EMAIL_DATE,CYC.BUDGET_START_DT) , ' ' , 000.000000 , 000.000000 , 000.00 , 000.00 , 000.000000 , CYC.CURRENCY_CD , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' 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_GROUP_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Group or Node Description |
| 5 | WCS_CYCLE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Cycle Description |
| 6 | DESCR25 | Character(25) | VARCHAR2(25) NOT NULL | Short description |
| 7 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 8 | WCS_TOT_A_AMT | Number(22,6) | DECIMAL(21,6) NOT NULL | Total Adjusted Amount in Node (direct and indirect) |
| 9 | WCS_TOT_P_AMT | Number(22,6) | DECIMAL(21,6) NOT NULL | Total Proposed Amount in Node (direct and indirect) |
| 10 | WCS_DSP_PCT_3 | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Workstrategy, Inc - eComp+ |
| 11 | WCS_DSP_PCT_2 | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | New Percent in Range |
| 12 | WCS_DSP_AMT_4 | Signed Number(23,6) | DECIMAL(21,6) NOT NULL | Display Amount |
| 13 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 14 | WCS_AMT_DESCR01 | Character(20) | VARCHAR2(20) NOT NULL | Used to display formatted amounts. |
| 15 | WCS_AMT_DESCR02 | Character(20) | VARCHAR2(20) NOT NULL | Used to display formatted amounts. |
| 16 | WCS_AMT_DESCR03 | Character(20) | VARCHAR2(20) NOT NULL | Used to display formatted amounts. |
| 17 | WCS_CHAR_AMT01 | Character(30) | VARCHAR2(30) NOT NULL | Character field used to display formatted amounts. |
| 18 | WCS_CHAR_AMT02 | Character(30) | VARCHAR2(30) NOT NULL | Character field used to display formatted amounts. |
| 19 | WCS_CHAR_AMT03 | Character(30) | VARCHAR2(30) NOT NULL | Character field used to display formatted amounts. |