RD_IDS_CFGSR_V2 (SQL View)	Index Back
SIC Code Config Search View Configurable Search View for Standard Industry Codes.

RD_IDS_CFGSR_V2

(SQL View)

SIC Code Config Search View

Configurable Search View for Standard Industry Codes.

SELECT A.SYNCID , B.INDUSTRY_ID , E.DESCR100 , B.SIC_TYPE , B.SIC_CODE FROM PS_RD_ACCT_CFG_VW A , PS_RD_COMPANY B , PS_RSF_INDUSTRY C , PS_SIC_TYPE D , PS_SIC_CODE E WHERE A.BO_ID = B.BO_ID AND B.INDUSTRY_ID = C.INDUSTRY_ID AND B.SIC_TYPE = D.SIC_TYPE AND D.SIC_TYPE = E.SIC_TYPE AND B.SIC_CODE = E.SIC_CODE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

2 INDUSTRY_ID Character(30) VARCHAR2(30) NOT NULL Industry ID.
Prompt Table: RSF_INDUSTRY

3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

4 SIC_TYPE Character(10) VARCHAR2(10) NOT NULL SIC Type.
Prompt Table: SIC_TYPE

5 SIC_CODE Character(10) VARCHAR2(10) NOT NULL Standard Industry Code
Prompt Table: SIC_CODE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
2	INDUSTRY_ID	Character(30)	VARCHAR2(30) NOT NULL	Industry ID. Prompt Table: RSF_INDUSTRY
3	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
4	SIC_TYPE	Character(10)	VARCHAR2(10) NOT NULL	SIC Type. Prompt Table: SIC_TYPE
5	SIC_CODE	Character(10)	VARCHAR2(10) NOT NULL	Standard Industry Code Prompt Table: SIC_CODE