SSF_SS_SUMPEND2(SQL View) |
Index Back |
|---|
| SELECT SF_PMT_REF_NBR , COMMON_ID , INSTITUTION_SET , LAST_DTTM_UPDATE ,%CurrentDateIn , PAYMENT_AMT , CR_CARD_DIGITS , TENDER_CATEGORY FROM PS_SF_PAYMENT A WHERE A.SA_ID_TYPE = 'P' AND A.SEQNUM = ( SELECT MAX(C.SEQNUM) FROM PS_SF_PAYMENT C WHERE A.SF_PMT_REF_NBR = C.SF_PMT_REF_NBR AND A.SEQNUM = C.SEQNUM) AND ((A.SF_PAYMENT_STATUS = 'S' OR A.SF_PAYMENT_STATUS = 'A' OR A.SF_PAYMENT_STATUS = 'B') AND A.SF_POST_STATUS <> 'S') AND A.CR_CARD_TRANS_SRC = 'P' AND A.PAYMENT_AMT > 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SF_PMT_REF_NBR | Character(12) | VARCHAR2(12) NOT NULL | Reference Nbr |
| 2 | COMMON_ID | Character(11) | VARCHAR2(11) NOT NULL | Common ID to store Personal ID / Ext Org ID value |
| 3 | INSTITUTION_SET | Character(5) | VARCHAR2(5) NOT NULL | Institution Set |
| 4 | 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. |
| 5 | SSF_POSTED_DATE | Date(10) | DATE | Date Posted |
| 6 | PAYMENT_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Payment Amount |
| 7 | CR_CARD_DIGITS | Character(4) | VARCHAR2(4) NOT NULL | Card Number's Last Four Digits |
| 8 | TENDER_CATEGORY | Character(3) | VARCHAR2(3) NOT NULL |
Tender Category
CC=Credit Card CCI=Credit Card In CCO=Credit Card Out CK=Check CKI=Check In CKO=Check Out CS=Cash CSI=Cash In CSO=Cash Out DB=Debit Card DBI=Debit Card In DBO=Debit Card Out DD=Direct Deposit DDI=Direct Debit DDO=Direct Deposit EC=Electronic Check TP=Third Party Check TPI=Third Party Check In WIR=Wire Transfer |