RSFM_SUSR_SV_VW

(SQL View)
 Index Back

Sales User

Sales User. Used by Mobile Sales.

SELECT U.PERSON_ID ,T.TERRITORY_ID ,U.STATUS ,U.SALES_USER_TYPE ,U.BUSINESS_UNIT ,U.MARKET ,U.TREE_NAME ,U.ASSIGN_GROUP ,U.BO_ID_COMPANY ,U.TEAM_ID ,U.TASK_TYPE ,U.CURRENCY_CD ,U.SEG_QUOTA_TYPE ,U.REV_QUOTA_TYPE ,U.UNIT_QUOTA_TYPE ,U.SHADOW_AMT ,U.SHADOW_PCT ,U.COMMENTS_254 ,U.ROW_ADDED_DTTM ,U.ROW_ADDED_OPRID ,U.ROW_LASTMANT_DTTM ,U.ROW_LASTMANT_OPRID ,U.SYNCID ,U.SYNCDTTM ,TR.DESCR FROM PS_RSF_SUSER U ,PS_RSF_TR_TEAM T ,PS_RSF_TERRITORY TR WHERE U.PERSON_ID = T.PERSON_ID AND T.TERRITORY_ID = TR.TERRITORY_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
2 TERRITORY_ID Character(20) VARCHAR2(20) NOT NULL Territory ID
3 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

Default Value: A

4 SALES_USER_TYPE Character(4) VARCHAR2(4) NOT NULL Sales User Type
ADMN=Sales Administrator
EXEC=Executive Sales Manager
FLDR=Field Sales Rep
INSR=Inside Sales Rep
PREP=Partner Contact
PRES=Pre-Sales Consultant
SMGR=Sales Manager
TECH=Sales Tech Support
TELR=Telesales Rep
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_RSF_NONVW

6 MARKET Character(3) VARCHAR2(3) NOT NULL Market

Default Value: GBL

7 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

Prompt Table: RSF_TREE_VW

8 ASSIGN_GROUP Character(30) VARCHAR2(30) NOT NULL This field is used to specify assignment group name for Territory assignment.

Prompt Table: RSF_ASSIGN_GRP
Set Control Field: BUSINESS_UNIT

9 BO_ID_COMPANY Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

Prompt Table: RSF_COMPANY_VW2

10 TEAM_ID Character(15) VARCHAR2(15) NOT NULL Sales Team ID

Prompt Table: RSF_TEAM_A_VW

11 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Copied from Resouce Management (8.1). Added new label id for "Task Type"

Prompt Table: RB_TASK_TYPE

12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

Prompt Table: CURRENCY_CD_TBL

13 SEG_QUOTA_TYPE Character(1) VARCHAR2(1) NOT NULL Segment Quota Type
M=Manager Quota
R=Rollup Quota

Default Value: R

14 REV_QUOTA_TYPE Character(1) VARCHAR2(1) NOT NULL Revenue Quota Type
M=Manager Quota
R=Rollup Quota

Default Value: R

15 UNIT_QUOTA_TYPE Character(1) VARCHAR2(1) NOT NULL Unit Quota Type
M=Manager Quota
R=Rollup Quota

Default Value: R

16 SHADOW_AMT Number(27,3) DECIMAL(26,3) NOT NULL An amount for a 'shadow' forecast.
17 SHADOW_PCT Number(6,2) DECIMAL(5,2) NOT NULL Shadow Amount Percent
18 COMMENTS_254 Character(254) VARCHAR2(254) NOT NULL Comments
19 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
20 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
21 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
22 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
23 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.
24 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
25 DESCR Character(30) VARCHAR2(30) NOT NULL Description