TC_BENEFITS_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance Default Value: 1
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	TC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Total Comp Plan ID
5	TC_PLAN_EFFDT	Date(10)	DATE	Total Comp Plan Effective Date
6	FROM_DATE	Date(10)	DATE	From Date
7	THRU_DATE	Date(10)	DATE	Thru Date
8	TC_RUN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Total Comp Extract Run Type D=Delete Run S=Standard Run
9	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
10	TC_COMP_SOURCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Compensation Source
11	COMPENSATION_ID	Character(10)	VARCHAR2(10) NOT NULL	Compensation ID
12	RUN_DTTM	DateTime(26)	TIMESTAMP	Run Date and Time
13	EXTRACT_PROGRAM	Character(12)	VARCHAR2(12) NOT NULL	Extract Program
14	FROM_DT_RUN	Date(10)	DATE	From Date From Run Control
15	THRU_DT_RUN	Date(10)	DATE	Thru Date from Run Control
16	CONTINUE_AE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Continue AE Processing flag
17	TC_FREQ	Character(1)	VARCHAR2(1) NOT NULL	Period Frequency A=Annually M=Monthly Q=Quarterly
18	TC_FREQ_FACTOR	Number(9,4)	DECIMAL(8,4) NOT NULL	Frequency Annual Factor
19	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Base Currency
20	CUR_EFFDT	Date(10)	DATE	Currency Effective Date
21	CUR_EFFDT_RUN	Date(10)	DATE	Currency Exchange Rate Effdt
22	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.
23	TC_FROZEN	Character(1)	VARCHAR2(1) NOT NULL	Plan Frozen N=No Y=Yes
24	CUR_EFFDT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Effective Date Flag E=Effective Date P=Period Thru Date
25	CAL_TARWARD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Calculate Target Award