PL_CATEG_ID (SQL View)	Index Back
PL CATEGORY ID used as a prompt table within planning panels for category id. (other key fields are not always known ..)

PL_CATEG_ID

used as a prompt table within planning panels for category id. (other key fields are not always known ..)

SELECT DISTINCT CATEGORY_ID FROM PS_ITM_CAT_TBL WHERE EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID