DIM_INPUT_FLD

index back

PeopleSoft Field NameField TypeColumn TypeDescription
DIMENSION_IDCharacter(30)VARCHAR2(30) NOT NULLDimension/Measure/Attribute

Default: DIM_DATA_SRC.DIMENSION_ID

SEQUENCE_NBRNumber(2,0)SMALLINT NOT NULLSequence Number

Default: DIM_DATA_SRC.SEQUENCE_NBR

QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name

Default: DIM_DATA_SRC.QRYNAME

DATA_SRC_NUMNumber(4,0)SMALLINT NOT NULLInput Number

Default: DIM_DATA_SRC.DATA_SRC_NUM

QRYFLDNAMECharacter(30)VARCHAR2(30) NOT NULLSource Field

Prompt Table: QRY_FLD_HDNG_VW

DIM_LEVEL_NAMECharacter(30)VARCHAR2(30) NOT NULLDim Level Name

Prompt Table: DIM_ROLLUP_LVL

DIM_INPUT_FLD_ROLECharacter(1)VARCHAR2(1) NOT NULLDimension Input Field Role
A=User Defined Attribute
C=LDAP Class Id
M=Member Value
P=Parent Member Value

Default: M

ATTRIBUTE_NUMNumber(4,0)SMALLINT NOT NULLAttribute Name

Prompt Table: %EDITTABLE13

COMPONENT_NBRNumber(3,0)SMALLINT NOT NULLComponent Number

Default: 1

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19