FS_CR_CARD_VW (SQL View)	Index Back
Active Cred Card View Displays credit cards that the system considers active and available for use.

FS_CR_CARD_VW

(SQL View)

Active Cred Card View

Displays credit cards that the system considers active and available for use.

SELECT cr_card_type , cr_card_name , cr_card_length FROM PS_FS_CR_CARD_TYPE WHERE cr_card_stat = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CR_CARD_TYPE Character(2) VARCHAR2(2) NOT NULL "See OM
01=Visa
02=MasterCard
03=Diners Club/Carte Blanche
04=AMEX
05=Discover
06=EnRoute

2 CR_CARD_NAME Character(32) VARCHAR2(32) NOT NULL Use in the Credit Card Number Capture Process

3 CR_CARD_LENGTH Number(3,0) SMALLINT NOT NULL Use in the Credit Card Number Capture Process

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CR_CARD_TYPE	Character(2)	VARCHAR2(2) NOT NULL	"See OM 01=Visa 02=MasterCard 03=Diners Club/Carte Blanche 04=AMEX 05=Discover 06=EnRoute
2	CR_CARD_NAME	Character(32)	VARCHAR2(32) NOT NULL	Use in the Credit Card Number Capture Process
3	CR_CARD_LENGTH	Number(3,0)	SMALLINT NOT NULL	Use in the Credit Card Number Capture Process