EG_DATE_CNV_OPT(SQL Table) |
Index Back |
|---|---|
Date ConversionThis is a setup table containing Date Conversion 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 | CONV_OPTION_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Option Type
CV=Date Conversion EX=Date Extraction Default Value: CV |
| 4 | CONV_DECIMAL_POS | Number(2,0) | SMALLINT NOT NULL | Conversion Decimal Position |
| 5 | CONV_DAYS_PER_MM | Number(2,0) | SMALLINT NOT NULL | Conversion Days Per Month |
| 6 | DAYS_PER_YEAR | Number(6,2) | DECIMAL(5,2) NOT NULL | Days Per Year |
| 7 | CONVERSION_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Conversion Method
A=Yrs + ((Months-1 * (Days/Mth)) B=Yrs + Months/12 C=Yrs + (Months-1)/12 + (Days - D=Yrs + (Months-1)/12 + (1/12 * E=Date Tables O=User Code Default Value: A |
| 8 | DATE_EXTRACT | Character(1) | VARCHAR2(1) NOT NULL |
Extract
D=Day J=Julian Date M=Month O=User Code W=Weekday Y=Year Default Value: W |