WCS_TGT_TREE_NAMEWCS_TGT_EFFDTWCS_CMPR_TRE_VE(SQL View) |
Index Back |
|---|
| SELECT TREE_NAME , EFFDT FROM PS_WCS_POP_TREE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | WCS_TGT_TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Target Tree Name |
| 2 | WCS_TGT_EFFDT |
Date(10) | DATE | Target Effective Date |