WCS_ECM_CYC_CFG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUDGET_ID	Character(10)	VARCHAR2(10) NOT NULL	Budget ID
2	BUDGET_START_DT	Date(10)	DATE NOT NULL	Budget Start Date
3	BUDGET_END_DT	Date(10)	DATE	Budget End Date
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCR20	Character(20)	VARCHAR2(20) NOT NULL	Description
6	WCS_CYCLE_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Cycle Status BIP=Build In Progress BLT=Built CAN=Canceled DEF=Defined FIN=Closed OPN=Opened Default Value: DEF
7	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID. Prompt Table: GB_GROUP_SEC_VW
8	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
9	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name Prompt Table: WCS_ECM_TREEVW1
10	WCS_TREE_EFFDT	Date(10)	DATE NOT NULL	Effective Date of Tree Prompt Table: WCS_ECM_TREEVW2
11	WCS_TREE_NODE_LBL	Character(30)	VARCHAR2(30) NOT NULL	Tree node label for the field name from the tree structure.
12	WCS_ECM_DIR_RPRTS	Character(1)	VARCHAR2(1) NOT NULL	Direct Reports Default Manager Role (determines direct report structure used for tree hierarchy) D=Department Position Nbr M=Manager ID N=None O=None R=Position Incumbent (Rpts To) S=Supervisor ID Default Value: N
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
14	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. Prompt Table: RT_TYPE_TBL
15	RT_RATE_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Market Rate Index Prompt Table: RT_INDEX_TBL
16	CURR_EFFDT	Date(10)	DATE	Current Benefit Date
17	WCS_PERF_INT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Performance Integration Type EP=PeopleSoft ePerformance NO=None OT=Other Default Value: NO
18	PERIOD_BEGIN_DT	Date(10)	DATE	Period Begin Date
19	PERIOD_END_DT	Date(10)	DATE	Period End Date
20	EP_REVIEW_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Review type Prompt Table: EP_REVW_TYP_VW
21	WCS_RATING_TYPE	Character(3)	VARCHAR2(3) NOT NULL	ePerformance Rating Used EPR=EP_RATING RVP=REVIEW_POINTS RVR=REVIEW_RATING
22	JOB_EFFDT	Date(10)	DATE	Job Effective Date
23	NEW_HIRE_ELIG_DT	Date(10)	DATE NOT NULL	New Hire Eligibility Date
24	URL_ID	Character(30)	VARCHAR2(30) NOT NULL	URL Identifier (see PSURLDEFN).
25	WCS_CURR_CONV	Character(1)	VARCHAR2(1) NOT NULL	Enable Currency Conversion Flag Y/N Table Edit
26	WCS_ENABLE_DELG	Character(1)	VARCHAR2(1) NOT NULL	Enable role delegation indicator. Y/N Table Edit Default Value: N
27	WCS_ENABLE_AWE	Character(1)	VARCHAR2(1) NOT NULL	Enable Approval Workflow Engine (AWE) Flag Y/N Table Edit Default Value: N
28	WCS_COMMENTS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Comments Flag - turn Comments on or off on the MSS pages Y/N Table Edit
29	WCS_ALLOW_INDIRECT	Character(1)	VARCHAR2(1) NOT NULL	Allow Indirect Flag Y/N Table Edit
30	WCS_VC_HIST_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag Indicating to Show Variable Compensation History Y/N Table Edit
31	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
32	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
33	EOAWPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID Prompt Table: WCS_AW_PRCS_VW
34	EOAWDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Framework Definition ID Prompt Table: WCS_AW_DEFN_VW
35	WCS_PUB_TRNS	Character(1)	VARCHAR2(1) NOT NULL	Publish Update Transactions N=No Y=Yes Y/N Table Edit Default Value: N
36	WCS_PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Used in Define Compensation Cycles page to distinguish between cycles that are bothmerit and comp versus cycles that are only variable comp. BO=Merit and Variable Comp VC=Variable Comp Only Default Value: BO