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 |