VC_ALLOC_AET(SQL Table) |
Index Back |
|---|---|
VC Determine Alloc State RecThis record is the 'state' record for the Determine Allocations Application Engine program 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 | VC_TC_FLAG | Character(2) | VARCHAR2(2) NOT NULL |
Var Comp/Total Comp Flag
TC=Total Compensation VC=Variable Compensation |
| 7 | VC_VALUATION_ID | Character(8) | VARCHAR2(8) NOT NULL | Valuation ID |
| 8 | CAL_TARWARD_FLG | Character(1) | VARCHAR2(1) NOT NULL | Calculate Target Award |
| 9 | 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 |
| 10 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 11 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 12 | VC_GOAL_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Plan Goal Type
G=Weighted Goals M=Goals Matrix |
| 13 | VC_PAYFORMULA_SQL | Character(254) | VARCHAR2(254) NOT NULL | Pay Formula SQL |
| 14 | VC_PAYFORMULA_ID | Character(10) | VARCHAR2(10) NOT NULL | Payout Formula ID |
| 15 | FREQUENCY_ID | Character(5) | VARCHAR2(5) NOT NULL | Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency. |
| 16 | RATE_CODE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Is Rate Code Overridable? |
| 17 | VC_CALC_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
Calculation Source
M=Manual Calculation N=System - Minimum S=System Calculated X=System - Maximum |
| 18 | COMP_RATECD | Character(6) | VARCHAR2(6) NOT NULL | Comp Rate Code |
| 19 | SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 20 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 21 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 22 | SCORE | Number(7,2) | DECIMAL(6,2) NOT NULL | Test Score |
| 23 | FROM_CLAUSE | Character(253) | VARCHAR2(253) NOT NULL | Scenario From Clause |
| 24 | VC_WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 25 | CONTINUE_AE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Continue AE Processing flag |
| 26 | IF_FLAG | Character(1) | VARCHAR2(1) NOT NULL | If flag |
| 27 | VC_TREE_DT | Date(10) | DATE | VC_TREE_DT |
| 28 | VC_EFFDT | Date(10) | DATE | Effective Date |
| 29 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 30 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 31 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 32 | AWARD_VALUE | Number(19,6) | DECIMAL(18,6) NOT NULL | Award Value |
| 33 | VC_AWARD_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Award Type
A=Actual M=Matrix N=Minimum T=Target X=Maximum |
| 34 | VC_ROUND_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Rounding Rule
D=Round Down S=Standard Rounding U=Round Up |
| 35 | DEC_PLACES | Number(3,0) | SMALLINT NOT NULL | Number of Decimal Places |
| 36 | JOB_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |