| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION_SET |
Character(5) |
VARCHAR2(5) NOT NULL |
Institution Set
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
SF_ENABLE_WEB_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Accept Self-Service Payments
Y/N Table Edit
Default Value: Y
|
| 4 |
CR_CARD_TRANS_ERR |
Number(3,0) |
SMALLINT NOT NULL |
Batch Transmission Error
|
| 5 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Type
Prompt Table:
ADDRESS_TYP_TBL
|
| 6 |
UPDATE_ADDRESS_SF |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Address Data
Y/N Table Edit
Default Value: N
|
| 7 |
AA_DETAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Anticipated Aid Detail
Y/N Table Edit
Default Value: Y
|
| 8 |
DISPLAY_AA_TOTAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Anticipated Aid Total
Y/N Table Edit
Default Value: Y
|
| 9 |
INCLUDE_AA_TOTAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Anticipated Aid Total
Y/N Table Edit
Default Value: N
|
| 10 |
SF_PAY_BALANCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Require Full Balance Payment
Y/N Table Edit
Default Value: N
|
| 11 |
SF_POST_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Unprocessed Authorization
Y/N Table Edit
Default Value: N
|
| 12 |
SF_POST_AUTH_OFFLN |
Character(1) |
VARCHAR2(1) NOT NULL |
Payments Authorized Offline
Y/N Table Edit
Default Value: N
|
| 13 |
CR_CARD_PROD_CD |
Character(20) |
VARCHAR2(20) NOT NULL |
Credit Card Product Code
|
| 14 |
CR_CARD_PROD_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Credit Card Product Name
|
| 15 |
CR_CARD_SKU |
Character(15) |
VARCHAR2(15) NOT NULL |
Credit Card Product SKU
|
| 16 |
SF_GET_BILL_ADDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Get Billing Address
Y/N Table Edit
Default Value: Y
|
| 17 |
SF_GET_BILL_PHONE |
Character(1) |
VARCHAR2(1) NOT NULL |
Get Telephone
Y/N Table Edit
Default Value: Y
|
| 18 |
SF_GET_EMAIL_ADDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Get Email Address
Y/N Table Edit
Default Value: Y
|
| 19 |
EMAILID |
Character(70) |
VARCHAR2(70) NOT NULL |
A user's E-mail address
|
| 20 |
BUSINESS_UNIT_SF |
Character(5) |
VARCHAR2(5) NOT NULL |
Stdnt Fin Business Unit
|
| 21 |
ITEM_TYPE_CR_CARD |
Character(12) |
VARCHAR2(12) NOT NULL |
Convenience Fee Item Type
|
| 22 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Base Currency
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 23 |
CR_CARD_DAY_LIMIT |
Number(3,0) |
SMALLINT NOT NULL |
Daily Limit
|
| 24 |
CR_CARD_DAILY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enforce Daily Limit
Y/N Table Edit
Default Value: N
|
| 25 |
SF_REVERSE_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Reverse Declined Authorization
Y/N Table Edit
Default Value: Y
|
| 26 |
CR_CARD_RT_OVRRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Realtime Transaction Override
Y/N Table Edit
Default Value: N
|
| 27 |
SF_MERCHANT_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
SF Merchant ID
Prompt Table:
MERCHANT_TBL_CR
|
| 28 |
SF_MERCHANT_ID_EC |
Character(12) |
VARCHAR2(12) NOT NULL |
SF eCheck Merchant ID
Prompt Table:
MERCHANT_TBL_EC
|
| 29 |
INCL_FA_IN_PAYMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Fin Aid in Payments
Y/N Table Edit
Default Value: N
|
| 30 |
INCL_PENDING_PMTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Pending Payments
Y/N Table Edit
Default Value: N
|
| 31 |
TUIT_CALC_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Tuition Calc Required
Y/N Table Edit
Default Value: N
|
| 32 |
SF_PAYMENT_ALLOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Payment Allocation
Y/N Table Edit
Default Value: Y
|
| 33 |
SF_ACCEPT_ADM_DEP |
Character(1) |
VARCHAR2(1) NOT NULL |
Accept Admissions Deposit
Y/N Table Edit
Default Value: Y
|
| 34 |
SF_ALLOW_EXCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Excess Payment
Y/N Table Edit
Default Value: Y
|
| 35 |
SF_CR_CARD_SEC |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Card Security Statement
Y/N Table Edit
Default Value: Y
|
| 36 |
SSF_SS_PAY_DRILLDN |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow payment drilldown
Default Value: N
|
| 37 |
SSF_BY_TERM |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocate by Term
Y/N Table Edit
Default Value: N
|
| 38 |
SSF_SS_DISP_ACTVTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Account Activity
Default Value: Y
|
| 39 |
SSF_SS_DISP_CHRGS |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Charges Due
Default Value: N
|
| 40 |
SSF_SS_DISP_PENDFA |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Pending Financial Aid
Default Value: N
|
| 41 |
SSF_SS_INC_PENDFA |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Pending Financial Aid
Y/N Table Edit
Default Value: N
|
| 42 |
SSF_SS_DISP_PMTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Payment History
Default Value: N
|
| 43 |
SSF_SS_DISP_PENDPY |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Pending Payments
Y/N Table Edit
Default Value: N
|
| 44 |
SSF_DUE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days in future for 'due now'
Default Value: 0
|
| 45 |
SSF_SS_DUE_DT_DTL |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Due Date Detail
Default Value: N
|
| 46 |
SSF_SS_CHRG_DTL |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Charge Detail
Default Value: N
|
| 47 |
SSF_DISP_PP_MAP |
Character(1) |
VARCHAR2(1) NOT NULL |
This field controls the display of Pending Payments for the Make a Payment component.
Y/N Table Edit
Default Value: N
|
| 48 |
SSF_INCL_PP_MAP |
Character(1) |
VARCHAR2(1) NOT NULL |
This field controls the display of Pending Payments for the Make a Payment component.
Y/N Table Edit
Default Value: N
|
| 49 |
SSF_SS_PMT_PLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag that indicates whether students can enroll in payment plans through self-service
Y/N Table Edit
Default Value: N
|
| 50 |
SSF_MERCHANT_ID_EC |
Character(12) |
VARCHAR2(12) NOT NULL |
SF eCheck Merchant ID
Prompt Table:
MERCHANT_TBL_EC
|
| 51 |
SSF_MERCHANT_ID_CC |
Character(12) |
VARCHAR2(12) NOT NULL |
SF Credit Card Merchant ID
Prompt Table:
MERCHANT_TBL_CR
|
| 52 |
SSF_ENABLE_MISCFEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Accept Miscellaneous Purchases
Y/N Table Edit
Default Value: N
|
| 53 |
SSF_SS_DISP_1098 |
Character(1) |
VARCHAR2(1) NOT NULL |
Display 1098-T Self Service Flag
Default Value: N
|
| 54 |
SSF_SS_INV_DUE |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Invoice Due
Y/N Table Edit
|
| 55 |
SSF_SS_STDNT_PERM |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Student Permissions
Y/N Table Edit
Default Value: N
|
| 56 |
SSF_SS_PERM_GRANT |
Character(1) |
VARCHAR2(1) NOT NULL |
Grant Student Permissions
Y/N Table Edit
Default Value: N
|
| 57 |
SSF_DISP_TCALC_MSG |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Tuition Calc Message
Y/N Table Edit
Default Value: N
|
| 58 |
SSF_DISP_PRIV_POL |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Privacy Policy
Y/N Table Edit
Default Value: N
|
| 59 |
SSF_DISP_BRWSR_MSG |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Browser Message
Y/N Table Edit
Default Value: N
|
| 60 |
SSF_DISP_DECL_DTL |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Declined Pymt Detail
Y/N Table Edit
Default Value: N
|
| 61 |
SSF_PRIVACY_POLICY |
Long Character |
CLOB |
Privacy Policy
|
| 62 |
SSF_SS_DISP_MYBANK |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Manage Banks Self Service Flag
Y/N Table Edit
Default Value: N
|
| 63 |
SSF_SS_DISP_DDENRL |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Direct Deposit Self Service Flag
Y/N Table Edit
Default Value: N
|
| 64 |
SSF_BANK_DTLS_URL |
Character(30) |
VARCHAR2(30) NOT NULL |
URL identifier used by Manage Banks to provide additional details.
Prompt Table:
PSURLDEFN
|
| 65 |
SSF_BANK_HELP_URL |
Character(30) |
VARCHAR2(30) NOT NULL |
URL identifier used by Manage Banks to provide help details.
Prompt Table:
PSURLDEFN
|
| 66 |
SSF_SS_DISP_BNKAGR |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Bank Agreement
Y/N Table Edit
Default Value: N
|
| 67 |
SSF_DD_DTLS_URL |
Character(30) |
VARCHAR2(30) NOT NULL |
URL identifier used by Direct Deposit to provide additional details.
Prompt Table:
PSURLDEFN
|
| 68 |
SSF_DD_HELP_URL |
Character(30) |
VARCHAR2(30) NOT NULL |
URL identifier used by Direct Deposit to provide help details.
Prompt Table:
PSURLDEFN
|
| 69 |
SSF_SS_DISP_DDCOMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Subsequent Direct Deposit Agreement
Y/N Table Edit
Default Value: N
|
| 70 |
SSF_DIRDEP_NUMBNK |
Number(3,0) |
SMALLINT NOT NULL |
Maximum number of direct deposit distributions allowed.
Default Value: 1
|
| 71 |
SSF_ALLOW_CNTRY_CH |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Change in Country
Y/N Table Edit
Default Value: N
|
| 72 |
SSF_LIMIT_PMTS |
Number(3,0) |
SMALLINT NOT NULL |
Maximum Payments in Service
|
| 73 |
SSF_ALLOW_SERVICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Use in Service
Y/N Table Edit
Default Value: N
|
| 74 |
SSF_DISP_DDENRL_FL |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Direct Deposit Self Service Flag
Y/N Table Edit
Default Value: N
|
| 75 |
SSF_ALLOW_CNTRY_FL |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Change in Country
Y/N Table Edit
Default Value: N
|
| 76 |
SSF_ALLOWREVOKE_FL |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Revocation
Y/N Table Edit
Default Value: N
|