CONTACT_CARD(SQL View) |
Index Back |
|---|---|
Contact Card InformationView Used as Message Segment for CONTACT Messages |
| SELECT A.SETID , A.CONTACT_ID , C.CUSTOMER_SETID , C.CUST_ID ,B.CR_CARD_NBR , B.CR_CARD_TYPE , B.PRIMARY_IND , B.CR_CARD_FNAME , B.CR_CARD_LNAME , B.CR_CARD_EXPMO , B.CR_CARD_EXPYR , B.CR_CARD_DIGITS , B.CC_PROF_TOKEN , B.CR_CARD_VENDOR , 0 , B.ROW_LASTMANT_OPRID , %DatePart(B.ROW_LASTMANT_DTTM) FROM PS_RB_INT_CONTACT A , PS_RB_CREDIT_CARD B , PS_RB_INT_CNTCT_CU C WHERE A.BO_ID=B.BO_ID AND A.BO_ID = C.BO_ID AND B.CR_CARD_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_FS.SETID |
| 2 | CONTACT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 3 | CUSTOMER_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Customer SETID |
| 4 | CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Customer ID |
| 5 | CR_CARD_NBR |
Character(44) | VARCHAR2(44) NOT NULL | "See OM |
| 6 | 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 |
| 7 | PRIMARY_CARD | Character(1) | VARCHAR2(1) NOT NULL |
Primary Card
Y/N Table Edit Default Value: N |
| 8 | CR_CARD_FNAME | Character(40) | VARCHAR2(40) NOT NULL | Credit Card First Name |
| 9 | CR_CARD_LNAME | Character(40) | VARCHAR2(40) NOT NULL | Credit Card Last Name |
| 10 | CR_CARD_EXPMO | Character(2) | VARCHAR2(2) NOT NULL |
Card Expiration Month
01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December |
| 11 | CR_CARD_EXPYR | Character(4) | VARCHAR2(4) NOT NULL | Card Expiration Year |
| 12 | CR_CARD_DIGITS | Character(4) | VARCHAR2(4) NOT NULL | Card Number's Last Four Digits |
| 13 | CC_PROF_TOKEN | Character(44) | VARCHAR2(44) NOT NULL | Profile Token ID |
| 14 | CR_CARD_VENDOR | Character(16) | VARCHAR2(16) NOT NULL | Vendor name for credit card processing |
| 15 | ADDR_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 16 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | This field determines the last user or operator that last changed this item. |
| 17 | DATE_LAST_MAINT | Date(10) | DATE | This field determines the date of last maintenance. |