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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |