CR_CUST_CRD_VW2(SQL View) |
Index Back |
|---|---|
Cust Contact Credit Card Vw |
| SELECT CC.SETID , CC.CONTACT_ID , CC.CR_CARD_NBR , CC.CR_CARD_TYPE , CC.CR_CARD_FNAME , CC.CR_CARD_LNAME , CC.CR_CARD_EXPMO , CC.CR_CARD_EXPYR , CC.CR_CARD_DIGITS , CC.PRIMARY_CARD FROM PS_CONTACT_CARD CC ,PS_CONTACT CT WHERE CC.SETID = CT.SETID AND CC.CONTACT_ID = CT.CONTACT_ID AND %EffdtCheck(CONTACT CT2, CT, %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 | CR_CARD_NBR |
Character(44) | VARCHAR2(44) NOT NULL | "See OM |
| 4 | 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 |
| 5 | CR_CARD_FNAME | Character(40) | VARCHAR2(40) NOT NULL | Credit Card First Name |
| 6 | CR_CARD_LNAME | Character(40) | VARCHAR2(40) NOT NULL | Credit Card Last Name |
| 7 | CR_CARD_EXPMO | Character(2) | VARCHAR2(2) NOT NULL |
Card Expiration Month
01=January 02=February 03=March 04=April 05=May 06=June 07=July 08=August 09=September 10=October 11=November 12=December |
| 8 | CR_CARD_EXPYR | Character(4) | VARCHAR2(4) NOT NULL |
Card Expiration Year
2011=2011 2012=2012 2013=2013 2014=2014 2015=2015 2016=2016 2017=2017 2018=2018 2019=2019 2020=2020 |
| 9 | CR_CARD_DIGITS | Character(4) | VARCHAR2(4) NOT NULL | Card Number's Last Four Digits |
| 10 | PRIMARY_CARD | Character(1) | VARCHAR2(1) NOT NULL | Primary Card |