LMS_BCOMP_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LMS_SCENARIO_ID	Character(10)	VARCHAR2(10) NOT NULL	LMS - Scenario Id Prompt Table: LMS_SCENARIO
2	LMS_SCENARIO_DTTM	DateTime(26)	TIMESTAMP NOT NULL	Scenario Run DateTime
3	FROM_DATE	Date(10)	DATE NOT NULL	From Date
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Default Value: JOB.EMPL_RCD
6	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
7	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
8	MCOP_CURR_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
9	LMS_MCOP_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Compensation Frequency
10	LMS_MCOP_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Comp Percent
11	LMS_MCOP_RATE_PTS	Number(5,0)	INTEGER NOT NULL	Comp Rate Points
12	LMS_MCOP_FTE_IND	Character(1)	VARCHAR2(1) NOT NULL	Apply FTE for Annualization
13	LMS_MCOP_RATECDGRP	Character(6)	VARCHAR2(6) NOT NULL	Rate Code Group Name
14	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
16	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.
17	LMS_MCOP_AMT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Compensation Amount
18	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.