DIM_ROLLUP_LVL

index back
Added PCode validation on SEdit event in Date function field for TPRD# T-Rerdem-TV7YH by SCO 12/19/00.

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 2019, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 25-NOV-20