PCMP_PROD_LNG (SQL Table)	Index Back
Prof Comp Product Used in the Professional Compliance module. Related language record for products that a Company can sell.

PCMP_PROD_LNG

(SQL Table)

Prof Comp Product

Used in the Professional Compliance module. Related language record for products that a Company can sell.

Related Language Record for PCMP_PRODUCT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SETID_TBL

2 PCMP_PROD_TYPE Character(6) VARCHAR2(6) NOT NULL Used in the Professional ompliance module. Prodtuct Type category.

3 PCMP_PRODUCT Character(6) VARCHAR2(6) NOT NULL Used in the Professional Compliance module. Product that a Company sells.

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 PCMP_PRODUCT_DESCR Character(30) VARCHAR2(30) NOT NULL Used in the Professional Compliance module. Product description.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SETID_TBL
2	PCMP_PROD_TYPE	Character(6)	VARCHAR2(6) NOT NULL	Used in the Professional ompliance module. Prodtuct Type category.
3	PCMP_PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Used in the Professional Compliance module. Product that a Company sells.
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	PCMP_PRODUCT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Used in the Professional Compliance module. Product description.