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 |