PRODCTLG_PLST

(SQL Table)
Index Back

PRODCTLG_PLST

Product Catalog List

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CATALOG_NBR Character(18) VARCHAR2(18) NOT NULL Catalog Number
3 EFFDT Date(10) DATE Effective Date
4 SETID_PRODUCT Character(5) VARCHAR2(5) NOT NULL Product SetID
5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
6 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group
7 EFFDT_PROD_GRP Date(10) DATE Product Group Effective Date
8 INCL_EXCL_TYPE Character(1) VARCHAR2(1) NOT NULL Include/Exclude Type
E=Exclusive
I=Inclusive
9 EFF_STATUS_GRP Character(1) VARCHAR2(1) NOT NULL eff product group status
A=Active
I=Inactive
10 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
11 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
12 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
13 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID