OPRIDRUN_CNTL_IDPrompt Table: VC_PAYPRD_TBL
Prompt Table: VC_PLAN_TBL
D=Detail
S=Summary
Default Value: S
Prompt Table: VC_EMPLAWRD_VW
A=Ad Hoc Award
E=Empl VC Record
G=Empl VC Record with Groups
T=Define Tree/Group
G=Weighted Goals
M=Goals Matrix
RC_VC_REPORTS(SQL Table) |
Index Back |
|---|---|
VC Reports Run ControlThis is the run control record to store input parameters for all of the reports run out of the Variable Compensation module. This record contains some fields that are report specific and will therefore not always be populated, depending upon which report is being run. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 4 | VC_PAYOUT_PRD_ID | Character(10) | VARCHAR2(10) NOT NULL |
Payout Period ID
Prompt Table: VC_PAYPRD_TBL |
| 5 | VC_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL |
VC Plan ID
Prompt Table: VC_PLAN_TBL |
| 6 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 7 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 8 | VC_TREE_DT | Date(10) | DATE | VC_TREE_DT |
| 9 | VC_REPORT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
VC Report Type
D=Detail S=Summary Default Value: S |
| 10 | FROMDATE | Date(10) | DATE | From Date |
| 11 | THRUDATE | Date(10) | DATE | End Date |
| 12 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: VC_EMPLAWRD_VW |
| 13 | VC_ORG_PLAN_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Org Goal Weight |
| 14 | VC_GRP_PLAN_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Group Goal Weight |
| 15 | VC_IND_PLAN_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Ind Goal Weight |
| 16 | SCORE | Number(7,2) | DECIMAL(6,2) NOT NULL | Test Score |
| 17 | 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 |
| 18 | VC_GOAL_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Plan Goal Type
G=Weighted Goals M=Goals Matrix |