RSF_SLSWRK_A_VW

(SQL View)
 Index Back

RSF_SLSWRK_A_VW

A view of all active sales users

SELECT A.PERSON_ID ,A.MARKET ,C.BO_NAME ,C.LAST_NAME_SRCH ,B.SETID_DEPT ,B.DEPTID ,C.NAME_AC ,A.EMPLID ,A.BO_ID ,C.SYNCID ,C.SYNCDTTM FROM PS_RD_PERSON A ,PS_RB_WORKER B ,PS_BO_NAME C , PS_RSF_SUSER D WHERE A.PERSON_ID = B.PERSON_ID AND B.PERSON_ID = D.PERSON_ID AND A.BO_ID = C.BO_ID AND C.PRIMARY_IND = 'Y' AND D.STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Default Value: NEXT

2 MARKET Character(3) VARCHAR2(3) NOT NULL Market
3 NAME Character(50) VARCHAR2(50) NOT NULL Name
4 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
5 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID

Prompt Table: SP_SETID_NONVW

6 DEPTID Character(15) VARCHAR2(15) NOT NULL Department

Prompt Table: RB_WORK_DEPT_VW

7 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)
8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
9 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
10 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.
11 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time