INSTALLATION_SF

(SQL Table)
Index Back

SF Installation

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BATCH_ID_LAST Number(12,0) DECIMAL(12) NOT NULL Last Batch ID
2 GROUP_ID_LAST Number(10,0) DECIMAL(10) NOT NULL Last Group ID Assigned
3 BILL_MSG_NBR_LAST Number(5,0) INTEGER NOT NULL Last Billing Msg Nbr
4 PAYMENT_ID_NBR Number(12,0) DECIMAL(12) NOT NULL Payment ID Nbr
5 RCPT_MAX_ROWS Number(3,0) SMALLINT NOT NULL Receipt Max Rows

Default Value: 50

6 TUIT_CALC_MAX_ROWS Number(3,0) SMALLINT NOT NULL Tuit Calc Max Rows

Default Value: 50

7 MSG_MAX_ROWS Number(3,0) SMALLINT NOT NULL Message Max Rows

Default Value: 50

8 LATE_FEE_MAX_ROWS Number(3,0) SMALLINT NOT NULL Late Fee Max Rows

Default Value: 50

9 APP_FEE_MAX_ROWS Number(3,0) SMALLINT NOT NULL App Fee Max Rows

Default Value: 50

10 DEP_FEE_MAX_ROWS Number(3,0) SMALLINT NOT NULL Dep Fee Max Rows

Default Value: 50

11 GRP_POST_MAX_ROWS Number(3,0) SMALLINT NOT NULL Grp Post Max Rows

Default Value: 50

12 REFUND_MAX_ROWS Number(5,0) INTEGER NOT NULL Refund Max Rows

Default Value: 50

13 LAST_INVOICE_NBR Number(18,0) DECIMAL(18) NOT NULL Last Invoice Nbr
14 LAST_BI_RQST_NBR Number(12,0) DECIMAL(12) NOT NULL Last Billing Request Nbr
15 LAST_PRT_RQST_NBR Number(9,0) DECIMAL(9) NOT NULL Last Print Request Nbr
16 EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table

Prompt Table: PSRECDEFN_VW

17 EDITTABLE2 Character(15) VARCHAR2(15) NOT NULL Secondary Edit Table

Prompt Table: PSRECDEFN_VW

18 EDITTABLE3 Character(15) VARCHAR2(15) NOT NULL Third Edit Table

Prompt Table: PSRECDEFN_VW

19 NEXT_BI_PRT_NBR Number(9,0) DECIMAL(9) NOT NULL Next Billing Print Request
20 LAST_ORIGIN_ID Number(5,0) INTEGER NOT NULL Last Origin ID
21 ITEM_TYPE_SEC_LEV Character(1) VARCHAR2(1) NOT NULL Item Type Security Level
C=Permission List Security
N=No Security
O=User ID Security

Default Value: N

22 UNIT_SECURITY_LEV Character(1) VARCHAR2(1) NOT NULL Business Unit Security Level
C=Permission List Security
N=No Security
O=User ID Security

Default Value: N

23 SETID_SECURITY_LEV Character(1) VARCHAR2(1) NOT NULL Setid Security Level
C=Permission List Security
N=No Security
O=User ID Security

Default Value: N

24 COMPANY_SEC_LEV Character(1) VARCHAR2(1) NOT NULL Company Security Level
C=Permission List Security
N=No Security
O=User ID Security

Default Value: N

25 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

Default Value: N

26 ISET_SECURITY_LEV Character(1) VARCHAR2(1) NOT NULL Institution Set Security Level
C=Permission List Security
N=No Security
O=User ID Security

Default Value: N

27 ORIGIN_SEC_LEV Character(1) VARCHAR2(1) NOT NULL Origin Security Level
C=Permission List Security
N=No Security
O=User ID Security

Default Value: N

28 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

Prompt Table: TREE_NAME_VW

29 SECURITY_RUN Character(1) VARCHAR2(1) NOT NULL Security Run

Default Value: N

30 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

31 PROCESS_GROUP Character(10) VARCHAR2(10) NOT NULL Process Group
32 COMBO_EDIT_FLG Character(1) VARCHAR2(1) NOT NULL Edit Combinations

Y/N Table Edit

Default Value: N

33 COMMIT_LVL_APP_FEE Number(3,0) SMALLINT NOT NULL App Fee Commit Level
34 COMMIT_LVL_DEP_FEE Number(3,0) SMALLINT NOT NULL Dep Fee Commit Level
35 APPFEE_LVL_COMMIT Character(1) VARCHAR2(1) NOT NULL App Fee Commit Level
E=Commit At The End
I=Commit After Each Item
L=Use Commit Level

Default Value: I

36 DEPFEE_LVL_COMMIT Character(1) VARCHAR2(1) NOT NULL Dep Fee Commit Level
E=Commit At the End
I=Commit After Each Item
L=Use Commit Level

Default Value: I

37 PUB_SEC_FIN_REL Character(3) VARCHAR2(3) NOT NULL E&G Financials Release
7.5=Release 7.5
8.4=Release 8.4 or 8.8
38 SEC_CHRG_REV Character(1) VARCHAR2(1) NOT NULL Charge Reversals

Y/N Table Edit

Default Value: N

39 SEC_PAY_REV Character(1) VARCHAR2(1) NOT NULL Payment Reversals

Y/N Table Edit

Default Value: N

