| PA_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 | 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 | ROUND_PERIOD | Character(2) | VARCHAR2(2) NOT NULL | Rounding Period AY=Anniversary Year CM=Calendar Month CY=Calendar Year PY=Plan 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 |