WCS_PRO_EXC_TBL (SQL Table)	Index Back
Prorate Execption Table Client may optionally populate this table rather than use delivered proration rules. If this option is selected, a prorate factor of 1 is assumed unless there is an entry in this table.

WCS_PRO_EXC_TBL

(SQL Table)

Prorate Execption Table

Client may optionally populate this table rather than use delivered proration rules. If this option is selected, a prorate factor of 1 is assumed unless there is an entry in this table.

Parent record: WCS_ECM_EE_DMG

# 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 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

4 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID

5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

7 WCS_PRORATE_FCTR Number(8,6) DECIMAL(7,6) NOT NULL Employee Prorate Factor

#	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	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
4	VC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	VC Plan ID
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
7	WCS_PRORATE_FCTR	Number(8,6)	DECIMAL(7,6) NOT NULL	Employee Prorate Factor