BUDGET_IDBUDGET_START_DTEMPL_ID_RCDTREE_NODE_NUMTREE_BRANCHPrompt Table: PERSON_NAME
A=Confirmer
C=Compensation Adminstrator
R=Reviewer
S=Submitter
Default Value: S
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
WCS_ECM_ACS2_VW(SQL View) |
Index Back |
|---|
| SELECT ACS.BUDGET_ID , ACS.BUDGET_START_DT , ACS.EMPL_ID_RCD , TN.TREE_NODE_NUM , TN.TREE_BRANCH , TN.TREE_LEVEL_NUM , TN.TREE_NODE_NUM_END , TN.PARENT_NODE_NUM , ACS.NAME_DISPLAY , ACS.EMPLID , 'S' , 'Y' , ' ' , TN.TREE_LEVEL_NUM , TN.TREE_LEVEL_NUM , TN.TREE_LEVEL_NUM , 0 , 0 , 0 , 0 , 0 , 0 FROM PS_WCS_ECM_ACS_VW ACS , PSTREENODE TN WHERE ACS.TREE_NAME = TN.TREE_NAME AND ACS.EMPL_ID_RCD = TN.SETCNTRLVALUE |
| # | 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 | EMPL_ID_RCD |
Character(20) | VARCHAR2(20) NOT NULL | Job concatenated key. |
| 4 | TREE_NODE_NUM |
Number(10,0) | DECIMAL(10) NOT NULL | Internal beginning node range number |
| 5 | TREE_BRANCH |
Character(20) | VARCHAR2(20) NOT NULL | Tree Branch Name |
| 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 | PARENT_NODE_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Parent Node Number |
| 9 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 10 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON_NAME |
| 11 | WCS_SP_ACCESS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Access Type/Role
A=Confirmer C=Compensation Adminstrator R=Reviewer S=Submitter Default Value: S |
| 12 | PRIMARY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Primary Flag
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 13 | WBS_ID | Character(15) | VARCHAR2(15) NOT NULL | WBS ID |
| 14 | LEVEL1 | Number(5,0) | INTEGER NOT NULL | Level 1 |
| 15 | LEVEL2 | Number(5,0) | INTEGER NOT NULL | Level 2 |
| 16 | LEVEL3 | Number(5,0) | INTEGER NOT NULL | Level 3 |
| 17 | LEVEL4 | Number(5,0) | INTEGER NOT NULL | Level 4 |
| 18 | LEVEL5 | Number(5,0) | INTEGER NOT NULL | Level 5 |
| 19 | LEVEL6 | Number(5,0) | INTEGER NOT NULL | Level 6 |
| 20 | LEVEL7 | Number(5,0) | INTEGER NOT NULL | Level 7 |
| 21 | LEVEL8 | Number(5,0) | INTEGER NOT NULL | Level 8 |
| 22 | LEVEL9 | Number(5,0) | INTEGER NOT NULL | Level 9 |