40 SEC_WROF_REV Character(1) VARCHAR2(1) NOT NULL Writeoff Reversals

Y/N Table Edit

Default Value: N

41 NULL_DUE_DATE Date(10) DATE Null Due Date
42 BI_CANC_NBR Number(10,0) DECIMAL(10) NOT NULL Billing Cancellation Number
43 ITEM_TYPE_ADD_SEC Character(1) VARCHAR2(1) NOT NULL Add Mode Security

Y/N Table Edit

Default Value: N

44 COMMIT_LVL_LAT_FEE Number(3,0) SMALLINT NOT NULL Late Fee Commit Level
45 LATFEE_LVL_COMMIT Character(1) VARCHAR2(1) NOT NULL Late Fee Commit Level
E=Commit At The End
I=Commit After Each Item
L=Use Commit Level

Default Value: I

46 BATCH_ID_LAST_PP Character(12) VARCHAR2(12) NOT NULL Batch ID
47 LAST_RECEIPT_NO Number(12,0) DECIMAL(12) NOT NULL Last Receipt Number
48 SF_PMT_REF_NBR_LST Number(15,0) DECIMAL(15) NOT NULL Last Reference Nbr
49 BATCH_ID_LAST_CC Number(12,0) DECIMAL(12) NOT NULL Last Batch ID for CC
50 SSF_COMMT_LVL_1098 Number(3,0) SMALLINT NOT NULL 1098 Data Commit Level
51 SSF_1098_LVL_COMMT Character(1) VARCHAR2(1) NOT NULL 1098 Data Commit Level
E=Commit At The End
I=Commit After Each Item
L=Use Commit Level

Default Value: I

52 SSF_CF_EDIT_RT Character(1) VARCHAR2(1) NOT NULL Real-Time Validation Edit

Y/N Table Edit

53 SSF_CF_EDIT_LED Character(1) VARCHAR2(1) NOT NULL Ledger Table Edit

Y/N Table Edit

54 SSF_CF_EDIT_JSETS Character(1) VARCHAR2(1) NOT NULL Journal Set Edit

Y/N Table Edit

55 SSF_CF_EDIT_REQFLD Character(1) VARCHAR2(1) NOT NULL Required Fields Edit

Y/N Table Edit

56 SSF_SHOW_EXTCF Character(1) VARCHAR2(1) NOT NULL Display External Chartfield

Y/N Table Edit

Default Value: N

57 SSF_LAST_AGR_NUM Number(12,0) DECIMAL(12) NOT NULL Last Agreement Number
58 SSF_EURO_INVOICING Character(1) VARCHAR2(1) NOT NULL Apply Payments by Invoice

Y/N Table Edit

Default Value: N

59 CRYPT_PRFL_DECRYPT Character(30) VARCHAR2(30) NOT NULL Decryption Profile ID

Prompt Table: PSCRYPTPRFL

60 CRYPT_PRFL_ID Character(30) VARCHAR2(30) NOT NULL Encryption Profile ID

Prompt Table: PSCRYPTPRFL

61 SSF_PRECONV_INV_ID Character(22) VARCHAR2(22) NOT NULL Pre-conversion Invoice ID
62 SSF_CF_DELIMITER Character(3) VARCHAR2(3) NOT NULL Abbreviated Display Delimiter
63 SSF_USE_PMT_PROFL Character(1) VARCHAR2(1) NOT NULL Self Service Payment Profile

Y/N Table Edit

Default Value: Y

64 SSF_FIN_SYSTEM Character(4) VARCHAR2(4) NOT NULL Financial System
ORCL=Oracle Financials
OTHR=Others
PSEF=Enterprise Financials

Default Value: PSEF

65 SSF_VCHR_BLD_VER Character(2) VARCHAR2(2) NOT NULL Version identifier for AP Refunding option.
V1=Use Voucher / Vendor Sync
V2=Use Single Payment Voucher

Default Value: V1

66 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: INSTALLATION_SA.INSTITUTION

Prompt Table: INSTITUTION_TBL

67 SSF_BANK_EVT_ID Character(10) VARCHAR2(10) NOT NULL Default 3Cs Event ID for Bank Notifications

Prompt Table: SSF_EVT3C_VW

68 SSF_DIRDEP_EVT_ID Character(10) VARCHAR2(10) NOT NULL Default 3Cs Event ID for Direct Deposit Notifications

Prompt Table: SSF_EVT3C_VW

69 SSF_GL_TRANS_LAST Number(12,0) DECIMAL(12) NOT NULL Last GL Transaction ID
70 SSF_RESTRICT_PMT Character(1) VARCHAR2(1) NOT NULL Enforce Payment Restriction

Y/N Table Edit

Default Value: N

71 SSF_TUIT_INSTMNT Character(1) VARCHAR2(1) NOT NULL Create Tuition Installments

Y/N Table Edit

Default Value: N

72 SSF_ENABLE_BILLADJ Character(1) VARCHAR2(1) NOT NULL Enable Billed Adjustments

Y/N Table Edit

Default Value: N

73 SSF_ENABLE_FLUID Character(1) VARCHAR2(1) NOT NULL Fluid Self Service

Y/N Table Edit

Default Value: N

74 SSF_SUBMIT_REF_ID Number(8,0) INTEGER NOT NULL CRA - T2202 - Submission Reference ID

Default Value: 0