GRP_ALLOC2_VW

(SQL View)
 Index Back

Group Allocation view

Group Allocation view

SELECT GRP_ALLOCATION.VC_PLAN_ID ,GRP_ALLOCATION.VC_PAYOUT_PRD_ID ,GRP_ALLOCATION.GB_GROUP_ID ,TREENODE.PARENT_NODE_NAME ,VC_PLAN_TBL.TREE_NAME ,GRP_ALLOCATION.CURRENCY_CD ,GRP_ALLOCATION.VC_ORIGINAL_ALLOC ,GRP_ALLOCATION.VC_BALANCE_ALLOC ,GRP_ALLOCATION.VC_RESERVE_BALANCE ,GRP_AWARD.VC_TARGET_VALUE ,GRP_AWARD.VC_GRP_PERF_FACTOR ,PAYOUT_PRD_TBL.VC_ORG_PERF_FACTOR ,GRP_ALLOCATION.NUMBER_OF_EMPL ,VC_PLAN_TBL.VC_ORG_PLAN_WEIGHT ,VC_PLAN_TBL.VC_GRP_PLAN_WEIGHT ,VC_PLAN_TBL.VC_IND_PLAN_WEIGHT FROM PS_VC_GRP_ALLOC GRP_ALLOCATION , PS_VC_GRP_AWARD GRP_AWARD , PS_VC_PLAN_EFFDT VC_PLAN_TBL , PS_VC_PAYPRD_TBL PAYOUT_PRD_TBL , PSTREENODE TREENODE WHERE GRP_ALLOCATION.VC_PLAN_ID = VC_PLAN_TBL.VC_PLAN_ID AND VC_PLAN_TBL.VC_PLAN_ID = PAYOUT_PRD_TBL.VC_PLAN_ID AND PAYOUT_PRD_TBL.VC_PLAN_ID = GRP_AWARD.VC_PLAN_ID AND GRP_ALLOCATION.VC_PAYOUT_PRD_ID = PAYOUT_PRD_TBL.VC_PAYOUT_PRD_ID AND GRP_AWARD.VC_PAYOUT_PRD_ID = PAYOUT_PRD_TBL.VC_PAYOUT_PRD_ID AND GRP_AWARD.GB_GROUP_ID = GRP_ALLOCATION.GB_GROUP_ID AND VC_PLAN_TBL.EFFDT = ( SELECT MAX(EFFDT) FROM PS_VC_PLAN_EFFDT VC_PLAN_TBL2 WHERE VC_PLAN_TBL.VC_PLAN_ID = VC_PLAN_TBL2.VC_PLAN_ID AND VC_PLAN_TBL.EFF_STATUS = 'A' AND VC_PLAN_TBL2.EFFDT <= PAYOUT_PRD_TBL.PRD_END_DT) AND VC_PLAN_TBL.TREE_NAME = TREENODE.TREE_NAME AND TREENODE.EFFDT = ( SELECT MAX(EFFDT) FROM PSTREENODE TREENODE1 WHERE TREENODE1.SETID = TREENODE.SETID AND TREENODE1.SETCNTRLVALUE= TREENODE.SETCNTRLVALUE AND TREENODE1.TREE_NAME = TREENODE.TREE_NAME AND TREENODE1.EFFDT <= VC_PLAN_TBL.EFFDT AND TREENODE1.TREE_NODE = TREENODE.TREE_NODE) AND GRP_ALLOCATION.GB_GROUP_ID = TREENODE.TREE_NODE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID
2 VC_PAYOUT_PRD_ID Character(10) VARCHAR2(10) NOT NULL Payout Period ID
3 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
4 PARENT_NODE_NAME Character(20) VARCHAR2(20) NOT NULL Name of parent node
5 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
7 VC_ORIGINAL_ALLOC Number(19,6) DECIMAL(18,6) NOT NULL Original Allocation
8 VC_BALANCE_ALLOC Signed Number(20,6) DECIMAL(18,6) NOT NULL Balance Allocation
9 VC_RESERVE_BALANCE Number(19,6) DECIMAL(18,6) NOT NULL Reserve Balance
10 VC_TARGET_VALUE Number(19,6) DECIMAL(18,6) NOT NULL Target Value
11 VC_GRP_PERF_FACTOR Number(20,4) DECIMAL(19,4) NOT NULL Group Perf Factor
12 VC_ORG_PERF_FACTOR Number(20,4) DECIMAL(19,4) NOT NULL Organizational Performance Factor field used in variable compensation.
13 NUMBER_OF_EMPL Number(6,0) INTEGER NOT NULL Number of Employees
14 VC_ORG_PLAN_WEIGHT Number(6,2) DECIMAL(5,2) NOT NULL Org Goal Weight
15 VC_GRP_PLAN_WEIGHT Number(6,2) DECIMAL(5,2) NOT NULL Group Goal Weight
16 VC_IND_PLAN_WEIGHT Number(6,2) DECIMAL(5,2) NOT NULL Ind Goal Weight