GP_NRP_VCPLN_VW(SQL View) |
Index Back |
|---|---|
VC Plan Effdt Table - NRP VwThis table will be used to move data from one database to another using the non rule packager process. |
| SELECT VC_PLAN_ID ,EFFDT ,EFF_STATUS ,VC_VALUATION_ID ,ERNCD ,VC_ORG_PLAN_WEIGHT ,VC_GRP_PLAN_WEIGHT ,VC_IND_PLAN_WEIGHT ,VC_MTX_COLUMN ,TREE_NAME ,VC_PRORATION_IND ,VC_APPROVAL_IND ,APPROVER_ID ,GROSSUP ,SEPCHK_FLAG ,PIN_ERN_NUM + 50000000 FROM PS_VC_PLAN_EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  VC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | VC Plan ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | VC_VALUATION_ID | Character(8) | VARCHAR2(8) NOT NULL |
Valuation ID
Prompt Table: VC_VALUE_TBL |
| 5 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL |
Earnings Code
Prompt Table: EARNINGS_TBL |
| 6 | VC_ORG_PLAN_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Org Goal Weight |
| 7 | VC_GRP_PLAN_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Group Goal Weight |
| 8 | VC_IND_PLAN_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Ind Goal Weight |
| 9 | VC_MTX_COLUMN | Character(2) | VARCHAR2(2) NOT NULL |
Nbr Matrix Columns
3=Three 5=Five 7=Seven |
| 10 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table: VC_TREE_PLAN_VW |
| 11 | VC_PRORATION_IND | Character(2) | VARCHAR2(2) NOT NULL |
Calculate Proration
Y/N Table Edit Default Value: N |
| 12 | VC_APPROVAL_IND | Character(2) | VARCHAR2(2) NOT NULL |
Approve Awards
Default Value: N |
| 13 | APPROVER_ID | Character(11) | VARCHAR2(11) NOT NULL |
Approver EmplID
Prompt Table: PERSON_NAME |
| 14 | GROSSUP | Character(1) | VARCHAR2(1) NOT NULL |
Gross-Up
Y/N Table Edit Default Value: N |
| 15 | SEPCHK_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Separate check flag.
Y/N Table Edit Default Value: N |
| 16 | PIN_ERN_NUM | Number(8,0) | INTEGER NOT NULL |
Pin Number Earning
Prompt Table: GP_ERN_SRCH |