PGM_GETPRNT_PRG(SQL View) |
Index Back |
|---|---|
Get project parent programThis view will select the parent program for each project. |
| SELECT B.BUSINESS_UNIT , B.PROJECT_ID , %Substring(A.PARENT_NODE_NAME, 1, 15) FROM PSTREENODE A , PS_PROJECT B , PS_BUS_UNIT_OPT_PC C WHERE %Substring(A.SETCNTRLVALUE, 1, 5) = B.BUSINESS_UNIT AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PROJECT_ID = A.TREE_NODE AND A.PARENT_NODE_NAME <> ' ' AND A.TREE_NAME = C.PGM_EPT_NAME AND A.EFFDT = ( SELECT MAX(D.EFFDT) FROM PSTREEDEFN D WHERE D.SETCNTRLVALUE = A.SETCNTRLVALUE AND D.TREE_NAME = A.TREE_NAME AND D.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 3 | PARENT_PROGRAM_ID | Character(15) | VARCHAR2(15) NOT NULL | Parent Program ID |