| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
SF_MERCHANT_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
SF Merchant ID
|
| 5 |
CR_CARD_AUTH_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Authorize and Settle
Y/N Table Edit
Default Value: Y
|
| 6 |
CR_CARD_BILL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Settle
Y/N Table Edit
Default Value: Y
|
| 7 |
CR_CARD_CREDIT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit
Y/N Table Edit
Default Value: Y
|
| 8 |
CR_CARD_MERCHANT |
Character(16) |
VARCHAR2(16) NOT NULL |
Credit Card Merchant ID
|
| 9 |
CR_CARD_IP |
Character(15) |
VARCHAR2(15) NOT NULL |
Credit Card IP Override
|
| 10 |
CR_CARD_SERVER |
Character(28) |
VARCHAR2(28) NOT NULL |
Credit Card Processing Server
|
| 11 |
CR_CARD_RISK |
Character(1) |
VARCHAR2(1) NOT NULL |
Perform Check Risk Service
Y/N Table Edit
Default Value: N
|
| 12 |
CR_CARD_AVS |
Character(1) |
VARCHAR2(1) NOT NULL |
Address Verification Flag
N=Address Verification Off
Y=Address Verification On
Default Value: N
|
| 13 |
CR_CARD_TRAN_RETRY |
Number(3,0) |
SMALLINT NOT NULL |
Transaction Transmission Retry
|
| 14 |
SF_PMT_REF_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Reference Nbr
Default Value: 0
|
| 15 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 16 |
SEQUENCE_NBR_3 |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Nbr
|
| 17 |
COMMON_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Common ID to store Personal ID / Ext Org ID value
|
| 18 |
SA_ID_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
ID Type
O=Organization
P=Person
|
| 19 |
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
|
| 20 |
SF_POST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Posting Status
E=Errors Encountered.
P=Pending
S=Successfully Posted
Default Value: P
|
| 21 |
INSTITUTION_SET |
Character(5) |
VARCHAR2(5) NOT NULL |
Institution Set
Prompt Table:
INSTITUTION_SET
|
| 22 |
PAYMENT_AMT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Payment Amount
|
| 23 |
STRM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term
Prompt Table:
TERM_VAL_TBL
|
| 24 |
DUE_DT |
Date(10) |
DATE |
Expected Birth Date
|
| 25 |
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
|
| 26 |
CR_CARD_EXPYR |
Character(4) |
VARCHAR2(4) NOT NULL |
Card Expiration Year
|
| 27 |
CR_CARD_FNAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Credit Card First Name
|
| 28 |
CR_CARD_LNAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Credit Card Last Name
|
| 29 |
CR_CARD_NBR |
Character(44) |
VARCHAR2(44) NOT NULL |
Credit Card Number
|
| 30 |
CR_CARD_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Credit Card Type
Prompt Table:
CR_CARD_TYPE_VW
|
| 31 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
SCC_CNT_ADFMTVW
|
| 32 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 33 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 34 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 35 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 36 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 37 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 38 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 39 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference
WW=House Trailer Reference
|
| 40 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 41 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 42 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 43 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 44 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 45 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 46 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 47 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 48 |
EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
Email Address
|
| 49 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 50 |
CR_CARD_AUTH_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Credit Card Authorization Code
|
| 51 |
CR_CARD_AUTH_DT |
Date(10) |
DATE |
Auth Date
|
| 52 |
CR_CARD_RQST_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Credit Card Request ID
|
| 53 |
CR_CARD_A_DTTM |
Character(20) |
VARCHAR2(20) NOT NULL |
Credit Card Authorization DTTM
|
| 54 |
CR_CARD_AUTH_REPLY |
Character(15) |
VARCHAR2(15) NOT NULL |
Authorization Reply
|
| 55 |
CR_CARD_TRANS_LAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Transaction Requested
1=Authorize
2=Authorize and Capture
3=Capture
4=Credit
5=eCheck Debit
6=eCheck Credit
91=Request Token
92=Authorize and Capture
93=Hosted Payment Credit
|
| 56 |
CR_CARD_ERRMSG |
Character(30) |
VARCHAR2(30) NOT NULL |
Credit Card Error Message
|
| 57 |
CR_CARD_AVS_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Card AVS Return Code
|
| 58 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 59 |
SF_PAYMENT_SPLIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Allocated
Y/N Table Edit
Default Value: N
|
| 60 |
CR_CARD_DIGITS |
Character(4) |
VARCHAR2(4) NOT NULL |
Card Number's Last Four Digits
|
| 61 |
SF_REVERSAL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Reversal Indicator
|
| 62 |
POSTED_DATE |
Date(10) |
DATE |
Date Posted
|
| 63 |
POSTED_DATETIME |
DateTime(26) |
TIMESTAMP |
Posted Date & Time
|
| 64 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 65 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 66 |
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
|
| 67 |
BUSINESS_UNIT_ERR |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 68 |
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.
|
| 69 |
BATCH_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Batch ID
|
| 70 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 71 |
REFUND_NBR |
Number(12,0) |
DECIMAL(12) NOT NULL |
Refund Nbr
|
| 72 |
LINE_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Line Sequence Nbr
|
| 73 |
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
|
| 74 |
REVERSAL_STAT_SF |
Character(1) |
VARCHAR2(1) NOT NULL |
Reversal Status
E=Errors were encountered
S=Successful
|
| 75 |
CASHIER_OFFICE |
Character(8) |
VARCHAR2(8) NOT NULL |
Cashier's Office
|
| 76 |
SF_REGISTER |
Character(5) |
VARCHAR2(5) NOT NULL |
Cash Register
|
| 77 |
RECEIPT_NBR |
Number(12,0) |
DECIMAL(12) NOT NULL |
Receipt Number
|
| 78 |
RECEIPT_LINE_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Receipt Line Number
|
| 79 |
ADM_APPL_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Application Nbr
|
| 80 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
|
| 81 |
ADM_APPL_CTR |
Character(4) |
VARCHAR2(4) NOT NULL |
Application Center
|
| 82 |
CR_CARD_SRVC_PROV |
Character(2) |
VARCHAR2(2) NOT NULL |
Credit Card Service Provider
01=Cybersource
02=TouchNet
99=Unsupported
|
| 83 |
SF_BI_RET_STATUS |
Character(10) |
VARCHAR2(10) NOT NULL |
Return Status
|
| 84 |
CR_CARD_TRAN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Card Transaction Source
A=All
C=Cashiering
D=Admissions
S=Self Service
|
| 85 |
CR_CARD_ERR_CTR |
Number(3,0) |
SMALLINT NOT NULL |
Credit Card Transmission Error
|
| 86 |
CR_CARD_TRANS_ERR |
Number(3,0) |
SMALLINT NOT NULL |
Batch Transmission Error
|
| 87 |
SF_TOTAL_SETTLED |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Total Amount Settled
|
| 88 |
SF_TOTAL_CREDIT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Total Amount Creditted
|
| 89 |
CRED_CARD_SEC_LEV |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Card Security Level
C=Permission List Security
N=No Security
O=User ID Security
|
| 90 |
CR_CARD_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Credit Card Processing Status
AC=Authorized Credit
AS=Authorized
AV=Authorized Void
CR=Credit/Return
ST=Settled
SV=Settled Void/Credit
UN=Pending Authorization
VD=Void Sale
VU=Void Unprocessed
|
| 91 |
TRACE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Report
|
| 92 |
REFUND_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Refund Status
A=AP Interface Created
B=Credit Pending
C=Confirmed
D=Credit Declined
E=Entered
I=Interfaced to Payroll
P=Posted
R=Reversed
S=Paysheet Created
V=Sent to ePayment Servicer
X=Cancelled
|
| 93 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 94 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 95 |
CR_CARD_COUNT_01 |
Number(5,0) |
INTEGER NOT NULL |
Authorize
|
| 96 |
CR_CARD_COUNT_02 |
Number(5,0) |
INTEGER NOT NULL |
Settle
|
| 97 |
CR_CARD_COUNT_03 |
Number(5,0) |
INTEGER NOT NULL |
Credit
|
| 98 |
CR_CARD_COUNT_04 |
Number(5,0) |
INTEGER NOT NULL |
Authorize Only
|
| 99 |
CR_CARD_COUNT_05 |
Number(5,0) |
INTEGER NOT NULL |
Settle Only
|
| 100 |
COUNTRY_2CHAR |
Character(2) |
VARCHAR2(2) NOT NULL |
2-Char Country Code
|
| 101 |
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
|
| 102 |
BANK_ACCT_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Bank Account Type
C=Checking
S=Savings
|
| 103 |
BANK_CD |
Character(11) |
VARCHAR2(11) NOT NULL |
Bank ID
|
| 104 |
SSF_BNK_ACCT_NUM |
Character(44) |
VARCHAR2(44) NOT NULL |
Bank Account Number
|
| 105 |
EC_CREDIT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit
|
| 106 |
EC_DEBIT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Debit
|
| 107 |
SF_MERCHANT_PROC |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Option
C=Credit Card
E=Electronic Check
|
| 108 |
CR_CARD_RISK_THRES |
Number(3,0) |
SMALLINT NOT NULL |
Check Risk Threshold
|
| 109 |
EC_VERIFICATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Verification Level
1=Validation
2=Verification
|
| 110 |
EC_SETTLE_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Settlement Method
A=Automated Clearing House
B=Best possible
F=Facsimile draft
|
| 111 |
TRANS_REF_NO |
Character(60) |
VARCHAR2(60) NOT NULL |
Transaction Reference Nbr
|
| 112 |
AGREEMENT_TEXT |
Long Character |
CLOB |
Agreement Text
|
| 113 |
AGREEMENT_DT |
Date(10) |
DATE |
Agreement Date
|
| 114 |
SSF_AGREEMENT_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Agreement Number
|
| 115 |
SCC_MERCHANT_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
Payment Merchant ID
|
| 116 |
CR_CARD_DECLND |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Card Declined
|