VC_PLAN_IDPrompt Table: VC_PLAN_TBL
VC_PAYOUT_PRD_IDGB_GROUP_IDPrompt Table: GB_GROUP_TBL
FROM_QTYPrompt Table: VC_PAYFORM_VW
VC_PAY_SCHD_TAO(SQL Table) |
Index Back |
|---|---|
Elig/Proration Temp RecEligibility/Proration Process temporary record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL |
VC Plan ID
Prompt Table: VC_PLAN_TBL |
| 2 | VC_PAYOUT_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL | Payout Period ID |
| 3 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GB_GROUP_TBL |
| 4 | FROM_QTY |
Number(7,2) | DECIMAL(6,2) NOT NULL | From Quantity |
| 5 | TO_QTY | Number(7,2) | DECIMAL(6,2) NOT NULL | To Quantity |
| 6 | VC_PAYFORMULA_ID | Character(10) | VARCHAR2(10) NOT NULL |
Payout Formula ID
Prompt Table: VC_PAYFORM_VW |