WCS_ECM_MSS_VW(SQL View) |
Index Back |
|---|---|
View of Node Status TableView of Node Status Table (WCS_ECM_NOD_STS) used as the search record for the MSS Summary (WCS_ECM_MSS_SUM) page. |
| SELECT STS.BUDGET_ID , STS.BUDGET_START_DT , STS.TREE_NODE_NUM , ACSS.EMPLID , ACSS.WCS_SP_ACCESS_TYPE , STS.TREE_LEVEL_NUM , STS.TREE_NODE_NUM_END , STS.TREE_NODE , STS.DESCR , STS.WCS_NODE_STATUS , STS.WCS_STATUS_DTTM , CFG.BUDGET_END_DT , ACSS.DELEGATOR_ID FROM PS_WCS_ECM_NOD_STS STS ,PS_WCS_ECM_ACCESS ACSS ,PS_WCS_ECM_CYC_CFG CFG WHERE STS.BUDGET_ID = ACSS.BUDGET_ID AND STS.BUDGET_START_DT = ACSS.BUDGET_START_DT AND STS.TREE_NODE_NUM BETWEEN ACSS.TREE_NODE_NUM AND ACSS.TREE_NODE_NUM_END AND STS.BUDGET_ID = CFG.BUDGET_ID AND STS.BUDGET_START_DT = CFG.BUDGET_START_DT AND CFG.WCS_CYCLE_STATUS IN ('OPN', 'FIN') |
| # | 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 | MANAGER_ID |
Character(11) | VARCHAR2(11) NOT NULL | Manager ID |
| 5 | WCS_SP_ACCESS_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Access Type/Role
A=Confirmer C=Compensation Adminstrator R=Reviewer S=Submitter |
| 6 | TREE_LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Parent tree level if this is a part of the PSTREEBRANCH record |
| 7 | TREE_NODE_NUM_END | Number(10,0) | DECIMAL(10) NOT NULL | Internal ending node range number |
| 8 | TREE_NODE | Character(20) | VARCHAR2(20) NOT NULL | Node name |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | 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 |
| 11 | WCS_STATUS_DTTM | DateTime(26) | TIMESTAMP | Status Date/Time Stamp |
| 12 | BUDGET_END_DT | Date(10) | DATE | Budget End Date |
| 13 | DELEGATOR_ID | Character(11) | VARCHAR2(11) NOT NULL | Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated. |