EX_EMP_CARD_VW3

(SQL View)
 Index Back

Credit Card Data

Used to populate user credit card values

SELECT A.EMPLID , C.EXPEND_MTHD , A.CRDMEM_ACCT_NBR , C.EFFDT , B.EFFDT , A.CREDIT_CARD_VENDOR , B.DESCR , A.EXPIRATION_DT ,A.CC_ACCT_STATUS ,A.CC_STATUS_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.EFF_STATUS = 'A' 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 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 EFFDT_VENDOR Date(10) DATE Effective Date Supplier
6 CREDIT_CARD_VENDOR Character(5) VARCHAR2(5) NOT NULL Corporate Card Vendor
7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 EXPIRATION_DT Date(10) DATE Expiration Date
9 CC_ACCT_STATUS Character(1) VARCHAR2(1) NOT NULL Account Status
A=Active
I=Inactive
10 CC_STATUS_DT Date(10) DATE Account Status Date