TC_MCOP_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	TC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Total Comp Plan ID Prompt Table: TC_PLAN
3	TC_PLAN_EFFDT	Date(10)	DATE NOT NULL	Total Comp Plan Effective Date Default Value: %date Prompt Table: TC_PLAN_VW
4	COMPENSATION_ID	Character(10)	VARCHAR2(10) NOT NULL	Compensation ID
5	TC_COMP_SOURCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Compensation Source
6	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
7	THRU_DATE	Date(10)	DATE NOT NULL	Thru Date Default Value: TC_PLAN.THRU_DATE
8	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
9	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Default Value: JOB.EMPL_RCD
10	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
11	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
12	MCOP_CURR_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
13	LMS_MCOP_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Compensation Frequency
14	LMS_MCOP_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Comp Percent
15	LMS_MCOP_RATE_PTS	Number(5,0)	INTEGER NOT NULL	Comp Rate Points
16	LMS_MCOP_FTE_IND	Character(1)	VARCHAR2(1) NOT NULL	Apply FTE for Annualization
17	LMS_MCOP_RATECDGRP	Character(6)	VARCHAR2(6) NOT NULL	Rate Code Group Name
18	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
19	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
20	RATE_CODE_CLASS	Character(6)	VARCHAR2(6) NOT NULL	Defines classes of rate codes. A rate code class can be used to bundle and group rate codes defined in the Comp Rate Code Table.
21	LMS_MCOP_AMT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Compensation Amount
22	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.