CC_UNMASK_N_VW (SQL View)	Index Back
Roles w/o CC Unmask Right

CC_UNMASK_N_VW

(SQL View)

Roles w/o CC Unmask Right

SELECT A.ROLENAME , 'N' , B.DISPLAY_DIGITS FROM PS_CC_CARD_ROLE A , PS_INSTALLATION_PO B WHERE NOT EXISTS ( SELECT 'X' FROM PS_CC_UNMASK_VW GG WHERE A.ROLENAME = GG.ROLENAME)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

2 CC_UNMASK Character(1) VARCHAR2(1) NOT NULL Unmask Credit Card

3 DISPLAY_DIGITS Number(3,0) SMALLINT NOT NULL Number of Digits to Display

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).
2	CC_UNMASK	Character(1)	VARCHAR2(1) NOT NULL	Unmask Credit Card
3	DISPLAY_DIGITS	Number(3,0)	SMALLINT NOT NULL	Number of Digits to Display