AR_OPRID_SLS_VW

(SQL View)

SELECT DISTINCT B.SETID , A.OPRID , 'S' , B.SUPPORT_TEAM_MBR FROM PSOPRDEFN A , PS_MEMBER_PERSON B , PS_MEMBER_TYPE_TBL C WHERE A.EMPLID = B.EMPLID AND B.EFF_STATUS = 'A' AND B.SETID = C.SETID AND B.TEAM_MEMBER_TYPE = C.TEAM_MEMBER_TYPE AND C.SALES_PERSON = 'Y' AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_MEMBER_TYPE_TBL C1 WHERE C.SETID = C1.SETID AND C.TEAM_MEMBER_TYPE = C1.TEAM_MEMBER_TYPE AND C1.EFFDT <= %CurrentDateIn AND C.SALES_PERSON = 'Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 ASSN_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the operator ID of the person who will enter items in a group. This is used when one person enters the control totals and another person enters the actual transactions. The assigned operator is also the person who processes the group and the person who is shown on group inquiry and processing panels.

3 OWNER_TYPE Character(1) VARCHAR2(1) NOT NULL Collection Owner Type
A=Credit Analyst
C=Collector
O=Other
R=AR Specialist
S=Sales Person

4 ACTION_OWNER Character(30) VARCHAR2(30) NOT NULL Action Owner

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	ASSN_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the operator ID of the person who will enter items in a group. This is used when one person enters the control totals and another person enters the actual transactions. The assigned operator is also the person who processes the group and the person who is shown on group inquiry and processing panels.
3	OWNER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Collection Owner Type A=Credit Analyst C=Collector O=Other R=AR Specialist S=Sales Person
4	ACTION_OWNER	Character(30)	VARCHAR2(30) NOT NULL	Action Owner