VC_ELIG_PRO_AET(SQL Table) |
Index Back |
|---|---|
VC Elig/Pro State RecordThis record is the 'state' record for the Eligibility/Proration Application Engine application in Variable Compensation. This records stores the process instance, all input parameters from the run control, as well as any fields requiring 'working' storage during processing. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | VC_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL | VC Plan ID |
| 5 | VC_PAYOUT_PRD_ID | Character(10) | VARCHAR2(10) NOT NULL | Payout Period ID |
| 6 | AS_OF_DATE | Date(10) | DATE | As of Date |
| 7 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 8 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 9 | THRUDATE | Date(10) | DATE | End Date |
| 10 | FROMDATE | Date(10) | DATE | From 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 |
| 12 | VC_GOAL_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Plan Goal Type
G=Weighted Goals M=Goals Matrix |
| 13 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 14 | VC_TREE_DT | Date(10) | DATE | VC_TREE_DT |
| 15 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 16 | VERSIONGBQDM | Number(10,0) | DECIMAL(10) NOT NULL | Version Number |
| 17 | VC_PRCS_COMPLETE | Character(1) | VARCHAR2(1) NOT NULL | 27 July 1999 - Suki Binpal Field to indicate if Variable Comp eligibility process has been run. (Y/N) |
| 18 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 19 | VC_PRORATION_IND | Character(2) | VARCHAR2(2) NOT NULL | Calculate Proration |
| 20 | PRORATE_FACTOR | Number(8,3) | DECIMAL(7,3) NOT NULL | Prorate Factor |
| 21 | VC_ELIG_PRO_DAYS | Number(8,3) | DECIMAL(7,3) NOT NULL | Days Eliglble In Period |
| 22 | VC_ORG_PLAN_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Org Goal Weight |
| 23 | VC_GRP_PLAN_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Group Goal Weight |
| 24 | VC_IND_PLAN_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Ind Goal Weight |
| 25 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 26 | VC_PRT_RULE_ID | Character(8) | VARCHAR2(8) NOT NULL | Users have the ability to define proration percentages for different employee statuses in the system. A Rule ID holds the definition to be created centrally and be shared between different VC Plans instead of having to redefine the same propration percentage on each plan. |
| 27 | VC_PRORATION_FREQ | Character(1) | VARCHAR2(1) NOT NULL |
Proration Frequency
D=Calendar Days K=By Workdays M=Monthly W=Weekly |
| 28 | VC_WRK_DY_RULE_ID | Character(8) | VARCHAR2(8) NOT NULL | A Working Days Rule ID defines the day pattern for a week. The definition of a day is governed by the value in the VC_DAY_FACTOR field. A '0' (zero) value in the factor would mean a Non-Working day, and a '1' would be identified as a full working day. |
| 29 | DAY_OF_WK | Character(1) | VARCHAR2(1) NOT NULL |
Day of the Week
1=Sunday 2=Monday 3=Tuesday 4=Wednesday 5=Thursday 6=Friday 7=Saturday |
| 30 | VC_TOTAL_DAYS | Number(7,3) | DECIMAL(6,3) NOT NULL | Total Days is required for performing the Eligibitity Process in VC |