CPROF_TOKEN_VW

(SQL View)
 Index Back

Cust Contact Credit Card Vw

Date Init. Issue # Description 10/09/01 JJM F-CJORGENS-6 Updated SQL to use "new" tables

SELECT DISTINCT CC.CC_PROF_TOKEN , CC.CR_CARD_VENDOR , CC.CR_CARD_TYPE , CC.CR_CARD_DIGITS , CC.PRIMARY_CARD , 'C' , CC.STATUS FROM PS_CONTACT_CARD CC WHERE %EffdtCheck(CONTACT_CARD CC2, CC, %CurrentDateIn) AND CC.CC_PROF_TOKEN <> ' ' UNION SELECT DISTINCT CP.CC_PROF_TOKEN , CP.CR_CARD_VENDOR , CP.CR_CARD_TYPE , CP.CR_CARD_DIGITS , 'N' , 'P' , CP.STATUS FROM PS_CR_CARD_PROF CP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CC_PROF_TOKEN Character(44) VARCHAR2(44) NOT NULL Profile Token ID
2 CR_CARD_VENDOR Character(16) VARCHAR2(16) NOT NULL Processor Name
3 CR_CARD_TYPE Character(3) VARCHAR2(3) NOT NULL "See OM
01=Visa
02=MasterCard
03=Diners Club/Carte Blanche
04=AMEX
05=Discover
06=EnRoute

Prompt Table: ORDENT_CCTYP_VW

4 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits
5 PRIMARY_CARD Character(1) VARCHAR2(1) NOT NULL Primary Card
6 CC_PROF_SOURCE Character(1) VARCHAR2(1) NOT NULL "See OM
C=Contact Component
P=Profile Table
7 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive