GP_PKG_IDVC_PLAN_IDEFFDTA=Active
I=Inactive
3=Three
5=Five
7=Seven
GP_NRP_VCPLN_AD(SQL Table) |
Index Back |
|---|---|
Effective-dated Plan TableUsed to move data using ADS for PUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | VC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | VC Plan ID |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | VC_VALUATION_ID | Character(8) | VARCHAR2(8) NOT NULL | Valuation ID |
| 6 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 7 | VC_ORG_PLAN_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Org Goal Weight |
| 8 | VC_GRP_PLAN_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Group Goal Weight |
| 9 | VC_IND_PLAN_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Ind Goal Weight |
| 10 | VC_MTX_COLUMN | Character(2) | VARCHAR2(2) NOT NULL |
Nbr Matrix Columns
3=Three 5=Five 7=Seven |
| 11 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 12 | VC_PRORATION_IND | Character(2) | VARCHAR2(2) NOT NULL | Calculate Proration |
| 13 | VC_APPROVAL_IND | Character(2) | VARCHAR2(2) NOT NULL | Approve Awards |
| 14 | APPROVER_ID | Character(11) | VARCHAR2(11) NOT NULL | Approver Empl ID |
| 15 | GROSSUP | Character(1) | VARCHAR2(1) NOT NULL | Gross-Up |
| 16 | SEPCHK_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Separate check flag. |
| 17 | PIN_ERN_NUM | Number(8,0) | INTEGER NOT NULL | Pin Number Earning |