DIM_ROLLUP_LVL |
index back |
|---|
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
 DIMENSION_ID |
Character(30) | VARCHAR2(30) NOT NULL | Dimension/Measure/Attribute |
| SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| DIM_LEVEL_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Dim Level Name |
| DIM_LEVEL_SEQ | Number(2,0) | SMALLINT NOT NULL | Level Num |
| 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 |
| 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 |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |