FROM_DATETHRU_DATEVC_PLAN_IDVC_PAYOUT_PRD_IDGB_GROUP_IDA=Ad Hoc Award
E=Empl VC Record
G=Empl VC Record with Groups
T=Define Tree/Group
TC_EXCEL_GRP_TM(SQL Table) |
Index Back |
|---|---|
TC Excel Variable CompTC Excel Variable Comp |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FROM_DATE |
Date(10) | DATE | From Date |
| 2 | THRU_DATE |
Date(10) | DATE | Thru Date |
| 3 | VC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | VC Plan ID |
| 4 | VC_PAYOUT_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL | Payout Period ID |
| 5 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 6 | VC_EFFDT | Date(10) | DATE | Effective Date |
| 7 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 8 | TREE_EFFDT | Date(10) | DATE | Effective date of the Tree |
| 9 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 10 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 11 | VC_PLAN_MEM_CRIT | Character(2) | VARCHAR2(2) NOT NULL |
Plan Member Criteria
A=Ad Hoc Award E=Empl VC Record G=Empl VC Record with Groups T=Define Tree/Group |