WCS_RID_EFFDT (SQL Table)	Index Back
Rounding Rule ID EffDate Rounding Rule ID Effective Date table

WCS_RID_EFFDT

(SQL Table)

Rounding Rule ID EffDate

Rounding Rule ID Effective Date table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 WCS_ROUND_ID Character(6) VARCHAR2(6) NOT NULL Rounding Rule ID

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 WCS_ROUND_METHOD Character(1) VARCHAR2(1) NOT NULL Rounding Rule Method
D=Down
N=Nearest
U=Up
X=No Rounding

4 WCS_ROUND_INCR_AMT Number(12,6) DECIMAL(11,6) NOT NULL Rounding Rule Increment Amount

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	WCS_ROUND_ID	Character(6)	VARCHAR2(6) NOT NULL	Rounding Rule ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	WCS_ROUND_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Rounding Rule Method D=Down N=Nearest U=Up X=No Rounding
4	WCS_ROUND_INCR_AMT	Number(12,6)	DECIMAL(11,6) NOT NULL	Rounding Rule Increment Amount