DIM_ROLLUP_LVL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  DIMENSION_ID |
Character(30) | VARCHAR2(30) NOT NULL | Dimension/Measure/Attribute |
| 2 | SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 3 | DIM_LEVEL_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Dim Level Name |
| 4 | DIM_LEVEL_SEQ | Number(2,0) | SMALLINT NOT NULL | Level Num |
| 5 | DATE_FUNCTION | Character(3) | VARCHAR2(3) NOT NULL |
Date Function (PowerPlay Only)
445=LunarMonth445 454=LunarMonth454 544=LunarMonth544 DAY=Day LMT=LunarMonth LQR=LunarQuarter LYR=LunarYear MTH=Month QR=Quarter WK=Week YR=Year |
| 6 | DATE_FORMAT | Character(3) | VARCHAR2(3) NOT NULL |
Date Format (PowerPlay Only)
D1=YY/MM/DD D2=MM/DD/YY D3=DDDD,MMMM DD, YYYY M1=YYYY/MMMM M2=MYY M3=MMMM,YYYY M4=MMMM YYYY Q=YYYY "Q" Q W=YYYY/MM/DD Y1=YYYY Y2=YY |