EG_DATE_RND_OPT

(SQL Table)
Index Back

Date Round

This is a setup table containing Date Round parameters.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPTION_NAME Character(10) VARCHAR2(10) NOT NULL Option Name
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 ROUND_TYPE Character(2) VARCHAR2(2) NOT NULL Rounding Type
DD=Decimal Date
RD=Raw Date
UE=User Exit

Default Value: RD

4 ROUND_DAY Character(2) VARCHAR2(2) NOT NULL Rounding Day
FD=First Day of Period
LD=Last Day of Period

Default Value: FD

5 EG_ROUND_PERIOD Character(2) VARCHAR2(2) NOT NULL Rounding Period
AY=Anniversary Year
CM=Calendar Month
CP=Computational Period
CY=Calendar Year

Default Value: CM

6 ROUND_RULE Character(3) VARCHAR2(3) NOT NULL Rounding Rule
CWF=Coincident with or Next
CWP=Coincident with or Previous
FP=First Previous
N=Near
NF=Next Following
UP=Up if Day/Month =>
UPD=Up if =>, else down

Default Value: CWF

7 UP_PERIOD_NUM Number(3,0) SMALLINT NOT NULL Limit for Rounding Up
8 UPD_PERIOD_NUM Number(3,0) SMALLINT NOT NULL Limit for Rounding Up or Down
9 DEC_PLACES Number(3,0) SMALLINT NOT NULL Number of Decimal Places