STMT_SEC_VW (SQL View)	Index Back
Statement Security View Used for row-level security for self-service transactions

STMT_SEC_VW

(SQL View)

Statement Security View

Used for row-level security for self-service transactions

SELECT OPRID , A.SETID , A.CONTACT_ID , B.CUSTOMER_SETID , B.CUST_ID , C.NAME1 FROM PSOPRALIAS A , PS_CONTACT_CUST B , PS_CUSTOMER C WHERE A.SETID = B.SETID AND A.CONTACT_ID = B.CONTACT_ID AND B.CUSTOMER_SETID = C.SETID AND B.CUST_ID = C.CUST_ID AND A.OPRALIASTYPE = 'CNT' AND B.BILL_TO_FLG = 'Y' AND B.VIEW_STMT_IMAGE = 'Y' AND B.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_CONTACT_CUST X WHERE X.SETID = B.SETID AND X.CONTACT_ID = B.CONTACT_ID AND X.CUSTOMER_SETID = B.CUSTOMER_SETID AND X.CUST_ID = B.CUST_ID AND X.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

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

4 CRSPD_SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID

5 CRSPD_CUST_ID Character(15) VARCHAR2(15) NOT NULL Correspondence Customer
Prompt Table: STMT_SEC_VW

6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
4	CRSPD_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID
5	CRSPD_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Correspondence Customer Prompt Table: STMT_SEC_VW
6	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1