HR_SS_TC_PLN_VW (SQL View)	Index Back
Total Compensation Plan View Review Total Compensation Self Service Transaction: This view returns the TC plan edited by the Self Service Transaction. This view must return only ONE row.

HR_SS_TC_PLN_VW

(SQL View)

Total Compensation Plan View

Review Total Compensation Self Service Transaction: This view returns the TC plan edited by the Self Service Transaction. This view must return only ONE row.

SELECT A.TC_PLAN_ID , A.FROM_DATE , A.THRU_DATE , A.DESCR50 , A.BASE_CURRENCY , A.RT_TYPE , A.TC_FREQ FROM PS_TC_PLAN A WHERE A.TC_PLAN_ID = 'SSTCPLAN' AND %EffdtCheck(TC_PLAN, A, %currentdatein)

Related Language Record: HR_SSTCPLNVWLNG

# 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 FROM_DATE Date(10) DATE NOT NULL From Date

3 THRU_DATE Date(10) DATE NOT NULL Thru Date

4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

5 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL Base Currency

6 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL

7 TC_FREQ Character(1) VARCHAR2(1) NOT NULL Period Frequency
A=Annually
M=Monthly
Q=Quarterly

#	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	FROM_DATE	Date(10)	DATE NOT NULL	From Date
3	THRU_DATE	Date(10)	DATE NOT NULL	Thru Date
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
5	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Base Currency
6	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. Prompt Table: RT_TYPE_TBL
7	TC_FREQ	Character(1)	VARCHAR2(1) NOT NULL	Period Frequency A=Annually M=Monthly Q=Quarterly