BUDGET_IDBUDGET_START_DTTREE_NODE_NUMMANAGER_IDLANGUAGE_CDWCS_ECM_MTX_LVW(SQL View) |
Index Back |
|---|---|
WCS - Manage Transations LngLanguage Search Record for Manage Transactions Component |
| SELECT STSL.BUDGET_ID , STSL.BUDGET_START_DT , STSL.TREE_NODE_NUM , ACSS.EMPLID , 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 = ACSS.TREE_NODE_NUM AND STSL.BUDGET_ID = CFG.BUDGET_ID AND STSL.BUDGET_START_DT = CFG.BUDGET_START_DT AND ACSS.WCS_SP_ACCESS_TYPE = 'C' 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |