PSRMT_COLUMN

index back

PeopleSoft Field NameField TypeColumn TypeDescription
TABLE_CATCharacter(30)VARCHAR2(30) NOT NULLTable Catalog
TABLE_SCHEMCharacter(30)VARCHAR2(30) NOT NULLTable Schema
TABLE_NAMECharacter(30)VARCHAR2(30) NOT NULLTable Name
COLUMN_NAMECharacter(30)VARCHAR2(30) NOT NULLColumn Name
COLUMN_TYPENumber(4,0)SMALLINT NOT NULLColumn Type
COLUMN_TYPE_NAMECharacter(30)VARCHAR2(30) NOT NULLColumn Type Name
COLUMN_SIZENumber(10,0)DECIMAL(10) NOT NULLColumn Size
COLUMN_PRECNumber(4,0)SMALLINT NOT NULLColumn Precision
COLUMN_SCALENumber(4,0)SMALLINT NOT NULLColumn Scale
COLUMN_NULLABLENumber(3,0)SMALLINT NOT NULLColumn Nullable
COLUMN_DEFAULTCharacter(30)VARCHAR2(30) NOT NULLColumn Default Value
COLUMN_DESCCharacter(254)VARCHAR2(254) NOT NULLColumn Description
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19