EX_EMP_CARD_VW2

(SQL View)
Index Back

Credit Card Data

Used to populate user credit card values

SELECT A.EMPLID , C.EXPEND_MTHD , A.CRDMEM_ACCT_NBR , A.CREDIT_CARD_VENDOR , B.DESCR , A.EXPIRATION_DT FROM PS_CC_CARD_DATA_EX A , PS_CC_CARD_TBL_EX B , PS_EX_EXP_MTHD_TBL C WHERE A.CREDIT_CARD_VENDOR = B.CREDIT_CARD_VENDOR AND B.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = A.BUSINESS_UNIT AND D.RECNAME = 'CC_CARD_TBL_EX') AND C.SETID = ( SELECT E.SETID FROM PS_SET_CNTRL_REC E WHERE E.SETCNTRLVALUE = A.BUSINESS_UNIT AND E.RECNAME = 'EX_EXP_MTHD_TBL') AND B.VENDOR_SETID = C.VENDOR_SETID AND B.VENDOR_ID = C.VENDOR_ID AND C.EXPEND_MTHD_EDIT = 'VND' AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_CC_CARD_TBL_EX B1 WHERE B1.SETID = B.SETID AND B1.CREDIT_CARD_VENDOR = B.CREDIT_CARD_VENDOR AND B1.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_EX_EXP_MTHD_TBL C1 WHERE C1.SETID = C.SETID AND C1.EXPEND_MTHD = C.EXPEND_MTHD AND C1.EFFDT <= %CurrentDateIn) AND C.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EXPEND_MTHD Character(3) VARCHAR2(3) NOT NULL Payment Type
3 CRDMEM_ACCT_NBR Character(44) VARCHAR2(44) NOT NULL Cardmember Number
4 CREDIT_CARD_VENDOR Character(5) VARCHAR2(5) NOT NULL Corporate Card Vendor
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 EXPIRATION_DT Date(10) DATE Expiration Date