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 |  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 | 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 Follow CWP=Coincident with or First Prev FP=First Previous N=Near NF=Next Following UP=Up if Day/Month => UPD=Up if Day/Month => Default Value: CWF |
| 7 | UP_PERIOD_NUM | Number(3,0) | SMALLINT NOT NULL | Up Period Number |
| 8 | UPD_PERIOD_NUM | Number(3,0) | SMALLINT NOT NULL | Up/Down Period Num |
| 9 | DEC_PLACES | Number(3,0) | SMALLINT NOT NULL | Number of Decimal Places |