PROCESS_INSTANCEGB_GROUP_IDTC_COMP_SOURCE_IDCOMPENSATION_IDVC_PLAN_IDVC_PAYOUT_PRD_IDA=Ad Hoc Award
E=Empl VC Record
G=Empl VC Record with Groups
T=Define Tree/Group
C=Completed
S=Start
TC_VCRUNCTL_TAO(SQL Table) |
Index Back |
|---|---|
TC VC RunctlTC VC Runctl |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 3 | TC_COMP_SOURCE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Compensation Source |
| 4 | COMPENSATION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Compensation ID |
| 5 | VC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | VC Plan ID |
| 6 | VC_PAYOUT_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL | Payout Period ID |
| 7 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 8 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 9 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 10 | TREE_EFFDT | Date(10) | DATE | Effective date of the Tree |
| 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 |
| 12 | CAL_TARWARD_FLG | Character(1) | VARCHAR2(1) NOT NULL | Calculate Target Award |
| 13 | TC_EXTRACT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Total Comp Extract Status
C=Completed S=Start |