WCS_CYC_RLE_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
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	BUDGET_ID	Character(10)	VARCHAR2(10) NOT NULL	Budget ID
5	BUDGET_START_DT	Date(10)	DATE NOT NULL	Budget Start Date
6	JOB_EFFDT	Date(10)	DATE	Job Effective Date
7	CYC_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Cycle currency code.
8	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.
9	RT_RATE_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Market Rate Index
10	CURR_EFFDT	Date(10)	DATE	Current Benefit Date
11	BUDGET_RULE_CD	Character(2)	VARCHAR2(2) NOT NULL	Job change types. 01=Active to Inactive Status 02=Currency Code 03=Salary
12	WCS_ECM_EXCLUDED	Character(1)	VARCHAR2(1) NOT NULL	Employee Exclusion Flag
13	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
14	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
15	TREE_NODE_NUM_END	Number(10,0)	DECIMAL(10) NOT NULL	Internal ending node range number
16	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
17	PRIORITY	Number(3,0)	SMALLINT NOT NULL	Priority
18	ROWS_RETRIEVED	Number(9,0)	DECIMAL(9) NOT NULL	Number of Rows Retrieved
19	ALERTSTATUS	Character(1)	VARCHAR2(1) NOT NULL	Alert Status
20	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
21	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
22	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
23	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
24	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
25	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
26	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
27	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
28	STD_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Standard Work Period
29	PAID_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Paid Hours
30	PAID_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Paid Work Period
31	OLD_COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Old compensation rate.
32	NEW_COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	New Compensation Rate
33	NEW_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	New Currency Code
34	CHANGE_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	Change Percent
35	COMP_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Compensation Frequency A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly
36	WCS_NODE_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Node Status CLC=Calculated CME=Completed with Errors CMP=Completed CNF=Confirmed INP=In Progress PSB=Pushed Back RTL=Ready to Load SUB=Submitted