RSFM_INDUST_VW (SQL View)	Index Back
Active Industries (Mobile) View For Active Industries

RSFM_INDUST_VW

(SQL View)

Active Industries (Mobile)

View For Active Industries

SELECT INDUSTRY_ID , DESCR50 , SIC_CODE , PARENT_INDUSTRY_ID , SYNCID , SYNCDTTM FROM PS_RSF_INDUSTRY WHERE STATUS = 'A'

Related Language Record: RSF_INDSTRY_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INDUSTRY_ID Character(30) VARCHAR2(30) NOT NULL Industry ID.

2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

3 SIC_CODE Character(10) VARCHAR2(10) NOT NULL Standard Industry Code

4 PARENT_INDUSTRY_ID Character(30) VARCHAR2(30) NOT NULL Used by Sales Force Automation to indicate who the parent industry is.
Prompt Table: RSF_INDUSTRY
Set Control Field: INDUSTRY

5 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.

6 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INDUSTRY_ID	Character(30)	VARCHAR2(30) NOT NULL	Industry ID.
2	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
3	SIC_CODE	Character(10)	VARCHAR2(10) NOT NULL	Standard Industry Code
4	PARENT_INDUSTRY_ID	Character(30)	VARCHAR2(30) NOT NULL	Used by Sales Force Automation to indicate who the parent industry is. Prompt Table: RSF_INDUSTRY Set Control Field: INDUSTRY
5	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.
6	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time