DIM_INPUT_FLD(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  DIMENSION_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Dimension/Measure/Attribute
Default Value: DIM_DATA_SRC.DIMENSION_ID |
| 2 | SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL |
Sequence Number
Default Value: DIM_DATA_SRC.SEQUENCE_NBR |
| 3 | QRYNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Query Name
Default Value: DIM_DATA_SRC.QRYNAME |
| 4 | DATA_SRC_NUM |
Number(4,0) | SMALLINT NOT NULL |
Input Number
Default Value: DIM_DATA_SRC.DATA_SRC_NUM |
| 5 | QRYFLDNAME | Character(30) | VARCHAR2(30) NOT NULL |
Source Field
Prompt Table: QRY_FLD_HDNG_VW |
| 6 | DIM_LEVEL_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Dim Level Name
Prompt Table: DIM_ROLLUP_LVL |
| 7 | 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 Value: M |
| 8 | ATTRIBUTE_NUM | Number(4,0) | SMALLINT NOT NULL |
Attribute Name
Prompt Table: %EDITTABLE13 |
| 9 | COMPONENT_NBR | Number(3,0) | SMALLINT NOT NULL |
Component Number
Default Value: 1 |