BUDGET_IDBUDGET_START_DTTREE_NODE_NUMEMPLIDEMPL_RCDEMPLID_ASSIGN_TOLANGUAGE_CDWCS_ECM_WD_SLNG(SQL View) |
Index Back |
|---|---|
Comp Cycle Worker Det LNG SRCHCompensation Cycle Manage Worker Detail Language Search Record |
| SELECT NSTS.BUDGET_ID , NSTS.BUDGET_START_DT , NSTS.TREE_NODE_NUM , CFG.DESCR , CFG.DESCR20 , DMG.EMPLID , DMG.EMPL_RCD , ACSS.EMPLID , CFG.LANGUAGE_CD FROM PS_WCS_ECM_NOD_STS NSTS , PS_WCS_CYC_CFG_LNG CFG , PS_WCS_ECM_EE_DMG DMG , PS_WCS_ECM_ACCESS ACSS WHERE NSTS.BUDGET_ID = CFG.BUDGET_ID AND NSTS.BUDGET_START_DT = CFG.BUDGET_START_DT AND CFG.BUDGET_ID = DMG.BUDGET_ID AND CFG.BUDGET_START_DT = DMG.BUDGET_START_DT AND NSTS.TREE_NODE_NUM = DMG.TREE_NODE_NUM AND ACSS.BUDGET_ID = CFG.BUDGET_ID AND ACSS.BUDGET_START_DT = CFG.BUDGET_START_DT AND ACSS.WCS_SP_ACCESS_TYPE = 'C' AND ACSS.TREE_NODE_NUM = 1 |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCR20 | Character(20) | VARCHAR2(20) NOT NULL | Description |
| 6 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 7 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 8 | EMPLID_ASSIGN_TO |
Character(11) | VARCHAR2(11) NOT NULL | Used for Interest List to determine who the Profile is assigned to |
| 9 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |