TC_EE_COMP

(SQL Table)
Index Back

TC EE Compensation

TC EE Compensation

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 TC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Total Comp Plan ID

Prompt Table: TC_PLAN_VW1

4 TC_PLAN_EFFDT Date(10) DATE Total Comp Plan Effective Date

Prompt Table: TC_PLAN_VW

5 FROM_DATE Date(10) DATE From Date
6 THRU_DATE Date(10) DATE Thru Date
7 TC_MEASURE Character(1) VARCHAR2(1) NOT NULL Amount Type
C=Compensation Amount
P=Payroll Amount

Default Value: C

8 TC_REFRESH_BTN Character(1) VARCHAR2(1) NOT NULL Refresh