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 NameField TypeColumn TypeDescription
DIMENSION_IDCharacter(30)VARCHAR2(30) NOT NULLDimension/Measure/Attribute
SEQUENCE_NBRNumber(2,0)SMALLINT NOT NULLSequence Number
DIM_LEVEL_NAMECharacter(30)VARCHAR2(30) NOT NULLDim Level Name
DIM_LEVEL_SEQNumber(2,0)SMALLINT NOT NULLLevel Num
DATE_FUNCTIONCharacter(3)VARCHAR2(3) NOT NULLDate 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_FORMATCharacter(3)VARCHAR2(3) NOT NULLDate 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.ukPeopleTools 8.54
PTRef generated on 09-JUN-19