SF_PAYMENT_VW

(SQL View)
 Index Back

SELECT A.SF_PMT_REF_NBR , A.COMMON_ID , A.SA_ID_TYPE , A.SF_PAYMENT_STATUS , A.INSTITUTION_SET , A.PAYMENT_AMT , A.CR_CARD_EXPMO , A.CR_CARD_EXPYR , A.CR_CARD_FNAME , A.CR_CARD_LNAME , A.CR_CARD_NBR , A.CR_CARD_TYPE , %subrec(ADDRESS_SBR, A) , A.EMAIL_ADDR , A.PHONE , A.CR_CARD_AUTH_CD , A.CR_CARD_AUTH_DT , A.CR_CARD_RQST_ID , A.CR_CARD_A_DTTM , A.CR_CARD_AUTH_REPLY , A.CR_CARD_AVS_CD , A.CURRENCY_CD , A.OPRID , A.CR_CARD_DIGITS , A.SF_REVERSAL_IND , A.POSTED_DATE , A.POSTED_DATETIME , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.SSF_ERROR_WARN , A.BUSINESS_UNIT_ERR , A.LAST_DTTM_UPDATE , A.SF_POST_STATUS , A.CR_CARD_TRANS_SRC FROM PS_SF_PAYMENT A WHERE SA_ID_TYPE = 'P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SF_PMT_REF_NBR2 Character(12) VARCHAR2(12) NOT NULL Reference Nbr
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person
4 SF_PAYMENT_STATUS Character(2) VARCHAR2(2) NOT NULL Payment Status
A=Authorization Successful
B=Payment Completed
C=Refunded
D=Declined
E=Edit Error
I=Payment Initiated
M=Manually Approved/Settled
N=Payment Cancelled
P=Credit Pending
R=Refund Cancelled
S=Payment Submitted

Default Value: I

5 INSTITUTION_SET Character(5) VARCHAR2(5) NOT NULL Institution Set
6 PAYMENT_AMT Number(19,3) DECIMAL(18,3) NOT NULL Payment Amount
7 CR_CARD_EXPMO Character(2) VARCHAR2(2) NOT NULL Card Expiration Month
01=01
02=02
03=03
04=04
05=05
06=06
07=07
08=08
09=09
10=10
11=11
12=12
8 CR_CARD_EXPYR Character(4) VARCHAR2(4) NOT NULL Card Expiration Year
9 CR_CARD_FNAME Character(40) VARCHAR2(40) NOT NULL Credit Card First Name
10 CR_CARD_LNAME Character(40) VARCHAR2(40) NOT NULL Credit Card Last Name
11 CR_CARD_NBR Character(44) VARCHAR2(44) NOT NULL Credit Card Number
12 CR_CARD_TYPE Character(2) VARCHAR2(2) NOT NULL Credit Card Type

Prompt Table: CREDIT_CARD_TYP

13 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: SCC_CNT_ADFMTVW

14 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
15 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
16 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
17 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
18 CITY Character(30) VARCHAR2(30) NOT NULL City
19 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
20 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
21 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference
22 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
23 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
24 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
25 COUNTY Character(30) VARCHAR2(30) NOT NULL County
26 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

27 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
28 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
29 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

30 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
31 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
32 CR_CARD_AUTH_CD Character(10) VARCHAR2(10) NOT NULL Credit Card Authorization Code
33 CR_CARD_AUTH_DT Date(10) DATE Auth Date
34 CR_CARD_RQST_ID Character(30) VARCHAR2(30) NOT NULL Credit Card Request ID
35 CR_CARD_A_DTTM Character(20) VARCHAR2(20) NOT NULL Credit Card Authorization DTTM
36 CR_CARD_AUTH_REPLY Character(15) VARCHAR2(15) NOT NULL Authorization Reply
37 CR_CARD_AVS_CD Character(1) VARCHAR2(1) NOT NULL Credit Card AVS Return Code
38 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
39 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
40 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits
41 SF_REVERSAL_IND Character(1) VARCHAR2(1) NOT NULL Reversal Indicator
42 POSTED_DATE Date(10) DATE Date Posted
43 POSTED_DATETIME DateTime(26) TIMESTAMP Posted Date & Time
44 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
45 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
46 SSF_ERROR_WARN Character(1) VARCHAR2(1) NOT NULL Field to hold translate values for Message Types - Error/Warning/Message
E=Error
M=Message
W=Warning
47 BUSINESS_UNIT_ERR Character(5) VARCHAR2(5) NOT NULL Business Unit
48 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
49 SF_POST_STATUS Character(1) VARCHAR2(1) NOT NULL Posting Status
E=Errors Encountered.
P=Pending
S=Successfully Posted
50 CR_CARD_TRANS_SRC Character(1) VARCHAR2(1) NOT NULL Payment Transaction Source
A=Application Center
C=Cashiering
I=Contributor Relations
M=Miscellaneous Fees
P=Payment
R=Refund
V=Payment Reversal