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 |