CONT_OWNERS_CUR

(SQL View)

SELECT SETID , CONTACT_ID , %TrimSubstr(A.SETID,1,5) %Concat '' %Concat %TrimSubstr(A.CONTACT_ID,1,15) , OPRID , FO_OWNER_TYPE , FO_OWNER_PRIORITY FROM %Table(CONT_OWNERS) A WHERE %EffdtCheck(CONT_OWNERS B, A, %currentdatein)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

3 SOID Character(29) VARCHAR2(29) NOT NULL Service Order Line Key

4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW
Set Control Field: SETID

5 FO_OWNER_TYPE Character(1) VARCHAR2(1) NOT NULL Collection Owner Type
O=Other
S=Sales User
V=Service User

6 FO_OWNER_PRIORITY Character(1) VARCHAR2(1) NOT NULL Owner Priority
H=High
L=Low
M=Medium
Prompt Table: FO_OWN_PRIORITY

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
3	SOID	Character(29)	VARCHAR2(29) NOT NULL	Service Order Line Key
4	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPRID_VW Set Control Field: SETID
5	FO_OWNER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Collection Owner Type O=Other S=Sales User V=Service User
6	FO_OWNER_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Owner Priority H=High L=Low M=Medium Prompt Table: FO_OWN_PRIORITY