DIM_INPUT_FLD

index back

PeopleSoft Field Name Field Type Column Type Description
DIMENSION_ID Character(30) VARCHAR2(30) NOT NULL Dimension/Measure/Attribute

Default: DIM_DATA_SRC.DIMENSION_ID

SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number

Default: DIM_DATA_SRC.SEQUENCE_NBR

QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name

Default: DIM_DATA_SRC.QRYNAME

DATA_SRC_NUM Number(4,0) SMALLINT NOT NULL Input Number

Default: DIM_DATA_SRC.DATA_SRC_NUM

QRYFLDNAME Character(30) VARCHAR2(30) NOT NULL Source Field

Prompt Table: QRY_FLD_HDNG_VW

DIM_LEVEL_NAME Character(30) VARCHAR2(30) NOT NULL Dim Level Name

Prompt Table: DIM_ROLLUP_LVL

DIM_INPUT_FLD_ROLE Character(1) VARCHAR2(1) NOT NULL Dimension Input Field Role
A=User Defined Attribute
C=LDAP Class Id
M=Member Value
P=Parent Member Value

Default: M

ATTRIBUTE_NUM Number(4,0) SMALLINT NOT NULL Attribute Name

Prompt Table: %EDITTABLE13

COMPONENT_NBR Number(3,0) SMALLINT NOT NULL Component Number

Default: 1

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