BUDGET_IDBUDGET_START_DTTREE_NODE_NUMMANAGER_IDWCS_SP_ACCESS_TYPEA=Confirmer
C=Compensation Adminstrator
R=Reviewer
S=Submitter
LANGUAGE_CDWCS_ECM_MSSVLNG(SQL View) |
Index Back |
|---|---|
View of Node Status Tbl (Lang)Related Language record for WCS_ECM_MSS_VW View of Node Status Table (WCS_ECM_NOD_STS) used as the search record for the MSS Summary (WCS_ECM_MSS_SUM) page. |
| SELECT STSL.BUDGET_ID , STSL.BUDGET_START_DT , STSL.TREE_NODE_NUM , ACSS.EMPLID , ACSS.WCS_SP_ACCESS_TYPE , STSL.LANGUAGE_CD , STSL.DESCR FROM PS_WCS_NOD_STS_LNG STSL ,PS_WCS_ECM_ACCESS ACSS ,PS_WCS_ECM_CYC_CFG CFG WHERE STSL.BUDGET_ID = ACSS.BUDGET_ID AND STSL.BUDGET_START_DT = ACSS.BUDGET_START_DT AND STSL.TREE_NODE_NUM BETWEEN ACSS.TREE_NODE_NUM AND ACSS.TREE_NODE_NUM_END AND STSL.BUDGET_ID = CFG.BUDGET_ID AND STSL.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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |