TC_PLAN_IDPrompt Table: TC_PLAN
EFFDTDefault Value: %Date
Prompt Table: TC_PLAN_VW
COMPENSATION_IDPrompt Table: TC_COMPADHOC_VW
TC_COMP_SOURCE_IDPrompt Table: TC_CMPSRCADH_VW
TC_PLAN_COMP_VW(SQL View) |
Index Back |
|---|---|
Total Comp EE Search ViewTotal Comp EE Search View |
| SELECT A.TC_PLAN_ID , A.EFFDT , C.COMPENSATION_ID , C.TC_COMP_SOURCE_ID FROM PS_TC_PLAN A , PSTREELEAF B , PS_TC_SRC_COMPIDS C , PS_TC_COMP_SOURCE E WHERE A.TREE_NAME = B.TREE_NAME AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PSTREELEAF D WHERE D.TREE_NAME = B.TREE_NAME AND D.EFFDT <= A.EFFDT) AND B.RANGE_FROM <> ' ' AND B.RANGE_FROM = B.RANGE_TO AND B.RANGE_FROM = C.COMPENSATION_ID AND C.TC_COMP_SOURCE_ID = E.TC_COMP_SOURCE_ID AND E.DATA_SOURCE = 'AE' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Total Comp Plan ID
Prompt Table: TC_PLAN |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %Date Prompt Table: TC_PLAN_VW |
| 3 | COMPENSATION_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Compensation ID
Prompt Table: TC_COMPADHOC_VW |
| 4 | TC_COMP_SOURCE_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Compensation Source
Prompt Table: TC_CMPSRCADH_VW |