| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
TABLE_CAT |
Character(30) |
VARCHAR2(30) NOT NULL |
Table Catalog
|
| 2 |
TABLE_SCHEM |
Character(30) |
VARCHAR2(30) NOT NULL |
Table Schema
|
| 3 |
TABLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Table Name
|
| 4 |
COLUMN_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Column Name
|
| 5 |
COLUMN_TYPE |
Number(4,0) |
SMALLINT NOT NULL |
Column Type
|
| 6 |
COLUMN_TYPE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Column Type Name
|
| 7 |
COLUMN_SIZE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Column Size
|
| 8 |
COLUMN_PREC |
Number(4,0) |
SMALLINT NOT NULL |
Column Precision
|
| 9 |
COLUMN_SCALE |
Number(4,0) |
SMALLINT NOT NULL |
Column Scale
|
| 10 |
COLUMN_NULLABLE |
Number(3,0) |
SMALLINT NOT NULL |
Column Nullable
|
| 11 |
COLUMN_DEFAULT |
Character(30) |
VARCHAR2(30) NOT NULL |
Column Default Value
|
| 12 |
COLUMN_DESC |
Character(254) |
VARCHAR2(254) NOT NULL |
Column Description
|