EG_DATE_RND_OPT(SQL Table) |
Index Back |
---|---|
Date RoundThis 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 |