TREE_SETIDTREE_EFFDTTREE_NAMEPARENT_PROJ_LEVELPARENT_PROJECT_IDCHILD_PROJ_LEVELPROJECT_IDPROJ_XCHILD_VW(SQL View) |
Index Back |
|---|---|
Child Project ID |
| SELECT A.TREE_SETID, A.TREE_EFFDT, A.TREE_NAME, A.PARENT_PROJ_LEVEL, A.PARENT_PROJECT_ID, A.CHILD_PROJ_LEVEL, A.PROJECT_ID FROM PS_PROJ_TREE_SRCH A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TREE_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Tree SetID |
| 2 | TREE_EFFDT |
Date(10) | DATE | Effective date of the Tree |
| 3 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 4 | PARENT_PROJ_LEVEL |
Number(3,0) | SMALLINT NOT NULL | Parent Project Level |
| 5 | PARENT_PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Parent Project ID |
| 6 | CHILD_PROJ_LEVEL |
Number(3,0) | SMALLINT NOT NULL | Child Project Level |
| 7 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |