| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table:
SP_BU_SF_NONVW
|
| 2 |
COMMON_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Common ID to store Personal ID / Ext Org ID value
|
| 3 |
SA_ID_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
ID Type
O=Organization
P=Person
|
| 4 |
PAYMENT_ID_NBR |
Number(12,0) |
DECIMAL(12) NOT NULL |
Payment ID Nbr
|
| 5 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
|
| 6 |
PAYMENT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Method
CC=Credit Card
CHK=Check
CSH=Cash
DB=Debit Card
EC=Electronic Check
EFT=Electronic Funds Transfer
LBX=Lockbox
TPC=Third Party Check
WIR=Wire Transfer
Default Value: CSH
|
| 7 |
PAYMENT_AMT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Payment Amount
|
| 8 |
ENCUMBRANCE_DT |
Date(10) |
DATE |
Encumbrance Date
|
| 9 |
ENCUMBERED_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Amount Encumbered
|
| 10 |
CHECK_NUM_SF |
Character(30) |
VARCHAR2(30) NOT NULL |
Check Nbr
|
| 11 |
THIRD_PARTY |
Character(30) |
VARCHAR2(30) NOT NULL |
Third Party Check Name
|
| 12 |
CREDIT_CARD_NBR |
Character(44) |
VARCHAR2(44) NOT NULL |
Card Number
|
| 13 |
CREDIT_CARD_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Credit Card Type
AE=American Express
DC=Diners' Club
DI=Diners Club
MC=MasterCard
VI=VISA
|
| 14 |
CREDIT_CARD_EXP_DT |
Date(10) |
DATE |
Expiration Date
|
| 15 |
CREDIT_CARD_ISSUER |
Character(20) |
VARCHAR2(20) NOT NULL |
Credit Card Issuer
|
| 16 |
CREDIT_CARD_HOLDER |
Character(30) |
VARCHAR2(30) NOT NULL |
Credit Card Holder
|
| 17 |
FED_RSRV_BANK_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Federal Reserve Bank ID
|
| 18 |
SSF_BNK_ACCT_NUM |
Character(44) |
VARCHAR2(44) NOT NULL |
Bank Account Number
|
| 19 |
BANK_ACCT_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Bank Account Type
C=Checking
S=Savings
|
| 20 |
BANK_ACCT_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Bank Account Holder Name
|
| 21 |
SF_REVERSAL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Reversal Indicator
Y/N Table Edit
Default Value: N
|
| 22 |
REF1_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Reference Nbr
|
| 23 |
TENDER_SPEC |
Character(1) |
VARCHAR2(1) NOT NULL |
Tender Specific
Y/N Table Edit
|
| 24 |
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
|
| 25 |
ITEM_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
Item Type
Prompt Table:
ITEM_TYPE_PA_VW
|
| 26 |
TRACER_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
Tracer Number
|
| 27 |
ACCOUNTING_DT |
Date(10) |
DATE NOT NULL |
Accounting Date
|
| 28 |
POSTED_DATE |
Date(10) |
DATE NOT NULL |
Date Posted
|
| 29 |
STRM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term
|
| 30 |
SESSION_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Session
1=Regular Academic Session
10W=10 Week
12W=Twelve Week
4W1=Four Week - First
4W2=Four Week - Second
4W3=Four Week - Third
4W4=Four Week - Fourth
6W1=Six Week - First
6W2=Six Week - Second
8W1=Eight Week - First
8W2=Eight Week - Second
A11=Medical Period 1, 4 Weeks
A12=Medical Period 1, 8 Weeks
A13=Medical Pd 1, 12 Weeks
A21=Medical Period 2, 4 Weeks
A22=Medical Period 2, 8 Weeks
A23=Medical Period 2, 12 Week
FYR=Full Year
MIN=Mini Session
OEE=Open Entry/Open Exit
SM1=Semester 1
SM2=Semester 2
|
| 31 |
PAYMENT_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Category
|
| 32 |
ACAD_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Year
|
| 33 |
CHARGE_PRIORITY |
Character(8) |
VARCHAR2(8) NOT NULL |
Charge Priority List
|
| 34 |
RESTRICT_ACCT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Entered Acct Only
|
| 35 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
|
| 36 |
EXC_ACCT_TYPE_SF |
Character(3) |
VARCHAR2(3) NOT NULL |
Excess Account Type SF
|
| 37 |
CHARGE_SET_TABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Charge Set Table Flag
|
| 38 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 39 |
GRP_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Group Line Time Stamp
|
| 40 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
|
| 41 |
SRVC_IND_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Service Indicator Cd
|
| 42 |
CONTRACT_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Contract ID
|
| 43 |
PRIORITY |
Number(3,0) |
SMALLINT NOT NULL |
Priority
|
| 44 |
PRIORITY_PMT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Priority Flag
|
| 45 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 46 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 47 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 48 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 49 |
ORIGNL_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 50 |
ORIGNL_ITEM_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Item Amount
|
| 51 |
TRANSFER_DT |
Date(10) |
DATE |
Transfer Date
|
| 52 |
TRANSFER_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Transfer Status
C=Complete Transfer
N=No Transfer
P=Partial Transfer
Default Value: N
|
| 53 |
TRANSFER_PAYMNT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Transfer Payment ID
|
| 54 |
TRANSFER_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Transfer Amt
|
| 55 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
|
| 56 |
DISBURSEMENT_DATE |
Date(10) |
DATE |
Disbursement Date
|
| 57 |
SF_DEPOSIT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Deposit ID
|
| 58 |
RECEIPT_NBR |
Number(12,0) |
DECIMAL(12) NOT NULL |
Receipt Number
|
| 59 |
SF_PMT_REF_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Reference Nbr
|
| 60 |
CR_CARD_DIGITS |
Character(4) |
VARCHAR2(4) NOT NULL |
Card Number's Last Four Digits
|
| 61 |
BANK_CD |
Character(11) |
VARCHAR2(11) NOT NULL |
Bank ID
|
| 62 |
INVOICE_ID |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice Number
Prompt Table:
%EDITTABLE
|
| 63 |
SSF_RESTRICT_INV |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates that the payment will be held until an invoice is provided.
Default Value: N
|
| 64 |
SSF_PMT_AMT_SENT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Amount sent
|
| 65 |
SSF_PMT_CHG_ALLOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Charge Allocation
Y/N Table Edit
Default Value: N
|
| 66 |
SSF_INSTMNT_ID |
Number(3,0) |
SMALLINT NOT NULL |
Installment ID
|
| 67 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 68 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 69 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 70 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|