BUDGET_IDBUDGET_START_DTTREE_NODE_NUMCLC=Calculated
CME=Completed with Errors
CMP=Completed
CNF=Confirmed
INP=In Progress
PSB=Pushed Back
RTL=Ready to Load
SUB=Submitted
WCS_ECM_NOD_VW(SQL View) |
Index Back |
|---|---|
Main Node RecordParent Node Record WCS. All groups roll up to this record. |
| SELECT N.BUDGET_ID ,N.BUDGET_START_DT , N.TREE_NODE_NUM , N.TREE_NODE_NUM_END , N.TREE_LEVEL_NUM , N.TREE_NODE , N.DESCR , N.WCS_NODE_STATUS , N.WCS_STATUS_DTTM , N.WCS_TOT_COUNT , N.WCS_TOT_SALARIES , N.WCS_DIR_COUNT , N.WCS_DIR_SALARIES , ' ' FROM PS_WCS_ECM_NOD_STS N |
| # | 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 | TREE_NODE_NUM_END | Number(10,0) | DECIMAL(10) NOT NULL | Internal ending node range number |
| 5 | TREE_LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Parent tree level if this is a part of the PSTREEBRANCH record |
| 6 | TREE_NODE | Character(20) | VARCHAR2(20) NOT NULL | Node name |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | 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 |
| 9 | WCS_STATUS_DTTM | DateTime(26) | TIMESTAMP | Status Date/Time Stamp |
| 10 | WCS_TOT_COUNT | Number(6,0) | INTEGER NOT NULL | Total Employees in Node (direct and indirect) |
| 11 | WCS_TOT_SALARIES | Number(22,6) | DECIMAL(21,6) NOT NULL | Total Employee Salaries in Node (direct and indirect) |
| 12 | WCS_DIR_COUNT | Number(6,0) | INTEGER NOT NULL | Total Direct Reports in Node |
| 13 | WCS_DIR_SALARIES | Number(22,6) | DECIMAL(21,6) NOT NULL | Total Direct Reports Salaries in Node |
| 14 | WBS_ID | Character(15) | VARCHAR2(15) NOT NULL | WBS ID |