TC_EE_DETAIL (SQL Table)	Index Back
Transaction Rec for Total Comp Main Transaction Record used in Total Compensation processing. This stores detail compensation data summarized at a compensation id level which is defined by the user.

TC_EE_DETAIL

(SQL Table)

Transaction Rec for Total Comp

Main Transaction Record used in Total Compensation processing. This stores detail compensation data summarized at a compensation id level which is defined by the user.

# 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_COMP_DEFN

4 TC_COMP_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Compensation Source
Prompt Table: TC_COMP_SOURCE

5 THRU_DATE Date(10) DATE NOT NULL Thru Date
Default Value: TC_PLAN.THRU_DATE

6 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERS_SRCH_GBL

8 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
Default Value: JOB.EMPL_RCD

9 FROM_CURR_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

10 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

11 FROM_DATE Date(10) DATE NOT NULL From Date
Default Value: TC_PLAN.FROM_DATE

12 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Default Value: JOB.COMPANY

13 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: JOB.BUSINESS_UNIT

14 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID

15 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
Default Value: JOB.LOCATION

16 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID

17 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Default Value: JOB.DEPTID

18 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID

19 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

20 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
Default Value: JOB.POSITION_NBR

21 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary Set ID

22 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
Default Value: JOB.SAL_ADMIN_PLAN

23 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
Default Value: JOB.GRADE

24 STEP Number(2,0) SMALLINT NOT NULL Step
Default Value: JOB.STEP

25 VCOMP_FLAG Character(1) VARCHAR2(1) NOT NULL Variable Compensation Flag

26 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

27 EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category

28 FROM_COMP_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Compensation Amount

29 FROM_PAYROLL_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Payroll Amount

30 TO_COMP_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Converted Compensation Amount

31 TO_PAYROLL_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Converted Payroll Amount

32 SETID_LBR_AGRMNT Character(5) VARCHAR2(5) NOT NULL Labor Agreement SetID

#	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_COMP_DEFN
4	TC_COMP_SOURCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Compensation Source Prompt Table: TC_COMP_SOURCE
5	THRU_DATE	Date(10)	DATE NOT NULL	Thru Date Default Value: TC_PLAN.THRU_DATE
6	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERS_SRCH_GBL
8	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Default Value: JOB.EMPL_RCD
9	FROM_CURR_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
10	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
11	FROM_DATE	Date(10)	DATE NOT NULL	From Date Default Value: TC_PLAN.FROM_DATE
12	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Default Value: JOB.COMPANY
13	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: JOB.BUSINESS_UNIT
14	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
15	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Default Value: JOB.LOCATION
16	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
17	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Default Value: JOB.DEPTID
18	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID
19	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
20	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Default Value: JOB.POSITION_NBR
21	SETID_SALARY	Character(5)	VARCHAR2(5) NOT NULL	Salary Set ID
22	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan Default Value: JOB.SAL_ADMIN_PLAN
23	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade Default Value: JOB.GRADE
24	STEP	Number(2,0)	SMALLINT NOT NULL	Step Default Value: JOB.STEP
25	VCOMP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Variable Compensation Flag
26	LABOR_AGREEMENT	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement
27	EMPL_CTG	Character(6)	VARCHAR2(6) NOT NULL	Employee Category
28	FROM_COMP_AMT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Compensation Amount
29	FROM_PAYROLL_AMT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Payroll Amount
30	TO_COMP_AMT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Converted Compensation Amount
31	TO_PAYROLL_AMT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Converted Payroll Amount
32	SETID_LBR_AGRMNT	Character(5)	VARCHAR2(5) NOT NULL	Labor Agreement SetID