TC_PLAN_IDEFFDTEXTRACT_PROGRAMTC_PLAN_EXTRACT(SQL View) |
Index Back |
|---|---|
Extract Program prompt for TCThis is used in the extract run control for Total Compensation |
| SELECT DISTINCT A.TC_PLAN_ID, A.EFFDT, E.EXTRACT_PROGRAM, F.DESCR FROM PS_TC_PLAN A, PSTREELEAF B, PS_TC_COMP_DEFN C, PS_TC_SRC_COMPIDS D, PS_TC_COMP_SOURCE E, PS_AE_APPL_TBL F WHERE A.TREE_NAME = B.TREE_NAME AND B.RANGE_FROM <> ' ' AND B.RANGE_FROM = B.RANGE_TO AND B.RANGE_FROM = C.COMPENSATION_ID AND C.COMPENSATION_ID = D.COMPENSATION_ID AND D.TC_COMP_SOURCE_ID = E.TC_COMP_SOURCE_ID AND E.EXTRACT_PROGRAM = F.AE_APPL_ID AND F.AE_PRODUCT = 'HR' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Total Comp Plan ID |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | EXTRACT_PROGRAM |
Character(12) | VARCHAR2(12) NOT NULL | Extract Program |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |