CUB_DIMENSIONIDCUB_SEQNUMSEQNUMPSCUBDIMSTRINFO |
index back |
|---|
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| CUB_DIMENSIONID |
Character(30) | VARCHAR2(30) NOT NULL | Dimension Name (see PSCUBDIMENSION). |
| CUB_SEQNUM |
Number(10,0) | DECIMAL(10) NOT NULL | Sequence Number |
| SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| QRYNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Name |
| FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| CUB_FIELDTYPE | Character(20) | VARCHAR2(20) NOT NULL | Field Type |
| CUB_FNUMBER | Signed Number(23,3) | DECIMAL(21,3) NOT NULL | Numeric Field |
| CUB_FCHAR | Character(254) | VARCHAR2(254) NOT NULL | Character Data |
| CUB_FDATE | Date(10) | DATE | Date Field |
| CUB_FDATETIME | DateTime(26) | TIMESTAMP | Datetime Field |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |