TREE_NAMETREE_EFFDTVC_TREE_CHANGE(SQL Table) |
Index Back |
|---|---|
Tree Change recordThis record is used by the VC_TREE_CHANGE Business Component. This component allows to update VC information according to the Tree manager modifications. Tree information modified by Tree manager are stored in this record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 2 | TREE_EFFDT |
Date(10) | DATE NOT NULL | Effective date of the Tree |
| 3 | EVENT_ID | Number(6,0) | INTEGER NOT NULL | Event Identification |
| 4 | TREE_NAME_OLD | Character(18) | VARCHAR2(18) NOT NULL | Old Tree Name for TREE_CHANGE PubSub message |
| 5 | EFFDT_OLD | Date(10) | DATE | Old Effective Date |
| 6 | VC_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL | VC Plan ID |