PSRMT_COLUMN

index back

PeopleSoft Field Name Field Type Column Type Description
TABLE_CAT Character(30) VARCHAR2(30) NOT NULL Table Catalog
TABLE_SCHEM Character(30) VARCHAR2(30) NOT NULL Table Schema
TABLE_NAME Character(30) VARCHAR2(30) NOT NULL Table Name
COLUMN_NAME Character(30) VARCHAR2(30) NOT NULL Column Name
COLUMN_TYPE Number(4,0) SMALLINT NOT NULL Column Type
COLUMN_TYPE_NAME Character(30) VARCHAR2(30) NOT NULL Column Type Name
COLUMN_SIZE Number(10,0) DECIMAL(10) NOT NULL Column Size
COLUMN_PREC Number(4,0) SMALLINT NOT NULL Column Precision
COLUMN_SCALE Number(4,0) SMALLINT NOT NULL Column Scale
COLUMN_NULLABLE Number(3,0) SMALLINT NOT NULL Column Nullable
COLUMN_DEFAULT Character(30) VARCHAR2(30) NOT NULL Column Default Value
COLUMN_DESC Character(254) VARCHAR2(254) NOT NULL Column Description
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19