INSTITUTION_SET

#	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
28	SF_MERCHANT_ID_EC	Character(12)	VARCHAR2(12) NOT NULL	Electronic Check Merchant ID
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	Electronic Check Merchant ID
51	SSF_MERCHANT_ID_CC	Character(12)	VARCHAR2(12) NOT NULL	Credit Card Merchant ID
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